AutoIncrement

An automatically incrementing integer with support for the Prisma adapter. It's important to note that this type:

• Has important limitations due to varying support from the underlying DB platform
• Has non-standard defaults for much of its configuration

Currently, outside its use as a primary key, this field type will only work on PostgreSQL.

Limitations

The majority of DB platforms allow only a single automatically incrementing column per table. At time of writing (2019-07-11) this is true of SQLite, MySQL, SQL Server, Oracle, and MariaDB. Further, it is often assumed these columns are the tables primary key. On several platforms (eg. SQLite) auto increment functionality is only available for primary keys.

Of the DB platforms supported by Knex, only PostgreSQL and Amazon Redshift supports multiple auto incrementing columns.

Non-standard defaults

The configuration for AutoIncrement fields has different default values than most field types. Specifically:

• isUnique defaults to true -- As unique values are generated by the DB it's assumed this uniqueness should be enforced with a unique constraint.
• isNotNullable defaults to true -- Likewise, it's assumed values will never be updated or explicitly set to null. The column is set to be not nullable to enforce this.
• Read only -- It's assumed AutoIncrement are not intended to be writable. Some DB platform will error if you attempt to update columns created by this type. Further, if the column has a unique constraint (as is the default; see isUnique in config above) inserting arbitrary values may cause errors when later records are created. As such, fields using this type default to being read-only. This is implemented by defaulting the create, update and delete field-level access control config to false.

Usage

const { Keystone } = require('@keystone-next/keystone-legacy');
const { AutoIncrement } = require('@keystone-next/fields-auto-increment-legacy');
const { Text } = require('@keystone-next/fields-legacy');

const keystone = new Keystone({...});

keystone.createList('Order', {
  fields: {
    name: { type: Text },
    orderNumber: { type: AutoIncrement, gqlType: 'Int' },
  },
});

Config

Option	Type	Default	Description
isRequired	Boolean	false	Does this field require a value?
isUnique	Boolean	true	Adds a unique index that allows only unique values to be stored
gqlType	String	Int or ID	The GraphQL to be used by this field. Defaults to ID for primary keys or Int otherwise.

Admin UI

AutoIncrement fields reuse the interface implementation from the native Integer field.

GraphQL

AutoIncrement fields can use the Int or ID GraphQL types. This can be specified using the gqlType config option if needed. The default is ID for primary key fields and Int otherwise.

Input fields

AutoIncrement fields are read-only by default. As such, input fields and types may not be added to the GraphQL schema. See the non-standard defaults section for details.

Field name	Type	Description
${path}	Int or ID	The integer value to save

Output fields

Field name	Type	Description
${path}	Int or ID	The integer value stored

Filters

Field name	Type	Description
${path}	Int or ID	Exact match to the value provided
${path}_not	Int or ID	Not an exact match to the value provided
${path}_lt	Int or ID	Less than the value provided
${path}_lte	Int or ID	Less than or equal to the value provided
${path}_gt	Int or ID	Greater than the value provided
${path}_gte	Int or ID	Greater or equal to than the value provided
${path}_in	[Int] or [ID]	In the array of integers provided
${path}_not_in	[Int] or [ID]	Not in the array of integers provided