sqlite3

package

v0.0.0-...-a11b62f Latest Latest Go to latest Published: Apr 12, 2021 License: GPL-3.0 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

Repository

github.com/huangtao-sh/grape

Documentation ¶

Index ¶

func Attach(path string, name string)
func Close()
func Config(pathName string)
func Detach(name string)
func ExecScript(sql string)
func ExecTx(txers ...interface{}) (err error)
func FetchValue(sql string, args ...interface{}) interface{}
func LoadSQL(method string, table string, columns interface{}) string
func NewDB() *sql.DB
func PrintRow(header string, query string, args ...interface{}) (err error)
func Printf(format string, sql string, args ...interface{})
func Println(sql string, args ...interface{})
func QueryRow(query string, args ...interface{}) *sql.Row
func StructAddr(s interface{}) []interface{}
type DataCh
type ExecFunc
- func NewTr(sql string, params ...interface{}) ExecFunc
type RowReader
- func Fetch(sql string, args ...interface{}) (reader *RowReader)
- func (r *RowReader) Read() []interface{}
type Tx
- func NewTx() *Tx
- func (tx *Tx) ExecCh(sql string, data DataCh) (err error)
- func (tx *Tx) Fetch(sql string, args ...interface{}) (reader *RowReader)
- func (tx *Tx) FetchValue(sql string, args ...interface{}) interface{}
type Txer

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func Attach ¶

func Attach(path string, name string)

Attach 附加数据库

func Close ¶

func Close()

Close 关闭数据库

func Config ¶

func Config(pathName string)

Config 配置数据库文件配置完成之后，可以直接调用 Open 打开

func Detach ¶

func Detach(name string)

Detach 分离数据库

func ExecScript ¶

func ExecScript(sql string)

ExecScript 执行脚本，支持多条语句，用于执行 DDL 语句

func ExecTx ¶

func ExecTx(txers ...interface{}) (err error)

ExecTx 执行事务

func FetchValue ¶

func FetchValue(sql string, args ...interface{}) interface{}

FetchValue 执行查询，并返回值

func LoadSQL ¶

func LoadSQL(method string, table string, columns interface{}) string

LoadSQL 生成导入 SQL 语句

func NewDB ¶

func NewDB() *sql.DB

NewDB 打开数据库

func PrintRow ¶

func PrintRow(header string, query string, args ...interface{}) (err error)

PrintRow 查询并打印单行数据，作为一个对象打印采用的格式为： Name Value 的格式打印

func Printf ¶

func Printf(format string, sql string, args ...interface{})

Printf 执行查询，并打印查询结果

func Println ¶

func Println(sql string, args ...interface{})

Println 执行查询，并打印查询结果

func QueryRow ¶

func QueryRow(query string, args ...interface{}) *sql.Row

QueryRow 执行查询，返回一行数据

func StructAddr ¶

func StructAddr(s interface{}) []interface{}

StructAddr 获取 Struct 的地址列表

Types ¶

type DataCh ¶

type DataCh interface {
	Done()
	ReadCh() <-chan []interface{}
}

DataCh 数据通道接口

type ExecFunc ¶

type ExecFunc func(*Tx) error

ExecFunc 执行函数类型

func NewTr ¶

func NewTr(sql string, params ...interface{}) ExecFunc

NewTr Tr构造函数

type RowReader ¶

type RowReader struct {
	*sql.Rows
	// contains filtered or unexported fields
}

RowReader 查询接口

func Fetch ¶

func Fetch(sql string, args ...interface{}) (reader *RowReader)

Fetch 执行查询，并返回查询结果

func (*RowReader) Read ¶

func (r *RowReader) Read() []interface{}

Read 读取下一条记录

type Tx ¶

type Tx struct {
	*sql.Tx
}

Tx 数据库事务

func NewTx ¶

func NewTx() *Tx

NewTx 新建事务

func (*Tx) ExecCh ¶

func (tx *Tx) ExecCh(sql string, data DataCh) (err error)

ExecCh 执行通道中的数据

func (*Tx) Fetch ¶

func (tx *Tx) Fetch(sql string, args ...interface{}) (reader *RowReader)

Fetch 查询数据

func (*Tx) FetchValue ¶

func (tx *Tx) FetchValue(sql string, args ...interface{}) interface{}

FetchValue 查询值

type Txer ¶

type Txer interface {
	Exec(tx *Tx) error
}

Txer 数据库事务执行接口

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL