Sha256: 47ee9123859efe588a26641ea4cfac9f4a330e82c919359000f73fdf5becf74a

Contents?: true

Size: 745 Bytes

Versions: 22

Compression:

Stored size: 745 Bytes

Contents

require File.join(File.dirname(File.expand_path(__FILE__)), "spec_helper")

describe "pg_loose_count extension" do
  before do
    @db = Sequel.mock(:host=>'postgres', :fetch=>{:v=>1}).extension(:pg_loose_count)
  end

  specify "should add loose_count method getting fast count for entire table using table statistics" do
    @db.loose_count(:a).should == 1
    @db.sqls.should == ["SELECT CAST(reltuples AS integer) AS v FROM pg_class WHERE (oid = CAST(CAST('a' AS regclass) AS oid)) LIMIT 1"]
  end

  specify "should support schema qualified tables" do
    @db.loose_count(:a__b).should == 1
    @db.sqls.should == ["SELECT CAST(reltuples AS integer) AS v FROM pg_class WHERE (oid = CAST(CAST('a.b' AS regclass) AS oid)) LIMIT 1"]
  end
end

Version data entries

22 entries across 22 versions & 2 rubygems

Version Path
sequel-4.22.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.21.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.20.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.19.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.18.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.17.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.16.0 spec/extensions/pg_loose_count_spec.rb
asana2flowdock-1.0.0 vendor/bundle/ruby/1.9.1/gems/sequel-4.15.0/spec/extensions/pg_loose_count_spec.rb
sequel-4.15.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.14.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.13.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.12.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.11.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.10.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.9.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.8.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.7.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.6.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.5.0 spec/extensions/pg_loose_count_spec.rb
sequel-4.4.0 spec/extensions/pg_loose_count_spec.rb