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

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

export const hook = createTailorDBHook(accountReceivableSettlement);

export const schema = defineSchema(
  createStandardSchema(schemaType, hook, accountReceivableSettlement),
  {
    foreignKeys: [
      {"column":"incomingPaymentId","references":{"table":"IncomingPayment","column":"id"}},
      {"column":"accountReceivableDueScheduleLineId","references":{"table":"AccountReceivableDueScheduleLine","column":"id"}},
      {"column":"reversalOfSettlementId","references":{"table":"AccountReceivableSettlement","column":"id"}},
    ],
    indexes: [
      {"name":"accountreceivablesettlement_reversalOfSettlementId_unique_idx","columns":["reversalOfSettlementId"],"unique":true},
      {"name":"account_receivable_settlement_incoming_payment_due_schedule_idx","columns":["sourceType","incomingPaymentId","accountReceivableDueScheduleLineId"],"unique":false},
    ],
  }
);