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": {
    BankAccount: {
      id: Generated<string>;
      companyId: string;
      currencyId: string;
      cashAccountId: string;
      incomingClearingAccountId: string | null;
      outgoingClearingAccountId: string | null;
      bankName: string;
      accountNumberMasked: string;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    BankReconciliation: {
      id: Generated<string>;
      bankAccountId: string;
      reconciliationDate: Timestamp;
      confirmedAt: Timestamp;
      action: "RECONCILE" | "UNRECONCILE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    BankReconciliationItem: {
      id: Generated<string>;
      bankReconciliationId: string;
      sourceType: "BANK_STATEMENT_LINE" | "INCOMING_PAYMENT" | "OUTGOING_PAYMENT";
      sourceId: string;
      clearedAmount: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    BankStatement: {
      id: Generated<string>;
      bankAccountId: string;
      statementNumber: string;
      statementDate: Timestamp;
      openingBalance: string;
      closingBalance: string;
      importedAt: Timestamp;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    BankStatementLine: {
      id: Generated<string>;
      bankStatementId: string;
      lineNumber: number;
      bookingDate: Timestamp;
      valueDate: Timestamp | null;
      flowDirection: "CREDIT" | "DEBIT";
      amount: string;
      reconciliationStatus: "UNRECONCILED" | "RECONCILED";
      currentBankReconciliationId: string | null;
      bankReference: string | null;
      endToEndId: string | null;
      counterpartyName: string | null;
      counterpartyAccount: string | null;
      description: 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>;