{"action":"created","issue":{"url":"https://api.github.com/repos/laravel/ideas/issues/1297","repository_url":"https://api.github.com/repos/laravel/ideas","labels_url":"https://api.github.com/repos/laravel/ideas/issues/1297/labels{/name}","comments_url":"https://api.github.com/repos/laravel/ideas/issues/1297/comments","events_url":"https://api.github.com/repos/laravel/ideas/issues/1297/events","html_url":"https://github.com/laravel/ideas/issues/1297","id":355098596,"node_id":"MDU6SXNzdWUzNTUwOTg1OTY=","number":1297,"title":"[Proposal] Get affected rows value at QueryExecuted event","user":{"login":"ritmas","id":3692760,"node_id":"MDQ6VXNlcjM2OTI3NjA=","avatar_url":"https://avatars0.githubusercontent.com/u/3692760?v=4","gravatar_id":"","url":"https://api.github.com/users/ritmas","html_url":"https://github.com/ritmas","followers_url":"https://api.github.com/users/ritmas/followers","following_url":"https://api.github.com/users/ritmas/following{/other_user}","gists_url":"https://api.github.com/users/ritmas/gists{/gist_id}","starred_url":"https://api.github.com/users/ritmas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ritmas/subscriptions","organizations_url":"https://api.github.com/users/ritmas/orgs","repos_url":"https://api.github.com/users/ritmas/repos","events_url":"https://api.github.com/users/ritmas/events{/privacy}","received_events_url":"https://api.github.com/users/ritmas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-08-29T10:33:41Z","updated_at":"2018-08-29T18:39:55Z","closed_at":null,"author_association":"NONE","body":"Currently, `Illuminate\\Database\\Events\\QueryExecuted` holds executed SQL query and the time it took to run. While logging the queries it's quite handy to know how much rows it has affected:\r\n```\r\nuse Illuminate\\Support\\Facades\\DB;\r\nuse Illuminate\\Database\\Events\\QueryExecuted;\r\n\r\nDB::listen(function(QueryExecuted $query) {\r\n    /**\r\n     * $query->sql      The SQL query that was executed.\r\n     * $query->time     The number of milliseconds it took to execute the query.\r\n     * $query->count    The quantity of rows query has affected.\r\n     */\r\n});\r\n```"},"comment":{"url":"https://api.github.com/repos/laravel/ideas/issues/comments/417060994","html_url":"https://github.com/laravel/ideas/issues/1297#issuecomment-417060994","issue_url":"https://api.github.com/repos/laravel/ideas/issues/1297","id":417060994,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNzA2MDk5NA==","user":{"login":"mfn","id":87493,"node_id":"MDQ6VXNlcjg3NDkz","avatar_url":"https://avatars0.githubusercontent.com/u/87493?v=4","gravatar_id":"","url":"https://api.github.com/users/mfn","html_url":"https://github.com/mfn","followers_url":"https://api.github.com/users/mfn/followers","following_url":"https://api.github.com/users/mfn/following{/other_user}","gists_url":"https://api.github.com/users/mfn/gists{/gist_id}","starred_url":"https://api.github.com/users/mfn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mfn/subscriptions","organizations_url":"https://api.github.com/users/mfn/orgs","repos_url":"https://api.github.com/users/mfn/repos","events_url":"https://api.github.com/users/mfn/events{/privacy}","received_events_url":"https://api.github.com/users/mfn/received_events","type":"User","site_admin":false},"created_at":"2018-08-29T18:39:55Z","updated_at":"2018-08-29T18:39:55Z","author_association":"NONE","body":"> but it seems there is such ability on each database currently supported by Laravel 5.6:\r\n\r\nTo me knowledge, Laravels SQL driver *exclusively* uses PDO, no? So this would rule out  PostgreSQL/SQlite for it."}}
{"actor":{"display_login":"mfn"}}