{"action":"created","issue":{"url":"https://api.github.com/repos/eggpi/citationhunt/issues/52","repository_url":"https://api.github.com/repos/eggpi/citationhunt","labels_url":"https://api.github.com/repos/eggpi/citationhunt/issues/52/labels{/name}","comments_url":"https://api.github.com/repos/eggpi/citationhunt/issues/52/comments","events_url":"https://api.github.com/repos/eggpi/citationhunt/issues/52/events","html_url":"https://github.com/eggpi/citationhunt/pull/52","id":166798574,"number":52,"title":"Use new WikiProject index tables","user":{"login":"earwig","id":637235,"avatar_url":"https://avatars.githubusercontent.com/u/637235?v=3","gravatar_id":"","url":"https://api.github.com/users/earwig","html_url":"https://github.com/earwig","followers_url":"https://api.github.com/users/earwig/followers","following_url":"https://api.github.com/users/earwig/following{/other_user}","gists_url":"https://api.github.com/users/earwig/gists{/gist_id}","starred_url":"https://api.github.com/users/earwig/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/earwig/subscriptions","organizations_url":"https://api.github.com/users/earwig/orgs","repos_url":"https://api.github.com/users/earwig/repos","events_url":"https://api.github.com/users/earwig/events{/privacy}","received_events_url":"https://api.github.com/users/earwig/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-07-21T11:37:49Z","updated_at":"2016-07-23T00:04:54Z","closed_at":"2016-07-21T17:40:26Z","pull_request":{"url":"https://api.github.com/repos/eggpi/citationhunt/pulls/52","html_url":"https://github.com/eggpi/citationhunt/pull/52","diff_url":"https://github.com/eggpi/citationhunt/pull/52.diff","patch_url":"https://github.com/eggpi/citationhunt/pull/52.patch"},"body":"We've changed the way the WikiProject index tables are laid out on the backend. The schema is a bit more complicated, but allows for much more flexibility—including better namespace and language support (though we're still limited to enwiki at the moment).\r\n\r\nAnyway, I've updated the way you query the database here. It's nice because we can pull the page IDs directly in the initial query instead of making an individual SELECT for each page. As far as I can tell, this is the only place you use the project index tables. The new tables are ready to go as soon as you can merge this; the old tables will stay around for a little while longer in case something goes wrong. On that note, I haven't fully tested this (just the querying logic) so please let me know if something isn't right.\r\n\r\nI realize PageAssessments is coming soon and will likely invalidate all of this, but until we reach that point..."},"comment":{"url":"https://api.github.com/repos/eggpi/citationhunt/issues/comments/234684990","html_url":"https://github.com/eggpi/citationhunt/pull/52#issuecomment-234684990","issue_url":"https://api.github.com/repos/eggpi/citationhunt/issues/52","id":234684990,"user":{"login":"earwig","id":637235,"avatar_url":"https://avatars.githubusercontent.com/u/637235?v=3","gravatar_id":"","url":"https://api.github.com/users/earwig","html_url":"https://github.com/earwig","followers_url":"https://api.github.com/users/earwig/followers","following_url":"https://api.github.com/users/earwig/following{/other_user}","gists_url":"https://api.github.com/users/earwig/gists{/gist_id}","starred_url":"https://api.github.com/users/earwig/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/earwig/subscriptions","organizations_url":"https://api.github.com/users/earwig/orgs","repos_url":"https://api.github.com/users/earwig/repos","events_url":"https://api.github.com/users/earwig/events{/privacy}","received_events_url":"https://api.github.com/users/earwig/received_events","type":"User","site_admin":false},"created_at":"2016-07-23T00:04:54Z","updated_at":"2016-07-23T00:04:54Z","body":"Looks like the page IDs in `unsourced_pageids` are strings, but our database returns ints. Judging by your last commit (faaa4df184a5f64173e61ed89c3d7f98b0649c9d), I guess you've already figured that out?"}}
{"actor":{"display_login":"earwig"}}