sqlbuild

package
v0.1.1 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Sep 16, 2026 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddColumnBuilder 

type AddColumnBuilder struct {
	// contains filtered or unexported fields
}

func AddColumn 

func AddColumn(t Table, column string, goType reflect.Type, spec dialect.ColumnSpec) *AddColumnBuilder

func (*AddColumnBuilder) Render 

func (b *AddColumnBuilder) Render(d dialect.Dialect) (string, []any, error)

type AlterColumnBuilder 

type AlterColumnBuilder struct {
	// contains filtered or unexported fields
}

func AlterColumn 

func AlterColumn(t Table, column string, goType reflect.Type, spec dialect.ColumnSpec) *AlterColumnBuilder

func (*AlterColumnBuilder) Render 

func (b *AlterColumnBuilder) Render(d dialect.Dialect) (string, []any, error)

type Assignment 

type Assignment struct {
	Col Column
	// contains filtered or unexported fields
}

func Set 

func Set(c Column, v any) Assignment

func SetExpr 

func SetExpr(c Column, sqlExpr string, args ...any) Assignment

type Column 

type Column struct {
	Table string
	Name  string
}

func Col 

func Col(name string) Column

func QualifiedCol 

func QualifiedCol(tableAlias, name string) Column

type CreateConstraintBuilder 

type CreateConstraintBuilder struct {
	// contains filtered or unexported fields
}

func CreateForeignKeyConstraint 

func CreateForeignKeyConstraint(t Table, name string, localCols []string, refTable string, refCols []string) *CreateConstraintBuilder

func (*CreateConstraintBuilder) Render 

func (b *CreateConstraintBuilder) Render(d dialect.Dialect) (string, []any, error)

type CreateIndexBuilder 

type CreateIndexBuilder struct {
	// contains filtered or unexported fields
}

func CreateIndex 

func CreateIndex(t Table, name string, columns ...string) *CreateIndexBuilder

func (*CreateIndexBuilder) Render 

func (b *CreateIndexBuilder) Render(d dialect.Dialect) (string, []any, error)

func (*CreateIndexBuilder) Unique 

func (b *CreateIndexBuilder) Unique() *CreateIndexBuilder

type CreateTableBuilder 

type CreateTableBuilder struct {
	// contains filtered or unexported fields
}

func CreateTable 

func CreateTable(t Table) *CreateTableBuilder

func (*CreateTableBuilder) Column 

func (b *CreateTableBuilder) Column(name string, goType reflect.Type, spec dialect.ColumnSpec) *CreateTableBuilder

func (*CreateTableBuilder) IfNotExists 

func (b *CreateTableBuilder) IfNotExists() *CreateTableBuilder

func (*CreateTableBuilder) Render 

func (b *CreateTableBuilder) Render(d dialect.Dialect) (string, []any, error)

type DeleteBuilder 

type DeleteBuilder struct {
	// contains filtered or unexported fields
}

func Delete 

func Delete(t Table) *DeleteBuilder

func (*DeleteBuilder) Render 

func (b *DeleteBuilder) Render(d dialect.Dialect) (string, []any, error)

func (*DeleteBuilder) Where 

func (b *DeleteBuilder) Where(p Predicate) *DeleteBuilder

type DropColumnBuilder 

type DropColumnBuilder struct {
	// contains filtered or unexported fields
}

func DropColumn 

func DropColumn(t Table, column string) *DropColumnBuilder

func (*DropColumnBuilder) Render 

func (b *DropColumnBuilder) Render(d dialect.Dialect) (string, []any, error)

type DropConstraintBuilder 

type DropConstraintBuilder struct {
	// contains filtered or unexported fields
}

func DropConstraint 

func DropConstraint(t Table, name string) *DropConstraintBuilder

func (*DropConstraintBuilder) Render 

func (b *DropConstraintBuilder) Render(d dialect.Dialect) (string, []any, error)

type DropIndexBuilder 

type DropIndexBuilder struct {
	// contains filtered or unexported fields
}

func DropIndex 

func DropIndex(t Table, index string) *DropIndexBuilder

func (*DropIndexBuilder) Render 

func (b *DropIndexBuilder) Render(d dialect.Dialect) (string, []any, error)

type DropTableBuilder 

type DropTableBuilder struct {
	// contains filtered or unexported fields
}

func DropTable 

func DropTable(t Table) *DropTableBuilder

func (*DropTableBuilder) Render 

func (b *DropTableBuilder) Render(d dialect.Dialect) (string, []any, error)

type ErrConflictingLockClause 

type ErrConflictingLockClause struct{}

func (*ErrConflictingLockClause) Error 

func (e *ErrConflictingLockClause) Error() string

type ErrConstraintsUnsupportedByDialect 

type ErrConstraintsUnsupportedByDialect struct {
	Dialect string
}

func (*ErrConstraintsUnsupportedByDialect) Error 

func (c *ErrConstraintsUnsupportedByDialect) Error() string

type ErrDDLUnsupportedByDialect 

type ErrDDLUnsupportedByDialect struct {
	Dialect string
}

func (*ErrDDLUnsupportedByDialect) Error 

func (d *ErrDDLUnsupportedByDialect) Error() string

type ErrILikeUnsupportedByDialect 

type ErrILikeUnsupportedByDialect struct {
	Dialect string
}

func (*ErrILikeUnsupportedByDialect) Error 

func (e *ErrILikeUnsupportedByDialect) Error() string

type ErrRawPlaceholderOutOfRange 

type ErrRawPlaceholderOutOfRange struct {
	Fragment string
	Index    int
	NumArgs  int
}

func (*ErrRawPlaceholderOutOfRange) Error 

func (e *ErrRawPlaceholderOutOfRange) Error() string

type ErrReturningUnsupportedByDialect 

type ErrReturningUnsupportedByDialect struct {
	Dialect string
}

func (*ErrReturningUnsupportedByDialect) Error 

func (e *ErrReturningUnsupportedByDialect) Error() string

type ErrRowLockingUnsupportedByDialect 

type ErrRowLockingUnsupportedByDialect struct {
	Dialect string
}

func (*ErrRowLockingUnsupportedByDialect) Error 

func (e *ErrRowLockingUnsupportedByDialect) Error() string

type ErrSkipLockedRequiresLockClause 

type ErrSkipLockedRequiresLockClause struct{}

func (*ErrSkipLockedRequiresLockClause) Error 

func (e *ErrSkipLockedRequiresLockClause) Error() string

type InsertBuilder 

type InsertBuilder struct {
	// contains filtered or unexported fields
}

func Insert 

func Insert(t Table) *InsertBuilder

func (*InsertBuilder) OnConflictDoNothing 

func (b *InsertBuilder) OnConflictDoNothing(cols ...Column) *InsertBuilder

func (*InsertBuilder) OnConflictDoUpdate 

func (b *InsertBuilder) OnConflictDoUpdate(cols []Column, assignments ...Assignment) *InsertBuilder

func (*InsertBuilder) Render 

func (b *InsertBuilder) Render(d dialect.Dialect) (string, []any, error)

func (*InsertBuilder) Returning 

func (b *InsertBuilder) Returning(cols ...Column) *InsertBuilder

func (*InsertBuilder) Values 

func (b *InsertBuilder) Values(a ...Assignment) *InsertBuilder

type Join 

type Join struct {
	// contains filtered or unexported fields
}

type JoinKind 

type JoinKind int
const (
	InnerJoin JoinKind = iota
	LeftJoin
)

type OrderTerm 

type OrderTerm struct {
	// contains filtered or unexported fields
}

func Asc 

func Asc(c Column) OrderTerm

func Desc 

func Desc(c Column) OrderTerm

func OrderRaw 

func OrderRaw(fragment string) OrderTerm

type Predicate 

type Predicate struct {
	// contains filtered or unexported fields
}

func And 

func And(preds ...Predicate) Predicate

func Between 

func Between(c Column, lo, hi any) Predicate

func Eq 

func Eq(c Column, v any) Predicate

func EqCol 

func EqCol(left, right Column) Predicate

func Gt 

func Gt(c Column, v any) Predicate

func Gte 

func Gte(c Column, v any) Predicate

func ILike 

func ILike(c Column, pattern string) Predicate

func In 

func In(c Column, vs ...any) Predicate

func IsNotNull 

func IsNotNull(c Column) Predicate

func IsNull 

func IsNull(c Column) Predicate

func Like 

func Like(c Column, pattern string) Predicate

func Lt 

func Lt(c Column, v any) Predicate

func Lte 

func Lte(c Column, v any) Predicate

func Ne 

func Ne(c Column, v any) Predicate

func Not 

func Not(p Predicate) Predicate

func NotIn 

func NotIn(c Column, vs ...any) Predicate

func NotLike 

func NotLike(c Column, pattern string) Predicate

func Or 

func Or(preds ...Predicate) Predicate

func Raw 

func Raw(fragment string, args ...any) Predicate

func (Predicate) IsZero 

func (p Predicate) IsZero() bool

type RenameColumnBuilder 

type RenameColumnBuilder struct {
	// contains filtered or unexported fields
}

func RenameColumn 

func RenameColumn(t Table, oldName, newName string) *RenameColumnBuilder

func (*RenameColumnBuilder) Render 

func (b *RenameColumnBuilder) Render(d dialect.Dialect) (string, []any, error)

type RenameIndexBuilder 

type RenameIndexBuilder struct {
	// contains filtered or unexported fields
}

func RenameIndex 

func RenameIndex(t Table, oldName, newName string) *RenameIndexBuilder

func (*RenameIndexBuilder) Render 

func (b *RenameIndexBuilder) Render(d dialect.Dialect) (string, []any, error)

type RenameTableBuilder 

type RenameTableBuilder struct {
	// contains filtered or unexported fields
}

func RenameTable 

func RenameTable(t Table, newName string) *RenameTableBuilder

func (*RenameTableBuilder) Render 

func (b *RenameTableBuilder) Render(d dialect.Dialect) (string, []any, error)

type SelectBuilder 

type SelectBuilder struct {
	// contains filtered or unexported fields
}

func Select 

func Select(t Table) *SelectBuilder

func (*SelectBuilder) Columns 

func (b *SelectBuilder) Columns(cols ...Column) *SelectBuilder

func (*SelectBuilder) Distinct 

func (b *SelectBuilder) Distinct() *SelectBuilder

func (*SelectBuilder) ForShare 

func (b *SelectBuilder) ForShare() *SelectBuilder

func (*SelectBuilder) ForUpdate 

func (b *SelectBuilder) ForUpdate() *SelectBuilder

func (*SelectBuilder) GroupBy 

func (b *SelectBuilder) GroupBy(cols ...Column) *SelectBuilder

func (*SelectBuilder) Having 

func (b *SelectBuilder) Having(p Predicate) *SelectBuilder

func (*SelectBuilder) Join 

func (b *SelectBuilder) Join(t Table, on Predicate) *SelectBuilder

func (*SelectBuilder) LeftJoin 

func (b *SelectBuilder) LeftJoin(t Table, on Predicate) *SelectBuilder

func (*SelectBuilder) Limit 

func (b *SelectBuilder) Limit(n int64) *SelectBuilder

func (*SelectBuilder) Offset 

func (b *SelectBuilder) Offset(n int64) *SelectBuilder

func (*SelectBuilder) OrderBy 

func (b *SelectBuilder) OrderBy(terms ...OrderTerm) *SelectBuilder

func (*SelectBuilder) Render 

func (b *SelectBuilder) Render(d dialect.Dialect) (string, []any, error)

func (*SelectBuilder) SelectRaw 

func (b *SelectBuilder) SelectRaw(fragment string) *SelectBuilder

func (*SelectBuilder) SkipLocked 

func (b *SelectBuilder) SkipLocked() *SelectBuilder

func (*SelectBuilder) Where 

func (b *SelectBuilder) Where(p Predicate) *SelectBuilder

type Table 

type Table struct {
	Name  string
	Alias string
}

type UpdateBuilder 

type UpdateBuilder struct {
	// contains filtered or unexported fields
}

func Update 

func Update(t Table) *UpdateBuilder

func (*UpdateBuilder) Render 

func (b *UpdateBuilder) Render(d dialect.Dialect) (string, []any, error)

func (*UpdateBuilder) Set 

func (b *UpdateBuilder) Set(a ...Assignment) *UpdateBuilder

func (*UpdateBuilder) Where 

func (b *UpdateBuilder) Where(p Predicate) *UpdateBuilder

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.