postgraphile -如何启用多到多个关系字段

Question

我有Uploads桌。

Uploads与Parties表有many-to-many关系。

连接表是Uploads_Parties，它包含：upload_id & party_id作为字段。

在模式生成中，我如何使postgraphile考虑到这些关系？

尝试：

1. ，多到多插件- https://github.com/graphile-contrib/pg-many-to-many。在添加插件后，没有发生任何效果。
2. 智能标记插件- https://www.graphile.org/postgraphile/make-pg-smart-tags-plugin/ -我尝试在Uploads.upload_id -> Uploads_Parties.upload_id之间添加外键关系，但是在postgraphile中抛出一个错误。

服务器init代码

const SmartTagsPlugin = makePgSmartTagsFromFilePlugin(
  resolve(__dirname, '../../postgraphile.tags.jsonc'),
);
...
appendPlugins: [
        SmartTagsPlugin,
        PgManyToManyPlugin]
...

tags.jsonc

"config": {
    "class": {
      "upload_service.upload": {
        "tags": {
          "foreignKey": [
            "(id) references upload_service.uploads_parties (upload_id)|@fieldName uploadDataSet"
          ]
        }
      }
    }
  }

Answer 1

解决方案是tags.jsonc，只将fk指向相反的方向：uploads.upload_id <- uploads_parties.upload_id。

"config": {
    "class": {
      "upload_service.uploads_parties": {
        "tags": {
          "foreignKey": [
            "(upload_id) references upload_service.uploads (id)|@fieldName fileUpload"
          ]
        }
      }
    }
  }

我还有以下插件：

    pgSimplifyInflector,
    postgraphilePluginConnectionFilter,
    pgOrderByRelatedPlugin,
    pgAggregatesPlugin,