对的NestJS TypeORM Post请求具有多个直通类型关系

Question

我正试图实现与自定义字段的多对多关系，就像下面演示的那样。我的数据与他给出的例子不同，但是关系的结构是相同的。我能够成功地创建关系，但我有一个问题，即产品（product_id）的外键为空，即使客户端正在为该字段发送数据。出于某种原因，TypeORM正在删除它并输入空值。

以下是连接表的结构：

@Entity()
export class ShipmentProduct {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  qty: number;

  @Column()
  pick_up: boolean;

  @ManyToOne(type => Shipment, shipment => shipment.shipmentProducts)
  @JoinColumn({ name: 'shipment_id' })
  shipment: Shipment;

  @ManyToOne(type => Product, product => product.shipmentProducts)
  @JoinColumn({ name: 'product_id' })
  product: Product;

}

我的服务通过以下功能提交数据：

 async create(shipmentData: CreateShipmentDto): Promise<Shipment> {
   const shipment = new Shipment();
   shipment.bill_of_lading = shipmentData.bill_of_lading;
   shipment.trailer_number = shipmentData.trailer_number;
   shipment.ship_date = shipmentData.ship_date;
   shipment.delivery_date = shipmentData.delivery_date;
   shipment.carrier = shipmentData.carrier;
   shipment.release_code = shipmentData.release_code;
   shipment.payment_date = shipmentData.payment_date;
   shipment.comments = shipmentData.comments;
   shipment.client = await this.clientsRepository.findOne(shipmentData.client_id);
   shipment.shipmentProducts = shipmentData.shipmentProducts;

   return await this.shipmentsRepository.save(shipment);
 }

提交表单时，装运数据将与shipmentProducts一起成功保存，但即使shipmentData包含product_id的值，也会删除product_id。

这是一个控制台。shipmentData日志

{
  client_id: 1,
  bill_of_lading: '12',
  trailer_number: '21',
  ship_date: '2020-04-02T04:00:00.000Z',
  delivery_date: '',
  carrier: '21',
  release_code: '21',
  fuel_surcharge: '21',
  payment_date: '',
  comments: '',
  shipmentProducts: [
    { product_id: 1966, qty: '12', pick_up: false },
    { product_id: 1966, qty: '12', pick_up: false }
  ]
}

但是，shimentProducts的插入语句省略了product_id，并坚持使用缺省值。为什么啊？我要怎么修？

INSERT INTO `shipment_product`(`id`, `qty`, `pick_up`, `shipment_id`, `product_id`) VALUES (DEFAULT, ?, ?, ?, DEFAULT) -- PARAMETERS: ["12",0,10]

Answer 1

这是很常见的问题。

有用的解决方法是使用：

js prettyprint-override">@Entity()
export class ShipmentProduct {
  @PrimaryGeneratedColumn()
  id: number;

  @ManyToOne(type => Product, product => product.shipmentProducts)
  @JoinColumn({ name: 'product_id' })
  product: Product;

  @Column({name: 'product_id'})
  productId: Product['id'];
}

所以您可以直接传递productId。

Answer 2

事实证明，我需要在post请求中至少发送一部分产品对象，而不仅仅是产品id。所以这似乎起到了作用。问题出在客户端，而不是NestJS或TypeORM。

shipmentProducts: [
  { product: { id:1966 }, qty: 12, pick_up: false }
  { product: { id:1845 }, qty: 20, pick_up: false }
]