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