Testing PG Database Constraints with RSpec

Question

I'm trying to test PG database constraints in a rails 4 using RSpec, and I'm not sure how to set it up.

My thought was to do something like this:

before do
  @subscriber = Marketing::Subscriber.new(email: "[email protected]")
end

describe "when email address is already taken" do
  before do
    subscriber_with_same_email = @subscriber.dup
    subscriber_with_same_email.email = @subscriber.email.upcase
    subscriber_with_same_email.save
  end

  it "should raise db error when validation is skipped" do
    expect(@subscriber.save!(validate: false)).to raise_error
  end
end

When I run this, it does in generate an error:

PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint

However, the test still fails.

Is there a proper syntax to get the test to pass?

strivedi183 · Accepted Answer · 2014-04-17 05:01:15Z

6

Try

it "should raise db error when validation is skipped" do
  expect { @subscriber.save!(validate: false) }.to raise_error
end

For more information, check the more info on rspec-expectations expect-error matchers

Hope this helps!

answered Apr 17, 2014 at 5:01

strivedi183

4,8373 gold badges33 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

GoBlue1616 Over a year ago

Gotta love the syntax errors. Thanks for your help!

scarver2 Over a year ago

Thank you @user2262149. Your method is more elegant than stubbing save and returning either ActiveRecord::RecordNotUnique or PG::UniqueViolation.

Max Brundige · Accepted Answer · 2021-10-03 16:07:40Z

1

Slight modification to @strivedi183's answer:

it "should raise db error when validation is skipped" do
   expect { @subscriber.save!(validate: false) }.to raise_error(ActiveRecord::RecordNotUnique)
end

The justification for being more verbose with the error class is that it protects you from having other possible checks that may raise an error that are not related to specific duplication error you wish to raise.

answered Oct 3, 2021 at 16:07

Max Brundige

211 silver badge2 bronze badges

Collectives™ on Stack Overflow

Testing PG Database Constraints with RSpec

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related