"It will also return the number of affected rows." - update method

[GabrielBellard]

In the github doc it is written that the update "[...] will also return the number of affected rows." but looking at the code, it does not seem the case.

Is there a simple way to retrieve it without using the psycopg2 cursor.execute() myself ?

[nackjicholson]

You're right, I think that is a documentation mistake. Sorry about that.

I don't think there is a simple way to do what you want without getting the cursor. I did introduce a way to get the underlying database cursor for a query though.

I can't guarantee something like this will work, but I think it might. You just suffix _cursor after your query name. Best of luck, thanks for using the project. Sorry about the issue.

-- name: subscribe_user
update user set is_subscribed = true where name = :name

with queries.subscribe_user_cursor("will") as cur:
    print(cur.rowcount)