Sha256: 7bf6bd98bf0dc08681b9b6f526a14e959bc75f290f5846679d5162a60c58314f
Contents?: true
Size: 798 Bytes
Versions: 8
Compression:
Stored size: 798 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)
@db.extend_datasets{def quote_identifiers?; false end}
end
it "should add loose_count method getting fast count for entire table using table statistics" do
@db.loose_count(:a).must_equal 1
@db.sqls.must_equal ["SELECT CAST(reltuples AS integer) AS v FROM pg_class WHERE (oid = CAST(CAST('a' AS regclass) AS oid)) LIMIT 1"]
end
it "should support schema qualified tables" do
@db.loose_count(:a__b).must_equal 1
@db.sqls.must_equal ["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
8 entries across 7 versions & 2 rubygems