英文:
Get postgresql array into struct with StructScan
问题
测试数据：
CREATE TABLE test (id int, data text[])
INSERT INTO test(id, data) VALUES(1, '{a,b,c}')
Go代码。首先是正常工作的代码：
func main() {
db, _ := sqlx.Open("postgres", "user=postgres dbname=test sslmode=disable")
var id int
var asSlice []string
err := db.QueryRowx(`SELECT id, data FROM test WHERE data @> ARRAY['b']`).Scan(&id, pq.Array(&asSlice))
if err != nil {
log.Fatal(err)
}
fmt.Println(id, asSlice)
}
我得到了预期的结果 1 [a b c]。
但是在这里，我手动将结果分配给变量。
现在，到不起作用的部分 - 使用StructScan
type MyStruct struct {
Id int
Data []string
}
func main() {
db, _ := sqlx.Open("postgres", "user=postgres dbname=test sslmode=disable")
var testStruct MyStruct
err := db.QueryRowx(`SELECT id, data FROM test WHERE data @> ARRAY['b']`).StructScan(&testStruct)
if err != nil {
log.Fatal(err)
}
fmt.Println(testStruct)
}
sql: Scan error on column index 1: unsupported Scan, storing driver.Value type []uint8 into type *[]string
我猜这意味着sqlx不知道PostgreSQL数组，并且不在内部使用pq.Array。
我该怎么办？也许我做错了什么？或者我应该手动应用pq.Array？如果是这样，应该怎么做？
英文:
Test data:
CREATE TABLE test (id int, data text[])
INSERT INTO test(id, data) VALUES(1, '{a,b,c}')
Go Code. First - one that is working just fine:
func main() {
db, _ := sqlx.Open("postgres", "user=postgres dbname=test sslmode=disable")
var id int
var asSlice []string
err := db.QueryRowx(`SELECT id, data FROM test WHERE data @> ARRAY['b']`).Scan(&id, pq.Array(&asSlice))
if err != nil {
log.Fatal(err)
}
fmt.Println(id, asSlice)
}
I get 1 [a b c] as expected.
But here I manually assign results to the variables
Now, to the part that is not working - using StructScan
type MyStruct struct {
Id int
Data []string
}
func main() {
db, _ := sqlx.Open("postgres", "user=postgres dbname=test sslmode=disable")
var testStruct MyStruct
err := db.QueryRowx(`SELECT id, data FROM test WHERE data @> ARRAY['b']`).StructScan(&testStruct)
if err != nil {
log.Fatal(err)
}
fmt.Println(testStruct)
}
sql: Scan error on column index 1: unsupported Scan, storing driver.Value type []uint8 into type *[]string
I guess that means that sqlx does not know about PostgreSQL arrays and does not use pq.Array internally.
What should I do about it? Maybe I am doing something wrong? Or maybe I should apply pq.Array manually? If so - how?
答案1
得分: 21
尝试使用pq.StringArray类型来表示[]string。
type MyStruct struct {
Id int
Data pq.StringArray
}
英文:
Try using pq.StringArray type for []string
type MyStruct struct {
Id int
Data pq.StringArray
}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论