sqlite

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 (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 Named(name string, value 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 (o *InsertQuery) SetOr(to string)
  • func (i InsertQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type SelectQuery
  • func (s SelectQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type UpdateQuery
  • func (o *UpdateQuery) SetOr(to string)
  • 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
	clause.From
	clause.Where
	clause.Returning
}

Trying to represent the select query structure as documented in https://www.sqlite.org/lang_delete.html

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 Named

func Named(name string, value 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.With

	clause.Table
	clause.Values
	clause.Conflict
	clause.Returning
	// contains filtered or unexported fields
}

Trying to represent the select query structure as documented in https://www.sqlite.org/lang_insert.html

func (*InsertQuery) SetOr

func (o *InsertQuery) SetOr(to 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.Load[*SelectQuery]
}

Trying to represent the select query structure as documented in https://www.sqlite.org/lang_select.html

func (SelectQuery) WriteSQL

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

type UpdateQuery

type UpdateQuery struct {
	clause.With

	Table clause.From
	clause.Set
	clause.From
	clause.Where
	clause.Returning
	// contains filtered or unexported fields
}

Trying to represent the select query structure as documented in https://www.sqlite.org/lang_update.html

func (*UpdateQuery) SetOr

func (o *UpdateQuery) SetOr(to string)

func (UpdateQuery) WriteSQL

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