Versions in this module Expand all Collapse all v1 v1.1.0 Jun 21, 2015 Changes in this version + var ErrArgumentMismatch = errors.New("mismatch between ? (placeholders) and arguments") + var ErrInvalidSliceLength = errors.New("length of slice is 0. length must be >= 1") + var ErrInvalidSliceValue = errors.New("trying to interpolate invalid slice value into query") + var ErrInvalidValue = errors.New("trying to interpolate invalid value into query") + var ErrNotFound = errors.New("not found") + var ErrNotUTF8 = errors.New("invalid UTF-8") + var NameMapping = camelCaseToSnakeCase + var Now = nowSentinel + var Quoter = MysqlQuoter + func Expr(sql string, values ...interface{}) *expr + func Interpolate(sql string, vals []interface{}) (string, error) + type Connection struct + Db *sql.DB + func NewConnection(db *sql.DB, log EventReceiver) *Connection + func (cxn *Connection) NewSession(log EventReceiver) *Session + type DeleteBuilder struct + From string + LimitCount uint64 + LimitValid bool + OffsetCount uint64 + OffsetValid bool + OrderBys []string + WhereFragments []*whereFragment + func (b *DeleteBuilder) Exec() (sql.Result, error) + func (b *DeleteBuilder) Limit(limit uint64) *DeleteBuilder + func (b *DeleteBuilder) Offset(offset uint64) *DeleteBuilder + func (b *DeleteBuilder) OrderBy(ord string) *DeleteBuilder + func (b *DeleteBuilder) OrderDir(ord string, isAsc bool) *DeleteBuilder + func (b *DeleteBuilder) ToSql() (string, []interface{}) + func (b *DeleteBuilder) Where(whereSqlOrMap interface{}, args ...interface{}) *DeleteBuilder + type Eq map[string]interface + type EventReceiver interface + Event func(eventName string) + EventErr func(eventName string, err error) error + EventErrKv func(eventName string, err error, kvs map[string]string) error + EventKv func(eventName string, kvs map[string]string) + Timing func(eventName string, nanoseconds int64) + TimingKv func(eventName string, nanoseconds int64, kvs map[string]string) + type InsertBuilder struct + Cols []string + Into string + Recs []interface{} + Vals [][]interface{} + func (b *InsertBuilder) Columns(columns ...string) *InsertBuilder + func (b *InsertBuilder) Exec() (sql.Result, error) + func (b *InsertBuilder) Pair(column string, value interface{}) *InsertBuilder + func (b *InsertBuilder) Record(record interface{}) *InsertBuilder + func (b *InsertBuilder) ToSql() (string, []interface{}) + func (b *InsertBuilder) Values(vals ...interface{}) *InsertBuilder + type MysqlQuoter struct + type NullBool struct + func (n *NullBool) MarshalJSON() ([]byte, error) + func (n *NullBool) UnmarshalJSON(b []byte) error + type NullEventReceiver struct + func (n *NullEventReceiver) Event(eventName string) + func (n *NullEventReceiver) EventErr(eventName string, err error) error + func (n *NullEventReceiver) EventErrKv(eventName string, err error, kvs map[string]string) error + func (n *NullEventReceiver) EventKv(eventName string, kvs map[string]string) + func (n *NullEventReceiver) Timing(eventName string, nanoseconds int64) + func (n *NullEventReceiver) TimingKv(eventName string, nanoseconds int64, kvs map[string]string) + type NullFloat64 struct + func (n *NullFloat64) MarshalJSON() ([]byte, error) + func (n *NullFloat64) UnmarshalJSON(b []byte) error + type NullInt64 struct + func (n *NullInt64) MarshalJSON() ([]byte, error) + func (n *NullInt64) UnmarshalJSON(b []byte) error + type NullString struct + func (n *NullString) MarshalJSON() ([]byte, error) + func (n *NullString) UnmarshalJSON(b []byte) error + type NullTime struct + func (n *NullTime) MarshalJSON() ([]byte, error) + func (n *NullTime) UnmarshalJSON(b []byte) error + type SelectBuilder struct + Columns []string + FromTable string + GroupBys []string + HavingFragments []*whereFragment + IsDistinct bool + LimitCount uint64 + LimitValid bool + OffsetCount uint64 + OffsetValid bool + OrderBys []string + RawArguments []interface{} + RawFullSql string + WhereFragments []*whereFragment + func (b *SelectBuilder) Distinct() *SelectBuilder + func (b *SelectBuilder) From(from string) *SelectBuilder + func (b *SelectBuilder) GroupBy(group string) *SelectBuilder + func (b *SelectBuilder) Having(whereSqlOrMap interface{}, args ...interface{}) *SelectBuilder + func (b *SelectBuilder) Limit(limit uint64) *SelectBuilder + func (b *SelectBuilder) LoadStruct(dest interface{}) error + func (b *SelectBuilder) LoadStructs(dest interface{}) (int, error) + func (b *SelectBuilder) LoadValue(dest interface{}) error + func (b *SelectBuilder) LoadValues(dest interface{}) (int, error) + func (b *SelectBuilder) Offset(offset uint64) *SelectBuilder + func (b *SelectBuilder) OrderBy(ord string) *SelectBuilder + func (b *SelectBuilder) OrderDir(ord string, isAsc bool) *SelectBuilder + func (b *SelectBuilder) Paginate(page, perPage uint64) *SelectBuilder + func (b *SelectBuilder) ReturnInt64() (int64, error) + func (b *SelectBuilder) ReturnInt64s() ([]int64, error) + func (b *SelectBuilder) ReturnString() (string, error) + func (b *SelectBuilder) ReturnStrings() ([]string, error) + func (b *SelectBuilder) ReturnUint64() (uint64, error) + func (b *SelectBuilder) ReturnUint64s() ([]uint64, error) + func (b *SelectBuilder) ToSql() (string, []interface{}) + func (b *SelectBuilder) Where(whereSqlOrMap interface{}, args ...interface{}) *SelectBuilder + type Session struct + func (sess *Session) Begin() (*Tx, error) + func (sess *Session) DeleteFrom(from string) *DeleteBuilder + func (sess *Session) InsertInto(into string) *InsertBuilder + func (sess *Session) Select(cols ...string) *SelectBuilder + func (sess *Session) SelectBySql(sql string, args ...interface{}) *SelectBuilder + func (sess *Session) Update(table string) *UpdateBuilder + func (sess *Session) UpdateBySql(sql string, args ...interface{}) *UpdateBuilder + type SessionRunner interface + DeleteFrom func(from string) *DeleteBuilder + InsertInto func(into string) *InsertBuilder + Select func(cols ...string) *SelectBuilder + SelectBySql func(sql string, args ...interface{}) *SelectBuilder + Update func(table string) *UpdateBuilder + UpdateBySql func(sql string, args ...interface{}) *UpdateBuilder + type Tx struct + func (tx *Tx) Commit() error + func (tx *Tx) DeleteFrom(from string) *DeleteBuilder + func (tx *Tx) InsertInto(into string) *InsertBuilder + func (tx *Tx) Rollback() error + func (tx *Tx) RollbackUnlessCommitted() + func (tx *Tx) Select(cols ...string) *SelectBuilder + func (tx *Tx) SelectBySql(sql string, args ...interface{}) *SelectBuilder + func (tx *Tx) Update(table string) *UpdateBuilder + func (tx *Tx) UpdateBySql(sql string, args ...interface{}) *UpdateBuilder + type UpdateBuilder struct + LimitCount uint64 + LimitValid bool + OffsetCount uint64 + OffsetValid bool + OrderBys []string + RawArguments []interface{} + RawFullSql string + SetClauses []*setClause + Table string + WhereFragments []*whereFragment + func (b *UpdateBuilder) Exec() (sql.Result, error) + func (b *UpdateBuilder) Limit(limit uint64) *UpdateBuilder + func (b *UpdateBuilder) Offset(offset uint64) *UpdateBuilder + func (b *UpdateBuilder) OrderBy(ord string) *UpdateBuilder + func (b *UpdateBuilder) OrderDir(ord string, isAsc bool) *UpdateBuilder + func (b *UpdateBuilder) Set(column string, value interface{}) *UpdateBuilder + func (b *UpdateBuilder) SetMap(clauses map[string]interface{}) *UpdateBuilder + func (b *UpdateBuilder) ToSql() (string, []interface{}) + func (b *UpdateBuilder) Where(whereSqlOrMap interface{}, args ...interface{}) *UpdateBuilder Incompatible versions in this module v3.0.0+incompatible Apr 5, 2018 v2.1.0+incompatible Aug 2, 2016 v2.0.0+incompatible Sep 19, 2015 Other modules containing this package github.com/brunotm/dbr/v2