Contents

require File.dirname(__FILE__) + '/helper'

##
# Once dynamically, once hardcoded
context "Different types" do
  types_hash = {
        'string' => "'string'",
         :symbol => "'--- :symbol\n'",
               1 => '1',
             1.2 => '1.2',
            true => '1',
           false => '0',
        Time.now => "'#{Time.now.to_s(:db)}'",
    DateTime.now => "'#{DateTime.now.to_s(:db)}'",
      Date.today => "'#{Date.today.to_s(:db)}'"
  }

  types_hash.each do |type, translation|
    specify "simple using #{type}" do
      sql = User.select { |m| m.name == type }.to_s
      sql.should == "SELECT * FROM users WHERE users.name = #{translation}"
    end
  end

  specify "float" do
    sql = User.select { |m| m.name == 1.2 }.to_s
    sql.should == "SELECT * FROM users WHERE users.name = 1.2"
  end
  
  specify "integer" do
    sql = User.select { |m| m.name == 1 }.to_s
    sql.should == "SELECT * FROM users WHERE users.name = 1"
  end
  
  specify "true" do
    sql = User.select { |m| m.name == true }.to_s
    sql.should == "SELECT * FROM users WHERE users.name = 1"
  end
  
  specify "false" do
    sql = User.select { |m| m.name == false }.to_s
    sql.should == "SELECT * FROM users WHERE users.name = 0"
  end

  specify "nil" do
    sql = User.select { |m| m.name == nil }.to_s
    sql.should == "SELECT * FROM users WHERE users.name IS NULL"
  end

  specify "not nil" do
    sql = User.select { |m| m.name != nil }.to_s
    sql.should == "SELECT * FROM users WHERE users.name IS NOT NULL"
  end

  specify "nil?" do
    sql = User.select { |m| m.name.nil? }.to_s
    sql.should == "SELECT * FROM users WHERE users.name IS NULL"
  end

  specify "!nil?" do
    sql = User.select { |m| !m.name.nil? }.to_s
    sql.should == "SELECT * FROM users WHERE users.name IS NOT NULL"
  end

  specify "Time" do
    sql = User.select { |m| m.name == Time.now }.to_s
    sql.should == "SELECT * FROM users WHERE users.name = '#{Time.now.to_s(:db)}'"
  end
end

Version data entries

11 entries across 11 versions & 2 rubygems

Version	Path
benhoskings-ambitious-activerecord-0.1.3.1	test/types_test.rb
benhoskings-ambitious-activerecord-0.1.3.2	test/types_test.rb
benhoskings-ambitious-activerecord-0.1.3.3	test/types_test.rb
benhoskings-ambitious-activerecord-0.1.3.4	test/types_test.rb
benhoskings-ambitious-activerecord-0.1.3.5	test/types_test.rb
benhoskings-ambitious-activerecord-0.1.3.6	test/types_test.rb
benhoskings-ambitious-activerecord-0.1.3.7	test/types_test.rb
benhoskings-ambitious-activerecord-0.1.3	test/types_test.rb
benhoskings-ambitious-activerecord-0.1.3.8	test/types_test.rb
ambitious-activerecord-0.1.3	test/types_test.rb
ambitious-activerecord-0.1.1	test/types_test.rb