Documentation
¶
Index ¶
- func Add[T any](db *gorm.DB, entity *T) (*T, error)
- func CheckExecError(r sql.Result, err error) error
- func Delete[T any](db *gorm.DB, id string) error
- func DeleteBy[T any](db *gorm.DB, whereColumn string, whereValue any) error
- func DeleteByWheres[T any](db *gorm.DB, where map[string]any) error
- func ExecTransaction(db *gorm.DB, fn func(tx *gorm.DB) error) error
- func Find[T any](db *gorm.DB, where map[string]any, orderBy string) ([]*T, error)
- func FindIn[T any](db *gorm.DB, whereColumn string, whereValue []any) ([]*T, error)
- func Get[T any](db *gorm.DB, id any) (*T, error)
- func GetBy[T any](db *gorm.DB, whereColumn string, whereValue any) (*T, error)
- func GetByWheres[T any](db *gorm.DB, where map[string]any, orderBy string) (*T, error)
- func NewGormDB(cfg *DBConfig) (*gorm.DB, error)
- func NewMysqlClient(host string, port int, user string, pwd string, db string) *sqlx.DB
- func PageFind[T any](db *gorm.DB, page int, pageSize int, startTime int64, endTime int64, ...) ([]*T, int64, error)
- func Update[T any](db *gorm.DB, entity *T) (*T, error)
- func UpdateColumn[T any](db *gorm.DB, columnName string, columnValue any, whereColumn string, ...) error
- func UpdateColumnByWheres[T any](db *gorm.DB, columnName string, columnValue any, where map[string]any) error
- func UpdateColumns[T any](db *gorm.DB, column map[string]any, whereColumn string, whereValue any) error
- func UpdateColumnsByWheres[T any](db *gorm.DB, column map[string]any, where map[string]any) error
- type DBConfig
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func DeleteByWheres ¶ added in v0.0.15
func ExecTransaction ¶
ExecTransaction 通用事务执行函数 参数:db 数据库连接;fn 业务逻辑函数(传入事务tx,执行SQL) 返回:执行错误,nil=成功提交,非nil=自动回滚
func Find ¶ added in v0.0.15
Find 搜索 where 查询条件,key=column,value=value,没有就传nil orderBy ASC=升序, DESC=降序, 空值=不排序
func GetByWheres ¶ added in v0.0.15
GetByWheres orderBy ASC=升序, DESC=降序, 空值=不排序
func NewMysqlClient ¶
func PageFind ¶ added in v0.0.15
func PageFind[T any](db *gorm.DB, page int, pageSize int, startTime int64, endTime int64, where map[string]any, like map[string]string, not map[string]any, orderBy string) ([]*T, int64, error)
PageFind 分页搜索 keyword 关键词,模糊搜索, page从1开始,当page>0&&pageSize>0才会分页 startTime 开始时间戳,单位秒 endtTime 结束时间戳,单位秒 order 空值=不排序,ASC=升序,DESC=降序 where 查询条件,key=value,没有就传nil like like查询, key like %value% not 不等于, key != value orderBy ASC=升序, DESC=降序, 空值=不排序
func UpdateColumn ¶
func UpdateColumn[T any](db *gorm.DB, columnName string, columnValue any, whereColumn string, whereValue any) error
UpdateColumn 更新一条字段值 columnName=字段名,columnValue=字段值 whereColumn=条件字段名名,whereValue=条件字段值 示例:UpdateColumn(db, "name", "cdj", "id",2) 表示把id=2的记录中的name的值改为cdj
func UpdateColumnByWheres ¶ added in v0.0.15
func UpdateColumnByWheres[T any](db *gorm.DB, columnName string, columnValue any, where map[string]any) error
UpdateColumnByWheres 根据一条或多条条件更新一条字段值 columnName=字段名,columnValue=字段值 where 条件
func UpdateColumns ¶
func UpdateColumns[T any](db *gorm.DB, column map[string]any, whereColumn string, whereValue any) error
UpdateColumns 更新多条字段值 column字段key和value,key=字段名,value=字段值 whereColumn=条件字段名名,whereValue=条件字段值 示例:UpdateColumns(db, map[string]any{"name":"cdj"}, "id",2) 表示把id=2的记录中的name的值改为cdj
Types ¶
type DBConfig ¶
type DBConfig struct {
Host string // 地址
Port string // 端口
User string // 用户名
Password string // 密码
DBName string // 数据库名
MaxIdleConns int // 最大空闲连接,可选
MaxOpenConns int // 最大连接数,可选
ConnMaxLifetime time.Duration // 连接最长存活时间,可选
LogLevel logger.LogLevel // GORM 日志级别,可选
DbType string // 数据库类型,可选,示例:mysql,postgres等
}
DBConfig 数据库配置结构体