{"action":"created","issue":{"url":"https://api.github.com/repos/PecanProject/bety/issues/196","labels_url":"https://api.github.com/repos/PecanProject/bety/issues/196/labels{/name}","comments_url":"https://api.github.com/repos/PecanProject/bety/issues/196/comments","events_url":"https://api.github.com/repos/PecanProject/bety/issues/196/events","html_url":"https://github.com/PecanProject/bety/issues/196","id":55683717,"number":196,"title":"models: decide on an appropriate key","user":{"login":"gsrohde","id":1706896,"avatar_url":"https://avatars.githubusercontent.com/u/1706896?v=3","gravatar_id":"","url":"https://api.github.com/users/gsrohde","html_url":"https://github.com/gsrohde","followers_url":"https://api.github.com/users/gsrohde/followers","following_url":"https://api.github.com/users/gsrohde/following{/other_user}","gists_url":"https://api.github.com/users/gsrohde/gists{/gist_id}","starred_url":"https://api.github.com/users/gsrohde/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gsrohde/subscriptions","organizations_url":"https://api.github.com/users/gsrohde/orgs","repos_url":"https://api.github.com/users/gsrohde/repos","events_url":"https://api.github.com/users/gsrohde/events{/privacy}","received_events_url":"https://api.github.com/users/gsrohde/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"dlebauer","id":464871,"avatar_url":"https://avatars.githubusercontent.com/u/464871?v=3","gravatar_id":"","url":"https://api.github.com/users/dlebauer","html_url":"https://github.com/dlebauer","followers_url":"https://api.github.com/users/dlebauer/followers","following_url":"https://api.github.com/users/dlebauer/following{/other_user}","gists_url":"https://api.github.com/users/dlebauer/gists{/gist_id}","starred_url":"https://api.github.com/users/dlebauer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dlebauer/subscriptions","organizations_url":"https://api.github.com/users/dlebauer/orgs","repos_url":"https://api.github.com/users/dlebauer/repos","events_url":"https://api.github.com/users/dlebauer/events{/privacy}","received_events_url":"https://api.github.com/users/dlebauer/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/PecanProject/bety/milestones/5","labels_url":"https://api.github.com/repos/PecanProject/bety/milestones/5/labels","id":886165,"number":5,"title":"Design Database Constraints","description":"Make a list of all constraints the BETYdb database should satisfy.\r\n\r\nRelated to Redmine issues:\r\n* https://ebi-forecast.igb.illinois.edu/redmine/issues/1915","creator":{"login":"gsrohde","id":1706896,"avatar_url":"https://avatars.githubusercontent.com/u/1706896?v=3","gravatar_id":"","url":"https://api.github.com/users/gsrohde","html_url":"https://github.com/gsrohde","followers_url":"https://api.github.com/users/gsrohde/followers","following_url":"https://api.github.com/users/gsrohde/following{/other_user}","gists_url":"https://api.github.com/users/gsrohde/gists{/gist_id}","starred_url":"https://api.github.com/users/gsrohde/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gsrohde/subscriptions","organizations_url":"https://api.github.com/users/gsrohde/orgs","repos_url":"https://api.github.com/users/gsrohde/repos","events_url":"https://api.github.com/users/gsrohde/events{/privacy}","received_events_url":"https://api.github.com/users/gsrohde/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":0,"state":"open","created_at":"2014-12-01T16:58:41Z","updated_at":"2015-01-27T22:25:39Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2015-01-27T22:25:39Z","updated_at":"2015-01-28T14:07:54Z","closed_at":null,"body":"The originally-proposed was model_path, but this column was removed in June 2014."},"comment":{"url":"https://api.github.com/repos/PecanProject/bety/issues/comments/71839590","html_url":"https://github.com/PecanProject/bety/issues/196#issuecomment-71839590","issue_url":"https://api.github.com/repos/PecanProject/bety/issues/196","id":71839590,"user":{"login":"mdietze","id":3081466,"avatar_url":"https://avatars.githubusercontent.com/u/3081466?v=3","gravatar_id":"","url":"https://api.github.com/users/mdietze","html_url":"https://github.com/mdietze","followers_url":"https://api.github.com/users/mdietze/followers","following_url":"https://api.github.com/users/mdietze/following{/other_user}","gists_url":"https://api.github.com/users/mdietze/gists{/gist_id}","starred_url":"https://api.github.com/users/mdietze/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdietze/subscriptions","organizations_url":"https://api.github.com/users/mdietze/orgs","repos_url":"https://api.github.com/users/mdietze/repos","events_url":"https://api.github.com/users/mdietze/events{/privacy}","received_events_url":"https://api.github.com/users/mdietze/received_events","type":"User","site_admin":false},"created_at":"2015-01-28T14:07:54Z","updated_at":"2015-01-28T14:07:54Z","body":"There are two issues when it comes to syncs. The short term issue is the addition of constraints breaking the sync due to legacy database errors -- this could be resolved by doing sync tests before pushing constraints to the live database. The longer term issue is that the constraints that are being imposed were proposed prior to getting the sync system up and running. There may be constrains that made sense on a single database that may no longer make sense if anyone can enter a record on any machine. In that case the conflicts do not appear until the sync is done. This then becomes an impediment to users and we simply do not have a system in place for resolving these conflicts. For example if two different users add the same site, who's is the 'correct' record, and who has to change their records? Furthermore, since only the users of an database instance can make changes to that instance, even if 'my' record is the 'correct' one, I can't change the other person's database. I think the list of constraints needs to be revisited in this light and reduced to the minimum needed. I'd prefer to handle more of the record issues via QAQC rather than imposing constrains.\r\n\r\nThe \"rush\" feeling doesn't come from there being a lot of issues posted (I've only seen the ones you've included me on), but the feeling that those of us at BU and NCSA had to scramble in order to fix problems created by adding these constraints at a time that we were already overworked to meet our own PEcAn release deadlines in advance of the NACP 2015 meeting. We'd really appreciate some advance warning and better communication on these things (and better testing) so that we're not getting a new BETY version the day before a major meeting.  Right now I'm only learning about releases after the fact via completely uninformative Twitter messages such as:\r\n\r\nThis release primarily implements several foreign-key constraints on the database.  It consists of a ne...\r\n\r\nThis release implements changes to the database schema discussed in Github issue #145 and makes a few r...\r\n\r\nThis incorporates the features and bug fixes from the June 17, 2014 sprint. It was deployed to www.be...\r\n\r\n\r\n"}}