lib/earth/automobile/automobile_make/data_miner.rb in earth-0.3.15 vs lib/earth/automobile/automobile_make/data_miner.rb in earth-0.4.0

@@ -17,9 +17,20 @@
         SELECT DISTINCT automobile_make_model_year_variants.make_name
         FROM automobile_make_model_year_variants
       }
     end
     
+    # sabshere 1/31/11 add Avanti, DaimlerChrysler, IHC, Tesla, etc.
+    process "Derive extra manufacturer names from CAFE data" do
+      AutomobileMakeFleetYear.run_data_miner!
+      connection.execute %{
+        INSERT IGNORE INTO automobile_makes(name)
+        SELECT DISTINCT automobile_make_fleet_years.make_name
+        FROM automobile_make_fleet_years
+      }
+    end
+    
+    # FIXME TODO make this a method on AutomobileMake?
     process "Calculate fuel efficiency from automobile make fleet years for makes with CAFE data" do
       AutomobileMakeFleetYear.run_data_miner!
       make_fleet_years = AutomobileMakeFleetYear.arel_table
       makes = AutomobileMake.arel_table
       conditional_relation = makes[:name].eq(make_fleet_years[:make_name])