postgraphile-upsert-plugin

add postgres upsert mutations to postgraphile

   

Getting Started

$3

``bash
yarn add @fullstackio/postgraphile-upsert-plugin
`

$3

`bash
postgraphile --append-plugins @fullstackio/postgraphile-upsert-plugin:PgMutationUpsertPlugin
`

See here for
more information about loading plugins with PostGraphile.

$3

`js
const express = require("express");
const { postgraphile } = require("postgraphile");
const {
PgMutationUpsertPlugin
} = require("@fullstackio/postgraphile-upsert-plugin");

const app = express();

app.use(
postgraphile(pgConfig, schema, {
appendPlugins: [PgMutationUpsertPlugin]
})
);

app.listen(5000);
`

Usage

This plugin creates an addition operation to upsert

using a where clause, which is any unique constraint on the table.

Example

`sql
create table bikes (
id serial PRIMARY KEY,
"serialNumber" varchar UNIQUE NOT NULL,
weight real,
make varchar,
model varchar
)
`

An upsert would look like this:

`graphql
mutation {
upsertBike(
where: { serialNumber: "abc123" }
input: {
bike: {
serialNumber: "abc123"
weight: 25.6
make: "kona"
model: "cool-ie deluxe"
}
}
) {
clientMutationId
}
}
``

Credits

- This is a fork of the TypeScript postgraphile-upsert-plugin
- Which itself is a fork of the original upsert plugin