/// <reference types="node" />

export interface ConnectionOptions {
  bigNumberStrings?: boolean;
  bulk?: number;
  charset?: string;
  compress?: boolean;
  logPackets?: boolean;
  connectAttributes?: boolean | object; // ???
  connectTimeout?: number;
  socketTimeout?: number;
  database: string;
  dateStrings?: boolean;
  debug?: boolean;
  debugCompress?: boolean;
  debugLen?: number;
  foundRows?: boolean;
  host?: string;
  initSql?: boolean; // ???
  maxAllowedPacket?: number; // ???
  metaAsArray?: boolean;
  multipleStatements?: boolean;
  namedPlaceholders?: boolean;
  nestTables?: boolean;
  password: string;
  permitSetMultiParamEntries?: boolean;
  pipelining?: boolean; // ???
  permitLocalInfile?: boolean;
  port?: number;
  rowsAsArray?: boolean;
  socketPath?: string; // ???
  sessionVariables?: string; // ???
  ssl?: boolean | string; // ???
  supportBigNumbers?: boolean;
  timezone?: string;
  trace?: boolean;
  typeCast?: string; // ???
  user: string;
}

export interface PoolOptions extends ConnectionOptions {
  acquireTimeout?: number;
  connectionLimit?: number;
  minDelayValidation?: number;
  resetAfterUse?: boolean;
  noControlAfterUse?: boolean; // ???
}

export interface createPoolClusterOptions {
  canRetry?: boolean;
  removeNodeErrorCount?: number;
  restoreNodeTimeout?: number;
  defaultSelector?: string;
}

export type createConnection = (opts: ConnectionOptions) => Promise<any>;

export type Pool = (options: PoolOptions, useCallback: boolean | object) => void;
export type createPool = (opts: PoolOptions) => Pool;

export type PoolCluster = (args?: createPoolClusterOptions) => void;
export type createPoolCluster = (opts?: createPoolClusterOptions) => PoolCluster;