Mutation Operations

Mutations define the write operations for modifying data in a GraphQL schema.

Data Connect Generated

basicTable_delete: BasicTable_KeyOutput

✨ Delete a single BasicTable based on id, key or first and return its key (or null if not found).

Field	Type	Description
id	UUID	The unique ID of the object.
key	BasicTable_Key	The key used to identify the object.
first	BasicTable_FirstRow	Fetch the first row based on the filters and ordering.

basicTable_deleteMany: Int!

✨ Delete BasicTable objects matching where conditions (or all, if true). Returns the number of rows deleted.

Field	Type	Description
where	BasicTable_Filter	Filter condition to specify which rows to delete.
all	Boolean	Set to true to delete all rows.

basicTable_insert: BasicTable_KeyOutput!

✨ Insert a single BasicTable into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	BasicTable_Data!	Data object to insert into the table.

basicTable_insertMany: [BasicTable_KeyOutput!]!

✨ Insert BasicTable objects into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	[BasicTable_Data!]!	List of data objects to insert into the table.

basicTable_update: BasicTable_KeyOutput

✨ Update a single BasicTable based on id, key or first, setting columns specified in data. Returns null if not found.

Field	Type	Description
id	UUID	The unique ID of the object.
key	BasicTable_Key	The key used to identify the object.
first	BasicTable_FirstRow	Fetch the first row based on the filters and ordering.
data	BasicTable_Data!	Data object containing fields to be updated.

basicTable_updateMany: Int!

✨ Update BasicTable objects matching where conditions (or all, if true) according to data. Returns the number of rows updated.

Field	Type	Description
where	BasicTable_Filter	Filter condition to specify which rows to update.
all	Boolean	Set to true to update all rows.
data	BasicTable_Data!	Data object containing fields to update.

basicTable_upsert: BasicTable_KeyOutput!

✨ Insert or update a single BasicTable into the table, based on the primary key. Returns the key of the newly inserted BasicTable.

Field	Type	Description
data	BasicTable_Data!	Data object to insert or update if it already exists.

basicTable_upsertMany: [BasicTable_KeyOutput!]!

✨ Insert or update BasicTable objects into the table, based on the primary key. Returns the key of the newly inserted BasicTable.

Field	Type	Description
data	[BasicTable_Data!]	List of data objects to insert or update.

joinTable_delete: JoinTable_KeyOutput

✨ Delete a single JoinTable based on id, key or first and return its key (or null if not found).

Field	Type	Description
key	JoinTable_Key	The key used to identify the object.
first	JoinTable_FirstRow	Fetch the first row based on the filters and ordering.

joinTable_deleteMany: Int!

✨ Delete JoinTable objects matching where conditions (or all, if true). Returns the number of rows deleted.

Field	Type	Description
where	JoinTable_Filter	Filter condition to specify which rows to delete.
all	Boolean	Set to true to delete all rows.

joinTable_insert: JoinTable_KeyOutput!

✨ Insert a single JoinTable into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	JoinTable_Data!	Data object to insert into the table.

joinTable_insertMany: [JoinTable_KeyOutput!]!

✨ Insert JoinTable objects into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	[JoinTable_Data!]!	List of data objects to insert into the table.

joinTable_update: JoinTable_KeyOutput

✨ Update a single JoinTable based on id, key or first, setting columns specified in data. Returns null if not found.

Field	Type	Description
key	JoinTable_Key	The key used to identify the object.
first	JoinTable_FirstRow	Fetch the first row based on the filters and ordering.
data	JoinTable_Data!	Data object containing fields to be updated.

joinTable_updateMany: Int!

✨ Update JoinTable objects matching where conditions (or all, if true) according to data. Returns the number of rows updated.

Field	Type	Description
where	JoinTable_Filter	Filter condition to specify which rows to update.
all	Boolean	Set to true to update all rows.
data	JoinTable_Data!	Data object containing fields to update.

joinTable_upsert: JoinTable_KeyOutput!

✨ Insert or update a single JoinTable into the table, based on the primary key. Returns the key of the newly inserted JoinTable.

Field	Type	Description
data	JoinTable_Data!	Data object to insert or update if it already exists.

joinTable_upsertMany: [JoinTable_KeyOutput!]!

✨ Insert or update JoinTable objects into the table, based on the primary key. Returns the key of the newly inserted JoinTable.

Field	Type	Description
data	[JoinTable_Data!]	List of data objects to insert or update.

leftTable_delete: LeftTable_KeyOutput

✨ Delete a single LeftTable based on id, key or first and return its key (or null if not found).

Field	Type	Description
id	UUID	The unique ID of the object.
key	LeftTable_Key	The key used to identify the object.
first	LeftTable_FirstRow	Fetch the first row based on the filters and ordering.

leftTable_deleteMany: Int!

✨ Delete LeftTable objects matching where conditions (or all, if true). Returns the number of rows deleted.

Field	Type	Description
where	LeftTable_Filter	Filter condition to specify which rows to delete.
all	Boolean	Set to true to delete all rows.

leftTable_insert: LeftTable_KeyOutput!

✨ Insert a single LeftTable into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	LeftTable_Data!	Data object to insert into the table.

leftTable_insertMany: [LeftTable_KeyOutput!]!

✨ Insert LeftTable objects into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	[LeftTable_Data!]!	List of data objects to insert into the table.

leftTable_update: LeftTable_KeyOutput

✨ Update a single LeftTable based on id, key or first, setting columns specified in data. Returns null if not found.

Field	Type	Description
id	UUID	The unique ID of the object.
key	LeftTable_Key	The key used to identify the object.
first	LeftTable_FirstRow	Fetch the first row based on the filters and ordering.
data	LeftTable_Data!	Data object containing fields to be updated.

leftTable_updateMany: Int!

✨ Update LeftTable objects matching where conditions (or all, if true) according to data. Returns the number of rows updated.

Field	Type	Description
where	LeftTable_Filter	Filter condition to specify which rows to update.
all	Boolean	Set to true to update all rows.
data	LeftTable_Data!	Data object containing fields to update.

leftTable_upsert: LeftTable_KeyOutput!

✨ Insert or update a single LeftTable into the table, based on the primary key. Returns the key of the newly inserted LeftTable.

Field	Type	Description
data	LeftTable_Data!	Data object to insert or update if it already exists.

leftTable_upsertMany: [LeftTable_KeyOutput!]!

✨ Insert or update LeftTable objects into the table, based on the primary key. Returns the key of the newly inserted LeftTable.

Field	Type	Description
data	[LeftTable_Data!]	List of data objects to insert or update.

manyTable_delete: ManyTable_KeyOutput

✨ Delete a single ManyTable based on id, key or first and return its key (or null if not found).

Field	Type	Description
id	UUID	The unique ID of the object.
key	ManyTable_Key	The key used to identify the object.
first	ManyTable_FirstRow	Fetch the first row based on the filters and ordering.

manyTable_deleteMany: Int!

✨ Delete ManyTable objects matching where conditions (or all, if true). Returns the number of rows deleted.

Field	Type	Description
where	ManyTable_Filter	Filter condition to specify which rows to delete.
all	Boolean	Set to true to delete all rows.

manyTable_insert: ManyTable_KeyOutput!

✨ Insert a single ManyTable into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	ManyTable_Data!	Data object to insert into the table.

manyTable_insertMany: [ManyTable_KeyOutput!]!

✨ Insert ManyTable objects into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	[ManyTable_Data!]!	List of data objects to insert into the table.

manyTable_update: ManyTable_KeyOutput

✨ Update a single ManyTable based on id, key or first, setting columns specified in data. Returns null if not found.

Field	Type	Description
id	UUID	The unique ID of the object.
key	ManyTable_Key	The key used to identify the object.
first	ManyTable_FirstRow	Fetch the first row based on the filters and ordering.
data	ManyTable_Data!	Data object containing fields to be updated.

manyTable_updateMany: Int!

✨ Update ManyTable objects matching where conditions (or all, if true) according to data. Returns the number of rows updated.

Field	Type	Description
where	ManyTable_Filter	Filter condition to specify which rows to update.
all	Boolean	Set to true to update all rows.
data	ManyTable_Data!	Data object containing fields to update.

manyTable_upsert: ManyTable_KeyOutput!

✨ Insert or update a single ManyTable into the table, based on the primary key. Returns the key of the newly inserted ManyTable.

Field	Type	Description
data	ManyTable_Data!	Data object to insert or update if it already exists.

manyTable_upsertMany: [ManyTable_KeyOutput!]!

✨ Insert or update ManyTable objects into the table, based on the primary key. Returns the key of the newly inserted ManyTable.

Field	Type	Description
data	[ManyTable_Data!]	List of data objects to insert or update.

maybeTable_delete: MaybeTable_KeyOutput

✨ Delete a single MaybeTable based on id, key or first and return its key (or null if not found).

Field	Type	Description
id	UUID	The unique ID of the object.
key	MaybeTable_Key	The key used to identify the object.
first	MaybeTable_FirstRow	Fetch the first row based on the filters and ordering.

maybeTable_deleteMany: Int!

✨ Delete MaybeTable objects matching where conditions (or all, if true). Returns the number of rows deleted.

Field	Type	Description
where	MaybeTable_Filter	Filter condition to specify which rows to delete.
all	Boolean	Set to true to delete all rows.

maybeTable_insert: MaybeTable_KeyOutput!

✨ Insert a single MaybeTable into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	MaybeTable_Data!	Data object to insert into the table.

maybeTable_insertMany: [MaybeTable_KeyOutput!]!

✨ Insert MaybeTable objects into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	[MaybeTable_Data!]!	List of data objects to insert into the table.

maybeTable_update: MaybeTable_KeyOutput

✨ Update a single MaybeTable based on id, key or first, setting columns specified in data. Returns null if not found.

Field	Type	Description
id	UUID	The unique ID of the object.
key	MaybeTable_Key	The key used to identify the object.
first	MaybeTable_FirstRow	Fetch the first row based on the filters and ordering.
data	MaybeTable_Data!	Data object containing fields to be updated.

maybeTable_updateMany: Int!

✨ Update MaybeTable objects matching where conditions (or all, if true) according to data. Returns the number of rows updated.

Field	Type	Description
where	MaybeTable_Filter	Filter condition to specify which rows to update.
all	Boolean	Set to true to update all rows.
data	MaybeTable_Data!	Data object containing fields to update.

maybeTable_upsert: MaybeTable_KeyOutput!

✨ Insert or update a single MaybeTable into the table, based on the primary key. Returns the key of the newly inserted MaybeTable.

Field	Type	Description
data	MaybeTable_Data!	Data object to insert or update if it already exists.

maybeTable_upsertMany: [MaybeTable_KeyOutput!]!

✨ Insert or update MaybeTable objects into the table, based on the primary key. Returns the key of the newly inserted MaybeTable.

Field	Type	Description
data	[MaybeTable_Data!]	List of data objects to insert or update.

oneTable_delete: OneTable_KeyOutput

✨ Delete a single OneTable based on id, key or first and return its key (or null if not found).

Field	Type	Description
id	UUID	The unique ID of the object.
key	OneTable_Key	The key used to identify the object.
first	OneTable_FirstRow	Fetch the first row based on the filters and ordering.

oneTable_deleteMany: Int!

✨ Delete OneTable objects matching where conditions (or all, if true). Returns the number of rows deleted.

Field	Type	Description
where	OneTable_Filter	Filter condition to specify which rows to delete.
all	Boolean	Set to true to delete all rows.

oneTable_insert: OneTable_KeyOutput!

✨ Insert a single OneTable into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	OneTable_Data!	Data object to insert into the table.

oneTable_insertMany: [OneTable_KeyOutput!]!

✨ Insert OneTable objects into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	[OneTable_Data!]!	List of data objects to insert into the table.

oneTable_update: OneTable_KeyOutput

✨ Update a single OneTable based on id, key or first, setting columns specified in data. Returns null if not found.

Field	Type	Description
id	UUID	The unique ID of the object.
key	OneTable_Key	The key used to identify the object.
first	OneTable_FirstRow	Fetch the first row based on the filters and ordering.
data	OneTable_Data!	Data object containing fields to be updated.

oneTable_updateMany: Int!

✨ Update OneTable objects matching where conditions (or all, if true) according to data. Returns the number of rows updated.

Field	Type	Description
where	OneTable_Filter	Filter condition to specify which rows to update.
all	Boolean	Set to true to update all rows.
data	OneTable_Data!	Data object containing fields to update.

oneTable_upsert: OneTable_KeyOutput!

✨ Insert or update a single OneTable into the table, based on the primary key. Returns the key of the newly inserted OneTable.

Field	Type	Description
data	OneTable_Data!	Data object to insert or update if it already exists.

oneTable_upsertMany: [OneTable_KeyOutput!]!

✨ Insert or update OneTable objects into the table, based on the primary key. Returns the key of the newly inserted OneTable.

Field	Type	Description
data	[OneTable_Data!]	List of data objects to insert or update.

rightTable_delete: RightTable_KeyOutput

✨ Delete a single RightTable based on id, key or first and return its key (or null if not found).

Field	Type	Description
id	UUID	The unique ID of the object.
key	RightTable_Key	The key used to identify the object.
first	RightTable_FirstRow	Fetch the first row based on the filters and ordering.

rightTable_deleteMany: Int!

✨ Delete RightTable objects matching where conditions (or all, if true). Returns the number of rows deleted.

Field	Type	Description
where	RightTable_Filter	Filter condition to specify which rows to delete.
all	Boolean	Set to true to delete all rows.

rightTable_insert: RightTable_KeyOutput!

✨ Insert a single RightTable into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	RightTable_Data!	Data object to insert into the table.

rightTable_insertMany: [RightTable_KeyOutput!]!

✨ Insert RightTable objects into the table. Columns not specified in data will receive defaults (e.g. null).

Field	Type	Description
data	[RightTable_Data!]!	List of data objects to insert into the table.

rightTable_update: RightTable_KeyOutput

✨ Update a single RightTable based on id, key or first, setting columns specified in data. Returns null if not found.

Field	Type	Description
id	UUID	The unique ID of the object.
key	RightTable_Key	The key used to identify the object.
first	RightTable_FirstRow	Fetch the first row based on the filters and ordering.
data	RightTable_Data!	Data object containing fields to be updated.

rightTable_updateMany: Int!

✨ Update RightTable objects matching where conditions (or all, if true) according to data. Returns the number of rows updated.

Field	Type	Description
where	RightTable_Filter	Filter condition to specify which rows to update.
all	Boolean	Set to true to update all rows.
data	RightTable_Data!	Data object containing fields to update.

rightTable_upsert: RightTable_KeyOutput!

✨ Insert or update a single RightTable into the table, based on the primary key. Returns the key of the newly inserted RightTable.

Field	Type	Description
data	RightTable_Data!	Data object to insert or update if it already exists.

rightTable_upsertMany: [RightTable_KeyOutput!]!

✨ Insert or update RightTable objects into the table, based on the primary key. Returns the key of the newly inserted RightTable.

Field	Type	Description
data	[RightTable_Data!]	List of data objects to insert or update.