@fullstackio/postgraphile-upsert-plugin
v1.4.0
Published
add postgres upsert mutations to postgraphile
Downloads
121
Maintainers
Readme
postgraphile-upsert-plugin
add postgres upsert
mutations to postgraphile
Getting Started
Install
yarn add @fullstackio/postgraphile-upsert-plugin
CLI
postgraphile --append-plugins @fullstackio/postgraphile-upsert-plugin:PgMutationUpsertPlugin
See here for more information about loading plugins with PostGraphile.
Library
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<Table>
using a where
clause, which is any unique constraint on the table.
Example
create table bikes (
id serial PRIMARY KEY,
"serialNumber" varchar UNIQUE NOT NULL,
weight real,
make varchar,
model varchar
)
An upsert would look like this:
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