SchemaComparator

Compares two Schemas and return an instance of SchemaDifference.

Index

Constructors

• constructor

Methods

• compare
• diffColumn
• diffComment
• diffEnumItems
• diffExpression
• diffForeignKey
• diffIndex
• diffTable
• hasSameDefaultValue
• isIndexFulfilledBy
• parseJsonDefault

Constructors

constructor

• new SchemaComparator(platform: AbstractSqlPlatform): SchemaComparator

• Parameters

  • platform: AbstractSqlPlatform

  Returns SchemaComparator

Methods

compare

• compare(fromSchema: DatabaseSchema, toSchema: DatabaseSchema, inverseDiff?: SchemaDifference): SchemaDifference

• Returns a SchemaDifference object containing the differences between the schemas fromSchema and toSchema.

  The returned differences are returned in such a way that they contain the operations to change the schema stored in fromSchema to the schema that is stored in toSchema.

  ---

  Parameters

  • fromSchema: DatabaseSchema

  • toSchema: DatabaseSchema

  • optionalinverseDiff: SchemaDifference

  Returns SchemaDifference

diffColumn

• diffColumn(fromColumn: Column, toColumn: Column, fromTable: DatabaseTable, tableName?: string): Set<string>

• Returns the difference between the columns If there are differences this method returns field2, otherwise the boolean false.

  ---

  Parameters

  • fromColumn: Column

  • toColumn: Column

  • fromTable: DatabaseTable

  • optionaltableName: string

  Returns Set<string>

diffComment

• diffComment(comment1?: string, comment2?: string): boolean

• Parameters

  • optionalcomment1: string

  • optionalcomment2: string

  Returns boolean

diffEnumItems

• diffEnumItems(items1?: string[], items2?: string[]): boolean

• Parameters

  • items1: string[] = []

  • items2: string[] = []

  Returns boolean

diffExpression

• diffExpression(expr1: string, expr2: string): boolean

• Parameters

  • expr1: string

  • expr2: string

  Returns boolean

diffForeignKey

• diffForeignKey(key1: ForeignKey, key2: ForeignKey, tableDifferences: TableDifference): boolean

• Parameters

  • key1: ForeignKey

  • key2: ForeignKey

  • tableDifferences: TableDifference

  Returns boolean

diffIndex

• diffIndex(index1: IndexDef, index2: IndexDef): boolean

• Finds the difference between the indexes index1 and index2. Compares index1 with index2 and returns index2 if there are any differences or false in case there are no differences.

  ---

  Parameters

  • index1: IndexDef

  • index2: IndexDef

  Returns boolean

diffTable

• diffTable(fromTable: DatabaseTable, toTable: DatabaseTable, inverseTableDiff?: TableDifference): false | TableDifference

• Returns the difference between the tables fromTable and toTable. If there are no differences this method returns the boolean false.

  ---

  Parameters

  • fromTable: DatabaseTable

  • toTable: DatabaseTable

  • optionalinverseTableDiff: TableDifference

  Returns false | TableDifference

hasSameDefaultValue

• hasSameDefaultValue(from: Column, to: Column): boolean

• Parameters

  • from: Column

  • to: Column

  Returns boolean

isIndexFulfilledBy

• isIndexFulfilledBy(index1: IndexDef, index2: IndexDef): boolean

• Checks if the other index already fulfills all the indexing and constraint needs of the current one.

  ---

  Parameters

  • index1: IndexDef

  • index2: IndexDef

  Returns boolean

parseJsonDefault

• parseJsonDefault(defaultValue?: null | string): null | string | Dictionary

• Parameters

  • optionaldefaultValue: null | string

  Returns null | string | Dictionary