db

Documentation

Index

• Variables
• func Delete(table, id string) error
• func DeleteTx(tx *sql.Tx, table, id string) error
• func Get(table string, kvs map[string]interface{}, obj interface{}) error
• func GetById(table string, id string, obj interface{}) error
• func Insert(table string, obj interface{}) error
• func InsertIfNotExist(table, id string, obj interface{}) error
• func InsertTx(tx *sql.Tx, table string, obj interface{}) error
• func List(field, table string, result interface{}, clause string, args ...interface{}) error
• func ToJSON(obj interface{}) (string, error)
• func Update(table, id string, newObj interface{}) error
• func UpdateKVS(table, id string, kvs map[string]interface{}) error
• func UpdateTx(tx *sql.Tx, table, id string, newObj interface{}) error
• func UpdateUUId(table, uuId string, kvs map[string]interface{}) error
• func Upsert(table, id string, obj interface{}) error

Variables

var DB *sql.DB

Functions

func Delete

func Delete(table, id string) error

func DeleteTx

func DeleteTx(tx *sql.Tx, table, id string) error

func Get

func Get(table string, kvs map[string]interface{}, obj interface{}) error

https://dev.mysql.com/doc/refman/5.7/en/json.html#json-paths

func GetById

func GetById(table string, id string, obj interface{}) error

func Insert

func Insert(table string, obj interface{}) error

func InsertIfNotExist

func InsertIfNotExist(table, id string, obj interface{}) error

func InsertTx

func InsertTx(tx *sql.Tx, table string, obj interface{}) error

func List

func List(field, table string, result interface{}, clause string, args ...interface{}) error

func ToJSON

func ToJSON(obj interface{}) (string, error)

func Update

func Update(table, id string, newObj interface{}) error

func UpdateKVS

func UpdateKVS(table, id string, kvs map[string]interface{}) error

string|int value works for now

func UpdateTx

func UpdateTx(tx *sql.Tx, table, id string, newObj interface{}) error

func UpdateUUId

func UpdateUUId(table, uuId string, kvs map[string]interface{}) error

func Upsert

func Upsert(table, id string, obj interface{}) error

Update||Insert