xdb

package
v0.0.18 Latest Latest
Warning

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

Go to latest
Published: Nov 12, 2026 License: MIT Imports: 11 Imported by: 0

README

数据库访问封装

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Add

func Add[T any](db *gorm.DB, entity *T) (*T, error)

func CheckExecError

func CheckExecError(r sql.Result, err error) error

func Delete

func Delete[T any](db *gorm.DB, id string) error

func DeleteBy

func DeleteBy[T any](db *gorm.DB, whereColumn string, whereValue any) error

func DeleteByWheres added in v0.0.15

func DeleteByWheres[T any](db *gorm.DB, where map[string]any) error

func ExecTransaction

func ExecTransaction(db *gorm.DB, fn func(tx *gorm.DB) error) error

ExecTransaction 通用事务执行函数 参数:db 数据库连接;fn 业务逻辑函数(传入事务tx,执行SQL) 返回:执行错误,nil=成功提交,非nil=自动回滚

func Find added in v0.0.15

func Find[T any](db *gorm.DB, where map[string]any, orderBy string) ([]*T, error)

Find 搜索 where 查询条件,key=column,value=value,没有就传nil orderBy ASC=升序, DESC=降序, 空值=不排序

func FindIn

func FindIn[T any](db *gorm.DB, whereColumn string, whereValue []any) ([]*T, error)

func Get

func Get[T any](db *gorm.DB, id any) (*T, error)

func GetBy

func GetBy[T any](db *gorm.DB, whereColumn string, whereValue any) (*T, error)

func GetByWheres added in v0.0.15

func GetByWheres[T any](db *gorm.DB, where map[string]any, orderBy string) (*T, error)

GetByWheres orderBy ASC=升序, DESC=降序, 空值=不排序

func NewGormDB

func NewGormDB(cfg *DBConfig) (*gorm.DB, error)

NewGormDB 创建 MySQL 连接

func NewMysqlClient

func NewMysqlClient(host string, port int, user string, pwd string, db string) *sqlx.DB

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 Update

func Update[T any](db *gorm.DB, entity *T) (*T, error)

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

func UpdateColumnsByWheres added in v0.0.15

func UpdateColumnsByWheres[T any](db *gorm.DB, column map[string]any, where map[string]any) error

UpdateColumnsByWheres 更新多条字段值 column字段key和value,key=字段名,value=字段值 where 条件

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 数据库配置结构体

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
⌂ 换网址