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

dbutils

package

Go to main page

Versions in this module

v1

v1.0.4

Jul 28, 2022

v1.0.3

Dec 30, 2021

v1.0.2

Dec 17, 2021

v1.0.1

Sep 29, 2021

Changes in this version

type SplitDbAndTbl

+ func (t SplitDbAndTbl) GetDbNum4int64(ival int64) (dbnum int64, err error)

+ func (t SplitDbAndTbl) GetTblNum4int64(ival int64) (tblnum int64, err error)

v1.0.0

Jul 27, 2021

Changes in this version

+ var ErrInsertEmpty = errors.New("The insert cannot be empty")

+ var ErrTableEmpty = errors.New("The table name cannot be empty")

+ var ErrUpdateEmpty = errors.New("The update cannot be empty")

+ func CamelCase(s string) string

+ func DbConnect(dsn string) (*sql.DB, error)

+ func DeleteSql(connect *sql.DB, insSql string, args ...interface{}) (num int64, err error)

+ func FiledType2GoType(fieldTypeStr string) string

+ func GenerateGormModel(connect *sql.DB, dbName string, tableNames []string, cfg map[string]string) map[string]string

+ func GetDbConnect(dbnameCode, dsn string) (*sql.DB, error)

+ func GetDsn(dbConfig map[string]interface{}) string

+ func GetFieldComment(field map[string]string) string

+ func GetHashOrd(str string) int64

+ func GetHashOrd127(str string) int64

+ func GetLikeStr(str string, pos int) string

+ func GetSimpleTableInfo(connect *sql.DB, dbName string, tableNames []string) []map[string]string

+ func GetTableFields(connect *sql.DB, tbl string) ([]map[string]string, error)

+ func GormModelFormat(table map[string]string, fields []map[string]string, cfg map[string]string) string

+ func InsertSql(connect *sql.DB, insSql string, args ...interface{}) (id int64, err error)

+ func JoinInt2Str(data []int, sep string) string

+ func JoinInt642Str(data []int64, sep string) string

+ func Md5V1(str string) string

+ func PinConditionIn(field string, condition string, values []interface{}) (string, []interface{})

+ func PinInStr(strs []string) string

+ func PinWhereNotIn(field string, values []interface{}) (string, []interface{})

+ func SelectOne(connect *sql.DB, sqlStr string, args ...interface{}) (map[string]string, error)

+ func SelectRows(connect *sql.DB, sqlStr string, args ...interface{}) ([]map[string]string, error)

+ func ShowCreateTable(connect *sql.DB, tblName string) (string, error)

+ func ShowTables(connect *sql.DB) []string

+ func StrInSlice(a string, list []string) bool

+ func UpdateSql(connect *sql.DB, insSql string, args ...interface{}) (num int64, err error)

+ func WenHaoPlaceholders(n int) string

+ func WrapField(field string) string

+ func WrapTable(field string) string

+ type GormModel struct

+ CreateTime int64

+ DeleteTime int64

+ ID int64

+ IsDelete int8

+ UpdateTime int64

+ type MysqlDsn struct

+ func NewMysqlDsn(dbConfig map[string]interface{}) *MysqlDsn

+ func (m *MysqlDsn) GetCharset() string

+ func (m *MysqlDsn) GetDbname() string

+ func (m *MysqlDsn) GetExtparam() string

+ func (m *MysqlDsn) GetHost() string

+ func (m *MysqlDsn) GetPassword() string

+ func (m *MysqlDsn) GetPort() string

+ func (m *MysqlDsn) GetUsername() string

+ func (m *MysqlDsn) Key() string

+ func (m *MysqlDsn) ToDsn() string

+ type SQLBuilderDelete struct

+ func NewSQLBuilderDelete() *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) ConditionWhere(operator string, field string, condition string, value interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) GetSQL() (string, error)

+ func (sqlb *SQLBuilderDelete) GetWhereParamValues() []interface{}

+ func (sqlb *SQLBuilderDelete) OrWhere(field string, condition string, value interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) OrWhereIn(field string, values ...interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) OrWhereNotIn(field string, values ...interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) OrWhereRaw(raw string, values ...interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) OrderBy(order string) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) Raw(operator string, raw string, values []interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) SetLimit(rowCount string) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) SetTable(tbl string) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) Where(field string, condition string, value interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) WhereIn(field string, values ...interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) WhereNotIn(field string, values ...interface{}) *SQLBuilderDelete

+ func (sqlb *SQLBuilderDelete) WhereRaw(raw string, values ...interface{}) *SQLBuilderDelete

+ type SQLBuilderInsert struct

+ func NewSQLBuilderInsert() *SQLBuilderInsert

+ func (sqlb *SQLBuilderInsert) GetParamValues() []interface{}

+ func (sqlb *SQLBuilderInsert) GetSql() (string, error)

+ func (sqlb *SQLBuilderInsert) SetInsertData(fileds []string, values ...interface{}) *SQLBuilderInsert

+ func (sqlb *SQLBuilderInsert) SetTable(tbl string) *SQLBuilderInsert

+ type SQLBuilderSelect struct

+ func NewSQLBuilderSelect() *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) ConditionWhere(operator string, field string, condition string, value interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) GetSQL() (string, error)

+ func (sqlb *SQLBuilderSelect) GetWhereParamValues() []interface{}

+ func (sqlb *SQLBuilderSelect) GroupBy(fields ...string) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) JoinRaw(join string, values ...interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) OrWhere(field string, condition string, value interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) OrWhereIn(field string, values ...interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) OrWhereNotIn(field string, values ...interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) OrWhereRaw(raw string, values ...interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) OrderBy(order string) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) Raw(operator string, raw string, values []interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) Select(fields ...string) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) SetTable(tbl string) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) Where(field string, condition string, value interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) WhereIn(field string, values ...interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) WhereNotIn(field string, values ...interface{}) *SQLBuilderSelect

+ func (sqlb *SQLBuilderSelect) WhereRaw(raw string, values ...interface{}) *SQLBuilderSelect

+ type SQLBuilderUpdate struct

+ func NewSQLBuilderUpdate() *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) ConditionWhere(operator string, field string, condition string, value interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) GetParamValues() []interface{}

+ func (sqlb *SQLBuilderUpdate) GetSQL() (string, error)

+ func (sqlb *SQLBuilderUpdate) GetSetParamValues() []interface{}

+ func (sqlb *SQLBuilderUpdate) GetWhereParamValues() []interface{}

+ func (sqlb *SQLBuilderUpdate) OrWhere(field string, condition string, value interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) OrWhereIn(field string, values ...interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) OrWhereNotIn(field string, values ...interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) OrWhereRaw(raw string, values ...interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) OrderBy(order string) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) Raw(operator string, raw string, values []interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) SetLimit(rowCount string) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) SetTable(tbl string) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) SetUpdateData(fileds []string, values ...interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) Where(field string, condition string, value interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) WhereIn(field string, values ...interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) WhereNotIn(field string, values ...interface{}) *SQLBuilderUpdate

+ func (sqlb *SQLBuilderUpdate) WhereRaw(raw string, values ...interface{}) *SQLBuilderUpdate

+ type SplitDbAndTbl struct

+ func NewSplitDbAndTbl(dbnum, tblnum int64) SplitDbAndTbl

+ func (t SplitDbAndTbl) GetDBBaseByStrUserid(userid string) map[string]int64

+ func (t SplitDbAndTbl) GetDBBaseByUserid(userid uint64) map[string]int64

+ func (t SplitDbAndTbl) GetDbNum(sVal string) (dbnum int64, err error)

+ func (t SplitDbAndTbl) GetTblNum(sVal string) (tblnum int64, err error)

+ func (t SplitDbAndTbl) GetTotalDbNum() int64

+ func (t SplitDbAndTbl) GetTotalTblNum() int64