abstractSchemaHelper

Hierarchy

• SchemaHelper
  • SqliteSchemaHelper
  • BetterSqliteSchemaHelper
  • MariaDbSchemaHelper
  • MySqlSchemaHelper
  • PostgreSqlSchemaHelper

Index

Constructors

• constructor

Methods

• configureColumn
• configureColumnDefault
• createTableColumn
• databaseExists
• disableForeignKeysSQL
• enableForeignKeysSQL
• finalizeTable
• getAlterColumnAutoincrement
• getChangeColumnCommentSQL
• getChecks
• getColumns
• getCreateDatabaseSQL
• getCreateIndexSQL
• getDatabaseExistsSQL
• getDatabaseNotExistsError
• getDefaultEmptyString
• getDropDatabaseSQL
• getDropIndexSQL
• getEnumDefinitions
• getForeignKeys
• getForeignKeysSQL
• getIndexes
• getListTablesSQL
• getManagementDbName
• getNamespaces
• getPreAlterTable
• getPrimaryKeys
• getRenameColumnSQL
• getRenameIndexSQL
• getSchemaBeginning
• getSchemaEnd
• hasNonDefaultPrimaryKeyName
• loadInformationSchema
• mapForeignKeys
• normalizeDefaultValue
• pushTableQuery
• supportsSchemaConstraints

Constructors

constructor

• new SchemaHelper(platform): SchemaHelper

• Parameters

  • platform: AbstractSqlPlatform

  Returns SchemaHelper

Methods

configureColumn

• configureColumn(column, col, knex, changedProperties): ColumnBuilder

• Parameters

  • column: Column

  • col: ColumnBuilder

  • knex: Knex<any, any[]>

  • optionalchangedProperties: Set<string>

  Returns ColumnBuilder

configureColumnDefault

• configureColumnDefault(column, col, knex, changedProperties): ColumnBuilder

• Parameters

  • column: Column

  • col: ColumnBuilder

  • knex: Knex<any, any[]>

  • optionalchangedProperties: Set<string>

  Returns ColumnBuilder

createTableColumn

• createTableColumn(table, column, fromTable, changedProperties): ColumnBuilder

• Parameters

  • table: TableBuilder

  • column: Column

  • fromTable: DatabaseTable

  • optionalchangedProperties: Set<string>

  Returns ColumnBuilder

databaseExists

• databaseExists(connection, name): Promise<boolean>

• Parameters

  • connection: Connection

  • name: string

  Returns Promise<boolean>

disableForeignKeysSQL

• disableForeignKeysSQL(): string

• Returns string

enableForeignKeysSQL

• enableForeignKeysSQL(): string

• Returns string

finalizeTable

• finalizeTable(table, charset, collate): void

• Parameters

  • table: TableBuilder

  • charset: string

  • optionalcollate: string

  Returns void

getAlterColumnAutoincrement

• getAlterColumnAutoincrement(tableName, column, schemaName): string

• Parameters

  • tableName: string

  • column: Column

  • optionalschemaName: string

  Returns string

getChangeColumnCommentSQL

• getChangeColumnCommentSQL(tableName, to, schemaName): string

• Parameters

  • tableName: string

  • to: Column

  • optionalschemaName: string

  Returns string

getChecks

• getChecks(connection, tableName, schemaName, columns): Promise<Check<unknown>[]>

• Parameters

  • connection: AbstractSqlConnection

  • tableName: string

  • optionalschemaName: string

  • optionalcolumns: Column[]

  Returns Promise<Check<unknown>[]>

getColumns

• getColumns(connection, tableName, schemaName): Promise<Column[]>

• Parameters

  • connection: AbstractSqlConnection

  • tableName: string

  • optionalschemaName: string

  Returns Promise<Column[]>

getCreateDatabaseSQL

• getCreateDatabaseSQL(name): string

• Parameters

  • name: string

  Returns string

getCreateIndexSQL

• getCreateIndexSQL(tableName, index): string

• Parameters

  • tableName: string

  • index: Index

  Returns string

getDatabaseExistsSQL

• getDatabaseExistsSQL(name): string

• Parameters

  • name: string

  Returns string

getDatabaseNotExistsError

• getDatabaseNotExistsError(dbName): string

• Parameters

  • dbName: string

  Returns string

getDefaultEmptyString

• getDefaultEmptyString(): string

• Returns string

getDropDatabaseSQL

• getDropDatabaseSQL(name): string

• Parameters

  • name: string

  Returns string

getDropIndexSQL

• getDropIndexSQL(tableName, index): string

• Parameters

  • tableName: string

  • index: Index

  Returns string

getEnumDefinitions

• getEnumDefinitions(connection, checks, tableName, schemaName): Promise<Dictionary<string[]>>

• Parameters

  • connection: AbstractSqlConnection

  • checks: Check<unknown>[]

  • tableName: string

  • optionalschemaName: string

  Returns Promise<Dictionary<string[]>>

getForeignKeys

• getForeignKeys(connection, tableName, schemaName): Promise<Dictionary>

• Parameters

  • connection: AbstractSqlConnection

  • tableName: string

  • optionalschemaName: string

  Returns Promise<Dictionary>

getForeignKeysSQL

• getForeignKeysSQL(tableName, schemaName): string

• Parameters

  • tableName: string

  • optionalschemaName: string

  Returns string

getIndexes

• getIndexes(connection, tableName, schemaName): Promise<Index[]>

• Parameters

  • connection: AbstractSqlConnection

  • tableName: string

  • optionalschemaName: string

  Returns Promise<Index[]>

getListTablesSQL

• getListTablesSQL(schemaName): string

• Parameters

  • optionalschemaName: string

  Returns string

getManagementDbName

• getManagementDbName(): string

• Returns string

getNamespaces

• getNamespaces(connection): Promise<string[]>

• Parameters

  • connection: AbstractSqlConnection

  Returns Promise<string[]>

getPreAlterTable

• getPreAlterTable(tableDiff, safe): string

• Parameters

  • tableDiff: TableDifference

  • safe: boolean

  Returns string

getPrimaryKeys

• getPrimaryKeys(connection, indexes, tableName, schemaName): Promise<string[]>

• Parameters

  • connection: AbstractSqlConnection

  • indexes: Index[] = []

  • tableName: string

  • optionalschemaName: string

  Returns Promise<string[]>

getRenameColumnSQL

• getRenameColumnSQL(tableName, oldColumnName, to, schemaName): string

• Parameters

  • tableName: string

  • oldColumnName: string

  • to: Column

  • optionalschemaName: string

  Returns string

getRenameIndexSQL

• getRenameIndexSQL(tableName, index, oldIndexName): string

• Parameters

  • tableName: string

  • index: Index

  • oldIndexName: string

  Returns string

getSchemaBeginning

• getSchemaBeginning(charset): string

• Parameters

  • charset: string

  Returns string

getSchemaEnd

• getSchemaEnd(): string

• Returns string

hasNonDefaultPrimaryKeyName

• hasNonDefaultPrimaryKeyName(table): boolean

• Parameters

  • table: DatabaseTable

  Returns boolean

loadInformationSchema

• loadInformationSchema(schema, connection, tables): Promise<void>

• Parameters

  • schema: DatabaseSchema

  • connection: AbstractSqlConnection

  • tables: Table[]

  Returns Promise<void>

mapForeignKeys

• mapForeignKeys(fks, tableName, schemaName): Dictionary

• Parameters

  • fks: any[]

  • tableName: string

  • optionalschemaName: string

  Returns Dictionary

normalizeDefaultValue

• normalizeDefaultValue(defaultValue, length, defaultValues): string | number

• Parameters

  • defaultValue: string

  • optionallength: number

  • defaultValues: Dictionary<string[]> = {}

  Returns string | number

pushTableQuery

• pushTableQuery(table, expression, grouping): void

• Uses raw method injected in AbstractSqlConnection to allow adding custom queries inside alter statements.

  ---

  Parameters

  • table: TableBuilder

  • expression: string

  • grouping: string = 'alterTable'

  Returns void

supportsSchemaConstraints

• supportsSchemaConstraints(): boolean

• Returns boolean