{"action":"created","comment":{"url":"https://api.github.com/repos/timminata/GTFS/pulls/comments/196336870","pull_request_review_id":129866634,"id":196336870,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDE5NjMzNjg3MA==","diff_hunk":"@@ -166,6 +178,36 @@ public IEnumerable<Agency> Get()\n             });\n         }\n \n+        /// <summary>\n+        /// Returns entity ids\n+        /// </summary>\n+        /// <returns></returns>\n+        public IEnumerable<string> GetIds()\n+        {\n+            #if DEBUG\n+            var stopwatch = new System.Diagnostics.Stopwatch();\n+            stopwatch.Start();\n+            Console.Write($\"Fetching agency ids...\");\n+            #endif\n+            var outList = new List<string>();\n+            using (var command = _connection.CreateCommand())\n+            {\n+                command.CommandText = \"SELECT DISTINCT(id) FROM agency\";","path":"GTFS.DB.PostgreSQL/Collections/PostgreSQLAgencyCollection.cs","position":null,"original_position":39,"commit_id":"d16d2fa38489e58da930fda82a358fde31cfc452","original_commit_id":"7929f86ed9c5e94c2b6959fbc4fbbfd5253caaad","user":{"login":"peetjvv","id":22648295,"node_id":"MDQ6VXNlcjIyNjQ4Mjk1","avatar_url":"https://avatars1.githubusercontent.com/u/22648295?v=4","gravatar_id":"","url":"https://api.github.com/users/peetjvv","html_url":"https://github.com/peetjvv","followers_url":"https://api.github.com/users/peetjvv/followers","following_url":"https://api.github.com/users/peetjvv/following{/other_user}","gists_url":"https://api.github.com/users/peetjvv/gists{/gist_id}","starred_url":"https://api.github.com/users/peetjvv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peetjvv/subscriptions","organizations_url":"https://api.github.com/users/peetjvv/orgs","repos_url":"https://api.github.com/users/peetjvv/repos","events_url":"https://api.github.com/users/peetjvv/events{/privacy}","received_events_url":"https://api.github.com/users/peetjvv/received_events","type":"User","site_admin":false},"body":"fixed","created_at":"2018-06-19T08:32:15Z","updated_at":"2018-06-19T08:32:15Z","html_url":"https://github.com/timminata/GTFS/pull/16#discussion_r196336870","pull_request_url":"https://api.github.com/repos/timminata/GTFS/pulls/16","author_association":"COLLABORATOR","_links":{"self":{"href":"https://api.github.com/repos/timminata/GTFS/pulls/comments/196336870"},"html":{"href":"https://github.com/timminata/GTFS/pull/16#discussion_r196336870"},"pull_request":{"href":"https://api.github.com/repos/timminata/GTFS/pulls/16"}},"in_reply_to_id":196332732},"pull_request":{"url":"https://api.github.com/repos/timminata/GTFS/pulls/16","id":195579376,"node_id":"MDExOlB1bGxSZXF1ZXN0MTk1NTc5Mzc2","html_url":"https://github.com/timminata/GTFS/pull/16","diff_url":"https://github.com/timminata/GTFS/pull/16.diff","patch_url":"https://github.com/timminata/GTFS/pull/16.patch","issue_url":"https://api.github.com/repos/timminata/GTFS/issues/16","number":16,"state":"open","locked":false,"title":"various things","user":{"login":"peetjvv","id":22648295,"node_id":"MDQ6VXNlcjIyNjQ4Mjk1","avatar_url":"https://avatars1.githubusercontent.com/u/22648295?v=4","gravatar_id":"","url":"https://api.github.com/users/peetjvv","html_url":"https://github.com/peetjvv","followers_url":"https://api.github.com/users/peetjvv/followers","following_url":"https://api.github.com/users/peetjvv/following{/other_user}","gists_url":"https://api.github.com/users/peetjvv/gists{/gist_id}","starred_url":"https://api.github.com/users/peetjvv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peetjvv/subscriptions","organizations_url":"https://api.github.com/users/peetjvv/orgs","repos_url":"https://api.github.com/users/peetjvv/repos","events_url":"https://api.github.com/users/peetjvv/events{/privacy}","received_events_url":"https://api.github.com/users/peetjvv/received_events","type":"User","site_admin":false},"body":" - more getids methods - probably included in the last Cap release by accident\r\n - fixed the sql params limit reached bug by splitting the request into groups of just under 1000 entities\r\n - ordering the stoptimes responses from postgres","created_at":"2018-06-18T16:22:33Z","updated_at":"2018-06-19T08:32:15Z","closed_at":null,"merged_at":null,"merge_commit_sha":"ec40227f71d3cf2926dc5d96751234aab898060b","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/timminata/GTFS/pulls/16/commits","review_comments_url":"https://api.github.com/repos/timminata/GTFS/pulls/16/comments","review_comment_url":"https://api.github.com/repos/timminata/GTFS/pulls/comments{/number}","comments_url":"https://api.github.com/repos/timminata/GTFS/issues/16/comments","statuses_url":"https://api.github.com/repos/timminata/GTFS/statuses/d16d2fa38489e58da930fda82a358fde31cfc452","head":{"label":"timminata:fixes/postgres-sql-calls-fixes","ref":"fixes/postgres-sql-calls-fixes","sha":"d16d2fa38489e58da930fda82a358fde31cfc452","user":{"login":"timminata","id":356092,"node_id":"MDQ6VXNlcjM1NjA5Mg==","avatar_url":"https://avatars0.githubusercontent.com/u/356092?v=4","gravatar_id":"","url":"https://api.github.com/users/timminata","html_url":"https://github.com/timminata","followers_url":"https://api.github.com/users/timminata/followers","following_url":"https://api.github.com/users/timminata/following{/other_user}","gists_url":"https://api.github.com/users/timminata/gists{/gist_id}","starred_url":"https://api.github.com/users/timminata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timminata/subscriptions","organizations_url":"https://api.github.com/users/timminata/orgs","repos_url":"https://api.github.com/users/timminata/repos","events_url":"https://api.github.com/users/timminata/events{/privacy}","received_events_url":"https://api.github.com/users/timminata/received_events","type":"User","site_admin":false},"repo":{"id":67799499,"node_id":"MDEwOlJlcG9zaXRvcnk2Nzc5OTQ5OQ==","name":"GTFS","full_name":"timminata/GTFS","owner":{"login":"timminata","id":356092,"node_id":"MDQ6VXNlcjM1NjA5Mg==","avatar_url":"https://avatars0.githubusercontent.com/u/356092?v=4","gravatar_id":"","url":"https://api.github.com/users/timminata","html_url":"https://github.com/timminata","followers_url":"https://api.github.com/users/timminata/followers","following_url":"https://api.github.com/users/timminata/following{/other_user}","gists_url":"https://api.github.com/users/timminata/gists{/gist_id}","starred_url":"https://api.github.com/users/timminata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timminata/subscriptions","organizations_url":"https://api.github.com/users/timminata/orgs","repos_url":"https://api.github.com/users/timminata/repos","events_url":"https://api.github.com/users/timminata/events{/privacy}","received_events_url":"https://api.github.com/users/timminata/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/timminata/GTFS","description":".Net/Mono implementation of a General Transit Feed Specification (GTFS) feed parser.","fork":true,"url":"https://api.github.com/repos/timminata/GTFS","forks_url":"https://api.github.com/repos/timminata/GTFS/forks","keys_url":"https://api.github.com/repos/timminata/GTFS/keys{/key_id}","collaborators_url":"https://api.github.com/repos/timminata/GTFS/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/timminata/GTFS/teams","hooks_url":"https://api.github.com/repos/timminata/GTFS/hooks","issue_events_url":"https://api.github.com/repos/timminata/GTFS/issues/events{/number}","events_url":"https://api.github.com/repos/timminata/GTFS/events","assignees_url":"https://api.github.com/repos/timminata/GTFS/assignees{/user}","branches_url":"https://api.github.com/repos/timminata/GTFS/branches{/branch}","tags_url":"https://api.github.com/repos/timminata/GTFS/tags","blobs_url":"https://api.github.com/repos/timminata/GTFS/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/timminata/GTFS/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/timminata/GTFS/git/refs{/sha}","trees_url":"https://api.github.com/repos/timminata/GTFS/git/trees{/sha}","statuses_url":"https://api.github.com/repos/timminata/GTFS/statuses/{sha}","languages_url":"https://api.github.com/repos/timminata/GTFS/languages","stargazers_url":"https://api.github.com/repos/timminata/GTFS/stargazers","contributors_url":"https://api.github.com/repos/timminata/GTFS/contributors","subscribers_url":"https://api.github.com/repos/timminata/GTFS/subscribers","subscription_url":"https://api.github.com/repos/timminata/GTFS/subscription","commits_url":"https://api.github.com/repos/timminata/GTFS/commits{/sha}","git_commits_url":"https://api.github.com/repos/timminata/GTFS/git/commits{/sha}","comments_url":"https://api.github.com/repos/timminata/GTFS/comments{/number}","issue_comment_url":"https://api.github.com/repos/timminata/GTFS/issues/comments{/number}","contents_url":"https://api.github.com/repos/timminata/GTFS/contents/{+path}","compare_url":"https://api.github.com/repos/timminata/GTFS/compare/{base}...{head}","merges_url":"https://api.github.com/repos/timminata/GTFS/merges","archive_url":"https://api.github.com/repos/timminata/GTFS/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/timminata/GTFS/downloads","issues_url":"https://api.github.com/repos/timminata/GTFS/issues{/number}","pulls_url":"https://api.github.com/repos/timminata/GTFS/pulls{/number}","milestones_url":"https://api.github.com/repos/timminata/GTFS/milestones{/number}","notifications_url":"https://api.github.com/repos/timminata/GTFS/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/timminata/GTFS/labels{/name}","releases_url":"https://api.github.com/repos/timminata/GTFS/releases{/id}","deployments_url":"https://api.github.com/repos/timminata/GTFS/deployments","created_at":"2016-09-09T13:04:33Z","updated_at":"2016-09-09T13:04:34Z","pushed_at":"2018-06-19T08:32:05Z","git_url":"git://github.com/timminata/GTFS.git","ssh_url":"git@github.com:timminata/GTFS.git","clone_url":"https://github.com/timminata/GTFS.git","svn_url":"https://github.com/timminata/GTFS","homepage":"","size":17661,"stargazers_count":0,"watchers_count":0,"language":"C#","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":1,"license":{"key":"mit","name":"MIT License","spdx_id":"MIT","url":"https://api.github.com/licenses/mit","node_id":"MDc6TGljZW5zZTEz"},"forks":0,"open_issues":1,"watchers":0,"default_branch":"develop"}},"base":{"label":"timminata:master","ref":"master","sha":"cef9c2a80387cee99afca715c426d9a048a25e9b","user":{"login":"timminata","id":356092,"node_id":"MDQ6VXNlcjM1NjA5Mg==","avatar_url":"https://avatars0.githubusercontent.com/u/356092?v=4","gravatar_id":"","url":"https://api.github.com/users/timminata","html_url":"https://github.com/timminata","followers_url":"https://api.github.com/users/timminata/followers","following_url":"https://api.github.com/users/timminata/following{/other_user}","gists_url":"https://api.github.com/users/timminata/gists{/gist_id}","starred_url":"https://api.github.com/users/timminata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timminata/subscriptions","organizations_url":"https://api.github.com/users/timminata/orgs","repos_url":"https://api.github.com/users/timminata/repos","events_url":"https://api.github.com/users/timminata/events{/privacy}","received_events_url":"https://api.github.com/users/timminata/received_events","type":"User","site_admin":false},"repo":{"id":67799499,"node_id":"MDEwOlJlcG9zaXRvcnk2Nzc5OTQ5OQ==","name":"GTFS","full_name":"timminata/GTFS","owner":{"login":"timminata","id":356092,"node_id":"MDQ6VXNlcjM1NjA5Mg==","avatar_url":"https://avatars0.githubusercontent.com/u/356092?v=4","gravatar_id":"","url":"https://api.github.com/users/timminata","html_url":"https://github.com/timminata","followers_url":"https://api.github.com/users/timminata/followers","following_url":"https://api.github.com/users/timminata/following{/other_user}","gists_url":"https://api.github.com/users/timminata/gists{/gist_id}","starred_url":"https://api.github.com/users/timminata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timminata/subscriptions","organizations_url":"https://api.github.com/users/timminata/orgs","repos_url":"https://api.github.com/users/timminata/repos","events_url":"https://api.github.com/users/timminata/events{/privacy}","received_events_url":"https://api.github.com/users/timminata/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/timminata/GTFS","description":".Net/Mono implementation of a General Transit Feed Specification (GTFS) feed parser.","fork":true,"url":"https://api.github.com/repos/timminata/GTFS","forks_url":"https://api.github.com/repos/timminata/GTFS/forks","keys_url":"https://api.github.com/repos/timminata/GTFS/keys{/key_id}","collaborators_url":"https://api.github.com/repos/timminata/GTFS/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/timminata/GTFS/teams","hooks_url":"https://api.github.com/repos/timminata/GTFS/hooks","issue_events_url":"https://api.github.com/repos/timminata/GTFS/issues/events{/number}","events_url":"https://api.github.com/repos/timminata/GTFS/events","assignees_url":"https://api.github.com/repos/timminata/GTFS/assignees{/user}","branches_url":"https://api.github.com/repos/timminata/GTFS/branches{/branch}","tags_url":"https://api.github.com/repos/timminata/GTFS/tags","blobs_url":"https://api.github.com/repos/timminata/GTFS/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/timminata/GTFS/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/timminata/GTFS/git/refs{/sha}","trees_url":"https://api.github.com/repos/timminata/GTFS/git/trees{/sha}","statuses_url":"https://api.github.com/repos/timminata/GTFS/statuses/{sha}","languages_url":"https://api.github.com/repos/timminata/GTFS/languages","stargazers_url":"https://api.github.com/repos/timminata/GTFS/stargazers","contributors_url":"https://api.github.com/repos/timminata/GTFS/contributors","subscribers_url":"https://api.github.com/repos/timminata/GTFS/subscribers","subscription_url":"https://api.github.com/repos/timminata/GTFS/subscription","commits_url":"https://api.github.com/repos/timminata/GTFS/commits{/sha}","git_commits_url":"https://api.github.com/repos/timminata/GTFS/git/commits{/sha}","comments_url":"https://api.github.com/repos/timminata/GTFS/comments{/number}","issue_comment_url":"https://api.github.com/repos/timminata/GTFS/issues/comments{/number}","contents_url":"https://api.github.com/repos/timminata/GTFS/contents/{+path}","compare_url":"https://api.github.com/repos/timminata/GTFS/compare/{base}...{head}","merges_url":"https://api.github.com/repos/timminata/GTFS/merges","archive_url":"https://api.github.com/repos/timminata/GTFS/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/timminata/GTFS/downloads","issues_url":"https://api.github.com/repos/timminata/GTFS/issues{/number}","pulls_url":"https://api.github.com/repos/timminata/GTFS/pulls{/number}","milestones_url":"https://api.github.com/repos/timminata/GTFS/milestones{/number}","notifications_url":"https://api.github.com/repos/timminata/GTFS/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/timminata/GTFS/labels{/name}","releases_url":"https://api.github.com/repos/timminata/GTFS/releases{/id}","deployments_url":"https://api.github.com/repos/timminata/GTFS/deployments","created_at":"2016-09-09T13:04:33Z","updated_at":"2016-09-09T13:04:34Z","pushed_at":"2018-06-19T08:32:05Z","git_url":"git://github.com/timminata/GTFS.git","ssh_url":"git@github.com:timminata/GTFS.git","clone_url":"https://github.com/timminata/GTFS.git","svn_url":"https://github.com/timminata/GTFS","homepage":"","size":17661,"stargazers_count":0,"watchers_count":0,"language":"C#","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":1,"license":{"key":"mit","name":"MIT License","spdx_id":"MIT","url":"https://api.github.com/licenses/mit","node_id":"MDc6TGljZW5zZTEz"},"forks":0,"open_issues":1,"watchers":0,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/timminata/GTFS/pulls/16"},"html":{"href":"https://github.com/timminata/GTFS/pull/16"},"issue":{"href":"https://api.github.com/repos/timminata/GTFS/issues/16"},"comments":{"href":"https://api.github.com/repos/timminata/GTFS/issues/16/comments"},"review_comments":{"href":"https://api.github.com/repos/timminata/GTFS/pulls/16/comments"},"review_comment":{"href":"https://api.github.com/repos/timminata/GTFS/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/timminata/GTFS/pulls/16/commits"},"statuses":{"href":"https://api.github.com/repos/timminata/GTFS/statuses/d16d2fa38489e58da930fda82a358fde31cfc452"}},"author_association":"COLLABORATOR"}}
{"actor":{"display_login":"peetjvv"}}