lib/pg_migrate/templates/up.erb in pg_migrate-0.0.1 vs lib/pg_migrate/templates/up.erb in pg_migrate-0.1.0

- old
+ new

@@ -2,27 +2,29 @@ \set ON_ERROR_STOP 1 BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; -- we want to ensure no one else is running this migration concurrently -LOCK TABLE pg_migrations IN ACCESS EXCLUSIVE MODE; +LOCK TABLE pgmigrate.pg_migrations IN ACCESS EXCLUSIVE MODE; -SELECT verify_against_existing_migrations('<%= migration_def.name %>', <%= migration_def.ordinal %>); +SELECT pgmigrate.verify_manifest_is_not_old(<%= manifest_version %>); +SELECT pgmigrate.verify_against_existing_migrations('<%= migration_def.name %>', <%= migration_def.ordinal %>); + -- to allow exception in CHECK_IF_MIGRATED to cause rollback, not failure \set ON_ERROR_STOP 0 -SELECT bypass_existing_migration('<%= migration_def.name %>'); +SELECT pgmigrate.bypass_existing_migration('<%= migration_def.name %>'); -- if the content of the migration is bad, we want psql to stop. \set ON_ERROR_STOP 1 -- beginning user sql, migration=<%= migration_def.name %> <%= migration_content %> -- beginning pg_migrate footer, migration=<%= migration_def.name %> -SELECT record_migration('<%= migration_def.name %>', <%= migration_def.ordinal %>, '0.0.1', '<%= builder_version %>'); +SELECT pgmigrate.record_migration('<%= migration_def.name %>', <%= migration_def.ordinal %>, '0.1.0', '<%= builder_version %>'); COMMIT; -- end pg_migrate migration, migration=<%= migration_def.name %>