psql

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 (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 (x Expression) BetweenSymmetric(a, b any) Expression
  • func (Expression) New(exp any) Expression
  • func (x Expression) NotBetweenSymmetric(a, b any) Expression
  • func (x Expression) String() string
• type InsertQuery
  • 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 (u UpdateQuery) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type ValuesQuery

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.Table
	clause.From
	clause.Where
	clause.Returning
	// contains filtered or unexported fields
}

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

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

func (x Expression) BetweenSymmetric(a, b any) Expression

BETWEEN SYMMETRIC a AND b

func (Expression) New

func (Expression) New(exp any) Expression

func (Expression) NotBetweenSymmetric

func (x Expression) NotBetweenSymmetric(a, b any) Expression

NOT BETWEEN SYMMETRIC a AND b

func (Expression) String

func (x Expression) String() string

Implements fmt.Stringer()

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.postgresql.org/docs/current/sql-insert.html

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.Fetch
	clause.For
	clause.Load[*SelectQuery]
}

Trying to represent the select query structure as documented in https://www.postgresql.org/docs/current/sql-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

	clause.Table
	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.postgresql.org/docs/current/sql-update.html

func (UpdateQuery) WriteSQL

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

type ValuesQuery

type ValuesQuery struct {
	// insert the group
	clause.OrderBy
	clause.Limit
	clause.Offset
	clause.Fetch
}