{"action":"created","comment":{"url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/comments/146109879","pull_request_review_id":71011752,"id":146109879,"diff_hunk":"@@ -0,0 +1,103 @@\n+CREATE OR REPLACE FUNCTION\n+    instance_questions_calculate_stats(\n+        instance_question_id_var bigint\n+    ) RETURNS VOID\n+AS $$\n+BEGIN\n+    WITH more_info AS (\n+        SELECT\n+            aq.assessment_id,\n+            aq.question_id,\n+            a.course_instance_id,\n+            aq.id AS assessment_question_id\n+        FROM\n+            instance_questions AS iq\n+            JOIN assessments AS a ON (a.id = iq.assessment_id)","path":"sprocs/instance_questions_calculate_stats.sql","position":15,"original_position":15,"commit_id":"cb13ede38d4f068ac855c57c13dbe9ddd9dc16a2","original_commit_id":"cb13ede38d4f068ac855c57c13dbe9ddd9dc16a2","user":{"login":"mwest1066","id":875833,"avatar_url":"https://avatars3.githubusercontent.com/u/875833?v=4","gravatar_id":"","url":"https://api.github.com/users/mwest1066","html_url":"https://github.com/mwest1066","followers_url":"https://api.github.com/users/mwest1066/followers","following_url":"https://api.github.com/users/mwest1066/following{/other_user}","gists_url":"https://api.github.com/users/mwest1066/gists{/gist_id}","starred_url":"https://api.github.com/users/mwest1066/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mwest1066/subscriptions","organizations_url":"https://api.github.com/users/mwest1066/orgs","repos_url":"https://api.github.com/users/mwest1066/repos","events_url":"https://api.github.com/users/mwest1066/events{/privacy}","received_events_url":"https://api.github.com/users/mwest1066/received_events","type":"User","site_admin":false},"body":"This fails because there is no column `instance_questions.assessment_id`.","created_at":"2017-10-21T16:50:46Z","updated_at":"2017-10-21T16:50:46Z","html_url":"https://github.com/PrairieLearn/PrairieLearn/pull/847#discussion_r146109879","pull_request_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/847","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/comments/146109879"},"html":{"href":"https://github.com/PrairieLearn/PrairieLearn/pull/847#discussion_r146109879"},"pull_request":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/847"}}},"pull_request":{"url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/847","id":144596505,"html_url":"https://github.com/PrairieLearn/PrairieLearn/pull/847","diff_url":"https://github.com/PrairieLearn/PrairieLearn/pull/847.diff","patch_url":"https://github.com/PrairieLearn/PrairieLearn/pull/847.patch","issue_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/issues/847","number":847,"state":"open","locked":false,"title":"Add detailed statistics on instructor assessment and instructor question pages.","user":{"login":"parasgithub","id":8584719,"avatar_url":"https://avatars2.githubusercontent.com/u/8584719?v=4","gravatar_id":"","url":"https://api.github.com/users/parasgithub","html_url":"https://github.com/parasgithub","followers_url":"https://api.github.com/users/parasgithub/followers","following_url":"https://api.github.com/users/parasgithub/following{/other_user}","gists_url":"https://api.github.com/users/parasgithub/gists{/gist_id}","starred_url":"https://api.github.com/users/parasgithub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/parasgithub/subscriptions","organizations_url":"https://api.github.com/users/parasgithub/orgs","repos_url":"https://api.github.com/users/parasgithub/repos","events_url":"https://api.github.com/users/parasgithub/events{/privacy}","received_events_url":"https://api.github.com/users/parasgithub/received_events","type":"User","site_admin":false},"body":"close #658","created_at":"2017-10-04T07:13:00Z","updated_at":"2017-10-21T16:50:46Z","closed_at":null,"merged_at":null,"merge_commit_sha":"eb1fc274bc95bf28e34e34d7b9f74546cb2bcb7a","assignee":null,"assignees":[],"requested_reviewers":[],"milestone":null,"commits_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/847/commits","review_comments_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/847/comments","review_comment_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/comments{/number}","comments_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/issues/847/comments","statuses_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/statuses/cb13ede38d4f068ac855c57c13dbe9ddd9dc16a2","head":{"label":"parasgithub:599-add-a-difficulty-value-column-in-instructor-assessment-pages-questions-table","ref":"599-add-a-difficulty-value-column-in-instructor-assessment-pages-questions-table","sha":"cb13ede38d4f068ac855c57c13dbe9ddd9dc16a2","user":{"login":"parasgithub","id":8584719,"avatar_url":"https://avatars2.githubusercontent.com/u/8584719?v=4","gravatar_id":"","url":"https://api.github.com/users/parasgithub","html_url":"https://github.com/parasgithub","followers_url":"https://api.github.com/users/parasgithub/followers","following_url":"https://api.github.com/users/parasgithub/following{/other_user}","gists_url":"https://api.github.com/users/parasgithub/gists{/gist_id}","starred_url":"https://api.github.com/users/parasgithub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/parasgithub/subscriptions","organizations_url":"https://api.github.com/users/parasgithub/orgs","repos_url":"https://api.github.com/users/parasgithub/repos","events_url":"https://api.github.com/users/parasgithub/events{/privacy}","received_events_url":"https://api.github.com/users/parasgithub/received_events","type":"User","site_admin":false},"repo":{"id":67903879,"name":"PrairieLearn","full_name":"parasgithub/PrairieLearn","owner":{"login":"parasgithub","id":8584719,"avatar_url":"https://avatars2.githubusercontent.com/u/8584719?v=4","gravatar_id":"","url":"https://api.github.com/users/parasgithub","html_url":"https://github.com/parasgithub","followers_url":"https://api.github.com/users/parasgithub/followers","following_url":"https://api.github.com/users/parasgithub/following{/other_user}","gists_url":"https://api.github.com/users/parasgithub/gists{/gist_id}","starred_url":"https://api.github.com/users/parasgithub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/parasgithub/subscriptions","organizations_url":"https://api.github.com/users/parasgithub/orgs","repos_url":"https://api.github.com/users/parasgithub/repos","events_url":"https://api.github.com/users/parasgithub/events{/privacy}","received_events_url":"https://api.github.com/users/parasgithub/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/parasgithub/PrairieLearn","description":null,"fork":true,"url":"https://api.github.com/repos/parasgithub/PrairieLearn","forks_url":"https://api.github.com/repos/parasgithub/PrairieLearn/forks","keys_url":"https://api.github.com/repos/parasgithub/PrairieLearn/keys{/key_id}","collaborators_url":"https://api.github.com/repos/parasgithub/PrairieLearn/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/parasgithub/PrairieLearn/teams","hooks_url":"https://api.github.com/repos/parasgithub/PrairieLearn/hooks","issue_events_url":"https://api.github.com/repos/parasgithub/PrairieLearn/issues/events{/number}","events_url":"https://api.github.com/repos/parasgithub/PrairieLearn/events","assignees_url":"https://api.github.com/repos/parasgithub/PrairieLearn/assignees{/user}","branches_url":"https://api.github.com/repos/parasgithub/PrairieLearn/branches{/branch}","tags_url":"https://api.github.com/repos/parasgithub/PrairieLearn/tags","blobs_url":"https://api.github.com/repos/parasgithub/PrairieLearn/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/parasgithub/PrairieLearn/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/parasgithub/PrairieLearn/git/refs{/sha}","trees_url":"https://api.github.com/repos/parasgithub/PrairieLearn/git/trees{/sha}","statuses_url":"https://api.github.com/repos/parasgithub/PrairieLearn/statuses/{sha}","languages_url":"https://api.github.com/repos/parasgithub/PrairieLearn/languages","stargazers_url":"https://api.github.com/repos/parasgithub/PrairieLearn/stargazers","contributors_url":"https://api.github.com/repos/parasgithub/PrairieLearn/contributors","subscribers_url":"https://api.github.com/repos/parasgithub/PrairieLearn/subscribers","subscription_url":"https://api.github.com/repos/parasgithub/PrairieLearn/subscription","commits_url":"https://api.github.com/repos/parasgithub/PrairieLearn/commits{/sha}","git_commits_url":"https://api.github.com/repos/parasgithub/PrairieLearn/git/commits{/sha}","comments_url":"https://api.github.com/repos/parasgithub/PrairieLearn/comments{/number}","issue_comment_url":"https://api.github.com/repos/parasgithub/PrairieLearn/issues/comments{/number}","contents_url":"https://api.github.com/repos/parasgithub/PrairieLearn/contents/{+path}","compare_url":"https://api.github.com/repos/parasgithub/PrairieLearn/compare/{base}...{head}","merges_url":"https://api.github.com/repos/parasgithub/PrairieLearn/merges","archive_url":"https://api.github.com/repos/parasgithub/PrairieLearn/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/parasgithub/PrairieLearn/downloads","issues_url":"https://api.github.com/repos/parasgithub/PrairieLearn/issues{/number}","pulls_url":"https://api.github.com/repos/parasgithub/PrairieLearn/pulls{/number}","milestones_url":"https://api.github.com/repos/parasgithub/PrairieLearn/milestones{/number}","notifications_url":"https://api.github.com/repos/parasgithub/PrairieLearn/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/parasgithub/PrairieLearn/labels{/name}","releases_url":"https://api.github.com/repos/parasgithub/PrairieLearn/releases{/id}","deployments_url":"https://api.github.com/repos/parasgithub/PrairieLearn/deployments","created_at":"2016-09-11T01:42:45Z","updated_at":"2016-09-11T01:42:49Z","pushed_at":"2017-10-18T15:31:00Z","git_url":"git://github.com/parasgithub/PrairieLearn.git","ssh_url":"git@github.com:parasgithub/PrairieLearn.git","clone_url":"https://github.com/parasgithub/PrairieLearn.git","svn_url":"https://github.com/parasgithub/PrairieLearn","homepage":null,"size":34961,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"PrairieLearn:master","ref":"master","sha":"737da0e1c8644b8449b19fb1394cf3981347ea76","user":{"login":"PrairieLearn","id":4580042,"avatar_url":"https://avatars3.githubusercontent.com/u/4580042?v=4","gravatar_id":"","url":"https://api.github.com/users/PrairieLearn","html_url":"https://github.com/PrairieLearn","followers_url":"https://api.github.com/users/PrairieLearn/followers","following_url":"https://api.github.com/users/PrairieLearn/following{/other_user}","gists_url":"https://api.github.com/users/PrairieLearn/gists{/gist_id}","starred_url":"https://api.github.com/users/PrairieLearn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PrairieLearn/subscriptions","organizations_url":"https://api.github.com/users/PrairieLearn/orgs","repos_url":"https://api.github.com/users/PrairieLearn/repos","events_url":"https://api.github.com/users/PrairieLearn/events{/privacy}","received_events_url":"https://api.github.com/users/PrairieLearn/received_events","type":"Organization","site_admin":false},"repo":{"id":20046997,"name":"PrairieLearn","full_name":"PrairieLearn/PrairieLearn","owner":{"login":"PrairieLearn","id":4580042,"avatar_url":"https://avatars3.githubusercontent.com/u/4580042?v=4","gravatar_id":"","url":"https://api.github.com/users/PrairieLearn","html_url":"https://github.com/PrairieLearn","followers_url":"https://api.github.com/users/PrairieLearn/followers","following_url":"https://api.github.com/users/PrairieLearn/following{/other_user}","gists_url":"https://api.github.com/users/PrairieLearn/gists{/gist_id}","starred_url":"https://api.github.com/users/PrairieLearn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PrairieLearn/subscriptions","organizations_url":"https://api.github.com/users/PrairieLearn/orgs","repos_url":"https://api.github.com/users/PrairieLearn/repos","events_url":"https://api.github.com/users/PrairieLearn/events{/privacy}","received_events_url":"https://api.github.com/users/PrairieLearn/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/PrairieLearn/PrairieLearn","description":"Online problem-driving learning system","fork":false,"url":"https://api.github.com/repos/PrairieLearn/PrairieLearn","forks_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/forks","keys_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/keys{/key_id}","collaborators_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/teams","hooks_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/hooks","issue_events_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/issues/events{/number}","events_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/events","assignees_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/assignees{/user}","branches_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/branches{/branch}","tags_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/tags","blobs_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/git/refs{/sha}","trees_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/git/trees{/sha}","statuses_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/statuses/{sha}","languages_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/languages","stargazers_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/stargazers","contributors_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/contributors","subscribers_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/subscribers","subscription_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/subscription","commits_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/commits{/sha}","git_commits_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/git/commits{/sha}","comments_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/comments{/number}","issue_comment_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/issues/comments{/number}","contents_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/contents/{+path}","compare_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/compare/{base}...{head}","merges_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/merges","archive_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/downloads","issues_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/issues{/number}","pulls_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls{/number}","milestones_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/milestones{/number}","notifications_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/labels{/name}","releases_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/releases{/id}","deployments_url":"https://api.github.com/repos/PrairieLearn/PrairieLearn/deployments","created_at":"2014-05-22T03:48:56Z","updated_at":"2017-09-29T05:48:13Z","pushed_at":"2017-10-21T15:37:00Z","git_url":"git://github.com/PrairieLearn/PrairieLearn.git","ssh_url":"git@github.com:PrairieLearn/PrairieLearn.git","clone_url":"https://github.com/PrairieLearn/PrairieLearn.git","svn_url":"https://github.com/PrairieLearn/PrairieLearn","homepage":"http://prairielearn.readthedocs.io/","size":35388,"stargazers_count":28,"watchers_count":28,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":33,"mirror_url":null,"archived":false,"open_issues_count":204,"forks":33,"open_issues":204,"watchers":28,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/847"},"html":{"href":"https://github.com/PrairieLearn/PrairieLearn/pull/847"},"issue":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/issues/847"},"comments":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/issues/847/comments"},"review_comments":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/847/comments"},"review_comment":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/pulls/847/commits"},"statuses":{"href":"https://api.github.com/repos/PrairieLearn/PrairieLearn/statuses/cb13ede38d4f068ac855c57c13dbe9ddd9dc16a2"}},"author_association":"NONE"}}
{"actor":{"display_login":"mwest1066"}}