Class PostgreSqlOperations

Database operations for PostgreSQL

Inheritance
object
DatabaseOperations
PostgreSqlOperations
Implements
Inherited Members
Namespace: SuperOffice.Data.Dialect
Assembly: SoDataBase.BusinessLogic.dll
Syntax
public class PostgreSqlOperations : DatabaseOperations, IDatabaseOperations

Methods

GetDatabaseSize()

Get the total database size (including any unallocated space inside the db, etc) in megabytes

Declaration
public override int GetDatabaseSize()
Returns
Type Description
int
Overrides

GetDatabaseVersion()

Database operations for PostgreSQL

Declaration
public override string GetDatabaseVersion()
Returns
Type Description
string
Overrides

GetIdentityFromAutoIncrement(SoTable)

Obtain the ID of a new record by inserting a dummy record into the database (or a set of records if count > 1; the ID of the first one is returned)

Declaration
public override int GetIdentityFromAutoIncrement(SoTable soTable)
Parameters
Type Name Description
SoTable soTable
Returns
Type Description
int
Overrides

GetKilobytes(SoTable)

Database operations for PostgreSQL

Declaration
public override int GetKilobytes(SoTable table)
Parameters
Type Name Description
SoTable table
Returns
Type Description
int
Overrides

GetRowCountAsync(SoTable, CancellationToken)

Get count of rows in the table (as quickly as possible). Not guaranteed to return exact results.

Declaration
public override Task<int> GetRowCountAsync(SoTable table, CancellationToken cancellationToken = default)
Parameters
Type Name Description
SoTable table

Table we want counts for
CancellationToken cancellationToken
Returns
Type Description
Task<int>

Approximate row count.
Overrides

InnerTruncateTableAsync(SoTable, TruncateOptions)

Database operations for PostgreSQL

Declaration
public override Task InnerTruncateTableAsync(SoTable table, TruncateOptions options = TruncateOptions.DeallocateStorage)
Parameters
Type Name Description
SoTable table
TruncateOptions options
Returns
Type Description
Task
Overrides

WriteBulkRowsAsync(BulkImportInfo, CancellationToken)

Actual bulk insert implementation

Declaration
protected override Task WriteBulkRowsAsync(DatabaseOperations.BulkImportInfo importInfo, CancellationToken cancellationToken)
Parameters
Type Name Description
DatabaseOperations.BulkImportInfo importInfo
CancellationToken cancellationToken
Returns
Type Description
Task
Overrides

Implements

Extension Methods