gorm-plus

gorm-plus copied to clipboard

关于join的查询，目前我没有找到该功能

1

我想使用gormplus进行关联表查询，但是似乎未找到该功能，后续还有计划添加和维护么

xueqizhang121

增加apply方法，用于拼接自定义sql字符串

4

需求案例场景：子查询、自定义sql片段 伪代码： ```go var expectSql = "SELECT * FROM `Users` WHERE username = 'afumu' OR age = 20" sessionDb := checkSelectSql(t, expectSql) query, u := gplus.NewQuery[User]() query.Eq(&u.Username, "afumu").Or().Eq(&u.Age, 20).Apply("AND id...

ColorDreams

有异常panic

3

getColumnNameMap

icetech233

support multiple gorm

4

We need to connect to multiple databases in our project, but gplus's gorm as a global variable. can gplus support multi gorm??

philhuan

关于连接池的问题

1

 我这边用压测工具试了下。发现时间一长就出现 2024/02/03 12:14:52 C:/Users/lg/go/pkg/mod/github.com/acmestack/[email protected]/gplus/dao.go:172 dial tcp 127.0.0.1:3306: connectex: Only one usage of each socket address (protocol/network address/port) is normally permitted. 连接不够了。这个连接池的释放管理是不是有问题。下面查询语句一直都慢查询了。感觉似乎就是有空余连接没有释放卡住了。 还有另外一个是 2024/02/03 12:14:52 C:/Users/lg/go/pkg/mod/github.com/acmestack/[email protected]/gplus/dao.go:172 SLOW SQL >= 200ms...

MrYZhou

提供一种基于流式分页的分页函数

1

在一些不需要跳页的场景下使用，相比于offset具有更好的性能。 伪代码如下： ```go type Comparable interface { ~int | ~int8 | ~int16 | ~int32 | ~int64 | ~uint | ~uint8 | ~uint16 | ~uint32 | ~uint64 | ~float32 | ~float64...

ColorDreams

当子条件的查询表达式为空时，构建sql拼接了多余的LeftBracket和RightBracket

6

bug案例复现： ```go func TestSelectListOr(t *testing.T) { var expectSql = "SELECT * FROM `Users` WHERE username = 'afumu' OR age = 20" sessionDb := checkSelectSql(t, expectSql) query, u := gplus.NewQuery[User]() query.Eq(&u.Username,...

ColorDreams

feat: add custom sql segment conditional support acmestack#76,fix #75 supplementary submit

2

add custom sql segment conditional support #76 fix bug: acmestack#75 supplementary submit

ColorDreams

能不能通过接口来做的更通用一些？做成Repository层

1

**Background & X Problem** A clear and concise description of what the problem is. Ex. I'm always frustrated when [...] **Proposal and Expectation** A clear and concise description of what...

henrion-y

伪代码如下： ```go // 变量 user 为入参 query, u := gplus.NewQuery[User]() query.Eq(&u.Password, "12345678").Or(func(q *gplus.QueryCond[User]) { q.EqCond(user.Id > 0,&u.Id, user.Id). Or().EqCond(len(user.Account) > 0, &u.Account, user.Account). Or().EqCond(len(user.Email) > 0, &u.Email, user.Email). Or().EqCond(len(user.Phone) >...

ColorDreams