import mysql, { ConnectionOptions } from "mysql2/promise";
export type DSN = ConnectionOptions;
/**
 * データベースアクセス
 */
export declare class MyMigDB {
    private dsn;
    private con;
    /**
     * constructor
     * @param dsn
     */
    constructor(dsn: DSN);
    /**
     * get connection
     */
    get(): Promise<mysql.Connection>;
    /**
     * release connection;
     */
    release(): Promise<void>;
    /**
     * クエリを実行する（一切変換しない）
     *
     * @param sql
     * @param params
     * @param isLog
     * @returns
     */
    query(sql: string, params?: any[], isLog?: boolean, selectTarget?: string): Promise<mysql.ResultSetHeader | {
        [key: string]: any;
    }[]>;
    /**
     *  データベースから読み込んだ時の標準的変換動作。
     */
    convertFrom(_tableName: string, _columnName: string, value: any): any;
    convertTo(value: any): any;
    queryLog(sql: string, params: any[], isLog: boolean): void;
    resultLog(result: any, isLog: boolean): void;
}
type Expression = "eq" | "en" | "ne" | "lt" | "le" | "gt" | "ge" | "isNull" | "isNotNull" | "isTrue" | "isFalse" | "isUnknown" | "isNotTrue" | "isNotFalse" | "isNotUnknown" | "between" | "notBetween";
export type Exp<COLUMN> = {
    key: COLUMN;
    exp: Expression;
    val?: any;
};
export type Where<COLUMN> = Exp<COLUMN> | (Where<COLUMN> | "AND" | "OR")[];
/**
 * テーブルアクセスクラス
 */
export declare class Table<TYPE extends object, COLUMNS> {
    protected tableName: string;
    protected database: MyMigDB;
    /**
     * コンストラクタ
     *
     * @param tableName
     * @param database
     */
    constructor(tableName: string, database: MyMigDB);
    /**
     * 式生成用関数
     *
     * @param key
     * @param val
     * @returns
     */
    eq(key: COLUMNS, val: any): Exp<COLUMNS>;
    en(key: COLUMNS, val: any): Exp<COLUMNS>;
    ne(key: COLUMNS, val: any): Exp<COLUMNS>;
    lt(key: COLUMNS, val: any): Exp<COLUMNS>;
    le(key: COLUMNS, val: any): Exp<COLUMNS>;
    gt(key: COLUMNS, val: any): Exp<COLUMNS>;
    ge(key: COLUMNS, val: any): Exp<COLUMNS>;
    isNull(key: COLUMNS): Exp<COLUMNS>;
    isNotNull(key: COLUMNS): Exp<COLUMNS>;
    isTrue(key: COLUMNS): Exp<COLUMNS>;
    isFalse(key: COLUMNS): Exp<COLUMNS>;
    isUnknown(key: COLUMNS): Exp<COLUMNS>;
    isNotTrue(key: COLUMNS): Exp<COLUMNS>;
    isNotFalse(key: COLUMNS): Exp<COLUMNS>;
    isNotUnknown(key: COLUMNS): Exp<COLUMNS>;
    between(key: COLUMNS, from: any, till: any): Exp<COLUMNS>;
    notBetween(key: COLUMNS, from: any, till: any): Exp<COLUMNS>;
    /**
     * こんな配列を渡すと
     * [eq("id","hoge"),"AND",[eq("foo","bar"),"OR",lt("updated_at","2022-03-26")]],
     *
     * こんな風にレンダリングする
     * id=? and (foo=? or updated_at<?)
     * ["hoge","bar","2022-03-26"]
     */
    where(where: Where<COLUMNS>, params: any[]): string;
    /**
     * select
     * 何もないときは空のリストを返す
     *
     * @param where
     * @param orderBy
     * @param isLog
     * @returns
     */
    select(where?: Where<COLUMNS> | undefined, orderBy?: undefined, isLog?: boolean): Promise<Required<TYPE>[]>;
    /**
     * get first row
     *
     * @param where
     * @param isLog
     * @returns
     */
    findOne(where: Where<COLUMNS>, isLog?: boolean): Promise<Required<TYPE> | undefined>;
    /**
     * insert
     *
     * @param insert
     * @param isLog
     * @returns
     */
    insert(insert: TYPE, isLog?: boolean): Promise<mysql.ResultSetHeader>;
    /**
     * update
     *
     * @param update
     * @param where
     * @param isLog
     * @returns
     */
    update(update: TYPE, where: Where<COLUMNS>, isLog?: boolean): Promise<mysql.ResultSetHeader>;
    /**
     * delete
     *
     * @param where
     * @param isLog
     * @returns
     */
    delete(where?: Where<COLUMNS> | undefined, isLog?: boolean): Promise<mysql.ResultSetHeader>;
    /**
     * upsert
     *
     * @param table
     * @param insert
     * @param updateNames
     * @returns
     */
    upsert(insert: TYPE, updateNames: (keyof TYPE)[], isLog?: boolean): Promise<mysql.ResultSetHeader>;
}
export {};