Sha256: 93dc89d136e85293348e1d672cb6abd6dc279aeaa1731552dc60dd2357e32e37
Contents?: true
Size: 1.17 KB
Versions: 15
Compression:
Stored size: 1.17 KB
Contents
require File.join(File.dirname(__FILE__), 'spec_helper.rb')
unless defined?(ADO_DB)
ADO_DB = Sequel.ado(:host => 'MY_SQL_SERVER', :database => 'MyDB', :user => 'my_pwd', :password => 'my_usr')
end
context "An ADO dataset" do
before(:each) do
ADO_DB.create_table!(:items) { text :name }
end
specify "should not raise exceptions when working with empty datasets" do
lambda {
ADO_DB[:items].all
}.should_not raise_error
end
end
context "An MSSQL dataset" do
before(:each) do
ADO_DB.create_table!(:items) { text :name }
end
specify "should assign a default name to anonymous columns" do
col = ADO_DB.fetch('SELECT COUNT(*) FROM items').columns[0]
col.to_s.should == '(no column name)'
end
specify "should support counting" do
ADO_DB[:items] << {:name => 'my name' }
ADO_DB[:items].count.should == 1
end
specify "should support first" do
ADO_DB[:items] << {:name => 'x' }
ADO_DB[:items] << {:name => 'y' }
ADO_DB[:items].first[:name].should == 'x'
end
specify "should support limit" do
3.times do
ADO_DB[:items] << {:name => 'my name' }
end
ADO_DB[:items].limit(2).all.size.should == 2
end
end
Version data entries
15 entries across 15 versions & 3 rubygems