Documentation ¶
Index ¶
- Constants
- func ObjectToTagMap(obj any, tag string) (map[string]interface{}, error)
- type Clause
- type ColumnObj
- type SQLEngine
- func (se *SQLEngine[T]) And(condition string, vals ...interface{}) *SQLEngine[T]
- func (se *SQLEngine[T]) Clear() *SQLEngine[T]
- func (se *SQLEngine[T]) CloseClause() *SQLEngine[T]
- func (se *SQLEngine[T]) Count() *SQLEngine[T]
- func (se *SQLEngine[T]) Delete() *SQLEngine[T]
- func (se *SQLEngine[T]) Exec() (sql.Result, error)
- func (se *SQLEngine[T]) Find(obj any, columns ...string) error
- func (se *SQLEngine[T]) Get(obj any, columns ...string) error
- func (se *SQLEngine[T]) InsertNamed(tag string, objs ...T) *SQLEngine[T]
- func (se *SQLEngine[T]) Or(condition string, vals ...interface{}) *SQLEngine[T]
- func (se *SQLEngine[T]) Select(columns ...string) *SQLEngine[T]
- func (se *SQLEngine[T]) Set(condition string, vals ...interface{}) *SQLEngine[T]
- func (se *SQLEngine[T]) Update() *SQLEngine[T]
- func (se *SQLEngine[T]) Value() (string, []interface{}, error)
- func (se *SQLEngine[T]) Where(condition string, vals ...interface{}) *SQLEngine[T]
- type TableObject
Constants ¶
View Source
const ( SELECT optionType // 查询 UPDATE // 修改 DELETE // 删除 INSERT // 新增 )
Variables ¶
This section is empty.
Functions ¶
Types ¶
type Clause ¶
type Clause struct { Condition []string // 语句(条件语句或设置语句) xxx = ? | xxx in (?) ... Params []interface{} // 值 End bool // 是否结束当前子句 }
子句 - 单个块的子句为 and 当存在多个子句时用 or 拼接
type SQLEngine ¶
type SQLEngine[T TableObject] struct { // contains filtered or unexported fields }
SQL引擎 - 基础单表操作sql引擎,快速进行单表操作
func NewSQLEngine ¶
func NewSQLEngine[T TableObject](db *sqlx.DB) *SQLEngine[T]
func (*SQLEngine[T]) CloseClause ¶
关闭当前子句 - 用于进入到下一条or子句 或结束当前or子句操作
func (*SQLEngine[T]) InsertNamed ¶
Insert insert named语句生成器(允许生成批量插入) 此方法依据tag获取字段名称,并将依据此tag的值设定为列名进行插入语句生成
type TableObject ¶
type TableObject interface {
TableName() string // 返回表名
}
Click to show internal directories.
Click to hide internal directories.