{"action":"created","comment":{"url":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/comments/71099243","id":71099243,"diff_hunk":"@@ -84,15 +94,20 @@ func (repo DbUserRepo) FindById(id int) (usecases.User, error) {\n }\n \n func (repo DbUserRepo) Count() (int, error) {\n-\trow, err := repo.dbHandler.Query(\"SELECT COUNT(*) FROM users\")\n+\t//\"SELECT COUNT(*)\" returns number of row, not the last id in the database\n+\trow, err := repo.dbHandler.Query(\"SELECT id FROM users\")","path":"interfaces/repositories.go","position":null,"original_position":31,"commit_id":"7d0bd0b0b5e1ef85a81cd75755c95dfb57320710","original_commit_id":"7d0bd0b0b5e1ef85a81cd75755c95dfb57320710","user":{"login":"frostablevenus","id":15098505,"avatar_url":"https://avatars.githubusercontent.com/u/15098505?v=3","gravatar_id":"","url":"https://api.github.com/users/frostablevenus","html_url":"https://github.com/frostablevenus","followers_url":"https://api.github.com/users/frostablevenus/followers","following_url":"https://api.github.com/users/frostablevenus/following{/other_user}","gists_url":"https://api.github.com/users/frostablevenus/gists{/gist_id}","starred_url":"https://api.github.com/users/frostablevenus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frostablevenus/subscriptions","organizations_url":"https://api.github.com/users/frostablevenus/orgs","repos_url":"https://api.github.com/users/frostablevenus/repos","events_url":"https://api.github.com/users/frostablevenus/events{/privacy}","received_events_url":"https://api.github.com/users/frostablevenus/received_events","type":"User","site_admin":false},"body":"This function gets the IDs to which the users are assigned when they are added to the database. It's possible that some users delete their account, making the number of rows different from the new IDs, so if I use ```COUNT(*)``` instead of ```id```, it's potentially wrong.","created_at":"2016-07-18T04:14:44Z","updated_at":"2016-07-18T04:14:44Z","html_url":"https://github.com/frostablevenus/game-tracker/pull/5#discussion_r71099243","pull_request_url":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/5","_links":{"self":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/comments/71099243"},"html":{"href":"https://github.com/frostablevenus/game-tracker/pull/5#discussion_r71099243"},"pull_request":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/5"}}},"pull_request":{"url":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/5","id":77579856,"html_url":"https://github.com/frostablevenus/game-tracker/pull/5","diff_url":"https://github.com/frostablevenus/game-tracker/pull/5.diff","patch_url":"https://github.com/frostablevenus/game-tracker/pull/5.patch","issue_url":"https://api.github.com/repos/frostablevenus/game-tracker/issues/5","number":5,"state":"open","locked":false,"title":"Core program","user":{"login":"frostablevenus","id":15098505,"avatar_url":"https://avatars.githubusercontent.com/u/15098505?v=3","gravatar_id":"","url":"https://api.github.com/users/frostablevenus","html_url":"https://github.com/frostablevenus","followers_url":"https://api.github.com/users/frostablevenus/followers","following_url":"https://api.github.com/users/frostablevenus/following{/other_user}","gists_url":"https://api.github.com/users/frostablevenus/gists{/gist_id}","starred_url":"https://api.github.com/users/frostablevenus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frostablevenus/subscriptions","organizations_url":"https://api.github.com/users/frostablevenus/orgs","repos_url":"https://api.github.com/users/frostablevenus/repos","events_url":"https://api.github.com/users/frostablevenus/events{/privacy}","received_events_url":"https://api.github.com/users/frostablevenus/received_events","type":"User","site_admin":false},"body":"Created core program with Clean structure:\r\n\r\n- domain - Business rules: Player, Game\r\n- usecases - Application rules: User, Library, Game, Repositories\r\n- interfaces - Information transporter between application logic and persistence mechanism\r\n- infrastructure - PostgresSQL Database\r\n\r\nProvided web services in main.go\r\nDB host address in config.json","created_at":"2016-07-15T08:23:41Z","updated_at":"2016-07-18T04:14:44Z","closed_at":null,"merged_at":null,"merge_commit_sha":"ec559214bc6ad1e729ec700e1bafd0243eb75b0e","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/5/commits","review_comments_url":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/5/comments","review_comment_url":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/comments{/number}","comments_url":"https://api.github.com/repos/frostablevenus/game-tracker/issues/5/comments","statuses_url":"https://api.github.com/repos/frostablevenus/game-tracker/statuses/7d0bd0b0b5e1ef85a81cd75755c95dfb57320710","head":{"label":"frostablevenus:create-layers-clean","ref":"create-layers-clean","sha":"7d0bd0b0b5e1ef85a81cd75755c95dfb57320710","user":{"login":"frostablevenus","id":15098505,"avatar_url":"https://avatars.githubusercontent.com/u/15098505?v=3","gravatar_id":"","url":"https://api.github.com/users/frostablevenus","html_url":"https://github.com/frostablevenus","followers_url":"https://api.github.com/users/frostablevenus/followers","following_url":"https://api.github.com/users/frostablevenus/following{/other_user}","gists_url":"https://api.github.com/users/frostablevenus/gists{/gist_id}","starred_url":"https://api.github.com/users/frostablevenus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frostablevenus/subscriptions","organizations_url":"https://api.github.com/users/frostablevenus/orgs","repos_url":"https://api.github.com/users/frostablevenus/repos","events_url":"https://api.github.com/users/frostablevenus/events{/privacy}","received_events_url":"https://api.github.com/users/frostablevenus/received_events","type":"User","site_admin":false},"repo":{"id":62686558,"name":"game-tracker","full_name":"frostablevenus/game-tracker","owner":{"login":"frostablevenus","id":15098505,"avatar_url":"https://avatars.githubusercontent.com/u/15098505?v=3","gravatar_id":"","url":"https://api.github.com/users/frostablevenus","html_url":"https://github.com/frostablevenus","followers_url":"https://api.github.com/users/frostablevenus/followers","following_url":"https://api.github.com/users/frostablevenus/following{/other_user}","gists_url":"https://api.github.com/users/frostablevenus/gists{/gist_id}","starred_url":"https://api.github.com/users/frostablevenus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frostablevenus/subscriptions","organizations_url":"https://api.github.com/users/frostablevenus/orgs","repos_url":"https://api.github.com/users/frostablevenus/repos","events_url":"https://api.github.com/users/frostablevenus/events{/privacy}","received_events_url":"https://api.github.com/users/frostablevenus/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/frostablevenus/game-tracker","description":null,"fork":false,"url":"https://api.github.com/repos/frostablevenus/game-tracker","forks_url":"https://api.github.com/repos/frostablevenus/game-tracker/forks","keys_url":"https://api.github.com/repos/frostablevenus/game-tracker/keys{/key_id}","collaborators_url":"https://api.github.com/repos/frostablevenus/game-tracker/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/frostablevenus/game-tracker/teams","hooks_url":"https://api.github.com/repos/frostablevenus/game-tracker/hooks","issue_events_url":"https://api.github.com/repos/frostablevenus/game-tracker/issues/events{/number}","events_url":"https://api.github.com/repos/frostablevenus/game-tracker/events","assignees_url":"https://api.github.com/repos/frostablevenus/game-tracker/assignees{/user}","branches_url":"https://api.github.com/repos/frostablevenus/game-tracker/branches{/branch}","tags_url":"https://api.github.com/repos/frostablevenus/game-tracker/tags","blobs_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/refs{/sha}","trees_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/trees{/sha}","statuses_url":"https://api.github.com/repos/frostablevenus/game-tracker/statuses/{sha}","languages_url":"https://api.github.com/repos/frostablevenus/game-tracker/languages","stargazers_url":"https://api.github.com/repos/frostablevenus/game-tracker/stargazers","contributors_url":"https://api.github.com/repos/frostablevenus/game-tracker/contributors","subscribers_url":"https://api.github.com/repos/frostablevenus/game-tracker/subscribers","subscription_url":"https://api.github.com/repos/frostablevenus/game-tracker/subscription","commits_url":"https://api.github.com/repos/frostablevenus/game-tracker/commits{/sha}","git_commits_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/commits{/sha}","comments_url":"https://api.github.com/repos/frostablevenus/game-tracker/comments{/number}","issue_comment_url":"https://api.github.com/repos/frostablevenus/game-tracker/issues/comments{/number}","contents_url":"https://api.github.com/repos/frostablevenus/game-tracker/contents/{+path}","compare_url":"https://api.github.com/repos/frostablevenus/game-tracker/compare/{base}...{head}","merges_url":"https://api.github.com/repos/frostablevenus/game-tracker/merges","archive_url":"https://api.github.com/repos/frostablevenus/game-tracker/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/frostablevenus/game-tracker/downloads","issues_url":"https://api.github.com/repos/frostablevenus/game-tracker/issues{/number}","pulls_url":"https://api.github.com/repos/frostablevenus/game-tracker/pulls{/number}","milestones_url":"https://api.github.com/repos/frostablevenus/game-tracker/milestones{/number}","notifications_url":"https://api.github.com/repos/frostablevenus/game-tracker/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/frostablevenus/game-tracker/labels{/name}","releases_url":"https://api.github.com/repos/frostablevenus/game-tracker/releases{/id}","deployments_url":"https://api.github.com/repos/frostablevenus/game-tracker/deployments","created_at":"2016-07-06T02:59:38Z","updated_at":"2016-07-06T02:59:38Z","pushed_at":"2016-07-18T03:37:36Z","git_url":"git://github.com/frostablevenus/game-tracker.git","ssh_url":"git@github.com:frostablevenus/game-tracker.git","clone_url":"https://github.com/frostablevenus/game-tracker.git","svn_url":"https://github.com/frostablevenus/game-tracker","homepage":null,"size":20,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":1,"forks":1,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"frostablevenus:master","ref":"master","sha":"51924be762e2febfa20775f32ee4e0054dc5cb38","user":{"login":"frostablevenus","id":15098505,"avatar_url":"https://avatars.githubusercontent.com/u/15098505?v=3","gravatar_id":"","url":"https://api.github.com/users/frostablevenus","html_url":"https://github.com/frostablevenus","followers_url":"https://api.github.com/users/frostablevenus/followers","following_url":"https://api.github.com/users/frostablevenus/following{/other_user}","gists_url":"https://api.github.com/users/frostablevenus/gists{/gist_id}","starred_url":"https://api.github.com/users/frostablevenus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frostablevenus/subscriptions","organizations_url":"https://api.github.com/users/frostablevenus/orgs","repos_url":"https://api.github.com/users/frostablevenus/repos","events_url":"https://api.github.com/users/frostablevenus/events{/privacy}","received_events_url":"https://api.github.com/users/frostablevenus/received_events","type":"User","site_admin":false},"repo":{"id":62686558,"name":"game-tracker","full_name":"frostablevenus/game-tracker","owner":{"login":"frostablevenus","id":15098505,"avatar_url":"https://avatars.githubusercontent.com/u/15098505?v=3","gravatar_id":"","url":"https://api.github.com/users/frostablevenus","html_url":"https://github.com/frostablevenus","followers_url":"https://api.github.com/users/frostablevenus/followers","following_url":"https://api.github.com/users/frostablevenus/following{/other_user}","gists_url":"https://api.github.com/users/frostablevenus/gists{/gist_id}","starred_url":"https://api.github.com/users/frostablevenus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frostablevenus/subscriptions","organizations_url":"https://api.github.com/users/frostablevenus/orgs","repos_url":"https://api.github.com/users/frostablevenus/repos","events_url":"https://api.github.com/users/frostablevenus/events{/privacy}","received_events_url":"https://api.github.com/users/frostablevenus/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/frostablevenus/game-tracker","description":null,"fork":false,"url":"https://api.github.com/repos/frostablevenus/game-tracker","forks_url":"https://api.github.com/repos/frostablevenus/game-tracker/forks","keys_url":"https://api.github.com/repos/frostablevenus/game-tracker/keys{/key_id}","collaborators_url":"https://api.github.com/repos/frostablevenus/game-tracker/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/frostablevenus/game-tracker/teams","hooks_url":"https://api.github.com/repos/frostablevenus/game-tracker/hooks","issue_events_url":"https://api.github.com/repos/frostablevenus/game-tracker/issues/events{/number}","events_url":"https://api.github.com/repos/frostablevenus/game-tracker/events","assignees_url":"https://api.github.com/repos/frostablevenus/game-tracker/assignees{/user}","branches_url":"https://api.github.com/repos/frostablevenus/game-tracker/branches{/branch}","tags_url":"https://api.github.com/repos/frostablevenus/game-tracker/tags","blobs_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/refs{/sha}","trees_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/trees{/sha}","statuses_url":"https://api.github.com/repos/frostablevenus/game-tracker/statuses/{sha}","languages_url":"https://api.github.com/repos/frostablevenus/game-tracker/languages","stargazers_url":"https://api.github.com/repos/frostablevenus/game-tracker/stargazers","contributors_url":"https://api.github.com/repos/frostablevenus/game-tracker/contributors","subscribers_url":"https://api.github.com/repos/frostablevenus/game-tracker/subscribers","subscription_url":"https://api.github.com/repos/frostablevenus/game-tracker/subscription","commits_url":"https://api.github.com/repos/frostablevenus/game-tracker/commits{/sha}","git_commits_url":"https://api.github.com/repos/frostablevenus/game-tracker/git/commits{/sha}","comments_url":"https://api.github.com/repos/frostablevenus/game-tracker/comments{/number}","issue_comment_url":"https://api.github.com/repos/frostablevenus/game-tracker/issues/comments{/number}","contents_url":"https://api.github.com/repos/frostablevenus/game-tracker/contents/{+path}","compare_url":"https://api.github.com/repos/frostablevenus/game-tracker/compare/{base}...{head}","merges_url":"https://api.github.com/repos/frostablevenus/game-tracker/merges","archive_url":"https://api.github.com/repos/frostablevenus/game-tracker/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/frostablevenus/game-tracker/downloads","issues_url":"https://api.github.com/repos/frostablevenus/game-tracker/issues{/number}","pulls_url":"https://api.github.com/repos/frostablevenus/game-tracker/pulls{/number}","milestones_url":"https://api.github.com/repos/frostablevenus/game-tracker/milestones{/number}","notifications_url":"https://api.github.com/repos/frostablevenus/game-tracker/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/frostablevenus/game-tracker/labels{/name}","releases_url":"https://api.github.com/repos/frostablevenus/game-tracker/releases{/id}","deployments_url":"https://api.github.com/repos/frostablevenus/game-tracker/deployments","created_at":"2016-07-06T02:59:38Z","updated_at":"2016-07-06T02:59:38Z","pushed_at":"2016-07-18T03:37:36Z","git_url":"git://github.com/frostablevenus/game-tracker.git","ssh_url":"git@github.com:frostablevenus/game-tracker.git","clone_url":"https://github.com/frostablevenus/game-tracker.git","svn_url":"https://github.com/frostablevenus/game-tracker","homepage":null,"size":20,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":1,"forks":1,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/5"},"html":{"href":"https://github.com/frostablevenus/game-tracker/pull/5"},"issue":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/issues/5"},"comments":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/issues/5/comments"},"review_comments":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/5/comments"},"review_comment":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/pulls/5/commits"},"statuses":{"href":"https://api.github.com/repos/frostablevenus/game-tracker/statuses/7d0bd0b0b5e1ef85a81cd75755c95dfb57320710"}}}}
{"actor":{"display_login":"frostablevenus"}}