{"action":"created","issue":{"url":"https://api.github.com/repos/iankronquist/y-cloninator/issues/9","labels_url":"https://api.github.com/repos/iankronquist/y-cloninator/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/iankronquist/y-cloninator/issues/9/comments","events_url":"https://api.github.com/repos/iankronquist/y-cloninator/issues/9/events","html_url":"https://github.com/iankronquist/y-cloninator/pull/9","id":128110233,"number":9,"title":"Issue #8 Refactor to handle multiple mentions of Git repo","user":{"login":"mshenfield","id":4812055,"avatar_url":"https://avatars.githubusercontent.com/u/4812055?v=3","gravatar_id":"","url":"https://api.github.com/users/mshenfield","html_url":"https://github.com/mshenfield","followers_url":"https://api.github.com/users/mshenfield/followers","following_url":"https://api.github.com/users/mshenfield/following{/other_user}","gists_url":"https://api.github.com/users/mshenfield/gists{/gist_id}","starred_url":"https://api.github.com/users/mshenfield/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mshenfield/subscriptions","organizations_url":"https://api.github.com/users/mshenfield/orgs","repos_url":"https://api.github.com/users/mshenfield/repos","events_url":"https://api.github.com/users/mshenfield/events{/privacy}","received_events_url":"https://api.github.com/users/mshenfield/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2016-01-22T08:49:00Z","updated_at":"2016-01-24T01:21:01Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/iankronquist/y-cloninator/pulls/9","html_url":"https://github.com/iankronquist/y-cloninator/pull/9","diff_url":"https://github.com/iankronquist/y-cloninator/pull/9.diff","patch_url":"https://github.com/iankronquist/y-cloninator/pull/9.patch"},"body":"The core of this change rewires the database so that hnposts are children of git repositories.  In the context of this project, this makes sense: we care about the repos, and 1 or more hnposts has mentioned them.\r\n\r\nThis allows us to do some interesting things, including displaying and linking to the first and last mentions of a project, and the total mentions.\r\n\r\nI couldn't find a `knex` syntax for selecting * from just one table, e.g. `select * from a.*`. So listed out all the columns needed. Refactored shared parts of the query into a base query that could be shared, minimizing duplicated code.\r\n\r\nThis requires a complete drop, re-add, and then re-population of the database."},"comment":{"url":"https://api.github.com/repos/iankronquist/y-cloninator/issues/comments/174240344","html_url":"https://github.com/iankronquist/y-cloninator/pull/9#issuecomment-174240344","issue_url":"https://api.github.com/repos/iankronquist/y-cloninator/issues/9","id":174240344,"user":{"login":"mshenfield","id":4812055,"avatar_url":"https://avatars.githubusercontent.com/u/4812055?v=3","gravatar_id":"","url":"https://api.github.com/users/mshenfield","html_url":"https://github.com/mshenfield","followers_url":"https://api.github.com/users/mshenfield/followers","following_url":"https://api.github.com/users/mshenfield/following{/other_user}","gists_url":"https://api.github.com/users/mshenfield/gists{/gist_id}","starred_url":"https://api.github.com/users/mshenfield/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mshenfield/subscriptions","organizations_url":"https://api.github.com/users/mshenfield/orgs","repos_url":"https://api.github.com/users/mshenfield/repos","events_url":"https://api.github.com/users/mshenfield/events{/privacy}","received_events_url":"https://api.github.com/users/mshenfield/received_events","type":"User","site_admin":false},"created_at":"2016-01-24T01:21:01Z","updated_at":"2016-01-24T01:21:01Z","body":"Fixed merge conflicts"}}