require 'acceptance/spec_helper' describe 'SQL delta indexing', :live => true do it "automatically indexes new records" do guards = Book.create( :title => 'Guards! Guards!', :author => 'Terry Pratchett' ) index expect(Book.search('Terry Pratchett').to_a).to eq([guards]) men = Book.create( :title => 'Men At Arms', :author => 'Terry Pratchett' ) work sleep 0.25 expect(Book.search('Terry Pratchett').to_a).to eq([guards, men]) end it "automatically indexes updated records" do book = Book.create :title => 'Night Watch', :author => 'Harry Pritchett' index expect(Book.search('Harry').to_a).to eq([book]) book.reload.update(:author => 'Terry Pratchett') work sleep 0.25 expect(Book.search('Terry').to_a).to eq([book]) end it "does not match on old values" do book = Book.create :title => 'Night Watch', :author => 'Harry Pritchett' index expect(Book.search('Harry').to_a).to eq([book]) book.reload.update(:author => 'Terry Pratchett') work sleep 0.25 expect(Book.search('Harry')).to be_empty end end