Options
All
  • Public
  • Public/Protected
  • All
Menu

Class default

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

  • new default(server: string, database: string, user: string, password: string, port?: number): default

Properties

Protected Readonly QUERY_PRIMARY_KEYS

QUERY_PRIMARY_KEYS: string = ...

Private config

config: config

connection

connection: ConnectionPool

Methods

UNIVERSAL_DATATYPE

  • UNIVERSAL_DATATYPE(): string

columnsExistInTable

  • columnsExistInTable(schema: string, table: string, columns: string[]): Promise<boolean>

  • This also checks if table and schema exist in database.

    Parameters

    • schema: string
    • table: string
    • columns: string[]

    Returns Promise<boolean>

dropTable_SQL

  • dropTable_SQL(tableName: string): string

dropTempTable

  • dropTempTable(name: string): Promise<void>

escape

  • escape(str: string): string

generateColumnString

  • generateColumnString(columns: string[]): string

getColumnSample

  • getColumnSample(table: string, column: string): Promise<any>

getDatatypes

  • getDatatypes(): Promise<string[]>

getDbmsName

getForeignKeys

getJdbcPath

  • getJdbcPath(): string

getMaxValueByColumn

  • getMaxValueByColumn(table: string, column: string): Promise<any>

getPrimaryKeys

getRedundantGroupLengthByColumns

  • getRedundantGroupLengthByColumns(table: string, columns: string[]): Promise<any>

getRedundantValuesByColumns

  • getRedundantValuesByColumns(table: string, columns: string[]): Promise<any>

getSchema

getTablePage

  • getTablePage(tablename: string, schemaname: string, offset: number, limit: number): Promise<default>

getTableRowCount

  • getTableRowCount(table: string, schema: string): Promise<default>

getViolatingRowsForFD

  • getViolatingRowsForFD(_sql: string, lhs: string[], rhs: string[], offset: number, limit: number): Promise<default>

getViolatingRowsForFDCount

  • getViolatingRowsForFDCount(_sql: string, lhs: string[], rhs: string[]): Promise<default>

getViolatingRowsForFDCount_Sql

  • getViolatingRowsForFDCount_Sql(tablename: string, lhs: any, rhs: any): string

getViolatingRowsForINDCount_Sql

  • getViolatingRowsForINDCount_Sql(referencingTable: string, referencedTable: string, columnRelationships: IColumnRelationship[]): string

getViolatingRowsForSuggestedIND

  • getViolatingRowsForSuggestedIND(referencingTableSql: string, referencedTableSql: string, columnRelationships: IColumnRelationship[], offset: number, limit: number): Promise<default>

getViolatingRowsForSuggestedINDCount

  • getViolatingRowsForSuggestedINDCount(referencingTableSql: string, referencedTableSql: string, columnRelationships: IColumnRelationship[]): Promise<default>

init

  • init(): Promise<void>

Protected randomName

  • randomName(): string

schemaExistsInDatabase

  • schemaExistsInDatabase(schema: string): Promise<boolean>

tableExistsInSchema

  • tableExistsInSchema(schema: string, table: string): Promise<boolean>

tempTableName

  • tempTableName(name: string): string

  • The #{name} is syntax-sugar in mssql to create a temp table. It is dropped after the session ends by the dbms.

    Parameters

    • name: string

    Returns string

tempTableScripts

  • tempTableScripts(Sql: string): default

testKeyUnionability

testKeyUnionabilitySql

testNewValue

  • testNewValue(t: default): Promise<boolean>

testNewValueSql

  • testNewValueSql(nv: default): string

testNotNullConstraint

testNotNullSql

testTypeCasting

testTypeCastingSql

Protected violatingRowsForFD_SQL

  • violatingRowsForFD_SQL(tableName: string, lhs: string[], rhs: string[]): string

Protected violatingRowsForSuggestedIND_SQL

  • violatingRowsForSuggestedIND_SQL(referencingTable: string, referencedTable: string, columnRelationships: IColumnRelationship[]): string

  • Because of the LEFT OUTER JOIN and the WHERE-Clause only those rows from the referencing table are selected, which are missing in the referenced table and are therefore violating the Inclusion-Dependency.

    Parameters

    Returns string

Generated using TypeDoc