database

Apr 18, 2023

Changes in this version

type DBO

+ func (dbo *DBO) SelectRowsUnionToMaps(table string, cols []string, wheres [][]Where, order *Order, paging *Paging) ([]map[string]interface{}, error)

Apr 4, 2023

Changes in this version

+ type DBO struct

+ func New(dial string, logger *zap.Logger) *DBO

+ func (dbo *DBO) Delete(tx *sql.Tx, table string, where []Where) (sql.Result, error)

+ func (dbo *DBO) Excute(stmt *sql.Stmt, fields []Feild) (sql.Result, error)

+ func (dbo *DBO) Exec(tx *sql.Tx, query string, args ...any) (sql.Result, error)

+ func (dbo *DBO) Insert(tx *sql.Tx, table string, fields []Feild) (sql.Result, error)

+ func (dbo *DBO) Prepare(tx *sql.Tx, table string, fields []Feild) (*sql.Stmt, error)

+ func (dbo *DBO) SelectRawSQL(table string, sqlStr string, values []interface{}, result interface{}) error

+ func (dbo *DBO) SelectRows(table string, where []Where, order *Order, paging *Paging, result interface{}) error

+ func (dbo *DBO) SelectRowsOffset(table string, where []Where, order *Order, offset, limit uint64, ...) error

+ func (dbo *DBO) SelectRowsToMaps(table string, where []Where, order *Order, paging *Paging) ([]map[string]interface{}, error)

+ func (dbo *DBO) SelectRowsUnion(table string, wheres [][]Where, order *Order, paging *Paging, ...) error

+ func (dbo *DBO) Transaction(fn func(tx *sql.Tx) error) error

+ func (dbo *DBO) Update(tx *sql.Tx, table string, toupdate []Feild, where []Where) (sql.Result, error)

+ type Feild struct

+ Name string

+ Value interface{}

+ type Order struct

+ Feilds []string

+ Type string

+ func MakeOrder(ordertype string, fields ...string) (*Order, error)

+ func (o *Order) GetOp() string

+ type Paging struct

+ CursorName string

+ CursorValue uint64

+ Limit uint64

+ func MakePaging(colName string, colValue uint64, limit uint64) *Paging

+ type Where struct

+ Name string

+ Op string

+ Value interface{}

+ func (w *Where) GetOp() string