Skip to main content
Module

x/sql/common.ts

Powerful and Easy use SQL Query Builder on Deno From @leizm/sql
Latest
File
export interface QueryOptionsParams { /** * 跳过的行数 */ skip?: number; /** * 跳过的行数 */ offset?: number; /** * 返回的行数 */ limit?: number; /** * 排序方向 */ orderBy?: string; /** * 分组 */ groupBy?: string; /** * 返回字段列表 */ fields?: string[];}
export type BaseFieldType = number | string | boolean | Date | null;
export type AdvancedCondition = Record< string | number | symbol, AdvancedConditionField>;
export type RawCondition = { $raw?: string };
export 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 type AdvancedUpdate = Record< string | number | symbol, AdvancedUpdateField>;
export type AdvancedUpdateField = | BaseFieldType | { /** x = x + y */ $incr?: number; /** x = x - y */ $decr?: number; /** x = y (y不做任何转义) */ $raw?: string; };
export type DataRow = Record<string, any>;