mysql

Oct 10, 2021

Changes in this version

type QueryBuilder

+ func (query *QueryBuilder) IsZero(v reflect.Value) bool

Jan 26, 2021

Changes in this version

type NullDateTime

+ func (nt *NullDateTime) Scan(value interface{}) error

Jan 25, 2021

Changes in this version

+ type NullBool struct

+ func NewBool(b bool) NullBool

+ func NewNullBool() NullBool

+ func (n NullBool) Convert() string

+ func (n NullBool) IsEmpty() bool

+ func (n NullBool) IsValid() bool

+ func (nb *NullBool) UnmarshalJSON(b []byte) error

+ func (nb NullBool) MarshalJSON() ([]byte, error)

+ func (ns NullBool) Result() interface{}

+ type NullDate struct

+ func NewDate(s string) NullDate

+ func NewNullDate() NullDate

+ func (ns *NullDate) UnmarshalJSON(b []byte) error

+ func (ns NullDate) IsEmpty() bool

+ func (ns NullDate) IsValid() bool

+ func (ns NullDate) MarshalJSON() ([]byte, error)

+ func (ns NullDate) Result() interface{}

+ func (nt *NullDate) Scan(value interface{}) error

+ type NullDateTime struct

+ func NewDateTime(t time.Time) NullDateTime

+ func NewNullDateTime() NullDateTime

+ func (n NullDateTime) Convert() string

+ func (n NullDateTime) IsEmpty() bool

+ func (n NullDateTime) IsValid() bool

+ func (ns NullDateTime) Result() interface{}

+ func (nt *NullDateTime) UnmarshalJSON(b []byte) error

+ func (nt NullDateTime) MarshalJSON() ([]byte, error)

+ type NullFloat64 struct

+ func NewFloat64(f float64) NullFloat64

+ func NewNullFloat64() NullFloat64

+ func (n NullFloat64) Convert() string

+ func (n NullFloat64) IsEmpty() bool

+ func (n NullFloat64) IsValid() bool

+ func (nf *NullFloat64) UnmarshalJSON(b []byte) error

+ func (nf NullFloat64) MarshalJSON() ([]byte, error)

+ func (ns NullFloat64) Result() interface{}

+ type NullInt32 struct

+ func NewInt32(i int32) NullInt32

+ func NewNullInt32() NullInt32

+ func (n NullInt32) Convert() string

+ func (n NullInt32) IsEmpty() bool

+ func (n NullInt32) IsValid() bool

+ func (ni *NullInt32) UnmarshalJSON(b []byte) error

+ func (ni NullInt32) MarshalJSON() ([]byte, error)

+ func (ns NullInt32) Result() interface{}

+ type NullInt64 struct

+ func NewInt64(i int64) NullInt64

+ func NewNullInt64() NullInt64

+ func (n NullInt64) Convert() string

+ func (n NullInt64) IsEmpty() bool

+ func (n NullInt64) IsValid() bool

+ func (ni *NullInt64) UnmarshalJSON(b []byte) error

+ func (ni NullInt64) MarshalJSON() ([]byte, error)

+ func (ns NullInt64) Result() interface{}

+ type NullString struct

+ func NewNullString() NullString

+ func NewString(s string) NullString

+ func (n NullString) Convert() string

+ func (ns *NullString) UnmarshalJSON(b []byte) error

+ func (ns NullString) IsEmpty() bool

+ func (ns NullString) IsValid() bool

+ func (ns NullString) MarshalJSON() ([]byte, error)

+ func (ns NullString) Result() interface{}

+ type Nullable interface

+ IsEmpty func() bool

+ IsValid func() bool

Dec 11, 2020

Changes in this version

type QueryTx

+ Tx *sql.Tx

Sep 10, 2020

Changes in this version

type Proxy

+ func NewProxy() *Proxy

Sep 9, 2020

Changes in this version

type Config

+ ConnMaxIdleTime time.Duration

+ ConnMaxLifetime time.Duration

Sep 3, 2020

Changes in this version

+ const AND

+ const ASC

+ const BETWEEN

+ const DESC

+ const EQUAL

+ const IN

+ const INNERJOIN

+ const ISNOTNULL

+ const ISNULL

+ const JOIN

+ const LEFTJOIN

+ const LIKE

+ const NOTBETWEEN

+ const NOTEQUAL

+ const NOTIN

+ const OR

+ const RIGHTJOIN

+ const UNION

+ const UNIONALL

+ func SetTrace(t bool)

+ type Config struct

+ Charset string

+ Database string

+ Host string

+ MaxIdleConns int

+ MaxLifetime time.Duration

+ MaxOpenConns int

+ Password string

+ Port string

+ Username string

+ func (config *Config) URI() string

+ type Connection interface

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

+ GetLastSql func() Sql

+ LastSql func(query string, args ...interface{})

+ NewQuery func(ctx context.Context) *QueryBuilder

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

+ type DbError struct

+ func NewDBError(msg string, sql Sql) DbError

+ func (e DbError) Error() string

+ type Epr struct

+ func NewEpr(value string) Epr

+ func (e Epr) ToString() string

+ type Grammar struct

+ func (g Grammar) Delete() string

+ func (g Grammar) Insert() string

+ func (g Grammar) InsertUpdate() string

+ func (g Grammar) Replace() string

+ func (g Grammar) Select() string

+ func (g Grammar) ToSql() string

+ func (g Grammar) Update() string

+ type Proxy struct

+ func (proxy *Proxy) Read() *QueryDb

+ func (proxy *Proxy) SetRead(query *QueryDb)

+ func (proxy *Proxy) SetWrite(query *QueryDb)

+ func (proxy *Proxy) Write() *QueryDb

+ type ProxyPool struct

+ func NewProxyPool() *ProxyPool

+ func (proxypool *ProxyPool) NameSpace(group string) *Proxy

+ func (proxypool *ProxyPool) SetNameSpace(group string, proxy *Proxy)

+ type QueryBuilder struct

+ func (query *QueryBuilder) Between(column string, value1 interface{}, value2 interface{}) *QueryBuilder

+ func (query *QueryBuilder) Count() (int64, error)

+ func (query *QueryBuilder) Delete() (int64, error)

+ func (query *QueryBuilder) DeleteSQL() string

+ func (query *QueryBuilder) Distinct() *QueryBuilder

+ func (query *QueryBuilder) Equal(column string, value interface{}) *QueryBuilder

+ func (query *QueryBuilder) Exec(sql string, args ...interface{}) (int64, error)

+ func (query *QueryBuilder) ExecSQL(sql string, args ...interface{}) string

+ func (query *QueryBuilder) GroupBy(groups ...string) *QueryBuilder

+ func (query *QueryBuilder) In(column string, value ...interface{}) *QueryBuilder

+ func (query *QueryBuilder) InnerJoin(tablename string, on string) *QueryBuilder

+ func (query *QueryBuilder) Insert(data interface{}) (int64, error)

+ func (query *QueryBuilder) InsertSQL(data interface{}) string

+ func (query *QueryBuilder) InsertUpdate(insert interface{}, update interface{}) (int64, error)

+ func (query *QueryBuilder) InsertUpdateSQL(insert interface{}, update interface{}) string

+ func (query *QueryBuilder) IsNULL(column string) *QueryBuilder

+ func (query *QueryBuilder) IsNotNULL(column string) *QueryBuilder

+ func (query *QueryBuilder) Join(tablename string, on string) *QueryBuilder

+ func (query *QueryBuilder) LeftJoin(tablename string, on string) *QueryBuilder

+ func (query *QueryBuilder) Like(column string, value interface{}) *QueryBuilder

+ func (query *QueryBuilder) Limit(limit int64) *QueryBuilder

+ func (query *QueryBuilder) MultiInsert(datas ...interface{}) (int64, error)

+ func (query *QueryBuilder) MultiInsertSQL(datas ...interface{}) string

+ func (query *QueryBuilder) NotBetween(column string, value1 interface{}, value2 interface{}) *QueryBuilder

+ func (query *QueryBuilder) NotEqual(column string, value interface{}) *QueryBuilder

+ func (query *QueryBuilder) NotIn(column string, value ...interface{}) *QueryBuilder

+ func (query *QueryBuilder) NotOrBetween(column string, value1 interface{}, value2 interface{}) *QueryBuilder

+ func (query *QueryBuilder) Offset(offset int64) *QueryBuilder

+ func (query *QueryBuilder) OrBetween(column string, value1 interface{}, value2 interface{}) *QueryBuilder

+ func (query *QueryBuilder) OrEqual(column string, value interface{}) *QueryBuilder

+ func (query *QueryBuilder) OrIn(column string, value ...interface{}) *QueryBuilder

+ func (query *QueryBuilder) OrIsNULL(column string) *QueryBuilder

+ func (query *QueryBuilder) OrIsNotNULL(column string) *QueryBuilder

+ func (query *QueryBuilder) OrLike(column string, value interface{}) *QueryBuilder

+ func (query *QueryBuilder) OrNotEqual(column string, value interface{}) *QueryBuilder

+ func (query *QueryBuilder) OrNotIn(column string, value ...interface{}) *QueryBuilder

+ func (query *QueryBuilder) OrWhere(column string, value ...interface{}) *QueryBuilder

+ func (query *QueryBuilder) OrderBy(column string, direction string) *QueryBuilder

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

+ func (query *QueryBuilder) QueryRowSQL(sql string, args ...interface{}) string

+ func (query *QueryBuilder) QueryRows(sql string, args ...interface{}) *Rows

+ func (query *QueryBuilder) QueryRowsSQL(sql string, args ...interface{}) string

+ func (query *QueryBuilder) Replace(datas ...interface{}) (int64, error)

+ func (query *QueryBuilder) ReplaceSQL(datas ...interface{}) string

+ func (query *QueryBuilder) RightJoin(tablename string, on string) *QueryBuilder

+ func (query *QueryBuilder) Row() *Row

+ func (query *QueryBuilder) RowSQL() string

+ func (query *QueryBuilder) Rows() *Rows

+ func (query *QueryBuilder) RowsSQL() string

+ func (query *QueryBuilder) Select(columns ...string) *QueryBuilder

+ func (query *QueryBuilder) Skip(offset int64) *QueryBuilder

+ func (query *QueryBuilder) Table(tablename ...string) *QueryBuilder

+ func (query *QueryBuilder) ToSql(method string) string

+ func (query *QueryBuilder) Union(unions ...QueryBuilder) *QueryBuilder

+ func (query *QueryBuilder) UnionAll(unions ...QueryBuilder) *QueryBuilder

+ func (query *QueryBuilder) UnionLimit(limit int64) *QueryBuilder

+ func (query *QueryBuilder) UnionOffset(offset int64) *QueryBuilder

+ func (query *QueryBuilder) UnionOrderBy(column string, direction string) *QueryBuilder

+ func (query *QueryBuilder) Update(data interface{}) (int64, error)

+ func (query *QueryBuilder) UpdateSQL(data interface{}) string

+ func (query *QueryBuilder) Where(column string, value ...interface{}) *QueryBuilder

+ type QueryDb struct

+ func New(config *Config) *QueryDb

+ func (querydb *QueryDb) Begin() (*QueryTx, error)

+ func (querydb *QueryDb) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (querydb *QueryDb) GetLastSql() Sql

+ func (querydb *QueryDb) LastSql(query string, args ...interface{})

+ func (querydb *QueryDb) NewQuery(ctx context.Context) *QueryBuilder

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

+ type QueryTx struct

+ func (querytx *QueryTx) Commit() error

+ func (querytx *QueryTx) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (querytx *QueryTx) GetLastSql() Sql

+ func (querytx *QueryTx) LastSql(query string, args ...interface{})

+ func (querytx *QueryTx) NewQuery(ctx context.Context) *QueryBuilder

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

+ func (querytx *QueryTx) Rollback() error

+ type Row struct

+ func (r *Row) ToArray() (result []string, err error)

+ func (r *Row) ToInterface() (result map[string]interface{}, err error)

+ func (r *Row) ToMap() (result map[string]string, err error)

+ func (r *Row) ToStruct(st interface{}) error

+ type Rows struct

+ func (r *Rows) ToArray() (data [][]string, err error)

+ func (r *Rows) ToInterface() (data []map[string]interface{}, err error)

+ func (r *Rows) ToMap() (data []map[string]string, err error)

+ func (r *Rows) ToStruct(st interface{}) error

+ type Sql struct

+ Args []interface{}

+ CostTime time.Duration

+ Sql string

+ func (sql Sql) ToJson() string

+ func (sqlRaw Sql) ToString() string