{"action":"closed","number":57,"pull_request":{"url":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls/57","id":191201979,"html_url":"https://github.com/AT-PHPIntership/food-drink/pull/57","diff_url":"https://github.com/AT-PHPIntership/food-drink/pull/57.diff","patch_url":"https://github.com/AT-PHPIntership/food-drink/pull/57.patch","issue_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues/57","number":57,"state":"closed","locked":false,"title":"delete post","user":{"login":"at-dungle","id":37789784,"avatar_url":"https://avatars2.githubusercontent.com/u/37789784?v=4","gravatar_id":"","url":"https://api.github.com/users/at-dungle","html_url":"https://github.com/at-dungle","followers_url":"https://api.github.com/users/at-dungle/followers","following_url":"https://api.github.com/users/at-dungle/following{/other_user}","gists_url":"https://api.github.com/users/at-dungle/gists{/gist_id}","starred_url":"https://api.github.com/users/at-dungle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/at-dungle/subscriptions","organizations_url":"https://api.github.com/users/at-dungle/orgs","repos_url":"https://api.github.com/users/at-dungle/repos","events_url":"https://api.github.com/users/at-dungle/events{/privacy}","received_events_url":"https://api.github.com/users/at-dungle/received_events","type":"User","site_admin":false},"body":"## Description\r\nDelete Post\r\n## Reference Requirements\r\n- Task ID: #57 \r\n\r\n## Reference Isuees\r\n#{issue_id}\r\n\r\n NO\r\n\r\n## Impacted Areas in Application\r\nList general components of the application that this PR will affect:\r\n\r\n-\r\n\r\n## SQL query and `explain`\r\nList of all queries and attach the result of each explaining query (in text, screenshot...)\r\n\r\n```\r\nmysql> explain select count(*) as aggregate from `posts` \\G;\r\n*************************** 1. row ***************************\r\n           id: 1\r\n  select_type: SIMPLE\r\n        table: posts\r\n   partitions: NULL\r\n         type: index\r\npossible_keys: NULL\r\n          key: posts_user_id_foreign\r\n      key_len: 4\r\n          ref: NULL\r\n         rows: 13\r\n     filtered: 100.00\r\n        Extra: Using index\r\n1 row in set, 1 warning (0.00 sec)\r\n\r\nERROR: \r\nNo query specified\r\n```\r\n```\r\nmysql> explain select * from `posts` limit 10 offset 0 \\G;\r\n*************************** 1. row ***************************\r\n           id: 1\r\n  select_type: SIMPLE\r\n        table: posts\r\n   partitions: NULL\r\n         type: ALL\r\npossible_keys: NULL\r\n          key: NULL\r\n      key_len: NULL\r\n          ref: NULL\r\n         rows: 13\r\n     filtered: 100.00\r\n        Extra: NULL\r\n1 row in set, 1 warning (0.00 sec)\r\n\r\nERROR: \r\nNo query specified\r\n\r\n```","created_at":"2018-05-29T16:24:14Z","updated_at":"2018-05-30T04:19:31Z","closed_at":"2018-05-30T04:19:31Z","merged_at":"2018-05-30T04:19:31Z","merge_commit_sha":"2179b395b3d57bd081b092bffd6441c89bc7ca92","assignee":{"login":"at-vietpham","id":16131595,"avatar_url":"https://avatars2.githubusercontent.com/u/16131595?v=4","gravatar_id":"","url":"https://api.github.com/users/at-vietpham","html_url":"https://github.com/at-vietpham","followers_url":"https://api.github.com/users/at-vietpham/followers","following_url":"https://api.github.com/users/at-vietpham/following{/other_user}","gists_url":"https://api.github.com/users/at-vietpham/gists{/gist_id}","starred_url":"https://api.github.com/users/at-vietpham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/at-vietpham/subscriptions","organizations_url":"https://api.github.com/users/at-vietpham/orgs","repos_url":"https://api.github.com/users/at-vietpham/repos","events_url":"https://api.github.com/users/at-vietpham/events{/privacy}","received_events_url":"https://api.github.com/users/at-vietpham/received_events","type":"User","site_admin":false},"assignees":[{"login":"at-vietpham","id":16131595,"avatar_url":"https://avatars2.githubusercontent.com/u/16131595?v=4","gravatar_id":"","url":"https://api.github.com/users/at-vietpham","html_url":"https://github.com/at-vietpham","followers_url":"https://api.github.com/users/at-vietpham/followers","following_url":"https://api.github.com/users/at-vietpham/following{/other_user}","gists_url":"https://api.github.com/users/at-vietpham/gists{/gist_id}","starred_url":"https://api.github.com/users/at-vietpham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/at-vietpham/subscriptions","organizations_url":"https://api.github.com/users/at-vietpham/orgs","repos_url":"https://api.github.com/users/at-vietpham/repos","events_url":"https://api.github.com/users/at-vietpham/events{/privacy}","received_events_url":"https://api.github.com/users/at-vietpham/received_events","type":"User","site_admin":false}],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":929671489,"url":"https://api.github.com/repos/AT-PHPIntership/food-drink/labels/in-review","name":"in-review","color":"c5def5","default":false},{"id":929673870,"url":"https://api.github.com/repos/AT-PHPIntership/food-drink/labels/task","name":"task","color":"1d76db","default":false},{"id":946556125,"url":"https://api.github.com/repos/AT-PHPIntership/food-drink/labels/week%203","name":"week 3","color":"d4c5f9","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls/57/commits","review_comments_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls/57/comments","review_comment_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls/comments{/number}","comments_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues/57/comments","statuses_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/statuses/9f3e8a381dabf014fb11dde57b5880c8ac4b909d","head":{"label":"AT-PHPIntership:post-delete","ref":"post-delete","sha":"9f3e8a381dabf014fb11dde57b5880c8ac4b909d","user":{"login":"AT-PHPIntership","id":17865237,"avatar_url":"https://avatars1.githubusercontent.com/u/17865237?v=4","gravatar_id":"","url":"https://api.github.com/users/AT-PHPIntership","html_url":"https://github.com/AT-PHPIntership","followers_url":"https://api.github.com/users/AT-PHPIntership/followers","following_url":"https://api.github.com/users/AT-PHPIntership/following{/other_user}","gists_url":"https://api.github.com/users/AT-PHPIntership/gists{/gist_id}","starred_url":"https://api.github.com/users/AT-PHPIntership/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AT-PHPIntership/subscriptions","organizations_url":"https://api.github.com/users/AT-PHPIntership/orgs","repos_url":"https://api.github.com/users/AT-PHPIntership/repos","events_url":"https://api.github.com/users/AT-PHPIntership/events{/privacy}","received_events_url":"https://api.github.com/users/AT-PHPIntership/received_events","type":"Organization","site_admin":false},"repo":{"id":132847163,"name":"food-drink","full_name":"AT-PHPIntership/food-drink","owner":{"login":"AT-PHPIntership","id":17865237,"avatar_url":"https://avatars1.githubusercontent.com/u/17865237?v=4","gravatar_id":"","url":"https://api.github.com/users/AT-PHPIntership","html_url":"https://github.com/AT-PHPIntership","followers_url":"https://api.github.com/users/AT-PHPIntership/followers","following_url":"https://api.github.com/users/AT-PHPIntership/following{/other_user}","gists_url":"https://api.github.com/users/AT-PHPIntership/gists{/gist_id}","starred_url":"https://api.github.com/users/AT-PHPIntership/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AT-PHPIntership/subscriptions","organizations_url":"https://api.github.com/users/AT-PHPIntership/orgs","repos_url":"https://api.github.com/users/AT-PHPIntership/repos","events_url":"https://api.github.com/users/AT-PHPIntership/events{/privacy}","received_events_url":"https://api.github.com/users/AT-PHPIntership/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/AT-PHPIntership/food-drink","description":null,"fork":false,"url":"https://api.github.com/repos/AT-PHPIntership/food-drink","forks_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/forks","keys_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/keys{/key_id}","collaborators_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/teams","hooks_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/hooks","issue_events_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues/events{/number}","events_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/events","assignees_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/assignees{/user}","branches_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/branches{/branch}","tags_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/tags","blobs_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/refs{/sha}","trees_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/trees{/sha}","statuses_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/statuses/{sha}","languages_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/languages","stargazers_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/stargazers","contributors_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/contributors","subscribers_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/subscribers","subscription_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/subscription","commits_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/commits{/sha}","git_commits_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/commits{/sha}","comments_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/comments{/number}","issue_comment_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues/comments{/number}","contents_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/contents/{+path}","compare_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/compare/{base}...{head}","merges_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/merges","archive_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/downloads","issues_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues{/number}","pulls_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls{/number}","milestones_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/milestones{/number}","notifications_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/labels{/name}","releases_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/releases{/id}","deployments_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/deployments","created_at":"2018-05-10T04:09:05Z","updated_at":"2018-05-30T03:59:11Z","pushed_at":"2018-05-30T04:19:31Z","git_url":"git://github.com/AT-PHPIntership/food-drink.git","ssh_url":"git@github.com:AT-PHPIntership/food-drink.git","clone_url":"https://github.com/AT-PHPIntership/food-drink.git","svn_url":"https://github.com/AT-PHPIntership/food-drink","homepage":null,"size":1817,"stargazers_count":3,"watchers_count":3,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":8,"license":null,"forks":0,"open_issues":8,"watchers":3,"default_branch":"master"}},"base":{"label":"AT-PHPIntership:master","ref":"master","sha":"52125449521510a295d2c7272e651056ca1175d7","user":{"login":"AT-PHPIntership","id":17865237,"avatar_url":"https://avatars1.githubusercontent.com/u/17865237?v=4","gravatar_id":"","url":"https://api.github.com/users/AT-PHPIntership","html_url":"https://github.com/AT-PHPIntership","followers_url":"https://api.github.com/users/AT-PHPIntership/followers","following_url":"https://api.github.com/users/AT-PHPIntership/following{/other_user}","gists_url":"https://api.github.com/users/AT-PHPIntership/gists{/gist_id}","starred_url":"https://api.github.com/users/AT-PHPIntership/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AT-PHPIntership/subscriptions","organizations_url":"https://api.github.com/users/AT-PHPIntership/orgs","repos_url":"https://api.github.com/users/AT-PHPIntership/repos","events_url":"https://api.github.com/users/AT-PHPIntership/events{/privacy}","received_events_url":"https://api.github.com/users/AT-PHPIntership/received_events","type":"Organization","site_admin":false},"repo":{"id":132847163,"name":"food-drink","full_name":"AT-PHPIntership/food-drink","owner":{"login":"AT-PHPIntership","id":17865237,"avatar_url":"https://avatars1.githubusercontent.com/u/17865237?v=4","gravatar_id":"","url":"https://api.github.com/users/AT-PHPIntership","html_url":"https://github.com/AT-PHPIntership","followers_url":"https://api.github.com/users/AT-PHPIntership/followers","following_url":"https://api.github.com/users/AT-PHPIntership/following{/other_user}","gists_url":"https://api.github.com/users/AT-PHPIntership/gists{/gist_id}","starred_url":"https://api.github.com/users/AT-PHPIntership/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AT-PHPIntership/subscriptions","organizations_url":"https://api.github.com/users/AT-PHPIntership/orgs","repos_url":"https://api.github.com/users/AT-PHPIntership/repos","events_url":"https://api.github.com/users/AT-PHPIntership/events{/privacy}","received_events_url":"https://api.github.com/users/AT-PHPIntership/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/AT-PHPIntership/food-drink","description":null,"fork":false,"url":"https://api.github.com/repos/AT-PHPIntership/food-drink","forks_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/forks","keys_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/keys{/key_id}","collaborators_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/teams","hooks_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/hooks","issue_events_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues/events{/number}","events_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/events","assignees_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/assignees{/user}","branches_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/branches{/branch}","tags_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/tags","blobs_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/refs{/sha}","trees_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/trees{/sha}","statuses_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/statuses/{sha}","languages_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/languages","stargazers_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/stargazers","contributors_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/contributors","subscribers_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/subscribers","subscription_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/subscription","commits_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/commits{/sha}","git_commits_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/git/commits{/sha}","comments_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/comments{/number}","issue_comment_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues/comments{/number}","contents_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/contents/{+path}","compare_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/compare/{base}...{head}","merges_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/merges","archive_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/downloads","issues_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues{/number}","pulls_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls{/number}","milestones_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/milestones{/number}","notifications_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/labels{/name}","releases_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/releases{/id}","deployments_url":"https://api.github.com/repos/AT-PHPIntership/food-drink/deployments","created_at":"2018-05-10T04:09:05Z","updated_at":"2018-05-30T03:59:11Z","pushed_at":"2018-05-30T04:19:31Z","git_url":"git://github.com/AT-PHPIntership/food-drink.git","ssh_url":"git@github.com:AT-PHPIntership/food-drink.git","clone_url":"https://github.com/AT-PHPIntership/food-drink.git","svn_url":"https://github.com/AT-PHPIntership/food-drink","homepage":null,"size":1817,"stargazers_count":3,"watchers_count":3,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":8,"license":null,"forks":0,"open_issues":8,"watchers":3,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls/57"},"html":{"href":"https://github.com/AT-PHPIntership/food-drink/pull/57"},"issue":{"href":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues/57"},"comments":{"href":"https://api.github.com/repos/AT-PHPIntership/food-drink/issues/57/comments"},"review_comments":{"href":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls/57/comments"},"review_comment":{"href":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/AT-PHPIntership/food-drink/pulls/57/commits"},"statuses":{"href":"https://api.github.com/repos/AT-PHPIntership/food-drink/statuses/9f3e8a381dabf014fb11dde57b5880c8ac4b909d"}},"author_association":"COLLABORATOR","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"at-vietpham","id":16131595,"avatar_url":"https://avatars2.githubusercontent.com/u/16131595?v=4","gravatar_id":"","url":"https://api.github.com/users/at-vietpham","html_url":"https://github.com/at-vietpham","followers_url":"https://api.github.com/users/at-vietpham/followers","following_url":"https://api.github.com/users/at-vietpham/following{/other_user}","gists_url":"https://api.github.com/users/at-vietpham/gists{/gist_id}","starred_url":"https://api.github.com/users/at-vietpham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/at-vietpham/subscriptions","organizations_url":"https://api.github.com/users/at-vietpham/orgs","repos_url":"https://api.github.com/users/at-vietpham/repos","events_url":"https://api.github.com/users/at-vietpham/events{/privacy}","received_events_url":"https://api.github.com/users/at-vietpham/received_events","type":"User","site_admin":false},"comments":2,"review_comments":3,"maintainer_can_modify":false,"commits":3,"additions":29,"deletions":1,"changed_files":4}}
{"actor":{"display_login":"at-vietpham"}}