{"action":"created","issue":{"url":"https://api.github.com/repos/pacificclimate/crmprtd/issues/9","repository_url":"https://api.github.com/repos/pacificclimate/crmprtd","labels_url":"https://api.github.com/repos/pacificclimate/crmprtd/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/pacificclimate/crmprtd/issues/9/comments","events_url":"https://api.github.com/repos/pacificclimate/crmprtd/issues/9/events","html_url":"https://github.com/pacificclimate/crmprtd/issues/9","id":276212301,"number":9,"title":"Investigate SQLAlchemy's nested transations","user":{"login":"jameshiebert","id":3904316,"avatar_url":"https://avatars2.githubusercontent.com/u/3904316?v=4","gravatar_id":"","url":"https://api.github.com/users/jameshiebert","html_url":"https://github.com/jameshiebert","followers_url":"https://api.github.com/users/jameshiebert/followers","following_url":"https://api.github.com/users/jameshiebert/following{/other_user}","gists_url":"https://api.github.com/users/jameshiebert/gists{/gist_id}","starred_url":"https://api.github.com/users/jameshiebert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jameshiebert/subscriptions","organizations_url":"https://api.github.com/users/jameshiebert/orgs","repos_url":"https://api.github.com/users/jameshiebert/repos","events_url":"https://api.github.com/users/jameshiebert/events{/privacy}","received_events_url":"https://api.github.com/users/jameshiebert/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"rod-glover","id":4139706,"avatar_url":"https://avatars3.githubusercontent.com/u/4139706?v=4","gravatar_id":"","url":"https://api.github.com/users/rod-glover","html_url":"https://github.com/rod-glover","followers_url":"https://api.github.com/users/rod-glover/followers","following_url":"https://api.github.com/users/rod-glover/following{/other_user}","gists_url":"https://api.github.com/users/rod-glover/gists{/gist_id}","starred_url":"https://api.github.com/users/rod-glover/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rod-glover/subscriptions","organizations_url":"https://api.github.com/users/rod-glover/orgs","repos_url":"https://api.github.com/users/rod-glover/repos","events_url":"https://api.github.com/users/rod-glover/events{/privacy}","received_events_url":"https://api.github.com/users/rod-glover/received_events","type":"User","site_admin":false},"assignees":[{"login":"rod-glover","id":4139706,"avatar_url":"https://avatars3.githubusercontent.com/u/4139706?v=4","gravatar_id":"","url":"https://api.github.com/users/rod-glover","html_url":"https://github.com/rod-glover","followers_url":"https://api.github.com/users/rod-glover/followers","following_url":"https://api.github.com/users/rod-glover/following{/other_user}","gists_url":"https://api.github.com/users/rod-glover/gists{/gist_id}","starred_url":"https://api.github.com/users/rod-glover/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rod-glover/subscriptions","organizations_url":"https://api.github.com/users/rod-glover/orgs","repos_url":"https://api.github.com/users/rod-glover/repos","events_url":"https://api.github.com/users/rod-glover/events{/privacy}","received_events_url":"https://api.github.com/users/rod-glover/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2017-11-22T21:43:28Z","updated_at":"2017-11-22T22:34:29Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"There is some evidence that suggests our nested transactions are not behaving properly. The ``moti_infill.py`` script is reporting that it's making insertions, however those insertions never actually appear in the database.\r\n\r\nThe transaction management in this package is \"complicated\". We haven't pinned our version of ``SQLAlchemy`` in the ``requirements.txt`` so there is a real possibility that the behaviour of nested transactions has changed out from under us. We need to:\r\n\r\n1. Upgrade and pin to the latest stable version of ``SQLAlchemy`` and\r\n1. Ensure that the nested transactions are behaving the way that they should"},"comment":{"url":"https://api.github.com/repos/pacificclimate/crmprtd/issues/comments/346491136","html_url":"https://github.com/pacificclimate/crmprtd/issues/9#issuecomment-346491136","issue_url":"https://api.github.com/repos/pacificclimate/crmprtd/issues/9","id":346491136,"user":{"login":"rod-glover","id":4139706,"avatar_url":"https://avatars3.githubusercontent.com/u/4139706?v=4","gravatar_id":"","url":"https://api.github.com/users/rod-glover","html_url":"https://github.com/rod-glover","followers_url":"https://api.github.com/users/rod-glover/followers","following_url":"https://api.github.com/users/rod-glover/following{/other_user}","gists_url":"https://api.github.com/users/rod-glover/gists{/gist_id}","starred_url":"https://api.github.com/users/rod-glover/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rod-glover/subscriptions","organizations_url":"https://api.github.com/users/rod-glover/orgs","repos_url":"https://api.github.com/users/rod-glover/repos","events_url":"https://api.github.com/users/rod-glover/events{/privacy}","received_events_url":"https://api.github.com/users/rod-glover/received_events","type":"User","site_admin":false},"created_at":"2017-11-22T22:34:29Z","updated_at":"2017-11-22T22:34:29Z","author_association":"NONE","body":"I think you must mean `moti_infill_insert.py`."}}
{"actor":{"display_login":"rod-glover"}}