UPDATE query returns none #271

abhijitgujar86 · 2020-12-07T11:16:32Z

I am using raw SQL query to update the table

rows = await app.db.execute( query= query )

the rows in none

1 ) How will i know if the query is successful or not
2) how will i know that how many rows have been updated ?

henriqueblang · 2021-02-02T16:47:14Z

Not sure if this is the best approach, but maybe you could add a RETURNING clause in your SQL query and call a fetch variation instead of execute.
If your query is unsuccessful, your result will be None; else, you'll be able to find out how many rows were affected.

encode / databases

UPDATE query returns none #271

UPDATE query returns none #271

abhijitgujar86 commented Dec 7, 2020 •

edited

henriqueblang commented Feb 2, 2021

encode / databases

UPDATE query returns none #271

UPDATE query returns none #271

Comments

abhijitgujar86 commented Dec 7, 2020 • edited

henriqueblang commented Feb 2, 2021

abhijitgujar86 commented Dec 7, 2020 •

edited