{"action":"created","issue":{"url":"https://api.github.com/repos/theory/sqitch/issues/298","repository_url":"https://api.github.com/repos/theory/sqitch","labels_url":"https://api.github.com/repos/theory/sqitch/issues/298/labels{/name}","comments_url":"https://api.github.com/repos/theory/sqitch/issues/298/comments","events_url":"https://api.github.com/repos/theory/sqitch/issues/298/events","html_url":"https://github.com/theory/sqitch/issues/298","id":157339612,"number":298,"title":"Sqitch tutorial:  Are 'verify/*.sql' examples out-of-date?","user":{"login":"jkeenan","id":96524,"avatar_url":"https://avatars.githubusercontent.com/u/96524?v=3","gravatar_id":"","url":"https://api.github.com/users/jkeenan","html_url":"https://github.com/jkeenan","followers_url":"https://api.github.com/users/jkeenan/followers","following_url":"https://api.github.com/users/jkeenan/following{/other_user}","gists_url":"https://api.github.com/users/jkeenan/gists{/gist_id}","starred_url":"https://api.github.com/users/jkeenan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jkeenan/subscriptions","organizations_url":"https://api.github.com/users/jkeenan/orgs","repos_url":"https://api.github.com/users/jkeenan/repos","events_url":"https://api.github.com/users/jkeenan/events{/privacy}","received_events_url":"https://api.github.com/users/jkeenan/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-28T13:47:53Z","updated_at":"2016-06-03T23:55:53Z","closed_at":"2016-06-03T23:54:59Z","body":"I am working my way through the Sqitch tutorial at https://metacpan.org/pod/sqitchtutorial, App::Sqitch-0.9994.  I'm at the point where I'm issuing a command like this:\r\n```sh\r\nsqitch add flips -r appschema -r users -n 'Adds table for storing flips.'\r\n```\r\nWhen I open up the `verify/flips.sql` for editing, I see this:\r\n```\r\n$ cat verify/flips.sql \r\n-- Verify flipr:flips on pg\r\n\r\nBEGIN;\r\n\r\n-- XXX Add verifications here.\r\n\r\nROLLBACK;\r\n```\r\nThe tutorial, however, prompts me to expect `COMMIT;` where you see `ROLLBACK;` above.\r\n\r\nIs the tutorial correct or is it out-of-date?\r\n\r\nThank you very much.\r\nJim Keenan"},"comment":{"url":"https://api.github.com/repos/theory/sqitch/issues/comments/223721051","html_url":"https://github.com/theory/sqitch/issues/298#issuecomment-223721051","issue_url":"https://api.github.com/repos/theory/sqitch/issues/298","id":223721051,"user":{"login":"theory","id":46604,"avatar_url":"https://avatars.githubusercontent.com/u/46604?v=3","gravatar_id":"","url":"https://api.github.com/users/theory","html_url":"https://github.com/theory","followers_url":"https://api.github.com/users/theory/followers","following_url":"https://api.github.com/users/theory/following{/other_user}","gists_url":"https://api.github.com/users/theory/gists{/gist_id}","starred_url":"https://api.github.com/users/theory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theory/subscriptions","organizations_url":"https://api.github.com/users/theory/orgs","repos_url":"https://api.github.com/users/theory/repos","events_url":"https://api.github.com/users/theory/events{/privacy}","received_events_url":"https://api.github.com/users/theory/received_events","type":"User","site_admin":false},"created_at":"2016-06-03T23:55:53Z","updated_at":"2016-06-03T23:55:53Z","body":"Laggards from earlier revisions, thanks for the catch!"}}
{"actor":{"display_login":"theory"}}