Sha256: 4166988042cec0ab8e372b16b18d128746f68321227cb96dec2e5b0a875519f0
Contents?: true
Size: 1.59 KB
Versions: 39
Compression:
Stored size: 1.59 KB
Contents
require 'cases/helper_sqlserver'
require 'models/book'
class FetchTestSqlserver < ActiveRecord::TestCase
let(:books) { @books }
before { create_10_books }
it 'work with fully qualified table and columns in select' do
books = Book.select('books.id, books.name').limit(3).offset(5)
assert_equal Book.all[5,3].map(&:id), books.map(&:id)
end
describe 'count' do
it 'gauntlet' do
books[0].destroy
books[1].destroy
books[2].destroy
assert_equal 7, Book.count
assert_equal 1, Book.limit(1).offset(1).count
assert_equal 1, Book.limit(1).offset(5).count
assert_equal 1, Book.limit(1).offset(6).count
assert_equal 0, Book.limit(1).offset(7).count
assert_equal 3, Book.limit(3).offset(4).count
assert_equal 2, Book.limit(3).offset(5).count
assert_equal 1, Book.limit(3).offset(6).count
assert_equal 0, Book.limit(3).offset(7).count
assert_equal 0, Book.limit(3).offset(8).count
end
end
describe 'order' do
it 'gauntlet' do
Book.where(name:'Name-10').delete_all
Book.order(:name).limit(1).offset(1).map(&:name).must_equal ['Name-2']
Book.order(:name).limit(2).offset(2).map(&:name).must_equal ['Name-3', 'Name-4']
Book.order(:name).limit(2).offset(7).map(&:name).must_equal ['Name-8', 'Name-9']
Book.order(:name).limit(3).offset(7).map(&:name).must_equal ['Name-8', 'Name-9']
Book.order(:name).limit(3).offset(9).map(&:name).must_equal []
end
end
protected
def create_10_books
Book.delete_all
@books = (1..10).map { |i| Book.create! name: "Name-#{i}" }
end
end
Version data entries
39 entries across 39 versions & 3 rubygems