data

package

v1.0.11 Latest Latest Go to latest Published: Oct 27, 2021 License: AGPL-3.0 Imports: 4 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

Package data @Description: 该文件来源于https://github.com/FloatTech/ZeroBot-Plugin/blob/master/data/sqlite.go

This section is empty.

This section is empty.

This section is empty.

type Sqlite struct {
	DB     *sql.DB
	DBPath string
}

Sqlite 数据库对象

func (db *Sqlite) Count(table string) (num int, err error)

Count 查询数据库行数返回行数以及错误

func (db *Sqlite) Create(table string, objptr interface{}) (err error)

Create 生成数据库默认结构体的第一个元素为主键返回错误

func (db *Sqlite) Del(table string, condition string) (err error)

Del 删除数据库 condition 可为"WHERE id = 0" 返回错误

func (db *Sqlite) Find(table string, objptr interface{}, condition string) (err error)

Find 查询数据库 condition 可为"WHERE id = 0" 默认字段与结构体元素顺序一致返回错误

func (db *Sqlite) Insert(table string, objptr interface{}) (err error)

Insert 插入数据集默认结构体的第一个元素为主键返回错误

func (db *Sqlite) ListTables() (s []string, err error)

ListTables 列出所有表名返回所有表名+错误