sequelize/sequelize-auto

import { Utils } from "sequelize";


export interface DialectOptions {
  name: string;
  hasSchema: boolean;
  
  getForeignKeysQuery: (tableName: string, schemaName: string) => string;
  remapForeignKeysRow?: (tableName: string, row: FKRow) => FKRelation;
  countTriggerQuery: (tableName: string, schemaName: string) => string;
  isForeignKey?: (record: any) => boolean;
  isUnique?: (record: FKRow, records: FKRow[]) => boolean;
  isPrimaryKey: (record: any) => boolean;
  isSerialKey: (record: any) => boolean;
  showTablesQuery?: (schemaName?: string) => string;
  showViewsQuery: (schemaName?: string) => string;
  showElementTypeQuery?: (tableName: string, schemaName?: string) => string;
  showGeographyTypeQuery?: (tableName: string, schemaName?: string) => string;
  showGeometryTypeQuery?: (tableName: string, schemaName?: string) => string;
  showPrecisionQuery?: (tableName: string, schemaName?: string) => string;
}

export interface FKRow {
  table: string;
  id: string;
  from: string;
  to: string;
  type: string;
  primaryKey: boolean;
  extra: string;
  column_key: string;
  constraint_name: string;
  constraint_type: string;
  contype: string;
  is_identity: boolean;
}

export interface FKRelation {
  constraint_name: string;
  source_schema?: string;
  source_table: string;
  source_column: string;
  target_schema?: string;
  target_table: string;
  target_column: string;
}

export interface FKSpec extends FKRelation {
  isForeignKey: boolean;
  isSerialKey: boolean;
  isPrimaryKey: boolean;
  isUnique: boolean | string;
  foreignSources: {
    source_table?: string;
    source_schema?: string;
    source_column?: string;
    target_table?: string;
    target_schema?: string;
    target_column?: string;
  };
  extra?: string;
  column_key?: string;
}

export interface ColumnElementType {
  column_name: string;
  data_type: string;
  udt_name: string;
  element_type: string;
  enum_values: string;
}

export interface ColumnPrecision {
  column_name: string;
  numeric_precision: number;
  numeric_scale: number;
}

export interface TriggerCount {
  trigger_count: number;
}

export function addTicks(value: any) {
  return Utils.addTicks(value, "'");
}

export function makeCondition(columnName: string, value?: string) {
  return value ? ` AND ${columnName} = ${addTicks(value)} ` : "";
}