/** * @leizm/mysql * * @author Zongmin Lei */ export interface QueryOptionsParams { /** * 跳过的行数 */ skip?: number; /** * 跳过的行数 */ offset?: number; /** * 返回的行数 */ limit?: number; /** * 排序方向 */ orderBy?: string; /** * 分组 */ groupBy?: string; /** * 返回字段列表 */ fields?: string[]; } export declare type BaseFieldType = number | string | boolean | Date | null; export declare type AdvancedCondition = Record; export declare type RawCondition = { $raw?: string; }; export declare type AdvancedConditionField = BaseFieldType | { /** x IN y */ $in?: any[]; /** x NOT IN y */ $notIn?: any[]; /** x LIKE y */ $like?: string; /** x NOT LIKE y */ $notLike?: string; /** x = y */ $eq?: any; /** x <> y */ $ne?: any; /** x < y */ $lt?: any; /** x <= y */ $lte?: any; /** x > y */ $gt?: any; /** x >= y */ $gte?: any; /** x IS NULL */ $isNull?: true; /** x IS NOT NULL */ $isNotNull?: true; /** x = y (y不做任何转义) */ $raw?: string; }; export declare type AdvancedUpdate = Record; export declare type AdvancedUpdateField = BaseFieldType | { /** x = x + y */ $incr?: number; /** x = x - y */ $decr?: number; /** x = y (y不做任何转义) */ $raw?: string; }; export declare type DataRow = Record;