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

context "Where (using select)" do
  specify "simple ==" do
    sql = User.select { |m| m.name == 'jon' }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name = 'jon'"
  end

  specify "simple !=" do
    sql = User.select { |m| m.name != 'jon' }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name <> 'jon'"
  end

  specify "simple == && ==" do
    sql = User.select { |m| m.name == 'jon' && m.age == 21 }.to_sql
    sql.should == "SELECT * FROM users WHERE (users.name = 'jon' AND users.age = 21)"
  end

  specify "simple == || ==" do
    sql = User.select { |m| m.name == 'jon' || m.age == 21 }.to_sql
    sql.should == "SELECT * FROM users WHERE (users.name = 'jon' OR users.age = 21)"
  end

  specify "mixed && and ||" do
    sql = User.select { |m| m.name == 'jon' || m.age == 21 && m.password == 'pass' }.to_sql
    sql.should == "SELECT * FROM users WHERE (users.name = 'jon' OR (users.age = 21 AND users.password = 'pass'))"
  end

  specify "grouped && and ||" do
    sql = User.select { |m| (m.name == 'jon' || m.name == 'rick') && m.age == 21 }.to_sql
    sql.should == "SELECT * FROM users WHERE ((users.name = 'jon' OR users.name = 'rick') AND users.age = 21)"
  end

  specify "simple >/<" do
    sql = User.select { |m| m.age > 21 }.to_sql
    sql.should == "SELECT * FROM users WHERE users.age > 21"

    sql = User.select { |m| m.age >= 21 }.to_sql
    sql.should == "SELECT * FROM users WHERE users.age >= 21"

    sql = User.select { |m| m.age < 21 }.to_sql
    sql.should == "SELECT * FROM users WHERE users.age < 21"
  end

  specify "array.include? item" do
    sql = User.select { |m| [1, 2, 3, 4].include? m.id }.to_sql
    sql.should == "SELECT * FROM users WHERE users.id IN (1, 2, 3, 4)"
  end

  specify "simple == with variables" do
    me = 'chris'
    sql = User.select { |m| m.name == me }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name = '#{me}'"
  end

  specify "simple == with method arguments" do
    def test_it(name)
      sql = User.select { |m| m.name == name }.to_sql
      sql.should == "SELECT * FROM users WHERE users.name = '#{name}'"
    end

    test_it('chris')
  end

  specify "simple == with instance variables" do
    @me = 'chris'
    sql = User.select { |m| m.name == @me }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name = '#{@me}'"
  end

  xspecify "simple == with instance variable method call" do
    require 'ostruct'
    @person = OpenStruct.new(:name => 'chris')

    sql = User.select { |m| m.name == @person.name }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name = '#{@person.name}'"
  end

  specify "simple == with global variables" do
    $my_name = 'boston'
    sql = User.select { |m| m.name == $my_name }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name = '#{$my_name}'"
  end

  specify "simple == with method call" do
    def band
      'megadeth'
    end

    sql = User.select { |m| m.name == band }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name = '#{band}'"
  end

  specify "simple =~ with string" do
    sql = User.select { |m| m.name =~ 'chris' }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name LIKE 'chris'"

    sql = User.select { |m| m.name =~ 'chri%' }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name LIKE 'chri%'"
  end

  specify "simple !~ with string" do
    sql = User.select { |m| m.name !~ 'chris' }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name NOT LIKE 'chris'"

    sql = User.select { |m| !(m.name =~ 'chris') }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name NOT LIKE 'chris'"
  end

  specify "simple =~ with regexp" do
    sql = User.select { |m| m.name =~ /chris/ }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name REGEXP 'chris'"
  end

  specify "simple =~ with regexp flags" do
    sql = User.select { |m| m.name =~ /chris/i }.to_sql
    sql.should == "SELECT * FROM users WHERE users.name REGEXP 'chris'"
  end

  specify "simple LOWER()" do
    sql = User.select { |m| m.name.downcase =~ 'chris%' }.to_sql
    sql.should == "SELECT * FROM users WHERE LOWER(users.name) LIKE 'chris%'"
  end

  specify "simple UPPER()" do
    sql = User.select { |m| m.name.upcase =~ 'chris%' }.to_sql
    sql.should == "SELECT * FROM users WHERE UPPER(users.name) LIKE 'chris%'"
  end

  specify "undefined equality symbol" do
    should.raise { User.select { |m| m.name =* /chris/ }.to_sql }
  end
  
  xspecify "simple == with inline ruby" do
    # TODO: implement this
    sql = User.select { |m| m.created_at == 2.days.ago.to_s(:db) }.to_sql
    sql.should == "SELECT * FROM users WHERE users.created_at = #{2.days.ago.to_s(:db)}"
  end

  specify "inspect" do
    User.select { |u| u.name }.inspect.should.match %r(call #to_sql or #to_hash)
  end
end

context "Where (using detect)" do
  specify "simple ==" do
    conditions = { :conditions => "users.name = 'chris'", :limit => '1' }
    User.expects(:find).with(:first, conditions)
    User.detect { |m| m.name == 'chris' }
  end

  specify "nothing found" do
    conditions = { :conditions => "users.name = 'chris'", :limit => '1' }
    User.expects(:find).with(:first, conditions).returns(nil)
    User.detect { |m| m.name == 'chris' }.should.be.nil
  end
end