require 'spec_helper'
require 'everywhere/hash_key'

describe 'normal query' do
  before do
    @where = Post.where(:title => 'hello').where_values
  end
  subject { @where }
  it { @where.should have(1).item }
  subject { @where.first }
  its(:to_sql) { should == %q["posts"."title" = 'hello'] }
end

describe 'not eq' do
  before do
    @where = Post.where(:not => {:title => 'hello'}).where_values
  end
  subject { @where }
  it { @where.should have(1).item }
  subject { @where.first }
  its(:to_sql) { should == %q["posts"."title" != 'hello'] }
end

describe 'not null' do
  before do
    @where = Post.where(:not => {:created_at => nil}).where_values
  end
  subject { @where }
  it { @where.should have(1).item }
  subject { @where.first }
  its(:to_sql) { should == %q["posts"."created_at" IS NOT NULL] }
end

describe 'not in' do
  before do
    @where = Post.where(:not => {:title => %w[hello goodbye]}).where_values
  end
  subject { @where }
  it { @where.should have(1).item }
  subject { @where.first }
  its(:to_sql) { should == %q["posts"."title" NOT IN ('hello', 'goodbye')] }
end

describe 'association' do
  before do
    @where = Post.joins(:comments).where(:comments => {:not => {:body => 'foo'}}).where_values
  end
  subject { @where }
  it { @where.should have(1).item }
  subject { @where.first }
  its(:to_sql) { should == %q["comments"."body" != 'foo'] }
end