mysql

Documentation

Index

• Variables
• func Delete(queryMods ...bob.Mod[*DeleteQuery]) bob.BaseQuery[*DeleteQuery]
• func F(name string, args ...any) *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 (h *DeleteQuery) AppendPartition(partitions ...string)
  • func (d DeleteQuery) WriteSQL(w io.Writer, dl bob.Dialect, start int) ([]any, error)
• type Dialect
  • func (d Dialect) WriteArg(w io.Writer, position int)
  • func (d Dialect) WriteQuoted(w io.Writer, s string)
• 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
  • func (Expression) New(exp any) Expression
  • func (x Expression) String() string
• 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) 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)

Variables

var DeleteQM = deleteQM{}

var InsertQM = insertQM{}

var SelectQM = selectQM{}

var UpdateQM = updateQM{}

Functions

func Delete

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

func F

func F(name string, args ...any) *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

	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) AppendPartition

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

func (DeleteQuery) WriteSQL

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

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 Expression

type Expression struct {
	expr.Chain[Expression, 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

func (Expression) New

func (Expression) New(exp any) Expression

func (Expression) String

func (x Expression) String() string

Implements fmt.Stringer()

type InsertQuery

type InsertQuery struct {
	clause.Values
	// 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.Select
	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) WriteSQL

func (s SelectQuery) 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)