Sha256: 746ab68a7e10ca6fab133fdc72a55eb89ddaf9083281aeb546b8aa472d7e7ee6
Contents?: true
Size: 832 Bytes
Versions: 4
Compression:
Stored size: 832 Bytes
Contents
require "spec_helper" describe "Simple::SQL::Connection::Scope#count" do let!(:users) { 1.upto(USER_COUNT).map { create(:user) } } let(:min_user_id) { SQL.ask "SELECT min(id) FROM users" } let(:scope) { SQL.scope("SELECT * FROM users") } describe "exact count" do it "counts" do expect(scope.count).to eq(USER_COUNT) end it "evaluates conditions" do expect(scope.where("id < $1", min_user_id).count).to eq(0) expect(scope.where("id <= $1", min_user_id).count).to eq(1) end end describe "fast count" do it "counts" do expect(scope.fast_count).to eq(USER_COUNT) end it "evaluates conditions" do expect(scope.where("id < $1", min_user_id).fast_count).to eq(0) expect(scope.where("id <= $1", min_user_id).fast_count).to eq(1) end end end
Version data entries
4 entries across 4 versions & 1 rubygems