querybuilder

package
v0.1.5 Latest Latest
Warning

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

Go to latest
Published: Mar 1, 2026 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

View Source
const (
	DefaultUnsetLimit  = -1
	DefaultUnsetOffset = -1
)

Variables

This section is empty.

Functions

This section is empty.

Types

type DeleteQueryBuilder added in v0.1.4

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

func NewDeleteQueryBuilder added in v0.1.4

func NewDeleteQueryBuilder() *DeleteQueryBuilder

func (*DeleteQueryBuilder) Build added in v0.1.4

func (qb *DeleteQueryBuilder) Build() (Query, error)

Build constructs the Query struct

func (*DeleteQueryBuilder) From added in v0.1.4

func (qb *DeleteQueryBuilder) From(table string) *DeleteQueryBuilder

func (*DeleteQueryBuilder) Limit added in v0.1.4

func (qb *DeleteQueryBuilder) Limit(limit int) *DeleteQueryBuilder

func (*DeleteQueryBuilder) Offset added in v0.1.4

func (qb *DeleteQueryBuilder) Offset(offset int) *DeleteQueryBuilder

func (*DeleteQueryBuilder) OrWhere added in v0.1.4

func (qb *DeleteQueryBuilder) OrWhere(condition string, args ...interface{}) *DeleteQueryBuilder

func (*DeleteQueryBuilder) OrderBy added in v0.1.4

func (qb *DeleteQueryBuilder) OrderBy(clauses ...string) *DeleteQueryBuilder

func (*DeleteQueryBuilder) Where added in v0.1.4

func (qb *DeleteQueryBuilder) Where(condition string, args ...interface{}) *DeleteQueryBuilder

type InsertQueryBuilder

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

func (*InsertQueryBuilder) Build

func (b *InsertQueryBuilder) Build() (string, []interface{}, error)

func (*InsertQueryBuilder) Columns

func (b *InsertQueryBuilder) Columns(cols ...string) *InsertQueryBuilder

Columns sets the columns for the INSERT.

func (*InsertQueryBuilder) Into

func (*InsertQueryBuilder) Values

func (b *InsertQueryBuilder) Values(vals ...interface{}) *InsertQueryBuilder

type Query

type Query struct {
	SQL  string
	Args []interface{}
}

func (Query) ToSQL

func (q Query) ToSQL() (string, []interface{})

ToSQL returns the SQL string and arguments for the query

type QueryBuilder

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

func NewQueryBuilder

func NewQueryBuilder() *QueryBuilder

func (*QueryBuilder) Build

func (qb *QueryBuilder) Build() Query

Build constructs the Query struct

func (*QueryBuilder) Distinct

func (qb *QueryBuilder) Distinct() *QueryBuilder

func (*QueryBuilder) From

func (qb *QueryBuilder) From(table string) *QueryBuilder

func (*QueryBuilder) GroupBy

func (qb *QueryBuilder) GroupBy(cols ...string) *QueryBuilder

func (*QueryBuilder) Having

func (qb *QueryBuilder) Having(condition string, args ...interface{}) *QueryBuilder

func (*QueryBuilder) Join

func (qb *QueryBuilder) Join(joinClause string) *QueryBuilder

func (*QueryBuilder) LeftJoin

func (qb *QueryBuilder) LeftJoin(joinClause string) *QueryBuilder

func (*QueryBuilder) Limit

func (qb *QueryBuilder) Limit(limit int) *QueryBuilder

func (*QueryBuilder) Offset

func (qb *QueryBuilder) Offset(offset int) *QueryBuilder

func (*QueryBuilder) OrWhere

func (qb *QueryBuilder) OrWhere(condition string, args ...interface{}) *QueryBuilder

func (*QueryBuilder) OrderBy

func (qb *QueryBuilder) OrderBy(clauses ...string) *QueryBuilder

func (*QueryBuilder) RightJoin

func (qb *QueryBuilder) RightJoin(joinClause string) *QueryBuilder

func (*QueryBuilder) Select

func (qb *QueryBuilder) Select(cols ...string) *QueryBuilder

func (*QueryBuilder) Where

func (qb *QueryBuilder) Where(condition string, args ...interface{}) *QueryBuilder

func (*QueryBuilder) WhereDateGte added in v0.1.5

func (qb *QueryBuilder) WhereDateGte(col string, val time.Time) *QueryBuilder

func (*QueryBuilder) WhereDateLte added in v0.1.5

func (qb *QueryBuilder) WhereDateLte(col string, val time.Time) *QueryBuilder

func (*QueryBuilder) WhereGte added in v0.1.5

func (qb *QueryBuilder) WhereGte(col string, val interface{}) *QueryBuilder

func (*QueryBuilder) WhereLike added in v0.1.5

func (qb *QueryBuilder) WhereLike(col string, val string) *QueryBuilder

func (*QueryBuilder) WhereLte added in v0.1.5

func (qb *QueryBuilder) WhereLte(col string, val interface{}) *QueryBuilder

type UpdateQueryBuilder added in v0.1.4

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

func (*UpdateQueryBuilder) Build added in v0.1.4

func (b *UpdateQueryBuilder) Build() (string, []interface{}, error)

func (*UpdateQueryBuilder) Columns added in v0.1.4

func (b *UpdateQueryBuilder) Columns(cols ...string) *UpdateQueryBuilder

Columns sets the columns for the UPDATE.

func (*UpdateQueryBuilder) Set added in v0.1.4

func (b *UpdateQueryBuilder) Set(col string, val interface{}) *UpdateQueryBuilder

Set adds a single column/value pair to the UPDATE.

func (*UpdateQueryBuilder) Table added in v0.1.4

func (b *UpdateQueryBuilder) Table(table string) *UpdateQueryBuilder

func (*UpdateQueryBuilder) Values added in v0.1.4

func (b *UpdateQueryBuilder) Values(vals ...interface{}) *UpdateQueryBuilder

Values sets the values for the UPDATE.

func (*UpdateQueryBuilder) Where added in v0.1.4

func (b *UpdateQueryBuilder) Where(condition string, args ...interface{}) *UpdateQueryBuilder

Where adds a WHERE condition.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL