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

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

export const hook = createTailorDBHook(accountReceivableDocument);

export const schema = defineSchema(
  createStandardSchema(schemaType, hook, accountReceivableDocument),
  {
    foreignKeys: [
      {"column":"companyId","references":{"table":"Company","column":"id"}},
      {"column":"customerAccountId","references":{"table":"CustomerAccount","column":"id"}},
      {"column":"currencyId","references":{"table":"Currency","column":"id"}},
      {"column":"receivableControlAccountId","references":{"table":"Account","column":"id"}},
      {"column":"correctionOfId","references":{"table":"AccountReceivableDocument","column":"id"}},
    ],
    indexes: [
      {"name":"accountreceivabledocument_documentNumber_unique_idx","columns":["documentNumber"],"unique":true},
    ],
  }
);