/**
 * escape sql param
 */
export declare function escape(param: any): string;
export interface Result extends Dict {
    rows?: Dict[];
    fields?: Dict<{
        name: string;
        type: number;
    }>;
    affectedRows?: number;
    insertId?: number;
}
/**
 * @class DatabaseTools
 */
export interface Database {
    /**
     * database statistics
     */
    statistics(): Promise<any>;
    /**
     * exec query database
     */
    exec(sql: string): Promise<Result[]>;
    /**
     * close database connection
     */
    close(): void;
    /**
     * srart transaction
     */
    transaction(): Promise<void>;
    /**
     * commit transaction
     */
    commit(): Promise<void>;
    /**
     * rollback transaction and clear sql command queue
     */
    rollback(): Promise<void>;
}
export type Where = Dict | string;
export interface SelectOptions {
    group?: string;
    order?: string;
    limit?: number | number[];
    out?: string;
    count?: boolean;
}
export interface DatabaseCRUD {
    exec(sql: string): Promise<Result[]>;
    insert(table: string, row: Dict): Promise<number>;
    insertSql(table: string, row: Dict): string;
    delete(table: string, where?: Where): Promise<number>;
    deleteSql(table: string, where?: Where): string;
    update(table: string, row: Dict, where?: Where): Promise<number>;
    updateSql(table: string, row: Dict, where?: Where): string;
    select<T = Dict>(table: string, where?: Where, opts?: SelectOptions): Promise<T[]>;
    selectSql(table: string, where?: Where, opts?: SelectOptions): string;
    selectCount(table: string, where?: Where, opts?: SelectOptions): Promise<number>;
    selectOne<T = Dict>(table: string, where?: Where, opts?: SelectOptions): Promise<T | null>;
    query<T = Dict>(sql: string): Promise<T[]>;
    has(name: string): boolean;
}
export interface DatabaseTools extends DatabaseCRUD {
    has(table: string): boolean;
    load(SQL: string, SQL_ALTER: string[], SQL_INDEXES: string[], id?: string): Promise<void>;
    scope<T = any>(cb: (db: DatabaseCRUD, self: DatabaseTools) => Promise<T>): Promise<T>;
    transaction<T = any>(cb: (db: DatabaseCRUD, self: DatabaseTools) => Promise<T>): Promise<T>;
    db(): Database;
}