首页 > 解决方案 > DynamoDB 如何获取项目及其相关项目的关系?

问题描述

我想知道如何在单个响应中获取带有 dynamoDB 的项目以及相关项目。我有这两种类型:

type User @model {
  typeUserID: ID!
  type: [TypeUser] @connection(fields: ["typeUserID"])
}

type TypeUser @model {
  userID: ID!
  user: [User] @connection(fields: ["userID"])
}

一个查询:

  const { Item } = await db.get({
    Key: {
      "id": userID,
    },
    TableName: User
  }).promise();

我收到:

{
  typeUserID: 'sjhsgd6876-djshg5679ksjds-76576HJHGF',
  id: 'djhssb7HGV-JHS7987sjhs-sjhsgd6876'
}

但我想拥有它:

{
  typeUserID: 'sjhsgd6876-djshg5679ksjds-76576HJHGF',
  typeUser: {
    id: 'sjhsgd6876-djshg5679ksjds-76576HJHGF'
  },
  id: 'djhssb7HGV-JHS7987sjhs-sjhsgd6876'
}

标签: amazon-dynamodbaws-amplifydynamodb-queries

解决方案


推荐阅读