import { t } from "@tailor-platform/sdk";
import { defineSchema } from "@tailor-platform/sdk/seed";
import { createTailorDBHook, createStandardSchema } from "@tailor-platform/sdk/test";
import { inboundShipmentLine } from "../../src/modules-db";

const schemaType = t.object({
  ...inboundShipmentLine.pickFields(["id"], { optional: true }),
  ...inboundShipmentLine.omitFields(["id"]),
});

export const hook = createTailorDBHook(inboundShipmentLine);

export const schema = defineSchema(
  createStandardSchema(schemaType, hook, inboundShipmentLine),
  {
    foreignKeys: [
      {"column":"inboundShipmentId","references":{"table":"InboundShipment","column":"id"}},
      {"column":"itemId","references":{"table":"Item","column":"id"}},
      {"column":"unitId","references":{"table":"Unit","column":"id"}},
      {"column":"primaryUnitId","references":{"table":"Unit","column":"id"}},
      {"column":"storageLocationId","references":{"table":"StorageLocation","column":"id"}},
    ],
    indexes: [
      {"name":"inbound_shipment_line_source_idx","columns":["sourceDocumentType","sourceDocumentId","sourceLineId"],"unique":false},
    ],
  }
);