import type { CursorPaginator, Paginator, SimplePaginator } from './paginator';
import type { Operator } from './subquery';
export declare interface OrmDriver<T = unknown> {
  find: (id: number) => Promise<T | undefined>
  create: (data: Partial<T>) => Promise<T>
  update: (id: number, data: Partial<T>) => Promise<T | undefined>
  delete: (id: number) => Promise<boolean>
  all: () => Promise<T[]>
  where: (column: string, value: unknown) => Promise<T[]>
}
export declare interface SelectedQuery<TTable, TJson, K extends string> {
  where<V = string>(column: keyof TTable, ...args: [V] | [Operator, V]): SelectedQuery<TTable, TJson, K>
  orWhere(...conditions: [keyof TTable, any][]): SelectedQuery<TTable, TJson, K>
  whereIn<V = number>(column: keyof TTable, values: V[]): SelectedQuery<TTable, TJson, K>
  whereNotIn<V = number>(column: keyof TTable, values: V[]): SelectedQuery<TTable, TJson, K>
  whereBetween<V = number>(column: keyof TTable, range: [V, V]): SelectedQuery<TTable, TJson, K>
  whereRef(column: keyof TTable, ...args: string[]): SelectedQuery<TTable, TJson, K>
  when(condition: boolean, callback: (query: SelectedQuery<TTable, TJson, K>) => SelectedQuery<TTable, TJson, K>): SelectedQuery<TTable, TJson, K>
  whereNull(column: keyof TTable): SelectedQuery<TTable, TJson, K>
  whereNotNull(column: keyof TTable): SelectedQuery<TTable, TJson, K>
  whereLike(column: keyof TTable, value: string): SelectedQuery<TTable, TJson, K>
  orderBy(column: keyof TTable, order: 'asc' | 'desc'): SelectedQuery<TTable, TJson, K>
  orderByAsc(column: keyof TTable): SelectedQuery<TTable, TJson, K>
  orderByDesc(column: keyof TTable): SelectedQuery<TTable, TJson, K>
  groupBy(column: keyof TTable): SelectedQuery<TTable, TJson, K>
  having<V = string>(column: keyof TTable, operator: Operator, value: V): SelectedQuery<TTable, TJson, K>
  inRandomOrder(): SelectedQuery<TTable, TJson, K>
  whereColumn(first: keyof TTable, operator: Operator, second: keyof TTable): SelectedQuery<TTable, TJson, K>
  skip(count: number): SelectedQuery<TTable, TJson, K>
  take(count: number): SelectedQuery<TTable, TJson, K>
  distinct(column: keyof TJson): SelectedQuery<TTable, TJson, K>
  join(table: string, firstCol: string, secondCol: string): SelectedQuery<TTable, TJson, K>
  first(): Promise<SelectedResult<TJson, K> | undefined>
  last(): Promise<SelectedResult<TJson, K> | undefined>
  firstOrFail(): Promise<SelectedResult<TJson, K>>
  find(id: number): Promise<SelectedResult<TJson, K> | undefined>
  findOrFail(id: number): Promise<SelectedResult<TJson, K>>
  findMany(ids: number[]): Promise<SelectedResult<TJson, K>[]>
  all(): Promise<SelectedResult<TJson, K>[]>
  get(): Promise<SelectedResult<TJson, K>[]>
  latest(column?: keyof TTable): Promise<SelectedResult<TJson, K> | undefined>
  oldest(column?: keyof TTable): Promise<SelectedResult<TJson, K> | undefined>
  paginate(perPage?: number, page?: number): Promise<Paginator<SelectedResult<TJson, K>>>
  simplePaginate(perPage?: number, page?: number): Promise<SimplePaginator<SelectedResult<TJson, K>>>
  cursorPaginate(
    perPage?: number,
    cursor?: string | number | unknown[] | null,
    column?: keyof TTable | (keyof TTable)[],
    direction?: 'asc' | 'desc',
  ): Promise<CursorPaginator<SelectedResult<TJson, K>>>
  chunk(size: number, callback: (models: SelectedResult<TJson, K>[]) => Promise<void>): Promise<void>
  pluck<PK extends Extract<K | 'id', keyof TJson>>(field: PK): Promise<TJson[PK][]>
  max(field: keyof TTable): Promise<number>
  min(field: keyof TTable): Promise<number>
  avg(field: keyof TTable): Promise<number>
  sum(field: keyof TTable): Promise<number>
  count(): Promise<number>
}
export type SelectedResult<TJson, K extends string> = Pick<TJson, Extract<K | 'id', keyof TJson>> & { id: number }