Contents

require 'spec_helper'

describe ActiveRecord::MTI::Calculations do

  context 'when an exception occurs' do
    it 'does not continue to adversely affect additional queries' do
      Admin.create(email: 'bob')
      expect{ Admin.joins(Transportation::Vehicle).count }.to raise_error(RuntimeError)
      expect(Thread.current['skip_tableoid_cast']).to_not eq(true)
      expect(Admin.count).to eq(1)
    end
  end

  context "don't project tableoid on" do
    it "grouping" do

      Admin.create(email: '[e-mail]', god_powers: 3)
      Admin.create(email: '[e-mail]', god_powers: 3)
      Admin.create(email: '[e-mail]', god_powers: 3)

      grouped_count = Admin.group(:email).count

      expect(grouped_count['[e-mail]']).to eq(1)
      expect(grouped_count['[e-mail]']).to eq(2)

    end

    it "count calculations" do

      Admin.create(email: '[e-mail]', god_powers: 3)
      Admin.create(email: '[e-mail]', god_powers: 3)
      Admin.create(email: '[e-mail]', god_powers: 3)

      expect(Admin.count(:email)).to eq(3)

    end
  end

  context "projects tableoid" do
    it "and groups tableoid when selecting :tableoid" do
      sql = Admin.select(:email, :tableoid).group(:email).to_sql

      expect(sql).to match(/SELECT .*, \"admins\".\"tableoid\" AS tableoid FROM \"admins\"/)

      expect(sql).to match(/GROUP BY .*, \"admins\".\"tableoid\"/)
    end

    it "when grouping :tableoid" do
      sql = Admin.select(:email).group(:email, :tableoid).to_sql

      expect(sql).to match(/SELECT .*, \"admins\".\"tableoid\" AS tableoid FROM \"admins\"/)

      expect(sql).to match(/GROUP BY .*, \"admins\".\"tableoid\"/)
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
active_record-mti-0.3.2	spec/active_record/mti/calculations_spec.rb
active_record-mti-0.3.0.pre.rc4	spec/active_record/mti/calculations_spec.rb