spec/features/triggers/revert_spec.rb in fx-0.7.0 vs spec/features/triggers/revert_spec.rb in fx-0.8.0

- old
+ new

@@ -20,15 +20,15 @@ EOS sql_definition = <<-EOS CREATE TRIGGER uppercase_users_name BEFORE INSERT ON users FOR EACH ROW - EXECUTE PROCEDURE uppercase_users_name(); + EXECUTE FUNCTION uppercase_users_name(); EOS with_trigger_definition( name: :uppercase_users_name, - sql_definition: sql_definition, + sql_definition: sql_definition ) do example.run end end @@ -55,37 +55,37 @@ drop_trigger :uppercase_users_name, on: :users end end expect { run_migration(good_migration, [:up, :down]) }.not_to raise_error - expect { run_migration(bad_migration, [:up, :down]) }. - to raise_error( + expect { run_migration(bad_migration, [:up, :down]) } + .to raise_error( ActiveRecord::IrreversibleMigration, - /`create_trigger` is reversible only if given a `revert_to_version`/, + /`create_trigger` is reversible only if given a `revert_to_version`/ ) end it "can run reversible migrations for updating triggers" do connection.create_trigger(:uppercase_users_name) sql_definition = <<-EOS CREATE TRIGGER uppercase_users_name BEFORE UPDATE ON users FOR EACH ROW - EXECUTE PROCEDURE uppercase_users_name(); + EXECUTE FUNCTION uppercase_users_name(); EOS with_trigger_definition( name: :uppercase_users_name, sql_definition: sql_definition, - version: 2, + version: 2 ) do migration = Class.new(migration_class) do def change update_trigger( :uppercase_users_name, on: :users, version: 2, - revert_to_version: 1, + revert_to_version: 1 ) end end expect { run_migration(migration, [:up, :down]) }.not_to raise_error