{"action":"opened","issue":{"url":"https://api.github.com/repos/KeyComps2018-19/KeyAttendance/issues/8","repository_url":"https://api.github.com/repos/KeyComps2018-19/KeyAttendance","labels_url":"https://api.github.com/repos/KeyComps2018-19/KeyAttendance/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/KeyComps2018-19/KeyAttendance/issues/8/comments","events_url":"https://api.github.com/repos/KeyComps2018-19/KeyAttendance/issues/8/events","html_url":"https://github.com/KeyComps2018-19/KeyAttendance/issues/8","id":367485326,"node_id":"MDU6SXNzdWUzNjc0ODUzMjY=","number":8,"title":"As a developer, I want the back end to validate the database on startup","user":{"login":"jordansybesma","id":18358845,"node_id":"MDQ6VXNlcjE4MzU4ODQ1","avatar_url":"https://avatars2.githubusercontent.com/u/18358845?v=4","gravatar_id":"","url":"https://api.github.com/users/jordansybesma","html_url":"https://github.com/jordansybesma","followers_url":"https://api.github.com/users/jordansybesma/followers","following_url":"https://api.github.com/users/jordansybesma/following{/other_user}","gists_url":"https://api.github.com/users/jordansybesma/gists{/gist_id}","starred_url":"https://api.github.com/users/jordansybesma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jordansybesma/subscriptions","organizations_url":"https://api.github.com/users/jordansybesma/orgs","repos_url":"https://api.github.com/users/jordansybesma/repos","events_url":"https://api.github.com/users/jordansybesma/events{/privacy}","received_events_url":"https://api.github.com/users/jordansybesma/received_events","type":"User","site_admin":false},"labels":[{"id":1056352033,"node_id":"MDU6TGFiZWwxMDU2MzUyMDMz","url":"https://api.github.com/repos/KeyComps2018-19/KeyAttendance/labels/question","name":"question","color":"d876e3","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-06T18:55:44Z","updated_at":"2018-10-06T18:55:44Z","closed_at":null,"author_association":"NONE","body":"I think it would be useful if the back end (when run locally) makes sure that the db it connects to has data tables that matches its expectations and makes sure that the database is populated with test data.  That way, if one of us has to make a db change the rest of us don't have to go through the manual sql to fix our own local copies, and we always have test data to play around with. But we should definitely talk about this first because there are a few design decisions involved:\r\n\r\n- Should the back end validate the database in a prod or stage environment?\r\n- How will the back end know which environment it's running in? Should we have a config file that stores that information?\r\n- If the database is different than what's expected, should it wipe everything and start from scratch, or have some means to correct the db first?"}}
{"actor":{"display_login":"jordansybesma"}}