Private
Optional
[COMPLETES_Indicates if the query completes the transaction Internal only
Optional
benchmarkPass query execution time in milliseconds as second argument to logging function (options.logging).
Optional
bindEither 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
cascadeOptional
connectionThe 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 returned fields to arbitrary names for SELECT query type if options.fieldMaps
is present.
Optional
ifOptional
instanceA sequelize instance used to build the return instance
Optional
loggingA function that gets executed while running the query to log the sql.
Optional
timing: numberOptional
mapMap returned fields to model's fields if options.model
or options.instance
is present.
Mapping will occur before building the model instance.
Optional
nestIf 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
false
Optional
plainSets the query type to SELECT
and return a single row
Optional
rawIf true, sequelize will not try to format the results of the query, or build an instance of a model from the result
Optional
retryOptional
supportsIf false do not prepend the query with the search_path (Postgres only)
Optional
transactionThe 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
typeThe type of query you are executing. The query type affects how results are formatted before they are
passed back. The type is a string, but Sequelize.QueryTypes
is provided as convenience shortcuts.
Optional
useForce the query to use the write pool, regardless of the query type.
false
Options accepted by AbstractQueryInterface#dropSchema