Options
All
  • Public
  • Public/Protected
  • All
Menu

Interface FindOrCreateOptions<TAttributes, TCreationAttributes>

Options for Model.findOrCreate method

Type parameters

  • TAttributes = any

  • TCreationAttributes = TAttributes

Hierarchy

Index

Properties

Properties

Optional attributes

attributes?: FindAttributeOptions

If an array: a list of the attributes that you want to select. Attributes can also be raw SQL (literal), fn, and col

To rename an attribute, you can pass an array, with two elements:

  • The first is the name of the attribute (or literal, fn, col),
  • and the second is the name to give to that attribute in the returned instance.

If include is used: selects all the attributes of the model, plus some additional ones. Useful for aggregations.

example
{ attributes: { include: [[literal('COUNT(id)'), 'total']] }

If exclude is used: selects all the attributes of the model, except the one specified in exclude. Useful for security purposes

example
{ attributes: { exclude: ['password'] } }

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 defaults

defaults?: TCreationAttributes

Default values to use if building a new instance

Optional fieldMap

fieldMap?: FieldMap

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

Optional fields

fields?: keyof TAttributes[]

If set, only columns matching those in fields will be saved

Optional group

group?: GroupOption

GROUP BY in sql

Optional groupedLimit

groupedLimit?: unknown

Optional having

having?: WhereOptions<any>

Select group rows after groups and aggregates are computed.

Optional hooks

hooks?: boolean

If false the applicable hooks will not be called. The default value depends on the context.

default

true

Optional ignoreDuplicates

ignoreDuplicates?: boolean

dialect specific ON CONFLICT DO NOTHING / INSERT IGNORE

Optional include

include?: AllowArray<Includeable>

A list of associations to eagerly load using a left join (a single association is also supported).

See Includeable to see how to specify the association, and its eager-loading options.

Optional indexHints

indexHints?: IndexHint[]

MySQL only.

Optional instance

instance?: Model<any, any>

A sequelize instance used to build the return instance

Optional isNewRecord

isNewRecord?: boolean

Is this record new

Optional limit

limit?: Nullish<number | Literal>

Limits how many items will be retrieved by the operation.

If limit and include are used together, Sequelize will turn the subQuery option on by default. This is done to ensure that limit only impacts the Model on the same level as the limit option.

You can disable this behavior by explicitly setting subQuery: false, however limit will then affect the total count of returned values, including eager-loaded associations, instead of just one table.

example
// in the following query, `limit` only affects the "User" model.
// This will return 2 users, each including all of their projects.
User.findAll({
  limit: 2,
  include: [User.associations.projects],
});
example
// in the following query, `limit` affects the total number of returned values, eager-loaded associations included.
// This may return 2 users, each with one project,
//  or 1 user with 2 projects.
User.findAll({
  limit: 2,
  include: [User.associations.projects],
  subQuery: false,
});

Optional lock

lock?: boolean | LOCK | { level: LOCK; of: ModelStatic<Model<any, any>> }

Lock the selected rows. Possible options are transaction.LOCK.UPDATE and transaction.LOCK.SHARE. Postgres also supports transaction.LOCK.KEY_SHARE, transaction.LOCK.NO_KEY_UPDATE and specific model locks with joins. See LOCK.

Optional logging

logging?: boolean | ((sql: string, timing?: number) => void)

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

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 | Literal

Skip the first n items of the results.

Optional order

order?: Order

Specifies an ordering. If a string is provided, it will be escaped.

Using an array, you can provide several attributes / functions to order by. Each element can be further wrapped in a two-element array:

  • The first element is the column / function to order by,
  • the second is the direction.
example

order: [['name', 'DESC']].

The attribute will be escaped, but the direction will not.

Optional paranoid

paranoid?: boolean

If true, only non-deleted records will be returned. If false, both deleted and non-deleted records will be returned.

Only applies if InitOptions.paranoid is true for the model.

default

true

Optional plain

plain?: boolean

Sets the query type to SELECT and return a single row

Optional raw

raw?: boolean

Return raw result. See {@link Sequelize#query} for more information.

Optional rejectOnEmpty

rejectOnEmpty?: boolean | Error

Throws an error if the query would return 0 results.

Optional replacements

replacements?: BindOrReplacements

Either an object of named parameter replacements in the format :param or an array of unnamed replacements to replace ? in your SQL.

Optional retry

retry?: RetryOptions

Optional returning

returning?: boolean | keyof TAttributes[]

Return the affected rows (only for postgres)

Optional searchPath

searchPath?: string

An optional parameter to specify the schema search_path (Postgres only)

Optional silent

silent?: boolean

If true, the updatedAt timestamp will not be updated.

default

false

Optional skipLocked

skipLocked?: boolean

Skip locked rows. Only supported in Postgres.

Optional subQuery

subQuery?: boolean

Use sub queries (internal).

If unspecified, this will true by default if limit is specified, and false otherwise. See {@link FindOptions#limit} for more information.

Optional transaction

transaction?: null | Transaction

The transaction in which this query must be run.

If CLS is enabled and a transaction is running in the current CLS context, that transaction will be used, unless null or a Transaction is manually specified here.

Optional type

type?: string

The 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 useMaster

useMaster?: boolean

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

default

false

Optional validate

validate?: boolean

If false, validations won't be run.

default

true

Optional where

where?: WhereOptions<TAttributes>

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

Generated using TypeDoc