{"action":"opened","issue":{"url":"https://api.github.com/repos/18F/openFEC/issues/528","labels_url":"https://api.github.com/repos/18F/openFEC/issues/528/labels{/name}","comments_url":"https://api.github.com/repos/18F/openFEC/issues/528/comments","events_url":"https://api.github.com/repos/18F/openFEC/issues/528/events","html_url":"https://github.com/18F/openFEC/issues/528","id":65770907,"number":528,"title":"CF needs migrations ","user":{"login":"LindsayYoung","id":4406333,"avatar_url":"https://avatars.githubusercontent.com/u/4406333?v=3","gravatar_id":"","url":"https://api.github.com/users/LindsayYoung","html_url":"https://github.com/LindsayYoung","followers_url":"https://api.github.com/users/LindsayYoung/followers","following_url":"https://api.github.com/users/LindsayYoung/following{/other_user}","gists_url":"https://api.github.com/users/LindsayYoung/gists{/gist_id}","starred_url":"https://api.github.com/users/LindsayYoung/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LindsayYoung/subscriptions","organizations_url":"https://api.github.com/users/LindsayYoung/orgs","repos_url":"https://api.github.com/users/LindsayYoung/repos","events_url":"https://api.github.com/users/LindsayYoung/events{/privacy}","received_events_url":"https://api.github.com/users/LindsayYoung/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/18F/openFEC/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-04-01T20:18:45Z","updated_at":"2015-04-01T20:18:45Z","closed_at":null,"body":"The API in cloud foundry needs to run migration to get the tables it needs. \r\n\r\nexample:\r\n`http://fec-api-dev.cf.18f.us/candidate/H4UT04052`\r\nproduces:\r\n```\r\nsqlalchemy.exc.ProgrammingError: (ProgrammingError) column ofec_candidate_detail_vw.candidate_expire_date does not exist\r\nLINE 2: FROM (SELECT ofec_candidate_detail_vw.candidate_expire_date ...\r\n```\r\n\r\nI tried launching the app with a shell script that runs the migration and then the api, but the migrations seemed to error out. Maybe it is permissions? \r\n\r\nTask:\r\n- [ ] get `python manage.py refresh_db` to run on cloudfoundry before starting the app\r\n\r\n\r\n"}}