import {
  createGetDB,
  type Generated,
  type Timestamp,
  type NamespaceDB,
  type NamespaceInsertable,
  type NamespaceSelectable,
  type NamespaceTable,
  type NamespaceTableName,
  type NamespaceTransaction,
  type NamespaceUpdateable,
} from "@tailor-platform/sdk/kysely";

export interface Namespace {
  "main-db": {
    PurchaseItem: {
      id: Generated<string>;
      itemId: string;
      requiresPhysicalReceipt: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseOrder: {
      id: Generated<string>;
      companyId: string;
      supplierAccountId: string;
      currencyId: string;
      receivingSiteId: string | null;
      orderStatus: "DRAFT" | "SUBMITTED" | "ORDERED" | "CANCELLED" | "CLOSED";
      receiptStatus: "NOT_RECEIVED" | "PARTIALLY_RECEIVED" | "RECEIVED" | null;
      billingStatus: "NOT_BILLED" | "PARTIALLY_BILLED" | "BILLED" | null;
      orderDate: Timestamp;
      externalSupplierOrderReference: string | null;
      supplierSnapshotName: string | null;
      rejectionReason: string | null;
      closeReason: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseOrderFieldChange: {
      id: Generated<string>;
      revisionId: string;
      recordType: "HEADER" | "LINE";
      recordId: string;
      fieldName: string;
      changeKind: "ADDED" | "MODIFIED" | "REMOVED";
      oldValue: string | null;
      newValue: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseOrderLine: {
      id: Generated<string>;
      purchaseOrderId: string;
      itemId: string;
      itemSnapshotName: string | null;
      itemSnapshotSku: string | null;
      quantity: string;
      unitPrice: string;
      unitId: string;
      receivingSiteId: string | null;
      requiresPhysicalReceipt: boolean;
      billedQuantity: Generated<string>;
      receivedQuantity: Generated<string>;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PurchaseOrderRevision: {
      id: Generated<string>;
      purchaseOrderId: string;
      revisionNumber: number;
      reason: string | null;
      amendedByUserId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }
  }
}

export const getDB = createGetDB<Namespace>();

export type DB<N extends keyof Namespace = keyof Namespace> = NamespaceDB<Namespace, N>;

export type Transaction<K extends keyof Namespace | DB = keyof Namespace> =
  NamespaceTransaction<Namespace, K>;

type TableName = NamespaceTableName<Namespace>;
export type Table<T extends TableName> = NamespaceTable<Namespace, T>;

export type Insertable<T extends TableName> = NamespaceInsertable<Namespace, T>;
export type Selectable<T extends TableName> = NamespaceSelectable<Namespace, T>;
export type Updateable<T extends TableName> = NamespaceUpdateable<Namespace, T>;