goqu

package module

Go to main page

Versions in this module

v7

v7.4.0

Jul 24, 2019

Changes in this version

type Database

+ func (d *Database) WithTx(fn func(*TxDatabase) error) error

v7.3.1

Jul 12, 2019

Changes in this version

type Database

+ func (d *Database) BeginTx(ctx context.Context, opts *sql.TxOptions) (*TxDatabase, error)

type SQLDatabase

+ BeginTx func(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

+ type SQLTx interface

+ Commit func() error

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ PrepareContext func(ctx context.Context, query string) (*sql.Stmt, error)

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(ctx context.Context, query string, args ...interface{}) *sql.Row

+ Rollback func() error

type TxDatabase

+ func NewTx(dialect string, tx SQLTx) *TxDatabase

v7.3.0

Jul 12, 2019

Changes in this version

+ type SQLDatabase interface

+ Begin func() (*sql.Tx, error)

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ PrepareContext func(ctx context.Context, query string) (*sql.Stmt, error)

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(ctx context.Context, query string, args ...interface{}) *sql.Row

v7.2.0

Jul 12, 2019

Changes in this version

type Dataset

+ func (d *Dataset) OrderPrepend(order ...exp.OrderedExpression) *Dataset

type SQLDialectOptions

+ WrapCompoundsInParens bool

v7.1.0

Jul 11, 2019

v7.0.1

Jul 9, 2019

v7.0.0

Jul 9, 2019

Changes in this version

+ const CommonTableSQLFragment

+ const CompoundsSQLFragment

+ const DeleteBeginSQLFragment

+ const ForSQLFragment

+ const FromSQLFragment

+ const GroupBySQLFragment

+ const HavingSQLFragment

+ const InsertBeingSQLFragment

+ const InsertSQLFragment

+ const JoinSQLFragment

+ const LimitSQLFragment

+ const NoWait

+ const OffsetSQLFragment

+ const OrderSQLFragment

+ const ReturningSQLFragment

+ const SelectSQLFragment

+ const SkipLocked

+ const SourcesSQLFragment

+ const TruncateSQLFragment

+ const UpdateBeginSQLFragment

+ const UpdateSQLFragment

+ const Wait

+ const WhereSQLFragment

+ var FalseLiteral = exp.NewLiteralExpression("FALSE")

+ var TrueLiteral = exp.NewLiteralExpression("TRUE")

+ func AVG(col interface{}) exp.SQLFunctionExpression

+ func And(expressions ...exp.Expression) exp.ExpressionList

+ func C(col string) exp.IdentifierExpression

+ func COALESCE(vals ...interface{}) exp.SQLFunctionExpression

+ func COUNT(col interface{}) exp.SQLFunctionExpression

+ func Cast(e exp.Expression, t string) exp.CastExpression

+ func DISTINCT(col interface{}) exp.SQLFunctionExpression

+ func Default() exp.LiteralExpression

+ func DeregisterDialect(name string)

+ func DoNothing() exp.ConflictExpression

+ func DoUpdate(target string, update interface{}) exp.ConflictUpdateExpression

+ func FIRST(col interface{}) exp.SQLFunctionExpression

+ func Func(name string, args ...interface{}) exp.SQLFunctionExpression

+ func I(ident string) exp.IdentifierExpression

+ func L(sql string, args ...interface{}) exp.LiteralExpression

+ func LAST(col interface{}) exp.SQLFunctionExpression

+ func Literal(sql string, args ...interface{}) exp.LiteralExpression

+ func MAX(col interface{}) exp.SQLFunctionExpression

+ func MIN(col interface{}) exp.SQLFunctionExpression

+ func On(expressions ...exp.Expression) exp.JoinCondition

+ func Or(expressions ...exp.Expression) exp.ExpressionList

+ func Range(start, end interface{}) exp.RangeVal

+ func RegisterDialect(name string, do *SQLDialectOptions)

+ func S(schema string) exp.IdentifierExpression

+ func SUM(col interface{}) exp.SQLFunctionExpression

+ func SetColumnRenameFunction(renameFunc func(string) string)

+ func Star() exp.LiteralExpression

+ func T(table string) exp.IdentifierExpression

+ func Using(columns ...interface{}) exp.JoinCondition

+ type Database struct

+ Db *sql.DB

+ func New(dialect string, db *sql.DB) *Database

+ func (d *Database) Begin() (*TxDatabase, error)

+ func (d *Database) Dialect() string

+ func (d *Database) Exec(query string, args ...interface{}) (sql.Result, error)

+ func (d *Database) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (d *Database) From(from ...interface{}) *Dataset

+ func (d *Database) Logger(logger Logger)

+ func (d *Database) Prepare(query string) (*sql.Stmt, error)

+ func (d *Database) PrepareContext(ctx context.Context, query string) (*sql.Stmt, error)

+ func (d *Database) Query(query string, args ...interface{}) (*sql.Rows, error)

+ func (d *Database) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (d *Database) QueryRow(query string, args ...interface{}) *sql.Row

+ func (d *Database) QueryRowContext(ctx context.Context, query string, args ...interface{}) *sql.Row

+ func (d *Database) ScanStruct(i interface{}, query string, args ...interface{}) (bool, error)

+ func (d *Database) ScanStructContext(ctx context.Context, i interface{}, query string, args ...interface{}) (bool, error)

+ func (d *Database) ScanStructs(i interface{}, query string, args ...interface{}) error

+ func (d *Database) ScanStructsContext(ctx context.Context, i interface{}, query string, args ...interface{}) error

+ func (d *Database) ScanVal(i interface{}, query string, args ...interface{}) (bool, error)

+ func (d *Database) ScanValContext(ctx context.Context, i interface{}, query string, args ...interface{}) (bool, error)

+ func (d *Database) ScanVals(i interface{}, query string, args ...interface{}) error

+ func (d *Database) ScanValsContext(ctx context.Context, i interface{}, query string, args ...interface{}) error

+ func (d *Database) Trace(op, sqlString string, args ...interface{})

+ type Dataset struct

+ func From(table ...interface{}) *Dataset

+ func (d *Dataset) AppendSQL(b sb.SQLBuilder)

+ func (d *Dataset) As(alias string) *Dataset

+ func (d *Dataset) ClearLimit() *Dataset

+ func (d *Dataset) ClearOffset() *Dataset

+ func (d *Dataset) ClearOrder() *Dataset

+ func (d *Dataset) ClearSelect() *Dataset

+ func (d *Dataset) ClearWhere() *Dataset

+ func (d *Dataset) Clone() exp.Expression

+ func (d *Dataset) CompoundFromSelf() *Dataset

+ func (d *Dataset) Count() (int64, error)

+ func (d *Dataset) CountContext(ctx context.Context) (int64, error)

+ func (d *Dataset) CrossJoin(table exp.Expression) *Dataset

+ func (d *Dataset) Delete() exec.QueryExecutor

+ func (d *Dataset) Dialect() SQLDialect

+ func (d *Dataset) Expression() exp.Expression

+ func (d *Dataset) ForKeyShare(waitOption exp.WaitOption) *Dataset

+ func (d *Dataset) ForNoKeyUpdate(waitOption exp.WaitOption) *Dataset

+ func (d *Dataset) ForShare(waitOption exp.WaitOption) *Dataset

+ func (d *Dataset) ForUpdate(waitOption exp.WaitOption) *Dataset

+ func (d *Dataset) From(from ...interface{}) *Dataset

+ func (d *Dataset) FromSelf() *Dataset

+ func (d *Dataset) FullJoin(table exp.Expression, condition exp.JoinCondition) *Dataset

+ func (d *Dataset) FullOuterJoin(table exp.Expression, condition exp.JoinCondition) *Dataset

+ func (d *Dataset) GetClauses() exp.Clauses

+ func (d *Dataset) GroupBy(groupBy ...interface{}) *Dataset

+ func (d *Dataset) Having(expressions ...exp.Expression) *Dataset

+ func (d *Dataset) InnerJoin(table exp.Expression, condition exp.JoinCondition) *Dataset

+ func (d *Dataset) Insert(i ...interface{}) exec.QueryExecutor

+ func (d *Dataset) InsertConflict(c exp.ConflictExpression, i ...interface{}) exec.QueryExecutor

+ func (d *Dataset) InsertIgnore(i ...interface{}) exec.QueryExecutor

+ func (d *Dataset) Intersect(other *Dataset) *Dataset

+ func (d *Dataset) IntersectAll(other *Dataset) *Dataset

+ func (d *Dataset) IsPrepared() bool

+ func (d *Dataset) Join(table exp.Expression, condition exp.JoinCondition) *Dataset

+ func (d *Dataset) LeftJoin(table exp.Expression, condition exp.JoinCondition) *Dataset

+ func (d *Dataset) LeftOuterJoin(table exp.Expression, condition exp.JoinCondition) *Dataset

+ func (d *Dataset) Limit(limit uint) *Dataset

+ func (d *Dataset) LimitAll() *Dataset

+ func (d *Dataset) NaturalFullJoin(table exp.Expression) *Dataset

+ func (d *Dataset) NaturalJoin(table exp.Expression) *Dataset

+ func (d *Dataset) NaturalLeftJoin(table exp.Expression) *Dataset

+ func (d *Dataset) NaturalRightJoin(table exp.Expression) *Dataset

+ func (d *Dataset) Offset(offset uint) *Dataset

+ func (d *Dataset) Order(order ...exp.OrderedExpression) *Dataset

+ func (d *Dataset) OrderAppend(order ...exp.OrderedExpression) *Dataset

+ func (d *Dataset) Pluck(i interface{}, col string) error

+ func (d *Dataset) PluckContext(ctx context.Context, i interface{}, col string) error

+ func (d *Dataset) Prepared(prepared bool) *Dataset

+ func (d *Dataset) Returning(returning ...interface{}) *Dataset

+ func (d *Dataset) RightJoin(table exp.Expression, condition exp.JoinCondition) *Dataset

+ func (d *Dataset) RightOuterJoin(table exp.Expression, condition exp.JoinCondition) *Dataset

+ func (d *Dataset) ScanStruct(i interface{}) (bool, error)

+ func (d *Dataset) ScanStructContext(ctx context.Context, i interface{}) (bool, error)

+ func (d *Dataset) ScanStructs(i interface{}) error

+ func (d *Dataset) ScanStructsContext(ctx context.Context, i interface{}) error

+ func (d *Dataset) ScanVal(i interface{}) (bool, error)

+ func (d *Dataset) ScanValContext(ctx context.Context, i interface{}) (bool, error)

+ func (d *Dataset) ScanVals(i interface{}) error

+ func (d *Dataset) ScanValsContext(ctx context.Context, i interface{}) error

+ func (d *Dataset) Select(selects ...interface{}) *Dataset

+ func (d *Dataset) SelectAppend(selects ...interface{}) *Dataset

+ func (d *Dataset) SelectDistinct(selects ...interface{}) *Dataset

+ func (d *Dataset) SetDialect(dialect SQLDialect) *Dataset

+ func (d *Dataset) ToDeleteSQL() (sql string, params []interface{}, err error)

+ func (d *Dataset) ToInsertConflictSQL(o exp.ConflictExpression, rows ...interface{}) (sql string, params []interface{}, err error)

+ func (d *Dataset) ToInsertIgnoreSQL(rows ...interface{}) (sql string, params []interface{}, err error)

+ func (d *Dataset) ToInsertSQL(rows ...interface{}) (sql string, params []interface{}, err error)

+ func (d *Dataset) ToSQL() (sql string, params []interface{}, err error)

+ func (d *Dataset) ToTruncateSQL() (sql string, params []interface{}, err error)

+ func (d *Dataset) ToTruncateWithOptsSQL(opts exp.TruncateOptions) (sql string, params []interface{}, err error)

+ func (d *Dataset) ToUpdateSQL(update interface{}) (sql string, params []interface{}, err error)

+ func (d *Dataset) Union(other *Dataset) *Dataset

+ func (d *Dataset) UnionAll(other *Dataset) *Dataset

+ func (d *Dataset) Update(i interface{}) exec.QueryExecutor

+ func (d *Dataset) Where(expressions ...exp.Expression) *Dataset

+ func (d *Dataset) With(name string, subquery exp.Expression) *Dataset

+ func (d *Dataset) WithDialect(dl string) *Dataset

+ func (d *Dataset) WithRecursive(name string, subquery exp.Expression) *Dataset

+ type DialectWrapper struct

+ func Dialect(dialect string) DialectWrapper

+ func (dw DialectWrapper) DB(db *sql.DB) *Database

+ func (dw DialectWrapper) From(table ...interface{}) *Dataset

+ type Ex = exp.Ex

+ type ExOr = exp.ExOr

+ type Expression = exp.Expression

+ type Logger interface

+ Printf func(format string, v ...interface{})

+ type Op = exp.Op

+ type Record = exp.Record

+ type SQLDialect interface

+ ToDeleteSQL func(b sb.SQLBuilder, clauses exp.Clauses)

+ ToInsertSQL func(b sb.SQLBuilder, clauses exp.Clauses, ie exp.InsertExpression)

+ ToSelectSQL func(b sb.SQLBuilder, clauses exp.Clauses)

+ ToTruncateSQL func(b sb.SQLBuilder, clauses exp.Clauses, options exp.TruncateOptions)

+ ToUpdateSQL func(b sb.SQLBuilder, clauses exp.Clauses, update interface{})

+ func GetDialect(name string) SQLDialect

+ type SQLDialectOptions struct

+ AndFragment []byte

+ AsFragment []byte

+ AscFragment []byte

+ BooleanOperatorLookup map[exp.BooleanOperation][]byte

+ CascadeFragment []byte

+ CastFragment []byte

+ CommaRune rune

+ ConflictDoNothingFragment []byte

+ ConflictDoUpdateFragment []byte

+ ConflictFragment []byte

+ DefaultValuesFragment []byte

+ DeleteClause []byte

+ DeleteSQLOrder []SQLFragmentType

+ DescFragment []byte

+ DistinctFragment []byte

+ EmptyString string

+ EscapedRunes map[rune][]byte

+ False []byte

+ ForKeyShareFragment []byte

+ ForNoKeyUpdateFragment []byte

+ ForShareFragment []byte

+ ForUpdateFragment []byte

+ FromFragment []byte

+ GroupByFragment []byte

+ HavingFragment []byte

+ IdentityFragment []byte

+ IncludePlaceholderNum bool

+ InsertClause []byte

+ InsertIgnoreClause []byte

+ InsertSQLOrder []SQLFragmentType

+ IntersectAllFragment []byte

+ IntersectFragment []byte

+ JoinTypeLookup map[exp.JoinType][]byte

+ LeftParenRune rune

+ LimitFragment []byte

+ NowaitFragment []byte

+ Null []byte

+ NullsFirstFragment []byte

+ NullsLastFragment []byte

+ OffsetFragment []byte

+ OnFragment []byte

+ OrFragment []byte

+ OrderByFragment []byte

+ PeriodRune rune

+ PlaceHolderRune rune

+ QuoteRune rune

+ RangeOperatorLookup map[exp.RangeOperation][]byte

+ RecursiveFragment []byte

+ RestrictFragment []byte

+ ReturningFragment []byte

+ RightParenRune rune

+ SelectClause []byte

+ SelectSQLOrder []SQLFragmentType

+ SetFragment []byte

+ SetOperatorRune rune

+ SkipLockedFragment []byte

+ SpaceRune rune

+ StarRune rune

+ StringQuote rune

+ SupportsConflictTarget bool

+ SupportsConflictUpdateWhere bool

+ SupportsInsertIgnoreSyntax bool

+ SupportsLimitOnDelete bool

+ SupportsLimitOnUpdate bool

+ SupportsOrderByOnDelete bool

+ SupportsOrderByOnUpdate bool

+ SupportsReturn bool

+ SupportsWithCTE bool

+ SupportsWithCTERecursive bool

+ TimeFormat string

+ True []byte

+ TruncateClause []byte

+ TruncateSQLOrder []SQLFragmentType

+ UnionAllFragment []byte

+ UnionFragment []byte

+ UpdateClause []byte

+ UpdateSQLOrder []SQLFragmentType

+ UseLiteralIsBools bool

+ UsingFragment []byte

+ ValuesFragment []byte

+ WhereFragment []byte

+ WithFragment []byte

+ func DefaultDialectOptions() *SQLDialectOptions

+ type SQLFragmentType int

+ func (sf SQLFragmentType) String() string

+ type TruncateOptions = exp.TruncateOptions

+ type TxDatabase struct

+ Tx *sql.Tx

+ func (td *TxDatabase) Commit() error

+ func (td *TxDatabase) Dialect() string

+ func (td *TxDatabase) Exec(query string, args ...interface{}) (sql.Result, error)

+ func (td *TxDatabase) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (td *TxDatabase) From(cols ...interface{}) *Dataset

+ func (td *TxDatabase) Logger(logger Logger)

+ func (td *TxDatabase) Prepare(query string) (*sql.Stmt, error)

+ func (td *TxDatabase) PrepareContext(ctx context.Context, query string) (*sql.Stmt, error)

+ func (td *TxDatabase) Query(query string, args ...interface{}) (*sql.Rows, error)

+ func (td *TxDatabase) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (td *TxDatabase) QueryRow(query string, args ...interface{}) *sql.Row

+ func (td *TxDatabase) QueryRowContext(ctx context.Context, query string, args ...interface{}) *sql.Row

+ func (td *TxDatabase) Rollback() error

+ func (td *TxDatabase) ScanStruct(i interface{}, query string, args ...interface{}) (bool, error)

+ func (td *TxDatabase) ScanStructContext(ctx context.Context, i interface{}, query string, args ...interface{}) (bool, error)

+ func (td *TxDatabase) ScanStructs(i interface{}, query string, args ...interface{}) error

+ func (td *TxDatabase) ScanStructsContext(ctx context.Context, i interface{}, query string, args ...interface{}) error

+ func (td *TxDatabase) ScanVal(i interface{}, query string, args ...interface{}) (bool, error)

+ func (td *TxDatabase) ScanValContext(ctx context.Context, i interface{}, query string, args ...interface{}) (bool, error)

+ func (td *TxDatabase) ScanVals(i interface{}, query string, args ...interface{}) error

+ func (td *TxDatabase) ScanValsContext(ctx context.Context, i interface{}, query string, args ...interface{}) error

+ func (td *TxDatabase) Trace(op, sqlString string, args ...interface{})

+ func (td *TxDatabase) Wrap(fn func() error) error

Other modules containing this package

github.com/doug-martin/goqu

github.com/doug-martin/goqu/v6

github.com/doug-martin/goqu/v8

github.com/doug-martin/goqu/v9

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