import { TransactionScope } from './scope'
import { Table } from './table'
import { ConstructorClass, DbDriver, ResultSet, ValueOf } from './types'
export interface DbConfig<TModels> {
  driver: DbDriver
  entities: TModels
  createTables?: boolean
}
export declare type Tables<T> = {
  [P in keyof T]: Table<ValueOf<T[P]>, ConstructorClass<ValueOf<T[P]>>, T>
}
export declare class Db<T> {
  /**
   * Create new database instance.
   * @param config Database Configuration
   */
  static init<TModels>(config: DbConfig<TModels>): Promise<Db<TModels>>
  config: DbConfig<T>
  driver: DbDriver
  tables: Tables<T>
  constructor()
  close(): Promise<void>
  buildTables(): Tables<T>
  transaction(
    scope: (transacionScope: TransactionScope<T>) => void
  ): Promise<ResultSet[]>
  exec(sql: string, args?: any[]): Promise<ResultSet>
  query<TResult = any>(sql: string, args?: any[]): Promise<TResult[]>
  single<TResult = any>(sql: string, args?: any[]): Promise<TResult>
  dropAllTables(): Promise<ResultSet[]>
  createAllTables(): Promise<ResultSet[]>
  generateBackupSql(): Promise<string>
  restoreFromSql(sql: string, recreate?: boolean): Promise<void>
}