sqlutil

package

Go to main page

Versions in this module

v1

v1.2.7

Dec 15, 2019

Changes in this version

+ const INSERT_OR_UPDATE_CONFLICT

+ const INSERT_OR_UPDATE_DUPLICATE

type QueryBuilder

+ func (q *QueryBuilder) OnConflictDoUpdate(key string) *QueryBuilder

v1.2.6

Nov 24, 2019

v1.2.5

Nov 24, 2019

Changes in this version

+ func ExecInsert(tx AbstractDBBase, query string, args ...interface{}) (lastInsertId int64, success bool)

+ func QueryCount(tx AbstractDBBase, query string, args ...interface{}) (count int64, success bool)

+ func QueryMany(tx AbstractDBBase, dest interface{}, query string, args ...interface{}) (success bool)

+ func QueryOne(tx AbstractDBBase, dest interface{}, query string, args ...interface{}) (success bool)

v1.2.4

Nov 24, 2019

v1.2.3

Nov 24, 2019

Changes in this version

+ func Exec(tx AbstractDBBase, query string, args ...interface{}) (success bool)

+ func Query(tx AbstractDBBase, dest interface{}, query string, args ...interface{}) (success bool)

type QueryBuilder

+ func (q *QueryBuilder) Returning(fields ...string) *QueryBuilder

+ func (q *QueryBuilder) ReturningAll() *QueryBuilder

v1.2.2

Nov 24, 2019

Changes in this version

+ func InsertMany2(tx AbstractDBBase, query string, args ...interface{}) (success bool)

+ func InsertOne2(tx AbstractDBBase, query string, args ...interface{}) (success bool)

v1.2.1

Nov 24, 2019

v1.2.0

Nov 23, 2019

Changes in this version

+ const DELETE

+ const INNER_JOIN

+ const INSERT

+ const INSERT_OR_UPDATE

+ const JOIN

+ const LEFT_JOIN

+ const RIGHT_JOIN

+ const SELECT

+ const SELECT_DISTINCT

+ const UPDATE

+ func GetDefaultLocation() *time.Location

+ func InterpolateParams(query string, args []driver.Value, loc *time.Location, ...) (string, error)

+ func SetDefaultLocation(loc *time.Location)

+ type ConnectionOptions interface

+ BuildDataSourceString func() string

+ type QueryBuilder struct

+ func NewEmptyQuery() *QueryBuilder

+ func Table(tableName string) *QueryBuilder

+ func (q *QueryBuilder) And(query string, args ...driver.Value) *QueryBuilder

+ func (q *QueryBuilder) AndRow(row Row) *QueryBuilder

+ func (q *QueryBuilder) As(name string) *QueryBuilder

+ func (q *QueryBuilder) Build() string

+ func (q *QueryBuilder) Clone() *QueryBuilder

+ func (q *QueryBuilder) Count(field string) *QueryBuilder

+ func (q *QueryBuilder) Delete() *QueryBuilder

+ func (q *QueryBuilder) Fields(fields ...string) *QueryBuilder

+ func (q *QueryBuilder) Format(query string, args ...driver.Value) string

+ func (q *QueryBuilder) GroupBy(tpl string, args ...driver.Value) *QueryBuilder

+ func (q *QueryBuilder) Having(tpl string, args ...driver.Value) *QueryBuilder

+ func (q *QueryBuilder) Init(quoteIdentifier func(id string) string, ...) *QueryBuilder

+ func (q *QueryBuilder) InnerJoin(tableName string, fields ...string) *QueryBuilder

+ func (q *QueryBuilder) Insert(row Row) *QueryBuilder

+ func (q *QueryBuilder) InsertMany(rows []Row) *QueryBuilder

+ func (q *QueryBuilder) Join(tableName string, fields ...string) *QueryBuilder

+ func (q *QueryBuilder) LeftJoin(tableName string, fields ...string) *QueryBuilder

+ func (q *QueryBuilder) Limit(n int) *QueryBuilder

+ func (q *QueryBuilder) Location(loc *time.Location) *QueryBuilder

+ func (q *QueryBuilder) On(condition string, args ...driver.Value) *QueryBuilder

+ func (q *QueryBuilder) OnDuplicateKeyUpdate() *QueryBuilder

+ func (q *QueryBuilder) OrderBy(tpl string, args ...driver.Value) *QueryBuilder

+ func (q *QueryBuilder) QuoteIdentifier(id string) string

+ func (q *QueryBuilder) RightJoin(tableName string, fields ...string) *QueryBuilder

+ func (q *QueryBuilder) Select(fields ...string) *QueryBuilder

+ func (q *QueryBuilder) SelectDistinct(fields ...string) *QueryBuilder

+ func (q *QueryBuilder) Set(update string, args ...driver.Value) *QueryBuilder

+ func (q *QueryBuilder) SetRow(row Row) *QueryBuilder

+ func (q *QueryBuilder) Skip(n int) *QueryBuilder

+ func (q *QueryBuilder) Table(tableName string) *QueryBuilder

+ func (q *QueryBuilder) Update() *QueryBuilder

+ func (q *QueryBuilder) Where(query string, args ...driver.Value) *QueryBuilder

+ func (q *QueryBuilder) WhereRow(row Row) *QueryBuilder

v1.1.3

Nov 21, 2019

v1.1.2

Nov 1, 2019

v1.1.1

Oct 28, 2019

v1.1.0

Oct 23, 2019

Changes in this version

+ func BuildDataSourceString(opts Options) string

+ func DeleteMany(tx AbstractDBBase, query string, args ...interface{}) (rowsAffected int64, success bool)

+ func DeleteOne(tx AbstractDBBase, query string, args ...interface{}) (rowsAffected int64, success bool)

+ func DisableDebug()

+ func EnableDebug()

+ func FindCount(tx AbstractDBBase, query string, args ...interface{}) (count int64, success bool)

+ func FindMany(tx AbstractDBBase, dest interface{}, query string, args ...interface{}) (success bool)

+ func FindOne(tx AbstractDBBase, dest interface{}, query string, args ...interface{}) (success bool)

+ func InsertMany(tx AbstractDBBase, query string, args ...interface{}) (lastInsertId int64, success bool)

+ func InsertOne(tx AbstractDBBase, query string, args ...interface{}) (insertId int64, success bool)

+ func MustOpen(driverName string, dataSourceName string) *sqlx.DB

+ func MustOpenWithOptions(driverName string, opts Options) *sqlx.DB

+ func Open(driverName string, dataSourceName string) (*sqlx.DB, error)

+ func OpenWithOptions(driverName string, opts Options) (*sqlx.DB, error)

+ func UpdateMany(tx AbstractDBBase, query string, args ...interface{}) (rowsAffected int64, success bool)

+ func UpdateOne(tx AbstractDBBase, query string, args ...interface{}) (rowsAffected int64, success bool)

+ type AbstractDB interface

+ MustBegin func() AbstractTx

+ type AbstractDBBase interface

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

+ Get func(dest interface{}, query string, args ...interface{}) error

+ Select func(dest interface{}, query string, args ...interface{}) error

+ type AbstractTx interface

+ Commit func() error

+ Rollback func() error

+ type DB = sqlx.DB

+ type Options struct

+ AutoCommit bool

+ Charset string

+ Database string

+ Host string

+ Params map[string]string

+ ParseTime bool

+ Password string

+ Port int

+ Timezone string

+ User string

+ type QueryCountRow struct

+ Count int64

+ type Row = map[string]interface

+ type Tx = sqlx.Tx

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