Documentation ¶
Index ¶
- Variables
- func Nodeize(stmt Statement) (tokenizer.Tokenizer, []interface{})
- type Args
- type Assign
- type Between
- type ColOrAlias
- type ColOrAliasOrSub
- type ColOrSub
- type Column
- func (c Column) As(alias string) ColumnAlias
- func (c Column) Asc() Order
- func (c Column) Assign(param ValOrFuncOrSub) Assign
- func (c Column) Between(from, to ValOrColOrFuncOrSub) Between
- func (c Column) Define(definition string) Definition
- func (c Column) Desc() Order
- func (c Column) Eq(val ValOrColOrFuncOrSub) ComparisonOperation
- func (c Column) EqAll(params Subquery) NonScalarOperation
- func (c Column) EqAny(params Subquery) NonScalarOperation
- func (c Column) Gt(val ValOrColOrFuncOrSub) ComparisonOperation
- func (c Column) GtAll(params Subquery) NonScalarOperation
- func (c Column) GtAny(params Subquery) NonScalarOperation
- func (c Column) Gte(val ValOrColOrFuncOrSub) ComparisonOperation
- func (c Column) GteAll(params Subquery) NonScalarOperation
- func (c Column) GteAny(params Subquery) NonScalarOperation
- func (c Column) In(params ValsOrSub) ContainingOperation
- func (c Column) IsNotNull() NullOperation
- func (c Column) IsNull() NullOperation
- func (c Column) Like(val ValOrColOrFuncOrSub) ComparisonOperation
- func (c Column) Lt(val ValOrColOrFuncOrSub) ComparisonOperation
- func (c Column) LtAll(params Subquery) NonScalarOperation
- func (c Column) LtAny(params Subquery) NonScalarOperation
- func (c Column) Lte(val ValOrColOrFuncOrSub) ComparisonOperation
- func (c Column) LteAll(params Subquery) NonScalarOperation
- func (c Column) LteAny(params Subquery) NonScalarOperation
- func (c Column) NotEq(val ValOrColOrFuncOrSub) ComparisonOperation
- func (c Column) NotEqAll(params Subquery) NonScalarOperation
- func (c Column) NotEqAny(params Subquery) NonScalarOperation
- func (c Column) NotIn(params ValsOrSub) ContainingOperation
- func (c Column) RegExp(val ValOrColOrFuncOrSub) ComparisonOperation
- type ColumnAlias
- type ComparisonOperation
- func NewEq(val ValOrColOrFuncOrSub) ComparisonOperation
- func NewGt(val ValOrColOrFuncOrSub) ComparisonOperation
- func NewGte(val ValOrColOrFuncOrSub) ComparisonOperation
- func NewLike(val ValOrColOrFuncOrSub) ComparisonOperation
- func NewLt(val ValOrColOrFuncOrSub) ComparisonOperation
- func NewLte(val ValOrColOrFuncOrSub) ComparisonOperation
- func NewNotEq(val ValOrColOrFuncOrSub) ComparisonOperation
- func NewRegExp(val ValOrColOrFuncOrSub) ComparisonOperation
- type ComparisonOrLogicalOperation
- type ContainingOperation
- type CreateTable
- type DefaultValues
- type Definition
- type Definitions
- type Delete
- type ExistanceOperation
- type FSP
- type Formula
- func NewAdd(numeric ...ValOrColOrSubOrFormula) Formula
- func NewDiv(numeric ...ValOrColOrSubOrFormula) Formula
- func NewIntegerDiv(numeric ...ValOrColOrSubOrFormula) Formula
- func NewMod(numeric ...ValOrColOrSubOrFormula) Formula
- func NewMul(numeric ...ValOrColOrSubOrFormula) Formula
- func NewSub(numeric ...ValOrColOrSubOrFormula) Formula
- type From
- type Fromer
- type Func
- func NewAdddate(date ValOrColOrFuncOrSub, interval IntervalUnit) Func
- func NewAddtime(date1, date2 ValOrColOrFuncOrSub) Func
- func NewConcat(strs ...ValOrColOrFuncOrSub) Func
- func NewConvertTz(date, from, to ValOrColOrFuncOrSub) Func
- func NewCount(col ValOrColOrFuncOrSub) Func
- func NewCurDate() Func
- func NewCurrentDate() Func
- func NewCurrentTime(fsp FSP) Func
- func NewCurrentTimestamp(fsp FSP) Func
- func NewCurtime(fsp FSP) Func
- func NewDate(date ValOrColOrFuncOrSub) Func
- func NewDateAdd(date ValOrColOrFuncOrSub, interval IntervalUnit) Func
- func NewDateFormat(date, format ValOrColOrFuncOrSub) Func
- func NewDateSub(date ValOrColOrFuncOrSub, interval IntervalUnit) Func
- func NewDatediff(date1, date2 ValOrColOrFuncOrSub) Func
- func NewDay(date ValOrColOrFuncOrSub) Func
- func NewDayname(date ValOrColOrFuncOrSub) Func
- func NewDayofmonth(date ValOrColOrFuncOrSub) Func
- func NewDayofweek(date ValOrColOrFuncOrSub) Func
- func NewDayofyear(date ValOrColOrFuncOrSub) Func
- func NewExtract(date ValOrColOrFuncOrSub) Func
- func NewFromDays(days ValOrColOrFuncOrSub) Func
- func NewFromUnixtime(utime, format ValOrColOrFuncOrSub) Func
- func NewGetFormat(typ, name ValOrColOrFuncOrSub) Func
- func NewHour(time ValOrColOrFuncOrSub) Func
- func NewIFNULL(expr1, expr2 ValOrColOrFuncOrSub) Func
- func NewLastDay(date ValOrColOrFuncOrSub) Func
- func NewLocaltime(fsp FSP) Func
- func NewLocaltimestamp(fsp FSP) Func
- func NewMakedate(year, days ValOrColOrFuncOrSub) Func
- func NewMaketime(hours, minutes, seconds ValOrColOrFuncOrSub) Func
- func NewMax(col ValOrColOrFuncOrSub) Func
- func NewMicrosecond(date ValOrColOrFuncOrSub) Func
- func NewMinute(date ValOrColOrFuncOrSub) Func
- func NewMonth(date ValOrColOrFuncOrSub) Func
- func NewMonthname(date ValOrColOrFuncOrSub) Func
- func NewNow(fsp FSP) Func
- func NewPeriodAdd(period, value ValOrColOrFuncOrSub) Func
- func NewPeriodDiff(period1, period2 ValOrColOrFuncOrSub) Func
- func NewQuarter(date ValOrColOrFuncOrSub) Func
- func NewSecToTime(seconds ValOrColOrFuncOrSub) Func
- func NewSecond(time ValOrColOrFuncOrSub) Func
- func NewStrToDate(str, format ValOrColOrFuncOrSub) Func
- func NewSubdate(date ValOrColOrFuncOrSub, interval IntervalUnit) Func
- func NewSubtime(date1, date2 ValOrColOrFuncOrSub) Func
- func NewSysdate(fsp FSP) Func
- func NewTime(date ValOrColOrFuncOrSub) Func
- func NewTimeFormat(time, format ValOrColOrFuncOrSub) Func
- func NewTimeToSec(time ValOrColOrFuncOrSub) Func
- func NewTimediff(date1, date2 ValOrColOrFuncOrSub) Func
- func NewTimestamp(date1, date2 ValOrColOrFuncOrSub) Func
- func NewTimestampadd(unit, interval, date ValOrColOrFuncOrSub) Func
- func NewTimestampdiff(unit, date1, date2 ValOrColOrFuncOrSub) Func
- func NewToDays(date ValOrColOrFuncOrSub) Func
- func NewToSeconds(date ValOrColOrFuncOrSub) Func
- func NewUnixTimestamp(date ValOrColOrFuncOrSub) Func
- func NewUtcDate() Func
- func NewUtcTime(fsp FSP) Func
- func NewUtcTimestamp(fsp FSP) Func
- func NewWeek(date, mode ValOrColOrFuncOrSub) Func
- func NewWeekday(date ValOrColOrFuncOrSub) Func
- func NewWeekofyear(date ValOrColOrFuncOrSub) Func
- func NewYear(date ValOrColOrFuncOrSub) Func
- func NewYearweek(date, mode ValOrColOrFuncOrSub) Func
- func (c Func) Between(from, to ValOrColOrFuncOrSub) Between
- func (c Func) Eq(value ValOrColOrFuncOrSub) ComparisonOperation
- func (c Func) EqAll(arg Subquery) NonScalarOperation
- func (c Func) EqAny(arg Subquery) NonScalarOperation
- func (c Func) Gt(value ValOrColOrFuncOrSub) ComparisonOperation
- func (c Func) GtAll(arg Subquery) NonScalarOperation
- func (c Func) GtAny(arg Subquery) NonScalarOperation
- func (c Func) Gte(value ValOrColOrFuncOrSub) ComparisonOperation
- func (c Func) GteAll(arg Subquery) NonScalarOperation
- func (c Func) GteAny(arg Subquery) NonScalarOperation
- func (c Func) In(arg ValsOrSub) ContainingOperation
- func (c Func) Like(value ValOrColOrFuncOrSub) ComparisonOperation
- func (c Func) Lt(value ValOrColOrFuncOrSub) ComparisonOperation
- func (c Func) LtAll(arg Subquery) NonScalarOperation
- func (c Func) LtAny(arg Subquery) NonScalarOperation
- func (c Func) Lte(value ValOrColOrFuncOrSub) ComparisonOperation
- func (c Func) LteAll(arg Subquery) NonScalarOperation
- func (c Func) LteAny(arg Subquery) NonScalarOperation
- func (c Func) NotEq(value ValOrColOrFuncOrSub) ComparisonOperation
- func (c Func) NotEqAll(arg Subquery) NonScalarOperation
- func (c Func) NotEqAny(arg Subquery) NonScalarOperation
- func (c Func) NotIn(arg ValsOrSub) ContainingOperation
- func (c Func) RegExp(value ValOrColOrFuncOrSub) ComparisonOperation
- type GroupBy
- type GroupByer
- type Having
- type InsertInto
- type Interval
- func (i Interval) Day() IntervalUnit
- func (i Interval) DayHour() IntervalUnit
- func (i Interval) DayMicrosecond() IntervalUnit
- func (i Interval) DayMinute() IntervalUnit
- func (i Interval) DaySecond() IntervalUnit
- func (i Interval) Hour() IntervalUnit
- func (i Interval) HourMicrosecond() IntervalUnit
- func (i Interval) HourMinute() IntervalUnit
- func (i Interval) HourSecond() IntervalUnit
- func (i Interval) Microsecond() IntervalUnit
- func (i Interval) Minute() IntervalUnit
- func (i Interval) MinuteMicrosecond() IntervalUnit
- func (i Interval) MinuteSecond() IntervalUnit
- func (i Interval) Month() IntervalUnit
- func (i Interval) Quarter() IntervalUnit
- func (i Interval) Second() IntervalUnit
- func (i Interval) SecondMicrosecond() IntervalUnit
- func (i Interval) Week() IntervalUnit
- func (i Interval) Year() IntervalUnit
- func (i Interval) YearMonth() IntervalUnit
- type IntervalUnit
- type Join
- type JoinOperation
- type Joiner
- type JoinerOrAlias
- type Limit
- type Limiter
- type Namer
- type NonScalarOperation
- func NewEqAll(sub Subquery) NonScalarOperation
- func NewEqAny(sub Subquery) NonScalarOperation
- func NewGtAll(sub Subquery) NonScalarOperation
- func NewGtAny(sub Subquery) NonScalarOperation
- func NewGteAll(sub Subquery) NonScalarOperation
- func NewGteAny(sub Subquery) NonScalarOperation
- func NewLtAll(sub Subquery) NonScalarOperation
- func NewLtAny(sub Subquery) NonScalarOperation
- func NewLteAll(sub Subquery) NonScalarOperation
- func NewLteAny(sub Subquery) NonScalarOperation
- func NewNotEqAll(sub Subquery) NonScalarOperation
- func NewNotEqAny(sub Subquery) NonScalarOperation
- type Not
- type NullOperation
- type Offset
- type Offsetter
- type On
- type Order
- type OrderBy
- type OrderByer
- type Prever
- type SearchedCase
- type SearchedElse
- type SearchedThen
- type SearchedThenOrElse
- type SearchedWhen
- type Select
- type Selector
- type Set
- type SetOperation
- func NewExcept(stmts ...Statement) SetOperation
- func NewExceptAll(stmts ...Statement) SetOperation
- func NewIntersect(stmts ...Statement) SetOperation
- func NewIntersectAll(stmts ...Statement) SetOperation
- func NewUnion(stmts ...Statement) SetOperation
- func NewUnionAll(stmts ...Statement) SetOperation
- type SimpleCase
- type SimpleElse
- type SimpleThen
- type SimpleThenOrElse
- type SimpleWhen
- type Statement
- type Subquery
- func (s Subquery) As(alias string) SubqueryAlias
- func (s Subquery) Between(from, to ValOrColOrFuncOrSub) Between
- func (s Subquery) Eq(value ValOrColOrFuncOrSub) ComparisonOperation
- func (s Subquery) Gt(value ValOrColOrFuncOrSub) ComparisonOperation
- func (s Subquery) Gte(value ValOrColOrFuncOrSub) ComparisonOperation
- func (s Subquery) In(params ValsOrSub) ContainingOperation
- func (s Subquery) InnerJoin(table TableOrAlias) Join
- func (s Subquery) IsNotNull() NullOperation
- func (s Subquery) IsNull() NullOperation
- func (s Subquery) Join(table TableOrAlias) Join
- func (s Subquery) LeftJoin(table TableOrAlias) Join
- func (s Subquery) Like(value ValOrColOrFuncOrSub) ComparisonOperation
- func (s Subquery) Lt(value ValOrColOrFuncOrSub) ComparisonOperation
- func (s Subquery) Lte(value ValOrColOrFuncOrSub) ComparisonOperation
- func (s Subquery) NotEq(value ValOrColOrFuncOrSub) ComparisonOperation
- func (s Subquery) NotIn(params ValsOrSub) ContainingOperation
- func (s Subquery) RegExp(value ValOrColOrFuncOrSub) ComparisonOperation
- func (s Subquery) RightJoin(table TableOrAlias) Join
- type SubqueryAlias
- type Table
- type TableAlias
- type TableOrAlias
- type Update
- type Using
- type Val
- type ValOrColOrAliasOrFuncOrSubOrFormula
- type ValOrColOrFuncOrSub
- type ValOrColOrFuncOrSubs
- type ValOrColOrSubOrFormula
- type ValOrFuncOrSub
- type Vals
- type ValsOrSub
- type Values
- type Where
- type Wherer
- type Wildcard
Constants ¶
This section is empty.
Variables ¶
View Source
var ( FormatEurope = NewVal("EUR") FormatUSA = NewVal("USA") FormatJIS = NewVal("JIS") FormatISO = NewVal("ISO") FormatInternal = NewVal("INTERNAL") )
View Source
var ( WeekMode0 = NewVal(0) WeekMode1 = NewVal(1) WeekMode2 = NewVal(2) WeekMode3 = NewVal(3) WeekMode4 = NewVal(4) WeekMode5 = NewVal(5) WeekMode6 = NewVal(6) WeekMode7 = NewVal(7) )
View Source
var ( UnitMicrosecond = NewVal(Microsecond) UnitSecond = NewVal(Second) UnitMinute = NewVal(Minute) UnitHour = NewVal(Hour) UnitDay = NewVal(Day) UnitWeek = NewVal(Week) UnitMonth = NewVal(Month) UnitQuarter = NewVal(Quarter) UnitYear = NewVal(Year) UnitSecondMicrosecond = NewVal(SecondMicrosecond) UnitMinuteMicrosecond = NewVal(MinuteMicrosecond) UnitMinuteSecond = NewVal(MinuteSecond) UnitHourMicrosecond = NewVal(HourMicrosecond) UnitHourSecond = NewVal(HourSecond) UnitHourMinute = NewVal(HourMinute) UnitDayMicrosecond = NewVal(DayMicrosecond) UnitDaySecond = NewVal(DaySecond) UnitDayMinute = NewVal(DayMinute) UnitDayHour = NewVal(DayHour) UnitYearMonth = NewVal(YearMonth) )
View Source
var ( Microsecond = "MICROSECOND" Second = "SECOND" Minute = "MINUTE" Hour = "HOUR" Day = "DAY" Week = "WEEK" Month = "MONTH" Quarter = "QUARTER" Year = "YEAR" SecondMicrosecond = "SECOND_MICROSECOND" MinuteMicrosecond = "MINUTE_MICROSECOND" MinuteSecond = "MINUTE_SECOND" HourMicrosecond = "HOUR_MICROSECOND" HourSecond = "HOUR_SECOND" HourMinute = "HOUR_MINUTE" DayMicrosecond = "DAY_MICROSECOND" DaySecond = "DAY_SECOND" DayMinute = "DAY_MINUTE" DayHour = "DAY_HOUR" YearMonth = "YEAR_MONTH" )
Functions ¶
Types ¶
type Assign ¶
type Assign struct {
// contains filtered or unexported fields
}
func NewAssign ¶
func NewAssign(column Column, param ValOrFuncOrSub) Assign
type Between ¶
type Between struct {
// contains filtered or unexported fields
}
func NewBetween ¶
func NewBetween(from, to ValOrColOrFuncOrSub) Between
type ColOrAlias ¶
type ColOrAlias interface { Statement // contains filtered or unexported methods }
type ColOrAliasOrSub ¶
type ColOrAliasOrSub interface { Statement // contains filtered or unexported methods }
type Column ¶
type Column struct { Name string // contains filtered or unexported fields }
Column is a stmt to indicate a column in a table.
func (Column) As ¶
func (c Column) As(alias string) ColumnAlias
As is used to give an alias name to the column. Returns a new ColumnAs.
func (Column) Assign ¶
func (c Column) Assign(param ValOrFuncOrSub) Assign
Assign is used to assign a params to the column. This constitutes a part of the record update stmt. Returns a new Assign.
func (Column) Between ¶
func (c Column) Between(from, to ValOrColOrFuncOrSub) Between
func (Column) Define ¶
func (c Column) Define(definition string) Definition
Define is used to specify a definition for the column. This constitutes a part of the table creation. Returns a new Definition.
func (Column) Eq ¶
func (c Column) Eq(val ValOrColOrFuncOrSub) ComparisonOperation
func (Column) EqAll ¶
func (c Column) EqAll(params Subquery) NonScalarOperation
func (Column) EqAny ¶
func (c Column) EqAny(params Subquery) NonScalarOperation
func (Column) Gt ¶
func (c Column) Gt(val ValOrColOrFuncOrSub) ComparisonOperation
func (Column) GtAll ¶
func (c Column) GtAll(params Subquery) NonScalarOperation
func (Column) GtAny ¶
func (c Column) GtAny(params Subquery) NonScalarOperation
func (Column) Gte ¶
func (c Column) Gte(val ValOrColOrFuncOrSub) ComparisonOperation
func (Column) GteAll ¶
func (c Column) GteAll(params Subquery) NonScalarOperation
func (Column) GteAny ¶
func (c Column) GteAny(params Subquery) NonScalarOperation
func (Column) In ¶
func (c Column) In(params ValsOrSub) ContainingOperation
func (Column) IsNotNull ¶
func (c Column) IsNotNull() NullOperation
func (Column) IsNull ¶
func (c Column) IsNull() NullOperation
func (Column) Like ¶
func (c Column) Like(val ValOrColOrFuncOrSub) ComparisonOperation
func (Column) Lt ¶
func (c Column) Lt(val ValOrColOrFuncOrSub) ComparisonOperation
func (Column) LtAll ¶
func (c Column) LtAll(params Subquery) NonScalarOperation
func (Column) LtAny ¶
func (c Column) LtAny(params Subquery) NonScalarOperation
func (Column) Lte ¶
func (c Column) Lte(val ValOrColOrFuncOrSub) ComparisonOperation
func (Column) LteAll ¶
func (c Column) LteAll(params Subquery) NonScalarOperation
func (Column) LteAny ¶
func (c Column) LteAny(params Subquery) NonScalarOperation
func (Column) NotEq ¶
func (c Column) NotEq(val ValOrColOrFuncOrSub) ComparisonOperation
func (Column) NotEqAll ¶
func (c Column) NotEqAll(params Subquery) NonScalarOperation
func (Column) NotEqAny ¶
func (c Column) NotEqAny(params Subquery) NonScalarOperation
func (Column) NotIn ¶
func (c Column) NotIn(params ValsOrSub) ContainingOperation
func (Column) RegExp ¶
func (c Column) RegExp(val ValOrColOrFuncOrSub) ComparisonOperation
type ColumnAlias ¶
type ColumnAlias struct { Alias string // contains filtered or unexported fields }
func NewColumnAlias ¶
func NewColumnAlias(alias string) ColumnAlias
type ComparisonOperation ¶
type ComparisonOperation struct {
// contains filtered or unexported fields
}
func NewEq ¶
func NewEq(val ValOrColOrFuncOrSub) ComparisonOperation
func NewGt ¶
func NewGt(val ValOrColOrFuncOrSub) ComparisonOperation
func NewGte ¶
func NewGte(val ValOrColOrFuncOrSub) ComparisonOperation
func NewLike ¶
func NewLike(val ValOrColOrFuncOrSub) ComparisonOperation
func NewLt ¶
func NewLt(val ValOrColOrFuncOrSub) ComparisonOperation
func NewLte ¶
func NewLte(val ValOrColOrFuncOrSub) ComparisonOperation
func NewNotEq ¶
func NewNotEq(val ValOrColOrFuncOrSub) ComparisonOperation
func NewRegExp ¶
func NewRegExp(val ValOrColOrFuncOrSub) ComparisonOperation
type ComparisonOrLogicalOperation ¶
type ComparisonOrLogicalOperation interface { Statement // contains filtered or unexported methods }
type ContainingOperation ¶
type ContainingOperation struct {
// contains filtered or unexported fields
}
func NewIn ¶
func NewIn(vals ValsOrSub) ContainingOperation
func NewNotIn ¶
func NewNotIn(vals ValsOrSub) ContainingOperation
type CreateTable ¶
type CreateTable struct {
// contains filtered or unexported fields
}
func NewCreateTable ¶
func NewCreateTable(joiner Joiner) CreateTable
func NewCreateTableIfNotExists ¶
func NewCreateTableIfNotExists(joiner Joiner) CreateTable
func (CreateTable) Definitions ¶
func (c CreateTable) Definitions(defs ...Definition) Definitions
type DefaultValues ¶
type DefaultValues struct {
// contains filtered or unexported fields
}
func NewDefaultValues ¶
func NewDefaultValues() DefaultValues
type Definition ¶
type Definition struct {
// contains filtered or unexported fields
}
func NewDefinition ¶
func NewDefinition(definition string) Definition
type Definitions ¶
type Definitions struct {
// contains filtered or unexported fields
}
func NewDefinitions ¶
func NewDefinitions(definitions ...Definition) Definitions
type Delete ¶
type Delete struct {
// contains filtered or unexported fields
}
func (Delete) From ¶
func (d Delete) From(t JoinerOrAlias) From
type ExistanceOperation ¶
type ExistanceOperation struct {
// contains filtered or unexported fields
}
func NewExists ¶
func NewExists(sub Subquery) ExistanceOperation
func NewNotExists ¶
func NewNotExists(sub Subquery) ExistanceOperation
type Formula ¶
type Formula struct {
// contains filtered or unexported fields
}
func NewAdd ¶
func NewAdd(numeric ...ValOrColOrSubOrFormula) Formula
func NewDiv ¶
func NewDiv(numeric ...ValOrColOrSubOrFormula) Formula
func NewIntegerDiv ¶
func NewIntegerDiv(numeric ...ValOrColOrSubOrFormula) Formula
func NewMod ¶
func NewMod(numeric ...ValOrColOrSubOrFormula) Formula
func NewMul ¶
func NewMul(numeric ...ValOrColOrSubOrFormula) Formula
func NewSub ¶
func NewSub(numeric ...ValOrColOrSubOrFormula) Formula
type From ¶
type From struct {
// contains filtered or unexported fields
}
func NewFrom ¶
func NewFrom(table JoinerOrAlias) From
func (From) Where ¶
func (f From) Where(op ComparisonOrLogicalOperation) Where
type Fromer ¶
type Fromer interface {
From(table JoinerOrAlias) From
}
type Func ¶
type Func struct {
// contains filtered or unexported fields
}
func NewAdddate ¶
func NewAdddate(date ValOrColOrFuncOrSub, interval IntervalUnit) Func
func NewAddtime ¶
func NewAddtime(date1, date2 ValOrColOrFuncOrSub) Func
func NewConcat ¶
func NewConcat(strs ...ValOrColOrFuncOrSub) Func
func NewConvertTz ¶
func NewConvertTz(date, from, to ValOrColOrFuncOrSub) Func
func NewCount ¶
func NewCount(col ValOrColOrFuncOrSub) Func
func NewCurDate ¶
func NewCurDate() Func
func NewCurrentDate ¶
func NewCurrentDate() Func
func NewCurrentTime ¶
func NewCurrentTimestamp ¶
func NewCurtime ¶
func NewDate ¶
func NewDate(date ValOrColOrFuncOrSub) Func
func NewDateAdd ¶
func NewDateAdd(date ValOrColOrFuncOrSub, interval IntervalUnit) Func
func NewDateFormat ¶
func NewDateFormat(date, format ValOrColOrFuncOrSub) Func
func NewDateSub ¶
func NewDateSub(date ValOrColOrFuncOrSub, interval IntervalUnit) Func
func NewDatediff ¶
func NewDatediff(date1, date2 ValOrColOrFuncOrSub) Func
func NewDay ¶
func NewDay(date ValOrColOrFuncOrSub) Func
func NewDayname ¶
func NewDayname(date ValOrColOrFuncOrSub) Func
func NewDayofmonth ¶
func NewDayofmonth(date ValOrColOrFuncOrSub) Func
func NewDayofweek ¶
func NewDayofweek(date ValOrColOrFuncOrSub) Func
func NewDayofyear ¶
func NewDayofyear(date ValOrColOrFuncOrSub) Func
func NewExtract ¶
func NewExtract(date ValOrColOrFuncOrSub) Func
func NewFromDays ¶
func NewFromDays(days ValOrColOrFuncOrSub) Func
func NewFromUnixtime ¶
func NewFromUnixtime(utime, format ValOrColOrFuncOrSub) Func
func NewGetFormat ¶
func NewGetFormat(typ, name ValOrColOrFuncOrSub) Func
func NewHour ¶
func NewHour(time ValOrColOrFuncOrSub) Func
func NewIFNULL ¶
func NewIFNULL(expr1, expr2 ValOrColOrFuncOrSub) Func
func NewLastDay ¶
func NewLastDay(date ValOrColOrFuncOrSub) Func
func NewLocaltime ¶
func NewLocaltimestamp ¶
func NewMakedate ¶
func NewMakedate(year, days ValOrColOrFuncOrSub) Func
func NewMaketime ¶
func NewMaketime(hours, minutes, seconds ValOrColOrFuncOrSub) Func
func NewMax ¶
func NewMax(col ValOrColOrFuncOrSub) Func
func NewMicrosecond ¶
func NewMicrosecond(date ValOrColOrFuncOrSub) Func
func NewMinute ¶
func NewMinute(date ValOrColOrFuncOrSub) Func
func NewMonth ¶
func NewMonth(date ValOrColOrFuncOrSub) Func
func NewMonthname ¶
func NewMonthname(date ValOrColOrFuncOrSub) Func
func NewPeriodAdd ¶
func NewPeriodAdd(period, value ValOrColOrFuncOrSub) Func
func NewPeriodDiff ¶
func NewPeriodDiff(period1, period2 ValOrColOrFuncOrSub) Func
func NewQuarter ¶
func NewQuarter(date ValOrColOrFuncOrSub) Func
func NewSecToTime ¶
func NewSecToTime(seconds ValOrColOrFuncOrSub) Func
func NewSecond ¶
func NewSecond(time ValOrColOrFuncOrSub) Func
func NewStrToDate ¶
func NewStrToDate(str, format ValOrColOrFuncOrSub) Func
func NewSubdate ¶
func NewSubdate(date ValOrColOrFuncOrSub, interval IntervalUnit) Func
func NewSubtime ¶
func NewSubtime(date1, date2 ValOrColOrFuncOrSub) Func
func NewSysdate ¶
func NewTime ¶
func NewTime(date ValOrColOrFuncOrSub) Func
func NewTimeFormat ¶
func NewTimeFormat(time, format ValOrColOrFuncOrSub) Func
func NewTimeToSec ¶
func NewTimeToSec(time ValOrColOrFuncOrSub) Func
func NewTimediff ¶
func NewTimediff(date1, date2 ValOrColOrFuncOrSub) Func
func NewTimestamp ¶
func NewTimestamp(date1, date2 ValOrColOrFuncOrSub) Func
func NewTimestampadd ¶
func NewTimestampadd(unit, interval, date ValOrColOrFuncOrSub) Func
func NewTimestampdiff ¶
func NewTimestampdiff(unit, date1, date2 ValOrColOrFuncOrSub) Func
func NewToDays ¶
func NewToDays(date ValOrColOrFuncOrSub) Func
func NewToSeconds ¶
func NewToSeconds(date ValOrColOrFuncOrSub) Func
func NewUnixTimestamp ¶
func NewUnixTimestamp(date ValOrColOrFuncOrSub) Func
func NewUtcDate ¶
func NewUtcDate() Func
func NewUtcTime ¶
func NewUtcTimestamp ¶
func NewWeek ¶
func NewWeek(date, mode ValOrColOrFuncOrSub) Func
func NewWeekday ¶
func NewWeekday(date ValOrColOrFuncOrSub) Func
func NewWeekofyear ¶
func NewWeekofyear(date ValOrColOrFuncOrSub) Func
func NewYear ¶
func NewYear(date ValOrColOrFuncOrSub) Func
func NewYearweek ¶
func NewYearweek(date, mode ValOrColOrFuncOrSub) Func
func (Func) Between ¶
func (c Func) Between(from, to ValOrColOrFuncOrSub) Between
func (Func) Eq ¶
func (c Func) Eq(value ValOrColOrFuncOrSub) ComparisonOperation
func (Func) EqAll ¶
func (c Func) EqAll(arg Subquery) NonScalarOperation
func (Func) EqAny ¶
func (c Func) EqAny(arg Subquery) NonScalarOperation
func (Func) Gt ¶
func (c Func) Gt(value ValOrColOrFuncOrSub) ComparisonOperation
func (Func) GtAll ¶
func (c Func) GtAll(arg Subquery) NonScalarOperation
func (Func) GtAny ¶
func (c Func) GtAny(arg Subquery) NonScalarOperation
func (Func) Gte ¶
func (c Func) Gte(value ValOrColOrFuncOrSub) ComparisonOperation
func (Func) GteAll ¶
func (c Func) GteAll(arg Subquery) NonScalarOperation
func (Func) GteAny ¶
func (c Func) GteAny(arg Subquery) NonScalarOperation
func (Func) In ¶
func (c Func) In(arg ValsOrSub) ContainingOperation
func (Func) Like ¶
func (c Func) Like(value ValOrColOrFuncOrSub) ComparisonOperation
func (Func) Lt ¶
func (c Func) Lt(value ValOrColOrFuncOrSub) ComparisonOperation
func (Func) LtAll ¶
func (c Func) LtAll(arg Subquery) NonScalarOperation
func (Func) LtAny ¶
func (c Func) LtAny(arg Subquery) NonScalarOperation
func (Func) Lte ¶
func (c Func) Lte(value ValOrColOrFuncOrSub) ComparisonOperation
func (Func) LteAll ¶
func (c Func) LteAll(arg Subquery) NonScalarOperation
func (Func) LteAny ¶
func (c Func) LteAny(arg Subquery) NonScalarOperation
func (Func) NotEq ¶
func (c Func) NotEq(value ValOrColOrFuncOrSub) ComparisonOperation
func (Func) NotEqAll ¶
func (c Func) NotEqAll(arg Subquery) NonScalarOperation
func (Func) NotEqAny ¶
func (c Func) NotEqAny(arg Subquery) NonScalarOperation
func (Func) NotIn ¶
func (c Func) NotIn(arg ValsOrSub) ContainingOperation
func (Func) RegExp ¶
func (c Func) RegExp(value ValOrColOrFuncOrSub) ComparisonOperation
type GroupBy ¶
type GroupBy struct {
// contains filtered or unexported fields
}
func NewGroupBy ¶
func (GroupBy) Having ¶
func (g GroupBy) Having(operation ComparisonOrLogicalOperation) Having
type Having ¶
type Having struct {
// contains filtered or unexported fields
}
func NewHaving ¶
func NewHaving(operation ComparisonOrLogicalOperation) Having
type InsertInto ¶
type InsertInto struct {
// contains filtered or unexported fields
}
func NewInsertInto ¶
func NewInsertInto(table Table, columns ...Column) InsertInto
func (InsertInto) DefaultValues ¶
func (i InsertInto) DefaultValues() DefaultValues
func (InsertInto) Select ¶
func (i InsertInto) Select(columns ...ValOrColOrAliasOrFuncOrSubOrFormula) Select
func (InsertInto) Values ¶
func (i InsertInto) Values(paramses ...Vals) Values
type Interval ¶
type Interval struct {
// contains filtered or unexported fields
}
func NewInterval ¶
func NewInterval(duration ValOrColOrFuncOrSub) Interval
func (Interval) Day ¶
func (i Interval) Day() IntervalUnit
func (Interval) DayHour ¶
func (i Interval) DayHour() IntervalUnit
func (Interval) DayMicrosecond ¶
func (i Interval) DayMicrosecond() IntervalUnit
func (Interval) DayMinute ¶
func (i Interval) DayMinute() IntervalUnit
func (Interval) DaySecond ¶
func (i Interval) DaySecond() IntervalUnit
func (Interval) Hour ¶
func (i Interval) Hour() IntervalUnit
func (Interval) HourMicrosecond ¶
func (i Interval) HourMicrosecond() IntervalUnit
func (Interval) HourMinute ¶
func (i Interval) HourMinute() IntervalUnit
func (Interval) HourSecond ¶
func (i Interval) HourSecond() IntervalUnit
func (Interval) Microsecond ¶
func (i Interval) Microsecond() IntervalUnit
func (Interval) Minute ¶
func (i Interval) Minute() IntervalUnit
func (Interval) MinuteMicrosecond ¶
func (i Interval) MinuteMicrosecond() IntervalUnit
func (Interval) MinuteSecond ¶
func (i Interval) MinuteSecond() IntervalUnit
func (Interval) Month ¶
func (i Interval) Month() IntervalUnit
func (Interval) Quarter ¶
func (i Interval) Quarter() IntervalUnit
func (Interval) Second ¶
func (i Interval) Second() IntervalUnit
func (Interval) SecondMicrosecond ¶
func (i Interval) SecondMicrosecond() IntervalUnit
func (Interval) Week ¶
func (i Interval) Week() IntervalUnit
func (Interval) Year ¶
func (i Interval) Year() IntervalUnit
func (Interval) YearMonth ¶
func (i Interval) YearMonth() IntervalUnit
type IntervalUnit ¶
type IntervalUnit struct {
// contains filtered or unexported fields
}
type Join ¶
type Join struct {
// contains filtered or unexported fields
}
func NewInnerJoin ¶
func NewInnerJoin(table TableOrAlias) Join
func NewJoin ¶
func NewJoin(table TableOrAlias) Join
func NewLeftJoin ¶
func NewLeftJoin(table TableOrAlias) Join
func NewRightJoin ¶
func NewRightJoin(table TableOrAlias) Join
func (Join) InnerJoin ¶
func (j Join) InnerJoin(table TableOrAlias) Join
func (Join) Join ¶
func (j Join) Join(table TableOrAlias) Join
func (Join) LeftJoin ¶
func (j Join) LeftJoin(table TableOrAlias) Join
func (Join) RightJoin ¶
func (j Join) RightJoin(table TableOrAlias) Join
type JoinOperation ¶
type JoinOperation struct {
// contains filtered or unexported fields
}
func NewAnd ¶
func NewAnd(ops ...ComparisonOrLogicalOperation) JoinOperation
func NewOr ¶
func NewOr(ops ...ComparisonOrLogicalOperation) JoinOperation
type Joiner ¶
type Joiner interface { Statement Join(TableOrAlias) Join InnerJoin(TableOrAlias) Join LeftJoin(TableOrAlias) Join RightJoin(TableOrAlias) Join }
type JoinerOrAlias ¶
type JoinerOrAlias interface { Statement // contains filtered or unexported methods }
type NonScalarOperation ¶
type NonScalarOperation struct {
// contains filtered or unexported fields
}
func NewEqAll ¶
func NewEqAll(sub Subquery) NonScalarOperation
func NewEqAny ¶
func NewEqAny(sub Subquery) NonScalarOperation
func NewGtAll ¶
func NewGtAll(sub Subquery) NonScalarOperation
func NewGtAny ¶
func NewGtAny(sub Subquery) NonScalarOperation
func NewGteAll ¶
func NewGteAll(sub Subquery) NonScalarOperation
func NewGteAny ¶
func NewGteAny(sub Subquery) NonScalarOperation
func NewLtAll ¶
func NewLtAll(sub Subquery) NonScalarOperation
func NewLtAny ¶
func NewLtAny(sub Subquery) NonScalarOperation
func NewLteAll ¶
func NewLteAll(sub Subquery) NonScalarOperation
func NewLteAny ¶
func NewLteAny(sub Subquery) NonScalarOperation
func NewNotEqAll ¶
func NewNotEqAll(sub Subquery) NonScalarOperation
func NewNotEqAny ¶
func NewNotEqAny(sub Subquery) NonScalarOperation
type Not ¶
type Not struct {
// contains filtered or unexported fields
}
func NewNot ¶
func NewNot(operation ComparisonOrLogicalOperation) Not
type NullOperation ¶
type NullOperation struct {
// contains filtered or unexported fields
}
func NewIsNotNull ¶
func NewIsNotNull() NullOperation
func NewIsNull ¶
func NewIsNull() NullOperation
type Offset ¶
type Offset struct {
// contains filtered or unexported fields
}
Offset skips specified rows before beginning to return rows.
type On ¶
type On struct {
// contains filtered or unexported fields
}
func (On) InnerJoin ¶
func (o On) InnerJoin(table TableOrAlias) Join
func (On) Join ¶
func (o On) Join(table TableOrAlias) Join
func (On) LeftJoin ¶
func (o On) LeftJoin(table TableOrAlias) Join
func (On) RightJoin ¶
func (o On) RightJoin(table TableOrAlias) Join
type SearchedCase ¶
type SearchedCase struct {
// contains filtered or unexported fields
}
func NewSearchedCase ¶
func NewSearchedCase(thenOrElse SearchedThenOrElse) SearchedCase
type SearchedElse ¶
type SearchedElse struct {
// contains filtered or unexported fields
}
func NewSearchedElse ¶
func NewSearchedElse(param ValOrColOrFuncOrSub) SearchedElse
type SearchedThen ¶
type SearchedThen struct {
// contains filtered or unexported fields
}
func NewSearchedThen ¶
func NewSearchedThen(param ValOrColOrFuncOrSub) SearchedThen
func (SearchedThen) Else ¶
func (t SearchedThen) Else(param ValOrColOrFuncOrSub) SearchedElse
func (SearchedThen) When ¶
func (t SearchedThen) When(condition ComparisonOrLogicalOperation) SearchedWhen
type SearchedThenOrElse ¶
type SearchedThenOrElse interface { Statement // contains filtered or unexported methods }
type SearchedWhen ¶
type SearchedWhen struct {
// contains filtered or unexported fields
}
func NewSearchedWhen ¶
func NewSearchedWhen(condition ComparisonOrLogicalOperation) SearchedWhen
func (SearchedWhen) Then ¶
func (w SearchedWhen) Then(param ValOrColOrFuncOrSub) SearchedThen
type Select ¶
type Select struct {
// contains filtered or unexported fields
}
func NewSelect ¶
func NewSelect(columns ...ValOrColOrAliasOrFuncOrSubOrFormula) Select
func NewSelectDistinct ¶
func NewSelectDistinct(columns ...ValOrColOrAliasOrFuncOrSubOrFormula) Select
func (Select) From ¶
func (s Select) From(t JoinerOrAlias) From
type Selector ¶
type Selector interface {
Select(columns ...ValOrColOrAliasOrFuncOrSubOrFormula) Select
}
type Set ¶
type Set struct {
// contains filtered or unexported fields
}
func (Set) Where ¶
func (s Set) Where(operation ComparisonOrLogicalOperation) Where
type SetOperation ¶
type SetOperation struct {
// contains filtered or unexported fields
}
func NewExcept ¶
func NewExcept(stmts ...Statement) SetOperation
func NewExceptAll ¶
func NewExceptAll(stmts ...Statement) SetOperation
func NewIntersect ¶
func NewIntersect(stmts ...Statement) SetOperation
func NewIntersectAll ¶
func NewIntersectAll(stmts ...Statement) SetOperation
func NewUnion ¶
func NewUnion(stmts ...Statement) SetOperation
func NewUnionAll ¶
func NewUnionAll(stmts ...Statement) SetOperation
func (SetOperation) OrderBy ¶
func (u SetOperation) OrderBy(os ...Order) OrderBy
type SimpleCase ¶
type SimpleCase struct {
// contains filtered or unexported fields
}
func NewSimpleCase ¶
func NewSimpleCase(param ValOrColOrFuncOrSub, thenOrElse SimpleThenOrElse) SimpleCase
type SimpleElse ¶
type SimpleElse struct {
// contains filtered or unexported fields
}
func NewSimpleElse ¶
func NewSimpleElse(param ValOrColOrFuncOrSub) SimpleElse
type SimpleThen ¶
type SimpleThen struct {
// contains filtered or unexported fields
}
func NewSimpleThen ¶
func NewSimpleThen(param ValOrColOrFuncOrSub) SimpleThen
func (SimpleThen) Else ¶
func (t SimpleThen) Else(param ValOrColOrFuncOrSub) SimpleElse
func (SimpleThen) When ¶
func (t SimpleThen) When(param Val) SimpleWhen
type SimpleThenOrElse ¶
type SimpleThenOrElse interface { Statement // contains filtered or unexported methods }
type SimpleWhen ¶
type SimpleWhen struct {
// contains filtered or unexported fields
}
func NewSimpleWhen ¶
func NewSimpleWhen(param Val) SimpleWhen
func (SimpleWhen) Then ¶
func (w SimpleWhen) Then(param ValOrColOrFuncOrSub) SimpleThen
type Statement ¶
type Statement interface {
// contains filtered or unexported methods
}
Statement is the interface of the component which is the minimum unit constituting SQL. All types that implement this interface can be built as SQL.
type Subquery ¶
type Subquery struct {
// contains filtered or unexported fields
}
func NewSubquery ¶
func (Subquery) As ¶
func (s Subquery) As(alias string) SubqueryAlias
func (Subquery) Between ¶
func (s Subquery) Between(from, to ValOrColOrFuncOrSub) Between
func (Subquery) Eq ¶
func (s Subquery) Eq(value ValOrColOrFuncOrSub) ComparisonOperation
func (Subquery) Gt ¶
func (s Subquery) Gt(value ValOrColOrFuncOrSub) ComparisonOperation
func (Subquery) Gte ¶
func (s Subquery) Gte(value ValOrColOrFuncOrSub) ComparisonOperation
func (Subquery) In ¶
func (s Subquery) In(params ValsOrSub) ContainingOperation
func (Subquery) InnerJoin ¶
func (s Subquery) InnerJoin(table TableOrAlias) Join
func (Subquery) IsNotNull ¶
func (s Subquery) IsNotNull() NullOperation
func (Subquery) IsNull ¶
func (s Subquery) IsNull() NullOperation
func (Subquery) Join ¶
func (s Subquery) Join(table TableOrAlias) Join
func (Subquery) LeftJoin ¶
func (s Subquery) LeftJoin(table TableOrAlias) Join
func (Subquery) Like ¶
func (s Subquery) Like(value ValOrColOrFuncOrSub) ComparisonOperation
func (Subquery) Lt ¶
func (s Subquery) Lt(value ValOrColOrFuncOrSub) ComparisonOperation
func (Subquery) Lte ¶
func (s Subquery) Lte(value ValOrColOrFuncOrSub) ComparisonOperation
func (Subquery) NotEq ¶
func (s Subquery) NotEq(value ValOrColOrFuncOrSub) ComparisonOperation
func (Subquery) NotIn ¶
func (s Subquery) NotIn(params ValsOrSub) ContainingOperation
func (Subquery) RegExp ¶
func (s Subquery) RegExp(value ValOrColOrFuncOrSub) ComparisonOperation
func (Subquery) RightJoin ¶
func (s Subquery) RightJoin(table TableOrAlias) Join
type SubqueryAlias ¶
type SubqueryAlias struct { Alias string // contains filtered or unexported fields }
func NewSubqueryAlias ¶
func NewSubqueryAlias(alias string) SubqueryAlias
func (SubqueryAlias) InnerJoin ¶
func (a SubqueryAlias) InnerJoin(table TableOrAlias) Join
func (SubqueryAlias) Join ¶
func (a SubqueryAlias) Join(table TableOrAlias) Join
func (SubqueryAlias) LeftJoin ¶
func (a SubqueryAlias) LeftJoin(table TableOrAlias) Join
func (SubqueryAlias) RightJoin ¶
func (a SubqueryAlias) RightJoin(table TableOrAlias) Join
type Table ¶
type Table struct {
Name string
}
func (Table) As ¶
func (t Table) As(alias string) TableAlias
func (Table) InnerJoin ¶
func (t Table) InnerJoin(table TableOrAlias) Join
func (Table) Join ¶
func (t Table) Join(table TableOrAlias) Join
func (Table) LeftJoin ¶
func (t Table) LeftJoin(table TableOrAlias) Join
func (Table) RightJoin ¶
func (t Table) RightJoin(table TableOrAlias) Join
type TableAlias ¶
type TableAlias struct { Alias string // contains filtered or unexported fields }
func NewTableAlias ¶
func NewTableAlias(alias string) TableAlias
func (TableAlias) Column ¶
func (t TableAlias) Column(name string) Column
func (TableAlias) InnerJoin ¶
func (t TableAlias) InnerJoin(table TableOrAlias) Join
func (TableAlias) Join ¶
func (t TableAlias) Join(table TableOrAlias) Join
func (TableAlias) LeftJoin ¶
func (t TableAlias) LeftJoin(table TableOrAlias) Join
func (TableAlias) RightJoin ¶
func (t TableAlias) RightJoin(table TableOrAlias) Join
type TableOrAlias ¶
type TableOrAlias interface { Statement // contains filtered or unexported methods }
type Using ¶
type Using struct {
// contains filtered or unexported fields
}
func (Using) InnerJoin ¶
func (u Using) InnerJoin(table TableOrAlias) Join
func (Using) Join ¶
func (u Using) Join(table TableOrAlias) Join
func (Using) LeftJoin ¶
func (u Using) LeftJoin(table TableOrAlias) Join
func (Using) RightJoin ¶
func (u Using) RightJoin(table TableOrAlias) Join
type ValOrColOrAliasOrFuncOrSubOrFormula ¶
type ValOrColOrAliasOrFuncOrSubOrFormula interface { Statement // contains filtered or unexported methods }
type ValOrColOrFuncOrSub ¶
type ValOrColOrFuncOrSub interface { Statement // contains filtered or unexported methods }
type ValOrColOrFuncOrSubs ¶
type ValOrColOrFuncOrSubs []ValOrColOrFuncOrSub
func (ValOrColOrFuncOrSubs) ToArgs ¶
func (vs ValOrColOrFuncOrSubs) ToArgs() Args
type ValOrColOrSubOrFormula ¶
type ValOrColOrSubOrFormula interface { Statement // contains filtered or unexported methods }
type ValOrFuncOrSub ¶
type ValOrFuncOrSub interface { Statement // contains filtered or unexported methods }
type Where ¶
type Where struct {
// contains filtered or unexported fields
}
func NewWhere ¶
func NewWhere(operation ComparisonOrLogicalOperation) Where
type Wherer ¶
type Wherer interface {
Where(op ComparisonOrLogicalOperation) Where
}
Source Files ¶
- assign.go
- case_searched.go
- case_simple.go
- column.go
- column_alias.go
- create_table.go
- definition.go
- delete.go
- formula.go
- from.go
- func.go
- func_count.go
- func_date.go
- func_date_interval.go
- func_ifnull.go
- func_max.go
- func_string.go
- group_by.go
- having.go
- helpers.go
- insert.go
- interfaces.go
- join.go
- limit.go
- offset.go
- on.go
- op.go
- op_nonscalar.go
- order.go
- order_by.go
- select.go
- set.go
- set_operation.go
- subquery.go
- subquery_alias.go
- table.go
- table_alias.go
- update.go
- using.go
- val.go
- values.go
- where.go
- wildcard.go
Click to show internal directories.
Click to hide internal directories.