Interface QiBulkDeleteOptions<TAttributes>

Options accepted by AbstractQueryInterface#bulkDelete

interface QiBulkDeleteOptions<TAttributes> {
    [COMPLETES_TRANSACTION]?: boolean;
    benchmark?: boolean;
    bind?: BindOrReplacements;
    connection?: null | AbstractConnection;
    fieldMap?: FieldMap;
    instance?: Model<any, any>;
    limit?: number | Nullish | Literal;
    logging?: false | ((sql, timing?) => void);
    mapToModel?: boolean;
    nest?: boolean;
    offset?: number | Nullish | Literal;
    plain?: boolean;
    replacements?: BindOrReplacements;
    retry?: Options;
    supportsSearchPath?: boolean;
    transaction?: null | Transaction;
    useMaster?: boolean;
    where?: WhereOptions<TAttributes>;
}

Type Parameters

  • TAttributes = any

Hierarchy (view full)

Properties

[COMPLETES_TRANSACTION]? benchmark? bind? connection? fieldMap? instance? limit? logging? mapToModel? nest? offset? plain? replacements? retry? supportsSearchPath? transaction? useMaster? where?

Properties

Private Optional [COMPLETES_TRANSACTION]

[COMPLETES_TRANSACTION]?: boolean

Indicates if the query completes the transaction Internal only

Optional benchmark

benchmark?: boolean

Pass query execution time in milliseconds as second argument to logging function (options.logging).

Optional bind

bind?: BindOrReplacements

Either an object of named parameter bindings in the format $param or an array of unnamed values to bind to $1, $2, etc in your SQL.

Optional connection

connection?: null | AbstractConnection

The connection on which this query must be run. Mutually exclusive with Transactionable.transaction.

Can be used to ensure that a query is run on the same connection as a previous query, which is useful when configuring session options.

Specifying this option takes precedence over CLS Transactions. If a transaction is running in the current AsyncLocalStorage context, it will be ignored in favor of the specified connection.

Optional fieldMap

fieldMap?: FieldMap

Map returned fields to arbitrary names for SELECT query type if options.fieldMaps is present.

Optional instance

instance?: Model<any, any>

A sequelize instance used to build the return instance

Optional limit

limit?: number | Nullish | Literal

Optional logging

logging?: false | ((sql, timing?) => void)

A function that gets executed while running the query to log the sql.

Type declaration

    • (sql, timing?): void

    • Parameters

      • sql: string
      • Optional timing: number

      Returns void

Optional mapToModel

mapToModel?: boolean

Map returned fields to model's fields if options.model or options.instance is present. Mapping will occur before building the model instance.

Optional nest

nest?: boolean

If true, transforms objects with . separated property names into nested objects using dottie.js. For example { 'user.username': 'john' } becomes { user: { username: 'john' }}. When nest is true, the query type is assumed to be 'SELECT', unless otherwise specified

Default

false

Optional offset

offset?: number | Nullish | Literal

Optional plain

plain?: boolean

Sets the query type to SELECT and return a single row

Optional replacements

replacements?: BindOrReplacements

Optional retry

retry?: Options

Optional supportsSearchPath

supportsSearchPath?: boolean

If false do not prepend the query with the search_path (Postgres only)

Optional transaction

transaction?: null | Transaction

The transaction in which this query must be run. Mutually exclusive with Transactionable.connection.

If the Sequelize disableClsTransactions option has not been set to true, and a transaction is running in the current AsyncLocalStorage context, that transaction will be used, unless null or another Transaction is manually specified here.

Optional useMaster

useMaster?: boolean

Force the query to use the write pool, regardless of the query type.

Default

false

Optional where

where?: WhereOptions<TAttributes>

The WHERE clause. Can be many things from a hash of attributes to raw SQL.

Visit https://sequelize.org/docs/v7/core-concepts/model-querying-basics/ for more information.

Settings

Member Visibility

Theme

On This Page

[COMPLETES_TRANSACTION]benchmarkbindconnectionfieldMapinstancelimitloggingmapToModelnestoffsetplainreplacementsretrysupportsSearchPathtransactionuseMasterwhere