/** * 数据库请求代理,连接和连接池管理的中间件 */ /// 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>; }