mecs_ratio_spec.rb in earth-0.11.11

- old
+ new
@@ -3,31 +3,38 @@
 
 describe MecsRatio do
   before :all do
     MecsRatio.auto_upgrade!
   end
-
-  describe '.find_by_naics_code_and_census_region' do
+  
+  describe '.find_by_naics_code_and_census_region_number' do
     before do
-      MecsRatio.create! :naics_code => '312', :census_region => '1', :consumption_per_dollar_of_shipments => 11
-      MecsRatio.create! :naics_code => '3121', :census_region => '1', :consumption_per_dollar_of_shipments => 12
-      MecsRatio.create! :naics_code => '3122', :census_region => '1', :consumption_per_dollar_of_shipments => 13
-      MecsRatio.create! :naics_code => '312', :census_region => '2', :consumption_per_dollar_of_shipments => 17
-      MecsRatio.create! :naics_code => '3121', :census_region => '2', :consumption_per_dollar_of_shipments => 18
-      MecsRatio.create! :naics_code => '3122', :census_region => '2', :consumption_per_dollar_of_shipments => 19
-      MecsRatio.create! :naics_code => '312211', :census_region => '2', :consumption_per_dollar_of_shipments => 20
+      MecsRatio.create! :naics_code => '311', :census_region_number => 1, :energy_per_dollar_of_shipments => 11
+      MecsRatio.create! :naics_code => '3112', :census_region_number => 1, :energy_per_dollar_of_shipments => 12
+      MecsRatio.create! :naics_code => '311221', :census_region_number => 1, :energy_per_dollar_of_shipments => 13
+      MecsRatio.create! :naics_code => '31131', :census_region_number => 1, :energy_per_dollar_of_shipments => 13
+      MecsRatio.create! :naics_code => '311', :census_region_number => 2, :energy_per_dollar_of_shipments => 17
+      MecsRatio.create! :naics_code => '3112', :census_region_number => 2, :energy_per_dollar_of_shipments => 18
+      MecsRatio.create! :naics_code => '311221', :census_region_number => 2, :energy_per_dollar_of_shipments => 19
+      MecsRatio.create! :naics_code => '31131', :census_region_number => 2, :energy_per_dollar_of_shipments => 20
     end
+    
     it 'finds an exact match' do
-      MecsRatio.find_by_naics_code_and_census_region('312211', '2').
-        naics_code.should == '312211'
+      ratio = MecsRatio.find_by_naics_code_and_census_region_number('311221', 2)
+      ratio.naics_code.should == '311221'
+      ratio.census_region_number.should == 2
     end
-    it 'finds a parent category by prefix' do
-      MecsRatio.find_by_naics_code_and_census_region('312199', '2').
-        naics_code.should == '3121'
+    it 'finds a parent category when exact code is not present' do
+      ratio = MecsRatio.find_by_naics_code_and_census_region_number('3117', 2)
+      ratio.naics_code.should == '311'
+      ratio.census_region_number.should == 2
     end
+    it 'finds a parent category rather than a sibling category' do
+      ratio = MecsRatio.find_by_naics_code_and_census_region_number('311225', 2)
+      ratio.naics_code.should == '3112'
+      ratio.census_region_number.should == 2
+    end
     it 'returns nil if no match found' do
-      MecsRatio.find_by_naics_code_and_census_region('543211', '2').
-        should be_nil
+      MecsRatio.find_by_naics_code_and_census_region_number('543211', 2).should be_nil
     end
   end
 end
-