mysql

Documentation

Index

• func GetConfigs(name string) map[string]*Config
• func SetConfig(name string, c map[string]any) error
• func SetIniConfig(name string, section *ini.Section) error
• type Config
  • func GetConfig(name string) (*Config, error)
• type Driver
  • func GetDb(name string) (*Driver, error)
  • func (d *Driver) GetConfig() *Config
  • func (d *Driver) Init() error
  • func (d *Driver) SetConfig(config *Config)
  • func (d *Driver) Tx() (*Executor, error)
• type Executor
  • func (e *Executor) Delete(table string, where map[string]any) (sql.Result, error)
  • func (e *Executor) Exec(sq string, args ...any) (sql.Result, error)
  • func (e *Executor) GetBind(bind *any, sq string, args ...any) error
  • func (e *Executor) GetMap(sq string, args ...any) (map[string]string, error)
  • func (e *Executor) GetMaps(sq string, args ...any) ([]map[string]string, error)
  • func (e *Executor) GetTable(table string) *Table
  • func (e *Executor) GetTuple(table string) *Tuple
  • func (e *Executor) GetValue(sq string, args ...any) (string, error)
  • func (e *Executor) GetValues(sq string, args ...any) ([]string, error)
  • func (e *Executor) Insert(table string, data map[string]any) (sql.Result, error)
  • func (e *Executor) Query(sq string, args ...any) (*sql.Rows, error)
  • func (e *Executor) Truncate(table string) (sql.Result, error)
  • func (e *Executor) Update(table string, data map[string]any, primaryKeys ...string) (sql.Result, error)
• type ExecutorType
• type Table
  • func (table *Table) Count(fields string) int
  • func (table *Table) GetValue(fields string) string
  • func (table *Table) Init() *Table
  • func (table *Table) Limit(limit int) *Table
  • func (table *Table) Offset(offset int) *Table
  • func (table *Table) OrderBy(field string, dir string) *Table
  • func (table *Table) OrderByStr(orderBy string) *Table
  • func (table *Table) SetExecutor(e *Executor) *Table
  • func (table *Table) SetName(name string) *Table
  • func (table *Table) SetStruct(s any) *Table
  • func (table *Table) Where(params ...any) *Table
  • func (table *Table) WhereGroup(params []any) *Table
• type Tuple
  • func (tuple *Tuple) Init() *Tuple
  • func (tuple *Tuple) SetExecutor(e *Executor) *Tuple
  • func (tuple *Tuple) SetName(name string)
  • func (tuple *Tuple) SetStruct(s any)

Functions

func GetConfigs

func GetConfigs(name string) map[string]*Config

GetConfigs 获取配置项

func SetConfig

func SetConfig(name string, c map[string]any) error

SetIniConfig 配置

func SetIniConfig

func SetIniConfig(name string, section *ini.Section) error

SetIniConfig 设置 ini 配置

Types

type Config

type Config struct {
	// contains filtered or unexported fields
}

func GetConfig

func GetConfig(name string) (*Config, error)

GetConfig 获取配置项

type Driver

type Driver struct {
	*Executor
	// contains filtered or unexported fields
}

func GetDb

func GetDb(name string) (*Driver, error)

GetDb 获取数据库实例

func (*Driver) GetConfig

func (d *Driver) GetConfig() *Config

GetConfig 参数配置

func (*Driver) Init

func (d *Driver) Init() error

Init 初始化

func (*Driver) SetConfig

func (d *Driver) SetConfig(config *Config)

SetConfig 参数配置

func (*Driver) Tx

func (d *Driver) Tx() (*Executor, error)

Tx 开启事务

type Executor

type Executor struct {
	// contains filtered or unexported fields
}

func (*Executor) Delete

func (e *Executor) Delete(table string, where map[string]any) (sql.Result, error)

Delete 删除

func (*Executor) Exec

func (e *Executor) Exec(sq string, args ...any) (sql.Result, error)

Exec 执行，用于 insert / update / delete

func (*Executor) GetBind

func (e *Executor) GetBind(bind *any, sq string, args ...any) error

GetBind 查询记录, 缓定到指定对象

func (*Executor) GetMap

func (e *Executor) GetMap(sq string, args ...any) (map[string]string, error)

GetMap 查询一行记录

func (*Executor) GetMaps

func (e *Executor) GetMaps(sq string, args ...any) ([]map[string]string, error)

GetMaps 查询多行记录

func (*Executor) GetTable

func (e *Executor) GetTable(table string) *Table

GetTable 获取表记录

func (*Executor) GetTuple

func (e *Executor) GetTuple(table string) *Tuple

GetTuple 获取行记录

func (*Executor) GetValue

func (e *Executor) GetValue(sq string, args ...any) (string, error)

GetValue 查询一个字段的值

func (*Executor) GetValues

func (e *Executor) GetValues(sq string, args ...any) ([]string, error)

GetValues 查询一个字段的值

func (*Executor) Insert

func (e *Executor) Insert(table string, data map[string]any) (sql.Result, error)

Insert 插入数据

func (*Executor) Query

func (e *Executor) Query(sq string, args ...any) (*sql.Rows, error)

Query 查询，返回查询结果集，用于 select

func (*Executor) Truncate

func (e *Executor) Truncate(table string) (sql.Result, error)

Truncate 清空表

func (*Executor) Update

func (e *Executor) Update(table string, data map[string]any, primaryKeys ...string) (sql.Result, error)

Update 更新数据

type ExecutorType

type ExecutorType string

const (
	ExecutorTypeDb ExecutorType = "db"
	ExecutorTypeTx ExecutorType = "tx"
)

type Table

type Table struct {
	// contains filtered or unexported fields
}

func (*Table) Count

func (table *Table) Count(fields string) int

Count 获取总数

func (*Table) GetValue

func (table *Table) GetValue(fields string) string

GetValue 获取值

func (*Table) Init

func (table *Table) Init() *Table

Init 初始化

func (*Table) Limit

func (table *Table) Limit(limit int) *Table

Limit 读取条数，即分页大小

func (*Table) Offset

func (table *Table) Offset(offset int) *Table

Offset 编移量

func (*Table) OrderBy

func (table *Table) OrderBy(field string, dir string) *Table

OrderBy 排序

func (*Table) OrderByStr

func (table *Table) OrderByStr(orderBy string) *Table

OrderByStr 排序字符串

func (*Table) SetExecutor

func (table *Table) SetExecutor(e *Executor) *Table

SetExecutor 设置执行品

func (*Table) SetName

func (table *Table) SetName(name string) *Table

SetName 设置名称

func (*Table) SetStruct

func (table *Table) SetStruct(s any) *Table

SetStruct 设置结构

func (*Table) Where

func (table *Table) Where(params ...any) *Table

Where 查询条件

func (*Table) WhereGroup

func (table *Table) WhereGroup(params []any) *Table

WhereGroup 一组查询条件

type Tuple

type Tuple struct {
	// contains filtered or unexported fields
}

func (*Tuple) Init

func (tuple *Tuple) Init() *Tuple

Init 初始化

func (*Tuple) SetExecutor

func (tuple *Tuple) SetExecutor(e *Executor) *Tuple

SetExecutor 设置执行品

func (*Tuple) SetName

func (tuple *Tuple) SetName(name string)

SetName 设置名称

func (*Tuple) SetStruct

func (tuple *Tuple) SetStruct(s any)

SetStruct 设置结构