Contents

require File.expand_path('../abstract_unit', __FILE__)

class TestCalculations < ActiveSupport::TestCase
  fixtures :articles, :products, :tariffs, :product_tariffs, :suburbs, :streets, :restaurants,
           :dorms, :rooms, :room_attributes, :room_attribute_assignments, :students, :room_assignments, :users, :readings,
           :departments, :employees, :memberships, :membership_statuses

  def test_count
    assert_equal(3, Product.includes(:product_tariffs).count)
    assert_equal(3, Tariff.includes(:product_tariffs).count)

    expected = {Date.today => 2,
                Date.today.next => 1}

    assert_equal(expected, Tariff.group(:start_date).count)
  end

  def test_count_distinct
    product = products(:first_product)
    assert_equal(1, product.product_tariffs.select('tariff_start_date').distinct.count)
  end
  
  def test_count_not_distinct
    product = products(:first_product)
    assert_equal(2, product.product_tariffs.select('tariff_start_date').count)
  end

  def test_count_includes
    count = Dorm.where("rooms.room_id = ?", 2).includes(:rooms).references(:rooms).count
    assert_equal(1, count)
  end

  def test_count_includes_dup_columns
    count = Tariff.includes(:product_tariffs).references(:product_tariffs).where("product_tariffs.tariff_id = ?", 2).count
    assert_equal(1, count)
  end

  def test_average
    average = Tariff.average(:amount)
    assert_equal(50, average)
  end
end

Version data entries

51 entries across 51 versions & 1 rubygems

Version	Path
composite_primary_keys-12.0.9	test/test_calculations.rb
composite_primary_keys-12.0.8	test/test_calculations.rb
composite_primary_keys-12.0.6	test/test_calculations.rb
composite_primary_keys-12.0.5	test/test_calculations.rb
composite_primary_keys-12.0.4	test/test_calculations.rb
composite_primary_keys-12.0.3	test/test_calculations.rb
composite_primary_keys-12.0.2	test/test_calculations.rb
composite_primary_keys-11.3.1	test/test_calculations.rb
composite_primary_keys-8.1.8	test/test_calculations.rb
composite_primary_keys-12.0.1	test/test_calculations.rb
composite_primary_keys-12.0.0	test/test_calculations.rb
composite_primary_keys-12.0.0.rc5	test/test_calculations.rb
composite_primary_keys-12.0.0.rc4	test/test_calculations.rb
composite_primary_keys-12.0.0.rc3	test/test_calculations.rb
composite_primary_keys-12.0.0.rc2	test/test_calculations.rb
composite_primary_keys-12.0.0.rc1	test/test_calculations.rb
composite_primary_keys-8.1.7	test/test_calculations.rb
composite_primary_keys-11.2.0	test/test_calculations.rb
composite_primary_keys-11.1.0	test/test_calculations.rb
composite_primary_keys-11.0.3	test/test_calculations.rb