mysql

package
v0.1.0 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jul 30, 2022 License: MIT Imports: 6 Imported by: 4

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func And 

func And(args ...any) chain

func Arg 

func Arg(args ...any) chain

func Concat 

func Concat(args ...any) chain

func Delete 

func Delete(queryMods ...query.Mod[*deleteQuery]) query.BaseQuery[*deleteQuery]

func F 

func F(name string, args ...any) *function

func Group 

func Group(exps ...any) chain

func Insert 

func Insert(queryMods ...query.Mod[*insertQuery]) query.BaseQuery[*insertQuery]

func Not 

func Not(exp any) chain

func Or 

func Or(args ...any) chain

func P 

func P(exp any) chain

func Placeholder 

func Placeholder(n uint) chain

func Quote 

func Quote(ss ...string) chain

func Raw 

func Raw(query string, args ...any) chain

func RawQuery 

func RawQuery(q string, args ...any) query.BaseQuery[expr.Raw]

func S 

func S(s string) chain

func Select 

func Select(queryMods ...query.Mod[*selectQuery]) query.BaseQuery[*selectQuery]

func Update 

func Update(queryMods ...query.Mod[*updateQuery]) query.BaseQuery[*updateQuery]

func X 

func X(exp any, others ...any) chain

Types

type DeleteQM 

type DeleteQM struct {
	mods.FromMod[*deleteQuery]
	// contains filtered or unexported fields
}

func (DeleteQM) CrossJoin 

func (j DeleteQM) CrossJoin(e any) query.Mod[Q]

func (DeleteQM) ForceIndex 

func (DeleteQM) ForceIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (DeleteQM) From 

func (qm DeleteQM) From(name any) query.Mod[*deleteQuery]

func (DeleteQM) FromAs 

func (qm DeleteQM) FromAs(name any, alias string) query.Mod[*deleteQuery]

func (DeleteQM) Ignore 

func (DeleteQM) Ignore() query.Mod[*deleteQuery]

func (DeleteQM) IgnoreIndex 

func (DeleteQM) IgnoreIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (DeleteQM) InnerJoin 

func (j DeleteQM) InnerJoin(e any) joinChain[Q]

func (DeleteQM) Lateral 

func (DeleteQM) Lateral() query.Mod[*clause.FromItem]

func (DeleteQM) LeftJoin 

func (j DeleteQM) LeftJoin(e any) joinChain[Q]

func (DeleteQM) Limit 

func (DeleteQM) Limit(count int64) query.Mod[*deleteQuery]

func (DeleteQM) LowPriority 

func (DeleteQM) LowPriority() query.Mod[*deleteQuery]

func (DeleteQM) MaxExecutionTime 

func (DeleteQM) MaxExecutionTime(n int) query.Mod[Q]

func (DeleteQM) OrderBy 

func (DeleteQM) OrderBy(e any) orderBy[*deleteQuery]

func (DeleteQM) Quick 

func (DeleteQM) Quick() query.Mod[*deleteQuery]

func (DeleteQM) Recursive 

func (DeleteQM) Recursive(r bool) query.Mod[Q]

func (DeleteQM) RightJoin 

func (j DeleteQM) RightJoin(e any) joinChain[Q]

func (DeleteQM) SetVar 

func (DeleteQM) SetVar(statement string) query.Mod[Q]

func (DeleteQM) StraightJoin 

func (j DeleteQM) StraightJoin(e any) query.Mod[Q]

func (DeleteQM) UseIndex 

func (DeleteQM) UseIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (DeleteQM) Using 

func (qm DeleteQM) Using(table any, usingMods ...query.Mod[*clause.FromItem]) query.Mod[*deleteQuery]

func (DeleteQM) Where 

func (qm DeleteQM) Where(e query.Expression) query.Mod[*deleteQuery]

func (DeleteQM) WhereClause 

func (qm DeleteQM) WhereClause(clause string, args ...any) query.Mod[*deleteQuery]

func (DeleteQM) With 

func (DeleteQM) With(name string, columns ...string) cteChain[Q]

type Dialect 

type Dialect struct{}

func (Dialect) WriteArg 

func (d Dialect) WriteArg(w io.Writer, position int)

func (Dialect) WriteQuoted 

func (d Dialect) WriteQuoted(w io.Writer, s string)

type InsertQM 

type InsertQM struct {
	// contains filtered or unexported fields
}

func (InsertQM) Apply 

func (s InsertQM) Apply(q Q)

func (InsertQM) As 

func (qm InsertQM) As(rowAlias string, colAlias ...string) query.Mod[*insertQuery]

func (InsertQM) HighPriority 

func (qm InsertQM) HighPriority() query.Mod[*insertQuery]

func (InsertQM) Ignore 

func (qm InsertQM) Ignore() query.Mod[*insertQuery]

func (InsertQM) Into 

func (qm InsertQM) Into(name any, columns ...string) query.Mod[*insertQuery]

func (InsertQM) LowPriority 

func (qm InsertQM) LowPriority() query.Mod[*insertQuery]

func (InsertQM) MaxExecutionTime 

func (InsertQM) MaxExecutionTime(n int) query.Mod[Q]

func (InsertQM) OnDuplicateKeyUpdate 

func (qm InsertQM) OnDuplicateKeyUpdate(sets ...setMod[*insertQuery]) query.Mod[*insertQuery]

func (InsertQM) Partition 

func (p InsertQM) Partition(partitions ...string) query.Mod[Q]

func (InsertQM) Query 

func (qm InsertQM) Query(q query.BaseQuery[*selectQuery]) query.Mod[*insertQuery]

Insert from a query If Go allows type parameters on methods, limit this to select, table and raw

func (InsertQM) Set 

func (qm InsertQM) Set(col string, val any) setMod[*insertQuery]

Insert with Set a = b

func (InsertQM) SetVar 

func (InsertQM) SetVar(statement string) query.Mod[Q]

func (InsertQM) Values 

func (qm InsertQM) Values(clauses ...any) query.Mod[*insertQuery]

type SelectQM 

type SelectQM struct {
	mods.FromMod[*selectQuery] // select *FROM*
	// contains filtered or unexported fields
}

func (SelectQM) BigResult 

func (SelectQM) BigResult() query.Mod[*selectQuery]

func (SelectQM) BufferResult 

func (SelectQM) BufferResult() query.Mod[*selectQuery]

func (SelectQM) Columns 

func (SelectQM) Columns(clauses ...any) query.Mod[*selectQuery]

func (SelectQM) CrossJoin 

func (j SelectQM) CrossJoin(e any) query.Mod[Q]

func (SelectQM) Distinct 

func (SelectQM) Distinct(on ...any) query.Mod[*selectQuery]

func (SelectQM) ForShare 

func (SelectQM) ForShare(tables ...string) lockChain[*selectQuery]

func (SelectQM) ForUpdate 

func (SelectQM) ForUpdate(tables ...string) lockChain[*selectQuery]

func (SelectQM) ForceIndex 

func (SelectQM) ForceIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (SelectQM) GroupBy 

func (SelectQM) GroupBy(e any) query.Mod[*selectQuery]

func (SelectQM) Having 

func (SelectQM) Having(e query.Expression) query.Mod[*selectQuery]

func (SelectQM) HavingClause 

func (qm SelectQM) HavingClause(clause string, args ...any) query.Mod[*selectQuery]

func (SelectQM) HighPriority 

func (SelectQM) HighPriority() query.Mod[*selectQuery]

func (SelectQM) IgnoreIndex 

func (SelectQM) IgnoreIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (SelectQM) InnerJoin 

func (j SelectQM) InnerJoin(e any) joinChain[Q]

func (SelectQM) Into 

func (i SelectQM) Into(var1 string, vars ...string) query.Mod[Q]

No need for the leading @

func (SelectQM) IntoDumpfile 

func (i SelectQM) IntoDumpfile(filename string) query.Mod[Q]

func (SelectQM) IntoOutfile 

func (i SelectQM) IntoOutfile(filename string) *intoChain[Q]

func (SelectQM) Lateral 

func (SelectQM) Lateral() query.Mod[*clause.FromItem]

func (SelectQM) LeftJoin 

func (j SelectQM) LeftJoin(e any) joinChain[Q]

func (SelectQM) Limit 

func (SelectQM) Limit(count int64) query.Mod[*selectQuery]

func (SelectQM) MaxExecutionTime 

func (SelectQM) MaxExecutionTime(n int) query.Mod[Q]

func (SelectQM) Offset 

func (SelectQM) Offset(count int64) query.Mod[*selectQuery]

func (SelectQM) OrderBy 

func (SelectQM) OrderBy(e any) orderBy[*selectQuery]

func (SelectQM) Recursive 

func (SelectQM) Recursive(r bool) query.Mod[Q]

func (SelectQM) RightJoin 

func (j SelectQM) RightJoin(e any) joinChain[Q]

func (SelectQM) SetVar 

func (SelectQM) SetVar(statement string) query.Mod[Q]

func (SelectQM) SmallResult 

func (SelectQM) SmallResult() query.Mod[*selectQuery]

func (SelectQM) Straight 

func (SelectQM) Straight() query.Mod[*selectQuery]

func (SelectQM) StraightJoin 

func (j SelectQM) StraightJoin(e any) query.Mod[Q]

func (SelectQM) Union 

func (SelectQM) Union(q query.Query) query.Mod[*selectQuery]

func (SelectQM) UnionAll 

func (SelectQM) UnionAll(q query.Query) query.Mod[*selectQuery]

func (SelectQM) UseIndex 

func (SelectQM) UseIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (SelectQM) Where 

func (SelectQM) Where(e query.Expression) query.Mod[*selectQuery]

func (SelectQM) WhereClause 

func (qm SelectQM) WhereClause(clause string, args ...any) query.Mod[*selectQuery]

func (SelectQM) Window 

func (SelectQM) Window(name string) windowMod[*selectQuery]

func (SelectQM) With 

func (SelectQM) With(name string, columns ...string) cteChain[Q]

func (SelectQM) WithRollup 

func (SelectQM) WithRollup(distinct bool) query.Mod[*selectQuery]

type UpdateQM 

type UpdateQM struct {
	// contains filtered or unexported fields
}

func (UpdateQM) CrossJoin 

func (j UpdateQM) CrossJoin(e any) query.Mod[Q]

func (UpdateQM) ForceIndex 

func (UpdateQM) ForceIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (UpdateQM) Ignore 

func (UpdateQM) Ignore() query.Mod[*deleteQuery]

func (UpdateQM) IgnoreIndex 

func (UpdateQM) IgnoreIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (UpdateQM) InnerJoin 

func (j UpdateQM) InnerJoin(e any) joinChain[Q]

func (UpdateQM) Lateral 

func (UpdateQM) Lateral() query.Mod[*clause.FromItem]

func (UpdateQM) LeftJoin 

func (j UpdateQM) LeftJoin(e any) joinChain[Q]

func (UpdateQM) Limit 

func (UpdateQM) Limit(count int64) query.Mod[*updateQuery]

func (UpdateQM) LowPriority 

func (UpdateQM) LowPriority() query.Mod[*deleteQuery]

func (UpdateQM) MaxExecutionTime 

func (UpdateQM) MaxExecutionTime(n int) query.Mod[Q]

func (UpdateQM) OrderBy 

func (UpdateQM) OrderBy(e any) orderBy[*updateQuery]

func (UpdateQM) Recursive 

func (UpdateQM) Recursive(r bool) query.Mod[Q]

func (UpdateQM) RightJoin 

func (j UpdateQM) RightJoin(e any) joinChain[Q]

func (UpdateQM) Set 

func (UpdateQM) Set(a string, b any) query.Mod[*updateQuery]

func (UpdateQM) SetArg 

func (UpdateQM) SetArg(a string, b any) query.Mod[*updateQuery]

func (UpdateQM) SetVar 

func (UpdateQM) SetVar(statement string) query.Mod[Q]

func (UpdateQM) StraightJoin 

func (j UpdateQM) StraightJoin(e any) query.Mod[Q]

func (UpdateQM) Table 

func (u UpdateQM) Table(name any, mods ...query.Mod[*clause.FromItem]) query.Mod[*updateQuery]

func (UpdateQM) TableAs 

func (u UpdateQM) TableAs(name any, alias string, mods ...query.Mod[*clause.FromItem]) query.Mod[*updateQuery]

func (UpdateQM) UseIndex 

func (UpdateQM) UseIndex(first string, others ...string) *indexHintChain[*clause.FromItem]

func (UpdateQM) Where 

func (UpdateQM) Where(e query.Expression) query.Mod[*updateQuery]

func (UpdateQM) WhereClause 

func (UpdateQM) WhereClause(clause string, args ...any) query.Mod[*updateQuery]

func (UpdateQM) With 

func (UpdateQM) With(name string, columns ...string) cteChain[Q]

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.