spec/active_relation/relations/deletion_spec.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

require File.join(File.dirname(__FILE__), '..', '..', 'spec_helper')

module ActiveRelation
  describe Deletion do
    before do
      @relation = Table.new(:users)
    end
  
    describe '#to_sql' do
      it 'manufactures sql deleting a table relation' do
        Deletion.new(@relation).to_sql.should be_like("""
          DELETE
          FROM `users`
        """)
      end
    
      it 'manufactures sql deleting a selection relation' do
        Deletion.new(@relation.select(@relation[:id].equals(1))).to_sql.should be_like("""
          DELETE
          FROM `users`
          WHERE `users`.`id` = 1
        """)
      end
    end
  end
end