Sha256: ece5f4ebea8313af53db99cfc6ddd1e9b4fb726afd3cbebf6e18643d96684d7c
Contents?: true
Size: 1.76 KB
Versions: 20
Compression:
Stored size: 1.76 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, :reference_codes, :reference_types
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_on_joined_relations_that_have_column_names_in_common
count_without_includes = ReferenceCode.count
count_with_includes = ReferenceCode.includes(:reference_type).references(:reference_type).count
assert_equal(count_without_includes, count_with_includes)
assert_equal(5, count_with_includes)
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
20 entries across 20 versions & 1 rubygems