/**
* 数据库请求代理,连接和连接池管理的中间件
*/
///
import EventEmitter from 'events';
import { AsScalarType, Assignment, ColumnsOf, Condition, DefaultRowObject, ExecutableStatement, Execute, Expression, Field, InputObject, Parameter, Procedure, RowObject, RowObjectFrom, Scalar, Select, WhereObject, XExpression, XObjectName, XRowset, XTable, XTables, XTableVariant } from '../sql';
import { SelectOptions } from './connection';
import { Sqlifier } from './sqlifier';
import { Command, QueryResult } from './types';
export declare abstract class Executor {
protected abstract doQuery(sql: string, params?: Parameter[]): Promise>;
protected abstract sqlifier: Sqlifier;
protected _emitter: EventEmitter;
on(event: 'open', listener: () => void): this;
on(event: 'opened', listener: () => void): this;
on(event: 'close', listener: () => void): this;
on(event: 'closed', listener: () => void): this;
on(event: 'command', listener: (cmd: Command) => void): this;
on(event: 'error', listener: (error: Error) => any): this;
off(event: 'open', listener: () => void): this;
off(event: 'opened', listener: () => void): this;
off(event: 'close', listener: () => void): this;
off(event: 'closed', listener: () => void): this;
off(event: 'command', listener?: (cmd: Command) => void): this;
off(event: 'error', listener?: (error: Error) => any): this;
protected emit(event: string, ...args: any[]): boolean;
protected internalQuery(...args: any[]): Promise>;
query(command: Command): Promise>;
query(sql: Select): Promise>;
/**
* 执行一个存储过程执行代码
*/
query(sql: Execute): Promise>;
query(sql: string): Promise>;
query(sql: string, params?: Parameter[] | Record): Promise>;
query(sql: ExecutableStatement | ExecutableStatement[] | string): Promise>;
query(sql: TemplateStringsArray, ...params: any[]): Promise>;
/**
* 执行一个查询并获取返回的第一个标量值
* @param sql
*/
queryScalar(sql: TemplateStringsArray, ...params: Scalar[]): Promise;
queryScalar(sql: string, params?: Parameter[]): Promise;
queryScalar(sql: string, params?: InputObject): Promise;
queryScalar(sql: Select): Promise | null>;
queryScalar(sql: Select): Promise;
queryScalar(expression: Expression): Promise;
/**
* 插入数据
*/
insert(table: XObjectName | XTable, fields: string[] | Field>, values: Scalar[][] | Scalar[]): Promise;
/**
* 插入数据
*/
insert(table: XTable | XObjectName, values: InputObject[] | InputObject): Promise;
find = InputObject>(table: XTable | XObjectName, results: (rowset: Readonly>) => G, where: Condition | WhereObject | ((table: XRowset) => Condition)): Promise | null>;
find(table: XTable | XObjectName, where: Condition | WhereObject | ((table: XRowset) => Condition)): Promise;
/**
* 简化版的SELECT查询,用于快速查询,如果要用复杂的查询,请使用select语句
* @param table
* @param where
* @param options
*/
select = InputObject>(table: XObjectName | XRowset, results: (rowset: Readonly>) => G, options?: SelectOptions): Promise[]>;
select(table: XObjectName | XRowset, results: ColumnsOf[] | ((rowset: Readonly>) => Field[]), options?: SelectOptions): Promise[]>;
select(table: XObjectName | XRowset, options?: SelectOptions): Promise;
/**
* 更新表
*/
update(table: XTables, sets: InputObject | Assignment[], where?: WhereObject | Condition | ((table: Readonly>) => Condition)): Promise;
delete(table: XTables, where?: WhereObject | Condition | ((table: Readonly> | Readonly>) => Condition)): Promise;
execute(spName: XObjectName | Procedure, params?: XExpression[]): Promise>;
}