PgDialect

class PgDialect {

private buildSelection;

buildDeleteQuery({ table, where, returning }: PgDeleteConfig): SQL;

buildInsertQuery({ table, values, onConflict, returning }: PgInsertConfig): SQL;

buildRefreshMaterializedViewQuery({ view, concurrently, withNoData }: {

view: PgMaterializedView;

concurrently?: boolean;

withNoData?: boolean;

}): SQL;

buildSelectQuery({ withList, fieldsList, where, having, table, joins, orderBy, groupBy, limit, offset, lockingClauses }: PgSelectConfig): SQL;

buildUpdateQuery({ table, set, where, returning }: PgUpdateConfig): SQL;

buildUpdateSet(table: AnyPgTable, set: UpdateSet): SQL;

escapeName(name: string): string;

escapeParam(num: number): string;

escapeString(str: string): string;

migrate(migrations: MigrationMeta[], session: PgSession): Promise<void>;

prepareTyping(encoder: DriverValueEncoder<unknown, unknown>): QueryTypingsValue;

sqlToQuery(sql: SQL): Query;

}

§Properties

buildSelection

[src]

Builds selection SQL with provided fields/expressions

Examples:

select <selection> from

insert ... returning <selection>

If isSingleTable is true, then columns won't be prefixed with table name

§Methods

buildDeleteQuery({ table, where, returning }: PgDeleteConfig): SQL

[src]

buildInsertQuery({ table, values, onConflict, returning }: PgInsertConfig): SQL

[src]

buildRefreshMaterializedViewQuery({ view, concurrently, withNoData }: {

view: PgMaterializedView;

concurrently?: boolean;

withNoData?: boolean;

}): SQL

[src]

buildSelectQuery({ withList, fieldsList, where, having, table, joins, orderBy, groupBy, limit, offset, lockingClauses }: PgSelectConfig): SQL

[src]

buildUpdateQuery({ table, set, where, returning }: PgUpdateConfig): SQL

[src]

buildUpdateSet(table: AnyPgTable, set: UpdateSet): SQL

[src]

escapeName(name: string): string

[src]

escapeParam(num: number): string

[src]

escapeString(str: string): string

[src]

migrate(migrations: MigrationMeta[], session: PgSession): Promise<void>

[src]

prepareTyping(encoder: DriverValueEncoder<unknown, unknown>): QueryTypingsValue

[src]

sqlToQuery(sql: SQL): Query

[src]