Contents

require 'spec_helper'

require 'remove_rooms_by_name'

describe "Remove rooms by name" do
  before(:all) do
    plsql.rooms.insert_values(
      [:room_key, :name],
      [1, 'Dining Room'],
      [2, 'Living Room'],
      [3, 'Office'],
      [4, 'Bathroom'],
      [5, 'Bedroom']
    )
    plsql.room_contents.insert_values(
      [:contents_key, :room_key, :name],
      [1, 1, 'Table'],
      [2, 1, 'Hutch'],
      [3, 1, 'Chair'],
      [4, 2, 'Sofa'],
      [5, 2, 'Lamp'],
      [6, 3, 'Desk'],
      [7, 3, 'Chair'],
      [8, 3, 'Computer'],
      [9, 3, 'Whiteboard']
    )
  end

  it "should remove a room without furniture" do
    rooms_without_b = plsql.rooms.all("WHERE name NOT LIKE 'B%'")
    plsql.remove_rooms_by_name('B%')
    plsql.rooms.all.should == rooms_without_b
  end

  it "should not remove a room with furniture" do
    lambda {
      lambda {
        plsql.remove_rooms_by_name('Living Room')
      }.should raise_error(/ORA-02292/)
    }.should_not change { plsql.rooms.all }
  end

  it "should raise exception when NULL value passed" do
    lambda {
      lambda {
        plsql.remove_rooms_by_name(NULL)
      }.should raise_error(/program error/)
    }.should_not change { plsql.rooms.all }
  end

end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
ruby-plsql-spec-0.2.1	examples/spec/remove_rooms_by_name_spec.rb
ruby-plsql-spec-0.1.0	examples/spec/remove_rooms_by_name_spec.rb