{"action":"closed","number":3,"pull_request":{"url":"https://api.github.com/repos/andela/ah-olympians/pulls/3","id":256202359,"node_id":"MDExOlB1bGxSZXF1ZXN0MjU2MjAyMzU5","html_url":"https://github.com/andela/ah-olympians/pull/3","diff_url":"https://github.com/andela/ah-olympians/pull/3.diff","patch_url":"https://github.com/andela/ah-olympians/pull/3.patch","issue_url":"https://api.github.com/repos/andela/ah-olympians/issues/3","number":3,"state":"closed","locked":false,"title":"#164047053 setup django to use postgreSQL","user":{"login":"kevpy","id":5704600,"node_id":"MDQ6VXNlcjU3MDQ2MDA=","avatar_url":"https://avatars0.githubusercontent.com/u/5704600?v=4","gravatar_id":"","url":"https://api.github.com/users/kevpy","html_url":"https://github.com/kevpy","followers_url":"https://api.github.com/users/kevpy/followers","following_url":"https://api.github.com/users/kevpy/following{/other_user}","gists_url":"https://api.github.com/users/kevpy/gists{/gist_id}","starred_url":"https://api.github.com/users/kevpy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kevpy/subscriptions","organizations_url":"https://api.github.com/users/kevpy/orgs","repos_url":"https://api.github.com/users/kevpy/repos","events_url":"https://api.github.com/users/kevpy/events{/privacy}","received_events_url":"https://api.github.com/users/kevpy/received_events","type":"User","site_admin":false},"body":"#### What does this PR do\r\nSet up [ah-olympians](https://github.com/andela/ah-olympians) to use postgreSQL database\r\n\r\n#### Description of Task to be completed?\r\n- Setup postgreSQL database engine as the default engine\r\n- Remove SQLite3 database engine from being the default engine\r\n- Add .env.example as an example .env file for database environment configuration  \r\n\r\n#### How should this be manually tested?\r\n- Pull the branch `git fetch ch-set-up-postgresql-164047053`\r\n- Install the dependencies `pip install -r requirements.txt`\r\n- Ensure you have a running postgreSQL database instance running.\r\n- Create a database on postgres. \r\n- Create a `.env` file with the database configs as shown in the `.env.example` file. \r\n- Export the `.env` file with `source .env`\r\n- Make migrations `python manage.py makemigrations` on `ah-olympians` root folder\r\n- Run database migrations with `python manage.py migrate`\r\n- Run the application instance with `python manage.py runserver`\r\n\r\n#### Any background context you want to provide?\r\n- Every Django application comes with `SQLite3` as the default database engine setup\r\n\r\n#### What are the relevant pivotal tracker stories?\r\n- [#164047053](https://www.pivotaltracker.com/story/show/164047053)\r\n","created_at":"2019-02-26T09:24:02Z","updated_at":"2019-02-26T15:04:34Z","closed_at":"2019-02-26T15:04:34Z","merged_at":"2019-02-26T15:04:34Z","merge_commit_sha":"4a8f9132dce1c516dc60ea1d8615ba7f7d572881","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/andela/ah-olympians/pulls/3/commits","review_comments_url":"https://api.github.com/repos/andela/ah-olympians/pulls/3/comments","review_comment_url":"https://api.github.com/repos/andela/ah-olympians/pulls/comments{/number}","comments_url":"https://api.github.com/repos/andela/ah-olympians/issues/3/comments","statuses_url":"https://api.github.com/repos/andela/ah-olympians/statuses/37c68f0064801b23b3e747fa993736ca6bba206b","head":{"label":"andela:ch-set-up-postgresql-164047053","ref":"ch-set-up-postgresql-164047053","sha":"37c68f0064801b23b3e747fa993736ca6bba206b","user":{"login":"andela","id":4100206,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQxMDAyMDY=","avatar_url":"https://avatars2.githubusercontent.com/u/4100206?v=4","gravatar_id":"","url":"https://api.github.com/users/andela","html_url":"https://github.com/andela","followers_url":"https://api.github.com/users/andela/followers","following_url":"https://api.github.com/users/andela/following{/other_user}","gists_url":"https://api.github.com/users/andela/gists{/gist_id}","starred_url":"https://api.github.com/users/andela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andela/subscriptions","organizations_url":"https://api.github.com/users/andela/orgs","repos_url":"https://api.github.com/users/andela/repos","events_url":"https://api.github.com/users/andela/events{/privacy}","received_events_url":"https://api.github.com/users/andela/received_events","type":"Organization","site_admin":false},"repo":{"id":170839139,"node_id":"MDEwOlJlcG9zaXRvcnkxNzA4MzkxMzk=","name":"ah-olympians","full_name":"andela/ah-olympians","private":false,"owner":{"login":"andela","id":4100206,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQxMDAyMDY=","avatar_url":"https://avatars2.githubusercontent.com/u/4100206?v=4","gravatar_id":"","url":"https://api.github.com/users/andela","html_url":"https://github.com/andela","followers_url":"https://api.github.com/users/andela/followers","following_url":"https://api.github.com/users/andela/following{/other_user}","gists_url":"https://api.github.com/users/andela/gists{/gist_id}","starred_url":"https://api.github.com/users/andela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andela/subscriptions","organizations_url":"https://api.github.com/users/andela/orgs","repos_url":"https://api.github.com/users/andela/repos","events_url":"https://api.github.com/users/andela/events{/privacy}","received_events_url":"https://api.github.com/users/andela/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/andela/ah-olympians","description":null,"fork":false,"url":"https://api.github.com/repos/andela/ah-olympians","forks_url":"https://api.github.com/repos/andela/ah-olympians/forks","keys_url":"https://api.github.com/repos/andela/ah-olympians/keys{/key_id}","collaborators_url":"https://api.github.com/repos/andela/ah-olympians/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/andela/ah-olympians/teams","hooks_url":"https://api.github.com/repos/andela/ah-olympians/hooks","issue_events_url":"https://api.github.com/repos/andela/ah-olympians/issues/events{/number}","events_url":"https://api.github.com/repos/andela/ah-olympians/events","assignees_url":"https://api.github.com/repos/andela/ah-olympians/assignees{/user}","branches_url":"https://api.github.com/repos/andela/ah-olympians/branches{/branch}","tags_url":"https://api.github.com/repos/andela/ah-olympians/tags","blobs_url":"https://api.github.com/repos/andela/ah-olympians/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/andela/ah-olympians/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/andela/ah-olympians/git/refs{/sha}","trees_url":"https://api.github.com/repos/andela/ah-olympians/git/trees{/sha}","statuses_url":"https://api.github.com/repos/andela/ah-olympians/statuses/{sha}","languages_url":"https://api.github.com/repos/andela/ah-olympians/languages","stargazers_url":"https://api.github.com/repos/andela/ah-olympians/stargazers","contributors_url":"https://api.github.com/repos/andela/ah-olympians/contributors","subscribers_url":"https://api.github.com/repos/andela/ah-olympians/subscribers","subscription_url":"https://api.github.com/repos/andela/ah-olympians/subscription","commits_url":"https://api.github.com/repos/andela/ah-olympians/commits{/sha}","git_commits_url":"https://api.github.com/repos/andela/ah-olympians/git/commits{/sha}","comments_url":"https://api.github.com/repos/andela/ah-olympians/comments{/number}","issue_comment_url":"https://api.github.com/repos/andela/ah-olympians/issues/comments{/number}","contents_url":"https://api.github.com/repos/andela/ah-olympians/contents/{+path}","compare_url":"https://api.github.com/repos/andela/ah-olympians/compare/{base}...{head}","merges_url":"https://api.github.com/repos/andela/ah-olympians/merges","archive_url":"https://api.github.com/repos/andela/ah-olympians/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/andela/ah-olympians/downloads","issues_url":"https://api.github.com/repos/andela/ah-olympians/issues{/number}","pulls_url":"https://api.github.com/repos/andela/ah-olympians/pulls{/number}","milestones_url":"https://api.github.com/repos/andela/ah-olympians/milestones{/number}","notifications_url":"https://api.github.com/repos/andela/ah-olympians/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/andela/ah-olympians/labels{/name}","releases_url":"https://api.github.com/repos/andela/ah-olympians/releases{/id}","deployments_url":"https://api.github.com/repos/andela/ah-olympians/deployments","created_at":"2019-02-15T09:36:35Z","updated_at":"2019-02-26T12:42:05Z","pushed_at":"2019-02-26T15:04:34Z","git_url":"git://github.com/andela/ah-olympians.git","ssh_url":"git@github.com:andela/ah-olympians.git","clone_url":"https://github.com/andela/ah-olympians.git","svn_url":"https://github.com/andela/ah-olympians","homepage":null,"size":27,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":2,"license":{"key":"bsd-3-clause","name":"BSD 3-Clause \"New\" or \"Revised\" License","spdx_id":"BSD-3-Clause","url":"https://api.github.com/licenses/bsd-3-clause","node_id":"MDc6TGljZW5zZTU="},"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"base":{"label":"andela:master","ref":"master","sha":"69083123bce18eeff4bf0614ce7da64e1834864a","user":{"login":"andela","id":4100206,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQxMDAyMDY=","avatar_url":"https://avatars2.githubusercontent.com/u/4100206?v=4","gravatar_id":"","url":"https://api.github.com/users/andela","html_url":"https://github.com/andela","followers_url":"https://api.github.com/users/andela/followers","following_url":"https://api.github.com/users/andela/following{/other_user}","gists_url":"https://api.github.com/users/andela/gists{/gist_id}","starred_url":"https://api.github.com/users/andela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andela/subscriptions","organizations_url":"https://api.github.com/users/andela/orgs","repos_url":"https://api.github.com/users/andela/repos","events_url":"https://api.github.com/users/andela/events{/privacy}","received_events_url":"https://api.github.com/users/andela/received_events","type":"Organization","site_admin":false},"repo":{"id":170839139,"node_id":"MDEwOlJlcG9zaXRvcnkxNzA4MzkxMzk=","name":"ah-olympians","full_name":"andela/ah-olympians","private":false,"owner":{"login":"andela","id":4100206,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQxMDAyMDY=","avatar_url":"https://avatars2.githubusercontent.com/u/4100206?v=4","gravatar_id":"","url":"https://api.github.com/users/andela","html_url":"https://github.com/andela","followers_url":"https://api.github.com/users/andela/followers","following_url":"https://api.github.com/users/andela/following{/other_user}","gists_url":"https://api.github.com/users/andela/gists{/gist_id}","starred_url":"https://api.github.com/users/andela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andela/subscriptions","organizations_url":"https://api.github.com/users/andela/orgs","repos_url":"https://api.github.com/users/andela/repos","events_url":"https://api.github.com/users/andela/events{/privacy}","received_events_url":"https://api.github.com/users/andela/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/andela/ah-olympians","description":null,"fork":false,"url":"https://api.github.com/repos/andela/ah-olympians","forks_url":"https://api.github.com/repos/andela/ah-olympians/forks","keys_url":"https://api.github.com/repos/andela/ah-olympians/keys{/key_id}","collaborators_url":"https://api.github.com/repos/andela/ah-olympians/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/andela/ah-olympians/teams","hooks_url":"https://api.github.com/repos/andela/ah-olympians/hooks","issue_events_url":"https://api.github.com/repos/andela/ah-olympians/issues/events{/number}","events_url":"https://api.github.com/repos/andela/ah-olympians/events","assignees_url":"https://api.github.com/repos/andela/ah-olympians/assignees{/user}","branches_url":"https://api.github.com/repos/andela/ah-olympians/branches{/branch}","tags_url":"https://api.github.com/repos/andela/ah-olympians/tags","blobs_url":"https://api.github.com/repos/andela/ah-olympians/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/andela/ah-olympians/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/andela/ah-olympians/git/refs{/sha}","trees_url":"https://api.github.com/repos/andela/ah-olympians/git/trees{/sha}","statuses_url":"https://api.github.com/repos/andela/ah-olympians/statuses/{sha}","languages_url":"https://api.github.com/repos/andela/ah-olympians/languages","stargazers_url":"https://api.github.com/repos/andela/ah-olympians/stargazers","contributors_url":"https://api.github.com/repos/andela/ah-olympians/contributors","subscribers_url":"https://api.github.com/repos/andela/ah-olympians/subscribers","subscription_url":"https://api.github.com/repos/andela/ah-olympians/subscription","commits_url":"https://api.github.com/repos/andela/ah-olympians/commits{/sha}","git_commits_url":"https://api.github.com/repos/andela/ah-olympians/git/commits{/sha}","comments_url":"https://api.github.com/repos/andela/ah-olympians/comments{/number}","issue_comment_url":"https://api.github.com/repos/andela/ah-olympians/issues/comments{/number}","contents_url":"https://api.github.com/repos/andela/ah-olympians/contents/{+path}","compare_url":"https://api.github.com/repos/andela/ah-olympians/compare/{base}...{head}","merges_url":"https://api.github.com/repos/andela/ah-olympians/merges","archive_url":"https://api.github.com/repos/andela/ah-olympians/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/andela/ah-olympians/downloads","issues_url":"https://api.github.com/repos/andela/ah-olympians/issues{/number}","pulls_url":"https://api.github.com/repos/andela/ah-olympians/pulls{/number}","milestones_url":"https://api.github.com/repos/andela/ah-olympians/milestones{/number}","notifications_url":"https://api.github.com/repos/andela/ah-olympians/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/andela/ah-olympians/labels{/name}","releases_url":"https://api.github.com/repos/andela/ah-olympians/releases{/id}","deployments_url":"https://api.github.com/repos/andela/ah-olympians/deployments","created_at":"2019-02-15T09:36:35Z","updated_at":"2019-02-26T12:42:05Z","pushed_at":"2019-02-26T15:04:34Z","git_url":"git://github.com/andela/ah-olympians.git","ssh_url":"git@github.com:andela/ah-olympians.git","clone_url":"https://github.com/andela/ah-olympians.git","svn_url":"https://github.com/andela/ah-olympians","homepage":null,"size":27,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":2,"license":{"key":"bsd-3-clause","name":"BSD 3-Clause \"New\" or \"Revised\" License","spdx_id":"BSD-3-Clause","url":"https://api.github.com/licenses/bsd-3-clause","node_id":"MDc6TGljZW5zZTU="},"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/andela/ah-olympians/pulls/3"},"html":{"href":"https://github.com/andela/ah-olympians/pull/3"},"issue":{"href":"https://api.github.com/repos/andela/ah-olympians/issues/3"},"comments":{"href":"https://api.github.com/repos/andela/ah-olympians/issues/3/comments"},"review_comments":{"href":"https://api.github.com/repos/andela/ah-olympians/pulls/3/comments"},"review_comment":{"href":"https://api.github.com/repos/andela/ah-olympians/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/andela/ah-olympians/pulls/3/commits"},"statuses":{"href":"https://api.github.com/repos/andela/ah-olympians/statuses/37c68f0064801b23b3e747fa993736ca6bba206b"}},"author_association":"COLLABORATOR","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"JoanNgatia","id":13269579,"node_id":"MDQ6VXNlcjEzMjY5NTc5","avatar_url":"https://avatars0.githubusercontent.com/u/13269579?v=4","gravatar_id":"","url":"https://api.github.com/users/JoanNgatia","html_url":"https://github.com/JoanNgatia","followers_url":"https://api.github.com/users/JoanNgatia/followers","following_url":"https://api.github.com/users/JoanNgatia/following{/other_user}","gists_url":"https://api.github.com/users/JoanNgatia/gists{/gist_id}","starred_url":"https://api.github.com/users/JoanNgatia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JoanNgatia/subscriptions","organizations_url":"https://api.github.com/users/JoanNgatia/orgs","repos_url":"https://api.github.com/users/JoanNgatia/repos","events_url":"https://api.github.com/users/JoanNgatia/events{/privacy}","received_events_url":"https://api.github.com/users/JoanNgatia/received_events","type":"User","site_admin":false},"comments":2,"review_comments":1,"maintainer_can_modify":false,"commits":1,"additions":12,"deletions":3,"changed_files":3}}
{"actor":{"display_login":"JoanNgatia"}}