MsSqlSchemaHelper

Hierarchy

• SchemaHelper
  • MsSqlSchemaHelper

Index

Constructors

• constructor

Properties

• DEFAULT_VALUES

Accessors

• knex
• options

Methods

• configureColumn
• configureColumnDefault
• createCheck
• createForeignKey
• createIndex
• createSchemaBuilder
• createTable
• createTableColumn
• databaseExists
• disableForeignKeysSQL
• dump
• enableForeignKeysSQL
• finalizeTable
• getAllChecks
• getAllColumns
• getAllForeignKeys
• getAllIndexes
• getAlterColumnAutoincrement
• getAlterNativeEnumSQL
• getAlterTable
• getChangeColumnCommentSQL
• getChecks
• getColumns
• getCreateDatabaseSQL
• getCreateIndexSQL
• getCreateNamespaceSQL
• getCreateNativeEnumSQL
• getDatabaseExistsSQL
• getDatabaseNotExistsError
• getDefaultEmptyString
• getDropColumnsSQL
• getDropDatabaseSQL
• getDropIndexSQL
• getDropNamespaceSQL
• getDropNativeEnumSQL
• getEnumDefinitions
• getForeignKeys
• getForeignKeysSQL
• getIndexes
• getListTablesSQL
• getManagementDbName
• getNamespaces
• getPostAlterTable
• getPreAlterTable
• getPrimaryKeys
• getReferencedTableName
• getRenameColumnSQL
• getRenameIndexSQL
• getSchemaBeginning
• getSchemaEnd
• getTablesGroupedBySchemas
• handleMultilineComment
• hasNonDefaultPrimaryKeyName
• inferLengthFromColumnType
• loadInformationSchema
• mapForeignKeys
• normalizeDefaultValue
• pushTableQuery
• splitTableName
• supportsSchemaConstraints

Constructors

constructor

• new MsSqlSchemaHelper(platform: AbstractSqlPlatform): MsSqlSchemaHelper

• Inherited from SchemaHelper.constructor

  Parameters

  • platform: AbstractSqlPlatform

  Returns MsSqlSchemaHelper

Properties

staticreadonlyDEFAULT_VALUES

DEFAULT_VALUES: { false: string[]; getdate(): string[]; true: string[] } = ...

Type declaration

• false: string[]

• getdate(): string[]

• true: string[]

Accessors

inheritedknex

• get knex(): Knex<any, any[]>

• Inherited from SchemaHelper.knex

  Returns Knex<any, any[]>

inheritedoptions

• get options(): { createForeignKeyConstraints?: boolean; disableForeignKeys?: boolean; ignoreSchema?: string[]; managementDbName?: string }

• Inherited from SchemaHelper.options

  Returns { createForeignKeyConstraints?: boolean; disableForeignKeys?: boolean; ignoreSchema?: string[]; managementDbName?: string }

  • optionalcreateForeignKeyConstraints?: boolean

  • optionaldisableForeignKeys?: boolean

  • optionalignoreSchema?: string[]

  • optionalmanagementDbName?: string

Methods

inheritedconfigureColumn

• configureColumn(column: Column, col: ColumnBuilder, knex: Knex<any, any[]>, changedProperties?: Set<string>): ColumnBuilder

• Inherited from SchemaHelper.configureColumn

  Parameters

  • column: Column

  • col: ColumnBuilder

  • knex: Knex<any, any[]>

  • optionalchangedProperties: Set<string>

  Returns ColumnBuilder

inheritedconfigureColumnDefault

• configureColumnDefault(column: Column, col: ColumnBuilder, knex: Knex<any, any[]>, changedProperties?: Set<string>): ColumnBuilder

• Inherited from SchemaHelper.configureColumnDefault

  Parameters

  • column: Column

  • col: ColumnBuilder

  • knex: Knex<any, any[]>

  • optionalchangedProperties: Set<string>

  Returns ColumnBuilder

inheritedcreateCheck

• createCheck(table: CreateTableBuilder, check: CheckDef<unknown>): void

• Inherited from SchemaHelper.createCheck

  Parameters

  • table: CreateTableBuilder

  • check: CheckDef<unknown>

  Returns void

inheritedcreateForeignKey

• createForeignKey(table: CreateTableBuilder, foreignKey: ForeignKey, schema?: string): void

• Inherited from SchemaHelper.createForeignKey

  Parameters

  • table: CreateTableBuilder

  • foreignKey: ForeignKey

  • optionalschema: string

  Returns void

inheritedcreateIndex

• createIndex(table: CreateTableBuilder, index: IndexDef, tableDef: DatabaseTable, createPrimary?: boolean): void

• Inherited from SchemaHelper.createIndex

  Parameters

  • table: CreateTableBuilder

  • index: IndexDef

  • tableDef: DatabaseTable

  • createPrimary: boolean = false

  Returns void

inheritedcreateSchemaBuilder

• createSchemaBuilder(schema?: string): SchemaBuilder

• Inherited from SchemaHelper.createSchemaBuilder

  Parameters

  • optionalschema: string

  Returns SchemaBuilder

inheritedcreateTable

• createTable(tableDef: DatabaseTable, alter?: boolean): SchemaBuilder

• Inherited from SchemaHelper.createTable

  Parameters

  • tableDef: DatabaseTable

  • optionalalter: boolean

  Returns SchemaBuilder

createTableColumn

• createTableColumn(table: TableBuilder, column: Column, fromTable: DatabaseTable, changedProperties?: Set<string>, alter?: boolean): undefined | ColumnBuilder

• Overrides SchemaHelper.createTableColumn

  Parameters

  • table: TableBuilder

  • column: Column

  • fromTable: DatabaseTable

  • optionalchangedProperties: Set<string>

  • optionalalter: boolean

  Returns undefined | ColumnBuilder

inheriteddatabaseExists

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

• Inherited from SchemaHelper.databaseExists

  Parameters

  • connection: Connection

  • name: string

  Returns Promise<boolean>

disableForeignKeysSQL

• disableForeignKeysSQL(): string

• Overrides SchemaHelper.disableForeignKeysSQL

  Returns string

inheriteddump

• dump(builder: string | SchemaBuilder, append: string): Promise<string>

• Inherited from SchemaHelper.dump

  Parameters

  • builder: string | SchemaBuilder

  • append: string

  Returns Promise<string>

enableForeignKeysSQL

• enableForeignKeysSQL(): string

• Overrides SchemaHelper.enableForeignKeysSQL

  Returns string

inheritedfinalizeTable

• finalizeTable(table: TableBuilder, charset: string, collate?: string): void

• Inherited from SchemaHelper.finalizeTable

  Parameters

  • table: TableBuilder

  • charset: string

  • optionalcollate: string

  Returns void

getAllChecks

• getAllChecks(connection: AbstractSqlConnection, tablesBySchemas: Map<undefined | string, Table[]>): Promise<Dictionary<CheckDef<unknown>[]>>

• Parameters

  • connection: AbstractSqlConnection

  • tablesBySchemas: Map<undefined | string, Table[]>

  Returns Promise<Dictionary<CheckDef<unknown>[]>>

getAllColumns

• getAllColumns(connection: AbstractSqlConnection, tablesBySchemas: Map<undefined | string, Table[]>): Promise<Dictionary<Column[]>>

• Parameters

  • connection: AbstractSqlConnection

  • tablesBySchemas: Map<undefined | string, Table[]>

  Returns Promise<Dictionary<Column[]>>

getAllForeignKeys

• getAllForeignKeys(connection: AbstractSqlConnection, tablesBySchemas: Map<undefined | string, Table[]>): Promise<Dictionary<Dictionary<ForeignKey>>>

• Parameters

  • connection: AbstractSqlConnection

  • tablesBySchemas: Map<undefined | string, Table[]>

  Returns Promise<Dictionary<Dictionary<ForeignKey>>>

getAllIndexes

• getAllIndexes(connection: AbstractSqlConnection, tablesBySchemas: Map<undefined | string, Table[]>): Promise<Dictionary<IndexDef[]>>

• Parameters

  • connection: AbstractSqlConnection

  • tablesBySchemas: Map<undefined | string, Table[]>

  Returns Promise<Dictionary<IndexDef[]>>

inheritedgetAlterColumnAutoincrement

• getAlterColumnAutoincrement(tableName: string, column: Column, schemaName?: string): string

• Inherited from SchemaHelper.getAlterColumnAutoincrement

  Parameters

  • tableName: string

  • column: Column

  • optionalschemaName: string

  Returns string

inheritedgetAlterNativeEnumSQL

• getAlterNativeEnumSQL(name: string, schema?: string, value?: string, items?: string[], oldItems?: string[]): string

• Inherited from SchemaHelper.getAlterNativeEnumSQL

  Parameters

  • name: string

  • optionalschema: string

  • optionalvalue: string

  • optionalitems: string[]

  • optionaloldItems: string[]

  Returns string

optionalinheritedgetAlterTable

• getAlterTable(changedTable: TableDifference, wrap?: boolean): Promise<string>

• Inherited from SchemaHelper.getAlterTable

  Parameters

  • changedTable: TableDifference

  • optionalwrap: boolean

  Returns Promise<string>

inheritedgetChangeColumnCommentSQL

• getChangeColumnCommentSQL(tableName: string, to: Column, schemaName?: string): string

• Inherited from SchemaHelper.getChangeColumnCommentSQL

  Parameters

  • tableName: string

  • to: Column

  • optionalschemaName: string

  Returns string

inheritedgetChecks

• getChecks(connection: AbstractSqlConnection, tableName: string, schemaName?: string, columns?: Column[]): Promise<CheckDef<unknown>[]>

• Inherited from SchemaHelper.getChecks

  Parameters

  • connection: AbstractSqlConnection

  • tableName: string

  • optionalschemaName: string

  • optionalcolumns: Column[]

  Returns Promise<CheckDef<unknown>[]>

inheritedgetColumns

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

• Inherited from SchemaHelper.getColumns

  Parameters

  • connection: AbstractSqlConnection

  • tableName: string

  • optionalschemaName: string

  Returns Promise<Column[]>

inheritedgetCreateDatabaseSQL

• getCreateDatabaseSQL(name: string): string

• Inherited from SchemaHelper.getCreateDatabaseSQL

  Parameters

  • name: string

  Returns string

inheritedgetCreateIndexSQL

• getCreateIndexSQL(tableName: string, index: IndexDef, partialExpression?: boolean): string

• Inherited from SchemaHelper.getCreateIndexSQL

  Parameters

  • tableName: string

  • index: IndexDef

  • partialExpression: boolean = false

  Returns string

getCreateNamespaceSQL

• getCreateNamespaceSQL(name: string): string

• Overrides SchemaHelper.getCreateNamespaceSQL

  Parameters

  • name: string

  Returns string

inheritedgetCreateNativeEnumSQL

• getCreateNativeEnumSQL(name: string, values: unknown[], schema?: string): string

• Inherited from SchemaHelper.getCreateNativeEnumSQL

  Parameters

  • name: string

  • values: unknown[]

  • optionalschema: string

  Returns string

getDatabaseExistsSQL

• getDatabaseExistsSQL(name: string): string

• Overrides SchemaHelper.getDatabaseExistsSQL

  Parameters

  • name: string

  Returns string

inheritedgetDatabaseNotExistsError

• getDatabaseNotExistsError(dbName: string): string

• Inherited from SchemaHelper.getDatabaseNotExistsError

  Parameters

  • dbName: string

  Returns string

inheritedgetDefaultEmptyString

• getDefaultEmptyString(): string

• Inherited from SchemaHelper.getDefaultEmptyString

  Returns string

getDropColumnsSQL

• getDropColumnsSQL(tableName: string, columns: Column[], schemaName?: string): string

• Overrides SchemaHelper.getDropColumnsSQL

  Parameters

  • tableName: string

  • columns: Column[]

  • optionalschemaName: string

  Returns string

inheritedgetDropDatabaseSQL

• getDropDatabaseSQL(name: string): string

• Inherited from SchemaHelper.getDropDatabaseSQL

  Parameters

  • name: string

  Returns string

getDropIndexSQL

• getDropIndexSQL(tableName: string, index: IndexDef): string

• Overrides SchemaHelper.getDropIndexSQL

  Parameters

  • tableName: string

  • index: IndexDef

  Returns string

getDropNamespaceSQL

• getDropNamespaceSQL(name: string): string

• Overrides SchemaHelper.getDropNamespaceSQL

  Parameters

  • name: string

  Returns string

inheritedgetDropNativeEnumSQL

• getDropNativeEnumSQL(name: string, schema?: string): string

• Inherited from SchemaHelper.getDropNativeEnumSQL

  Parameters

  • name: string

  • optionalschema: string

  Returns string

getEnumDefinitions

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

• Overrides SchemaHelper.getEnumDefinitions

  Parameters

  • connection: AbstractSqlConnection

  • checks: CheckDef<unknown>[]

  • optionaltableName: string

  • optionalschemaName: string

  Returns Promise<Dictionary<string[]>>

inheritedgetForeignKeys

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

• Inherited from SchemaHelper.getForeignKeys

  Parameters

  • connection: AbstractSqlConnection

  • tableName: string

  • optionalschemaName: string

  Returns Promise<Dictionary>

inheritedgetForeignKeysSQL

• getForeignKeysSQL(tableName: string, schemaName?: string): string

• Inherited from SchemaHelper.getForeignKeysSQL

  Parameters

  • tableName: string

  • optionalschemaName: string

  Returns string

inheritedgetIndexes

• getIndexes(connection: AbstractSqlConnection, tableName: string, schemaName?: string): Promise<IndexDef[]>

• Inherited from SchemaHelper.getIndexes

  Parameters

  • connection: AbstractSqlConnection

  • tableName: string

  • optionalschemaName: string

  Returns Promise<IndexDef[]>

getListTablesSQL

• getListTablesSQL(): string

• Overrides SchemaHelper.getListTablesSQL

  Returns string

getManagementDbName

• getManagementDbName(): string

• Overrides SchemaHelper.getManagementDbName

  Returns string

getNamespaces

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

• Overrides SchemaHelper.getNamespaces

  Parameters

  • connection: AbstractSqlConnection

  Returns Promise<string[]>

getPostAlterTable

• getPostAlterTable(tableDiff: TableDifference, safe: boolean): string

• Overrides SchemaHelper.getPostAlterTable

  Parameters

  • tableDiff: TableDifference

  • safe: boolean

  Returns string

getPreAlterTable

• getPreAlterTable(tableDiff: TableDifference, safe: boolean): string

• Overrides SchemaHelper.getPreAlterTable

  Parameters

  • tableDiff: TableDifference

  • safe: boolean

  Returns string

inheritedgetPrimaryKeys

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

• Inherited from SchemaHelper.getPrimaryKeys

  Parameters

  • connection: AbstractSqlConnection

  • indexes: IndexDef[] = []

  • tableName: string

  • optionalschemaName: string

  Returns Promise<string[]>

inheritedgetReferencedTableName

• getReferencedTableName(referencedTableName: string, schema?: string): string

• Inherited from SchemaHelper.getReferencedTableName

  Parameters

  • referencedTableName: string

  • optionalschema: string

  Returns string

getRenameColumnSQL

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

• Overrides SchemaHelper.getRenameColumnSQL

  Parameters

  • tableName: string

  • oldColumnName: string

  • to: Column

  • optionalschemaName: string

  Returns string

inheritedgetRenameIndexSQL

• getRenameIndexSQL(tableName: string, index: IndexDef, oldIndexName: string): string

• Inherited from SchemaHelper.getRenameIndexSQL

  Parameters

  • tableName: string

  • index: IndexDef

  • oldIndexName: string

  Returns string

inheritedgetSchemaBeginning

• getSchemaBeginning(charset: string, disableForeignKeys?: boolean): string

• Inherited from SchemaHelper.getSchemaBeginning

  Parameters

  • charset: string

  • optionaldisableForeignKeys: boolean

  Returns string

inheritedgetSchemaEnd

• getSchemaEnd(disableForeignKeys?: boolean): string

• Inherited from SchemaHelper.getSchemaEnd

  Parameters

  • optionaldisableForeignKeys: boolean

  Returns string

inheritedgetTablesGroupedBySchemas

• getTablesGroupedBySchemas(tables: Table[]): Map<undefined | string, Table[]>

• Inherited from SchemaHelper.getTablesGroupedBySchemas

  Parameters

  • tables: Table[]

  Returns Map<undefined | string, Table[]>

handleMultilineComment

• handleMultilineComment(comment: string): string

• Overrides SchemaHelper.handleMultilineComment

  MSSQL supports \n in SQL and stores \\n literally. This method overrides the parent behavior to prevent replacing \n with \\n.

  ---

  Parameters

  • comment: string

  Returns string

inheritedhasNonDefaultPrimaryKeyName

• hasNonDefaultPrimaryKeyName(table: DatabaseTable): boolean

• Inherited from SchemaHelper.hasNonDefaultPrimaryKeyName

  Parameters

  • table: DatabaseTable

  Returns boolean

inferLengthFromColumnType

• inferLengthFromColumnType(type: string): undefined | number

• Overrides SchemaHelper.inferLengthFromColumnType

  Parameters

  • type: string

  Returns undefined | number

loadInformationSchema

• loadInformationSchema(schema: DatabaseSchema, connection: AbstractSqlConnection, tables: Table[]): Promise<void>

• Overrides SchemaHelper.loadInformationSchema

  Parameters

  • schema: DatabaseSchema

  • connection: AbstractSqlConnection

  • tables: Table[]

  Returns Promise<void>

mapForeignKeys

• mapForeignKeys(fks: any[], tableName: string, schemaName?: string): Dictionary

• Overrides SchemaHelper.mapForeignKeys

  Parameters

  • fks: any[]

  • tableName: string

  • optionalschemaName: string

  Returns Dictionary

normalizeDefaultValue

• normalizeDefaultValue(defaultValue: string, length: number, defaultValues?: Dictionary<string[]>, stripQuotes?: boolean): string | number

• Overrides SchemaHelper.normalizeDefaultValue

  Parameters

  • defaultValue: string

  • length: number

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

  • stripQuotes: boolean = false

  Returns string | number

inheritedpushTableQuery

• pushTableQuery(table: TableBuilder, expression: string, grouping?: string): void

• Inherited from SchemaHelper.pushTableQuery

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

  ---

  Parameters

  • table: TableBuilder

  • expression: string

  • grouping: string = 'alterTable'

  Returns void

inheritedsplitTableName

• splitTableName(name: string): [undefined | string, string]

• Inherited from SchemaHelper.splitTableName

  Parameters

  • name: string

  Returns [undefined | string, string]

inheritedsupportsSchemaConstraints

• supportsSchemaConstraints(): boolean

• Inherited from SchemaHelper.supportsSchemaConstraints

  Returns boolean