spec/fx/adapters/postgres/triggers_spec.rb in fx-0.8.0 vs spec/fx/adapters/postgres/triggers_spec.rb in fx-0.9.0
- old
+ new
@@ -1,45 +1,41 @@
require "spec_helper"
-module Fx
- module Adapters
- describe Postgres::Triggers, :db do
- describe ".all" do
- it "returns `Trigger` objects" do
- connection = ActiveRecord::Base.connection
- connection.execute <<-EOS.strip_heredoc
- CREATE TABLE users (
- id int PRIMARY KEY,
- name varchar(256),
- upper_name varchar(256)
- );
- EOS
- connection.execute <<-EOS.strip_heredoc
- CREATE OR REPLACE FUNCTION uppercase_users_name()
- RETURNS trigger AS $$
- BEGIN
- NEW.upper_name = UPPER(NEW.name);
- RETURN NEW;
- END;
- $$ LANGUAGE plpgsql;
- EOS
- connection.execute <<-EOS.strip_heredoc
- CREATE TRIGGER uppercase_users_name
- BEFORE INSERT ON users
- FOR EACH ROW
- EXECUTE FUNCTION uppercase_users_name();
- EOS
+RSpec.describe Fx::Adapters::Postgres::Triggers, :db do
+ describe ".all" do
+ it "returns `Trigger` objects" do
+ connection = ActiveRecord::Base.connection
+ connection.execute <<~EOS
+ CREATE TABLE users (
+ id int PRIMARY KEY,
+ name varchar(256),
+ upper_name varchar(256)
+ );
+ EOS
+ connection.execute <<~EOS
+ CREATE OR REPLACE FUNCTION uppercase_users_name()
+ RETURNS trigger AS $$
+ BEGIN
+ NEW.upper_name = UPPER(NEW.name);
+ RETURN NEW;
+ END;
+ $$ LANGUAGE plpgsql;
+ EOS
+ connection.execute <<~EOS
+ CREATE TRIGGER uppercase_users_name
+ BEFORE INSERT ON users
+ FOR EACH ROW
+ EXECUTE FUNCTION uppercase_users_name();
+ EOS
- triggers = Postgres::Triggers.new(connection).all
+ triggers = Fx::Adapters::Postgres::Triggers.new(connection).all
- first = triggers.first
- expect(triggers.size).to eq 1
- expect(first.name).to eq "uppercase_users_name"
- expect(first.definition).to include("BEFORE INSERT")
- expect(first.definition).to match(/ON [public.ser|]/)
- expect(first.definition).to include("FOR EACH ROW")
- expect(first.definition).to include("EXECUTE FUNCTION uppercase_users_name()")
- end
- end
+ first = triggers.first
+ expect(triggers.size).to eq(1)
+ expect(first.name).to eq("uppercase_users_name")
+ expect(first.definition).to include("BEFORE INSERT")
+ expect(first.definition).to match(/ON [public.ser|]/)
+ expect(first.definition).to include("FOR EACH ROW")
+ expect(first.definition).to include("EXECUTE FUNCTION uppercase_users_name()")
end
end
end