{"action":"created","issue":{"url":"https://api.github.com/repos/PecanProject/bety/issues/245","repository_url":"https://api.github.com/repos/PecanProject/bety","labels_url":"https://api.github.com/repos/PecanProject/bety/issues/245/labels{/name}","comments_url":"https://api.github.com/repos/PecanProject/bety/issues/245/comments","events_url":"https://api.github.com/repos/PecanProject/bety/issues/245/events","html_url":"https://github.com/PecanProject/bety/issues/245","id":57855392,"number":245,"title":"runs value constraints: needed cleanup and decisions","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":[{"url":"https://api.github.com/repos/PecanProject/bety/labels/2%20-%20Working","name":"2 - Working","color":"CCCCCC"},{"url":"https://api.github.com/repos/PecanProject/bety/labels/data","name":"data","color":"009800"},{"url":"https://api.github.com/repos/PecanProject/bety/labels/PEcAn","name":"PEcAn","color":"eb6420"},{"url":"https://api.github.com/repos/PecanProject/bety/labels/qaqc","name":"qaqc","color":"f7c6c7"}],"state":"open","locked":false,"assignee":{"login":"robkooper","id":1580696,"avatar_url":"https://avatars.githubusercontent.com/u/1580696?v=3","gravatar_id":"","url":"https://api.github.com/users/robkooper","html_url":"https://github.com/robkooper","followers_url":"https://api.github.com/users/robkooper/followers","following_url":"https://api.github.com/users/robkooper/following{/other_user}","gists_url":"https://api.github.com/users/robkooper/gists{/gist_id}","starred_url":"https://api.github.com/users/robkooper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robkooper/subscriptions","organizations_url":"https://api.github.com/users/robkooper/orgs","repos_url":"https://api.github.com/users/robkooper/repos","events_url":"https://api.github.com/users/robkooper/events{/privacy}","received_events_url":"https://api.github.com/users/robkooper/received_events","type":"User","site_admin":false},"assignees":[{"login":"robkooper","id":1580696,"avatar_url":"https://avatars.githubusercontent.com/u/1580696?v=3","gravatar_id":"","url":"https://api.github.com/users/robkooper","html_url":"https://github.com/robkooper","followers_url":"https://api.github.com/users/robkooper/followers","following_url":"https://api.github.com/users/robkooper/following{/other_user}","gists_url":"https://api.github.com/users/robkooper/gists{/gist_id}","starred_url":"https://api.github.com/users/robkooper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robkooper/subscriptions","organizations_url":"https://api.github.com/users/robkooper/orgs","repos_url":"https://api.github.com/users/robkooper/repos","events_url":"https://api.github.com/users/robkooper/events{/privacy}","received_events_url":"https://api.github.com/users/robkooper/received_events","type":"User","site_admin":false},{"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}],"milestone":{"url":"https://api.github.com/repos/PecanProject/bety/milestones/8","html_url":"https://github.com/PecanProject/bety/milestones/Implement%20Database%20Constraints","labels_url":"https://api.github.com/repos/PecanProject/bety/milestones/8/labels","id":886188,"number":8,"title":"Implement Database Constraints","description":"Once we have ensure that our data is consistent with the constraints we wish to add we can go ahead and add them.","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":5,"closed_issues":20,"state":"open","created_at":"2014-12-01T17:12:33Z","updated_at":"2015-12-07T00:04:18Z","due_on":null,"closed_at":null},"comments":11,"created_at":"2015-02-16T21:51:50Z","updated_at":"2016-08-04T00:04:58Z","closed_at":null,"body":"* [x] Decide what constraints are possible\r\n* [ ] Decide on precise form of started_at constraint (pending resolution of #257) [Resolved for now by assuming local machine time; see note]\r\n* [ ] Add them.\r\n\r\n# Details\r\n\r\nAt the least, all textual columns will be set to NOT NULL.\r\n\r\n<!---\r\n@huboard:{\"order\":156.0,\"milestone_order\":245,\"custom_state\":\"\"}\r\n-->\r\n"},"comment":{"url":"https://api.github.com/repos/PecanProject/bety/issues/comments/237412637","html_url":"https://github.com/PecanProject/bety/issues/245#issuecomment-237412637","issue_url":"https://api.github.com/repos/PecanProject/bety/issues/245","id":237412637,"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":"2016-08-04T00:04:58Z","updated_at":"2016-08-04T00:04:58Z","body":"Time zone is critical if you put any constraints on started_at and finished_at otherwise this will completely destroy the sync system. All times should be UTC. We decided that a few years ago so hopefully any Central time records are old.   There should be no constraints on the absolute values of start_time and finish_time. The relative constraint of finish being after start seems ok"}}
{"actor":{"display_login":"mdietze"}}