Contents

AircraftClass.class_eval do
  data_miner do
    schema Earth.database_options do
      string  'code'
      string  'name'
      float   'm1'
      float   'm2'
      float   'm3'
      float   'endpoint_fuel'
      float   'seats'
    end
    
    import "a list of Brighter Planet-defined aircraft classes",
           :url => 'https://spreadsheets.google.com/pub?key=0AoQJbWqPrREqdGNBbHFibmxJUFprQkUwZHp6VU51Smc&hl=en&single=true&gid=0&output=csv' do
      key 'code', :field_name => 'aircraft_class_code'
      store 'name'
    end
    
    process "Derive some average aircraft chraracteristics from aircraft" do
      Aircraft.run_data_miner!
      aircraft = Aircraft.arel_table
      aircraft_classes = AircraftClass.arel_table
      conditional_relation = aircraft_classes[:code].eq(aircraft[:class_code])
      
      %w{ m1 m2 m3 endpoint_fuel seats }.each do |column|
        relation = Aircraft.weighted_average_relation(column).where(conditional_relation)
        update_all "#{column} = (#{relation.to_sql})"
      end
    end
    
    # FIXME TODO verify this
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
earth-0.4.4	lib/earth/air/aircraft_class/data_miner.rb
earth-0.4.3	lib/earth/air/aircraft_class/data_miner.rb
earth-0.4.2	lib/earth/air/aircraft_class/data_miner.rb
earth-0.4.1	lib/earth/air/aircraft_class/data_miner.rb
earth-0.4.0	lib/earth/air/aircraft_class/data_miner.rb
earth-0.3.15	lib/earth/air/aircraft_class/data_miner.rb
earth-0.3.14	lib/earth/air/aircraft_class/data_miner.rb
earth-0.3.13	lib/earth/air/aircraft_class/data_miner.rb