sqlite

package

v0.0.0-...-0747d37 Latest Latest Go to latest Published: Apr 16, 2018 License: GPL-3.0 Imports: 10 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.

This section is empty.

type SqlConnPool struct {
	DriverName     string
	DataSourceName string
	SqlDB          *sql.DB // 连接池
}

var (
	DB *SqlConnPool
)

func (p *SqlConnPool) Begin() (*SqlConnTransaction, error)

// 开启一个事务

func (p *SqlConnPool) Close() error

func (p *SqlConnPool) Delete(deleteStr string, args ...interface{}) (int64, error)

func (p *SqlConnPool) Insert(insertStr string, args ...interface{}) (int64, error)

func (p *SqlConnPool) InsertMap(table string, m map[string]interface{}) (int64, error)

func (p *SqlConnPool) Query(queryStr string, args ...interface{}) ([]map[string]interface{}, error)

func (p *SqlConnPool) QueryPage(page *utils.PageTable, args ...interface{}) (*utils.PageData, error)

func (p *SqlConnPool) Update(updateStr string, args ...interface{}) (int64, error)

type SqlConnTransaction struct {
	SqlTx *sql.Tx // 单个事务连接
}

func (t *SqlConnTransaction) Commit() error

func (t *SqlConnTransaction) Delete(deleteStr string, args ...interface{}) (int64, error)

func (t *SqlConnTransaction) Insert(insertStr string, args ...interface{}) (int64, error)

func (t *SqlConnTransaction) Query(queryStr string, args ...interface{}) ([]map[string]interface{}, error)

func (t *SqlConnTransaction) Rollback() error

封装的单个事务连接的方法

func (t *SqlConnTransaction) Update(updateStr string, args ...interface{}) (int64, error)