Options
All
  • Public
  • Public/Protected
  • All
Menu

Class default Abstract

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Properties

Protected Readonly QUERY_PRIMARY_KEYS

QUERY_PRIMARY_KEYS: string = ...

Methods

Abstract UNIVERSAL_DATATYPE

  • UNIVERSAL_DATATYPE(): string

dropTable_SQL

  • dropTable_SQL(tableName: string): string

Abstract dropTempTable

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

Abstract escape

  • escape(str: string): string

generateColumnString

  • generateColumnString(columns: string[]): string

Abstract getColumnSample

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

Abstract getDatatypes

  • getDatatypes(): Promise<string[]>

Abstract getDbmsName

Abstract getForeignKeys

Abstract getJdbcPath

  • getJdbcPath(): string

Abstract getMaxValueByColumn

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

  • Parameters

    • table: string
    • column: string

    Returns Promise<any>

Abstract getPrimaryKeys

Abstract getRedundantGroupLengthByColumns

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

  • Parameters

    • table: string
    • columns: string[]

    Returns Promise<any>

Abstract getRedundantValuesByColumns

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

  • Parameters

    • table: string
    • columns: string[]

    Returns Promise<any>

Abstract getSchema

Abstract getTablePage

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

  • Parameters

    • tablename: string
    • schemaname: string
    • offset: number
    • limit: number

    Returns Promise<default>

Abstract getTableRowCount

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

Abstract getViolatingRowsForFD

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

  • Parameters

    • sql: string
    • lhs: string[]
    • rhs: string[]
    • offset: number
    • limit: number

    Returns Promise<default>

Abstract 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

Abstract getViolatingRowsForSuggestedIND

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

Abstract getViolatingRowsForSuggestedINDCount

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

Abstract init

  • init(): void

Protected randomName

  • randomName(): string

Abstract tableExistsInSchema

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

  • Parameters

    • schema: string
    • table: string

    Returns Promise<boolean>

Abstract tempTableName

  • tempTableName(name: string): string

Abstract tempTableScripts

  • tempTableScripts(Sql: string, name: string): default

  • Parameters

    • Sql: string

      The Sql that queries the information the temp-table should contain

    • name: string

      The name of the temp-table. Relevant for multiple temp-table in one query

    Returns default

Abstract testKeyUnionability

testKeyUnionabilitySql

  • A key is invalid when the unioned table contains different rows with the same key. (SQL-UNION is implemented as a SET-Operation)

    Parameters

    Returns string

Abstract testNewValue

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

testNewValueSql

  • testNewValueSql(nv: default): string

Abstract testNotNullConstraint

testNotNullSql

Abstract testTypeCasting

testTypeCastingSql

Protected violatingRowsForFD_SQL

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

  • Parameters

    • tableName: string
    • lhs: string[]
    • rhs: string[]

    Returns 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