{"action":"closed","number":2572,"pull_request":{"url":"https://api.github.com/repos/LMFDB/lmfdb/pulls/2572","id":209300235,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA5MzAwMjM1","html_url":"https://github.com/LMFDB/lmfdb/pull/2572","diff_url":"https://github.com/LMFDB/lmfdb/pull/2572.diff","patch_url":"https://github.com/LMFDB/lmfdb/pull/2572.patch","issue_url":"https://api.github.com/repos/LMFDB/lmfdb/issues/2572","number":2572,"state":"closed","locked":false,"title":"Postgres","user":{"login":"roed314","id":22795,"node_id":"MDQ6VXNlcjIyNzk1","avatar_url":"https://avatars3.githubusercontent.com/u/22795?v=4","gravatar_id":"","url":"https://api.github.com/users/roed314","html_url":"https://github.com/roed314","followers_url":"https://api.github.com/users/roed314/followers","following_url":"https://api.github.com/users/roed314/following{/other_user}","gists_url":"https://api.github.com/users/roed314/gists{/gist_id}","starred_url":"https://api.github.com/users/roed314/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roed314/subscriptions","organizations_url":"https://api.github.com/users/roed314/orgs","repos_url":"https://api.github.com/users/roed314/repos","events_url":"https://api.github.com/users/roed314/events{/privacy}","received_events_url":"https://api.github.com/users/roed314/received_events","type":"User","site_admin":false},"body":"Changelog:\r\n* Factored out common functionality from search functions to a new `search_wrapper.py` file, using it to give a better timeout warning.\r\n* Updated documentation in `GettingStarted.md` and `Postgres_FAQ.md`.\r\n* Change format for `copy_from` and `reload` to require header lines.\r\n* Added `adjust_schema` option to `reload`, easing ability to push schema changes to prod.\r\n* Add `label_col` option to `lookup` method.\r\n* Reduce number of database calls at startup.\r\n* Add ability to undo a `reload` or `rewrite` operation.\r\n* Require editors to log in (or add a line to their `config.ini`), then include their username in a new log of high-level changes (stored in the `userdb.dbrecord` table).","created_at":"2018-08-18T07:45:55Z","updated_at":"2018-08-18T13:52:32Z","closed_at":"2018-08-18T13:52:31Z","merged_at":"2018-08-18T13:52:31Z","merge_commit_sha":"bbdd49134d833fea95c6c6d85de20634111677e3","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/LMFDB/lmfdb/pulls/2572/commits","review_comments_url":"https://api.github.com/repos/LMFDB/lmfdb/pulls/2572/comments","review_comment_url":"https://api.github.com/repos/LMFDB/lmfdb/pulls/comments{/number}","comments_url":"https://api.github.com/repos/LMFDB/lmfdb/issues/2572/comments","statuses_url":"https://api.github.com/repos/LMFDB/lmfdb/statuses/64bfd8edfbb1585ad5d08473377f809b94a8cb98","head":{"label":"roed314:postgres","ref":"postgres","sha":"64bfd8edfbb1585ad5d08473377f809b94a8cb98","user":{"login":"roed314","id":22795,"node_id":"MDQ6VXNlcjIyNzk1","avatar_url":"https://avatars3.githubusercontent.com/u/22795?v=4","gravatar_id":"","url":"https://api.github.com/users/roed314","html_url":"https://github.com/roed314","followers_url":"https://api.github.com/users/roed314/followers","following_url":"https://api.github.com/users/roed314/following{/other_user}","gists_url":"https://api.github.com/users/roed314/gists{/gist_id}","starred_url":"https://api.github.com/users/roed314/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roed314/subscriptions","organizations_url":"https://api.github.com/users/roed314/orgs","repos_url":"https://api.github.com/users/roed314/repos","events_url":"https://api.github.com/users/roed314/events{/privacy}","received_events_url":"https://api.github.com/users/roed314/received_events","type":"User","site_admin":false},"repo":{"id":39801889,"node_id":"MDEwOlJlcG9zaXRvcnkzOTgwMTg4OQ==","name":"lmfdb","full_name":"roed314/lmfdb","owner":{"login":"roed314","id":22795,"node_id":"MDQ6VXNlcjIyNzk1","avatar_url":"https://avatars3.githubusercontent.com/u/22795?v=4","gravatar_id":"","url":"https://api.github.com/users/roed314","html_url":"https://github.com/roed314","followers_url":"https://api.github.com/users/roed314/followers","following_url":"https://api.github.com/users/roed314/following{/other_user}","gists_url":"https://api.github.com/users/roed314/gists{/gist_id}","starred_url":"https://api.github.com/users/roed314/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roed314/subscriptions","organizations_url":"https://api.github.com/users/roed314/orgs","repos_url":"https://api.github.com/users/roed314/repos","events_url":"https://api.github.com/users/roed314/events{/privacy}","received_events_url":"https://api.github.com/users/roed314/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/roed314/lmfdb","description":"L-Functions and Modular Forms Database","fork":true,"url":"https://api.github.com/repos/roed314/lmfdb","forks_url":"https://api.github.com/repos/roed314/lmfdb/forks","keys_url":"https://api.github.com/repos/roed314/lmfdb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/roed314/lmfdb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/roed314/lmfdb/teams","hooks_url":"https://api.github.com/repos/roed314/lmfdb/hooks","issue_events_url":"https://api.github.com/repos/roed314/lmfdb/issues/events{/number}","events_url":"https://api.github.com/repos/roed314/lmfdb/events","assignees_url":"https://api.github.com/repos/roed314/lmfdb/assignees{/user}","branches_url":"https://api.github.com/repos/roed314/lmfdb/branches{/branch}","tags_url":"https://api.github.com/repos/roed314/lmfdb/tags","blobs_url":"https://api.github.com/repos/roed314/lmfdb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/roed314/lmfdb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/roed314/lmfdb/git/refs{/sha}","trees_url":"https://api.github.com/repos/roed314/lmfdb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/roed314/lmfdb/statuses/{sha}","languages_url":"https://api.github.com/repos/roed314/lmfdb/languages","stargazers_url":"https://api.github.com/repos/roed314/lmfdb/stargazers","contributors_url":"https://api.github.com/repos/roed314/lmfdb/contributors","subscribers_url":"https://api.github.com/repos/roed314/lmfdb/subscribers","subscription_url":"https://api.github.com/repos/roed314/lmfdb/subscription","commits_url":"https://api.github.com/repos/roed314/lmfdb/commits{/sha}","git_commits_url":"https://api.github.com/repos/roed314/lmfdb/git/commits{/sha}","comments_url":"https://api.github.com/repos/roed314/lmfdb/comments{/number}","issue_comment_url":"https://api.github.com/repos/roed314/lmfdb/issues/comments{/number}","contents_url":"https://api.github.com/repos/roed314/lmfdb/contents/{+path}","compare_url":"https://api.github.com/repos/roed314/lmfdb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/roed314/lmfdb/merges","archive_url":"https://api.github.com/repos/roed314/lmfdb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/roed314/lmfdb/downloads","issues_url":"https://api.github.com/repos/roed314/lmfdb/issues{/number}","pulls_url":"https://api.github.com/repos/roed314/lmfdb/pulls{/number}","milestones_url":"https://api.github.com/repos/roed314/lmfdb/milestones{/number}","notifications_url":"https://api.github.com/repos/roed314/lmfdb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/roed314/lmfdb/labels{/name}","releases_url":"https://api.github.com/repos/roed314/lmfdb/releases{/id}","deployments_url":"https://api.github.com/repos/roed314/lmfdb/deployments","created_at":"2015-07-27T22:56:31Z","updated_at":"2016-03-25T15:48:05Z","pushed_at":"2018-08-18T07:39:58Z","git_url":"git://github.com/roed314/lmfdb.git","ssh_url":"git@github.com:roed314/lmfdb.git","clone_url":"https://github.com/roed314/lmfdb.git","svn_url":"https://github.com/roed314/lmfdb","homepage":null,"size":22712,"stargazers_count":0,"watchers_count":0,"language":"Python","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,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"LMFDB:master","ref":"master","sha":"837e246694a94267025084c2f75f9ecfc383251f","user":{"login":"LMFDB","id":3043016,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMwNDMwMTY=","avatar_url":"https://avatars0.githubusercontent.com/u/3043016?v=4","gravatar_id":"","url":"https://api.github.com/users/LMFDB","html_url":"https://github.com/LMFDB","followers_url":"https://api.github.com/users/LMFDB/followers","following_url":"https://api.github.com/users/LMFDB/following{/other_user}","gists_url":"https://api.github.com/users/LMFDB/gists{/gist_id}","starred_url":"https://api.github.com/users/LMFDB/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LMFDB/subscriptions","organizations_url":"https://api.github.com/users/LMFDB/orgs","repos_url":"https://api.github.com/users/LMFDB/repos","events_url":"https://api.github.com/users/LMFDB/events{/privacy}","received_events_url":"https://api.github.com/users/LMFDB/received_events","type":"Organization","site_admin":false},"repo":{"id":7166369,"node_id":"MDEwOlJlcG9zaXRvcnk3MTY2MzY5","name":"lmfdb","full_name":"LMFDB/lmfdb","owner":{"login":"LMFDB","id":3043016,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMwNDMwMTY=","avatar_url":"https://avatars0.githubusercontent.com/u/3043016?v=4","gravatar_id":"","url":"https://api.github.com/users/LMFDB","html_url":"https://github.com/LMFDB","followers_url":"https://api.github.com/users/LMFDB/followers","following_url":"https://api.github.com/users/LMFDB/following{/other_user}","gists_url":"https://api.github.com/users/LMFDB/gists{/gist_id}","starred_url":"https://api.github.com/users/LMFDB/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LMFDB/subscriptions","organizations_url":"https://api.github.com/users/LMFDB/orgs","repos_url":"https://api.github.com/users/LMFDB/repos","events_url":"https://api.github.com/users/LMFDB/events{/privacy}","received_events_url":"https://api.github.com/users/LMFDB/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/LMFDB/lmfdb","description":"L-Functions and Modular Forms Database","fork":false,"url":"https://api.github.com/repos/LMFDB/lmfdb","forks_url":"https://api.github.com/repos/LMFDB/lmfdb/forks","keys_url":"https://api.github.com/repos/LMFDB/lmfdb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/LMFDB/lmfdb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/LMFDB/lmfdb/teams","hooks_url":"https://api.github.com/repos/LMFDB/lmfdb/hooks","issue_events_url":"https://api.github.com/repos/LMFDB/lmfdb/issues/events{/number}","events_url":"https://api.github.com/repos/LMFDB/lmfdb/events","assignees_url":"https://api.github.com/repos/LMFDB/lmfdb/assignees{/user}","branches_url":"https://api.github.com/repos/LMFDB/lmfdb/branches{/branch}","tags_url":"https://api.github.com/repos/LMFDB/lmfdb/tags","blobs_url":"https://api.github.com/repos/LMFDB/lmfdb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/LMFDB/lmfdb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/LMFDB/lmfdb/git/refs{/sha}","trees_url":"https://api.github.com/repos/LMFDB/lmfdb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/LMFDB/lmfdb/statuses/{sha}","languages_url":"https://api.github.com/repos/LMFDB/lmfdb/languages","stargazers_url":"https://api.github.com/repos/LMFDB/lmfdb/stargazers","contributors_url":"https://api.github.com/repos/LMFDB/lmfdb/contributors","subscribers_url":"https://api.github.com/repos/LMFDB/lmfdb/subscribers","subscription_url":"https://api.github.com/repos/LMFDB/lmfdb/subscription","commits_url":"https://api.github.com/repos/LMFDB/lmfdb/commits{/sha}","git_commits_url":"https://api.github.com/repos/LMFDB/lmfdb/git/commits{/sha}","comments_url":"https://api.github.com/repos/LMFDB/lmfdb/comments{/number}","issue_comment_url":"https://api.github.com/repos/LMFDB/lmfdb/issues/comments{/number}","contents_url":"https://api.github.com/repos/LMFDB/lmfdb/contents/{+path}","compare_url":"https://api.github.com/repos/LMFDB/lmfdb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/LMFDB/lmfdb/merges","archive_url":"https://api.github.com/repos/LMFDB/lmfdb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/LMFDB/lmfdb/downloads","issues_url":"https://api.github.com/repos/LMFDB/lmfdb/issues{/number}","pulls_url":"https://api.github.com/repos/LMFDB/lmfdb/pulls{/number}","milestones_url":"https://api.github.com/repos/LMFDB/lmfdb/milestones{/number}","notifications_url":"https://api.github.com/repos/LMFDB/lmfdb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/LMFDB/lmfdb/labels{/name}","releases_url":"https://api.github.com/repos/LMFDB/lmfdb/releases{/id}","deployments_url":"https://api.github.com/repos/LMFDB/lmfdb/deployments","created_at":"2012-12-14T14:09:00Z","updated_at":"2018-08-17T02:13:57Z","pushed_at":"2018-08-18T13:52:31Z","git_url":"git://github.com/LMFDB/lmfdb.git","ssh_url":"git@github.com:LMFDB/lmfdb.git","clone_url":"https://github.com/LMFDB/lmfdb.git","svn_url":"https://github.com/LMFDB/lmfdb","homepage":null,"size":22613,"stargazers_count":139,"watchers_count":139,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":115,"mirror_url":null,"archived":false,"open_issues_count":188,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":115,"open_issues":188,"watchers":139,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/LMFDB/lmfdb/pulls/2572"},"html":{"href":"https://github.com/LMFDB/lmfdb/pull/2572"},"issue":{"href":"https://api.github.com/repos/LMFDB/lmfdb/issues/2572"},"comments":{"href":"https://api.github.com/repos/LMFDB/lmfdb/issues/2572/comments"},"review_comments":{"href":"https://api.github.com/repos/LMFDB/lmfdb/pulls/2572/comments"},"review_comment":{"href":"https://api.github.com/repos/LMFDB/lmfdb/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/LMFDB/lmfdb/pulls/2572/commits"},"statuses":{"href":"https://api.github.com/repos/LMFDB/lmfdb/statuses/64bfd8edfbb1585ad5d08473377f809b94a8cb98"}},"author_association":"CONTRIBUTOR","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"AndrewVSutherland","id":11425002,"node_id":"MDQ6VXNlcjExNDI1MDAy","avatar_url":"https://avatars3.githubusercontent.com/u/11425002?v=4","gravatar_id":"","url":"https://api.github.com/users/AndrewVSutherland","html_url":"https://github.com/AndrewVSutherland","followers_url":"https://api.github.com/users/AndrewVSutherland/followers","following_url":"https://api.github.com/users/AndrewVSutherland/following{/other_user}","gists_url":"https://api.github.com/users/AndrewVSutherland/gists{/gist_id}","starred_url":"https://api.github.com/users/AndrewVSutherland/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AndrewVSutherland/subscriptions","organizations_url":"https://api.github.com/users/AndrewVSutherland/orgs","repos_url":"https://api.github.com/users/AndrewVSutherland/repos","events_url":"https://api.github.com/users/AndrewVSutherland/events{/privacy}","received_events_url":"https://api.github.com/users/AndrewVSutherland/received_events","type":"User","site_admin":false},"comments":1,"review_comments":0,"maintainer_can_modify":false,"commits":14,"additions":1902,"deletions":1835,"changed_files":45}}
{"actor":{"display_login":"AndrewVSutherland"}}