Documentation
¶
Overview ¶
* @Author: kamalyes 501893067@qq.com * @Date: 2024-12-05 20:08:55 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2024-12-06 11:55:16 * @FilePath: \go-toolbox\pkg\sqlbuilderx\builder.go * @Description: * * Copyright (c) 2024 by kamalyes, All Rights Reserved.
* @Author: kamalyes 501893067@qq.com * @Date: 2024-12-05 20:08:55 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2024-12-06 11:06:59 * @FilePath: \go-toolbox\pkg\sqlbuilderx\exec.go * @Description: * * Copyright (c) 2024 by kamalyes, All Rights Reserved.
* @Author: kamalyes 501893067@qq.com * @Date: 2024-12-05 20:08:55 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2024-12-05 20:15:55 * @FilePath: \go-toolbox\pkg\sqlbuilderx\joins.go * @Description: * * Copyright (c) 2024 by kamalyes, All Rights Reserved.
* @Author: kamalyes 501893067@qq.com * @Date: 2024-12-05 20:08:55 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2024-12-05 20:15:55 * @FilePath: \go-toolbox\pkg\sqlbuilderx\query.go * @Description: * * Copyright (c) 2024 by kamalyes, All Rights Reserved.
* @Author: kamalyes 501893067@qq.com * @Date: 2024-12-05 20:08:55 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2024-12-06 11:55:55 * @FilePath: \go-toolbox\pkg\sqlbuilderx\utils.go * @Description: * * Copyright (c) 2024 by kamalyes, All Rights Reserved.
* @Author: kamalyes 501893067@qq.com * @Date: 2024-12-05 20:08:55 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2024-12-05 20:15:55 * @FilePath: \go-toolbox\pkg\sqlbuilderx\where.go * @Description: * * Copyright (c) 2024 by kamalyes, All Rights Reserved.
Index ¶
- type Builder
- func (b *Builder) Clone() *Builder
- func (b *Builder) Delete() (string, []interface{})
- func (b *Builder) DuplicateKey(duplicateKey map[string]interface{}) *Builder
- func (b *Builder) GetField() []interface{}
- func (b *Builder) GetGroup() []string
- func (b *Builder) GetHaving() []string
- func (b *Builder) GetJoin() []string
- func (b *Builder) GetLimit() string
- func (b *Builder) GetOrder() []string
- func (b *Builder) GetTable() string
- func (b *Builder) GetWhere() []string
- func (b *Builder) Group(group ...string) *Builder
- func (b *Builder) Having(args ...interface{}) *Builder
- func (b *Builder) Insert(args ...interface{}) (string, []interface{})
- func (b *Builder) Join(table interface{}, condition string, params ...interface{}) *Builder
- func (b *Builder) Joins(table interface{}, condition string, joinType string, params ...interface{}) *Builder
- func (b *Builder) LefJoin(table interface{}, condition string, params ...interface{}) *Builder
- func (b *Builder) Limit(args ...int64) *Builder
- func (b *Builder) OrHaving(args ...interface{}) *Builder
- func (b *Builder) OrWhere(args ...interface{}) *Builder
- func (b *Builder) OrWhereBetween(field string, value ...interface{}) *Builder
- func (b *Builder) OrWhereExists(where func(*Builder)) *Builder
- func (b *Builder) OrWhereIn(field string, value ...interface{}) *Builder
- func (b *Builder) OrWhereNotBetween(field string, value ...interface{}) *Builder
- func (b *Builder) OrWhereNotExists(where func(*Builder)) *Builder
- func (b *Builder) OrWhereNotIn(field string, value ...interface{}) *Builder
- func (b *Builder) OrWhereNotNull(field string) *Builder
- func (b *Builder) OrWhereNull(field string) *Builder
- func (b *Builder) Order(args ...interface{}) *Builder
- func (b *Builder) Page(page int64, listRows int64) *Builder
- func (b *Builder) Replace(args ...interface{}) (string, []interface{})
- func (b *Builder) RightJoin(table interface{}, condition string, params ...interface{}) *Builder
- func (b *Builder) Select(args ...interface{}) *Builder
- func (b *Builder) Table(table interface{}) *Builder
- func (b *Builder) TmpTable() string
- func (b *Builder) ToSql() (string, []interface{})
- func (b *Builder) Update(data map[string]interface{}) (string, []interface{})
- func (b *Builder) Where(args ...interface{}) *Builder
- func (b *Builder) WhereBetween(field string, value ...interface{}) *Builder
- func (b *Builder) WhereExists(where func(*Builder)) *Builder
- func (b *Builder) WhereIn(field string, value ...interface{}) *Builder
- func (b *Builder) WhereNotBetween(field string, value ...interface{}) *Builder
- func (b *Builder) WhereNotExists(where func(*Builder)) *Builder
- func (b *Builder) WhereNotIn(field string, value ...interface{}) *Builder
- func (b *Builder) WhereNotNull(field string) *Builder
- func (b *Builder) WhereNull(field string) *Builder
- type Raw
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type Builder ¶
type Builder struct {
TableName string // 表名
TableAlias string // 表别名
// contains filtered or unexported fields
}
Builder 结构体用于构建 SQL 查询
func (*Builder) DuplicateKey ¶
DuplicateKey 设置重复键
func (*Builder) Joins ¶
func (b *Builder) Joins(table interface{}, condition string, joinType string, params ...interface{}) *Builder
Joins 方法用于添加连接（JOIN）到查询中
func (*Builder) Limit ¶
Limit 方法用于指定查询数量 @Description: 指定查询数量 @receiver b @param int64 offset 起始位置 @param int64 length 查询数量 @return *Builder
func (*Builder) OrWhereBetween ¶
OrWhereBetween 方法用于添加 OR BETWEEN 条件
func (*Builder) OrWhereExists ¶
OrWhereExists 方法用于添加 OR EXISTS 条件
func (*Builder) OrWhereNotBetween ¶
OrWhereNotBetween 方法用于添加 OR NOT BETWEEN 条件
func (*Builder) OrWhereNotExists ¶
OrWhereNotExists 方法用于添加 OR NOT EXISTS 条件
func (*Builder) OrWhereNotIn ¶
OrWhereNotIn 方法用于添加 OR NOT IN 条件
func (*Builder) OrWhereNotNull ¶
OrWhereNotNull 方法用于添加 OR IS NOT NULL 条件
func (*Builder) OrWhereNull ¶
OrWhereNull 方法用于添加 OR IS NULL 条件
func (*Builder) WhereBetween ¶
WhereBetween 方法用于添加 BETWEEN 条件
func (*Builder) WhereExists ¶
WhereExists 方法用于添加 EXISTS 条件
func (*Builder) WhereNotBetween ¶
WhereNotBetween 方法用于添加 NOT BETWEEN 条件
func (*Builder) WhereNotExists ¶
WhereNotExists 方法用于添加 NOT EXISTS 条件
func (*Builder) WhereNotIn ¶
WhereNotIn 方法用于添加 NOT IN 条件
func (*Builder) WhereNotNull ¶
WhereNotNull 方法用于添加 IS NOT NULL 条件
Source Files