{"action":"created","issue":{"url":"https://api.github.com/repos/dimagi/commcare-hq/issues/9547","labels_url":"https://api.github.com/repos/dimagi/commcare-hq/issues/9547/labels{/name}","comments_url":"https://api.github.com/repos/dimagi/commcare-hq/issues/9547/comments","events_url":"https://api.github.com/repos/dimagi/commcare-hq/issues/9547/events","html_url":"https://github.com/dimagi/commcare-hq/pull/9547","id":121898057,"number":9547,"title":"SQL Sync","user":{"login":"NoahCarnahan","id":2117127,"avatar_url":"https://avatars.githubusercontent.com/u/2117127?v=3","gravatar_id":"","url":"https://api.github.com/users/NoahCarnahan","html_url":"https://github.com/NoahCarnahan","followers_url":"https://api.github.com/users/NoahCarnahan/followers","following_url":"https://api.github.com/users/NoahCarnahan/following{/other_user}","gists_url":"https://api.github.com/users/NoahCarnahan/gists{/gist_id}","starred_url":"https://api.github.com/users/NoahCarnahan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NoahCarnahan/subscriptions","organizations_url":"https://api.github.com/users/NoahCarnahan/orgs","repos_url":"https://api.github.com/users/NoahCarnahan/repos","events_url":"https://api.github.com/users/NoahCarnahan/events{/privacy}","received_events_url":"https://api.github.com/users/NoahCarnahan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-12-13T04:16:06Z","updated_at":"2015-12-28T20:31:05Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/dimagi/commcare-hq/pulls/9547","html_url":"https://github.com/dimagi/commcare-hq/pull/9547","diff_url":"https://github.com/dimagi/commcare-hq/pull/9547.diff","patch_url":"https://github.com/dimagi/commcare-hq/pull/9547.patch"},"body":"Modify sync code to be backend agnostic. All tests in the `phone` app are passing.\r\n\r\nTODO:\r\n- ~~write sql functions instead of using django ORM~~\r\n- ~~mark tests with `run_with_all_backends`~~\r\n- ~~fix merge conflicts~~\r\n- ~~remove notes / misc clean up~~\r\n- write tests for `CaseAccessors` API\r\n\r\ncan be reviewed commit-by-commit.\r\n@snopoke @benrudolph @czue "},"comment":{"url":"https://api.github.com/repos/dimagi/commcare-hq/issues/comments/167648108","html_url":"https://github.com/dimagi/commcare-hq/pull/9547#issuecomment-167648108","issue_url":"https://api.github.com/repos/dimagi/commcare-hq/issues/9547","id":167648108,"user":{"login":"gcapalbo","id":1028814,"avatar_url":"https://avatars.githubusercontent.com/u/1028814?v=3","gravatar_id":"","url":"https://api.github.com/users/gcapalbo","html_url":"https://github.com/gcapalbo","followers_url":"https://api.github.com/users/gcapalbo/followers","following_url":"https://api.github.com/users/gcapalbo/following{/other_user}","gists_url":"https://api.github.com/users/gcapalbo/gists{/gist_id}","starred_url":"https://api.github.com/users/gcapalbo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gcapalbo/subscriptions","organizations_url":"https://api.github.com/users/gcapalbo/orgs","repos_url":"https://api.github.com/users/gcapalbo/repos","events_url":"https://api.github.com/users/gcapalbo/events{/privacy}","received_events_url":"https://api.github.com/users/gcapalbo/received_events","type":"User","site_admin":false},"created_at":"2015-12-28T20:31:05Z","updated_at":"2015-12-28T20:31:05Z","body":"@NoahCarnahan Also is `modified_by` a typo there - should that be `user_id`?"}}