Sha256: be76e30b3a43f2ab78b5e3eecc6e0e081a89b1899b74563305f72b45537ca7f9

Contents?: true

Size: 1.31 KB

Versions: 23

Compression:

Stored size: 1.31 KB

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
end

Version data entries

23 entries across 23 versions & 1 rubygems

Version Path
composite_primary_keys-8.1.1 test/test_calculations.rb
composite_primary_keys-7.0.14 test/test_calculations.rb
composite_primary_keys-8.1.0 test/test_calculations.rb
composite_primary_keys-7.0.13 test/test_calculations.rb
composite_primary_keys-6.0.8 test/test_calculations.rb
composite_primary_keys-8.0.0 test/test_calculations.rb
composite_primary_keys-7.0.12 test/test_calculations.rb
composite_primary_keys-7.0.11 test/test_calculations.rb
composite_primary_keys-6.0.7 test/test_calculations.rb
composite_primary_keys-7.0.10 test/test_calculations.rb
composite_primary_keys-7.0.9 test/test_calculations.rb
composite_primary_keys-7.0.8 test/test_calculations.rb
composite_primary_keys-7.0.7 test/test_calculations.rb
composite_primary_keys-7.0.6 test/test_calculations.rb
composite_primary_keys-7.0.5 test/test_calculations.rb
composite_primary_keys-7.0.4 test/test_calculations.rb
composite_primary_keys-7.0.3 test/test_calculations.rb
composite_primary_keys-7.0.2 test/test_calculations.rb
composite_primary_keys-7.0.1 test/test_calculations.rb
composite_primary_keys-7.0.0 test/test_calculations.rb