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": {
    AppointmentHistory: {
      id: Generated<string>;
      workerId: string;
      assignmentId: string;
      fromPositionId: string | null;
      toPositionId: string | null;
      appointmentTypeId: string;
      effectiveDate: Timestamp;
      issuedAt: Timestamp;
      appliedAt: Timestamp | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    AppointmentType: {
      id: Generated<string>;
      companyId: string;
      key: string;
      displayName: string;
      action: "CREATE_PRIMARY_ASSIGNMENT" | "CREATE_SECONDARY_ASSIGNMENT" | "CHANGE_ASSIGNMENT" | "END_ASSIGNMENT";
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Assignment: {
      id: Generated<string>;
      workerEmploymentId: string;
      positionId: string;
      isPrimary: boolean;
      effectiveStart: Timestamp;
      effectiveEnd: Timestamp | null;
      versionOf: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    EmploymentType: {
      id: Generated<string>;
      companyId: string;
      key: string;
      displayName: string;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    JobProfile: {
      id: Generated<string>;
      code: string;
      jobFamily: string;
      gradeReference: string;
      requirements: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Position: {
      id: Generated<string>;
      departmentId: string;
      siteId: string | null;
      jobProfileId: string;
      headcount: number;
      effectiveStart: Timestamp;
      effectiveEnd: Timestamp | null;
      versionOf: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    WorkRegime: {
      id: Generated<string>;
      companyId: string;
      key: string;
      displayName: string;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    WorkSchedule: {
      id: Generated<string>;
      assignmentId: string;
      scheduledDailyMinutes: number;
      scheduledWeeklyMinutes: number;
      effectiveStart: Timestamp;
      effectiveEnd: Timestamp | null;
      versionOf: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Worker: {
      id: Generated<string>;
      userId: string;
      workerCode: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    WorkerEmployment: {
      id: Generated<string>;
      workerId: string;
      companyId: string;
      employmentTypeId: string;
      workRegimeId: string;
      hireDate: Timestamp;
      terminationDate: Timestamp | null;
      effectiveStart: Timestamp;
      effectiveEnd: Timestamp | null;
      versionOf: string;
      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>;