mysql

Documentation

Index

• func Delete(queryMods ...bob.Mod[*DeleteQuery]) bob.BaseQuery[*DeleteQuery]
• func F(name string, args ...any) *dialect.Function
• func Insert(queryMods ...bob.Mod[*InsertQuery]) bob.BaseQuery[*InsertQuery]
• func RawQuery(q string, args ...any) bob.BaseQuery[expr.Raw]
• func Select(queryMods ...bob.Mod[*SelectQuery]) bob.BaseQuery[*SelectQuery]
• func Update(queryMods ...bob.Mod[*UpdateQuery]) bob.BaseQuery[*UpdateQuery]
• type DeleteQuery
  • func (h *DeleteQuery) AppendHint(hint string)
  • func (h *DeleteQuery) AppendModifier(modifier T)
  • func (d DeleteQuery) WriteSQL(w io.Writer, dl bob.Dialect, start int) ([]any, error)
• type Expression
  • func And(args ...any) Expression
  • func Arg(args ...any) Expression
  • func Concat(args ...any) Expression
  • func Group(exps ...any) Expression
  • func Not(exp any) Expression
  • func Or(args ...any) Expression
  • func P(exp any) Expression
  • func Placeholder(n uint) Expression
  • func Quote(ss ...string) Expression
  • func Raw(query string, args ...any) Expression
  • func S(s string) Expression
  • func X(exp any, others ...any) Expression
• type InsertQuery
  • func (h *InsertQuery) AppendHint(hint string)
  • func (h *InsertQuery) AppendModifier(modifier T)
  • func (h *InsertQuery) AppendPartition(partitions ...string)
  • func (i InsertQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type SelectQuery
  • func (h *SelectQuery) AppendHint(hint string)
  • func (h *SelectQuery) AppendModifier(modifier T)
  • func (s *SelectQuery) SetInto(i any)
  • func (s SelectQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type Set
  • func (s Set) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type UpdateQuery
  • func (h *UpdateQuery) AppendHint(hint string)
  • func (h *UpdateQuery) AppendModifier(modifier T)
  • func (u UpdateQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

Functions

func Delete

func Delete(queryMods ...bob.Mod[*DeleteQuery]) bob.BaseQuery[*DeleteQuery]

func F

func F(name string, args ...any) *dialect.Function

func Insert

func Insert(queryMods ...bob.Mod[*InsertQuery]) bob.BaseQuery[*InsertQuery]

func RawQuery

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

func Select

func Select(queryMods ...bob.Mod[*SelectQuery]) bob.BaseQuery[*SelectQuery]

func Update

func Update(queryMods ...bob.Mod[*UpdateQuery]) bob.BaseQuery[*UpdateQuery]

Types

type DeleteQuery

type DeleteQuery struct {
	clause.With

	Tables []clause.Table
	clause.From
	clause.Where
	clause.OrderBy
	clause.Limit
	// contains filtered or unexported fields
}

Trying to represent the query structure as documented in https://dev.mysql.com/doc/refman/8.0/en/delete.html

func (*DeleteQuery) AppendHint

func (h *DeleteQuery) AppendHint(hint string)

func (*DeleteQuery) AppendModifier

func (h *DeleteQuery) AppendModifier(modifier T)

func (DeleteQuery) WriteSQL

func (d DeleteQuery) WriteSQL(w io.Writer, dl bob.Dialect, start int) ([]any, error)

type Expression

type Expression = dialect.Expression

func And

func And(args ...any) Expression

func Arg

func Arg(args ...any) Expression

func Concat

func Concat(args ...any) Expression

func Group

func Group(exps ...any) Expression

func Not

func Not(exp any) Expression

func Or

func Or(args ...any) Expression

func P

func P(exp any) Expression

func Placeholder

func Placeholder(n uint) Expression

func Quote

func Quote(ss ...string) Expression

func Raw

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

func S

func S(s string) Expression

func X

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

type InsertQuery

type InsertQuery struct {
	clause.Values

	Table              any
	Columns            []string
	RowAlias           string
	ColumnAlias        []string
	Sets               []Set
	DuplicateKeyUpdate []Set
	// contains filtered or unexported fields
}

Trying to represent the query structure as documented in https://dev.mysql.com/doc/refman/8.0/en/insert.html

func (*InsertQuery) AppendHint

func (h *InsertQuery) AppendHint(hint string)

func (*InsertQuery) AppendModifier

func (h *InsertQuery) AppendModifier(modifier T)

func (*InsertQuery) AppendPartition

func (h *InsertQuery) AppendPartition(partitions ...string)

func (InsertQuery) WriteSQL

func (i InsertQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

type SelectQuery

type SelectQuery struct {
	clause.With
	clause.SelectList
	clause.From
	clause.Where
	clause.GroupBy
	clause.Having
	clause.Windows

	clause.Combine
	clause.OrderBy
	clause.Limit
	clause.Offset
	clause.For
	clause.Load[*SelectQuery]
	// contains filtered or unexported fields
}

Trying to represent the query structure as documented in https://dev.mysql.com/doc/refman/8.0/en/select.html

func (*SelectQuery) AppendHint

func (h *SelectQuery) AppendHint(hint string)

func (*SelectQuery) AppendModifier

func (h *SelectQuery) AppendModifier(modifier T)

func (*SelectQuery) SetInto

func (s *SelectQuery) SetInto(i any)

func (SelectQuery) WriteSQL

func (s SelectQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

type Set

type Set struct {
	Col string
	Val any
}

func (Set) WriteSQL

func (s Set) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

type UpdateQuery

type UpdateQuery struct {
	clause.With
	clause.Set
	clause.From
	clause.Where
	clause.OrderBy
	clause.Limit
	// contains filtered or unexported fields
}

Trying to represent the select query structure as documented in https://www.postgresql.org/docs/current/sql-update.html

func (*UpdateQuery) AppendHint

func (h *UpdateQuery) AppendHint(hint string)

func (*UpdateQuery) AppendModifier

func (h *UpdateQuery) AppendModifier(modifier T)

func (UpdateQuery) WriteSQL

func (u UpdateQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)