Class AbstractDialectAbstract

Protected Static extendSupport

• extendSupport(supportsOverwrite): DialectSupports

• Parameters

  • supportsOverwrite: {
        DEFAULT?: boolean;
        DEFAULT VALUES?: boolean;
        EXCEPTION?: boolean;
        IREGEXP?: boolean;
        LIMIT ON UPDATE?: boolean;
        ON DUPLICATE KEY?: boolean;
        ORDER NULLS?: boolean;
        REGEXP?: boolean;
        RIGHT JOIN?: boolean;
        UNION?: boolean;
        UNION ALL?: boolean;
        VALUES ()?: boolean;
        alterColumn?: { unique?: boolean; };
        autoIncrement?: { identityInsert?: boolean; defaultValue?: boolean; update?: boolean; };
        bulkDefault?: boolean;
        constraints?: { restrict?: boolean; deferrable?: boolean; unique?: boolean; default?: boolean; check?: boolean; foreignKey?: boolean; foreignKeyChecksDisableable?: boolean; primaryKey?: boolean; onUpdate?: boolean; add?: boolean; remove?: boolean; removeOptions?: { ...; }; };
        dataTypes?: { CHAR?: boolean; COLLATE_BINARY?: boolean; CITEXT?: boolean; INTS?: { zerofill?: boolean; unsigned?: boolean; }; REAL?: { scaleAndPrecision?: boolean; NaN?: boolean; infinity?: boolean; zerofill?: boolean; unsigned?: boolean; }; ... 16 more ...; TIME?: { ...; }; };
        dropTable?: { cascade?: boolean; };
        escapeStringConstants?: boolean;
        finalTable?: boolean;
        forShare?: "LOCK IN SHARE MODE" | "FOR SHARE";
        globalTimeZoneConfig?: boolean;
        groupedLimit?: boolean;
        index?: { collate?: boolean; length?: boolean; parser?: boolean; concurrently?: boolean; type?: boolean; using?: number | boolean; functionBased?: boolean; operator?: boolean; where?: boolean; include?: boolean; };
        indexHints?: boolean;
        indexViaAlter?: boolean;
        inserts?: { ignoreDuplicates?: string; updateOnDuplicate?: string | boolean; onConflictDoNothing?: string; onConflictWhere?: boolean; conflictFields?: boolean; };
        jsonExtraction?: { unquoted?: boolean; quoted?: boolean; };
        jsonOperations?: boolean;
        lock?: boolean;
        lockKey?: boolean;
        lockOf?: boolean;
        lockOuterJoinFailure?: boolean;
        maxExecutionTimeHint?: { select?: boolean; };
        migrations?: boolean;
        multiDatabases?: boolean;
        removeColumn?: { cascade?: boolean; ifExists?: boolean; };
        renameTable?: { changeSchema?: boolean; changeSchemaAndTable?: boolean; };
        returnValues?: false | "output" | "returning";
        schemas?: boolean;
        searchPath?: boolean;
        settingIsolationLevelDuringTransaction?: boolean;
        skipLocked?: boolean;
        tableHints?: boolean;
        tmpTableTrigger?: boolean;
        transactionOptions?: { type?: boolean; };
        transactions?: boolean;
        truncate?: { cascade?: boolean; };
        upserts?: boolean;
    }

    • Optional DEFAULT?: boolean

    • Optional DEFAULT VALUES?: boolean

    • Optional EXCEPTION?: boolean

    • Optional IREGEXP?: boolean

      Case-insensitive regexp operator support ('~*' in postgres).

    • Optional LIMIT ON UPDATE?: boolean

    • Optional ON DUPLICATE KEY?: boolean

    • Optional ORDER NULLS?: boolean

    • Optional REGEXP?: boolean

    • Optional RIGHT JOIN?: boolean

    • Optional UNION?: boolean

    • Optional UNION ALL?: boolean

    • Optional VALUES ()?: boolean

    • Optional alterColumn?: { unique?: boolean; }

    • Optional autoIncrement?: { identityInsert?: boolean; defaultValue?: boolean; update?: boolean; }

    • Optional bulkDefault?: boolean

    • Optional constraints?: { restrict?: boolean; deferrable?: boolean; unique?: boolean; default?: boolean; check?: boolean; foreignKey?: boolean; foreignKeyChecksDisableable?: boolean; primaryKey?: boolean; onUpdate?: boolean; add?: boolean; remove?: boolean; removeOptions?: { ...; }; }

    • Optional dataTypes?: { CHAR?: boolean; COLLATE_BINARY?: boolean; CITEXT?: boolean; INTS?: { zerofill?: boolean; unsigned?: boolean; }; REAL?: { scaleAndPrecision?: boolean; NaN?: boolean; infinity?: boolean; zerofill?: boolean; unsigned?: boolean; }; ... 16 more ...; TIME?: { ...; }; }

    • Optional dropTable?: { cascade?: boolean; }

    • Optional escapeStringConstants?: boolean

      This dialect supports E-prefixed strings, e.g. "E'foo'", which enables the ability to use backslash escapes inside of the string.

    • Optional finalTable?: boolean

    • Optional forShare?: "LOCK IN SHARE MODE" | "FOR SHARE"

    • Optional globalTimeZoneConfig?: boolean

      Whether this dialect supports changing the global timezone option

    • Optional groupedLimit?: boolean

    • Optional index?: { collate?: boolean; length?: boolean; parser?: boolean; concurrently?: boolean; type?: boolean; using?: number | boolean; functionBased?: boolean; operator?: boolean; where?: boolean; include?: boolean; }

    • Optional indexHints?: boolean

    • Optional indexViaAlter?: boolean

    • Optional inserts?: { ignoreDuplicates?: string; updateOnDuplicate?: string | boolean; onConflictDoNothing?: string; onConflictWhere?: boolean; conflictFields?: boolean; }

    • Optional jsonExtraction?: { unquoted?: boolean; quoted?: boolean; }

      Whether this dialect supports returning quoted & unquoted JSON strings

    • Optional jsonOperations?: boolean

      Whether this dialect supports SQL JSON functions

    • Optional lock?: boolean

    • Optional lockKey?: boolean

    • Optional lockOf?: boolean

    • Optional lockOuterJoinFailure?: boolean

    • Optional maxExecutionTimeHint?: { select?: boolean; }

    • Optional migrations?: boolean

    • Optional multiDatabases?: boolean

      Whether this dialect has native support for having multiple databases per instance (in the postgres or mssql sense). For the purposes of Sequelize, a database is considered to be a grouping of schemas. For instance, in MySQL, "CREATE DATABASE" creates what we consider to be a schema, so we do not consider that MySQL supports this option.

    • Optional removeColumn?: { cascade?: boolean; ifExists?: boolean; }

    • Optional renameTable?: { changeSchema?: boolean; changeSchemaAndTable?: boolean; }

    • Optional returnValues?: false | "output" | "returning"

    • Optional schemas?: boolean

      Whether this dialect has native support for schemas. For the purposes of Sequelize, a Schema is considered to be a grouping of tables. For instance, in MySQL, "CREATE DATABASE" creates what we consider to be a schema.

    • Optional searchPath?: boolean

    • Optional settingIsolationLevelDuringTransaction?: boolean

    • Optional skipLocked?: boolean

    • Optional tableHints?: boolean

    • Optional tmpTableTrigger?: boolean

    • Optional transactionOptions?: { type?: boolean; }

    • Optional transactions?: boolean

    • Optional truncate?: { cascade?: boolean; }

    • Optional upserts?: boolean

  Returns DialectSupports