Sha256: 89fa320d9fd1825eb0b31b0e4dca32a2f26a4a479f0e1c966991b4dc3982acd1
Contents?: true
Size: 1.01 KB
Versions: 19
Compression:
Stored size: 1.01 KB
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 "Brighter Planet's 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
end
end
Version data entries
19 entries across 19 versions & 1 rubygems