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": {
    BusinessPartner: {
      id: Generated<string>;
      name: string;
      type: "ORGANIZATION" | "INDIVIDUAL";
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CustomerAccount: {
      id: Generated<string>;
      partnerId: string;
      companyId: string;
      code: string;
      name: string;
      preferredCurrencyId: string | null;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CustomerAddressUsage: {
      id: Generated<string>;
      accountId: string;
      addressId: string;
      purpose: "BILL_TO" | "SHIP_TO";
      isDefault: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CustomerBankAccountUsage: {
      id: Generated<string>;
      accountId: string;
      bankAccountId: string;
      purpose: "RECEIPT" | "REFUND";
      isDefault: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PartnerAddress: {
      id: Generated<string>;
      partnerId: string;
      active: boolean;
      line1: string;
      line2: string | null;
      city: string;
      state: string | null;
      postalCode: string;
      country: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    PartnerBankAccount: {
      id: Generated<string>;
      partnerId: string;
      active: boolean;
      bankName: string;
      accountHolderName: string;
      accountNumber: string;
      routingNumber: string | null;
      currencyId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SupplierAccount: {
      id: Generated<string>;
      partnerId: string;
      companyId: string;
      code: string;
      name: string;
      preferredCurrencyId: string | null;
      defaultExpenseAccountId: string | null;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SupplierAddressUsage: {
      id: Generated<string>;
      accountId: string;
      addressId: string;
      purpose: "ORDER_FROM" | "REMIT_TO" | "SHIP_FROM" | "RETURN_TO";
      isDefault: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    SupplierBankAccountUsage: {
      id: Generated<string>;
      accountId: string;
      bankAccountId: string;
      purpose: "PAYMENT" | "REFUND";
      isDefault: boolean;
      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>;