建议结构体改为嵌套 about gorm-plus HOT 8 CLOSED

select_test.go:302: errors happened when select expect: SELECT * FROM Users WHERE id IN (1,2), got SELECT * FROM Users WHERE id IN ('1','2')

TestSelectByIdName : errors happened when select expect: SELECT * FROM Users WHERE id = 1 LIMIT 1, got SELECT * FROM Users WHERE id = 1 ORDER BY Users.id LIMIT 1

from gorm-plus.

select_test.go:302: errors happened when select expect: SELECT * FROM Users WHERE id IN (1,2), got SELECT * FROM Users WHERE id IN ('1','2')

TestSelectByIdName : errors happened when select expect: SELECT * FROM Users WHERE id = 1 LIMIT 1, got SELECT * FROM Users WHERE id = 1 ORDER BY Users.id LIMIT 1

我这边测试没有问题呀

from gorm-plus.

你把user的结构体换成我上面的，再跑测试

from gorm-plus.

select_test.go:302: errors happened when select expect: SELECT * FROM Users WHERE id IN (1,2), got SELECT * FROM Users WHERE id IN ('1','2')
TestSelectByIdName : errors happened when select expect: SELECT * FROM Users WHERE id = 1 LIMIT 1, got SELECT * FROM Users WHERE id = 1 ORDER BY Users.id LIMIT 1

这个错误跟结构体没有关系，你那边应该没有更新到最新的测试代码吧

from gorm-plus.

--- FAIL: TestQueryByIdsIn (0.00s)
select_test.go:302: errors happened when select expect: SELECT * FROM Users WHERE id IN (1,2), got SELECT * FROM Users WHERE id IN ('1','2')

func TestQueryByIdsIn(t *testing.T) {
values := url.Values{}
values["q"] = []string{"id?=1,2"}
query := gplus.BuildQueryUser
var expectSql = "SELECT * FROM Users WHERE id IN (1,2)"
sessionDb := checkSelectSql(t, expectSql)
gplus.SelectList[User](query, gplus.Db(sessionDb))
}

是因为gplus.BuildQuery的时候，没有把ID识别成int64，所有导致出来的是字符串，而识别到的就是int64值，问题就出在这里

from gorm-plus.

--- FAIL: TestQueryByIdsIn (0.00s) select_test.go:302: errors happened when select expect: SELECT * FROM Users WHERE id IN (1,2), got SELECT * FROM Users WHERE id IN ('1','2')

func TestQueryByIdsIn(t *testing.T) { values := url.Values{} values["q"] = []string{"id?=1,2"} query := gplus.BuildQueryUser var expectSql = "SELECT * FROM Users WHERE id IN (1,2)" sessionDb := checkSelectSql(t, expectSql) gplus.SelectList[User](query, gplus.Db(sessionDb)) }

是因为gplus.BuildQuery的时候，没有把ID识别成int64，所有导致出来的是字符串，而识别到的就是int64值，问题就出在这里

哦哦，确实嵌套会有问题，主要在获取类型那块，得递归缓存好类型信息

from gorm-plus.

--- FAIL: TestQueryByIdsIn (0.00s) select_test.go:302: errors happened when select expect: SELECT * FROM Users WHERE id IN (1,2), got SELECT * FROM Users WHERE id IN ('1','2')
func TestQueryByIdsIn(t *testing.T) { values := url.Values{} values["q"] = []string{"id?=1,2"} query := gplus.BuildQueryUser var expectSql = "SELECT * FROM Users WHERE id IN (1,2)" sessionDb := checkSelectSql(t, expectSql) gplus.SelectList[User](query, gplus.Db(sessionDb)) }
是因为gplus.BuildQuery的时候，没有把ID识别成int64，所有导致出来的是字符串，而识别到的就是int64值，问题就出在这里

哦哦，确实嵌套会有问题，主要在获取类型那块，得递归缓存好类型信息

看这里 #63

from gorm-plus.

问题已经解决

from gorm-plus.