import { Database } from '../Database';
import { QueryArray } from '../QueryArray';
import { Reactive } from '../Reactive';
import type {
  Entities,
  FieldsSelect,
  QueryOptions,
  QueryResult,
  UpperOptions,
} from './types';

export class Upper<T extends Entities> {
  private db: Database<T>;

  constructor(options: UpperOptions<T>) {
    this.db = Database.getInstance(options);
  }

  Query<Entity extends keyof T, Fields extends FieldsSelect<T[Entity]>>(
    entityName: Entity,
    options?: QueryOptions<T[Entity], Fields>
  ): QueryArray<QueryResult<T[Entity], Fields>> {
    const rows = this.db.select(entityName as string, options);

    const upperRows = Reactive.array(rows, entityName as string);

    return Reactive.create(upperRows, entityName as string) as any;
  }

  QueryOne<Entity extends keyof T, Fields extends FieldsSelect<T[Entity]>>(
    entityName: Entity,
    options?: QueryOptions<T[Entity], Fields>
  ): InstanceType<T[Entity]> {
    const row = this.db.selectOne(entityName as string, options);

    return Reactive.create(row, entityName as string);
  }
}