@_lukepatrick/postgraphile-upsert-plugin 中文文档教程

Question

postgraphile-upsert-plugin

将 postgres upsert 突变添加到 postgraphile。

Getting Started

Install

yarn add @fullstackio/postgraphile-upsert-plugin

CLI

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

见 此处 有关使用 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

此插件使用 where 子句创建对 upsert 的添加操作，这是对表的任何唯一约束。 支持多列唯一索引。

Example

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

upsert 看起来像这样：

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 jashmenn/postgraphile-upsert-plugin
• Which itself is a fork of the TypeScript postgraphile-upsert-plugin
• Which itself is a fork of the original upsert plugin