{"action":"created","comment":{"url":"https://api.github.com/repos/roundware/roundware-server/pulls/comments/57539344","id":57539344,"diff_hunk":"@@ -56,10 +57,16 @@ the installation process and run both schema and data migrations.\n  sudo su - postgres -c \"psql -c \\\"alter user round password 'round'\\\"\"\n  sudo su - postgres -c \"psql roundware -c 'create extension postgis'\"\n  ```\n-6. Run migration required for Postgres update: `python manage.py migrate`\n-7. Import dumped db from MySQL into Postgres db: `python manage.py loaddata rw-pre-postgres.json`\n-8. Update to most recent code including speaker polygon updates: `git checkout develop`\n-9. Deploy newest code (includes pip installs and db migrations): `sudo ./deploy.sh`\n+7. Deploy code again to run pip installs and minor migration in preparation for data import: `sudo ./deploy.sh`\n+8. Prepare database and import fixture\n+ 1. switch to `roundware` user in order to run `manage.py` commands: `sudo su roundware`\n+ 2. enter virtualenv: `source /var/www/roundware/bin/activate`\n+ 3. set PYTHONPATH: `export PYTHONPATH=/var/www/roundware/source/`\n+ 4. Flush database to enable import w/o errors (default pw: round - CHANGE!): `(roundware)roundware@rw-server:/var/www/roundware/source/roundware$ ./manage.py sqlflush | ./manage.py dbshell`\n+ 5. Load exported fixture: `./manage.py loaddata /path/to/rw-pre-postgres.json`\n+9. `deactivate` virtualenv and `exit` `roundware` user","path":"UPGRADING.md","position":41,"original_position":41,"commit_id":"1a6ddff7d27b9850bebd726d79b61c832efa2ac4","original_commit_id":"1a6ddff7d27b9850bebd726d79b61c832efa2ac4","user":{"login":"eosrei","id":195061,"avatar_url":"https://avatars.githubusercontent.com/u/195061?v=3","gravatar_id":"","url":"https://api.github.com/users/eosrei","html_url":"https://github.com/eosrei","followers_url":"https://api.github.com/users/eosrei/followers","following_url":"https://api.github.com/users/eosrei/following{/other_user}","gists_url":"https://api.github.com/users/eosrei/gists{/gist_id}","starred_url":"https://api.github.com/users/eosrei/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eosrei/subscriptions","organizations_url":"https://api.github.com/users/eosrei/orgs","repos_url":"https://api.github.com/users/eosrei/repos","events_url":"https://api.github.com/users/eosrei/events{/privacy}","received_events_url":"https://api.github.com/users/eosrei/received_events","type":"User","site_admin":false},"body":"Minor: No reason to deactivate","created_at":"2016-03-28T01:56:25Z","updated_at":"2016-03-28T01:56:25Z","html_url":"https://github.com/roundware/roundware-server/pull/276#discussion_r57539344","pull_request_url":"https://api.github.com/repos/roundware/roundware-server/pulls/276","_links":{"self":{"href":"https://api.github.com/repos/roundware/roundware-server/pulls/comments/57539344"},"html":{"href":"https://github.com/roundware/roundware-server/pull/276#discussion_r57539344"},"pull_request":{"href":"https://api.github.com/repos/roundware/roundware-server/pulls/276"}}},"pull_request":{"url":"https://api.github.com/repos/roundware/roundware-server/pulls/276","id":63892742,"html_url":"https://github.com/roundware/roundware-server/pull/276","diff_url":"https://github.com/roundware/roundware-server/pull/276.diff","patch_url":"https://github.com/roundware/roundware-server/pull/276.patch","issue_url":"https://api.github.com/repos/roundware/roundware-server/issues/276","number":276,"state":"open","locked":false,"title":"Various small updates","user":{"login":"hburgund","id":1714948,"avatar_url":"https://avatars.githubusercontent.com/u/1714948?v=3","gravatar_id":"","url":"https://api.github.com/users/hburgund","html_url":"https://github.com/hburgund","followers_url":"https://api.github.com/users/hburgund/followers","following_url":"https://api.github.com/users/hburgund/following{/other_user}","gists_url":"https://api.github.com/users/hburgund/gists{/gist_id}","starred_url":"https://api.github.com/users/hburgund/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hburgund/subscriptions","organizations_url":"https://api.github.com/users/hburgund/orgs","repos_url":"https://api.github.com/users/hburgund/repos","events_url":"https://api.github.com/users/hburgund/events{/privacy}","received_events_url":"https://api.github.com/users/hburgund/received_events","type":"User","site_admin":false},"body":"things that are not deserving of their own PRs; includes upgrade doc improvements, new default fixture and some admin adjustments","created_at":"2016-03-23T14:43:20Z","updated_at":"2016-03-28T01:56:25Z","closed_at":null,"merged_at":null,"merge_commit_sha":"c9c3b5774c35c719e57eb225a1ce78f2568ae327","assignee":{"login":"eosrei","id":195061,"avatar_url":"https://avatars.githubusercontent.com/u/195061?v=3","gravatar_id":"","url":"https://api.github.com/users/eosrei","html_url":"https://github.com/eosrei","followers_url":"https://api.github.com/users/eosrei/followers","following_url":"https://api.github.com/users/eosrei/following{/other_user}","gists_url":"https://api.github.com/users/eosrei/gists{/gist_id}","starred_url":"https://api.github.com/users/eosrei/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eosrei/subscriptions","organizations_url":"https://api.github.com/users/eosrei/orgs","repos_url":"https://api.github.com/users/eosrei/repos","events_url":"https://api.github.com/users/eosrei/events{/privacy}","received_events_url":"https://api.github.com/users/eosrei/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/roundware/roundware-server/pulls/276/commits","review_comments_url":"https://api.github.com/repos/roundware/roundware-server/pulls/276/comments","review_comment_url":"https://api.github.com/repos/roundware/roundware-server/pulls/comments{/number}","comments_url":"https://api.github.com/repos/roundware/roundware-server/issues/276/comments","statuses_url":"https://api.github.com/repos/roundware/roundware-server/statuses/1a6ddff7d27b9850bebd726d79b61c832efa2ac4","head":{"label":"hburgund:small-updates","ref":"small-updates","sha":"1a6ddff7d27b9850bebd726d79b61c832efa2ac4","user":{"login":"hburgund","id":1714948,"avatar_url":"https://avatars.githubusercontent.com/u/1714948?v=3","gravatar_id":"","url":"https://api.github.com/users/hburgund","html_url":"https://github.com/hburgund","followers_url":"https://api.github.com/users/hburgund/followers","following_url":"https://api.github.com/users/hburgund/following{/other_user}","gists_url":"https://api.github.com/users/hburgund/gists{/gist_id}","starred_url":"https://api.github.com/users/hburgund/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hburgund/subscriptions","organizations_url":"https://api.github.com/users/hburgund/orgs","repos_url":"https://api.github.com/users/hburgund/repos","events_url":"https://api.github.com/users/hburgund/events{/privacy}","received_events_url":"https://api.github.com/users/hburgund/received_events","type":"User","site_admin":false},"repo":{"id":34191480,"name":"roundware-server","full_name":"hburgund/roundware-server","owner":{"login":"hburgund","id":1714948,"avatar_url":"https://avatars.githubusercontent.com/u/1714948?v=3","gravatar_id":"","url":"https://api.github.com/users/hburgund","html_url":"https://github.com/hburgund","followers_url":"https://api.github.com/users/hburgund/followers","following_url":"https://api.github.com/users/hburgund/following{/other_user}","gists_url":"https://api.github.com/users/hburgund/gists{/gist_id}","starred_url":"https://api.github.com/users/hburgund/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hburgund/subscriptions","organizations_url":"https://api.github.com/users/hburgund/orgs","repos_url":"https://api.github.com/users/hburgund/repos","events_url":"https://api.github.com/users/hburgund/events{/privacy}","received_events_url":"https://api.github.com/users/hburgund/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/hburgund/roundware-server","description":"location-based contributory audio platform for art, education and documentary","fork":true,"url":"https://api.github.com/repos/hburgund/roundware-server","forks_url":"https://api.github.com/repos/hburgund/roundware-server/forks","keys_url":"https://api.github.com/repos/hburgund/roundware-server/keys{/key_id}","collaborators_url":"https://api.github.com/repos/hburgund/roundware-server/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/hburgund/roundware-server/teams","hooks_url":"https://api.github.com/repos/hburgund/roundware-server/hooks","issue_events_url":"https://api.github.com/repos/hburgund/roundware-server/issues/events{/number}","events_url":"https://api.github.com/repos/hburgund/roundware-server/events","assignees_url":"https://api.github.com/repos/hburgund/roundware-server/assignees{/user}","branches_url":"https://api.github.com/repos/hburgund/roundware-server/branches{/branch}","tags_url":"https://api.github.com/repos/hburgund/roundware-server/tags","blobs_url":"https://api.github.com/repos/hburgund/roundware-server/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/hburgund/roundware-server/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/hburgund/roundware-server/git/refs{/sha}","trees_url":"https://api.github.com/repos/hburgund/roundware-server/git/trees{/sha}","statuses_url":"https://api.github.com/repos/hburgund/roundware-server/statuses/{sha}","languages_url":"https://api.github.com/repos/hburgund/roundware-server/languages","stargazers_url":"https://api.github.com/repos/hburgund/roundware-server/stargazers","contributors_url":"https://api.github.com/repos/hburgund/roundware-server/contributors","subscribers_url":"https://api.github.com/repos/hburgund/roundware-server/subscribers","subscription_url":"https://api.github.com/repos/hburgund/roundware-server/subscription","commits_url":"https://api.github.com/repos/hburgund/roundware-server/commits{/sha}","git_commits_url":"https://api.github.com/repos/hburgund/roundware-server/git/commits{/sha}","comments_url":"https://api.github.com/repos/hburgund/roundware-server/comments{/number}","issue_comment_url":"https://api.github.com/repos/hburgund/roundware-server/issues/comments{/number}","contents_url":"https://api.github.com/repos/hburgund/roundware-server/contents/{+path}","compare_url":"https://api.github.com/repos/hburgund/roundware-server/compare/{base}...{head}","merges_url":"https://api.github.com/repos/hburgund/roundware-server/merges","archive_url":"https://api.github.com/repos/hburgund/roundware-server/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/hburgund/roundware-server/downloads","issues_url":"https://api.github.com/repos/hburgund/roundware-server/issues{/number}","pulls_url":"https://api.github.com/repos/hburgund/roundware-server/pulls{/number}","milestones_url":"https://api.github.com/repos/hburgund/roundware-server/milestones{/number}","notifications_url":"https://api.github.com/repos/hburgund/roundware-server/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/hburgund/roundware-server/labels{/name}","releases_url":"https://api.github.com/repos/hburgund/roundware-server/releases{/id}","deployments_url":"https://api.github.com/repos/hburgund/roundware-server/deployments","created_at":"2015-04-19T03:02:52Z","updated_at":"2016-02-27T20:33:31Z","pushed_at":"2016-03-23T18:20:09Z","git_url":"git://github.com/hburgund/roundware-server.git","ssh_url":"git@github.com:hburgund/roundware-server.git","clone_url":"https://github.com/hburgund/roundware-server.git","svn_url":"https://github.com/hburgund/roundware-server","homepage":"http://roundware.org","size":15865,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"develop"}},"base":{"label":"roundware:develop","ref":"develop","sha":"02d6243dd8f40daa34df7725a3bc6b73a6204a85","user":{"login":"roundware","id":10054725,"avatar_url":"https://avatars.githubusercontent.com/u/10054725?v=3","gravatar_id":"","url":"https://api.github.com/users/roundware","html_url":"https://github.com/roundware","followers_url":"https://api.github.com/users/roundware/followers","following_url":"https://api.github.com/users/roundware/following{/other_user}","gists_url":"https://api.github.com/users/roundware/gists{/gist_id}","starred_url":"https://api.github.com/users/roundware/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roundware/subscriptions","organizations_url":"https://api.github.com/users/roundware/orgs","repos_url":"https://api.github.com/users/roundware/repos","events_url":"https://api.github.com/users/roundware/events{/privacy}","received_events_url":"https://api.github.com/users/roundware/received_events","type":"Organization","site_admin":false},"repo":{"id":6511853,"name":"roundware-server","full_name":"roundware/roundware-server","owner":{"login":"roundware","id":10054725,"avatar_url":"https://avatars.githubusercontent.com/u/10054725?v=3","gravatar_id":"","url":"https://api.github.com/users/roundware","html_url":"https://github.com/roundware","followers_url":"https://api.github.com/users/roundware/followers","following_url":"https://api.github.com/users/roundware/following{/other_user}","gists_url":"https://api.github.com/users/roundware/gists{/gist_id}","starred_url":"https://api.github.com/users/roundware/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roundware/subscriptions","organizations_url":"https://api.github.com/users/roundware/orgs","repos_url":"https://api.github.com/users/roundware/repos","events_url":"https://api.github.com/users/roundware/events{/privacy}","received_events_url":"https://api.github.com/users/roundware/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/roundware/roundware-server","description":"Location-based contributory audio platform for art, education and documentary","fork":false,"url":"https://api.github.com/repos/roundware/roundware-server","forks_url":"https://api.github.com/repos/roundware/roundware-server/forks","keys_url":"https://api.github.com/repos/roundware/roundware-server/keys{/key_id}","collaborators_url":"https://api.github.com/repos/roundware/roundware-server/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/roundware/roundware-server/teams","hooks_url":"https://api.github.com/repos/roundware/roundware-server/hooks","issue_events_url":"https://api.github.com/repos/roundware/roundware-server/issues/events{/number}","events_url":"https://api.github.com/repos/roundware/roundware-server/events","assignees_url":"https://api.github.com/repos/roundware/roundware-server/assignees{/user}","branches_url":"https://api.github.com/repos/roundware/roundware-server/branches{/branch}","tags_url":"https://api.github.com/repos/roundware/roundware-server/tags","blobs_url":"https://api.github.com/repos/roundware/roundware-server/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/roundware/roundware-server/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/roundware/roundware-server/git/refs{/sha}","trees_url":"https://api.github.com/repos/roundware/roundware-server/git/trees{/sha}","statuses_url":"https://api.github.com/repos/roundware/roundware-server/statuses/{sha}","languages_url":"https://api.github.com/repos/roundware/roundware-server/languages","stargazers_url":"https://api.github.com/repos/roundware/roundware-server/stargazers","contributors_url":"https://api.github.com/repos/roundware/roundware-server/contributors","subscribers_url":"https://api.github.com/repos/roundware/roundware-server/subscribers","subscription_url":"https://api.github.com/repos/roundware/roundware-server/subscription","commits_url":"https://api.github.com/repos/roundware/roundware-server/commits{/sha}","git_commits_url":"https://api.github.com/repos/roundware/roundware-server/git/commits{/sha}","comments_url":"https://api.github.com/repos/roundware/roundware-server/comments{/number}","issue_comment_url":"https://api.github.com/repos/roundware/roundware-server/issues/comments{/number}","contents_url":"https://api.github.com/repos/roundware/roundware-server/contents/{+path}","compare_url":"https://api.github.com/repos/roundware/roundware-server/compare/{base}...{head}","merges_url":"https://api.github.com/repos/roundware/roundware-server/merges","archive_url":"https://api.github.com/repos/roundware/roundware-server/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/roundware/roundware-server/downloads","issues_url":"https://api.github.com/repos/roundware/roundware-server/issues{/number}","pulls_url":"https://api.github.com/repos/roundware/roundware-server/pulls{/number}","milestones_url":"https://api.github.com/repos/roundware/roundware-server/milestones{/number}","notifications_url":"https://api.github.com/repos/roundware/roundware-server/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/roundware/roundware-server/labels{/name}","releases_url":"https://api.github.com/repos/roundware/roundware-server/releases{/id}","deployments_url":"https://api.github.com/repos/roundware/roundware-server/deployments","created_at":"2012-11-02T20:00:40Z","updated_at":"2016-03-14T13:51:23Z","pushed_at":"2016-03-23T18:31:05Z","git_url":"git://github.com/roundware/roundware-server.git","ssh_url":"git@github.com:roundware/roundware-server.git","clone_url":"https://github.com/roundware/roundware-server.git","svn_url":"https://github.com/roundware/roundware-server","homepage":"http://roundware.org","size":13093,"stargazers_count":15,"watchers_count":15,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":14,"mirror_url":null,"open_issues_count":81,"forks":14,"open_issues":81,"watchers":15,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/roundware/roundware-server/pulls/276"},"html":{"href":"https://github.com/roundware/roundware-server/pull/276"},"issue":{"href":"https://api.github.com/repos/roundware/roundware-server/issues/276"},"comments":{"href":"https://api.github.com/repos/roundware/roundware-server/issues/276/comments"},"review_comments":{"href":"https://api.github.com/repos/roundware/roundware-server/pulls/276/comments"},"review_comment":{"href":"https://api.github.com/repos/roundware/roundware-server/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/roundware/roundware-server/pulls/276/commits"},"statuses":{"href":"https://api.github.com/repos/roundware/roundware-server/statuses/1a6ddff7d27b9850bebd726d79b61c832efa2ac4"}}}}