Sha256: e009e2de2a91d875bf59c4f347491b0954f7acab82a7e2b9c3d9243c2fd9a9f4
Contents?: true
Size: 1.34 KB
Versions: 9
Compression:
Stored size: 1.34 KB
Contents
require "spec_helper"
describe "Trigger migrations", :db do
around do |example|
connection.execute <<-EOS
CREATE TABLE users (
id int PRIMARY KEY,
name varchar(256),
upper_name varchar(256)
);
EOS
Fx.database.create_function <<-EOS
CREATE OR REPLACE FUNCTION uppercase_users_name()
RETURNS trigger AS $$
BEGIN
NEW.upper_name = UPPER(NEW.name);
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
EOS
sql_definition = <<-EOS
CREATE TRIGGER uppercase_users_name
BEFORE INSERT ON users
FOR EACH ROW
EXECUTE PROCEDURE uppercase_users_name();
EOS
with_trigger_definition(
name: :uppercase_users_name,
sql_definition: sql_definition,
) do
example.run
end
end
it "can run migrations that create triggers" do
migration = Class.new(migration_class) do
def up
create_trigger :uppercase_users_name
end
end
expect { run_migration(migration, :up) }.not_to raise_error
end
it "can run migrations that drop triggers" do
connection.create_trigger(:uppercase_users_name)
migration = Class.new(migration_class) do
def up
drop_trigger :uppercase_users_name, on: :users
end
end
expect { run_migration(migration, :up) }.not_to raise_error
end
end
Version data entries
9 entries across 9 versions & 2 rubygems