Documentation
¶
Index ¶
- Variables
- func All(v any) any
- func Any(v any) any
- func Arg(v any) any
- func NotArg(v any) any
- func Raw(v any) any
- type Cond
- type CondMode
- type CondOp
- type CondValue
- type CondValues
- type ConflictAction
- type ConflictTarget
- type DeleteStatement
- type Distinct
- type InsertStatement
- type Join
- type OrderBy
- type Result
- func (r *Result) Exec(f func(string, ...any) (sql.Result, error)) (sql.Result, error)
- func (r *Result) ExecContext(ctx context.Context, ...) (sql.Result, error)
- func (r *Result) ExecWith(ctx context.Context) (pgconn.CommandTag, error)
- func (r *Result) IterWith(ctx context.Context, iter pgsql.Iterator) error
- func (r *Result) Query(f func(string, ...any) (*sql.Rows, error)) (*pgsql.Rows, error)
- func (r *Result) QueryContext(ctx context.Context, ...) (*pgsql.Rows, error)
- func (r *Result) QueryRow(f func(string, ...any) *sql.Row) *pgsql.Row
- func (r *Result) QueryRowContext(ctx context.Context, f func(context.Context, string, ...any) *sql.Row) *pgsql.Row
- func (r *Result) QueryRowWith(ctx context.Context) pgx.Row
- func (r *Result) QueryWith(ctx context.Context) (pgx.Rows, error)
- func (r *Result) SQL() (query string, args []any)
- type SelectStatement
- type Set
- type UnionStatement
- type UpdateStatement
- type Values
Constants ¶
This section is empty.
Variables ¶
View Source
var Default any = defaultValue{}
Default use for insert default value
Functions ¶
Types ¶
type Cond ¶
type Cond interface { Op(field any, op string, value any) OpRaw(field any, op string, rawValue any) Eq(field, value any) EqRaw(field, rawValue any) Ne(field, value any) NeRaw(field, rawValue any) Lt(field, value any) LtRaw(field, rawValue any) Le(field, value any) LeRaw(field, rawValue any) Gt(field, value any) GtRaw(field, rawValue any) Ge(field, value any) GeRaw(field, rawValue any) Like(field, value any) LikeRaw(field, rawValue any) ILike(field, value any) ILikeRaw(field, rawValue any) In(field any, value ...any) InRaw(field any, value ...any) InSelect(field any, f func(b SelectStatement)) NotIn(field any, value ...any) NotInRaw(field any, value ...any) IsNull(field any) IsNotNull(field any) Field(field any) CondOp Value(value any) CondOp Raw(sql string) Not(f func(b Cond)) And(f func(b Cond)) Or(f func(b Cond)) Mode() CondMode }
Cond is the condition builder
type CondOp ¶
type CondOp interface { Op(op string) CondValue OpValues(op string) CondValues Eq() CondValue Ne() CondValue Lt() CondValue Le() CondValue Gt() CondValue Ge() CondValue Like() CondValue ILike() CondValue In() CondValues NotIn() CondValues IsNull() IsNotNull() }
type CondValues ¶
type CondValues interface { Value(values ...any) Raw(rawValues ...any) Field(field any) Select(f func(b SelectStatement)) }
type ConflictAction ¶
type ConflictAction interface { DoNothing() DoUpdate(f func(b UpdateStatement)) }
type ConflictTarget ¶
type DeleteStatement ¶
type InsertStatement ¶
type InsertStatement interface { Into(table string) Columns(col ...string) OverridingSystemValue() OverridingUserValue() DefaultValues() Value(value ...any) Values(values ...any) Select(f func(b SelectStatement)) OnConflict(f func(b ConflictTarget)) ConflictAction // OnConflictDoNothing is the shortcut for // OnConflict(func(b ConflictTarget) {}).DoNothing() OnConflictDoNothing() // OnConflictIndex is the shortcut for // OnConflict(func(b ConflictTarget) { // b.Index(target...) // }) OnConflictIndex(target ...string) ConflictAction // OnConflictOnConstraint is the shortcut for // OnConflict(func(b ConflictTarget) { // b.OnConstraint(constraintName) // }) OnConflictOnConstraint(constraintName string) ConflictAction Returning(col ...string) }
InsertStatement is the insert statement builder
type Result ¶
type Result struct {
// contains filtered or unexported fields
}
func Union ¶
func Union(f func(b UnionStatement)) *Result
func (*Result) ExecContext ¶
func (*Result) QueryContext ¶
func (*Result) QueryRowContext ¶
func (*Result) QueryRowWith ¶
type SelectStatement ¶
type SelectStatement interface { Distinct() Distinct Columns(col ...any) ColumnSelect(f func(b SelectStatement), as string) From(table ...string) FromSelect(f func(b SelectStatement), as string) FromValues(f func(b Values), as string) Join(table string) Join InnerJoin(table string) Join FullOuterJoin(table string) Join LeftJoin(table string) Join RightJoin(table string) Join JoinSelect(f func(b SelectStatement), as string) Join InnerJoinSelect(f func(b SelectStatement), as string) Join FullOuterJoinSelect(f func(b SelectStatement), as string) Join LeftJoinSelect(f func(b SelectStatement), as string) Join RightJoinSelect(f func(b SelectStatement), as string) Join JoinLateralSelect(f func(b SelectStatement), as string) Join InnerJoinLateralSelect(f func(b SelectStatement), as string) Join FullOuterJoinLateralSelect(f func(b SelectStatement), as string) Join LeftJoinLateralSelect(f func(b SelectStatement), as string) Join RightJoinLateralSelect(f func(b SelectStatement), as string) Join JoinUnion(f func(b UnionStatement), as string) Join InnerJoinUnion(f func(b UnionStatement), as string) Join FullOuterJoinUnion(f func(b UnionStatement), as string) Join LeftJoinUnion(f func(b UnionStatement), as string) Join RightJoinUnion(f func(b UnionStatement), as string) Join Where(f func(b Cond)) GroupBy(col ...string) Having(f func(b Cond)) OrderBy(col string) OrderBy Limit(n int64) Offset(n int64) }
SelectStatement is the select statement builder
type Set ¶
type Set interface { To(value ...any) ToRaw(rawValue ...any) Select(f func(b SelectStatement)) }
type UnionStatement ¶
type UnionStatement interface { Select(f func(b SelectStatement)) AllSelect(f func(b SelectStatement)) Union(f func(b UnionStatement)) AllUnion(f func(b UnionStatement)) OrderBy(col string) OrderBy Limit(n int64) Offset(n int64) }
type UpdateStatement ¶
type UpdateStatement interface { Table(table string) Set(col ...string) Set From(table ...string) Join(table string) Join InnerJoin(table string) Join FullOuterJoin(table string) Join LeftJoin(table string) Join RightJoin(table string) Join Where(f func(b Cond)) WhereCurrentOf(cursor string) Returning(col ...string) }
Click to show internal directories.
Click to hide internal directories.