graphile-upsert-plugin

This postgraphile plugin adds root level mutations for upserting with an equivalent API to the standard Create/Update mutations (upsert${Table}) using postgres INSERT INTO ON CONFLICT UPDATE statements. It includes:

• A single record mutation index.js (original) --append-plugins graphile-upsert-plugin
• batch.js, which accepts a non-empty list of records --append-plugins graphile-upsert-plugin/batch
• batch-allow-empty.js which is the same but with empty values allowed --append-plugins graphile-upsert-plugin/batch-allow-empty The last two are the exact same, eventually the difference will just be a configuration but for now they're copy-pasted

If you add both via --append-plugins graphile-upsert-plugin,graphile-upsert-plugin/batch, your schema should look something like:

"""All input for the upsert `Event` batch mutation."""
# ...

input UpsertEventBatchInput {
  clientMutationId: String

  """
  The `Events` to be upserted by this mutation. Expects all records to conform to the structure of the first.
  """
  events: [EventInput!]!
}

# ...

type Mutation {
  # ...

  """Upserts a single `Event`."""
  upsertEvent(
    """
    The exclusive input argument for this mutation. An object type, make sure to see documentation for this object’s fields.
    """
    input: UpsertEventInput!
  ): UpsertEventPayload

  """Upserts a batch of `Events`."""
  upsertEventBatch(
    """
    The exclusive input argument for this mutation. An object type, make sure to see documentation for this object’s fields.
    """
    input: UpsertEventBatchInput!
  ): UpsertEventBatchPayload

  # ...
}

# ...