sql

Documentation

Index

• func And(items ...xqi.SqlLogic) xqi.SqlCondition
• func Avg(expr interface{}) SqlField
• func Case(expr interface{}, cases map[interface{}]interface{}, caseElse ...interface{}) SqlField
• func CaseThen(condition interface{}, caseTrue, caseFalse interface{}) SqlField
• func Cast(expr interface{}, asType DbType) SqlField
• func Concat(str interface{}, str1 interface{}, more ...interface{}) SqlField
• func Count(expr interface{}) SqlField
• func DateAdd(date interface{}, interval int, datePart xdriveri.DatePart) SqlField
• func DateDiff(date1, date2 interface{}, datePart xdriveri.DatePart) SqlField
• func DateFormat(expr interface{}, format string) SqlField
• func DateSub(date interface{}, interval int, datePart xdriveri.DatePart) SqlField
• func DateToUnix(date interface{}) SqlField
• func Eq(exp1, exp2 interface{}) xqi.SqlConditionItem
• func ExprField(sqlExpress string, alias string) xqi.SqlField
• func ExprTable(sqlExpress string, alias string) xqi.SqlTable
• func Field(expr interface{}) xqi.SqlField
• func Gt(exp1, exp2 interface{}) xqi.SqlConditionItem
• func Gte(exp1, exp2 interface{}) xqi.SqlConditionItem
• func If(expr interface{}, trueValue, falseValue interface{}) SqlField
• func IfNull(expr interface{}, nullVal interface{}) SqlField
• func In(exp1, exp2 interface{}) xqi.SqlConditionItem
• func Like(exp1, exp2 interface{}) xqi.SqlConditionItem
• func Lt(exp1, exp2 interface{}) xqi.SqlConditionItem
• func Lte(exp1, exp2 interface{}) xqi.SqlConditionItem
• func Max(expr interface{}) SqlField
• func Min(expr interface{}) SqlField
• func Neq(exp1, exp2 interface{}) xqi.SqlConditionItem
• func NotIn(exp1, exp2 interface{}) xqi.SqlConditionItem
• func NotLike(exp1, exp2 interface{}) xqi.SqlConditionItem
• func On(items ...xqi.SqlLogic) xqi.SqlCondition
• func OpDiv(v1, v2 interface{}) SqlField
• func OpMul(v1, v2 interface{}) SqlField
• func OpPlus(v1, v2 interface{}) SqlField
• func OpSub(v1, v2 interface{}) SqlField
• func Or(items ...xqi.SqlLogic) xqi.SqlCondition
• func Static(v interface{}) xqi.SqlStaticExpr
• func Substring(str interface{}, from, len int) SqlField
• func Sum(expr interface{}) SqlField
• func UnixToDate(unix interface{}) SqlField
• func Var(varName string, v interface{}) xqi.SqlVarExpr
• func Where(items ...xqi.SqlLogic) xqi.SqlCondition
• func Xor(items ...xqi.SqlLogic) xqi.SqlCondition

Functions

func And

func And(items ...xqi.SqlLogic) xqi.SqlCondition

func Avg

func Avg(expr interface{}) SqlField

func Case

func Case(expr interface{}, cases map[interface{}]interface{}, caseElse ...interface{}) SqlField

func CaseThen

func CaseThen(condition interface{}, caseTrue, caseFalse interface{}) SqlField

func Cast

func Cast(expr interface{}, asType DbType) SqlField

func Concat

func Concat(str interface{}, str1 interface{}, more ...interface{}) SqlField

字符串连接

func Count

func Count(expr interface{}) SqlField

func DateAdd

func DateAdd(date interface{}, interval int, datePart xdriveri.DatePart) SqlField

func DateDiff

func DateDiff(date1, date2 interface{}, datePart xdriveri.DatePart) SqlField

func DateFormat

func DateFormat(expr interface{}, format string) SqlField

func DateSub

func DateSub(date interface{}, interval int, datePart xdriveri.DatePart) SqlField

func DateToUnix

func DateToUnix(date interface{}) SqlField

func Eq

func Eq(exp1, exp2 interface{}) xqi.SqlConditionItem

func ExprField

func ExprField(sqlExpress string, alias string) xqi.SqlField

ExprField sql表达式字段

func ExprTable

func ExprTable(sqlExpress string, alias string) xqi.SqlTable

ExprTable sql表达式表

func Field

func Field(expr interface{}) xqi.SqlField

func Gt

func Gt(exp1, exp2 interface{}) xqi.SqlConditionItem

func Gte

func Gte(exp1, exp2 interface{}) xqi.SqlConditionItem

func If

func If(expr interface{}, trueValue, falseValue interface{}) SqlField

func IfNull

func IfNull(expr interface{}, nullVal interface{}) SqlField

func In

func In(exp1, exp2 interface{}) xqi.SqlConditionItem

func Like

func Like(exp1, exp2 interface{}) xqi.SqlConditionItem

func Lt

func Lt(exp1, exp2 interface{}) xqi.SqlConditionItem

func Lte

func Lte(exp1, exp2 interface{}) xqi.SqlConditionItem

func Max

func Max(expr interface{}) SqlField

func Min

func Min(expr interface{}) SqlField

func Neq

func Neq(exp1, exp2 interface{}) xqi.SqlConditionItem

func NotIn

func NotIn(exp1, exp2 interface{}) xqi.SqlConditionItem

func NotLike

func NotLike(exp1, exp2 interface{}) xqi.SqlConditionItem

func On

func On(items ...xqi.SqlLogic) xqi.SqlCondition

func OpDiv

func OpDiv(v1, v2 interface{}) SqlField

除法运算

func OpMul

func OpMul(v1, v2 interface{}) SqlField

乘法运算

func OpPlus

func OpPlus(v1, v2 interface{}) SqlField

加法运算

func OpSub

func OpSub(v1, v2 interface{}) SqlField

减法运算

func Or

func Or(items ...xqi.SqlLogic) xqi.SqlCondition

func Static

func Static(v interface{}) xqi.SqlStaticExpr

创建sql常量

func Substring

func Substring(str interface{}, from, len int) SqlField

字符串截取

func Sum

func Sum(expr interface{}) SqlField

func UnixToDate

func UnixToDate(unix interface{}) SqlField

func Var

func Var(varName string, v interface{}) xqi.SqlVarExpr

创建sql变量

func Where

func Where(items ...xqi.SqlLogic) xqi.SqlCondition

func Xor

func Xor(items ...xqi.SqlLogic) xqi.SqlCondition