Sha256: b9f8d14d3eb4eee0cb0da42a32e744a07beca076afd90fc9e87722d6c1b69327
Contents?: true
Size: 1.41 KB
Versions: 5
Compression:
Stored size: 1.41 KB
Contents
require File.join(File.dirname(File.expand_path(__FILE__)), "spec_helper")
describe "prepared_statements_with_pk plugin" do
before do
@c = Class.new(Sequel::Model(:people))
@c.columns :id, :name, :i
@ds = ds = @c.dataset
def ds.fetch_rows(sql)
db << {:server=>@opts[:server] || :read_only}.merge(opts)[:server]
super{|h|}
yield(:id=>1, :name=>'foo', :i=>2)
end
@c.plugin :prepared_statements_with_pk
@p = @c.load(:id=>1, :name=>'foo', :i=>2)
@c.db.execute 'foo'
@sqls = @c.db.sqls
@sqls.clear
end
specify "should load the prepared_statements plugin" do
@c.plugins.should include(Sequel::Plugins::PreparedStatements)
end
specify "should correctly lookup by primary key from dataset" do
@c.dataset.filter(:name=>'foo')[1].should == @p
@sqls.should == [:read_only, "SELECT * FROM people WHERE ((name = 'foo') AND (id = 1)) LIMIT 1"]
end
specify "should still work correctly if there are multiple conflicting variables" do
@c.dataset.filter(:name=>'foo').or(:name=>'bar')[1].should == @p
@sqls.should == [:read_only, "SELECT * FROM people WHERE (((name = 'foo') OR (name = 'bar')) AND (id = 1)) LIMIT 1"]
end
specify "should still work correctly if the primary key is used elsewhere in the query" do
@c.dataset.filter{id > 2}[1].should == @p
@sqls.should == [:read_only, "SELECT * FROM people WHERE ((id > 2) AND (id = 1)) LIMIT 1"]
end
end
Version data entries
5 entries across 5 versions & 1 rubygems