{"action":"created","issue":{"url":"https://api.github.com/repos/MagicStack/asyncpg/issues/264","repository_url":"https://api.github.com/repos/MagicStack/asyncpg","labels_url":"https://api.github.com/repos/MagicStack/asyncpg/issues/264/labels{/name}","comments_url":"https://api.github.com/repos/MagicStack/asyncpg/issues/264/comments","events_url":"https://api.github.com/repos/MagicStack/asyncpg/issues/264/events","html_url":"https://github.com/MagicStack/asyncpg/issues/264","id":297542868,"number":264,"title":"How to find out query result is success or not?","user":{"login":"python-programmer","id":8934969,"avatar_url":"https://avatars0.githubusercontent.com/u/8934969?v=4","gravatar_id":"","url":"https://api.github.com/users/python-programmer","html_url":"https://github.com/python-programmer","followers_url":"https://api.github.com/users/python-programmer/followers","following_url":"https://api.github.com/users/python-programmer/following{/other_user}","gists_url":"https://api.github.com/users/python-programmer/gists{/gist_id}","starred_url":"https://api.github.com/users/python-programmer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/python-programmer/subscriptions","organizations_url":"https://api.github.com/users/python-programmer/orgs","repos_url":"https://api.github.com/users/python-programmer/repos","events_url":"https://api.github.com/users/python-programmer/events{/privacy}","received_events_url":"https://api.github.com/users/python-programmer/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-15T18:05:50Z","updated_at":"2018-02-16T14:23:45Z","closed_at":null,"author_association":"NONE","body":"first of all, Thank you for your quick reply. \r\n\r\nI have a product table like this:\r\n```\r\nProduct\r\n    id\r\n    name\r\n    price\r\n```\r\n\r\ni want to update my product name\r\n\r\n```\r\nresult = await connection.execute('''\r\n                UPDATE products SET name = $1\r\n            ''', 'asyncpg')\r\n```\r\n\r\nand result string contains two string\r\n```\r\nfailed => UPDATE 0\r\nsuccess => UPDATE 1\r\n```\r\n\r\ncheck result with this strings is a good idea or you have better solution?"},"comment":{"url":"https://api.github.com/repos/MagicStack/asyncpg/issues/comments/366248529","html_url":"https://github.com/MagicStack/asyncpg/issues/264#issuecomment-366248529","issue_url":"https://api.github.com/repos/MagicStack/asyncpg/issues/264","id":366248529,"user":{"login":"egalpin","id":7582748,"avatar_url":"https://avatars0.githubusercontent.com/u/7582748?v=4","gravatar_id":"","url":"https://api.github.com/users/egalpin","html_url":"https://github.com/egalpin","followers_url":"https://api.github.com/users/egalpin/followers","following_url":"https://api.github.com/users/egalpin/following{/other_user}","gists_url":"https://api.github.com/users/egalpin/gists{/gist_id}","starred_url":"https://api.github.com/users/egalpin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/egalpin/subscriptions","organizations_url":"https://api.github.com/users/egalpin/orgs","repos_url":"https://api.github.com/users/egalpin/repos","events_url":"https://api.github.com/users/egalpin/events{/privacy}","received_events_url":"https://api.github.com/users/egalpin/received_events","type":"User","site_admin":false},"created_at":"2018-02-16T14:23:45Z","updated_at":"2018-02-16T14:23:45Z","author_association":"NONE","body":"I'm not sure if no error implies success (that might be the case), but you could also add a `RETURNING` clause in your `UPDATE` statement that would only return values in the case of successful update?"}}
{"actor":{"display_login":"egalpin"}}