import { DialectBase, DialectKind, IDialectBase } from '.'
import { Condition } from '../../condition'
import { KeyVal, TableInfo, ValueOf } from '../../types'
export interface IDialectOrderByAlias<M, R, Q> extends IDialectBase<R> {
  orderBy(
    order: {
      [key in keyof Partial<Q>]: {
        [P in keyof Partial<ValueOf<Q[key]>>]: 'ASC' | 'DESC'
      }
    } & {
      self?: { [P in keyof M]?: 'ASC' | 'DESC' }
    }
  ): IDialectLimitAliasOffset<R>
}
export interface IDialectWhereAlias<M, R, Q> extends IDialectBase<R> {
  where<TResult>(
    fields: (
      left: { [key in keyof Q]: Condition<ValueOf<Q[key]>> } & {
        self: Condition<M>
      },
      right: { [key in keyof Q]: ValueOf<Q[key]> } & {
        self: M
      }
    ) => TResult
  ): IDialectOrderByAlias<M, R, Q> & IDialectLimitAliasOffset<R>
}
export interface IDialectLimitAliasOffset<R> extends IDialectBase<R> {
  limit(limit: number, offset?: number): IDialectBase<R>
}
export declare class ReadAliasDialect<M, R, Q> extends DialectBase<M, R>
  implements
    IDialectOrderByAlias<M, R, Q>,
    IDialectWhereAlias<M, R, Q>,
    IDialectLimitAliasOffset<R> {
  constructor(
    info: TableInfo<M>,
    sql: string,
    kind: DialectKind,
    aliases: KeyVal<TableInfo<any>>,
    map: any
  )
  limit(limit: number, offset?: number): IDialectBase<R>
  orderBy(
    order: {
      [key in keyof Partial<Q>]: {
        [P in keyof Partial<ValueOf<Q[key]>>]: 'ASC' | 'DESC'
      }
    } & {
      self?: { [P in keyof M]?: 'ASC' | 'DESC' }
    }
  ): IDialectLimitAliasOffset<R>
  where<TResult>(
    fields: (
      left: { [key in keyof Q]: Condition<ValueOf<Q[key]>> } & {
        self: Condition<M>
      },
      right: { [key in keyof Q]: ValueOf<Q[key]> } & {
        self: M
      }
    ) => TResult
  ): IDialectOrderByAlias<M, R, Q> & IDialectLimitAliasOffset<R>
}