gosql

Sep 3, 2020

Changes in this version

+ type Execer interface

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

+ type Querier interface

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

+ type QueryRower interface

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

+ type Tx struct

+ func (t *Tx) Commit() error

+ func (t *Tx) Count(table string, count string) *CountQuery

+ func (t *Tx) Delete(obj interface{}) (sql.Result, error)

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

+ func (t *Tx) Insert(obj interface{}) (sql.Result, error)

+ func (t *Tx) ManualDelete(table string) *DeleteQuery

+ func (t *Tx) ManualUpdate(table string) *UpdateQuery

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

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

+ func (t *Tx) Rollback() error

+ func (t *Tx) Select(fields ...string) *SelectQuery

+ func (t *Tx) Update(obj interface{}) (sql.Result, error)

Aug 26, 2020

Changes in this version

type CountQuery

+ func (cq *CountQuery) LeftJoin(join string) *CountQuery

type DeleteQuery

+ func (dq *DeleteQuery) LeftJoin(join string) *DeleteQuery

type SelectQuery

+ func (sq *SelectQuery) LeftJoin(join string) *SelectQuery

type UpdateQuery

+ func (uq *UpdateQuery) LeftJoin(join string) *UpdateQuery

Aug 26, 2020

Changes in this version

type CountQuery

+ func (cq *CountQuery) GroupBy(bys ...string) *CountQuery

+ func (cq *CountQuery) Having(condition string, args ...interface{}) *CountQuery

+ func (cq *CountQuery) OrHaving(condition string, args ...interface{}) *CountQuery

May 3, 2020

Changes in this version

type SelectQuery

+ func (sq *SelectQuery) GroupBy(bys ...string) *SelectQuery

+ func (sq *SelectQuery) Having(condition string, args ...interface{}) *SelectQuery

+ func (sq *SelectQuery) OrHaving(condition string, args ...interface{}) *SelectQuery

Feb 5, 2020

Changes in this version

type SelectQuery

+ func (sq *SelectQuery) Get(out interface{}) error

Jan 28, 2020

Changes in this version

+ type NullInt64 struct

+ Int64 int64

+ Valid bool

+ func (n *NullInt64) Scan(value interface{}) error

+ func (n *NullInt64) UnmarshalJSON(data []byte) error

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

+ func (n NullInt64) Value() (driver.Value, error)

+ type NullString struct

+ String string

+ Valid bool

+ func (n *NullString) Scan(value interface{}) error

+ func (n *NullString) UnmarshalJSON(data []byte) error

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

+ func (n NullString) Value() (driver.Value, error)

+ type NullTime struct

+ Time time.Time

+ Valid bool

+ func (n *NullTime) Scan(value interface{}) error

+ func (n *NullTime) UnmarshalJSON(data []byte) error

+ func (n NullTime) MarshalJSON() ([]byte, error)

+ func (n NullTime) Value() (driver.Value, error)

Jan 28, 2020

Changes in this version

+ var ErrNotFound = errors.New("no result found")

+ type CountQuery struct

+ func (cq *CountQuery) Exec() (int64, error)

+ func (cq *CountQuery) Join(join string) *CountQuery

+ func (cq *CountQuery) OrWhere(condition string, args ...interface{}) *CountQuery

+ func (cq *CountQuery) String() string

+ func (cq *CountQuery) Where(condition string, args ...interface{}) *CountQuery

+ type DB struct

+ func New(db *sql.DB) *DB

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

+ func (db *DB) Count(table string, count string) *CountQuery

+ func (db *DB) Delete(obj interface{}) (sql.Result, error)

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

+ func (db *DB) Insert(obj interface{}) (sql.Result, error)

+ func (db *DB) ManualDelete(table string) *DeleteQuery

+ func (db *DB) ManualUpdate(table string) *UpdateQuery

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

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

+ func (db *DB) Register(structs ...interface{}) error

+ func (db *DB) Select(fields ...string) *SelectQuery

+ func (db *DB) Update(obj interface{}) (sql.Result, error)

+ type DeleteQuery struct

+ func (dq *DeleteQuery) Exec() (sql.Result, error)

+ func (dq *DeleteQuery) Join(join string) *DeleteQuery

+ func (dq *DeleteQuery) OrWhere(condition string, args ...interface{}) *DeleteQuery

+ func (dq *DeleteQuery) String() string

+ func (dq *DeleteQuery) Where(condition string, args ...interface{}) *DeleteQuery

+ type SelectQuery struct

+ func (sq *SelectQuery) Join(join string) *SelectQuery

+ func (sq *SelectQuery) Limit(limit int64) *SelectQuery

+ func (sq *SelectQuery) Offset(offset int64) *SelectQuery

+ func (sq *SelectQuery) OrWhere(condition string, args ...interface{}) *SelectQuery

+ func (sq *SelectQuery) OrderBy(orderBy string) *SelectQuery

+ func (sq *SelectQuery) String() string

+ func (sq *SelectQuery) To(out interface{}) error

+ func (sq *SelectQuery) Where(condition string, args ...interface{}) *SelectQuery

+ type UpdateQuery struct

+ func (uq *UpdateQuery) Exec() (sql.Result, error)

+ func (uq *UpdateQuery) Join(join string) *UpdateQuery

+ func (uq *UpdateQuery) OrWhere(condition string, args ...interface{}) *UpdateQuery

+ func (uq *UpdateQuery) Set(set string, args ...interface{}) *UpdateQuery

+ func (uq *UpdateQuery) String() string

+ func (uq *UpdateQuery) Where(condition string, args ...interface{}) *UpdateQuery