Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

dbquery

package

Go to main page

Versions in this module

v0

v0.8.0

Feb 5, 2021

v0.7.10

Feb 3, 2021

v0.7.9

Feb 3, 2021

v0.7.8

Feb 2, 2021

v0.7.7

Jan 31, 2021

v0.7.6

Jan 31, 2021

v0.7.5

Jan 31, 2021

v0.7.4

Jan 31, 2021

v0.7.3

Jan 31, 2021

v0.7.2

Jan 30, 2021

v0.7.1

Jan 29, 2021

v0.7.0

Jan 27, 2021

v0.6.9

Jan 27, 2021

v0.6.8

Jan 27, 2021

v0.6.7

Jan 27, 2021

Changes in this version

+ func LeftJoinListByStmt(dbName string, tableA, tableB string, join_on string, title string, ...) ([]map[string]string, error)

v0.6.6

Jan 27, 2021

v0.6.5

Jan 27, 2021

v0.6.3

Jan 27, 2021

v0.6.2

Jan 27, 2021

v0.6.1

Jan 27, 2021

v0.6.0

Jan 27, 2021

Changes in this version

+ var DB *sql.DB

+ func CloseConn() error

+ func CloseStmt(stmt *sql.Stmt) error

+ func Connect(DBHOST, DBUSER, DBPWD, DBNAME, DBPORT string, conns ...int) error

+ func Delete(dbName, table string, data map[string]string, del_count ...string) (int64, error)

+ func DoQuery(args ...interface{}) ([]map[string]string, error)

+ func GetCount(dbName, table string, where map[string]string, args ...string) (total int)

+ func GetData(dbName, table string, title string, where map[string]string, ...) (int, map[string]string, error)

+ func GetDataByStmt(dbName string, table string, title string, where []string, ...) (map[string]string, error)

+ func GetDbTableName(dbName, table string) string

+ func GetInfo(dbName, table string, title string, where map[string]string) (map[string]string, error)

+ func GetJoinListByStmt(dbName string, tableA, tableA_alias string, tableB, tableB_alias string, ...) ([]map[string]string, error)

+ func GetList(dbName, table string, title string, where map[string]string, ...) ([]map[string]string, error)

+ func GetListByStmt(dbName string, table string, title string, where []string, ...) ([]map[string]string, error)

+ func GetTotal(dbName, table string, args ...string) (total int)

+ func Insert(dbName, table string, data map[string]string) (int64, error)

+ func InsertByStmt(dbName string, table string, data []string, valuelist []interface{}) (int64, error)

+ func QueryByStmt(sql string, valuelist []interface{}) ([]map[string]string, error)

+ func StmtForInsert(dbName, table string, data []string) (*sql.Stmt, error)

+ func StmtForInsertExec(stmt *sql.Stmt, valuelist []interface{}) (int64, error)

+ func StmtForQuery(querysql string) (*sql.Stmt, error)

+ func StmtForQueryList(stmt *sql.Stmt, valuelist []interface{}) ([]map[string]string, error)

+ func StmtForQueryRow(stmt *sql.Stmt, valuelist []interface{}) (map[string]string, error)

+ func StmtForRead(dbName, table string, title string, where []string, limit map[string]string) (*sql.Stmt, error)

+ func StmtForUpdate(dbName, table string, data []string, where []string) (*sql.Stmt, error)

+ func StmtForUpdateExec(stmt *sql.Stmt, valuelist []interface{}) (int64, error)

+ func TxDelete(tx *sql.Tx, dbname, table string, where map[string]string, del_count ...string) (int64, error)

+ func TxForRead(tx *sql.Tx, dbName, table string, title string, where []string) (*sql.Stmt, error)

+ func TxGetData(tx *sql.Tx, dbName string, table string, title string, where []string, ...) (map[string]string, error)

+ func TxInsert(tx *sql.Tx, dbname, table string, data map[string]string) (int64, error)

+ func TxPreInsert(tx *sql.Tx, dbname, table string, data map[string]interface{}) (int64, error)

+ func TxPreUpdate(tx *sql.Tx, dbname, table string, data []string, where []string, ...) (int64, error)

+ func TxUpdate(tx *sql.Tx, dbname, table string, data map[string]string, ...) (int64, error)

+ func Update(dbName, table string, data map[string]string, where map[string]string) (int64, error)

+ func UpdateByStmt(dbName string, table string, data []string, where []string, ...) (int64, error)