ToolsDBHelper

package

v0.0.0-...-332b391 Latest Latest Go to latest Published: Dec 20, 2022 License: BSD-3-Clause Imports: 8 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

func DoProcessRow(row *sql.Rows, Afunc func(data map[string]interface{}, Atype []*sql.ColumnType) bool) error

func DoProcessRows(rows *sql.Rows, Afunc func(data map[string]interface{}, Atype []*sql.ColumnType) bool) error

func DoQuery(rows *sql.Rows) ([]map[string]interface{}, error)

func DoRowToStruct(rows *sql.Rows, objaddr interface{}) error

func DoRowsToStruct(rows *sql.Rows, objaddr interface{}) error

type DbStruct struct {
}

简单的生成SQL语句

func (DS *DbStruct) Delete(TblName string, obj interface{}, Key string) string

func (DS *DbStruct) GenerateArgs(obj interface{}) string

func (DS *DbStruct) Insert(TblName string, obj interface{}) string

type Testt struct {
	DbStruct
	Aid int `col:"aid"`
	Abc string `col:"abc"`
	Bcd int `col:"bcd"`
	Cde float64 `col:"cde"`
}

生成插入语句

func (DS *DbStruct) Update(TblName string, obj interface{}, Key string) string

type NullInt struct {
	Int   int
	Valid bool // Valid is true if Int is not NULL
}

func (nt *NullInt) Scan(value interface{}) error

Scan 实现它的赋值方法(注意，这个方属于指针)

func (nt *NullInt) Value() (driver.Value, error)

Value 实现它的取值方式

type NullTime struct {
	Time  time.Time
	Valid bool // Valid is true if Time is not NULL
}

func (nt *NullTime) Scan(value interface{}) error

Scan 实现它的赋值方法(注意，这个方属于指针)

func (nt NullTime) Value() (driver.Value, error)

Value 实现它的取值方式