Contents

require 'spec_helper'
require 'active_record/turntable/sql_tree_patch'

describe SQLTree do
  before(:all) do
    reload_turntable!(File.join(File.dirname(__FILE__), "../../config/turntable.yml"))
  end

  context "Insert query with binary string" do
    subject { SQLTree["INSERT INTO `hogehoge` (`name`) VALUES (x'deadbeef')"] }
    it { expect { subject }.to_not raise_error }
    its(:to_sql) { is_expected.to include("x'deadbeef") }
  end

  context "Select query with index hint" do
    ["FORCE INDEX", "IGNORE INDEX", "USE INDEX"].each do |hint|
      context hint do
        subject { SQLTree["SELECT * FROM table #{hint} (`foo`) WHERE field = 'value'"] }
        it { expect { subject }.to_not raise_error }
        its(:to_sql) { is_expected.to include("#{hint} (`foo`)") }
      end
    end
  end

  context "Select query without index hint" do
    subject { SQLTree["SELECT * FROM table WHERE field = 'value'"] }
    it { expect { subject }.to_not raise_error }
  end

  context "Delete query" do
    subject { SQLTree["DELETE FROM table"] }
    it { expect { subject }.to_not raise_error }
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
activerecord-turntable-2.5.0	spec/active_record/turntable/sql_tree_patch_spec.rb
activerecord-turntable-2.4.0	spec/active_record/turntable/sql_tree_patch_spec.rb
activerecord-turntable-2.3.3	spec/active_record/turntable/sql_tree_patch_spec.rb
activerecord-turntable-2.3.2	spec/active_record/turntable/sql_tree_patch_spec.rb
activerecord-turntable-2.3.1	spec/active_record/turntable/sql_tree_patch_spec.rb
activerecord-turntable-2.3.0	spec/active_record/turntable/sql_tree_patch_spec.rb