{"action":"created","issue":{"url":"https://api.github.com/repos/andialbrecht/runsqlrun/issues/14","labels_url":"https://api.github.com/repos/andialbrecht/runsqlrun/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/andialbrecht/runsqlrun/issues/14/comments","events_url":"https://api.github.com/repos/andialbrecht/runsqlrun/issues/14/events","html_url":"https://github.com/andialbrecht/runsqlrun/issues/14","id":118316830,"number":14,"title":"[sqlite3] DELETE queries not taking affect until COMMIT.","user":{"login":"mjs7231","id":435619,"avatar_url":"https://avatars.githubusercontent.com/u/435619?v=3","gravatar_id":"","url":"https://api.github.com/users/mjs7231","html_url":"https://github.com/mjs7231","followers_url":"https://api.github.com/users/mjs7231/followers","following_url":"https://api.github.com/users/mjs7231/following{/other_user}","gists_url":"https://api.github.com/users/mjs7231/gists{/gist_id}","starred_url":"https://api.github.com/users/mjs7231/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjs7231/subscriptions","organizations_url":"https://api.github.com/users/mjs7231/orgs","repos_url":"https://api.github.com/users/mjs7231/repos","events_url":"https://api.github.com/users/mjs7231/events{/privacy}","received_events_url":"https://api.github.com/users/mjs7231/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/andialbrecht/runsqlrun/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-23T04:05:34Z","updated_at":"2015-11-23T19:16:04Z","closed_at":null,"body":"After performing DELETE queries on my SQLite3 DB, I noticed it took affect in the RSR view, but not in the actual database. I thought maybe everything is in a transaction, so I made the query COMMIT; and got the message back \"cannot commit, no transaction is active.\"  Despite the error message, this did cause the deleted to propagate to the actual database.\r\n\r\nIn Crunchyfrog things works as expected."},"comment":{"url":"https://api.github.com/repos/andialbrecht/runsqlrun/issues/comments/159033621","html_url":"https://github.com/andialbrecht/runsqlrun/issues/14#issuecomment-159033621","issue_url":"https://api.github.com/repos/andialbrecht/runsqlrun/issues/14","id":159033621,"user":{"login":"andialbrecht","id":25632,"avatar_url":"https://avatars.githubusercontent.com/u/25632?v=3","gravatar_id":"","url":"https://api.github.com/users/andialbrecht","html_url":"https://github.com/andialbrecht","followers_url":"https://api.github.com/users/andialbrecht/followers","following_url":"https://api.github.com/users/andialbrecht/following{/other_user}","gists_url":"https://api.github.com/users/andialbrecht/gists{/gist_id}","starred_url":"https://api.github.com/users/andialbrecht/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andialbrecht/subscriptions","organizations_url":"https://api.github.com/users/andialbrecht/orgs","repos_url":"https://api.github.com/users/andialbrecht/repos","events_url":"https://api.github.com/users/andialbrecht/events{/privacy}","received_events_url":"https://api.github.com/users/andialbrecht/received_events","type":"User","site_admin":false},"created_at":"2015-11-23T19:16:04Z","updated_at":"2015-11-23T19:16:04Z","body":"The transaction handling code is not ported from CrunchyFrog yet. "}}