createteable sqitch template ~/ .sqitch/templates

deploy.tmpl

-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]

BEGIN;

  create table if not exists [% schema %].[% table %] (
[% FOREACH col IN column -%]
    [% col %] [% type.item( loop.index ) or 'text' %] not null[% loop.last ? '' : ',' %]
[% END -%]
  );

COMMIT;

revert.tmpl

-- Verify [% project %]:[% change %] on [% engine %]

BEGIN;

  select [% column.join(', ') %]
    from [% schema %].[% table %]
   where false;

ROLLBACK;

verify.tmpl

-- Revert [% project %]:[% change %] from [% engine %]

BEGIN;

  drop table [% schema %].[% table %];

COMMIT;