import { MysqlCfg } from '../interface'; export declare class MysqlClient { private cfg; private pool; constructor(config: MysqlCfg); closePool(): Promise; /** * 执行 SQL 语句(通用方法) * @param {string} sql - SQL 语句 * @param {array} params - SQL 参数(防止 SQL 注入) * @return {Promise} - 结果集 */ execute(sql: string, params?: Array): Promise; /** * 查询表信息 * @param table */ getTableInfo(table: string): Promise<{ columns: { COLUMN_NAME: string; ORDINAL_POSITION: number; COLUMN_TYPE: string; IS_NULLABLE: string; COLUMN_DEFAULT: string; COLUMN_COMMENT: string; }[]; indexes: { INDEX_NAME: string; COLUMN_NAME: string; }[]; }>; queryOne(table: string, whereStr: string): Promise; queryAll(table: string, whereStr: string): Promise; /** * 获取可设置的列 * 去掉 id updated_at created_at 三个约定字段 * @param table * @private */ private getSetAbleColumnNames; insert(table: string, record: any): Promise; update(table: string, record: any, whereStr: string): Promise; delete(table: string, whereStr: string): Promise; }