query_builder_spec.rb

require File.expand_path(File.dirname(__FILE__) + '/../spec_helper')

describe Yql::QueryBuilder do

  describe ".show_tables" do

    it "should return show tables string" do
      Yql::QueryBuilder.show_tables.should eql('show tables;')
    end

  end

  describe ".describe_table" do

    it "should return the describe tables query" do
      Yql::QueryBuilder.describe_table('yql.table.name').should eql('desc yql.table.name;')
    end

  end

  describe "#describe_table" do

    before(:each) do
      @query_builder = Yql::QueryBuilder.new('yql.table.name')
    end

    it "should describe the current table using class method" do
      Yql::QueryBuilder.should_receive(:describe_table).with('yql.table.name')
      @query_builder.describe_table
    end

    it "should return the result from the class method" do
      Yql::QueryBuilder.stub!(:describe_table).and_return('table description')
      @query_builder.describe_table.should eql('table description')
    end

  end

  describe "#find" do

    before(:each) do
      @query_builder = Yql::QueryBuilder.new('yql.table.name')
      @query_builder.stub!(:construct_query).and_return('The yql query')
    end

    it "should set the limit of records to 1 by default" do
      @query_builder.should_receive(:limit=).with(1)
      @query_builder.find
    end

    it "should construct the query" do
      @query_builder.should_receive(:construct_query)
      @query_builder.find
    end

    it "should return the constructed query" do
      @query_builder.find.should eql('The yql query')
    end

  end

  describe "#find_all" do

    before(:each) do
      @query_builder = Yql::QueryBuilder.new('yql.table.name')
      @query_builder.stub!(:construct_query).and_return('The yql query')
    end

    it "should set the limit of records to nil" do
      @query_builder.should_receive(:limit=).with(nil)
      @query_builder.find_all
    end

    it "should set the with provided hash" do
      @query_builder.should_receive(:limit=).with(10)
      @query_builder.find_all({:limit => 10})
    end

    it "should construct the query" do
      @query_builder.should_receive(:construct_query)
      @query_builder.find_all
    end

    it "should return the constructed query" do
      @query_builder.find_all.should eql('The yql query')
    end

  end

  describe "#to_s" do

    before(:each) do
      @query_builder = Yql::QueryBuilder.new('yql.table.name')
      @query_builder.stub!(:construct_query).and_return('The yql query')
    end

    it "should construct the query" do
      @query_builder.should_receive(:construct_query)
      @query_builder.to_s
    end

    it "should return the constructed query" do
      @query_builder.to_s.should eql('The yql query')
    end

  end

  describe "#limit" do

    before(:each) do
      @query_builder = Yql::QueryBuilder.new('yql.table.name')
    end

    it "should return nil if @limit instance is not set" do
      @query_builder.limit.should be_nil
    end

    it "should return the limit text with limit number" do
      @query_builder.limit = 3
      @query_builder.limit.should eql('limit 3')
    end

  end

  describe "#conditions" do

    before(:each) do
      @query_builder = Yql::QueryBuilder.new('yql.table.name')
    end

    context "when condition is set as string" do

      it "should return the condition string with where clause" do
        @query_builder.conditions = "some sql like yql conditions"
        @query_builder.conditions.should eql('where some sql like yql conditions')
      end

    end

    context "when condition is passed as a hash" do

      before(:each) do
        @query_builder.conditions = {:attr1 => 'val1', :attr2 => 'val2', :attr3 => 4, :attr4 => '5'}
      end

      it "should 'where' text in the beginning of the return value" do
        @query_builder.conditions.should match(/^where attr/)
        # @query_builder.conditions.should match("where key1='val1' and key2='val2' and key3=4 and key4='5'")
      end

      it "should have the attr1 key value pair" do
        @query_builder.conditions.should match(/attr1='val1'/)
      end

      it "should have the attr2 key value pair" do
        @query_builder.conditions.should match(/attr2='val2'/)
      end

      it "should have the attr3 key value pair as integer" do
        @query_builder.conditions.should match(/attr3=4/)
      end

      it "should have the attr3 key value pair integer as string" do
        @query_builder.conditions.should match(/attr4='5'/)
      end

      it "should have 'and' only thrice in the returned value as there are 4 key values passed to condition" do
        @query_builder.conditions.scan('and').size.should eql(3)
      end

    end

  end

end