英文:
Golang how can I check for errors using the sql query row
问题
我正在使用Postgres数据库,并从数据库返回一个字符串形式的Json响应,用于API。我的问题是,我不知道如何使用QueryRow方法检查错误。这是我的代码,它可以正常工作。它只是显示一个Json响应。然而,如果代码出现错误,我想使用一个自定义函数,但是QueryRow不允许我检查错误,有什么建议吗?
var result string
db.QueryRowContext(ctx, "select json_build_object('Profile', array_to_json(array_agg(t))) from" +
" (select p.id,p.fullname,z.thirtylatmin as latmin,z.thirtylatmax as latmax,z.thirtylonmin as lonmin," +
"z.thirtylonmax as lonmax,p.latitudes,p.longitudes,p.location as location" +
",p.picture,p.is_gold from profiles p join zips z on (z.city='Boston' " +
"and z.state='MA') where email=$1) t;", email).Scan(&result)
io.WriteString(w, result)
如果我将上面的代码更改为以下代码,则可以使用错误消息,但是如何将其作为字符串返回?
SqlStatement, err := db.QueryContext(ctx, "select json_build_object('Profile', array_to_json(array_agg(t))) from" +
" (select p.id,p.fullname,z.thirtylatmin as latmin,z.thirtylatmax as latmax,z.thirtylonmin as lonmin," +
"z.thirtylonmax as lonmax,p.latitudes,p.longitudes,p.location as location" +
",p.picture,p.is_gold from profiles p join zips z on (z.city='Boston' " +
"and z.state='MA') where email=$1) t;", email)
if err != nil {
log_errors("sql statement error", err.Error(), w)
}
io.WriteString(w, "如何将SqlStatement作为一个完整的字符串返回?")
上面的语句允许我记录任何错误并将其插入到数据库中,现在我需要将SqlStatement作为一个完整的字符串返回。SQL语句已经完美返回,现在我只需要以字符串格式将其传递给io.WriteString。
英文:
I am using postgres database and am returning a Json response from the database in the form of a string which is used for an API . My problem is that I do not know how to check for errors using the QueryRow Method . This right here is my code and it works correctly. That just shows a Json response . However I have a custom function that I would like to use if there is some error with the code and QueryRow does not let me check for errors any suggestions ?
var result string
db.QueryRowContext(ctx,"select json_build_object('Profile', array_to_json(array_agg(t))) from" +
" (select p.id,p.fullname,z.thirtylatmin as latmin,z.thirtylatmax as latmax,z.thirtylonmin as lonmin," +
"z.thirtylonmax as lonmax,p.latitudes,p.longitudes,p.location as location" +
",p.picture,p.is_gold from profiles p join zips z on (z.city='Boston' " +
"and z.state='MA') where email=$1) t;",email).Scan(&result)
io.writestring(w, result)
If I change the above code to this then it works with the error message however how can I return that in a String
SqlStatement,err := db.QueryContext(ctx,"select json_build_object('Profile', array_to_json(array_agg(t))) from" +
" (select p.id,p.fullname,z.thirtylatmin as latmin,z.thirtylatmax as latmax,z.thirtylonmin as lonmin," +
"z.thirtylonmax as lonmax,p.latitudes,p.longitudes,p.location as location" +
",p.picture,p.is_gold from profiles p join zips z on (z.city='Boston' " +
"and z.state='MA') where email=$1) t;",email)
if err != nil {
log_errors("sql statement error",err.Error(),w)
}
io.WriteString(w, "How can I get SqlStatement as 1 whole String ??")
The statement above lets me log any errors and insert it into the database, now how can I get SqlStatement to return as 1 whole string ? The SQL statement returns perfectly now I just need to get it into io.WriteString in a String format
答案1
得分: 1
你应该检查Row.Scan方法的返回值,就像这样:
row := db.QueryRow(
`SELECT
json_build_object('Profile', array_to_json(array_agg(t)))
FROM
(
SELECT
p.id,
p.fullname,
z.thirtylatmin as latmin,
z.thirtylatmax as latmax,
z.thirtylonmin as lonmin,
z.thirtylonmax as lonmax,
p.latitudes,
p.longitudes,
p.location as location,
p.picture,
p.is_gold
FROM
profiles p
JOIN zips z on (z.city='Boston'AND z.state='MA')
WHERE
email=$1
) t`,
email,
)
var result string
if err := Scan(&result); err != nil {
log.Fatal(err)
}
fmt.Fprint(w, result)
英文:
You should just check return value of Row.Scan method, just like this:
row := db.QueryRow(
`SELECT
json_build_object('Profile', array_to_json(array_agg(t)))
FROM
(
SELECT
p.id,
p.fullname,
z.thirtylatmin as latmin,
z.thirtylatmax as latmax,
z.thirtylonmin as lonmin,
z.thirtylonmax as lonmax,
p.latitudes,
p.longitudes,
p.location as location,
p.picture,
p.is_gold
FROM
profiles p
JOIN zips z on (z.city='Boston'AND z.state='MA')
WHERE
email=$1
) t`,
email,
)
var result string
if err := Scan(&result); err != nil {
log.Fatal(err)
}
fmt.Fprint(w, result)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论