Skip to main content

Version: Next

MsSqlSchemaHelper

Hierarchy

SchemaHelper
- MsSqlSchemaHelper

Index

Constructors

constructor

Properties

DEFAULT_VALUES

Accessors

options

Methods

Constructors

constructor

new MsSqlSchemaHelper(platform): 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

inheritedoptions

get options(): { createForeignKeyConstraints?: boolean; disableForeignKeys?: boolean; ignoreSchema?: string[]; managementDbName?: string; skipColumns?: Dictionary<(string | RegExp)[]>; skipTables?: (string | RegExp)[] }

Inherited from SchemaHelper.options
Returns { createForeignKeyConstraints?: boolean; disableForeignKeys?: boolean; ignoreSchema?: string[]; managementDbName?: string; skipColumns?: Dictionary<(string | RegExp)[]>; skipTables?: (string | RegExp)[] }
- optionalcreateForeignKeyConstraints?: boolean
  Generate foreign key constraints.
- optionaldisableForeignKeys?: boolean
  Try to disable foreign key checks during schema operations.
- optionalignoreSchema?: string[]
  Schema names to ignore when comparing schemas.
- optionalmanagementDbName?: string
  Database name to use for management operations (e.g., creating/dropping databases).
- optionalskipColumns?: Dictionary<(string | RegExp)[]>
  Column names or patterns to skip during schema generation, keyed by table name.
- optionalskipTables?: (string | RegExp)[]
  Table names or patterns to skip during schema generation.

Methods

inheritedalterTable

alterTable(diff, safe): string[]

Inherited from SchemaHelper.alterTable
Parameters
- diff: TableDifference
- optionalsafe: boolean
Returns string[]

alterTableColumn

alterTableColumn(column, table, changedProperties): string[]

Overrides SchemaHelper.alterTableColumn
Parameters
- column: Column
- table: DatabaseTable
- changedProperties: Set<string>
Returns string[]

inheritedalterTableComment

alterTableComment(table, comment): string

Inherited from SchemaHelper.alterTableComment
Parameters
- table: DatabaseTable
- optionalcomment: string
Returns string

inheritedappend

append(array, sql, pad): void

Inherited from SchemaHelper.append
Parameters
- array: string[]
- sql: string | string[]
- pad: boolean = false
Returns void

appendComments

appendComments(table): string[]

Overrides SchemaHelper.appendComments
Parameters
- table: DatabaseTable
Returns string[]

inheritedcastColumn

castColumn(name, type): string

Inherited from SchemaHelper.castColumn
Parameters
- name: string
- type: string
Returns string

inheritedcreateCheck

createCheck(table, check): string

Inherited from SchemaHelper.createCheck
Parameters
- table: DatabaseTable
- check: CheckDef<unknown>
Returns string

inheritedcreateForeignKey

createForeignKey(table, foreignKey, alterTable, inline): string

Inherited from SchemaHelper.createForeignKey
Parameters
- table: DatabaseTable
- foreignKey: ForeignKey
- alterTable: boolean = true
- inline: boolean = false
Returns string

createIndex

createIndex(index, table, createPrimary): string

Overrides SchemaHelper.createIndex
Parameters
- index: IndexDef
- table: DatabaseTable
- createPrimary: boolean = false
Returns string

inheritedcreateTable

createTable(table, alter): string[]

Inherited from SchemaHelper.createTable
Parameters
- table: DatabaseTable
- optionalalter: boolean
Returns string[]

createTableColumn

createTableColumn(column, table, changedProperties): undefined | string

Overrides SchemaHelper.createTableColumn
Parameters
- column: Column
- table: DatabaseTable
- optionalchangedProperties: Set<string>
Returns undefined | string

inheriteddatabaseExists

databaseExists(connection, name): Promise<boolean>

Inherited from SchemaHelper.databaseExists
Parameters
- connection: Connection
- name: string
Returns Promise<boolean>

disableForeignKeysSQL

disableForeignKeysSQL(): string

Overrides SchemaHelper.disableForeignKeysSQL
Returns string

inheriteddropConstraint

dropConstraint(table, name): string

Inherited from SchemaHelper.dropConstraint
Parameters
- table: string
- name: string
Returns string

dropForeignKey

dropForeignKey(tableName, constraintName): string

Overrides SchemaHelper.dropForeignKey
Parameters
- tableName: string
- constraintName: string
Returns string

dropIndex

dropIndex(table, index, oldIndexName): string

Overrides SchemaHelper.dropIndex
Parameters
- table: string
- index: IndexDef
- oldIndexName: string = index.keyName
Returns string

dropTableIfExists

dropTableIfExists(name, schema): string

Overrides SchemaHelper.dropTableIfExists
Parameters
- name: string
- optionalschema: string
Returns string

enableForeignKeysSQL

enableForeignKeysSQL(): string

Overrides SchemaHelper.enableForeignKeysSQL
Returns string

inheritedfinalizeTable

finalizeTable(table, charset, collate): string

Inherited from SchemaHelper.finalizeTable
Parameters
- table: DatabaseTable
- charset: string
- optionalcollate: string
Returns string

getAddColumnsSQL

getAddColumnsSQL(table, columns): string[]

Overrides SchemaHelper.getAddColumnsSQL
Parameters
- table: DatabaseTable
- columns: Column[]
Returns string[]

getAllChecks

getAllChecks(connection, tablesBySchemas): Promise<Dictionary<CheckDef<unknown>[]>>

Parameters
- connection: AbstractSqlConnection
- tablesBySchemas: Map<undefined | string, Table[]>
Returns Promise<Dictionary<CheckDef<unknown>[]>>

getAllColumns

getAllColumns(connection, tablesBySchemas): Promise<Dictionary<Column[]>>

Parameters
- connection: AbstractSqlConnection
- tablesBySchemas: Map<undefined | string, Table[]>
Returns Promise<Dictionary<Column[]>>

getAllForeignKeys

getAllForeignKeys(connection, tablesBySchemas): Promise<Dictionary<Dictionary<ForeignKey>>>

Parameters
- connection: AbstractSqlConnection
- tablesBySchemas: Map<undefined | string, Table[]>
Returns Promise<Dictionary<Dictionary<ForeignKey>>>

getAllIndexes

getAllIndexes(connection, tablesBySchemas): Promise<Dictionary<IndexDef[]>>

Parameters
- connection: AbstractSqlConnection
- tablesBySchemas: Map<undefined | string, Table[]>
Returns Promise<Dictionary<IndexDef[]>>

inheritedgetAlterNativeEnumSQL

getAlterNativeEnumSQL(name, schema, value, items, oldItems): string

Inherited from SchemaHelper.getAlterNativeEnumSQL
Parameters
- name: string
- optionalschema: string
- optionalvalue: string
- optionalitems: string[]
- optionaloldItems: string[]
Returns string

inheritedgetChangeColumnCommentSQL

getChangeColumnCommentSQL(tableName, to, schemaName): string

Inherited from SchemaHelper.getChangeColumnCommentSQL
Parameters
- tableName: string
- to: Column
- optionalschemaName: string
Returns string

inheritedgetCreateDatabaseSQL

getCreateDatabaseSQL(name): string

Inherited from SchemaHelper.getCreateDatabaseSQL
Parameters
- name: string
Returns string

getCreateIndexSQL

getCreateIndexSQL(tableName, index, partialExpression): string

Overrides SchemaHelper.getCreateIndexSQL
Parameters
- tableName: string
- index: IndexDef
- partialExpression: boolean = false
Returns string

getCreateNamespaceSQL

getCreateNamespaceSQL(name): string

Overrides SchemaHelper.getCreateNamespaceSQL
Parameters
- name: string
Returns string

inheritedgetCreateNativeEnumSQL

getCreateNativeEnumSQL(name, values, schema): string

Inherited from SchemaHelper.getCreateNativeEnumSQL
Parameters
- name: string
- values: unknown[]
- optionalschema: string
Returns string

getDatabaseExistsSQL

getDatabaseExistsSQL(name): string

Overrides SchemaHelper.getDatabaseExistsSQL
Parameters
- name: string
Returns string

inheritedgetDatabaseNotExistsError

getDatabaseNotExistsError(dbName): string

Inherited from SchemaHelper.getDatabaseNotExistsError
Parameters
- dbName: string
Returns string

inheritedgetDefaultEmptyString

getDefaultEmptyString(): string

Inherited from SchemaHelper.getDefaultEmptyString
Returns string

getDropColumnsSQL

getDropColumnsSQL(tableName, columns, schemaName): string

Overrides SchemaHelper.getDropColumnsSQL
Parameters
- tableName: string
- columns: Column[]
- optionalschemaName: string
Returns string

inheritedgetDropDatabaseSQL

getDropDatabaseSQL(name): string

Inherited from SchemaHelper.getDropDatabaseSQL
Parameters
- name: string
Returns string

getDropIndexSQL

getDropIndexSQL(tableName, index): string

Overrides SchemaHelper.getDropIndexSQL
Parameters
- tableName: string
- index: IndexDef
Returns string

getDropNamespaceSQL

getDropNamespaceSQL(name): string

Overrides SchemaHelper.getDropNamespaceSQL
Parameters
- name: string
Returns string

inheritedgetDropNativeEnumSQL

getDropNativeEnumSQL(name, schema): string

Inherited from SchemaHelper.getDropNativeEnumSQL
Parameters
- name: string
- optionalschema: string
Returns string

getListTablesSQL

getListTablesSQL(): string

Overrides SchemaHelper.getListTablesSQL
Returns string

getManagementDbName

getManagementDbName(): string

Overrides SchemaHelper.getManagementDbName
Returns string

getNamespaces

getNamespaces(connection): Promise<string[]>

Overrides SchemaHelper.getNamespaces
Parameters
- connection: AbstractSqlConnection
Returns Promise<string[]>

getPostAlterTable

getPostAlterTable(tableDiff, safe): string[]

Overrides SchemaHelper.getPostAlterTable
Parameters
- tableDiff: TableDifference
- safe: boolean
Returns string[]

getPreAlterTable

getPreAlterTable(tableDiff, safe): string[]

Overrides SchemaHelper.getPreAlterTable
Parameters
- tableDiff: TableDifference
- safe: boolean
Returns string[]

inheritedgetPrimaryKeys

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

Inherited from SchemaHelper.getPrimaryKeys
Parameters
- connection: AbstractSqlConnection
- indexes: IndexDef[] = []
- tableName: string
- optionalschemaName: string
Returns Promise<string[]>

inheritedgetReferencedTableName

getReferencedTableName(referencedTableName, schema): string

Inherited from SchemaHelper.getReferencedTableName
Parameters
- referencedTableName: string
- optionalschema: string
Returns string

getRenameColumnSQL

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

Overrides SchemaHelper.getRenameColumnSQL
Parameters
- tableName: string
- oldColumnName: string
- to: Column
- optionalschemaName: string
Returns string

inheritedgetRenameIndexSQL

getRenameIndexSQL(tableName, index, oldIndexName): string[]

Inherited from SchemaHelper.getRenameIndexSQL
Parameters
- tableName: string
- index: IndexDef
- oldIndexName: string
Returns string[]

inheritedgetSchemaBeginning

getSchemaBeginning(_charset, disableForeignKeys): string

Inherited from SchemaHelper.getSchemaBeginning
Parameters
- _charset: string
- optionaldisableForeignKeys: boolean
Returns string

inheritedgetSchemaEnd

getSchemaEnd(disableForeignKeys): string

Inherited from SchemaHelper.getSchemaEnd
Parameters
- optionaldisableForeignKeys: boolean
Returns string

inheritedgetTablesGroupedBySchemas

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

Inherited from SchemaHelper.getTablesGroupedBySchemas
Parameters
- tables: Table[]
Returns Map<undefined | string, Table[]>

inheritedhasNonDefaultPrimaryKeyName

hasNonDefaultPrimaryKeyName(table): boolean

Inherited from SchemaHelper.hasNonDefaultPrimaryKeyName
Parameters
- table: DatabaseTable
Returns boolean

inferLengthFromColumnType

inferLengthFromColumnType(type): undefined | number

Overrides SchemaHelper.inferLengthFromColumnType
Parameters
- type: string
Returns undefined | number

loadInformationSchema

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

Overrides SchemaHelper.loadInformationSchema
Parameters
- schema: DatabaseSchema
- connection: AbstractSqlConnection
- tables: Table[]
Returns Promise<void>

mapForeignKeys

mapForeignKeys(fks, tableName, schemaName): Dictionary

Overrides SchemaHelper.mapForeignKeys
Parameters
- fks: any[]
- tableName: string
- optionalschemaName: string
Returns Dictionary

normalizeDefaultValue

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

Overrides SchemaHelper.normalizeDefaultValue
Parameters
- defaultValue: string
- length: number
- defaultValues: Dictionary<string[]> = {}
- stripQuotes: boolean = false
Returns string | number

inheritedsplitTableName

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

Inherited from SchemaHelper.splitTableName
Parameters
- name: string
- skipDefaultSchema: boolean = false
Returns [undefined | string, string]

inheritedsupportsSchemaConstraints

supportsSchemaConstraints(): boolean

Inherited from SchemaHelper.supportsSchemaConstraints
Returns boolean

Page Options

Hide Inherited