import { Connection, ConnectOptions, DbProvider, ISOLATION_LEVEL, QueryResult } from 'lubejs/core'; import { config as MssqlConfig } from '@jovercao/mssql'; import { MssqlSqlOptions } from './sqlifier'; export declare function parseMssqlConfig(options: MssqlConnectOptions): MssqlConfig; export declare class MssqlConnection extends Connection { changeToSysdb(): Promise; constructor(provider: DbProvider, options: MssqlConnectOptions); private _connection?; private _mssqlOptions?; readonly options: MssqlConnectOptions; protected doBeginTrans(isolationLevel: ISOLATION_LEVEL): Promise; protected createSavePoint(id: number): Promise; protected rollbackSavePoint(id: number): Promise; protected doCommit(): Promise; protected doRollback(): Promise; protected doOpen(): Promise; protected doClose(): Promise; protected doShutdown(): void; /** * 获取数据库架构 */ getSchema(dbname?: string): any; protected doQuery(sql: string, params?: any[], batch?: boolean): Promise>; protected reset(): Promise; } export interface MssqlConnectOptions extends ConnectOptions { /** * 实例名 */ instance?: string; /** * 是否启用加密 */ encrypt?: boolean; /** * 是否使用UTC时间,默认为true */ useUTC?: boolean; sqlOptions?: MssqlSqlOptions; /** * 开启性能优化,默认会使用 sp_executesql 来执行语句 * 但使用过程中可能会遇到问题,比如开启事物等 */ optimize?: boolean; }