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.