import { DbType, Condition, If, While, Break, Continue, XExpression, Return, Statement, Document, Scalar, ExpandScalar, Integer, DbTypeFromScalar, Literal, Variant, XRowsets, Field, Select, RowObject, TableVariantBuilder, TableVariantMember, XTableVariant, XObjectName, XTable, Func, Procedure, BuiltIn, Star, XRowset, CompatiblifyTuple, Execute, Assignable, Assignment, TableVariant, Declare, When, Case, WithSelect, XWithSelect, SelectAliasObject, With, CreateTableBuilder, AlterTableBuilder, AlterView, CreateIndex, CreateProcedureBuilder, AlterProcedureBuilder, CreateFunctionBuilder, AlterFunctionBuilder, DropIndex, Annotation, Insert, Update, Delete, Block, AlterDatabase, Parameter, ScalarFromDbType, Sequence, Expression, XTables, ColumnsOf, Numeric, SelectAction, CreateDatabaseBuilder, CreateSequenceBuilder, CreateViewBuilder, ScalarFuncInvoke, DropTableBuilder } from './sql'; import { CreateSchemaBuilder, DropDatabaseBuilder, DropFunctionBuilder, DropProcedureBuilder, DropSchemaBuilder, DropSequenceBuilder, DropViewBuilder } from './sql/statement'; import { VirtualOperation } from './virtual-operation'; export interface SqlBuilder extends VirtualOperation { readonly type: typeof DbType; if(condition: Condition): If; while(condition: Condition): While; break(): Break; continue(): Continue; return(value?: XExpression): Return; /** * 创建一个SQL文档 * @param statements 文档代码 */ doc(statements: Statement[]): Document; doc(...statements: Statement[]): Document; group(condition: Condition): Condition; group(expr: XExpression): Expression; /** * 负号运算符 - */ neg(expr: XExpression): Expression>; /** * 字符串连接运算 */ concat(...strs: [ XExpression, XExpression, ...XExpression[] ]): Expression; /** * 算术运算 + * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ add(left: XExpression, right: XExpression): Expression; /** * 算术运算 - * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ sub(left: XExpression, right: XExpression): Expression; /** * 算术运算 * * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ mul(left: XExpression, right: XExpression): Expression; /** * 算术运算 / * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ div(left: XExpression, right: XExpression): Expression; /** * 算术运算 % * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ mod(left: XExpression, right: XExpression): Expression; xor(left: XExpression, right: XExpression): Expression; /** * 位算术运算 << 仅支持整型 * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ shl(left: XExpression, right: XExpression): Expression; /** * 位算术运算 >> * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ shr(left: XExpression, right: XExpression): Expression; literal(value: T, dbType?: DbTypeFromScalar): Literal>; var(name: N, type: DbTypeFromScalar): Variant, N>; /** * 创建一个字段 */ field(name: N, rowset?: XRowsets): Field; /** * 将多个查询条件通过 AND 合并成一个大查询条件 * @param conditions 查询条件列表 * @returns 返回逻辑表达式 */ and(conditions: Condition[]): Condition; and(...conditions: [Condition, Condition, ...Condition[]]): Condition; /** * 位算术运算 & * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ and(left: XExpression, right: XExpression): Expression; /** * 将多个查询条件通过 OR 合并成一个 * @param conditions 查询条件列表 * @returns 返回逻辑表达式 */ or(conditions: Condition[]): Condition; or(...conditions: [Condition, Condition, ...Condition[]]): Condition; /** * 位算术运算 | * @param left 左值 * @param right 右值 * @returns 返回算术运算表达式 */ or(left: XExpression, right: XExpression): Expression; /** * Not 逻辑运算 * @param condition */ not(condition: Condition): Condition; /** * 位算术运算 ~ * @param value 左值 * @param right 右值 * @returns 返回算术运算表达式 */ not(value: XExpression): Expression; /** * 比较运算 IS NULL * @returns 返回比较运算符 * @param expr 表达式 */ isNull(expr: XExpression): Condition; /** * 比较运算 IS NOT NULL * @param expr 表达式 * @returns 返回比较运算符 */ isNotNull(expr: XExpression): Condition; eq(left: XExpression, right: XExpression): Condition; /** * 比较运算 <> * @param left 左值 * @param right 右值 * @returns 返回比较运算对比条件 */ neq(left: XExpression, right: XExpression): Condition; lt(left: XExpression, right: XExpression): Condition; /** * 比较运算 <= * @param left 左值 * @param right 右值 * @returns 返回比较运算对比条件 */ lte(left: XExpression, right: XExpression): Condition; /** * 比较运算 > * @param left 左值 * @param right 右值 * @returns 返回比较运算对比条件 */ gt(left: XExpression, right: XExpression): Condition; /** * 比较运算 >= * @param left 左值 * @param right 右值 * @returns 返回比较运算对比条件 */ gte(left: XExpression, right: XExpression): Condition; /** * 比较运算 LIKE * @param left 左值 * @param right 右值 * @returns 返回比较运算对比条件 */ like(left: XExpression, right: XExpression): Condition; /** * 比较运算 NOT LIKE * @param left 左值 * @param right 右值 * @returns 返回比较运算对比条件 */ notLike(left: XExpression, right: XExpression): Condition; /** * 比较运算 IN * @param left 左值 * @param values 要比较的值列表 * @returns 返回比较运算对比条件 */ in(left: XExpression, select: Select): Condition; in(left: XExpression, values: XExpression[]): Condition; in(left: XExpression, values: XExpression[] | Select): Condition; /** * 比较运算 NOT IN * @param left 左值 * @param values 要比较的值列表 * @returns 返回比较运算对比条件 */ notIn(left: XExpression, values: XExpression[]): Condition; /** * 判断是否存在 * @param select 查询语句 */ exists(select: Select): Condition; table(name: string, members: ((builder: TableVariantBuilder) => TableVariantMember[]) | TableVariantMember[]): XTableVariant; table(name: XObjectName, builtIn?: boolean): XTable; /** * 声明一个函数 */ func(name: XObjectName, builtIn?: boolean): Func; /** * 创建一个可供调用的存储过程函数 */ proc(name: XObjectName, builtIn?: boolean): Procedure; builtIn(name: N): BuiltIn; star(): Star; invokeAsTable(func: XObjectName | Func, args: (Star | BuiltIn | XExpression)[]): XRowset; invokeAsScalar(func: XObjectName | Func, args: (Star | BuiltIn | XExpression)[]): ScalarFuncInvoke; makeInvoke(type: 'table', name: XObjectName, builtIn?: boolean): (...args: (Star | BuiltIn | XExpression | undefined)[]) => XRowset; makeInvoke(type: 'table', name: XObjectName, builtIn?: boolean): (...args: CompatiblifyTuple) => XRowset; makeInvoke(type: 'scalar', name: XObjectName, builtIn?: boolean): (...args: (Star | BuiltIn | XExpression | undefined)[]) => Expression; makeInvoke(type: 'scalar', name: XObjectName, builtIn?: boolean): (...args: CompatiblifyTuple) => Expression; /** * 创建一个可供JS调用的存储过程 */ makeExec(name: XObjectName, builtIn?: boolean): (...args: (BuiltIn | Scalar | XExpression | undefined)[]) => Execute; makeExec(name: XObjectName, builtIn?: boolean): (...args: CompatiblifyTuple) => Execute; /** * 赋值语句 * @param left 左值 * @param right 右值 */ set(left: Assignable, right: XExpression): Assignment; /** * 变量声明 * @param declares 变量列表 */ declare(...members: (Variant | TableVariant)[] | [(Variant | TableVariant)[]]): Declare; /** * WHEN 语句块 * @param expr * @param value */ when(expr: XExpression, value: XExpression): When; case(expr?: XExpression): Case; /** * With语句 */ with(...rowsets: WithSelect[] | [WithSelect[]] | XWithSelect[] | [XWithSelect[]] | [SelectAliasObject]): With; union(...selects: Select[]): Select; unionAll(...selects: Select[]): Select; readonly createTable: CreateTableBuilder; readonly alterTable: AlterTableBuilder; createView: CreateViewBuilder; alterView(name: XObjectName): AlterView; createIndex(name: string): CreateIndex; readonly createProcedure: CreateProcedureBuilder; readonly alterProcedure: AlterProcedureBuilder; readonly createFunction: CreateFunctionBuilder; readonly alterFunction: AlterFunctionBuilder; readonly dropProcedure: DropProcedureBuilder; readonly dropTable: DropTableBuilder; readonly dropView: DropViewBuilder; readonly dropFunction: DropFunctionBuilder; dropIndex(table: XObjectName, name: N): DropIndex; annotation(...text: string[]): Annotation; note(text: string): Annotation; /** * 插入至表,into的别名 * @param table * @param fields */ insert(table: XTables, fields?: ColumnsOf[] | Field>[]): Insert; /** * 更新一个表格 * @param table */ update(table: XTables): Update; /** * 删除一个表格 * @param table 表格 */ delete(table: XTables): Delete; readonly select: SelectAction; raw(sql: string): any; block(...args: Statement[] | [Statement[]]): Block; execute(proc: XObjectName | Procedure, params?: (BuiltIn | XExpression)[]): Execute; readonly createDatabase: CreateDatabaseBuilder; readonly createSchema: CreateSchemaBuilder; readonly dropSchema: DropSchemaBuilder; alterDatabase(name: string): AlterDatabase; readonly dropDatabase: DropDatabaseBuilder; readonly createSequence: CreateSequenceBuilder; readonly dropSequence: DropSequenceBuilder; /** * input 参数 */ input(name: N, value: T): Parameter, N>; input(name: N, type: T, value?: ScalarFromDbType): Parameter>, N>; /** * output参数 */ output(name: N, type: T, value?: ScalarFromDbType): Parameter>, N>; /** * 创建一个输入输出参数 */ inoutput(name: N, type: T, value?: ScalarFromDbType): Parameter>, N>; sequence(name: XObjectName): Sequence; } export declare const SQL: SqlBuilder;