db

package
v1.4.0 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jan 14, 2025 License: BSD-3-Clause Imports: 13 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type MySQLDB added in v1.0.12 

type MySQLDB struct {
	DB *sql.DB // 数据库连接对象
	// contains filtered or unexported fields
}

func MySQLConnect added in v1.0.12 

func MySQLConnect(UseDataBases string) *MySQLDB

连接 MySQL 数据库

func (*MySQLDB) Count added in v1.2.0 

func (mysqlDB *MySQLDB) Count() (int, error)

返回查询条数数量

func (*MySQLDB) Delete added in v1.0.12 

func (mysqlDB *MySQLDB) Delete() (sql.Result, error)

删除数据，返回操作条数

func (*MySQLDB) Execute added in v1.0.12 

func (mysqlDB *MySQLDB) Execute(query string, args ...interface{}) (sql.Result, error)

执行语句

func (*MySQLDB) Exists added in v1.4.0 

func (mysqlDB *MySQLDB) Exists() (bool, error)

是否存在

func (MySQLDB) Fields added in v1.0.12 

func (mysqlDB MySQLDB) Fields(fields ...string) *MySQLDB

设置查询结果字段 return 当前 *MySQLDB 的副本指针

func (*MySQLDB) First added in v1.0.12 

func (mysqlDB *MySQLDB) First(queryResult interface{}) error

返回第一条数据

func (MySQLDB) GetSQL added in v1.4.0 

func (mysqlDB MySQLDB) GetSQL() string

获取SQL语句

func (MySQLDB) GroupBy added in v1.4.0 

func (mysqlDB MySQLDB) GroupBy(groups ...string) *MySQLDB

分组 return 当前 *MySQLDB 的副本指针

func (*MySQLDB) Insert added in v1.0.12 

func (mysqlDB *MySQLDB) Insert(ModelData mysql.MySQLModel) (sql.Result, error)

插入到数据库

func (*MySQLDB) Migrate added in v1.3.1 

func (mysqlDB *MySQLDB) Migrate(db_name string, model mysql.MySQLModel)

模型迁移

func (MySQLDB) Name added in v1.0.12 

func (mysqlDB MySQLDB) Name() string

获取数据库别名

func (MySQLDB) OrderBy added in v1.2.0 

func (mysqlDB MySQLDB) OrderBy(orders ...string) *MySQLDB

排序 return 当前 *MySQLDB 的副本指针

func (*MySQLDB) Page added in v1.2.0 

func (mysqlDB *MySQLDB) Page(page int, pagesize int) (int, int, error)

分页

func (*MySQLDB) Query added in v1.0.12 

func (mysqlDB *MySQLDB) Query(query string, args ...interface{}) (*sql.Rows, error)

查询语句

func (*MySQLDB) Select added in v1.0.12 

func (mysqlDB *MySQLDB) Select(queryResult interface{}) error

执行查询语句获取数据

func (*MySQLDB) SetModel added in v1.0.12 

func (mysqlDB *MySQLDB) SetModel(model mysql.MySQLModel) *MySQLDB

设置使用模型 return 当前 *MySQLDB 本身

func (*MySQLDB) Update added in v1.0.12 

func (mysqlDB *MySQLDB) Update(ModelData mysql.MySQLModel) (sql.Result, error)

更新数据，返回操作条数

func (MySQLDB) Where added in v1.0.12 

func (mysqlDB MySQLDB) Where(query string, args ...interface{}) *MySQLDB

设置条件查询语句 return 当前 *MySQLDB 的副本指针

func (*MySQLDB) WithTransaction added in v1.4.0 

func (mysqlDB *MySQLDB) WithTransaction(transactionFunc func(mysqlDB *MySQLDB, args ...interface{}) error, args ...interface{}) error

事务

type SQLite3DB added in v1.0.12 

type SQLite3DB struct {
	DB *sql.DB // 数据库连接对象
	// contains filtered or unexported fields
}

func SQLite3Connect added in v1.0.12 

func SQLite3Connect(UseDataBases string) *SQLite3DB

连接 SQLite3 数据库

func (*SQLite3DB) Count added in v1.2.0 

func (sqlite3DB *SQLite3DB) Count() (int, error)

返回查询条数数量

func (*SQLite3DB) Delete added in v1.0.12 

func (sqlite3DB *SQLite3DB) Delete() (sql.Result, error)

删除数据，返回操作条数

func (*SQLite3DB) Execute added in v1.0.12 

func (sqlite3DB *SQLite3DB) Execute(query string, args ...interface{}) (sql.Result, error)

执行语句

func (*SQLite3DB) Exists added in v1.4.0 

func (sqlite3DB *SQLite3DB) Exists() (bool, error)

是否存在

func (SQLite3DB) Fields added in v1.0.12 

func (sqlite3DB SQLite3DB) Fields(fields ...string) *SQLite3DB

设置查询结果字段 return 当前 *SQLite3DB 的副本指针

func (*SQLite3DB) First added in v1.0.12 

func (sqlite3DB *SQLite3DB) First(queryResult interface{}) error

返回第一条数据

func (SQLite3DB) GetSQL added in v1.4.0 

func (sqlite3DB SQLite3DB) GetSQL() string

获取SQL语句

func (SQLite3DB) GroupBy added in v1.4.0 

func (sqlite3DB SQLite3DB) GroupBy(groups ...string) *SQLite3DB

分组 return 当前 *SQLite3DB 的副本指针

func (*SQLite3DB) Insert added in v1.0.12 

func (sqlite3DB *SQLite3DB) Insert(ModelData sqlite3.SQLite3Model) (sql.Result, error)

插入数据库

func (*SQLite3DB) Migrate added in v1.3.1 

func (sqlite3DB *SQLite3DB) Migrate(db_name string, model sqlite3.SQLite3Model)

模型迁移

func (SQLite3DB) Name added in v1.0.12 

func (sqlite3DB SQLite3DB) Name() string

获取数据库别名

func (SQLite3DB) OrderBy added in v1.2.0 

func (sqlite3DB SQLite3DB) OrderBy(orders ...string) *SQLite3DB

排序 return 当前 *SQLite3DB 的副本指针

func (*SQLite3DB) Page added in v1.2.0 

func (sqlite3DB *SQLite3DB) Page(page int, pagesize int) (int, int, error)

分页

func (*SQLite3DB) Query added in v1.0.12 

func (sqlite3DB *SQLite3DB) Query(query string, args ...interface{}) (*sql.Rows, error)

查询语句

func (*SQLite3DB) Select added in v1.0.12 

func (sqlite3DB *SQLite3DB) Select(queryResult interface{}) error

执行查询语句获取数据

func (*SQLite3DB) SetModel added in v1.0.12 

func (sqlite3DB *SQLite3DB) SetModel(model sqlite3.SQLite3Model) *SQLite3DB

设置使用模型 return 当前 *SQLite3DB 本身

func (*SQLite3DB) Update added in v1.0.12 

func (sqlite3DB *SQLite3DB) Update(ModelData sqlite3.SQLite3Model) (sql.Result, error)

更新数据，返回操作条数

func (SQLite3DB) Where added in v1.0.12 

func (sqlite3DB SQLite3DB) Where(query string, args ...interface{}) *SQLite3DB

设置条件查询语句 return 当前 *SQLite3DB 的副本指针

func (*SQLite3DB) WithTransaction added in v1.4.0 

func (sqlite3DB *SQLite3DB) WithTransaction(transactionFunc func(sqlite3DB *SQLite3DB, args ...interface{}) error, args ...interface{}) error

事务

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.