英文:
Returning array like json with Fiber, Golang
问题
我在我的数据库中有一个包含token、user_id和last_seen列的表格。
任务是在我的应用程序收到GET请求时将它们全部发送出去。
Fiber, Golang:
type sessionsInfo struct {
token string
user_id int
last_seen string
}
app.Get("/testA", func(c *fiber.Ctx) error {
logMsg("GET /testA")
var sessions sessionsInfo
execQuery := `select * from sessions`
rows, err := db.Query(execQuery)
if err != nil {
fmt.Println(err)
return c.SendStatus(418)
}
var sessionsArray []sessionsInfo
for rows.Next(){
rows.Scan(
&sessions.token,
&sessions.user_id,
&sessions.last_seen,
)
sessionsArray = append(sessionsArray, sessions)
}
defer rows.Close()
fmt.Println(sessionsArray)
c.JSON(sessionsArray)
return c.SendStatus(200)
})
奇怪的是,我在控制台中看到了正确的数组,完全匹配我的数据库中的数据。
[2021-11-04 15:50:31] GET /testA
[{be0e6163-ce2c-4ac3-5349-ff3b34a51c37 1 2021-10-21T17:50:42.308751Z}
{6c4f21f1-dc00-4975-6fe2-c69d14328099 2 2021-10-21T17:51:27.963031Z}
{824012ec-07d1-4732-63a1-7b1c99261c6d 3 2021-10-21T21:29:23.95517Z}
{a13b67d8-370c-49d2-72da-21fd02081711 4 2021-10-22T07:45:43.539265Z}
{ebb8fdfc-923b-4d8d-6988-781c71c17dbe 5 2021-10-26T08:48:50.12082Z}
{212909aa-70c9-4f50-553c-0f503e65fa7b 6 2021-10-26T08:49:56.880621Z}
{132fbbd0-5c81-4278-4e39-ed933872d58e 7 2021-10-26T10:07:26.221177Z}
{753f278c-9a9f-4bd5-5a9c-dc4a14b6bc81 7 2021-10-26T11:11:34.955218Z}
{c32dea1d-230c-4caa-50a8-0cb2bd97d562 7 2021-10-26T11:11:38.723956Z}
{ea2a87e5-6140-40a2-6641-69e85c0fef34 7 2021-10-26T11:11:39.417712Z}
{4fe4958a-ebfb-4c5e-61b0-5c6e7e9666b4 7 2021-10-26T11:11:40.018127Z}
{feb7c3f0-26b0-47f9-63e1-d261e3093f30 7 2021-10-26T11:17:28.634217Z}
{2a484f33-9b61-4ef1-7987-78aa07f6f6ff 7 2021-10-26T11:17:47.73872Z}
{c9dbfe03-1435-4cae-67f9-1c0a010c14b6 7 2021-10-26T11:18:02.7325Z}
{c866ca0c-0e16-486e-79cf-0a4b1b30c6ef 7 2021-10-26T11:18:03.160044Z}
{aafc6dfc-0b91-41fa-6ebc-29053c097570 7 2021-10-26T11:18:03.680851Z}
{d3325e13-7ec3-478b-6eb8-3b609440b0c8 8 2021-10-29T18:49:21.366545Z}
{ef473f2e-66a2-4518-6e7e-7b0a21544444 7 2021-10-29T19:01:13.583646Z}
{3aa6644b-815c-456d-5601-0ec5bb84c532 9 2021-10-29T19:03:53.866348Z}
{6b8ecbea-dccf-4b90-4dd1-e5ca6f589560 10 2021-10-29T19:04:46.824083Z}
{a39567bc-4001-4e50-45ff-638c08d4cb09 10 2021-10-29T19:12:30.415509Z}
{e9a80c87-9d4f-4582-413f-f56210d313fd 10 2021-10-29T19:13:02.469866Z}
{d9d15614-aeb1-4c74-75b2-b9f3f6fed9d2 11 2021-10-29T20:36:18.883786Z}
{6398683b-94fa-4a7c-53a3-849084565ab7 11 2021-10-29T20:36:48.724322Z}
{bed2a9fe-7288-41be-5786-0aa3710a4e22 11 2021-10-29T20:37:23.696741Z}]
但是出于某种原因,当我查看响应的主体时,我看到了一个包含25个空子JSON(我不知道如何正确命名它,哈哈),像这样:
[
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{}
]
与应该有的数量相同,但是为空的。
结果应该是这样的:
[
{
"token": "be0e6163-ce2c-4ac3-5349-ff3b34a51c37",
"id": "1",
"last_seen": "2021-10-21T17:50:42.308751Z"
},
{
"token": "6c4f21f1-dc00-4975-6fe2-c69d14328099",
"id": "2",
"last_seen": "2021-10-21T17:51:27.963031Z"
}
...
...
...
]
我该如何修复这个问题?我做错了什么?
英文:
I have a table with columns token, user_id and last_seen in my databse
The task is to send all of them with my app when it gets a get request
Fiber, Golang:
type sessionsInfo struct {
token string
user_id int
last_seen string
}
app.Get("/testA", func(c *fiber.Ctx) error {
logMsg("GET /testA")
var sessions sessionsInfo
execQuery := `select * from sessions`
rows, err := db.Query(execQuery)
if err != nil {
fmt.Println(err)
return c.SendStatus(418)
}
var sessionsArray []sessionsInfo
for rows.Next(){
rows.Scan(
&sessions.token,
&sessions.user_id,
&sessions.last_seen,
)
sessionsArray = append(sessionsArray, sessions)
}
defer rows.Close()
fmt.Println(sessionsArray)
c.JSON(sessionsArray)
return c.SendStatus(200)
})
The strange thing is that i see correct array in console, matching 100% my data in DB
[2021-11-04 15:50:31] GET /testA
[{be0e6163-ce2c-4ac3-5349-ff3b34a51c37 1 2021-10-21T17:50:42.308751Z}
{6c4f21f1-dc00-4975-6fe2-c69d14328099 2 2021-10-21T17:51:27.963031Z}
{824012ec-07d1-4732-63a1-7b1c99261c6d 3 2021-10-21T21:29:23.95517Z}
{a13b67d8-370c-49d2-72da-21fd02081711 4 2021-10-22T07:45:43.539265Z}
{ebb8fdfc-923b-4d8d-6988-781c71c17dbe 5 2021-10-26T08:48:50.12082Z}
{212909aa-70c9-4f50-553c-0f503e65fa7b 6 2021-10-26T08:49:56.880621Z}
{132fbbd0-5c81-4278-4e39-ed933872d58e 7 2021-10-26T10:07:26.221177Z}
{753f278c-9a9f-4bd5-5a9c-dc4a14b6bc81 7 2021-10-26T11:11:34.955218Z}
{c32dea1d-230c-4caa-50a8-0cb2bd97d562 7 2021-10-26T11:11:38.723956Z}
{ea2a87e5-6140-40a2-6641-69e85c0fef34 7 2021-10-26T11:11:39.417712Z}
{4fe4958a-ebfb-4c5e-61b0-5c6e7e9666b4 7 2021-10-26T11:11:40.018127Z}
{feb7c3f0-26b0-47f9-63e1-d261e3093f30 7 2021-10-26T11:17:28.634217Z}
{2a484f33-9b61-4ef1-7987-78aa07f6f6ff 7 2021-10-26T11:17:47.73872Z}
{c9dbfe03-1435-4cae-67f9-1c0a010c14b6 7 2021-10-26T11:18:02.7325Z}
{c866ca0c-0e16-486e-79cf-0a4b1b30c6ef 7 2021-10-26T11:18:03.160044Z}
{aafc6dfc-0b91-41fa-6ebc-29053c097570 7 2021-10-26T11:18:03.680851Z}
{d3325e13-7ec3-478b-6eb8-3b609440b0c8 8 2021-10-29T18:49:21.366545Z}
{ef473f2e-66a2-4518-6e7e-7b0a21544444 7 2021-10-29T19:01:13.583646Z}
{3aa6644b-815c-456d-5601-0ec5bb84c532 9 2021-10-29T19:03:53.866348Z}
{6b8ecbea-dccf-4b90-4dd1-e5ca6f589560 10 2021-10-29T19:04:46.824083Z}
{a39567bc-4001-4e50-45ff-638c08d4cb09 10 2021-10-29T19:12:30.415509Z}
{e9a80c87-9d4f-4582-413f-f56210d313fd 10 2021-10-29T19:13:02.469866Z}
{d9d15614-aeb1-4c74-75b2-b9f3f6fed9d2 11 2021-10-29T20:36:18.883786Z}
{6398683b-94fa-4a7c-53a3-849084565ab7 11 2021-10-29T20:36:48.724322Z}
{bed2a9fe-7288-41be-5786-0aa3710a4e22 11 2021-10-29T20:37:23.696741Z}]
but with some reason when i look at answer's body i see json that has 25 empty sub-jsons (i dunno how to name it correctly, lmao), like this
[
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{}
]
The same count as it should be, but empty.
The result should be something like this
[
{
"token": "be0e6163-ce2c-4ac3-5349-ff3b34a51c37",
"id": "1",
"last_seen": "2021-10-21T17:50:42.308751Z"
},
{
"token": "6c4f21f1-dc00-4975-6fe2-c69d14328099",
"id": "2",
"last_seen": "2021-10-21T17:51:27.963031Z"
}
...
...
...
]
How can i fix this? What am i doing wrong?
答案1
得分: 3
导出类型:
type sessionsInfo struct {
token string
user_id int
last_seen string
}
转换为:
type SessionsInfo struct {
Token string `json:"token"`
User_id int `json:"user_id"`
Last_seen string `json:"last_seen"`
}
英文:
Export the types:
type sessionsInfo struct {
token string
user_id int
last_seen string
}
To:
type SessionsInfo struct {
Token string `json:"token"`
User_id int `json:"user_id"`
Last_seen string `json:"last_seen"`
}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论