def get_db_parameter():
query='select * from parameter where id=(select max(id) from parameter)'
row=query_db(query)
a=1
para=Parameter()
para.set_time_1(row[a])
para.set_temperature_1(row[a+1])
para.set_time_2(row[a+2])
para.set_temperature_2(row[a+3])
para.set_time_3(row[a+4])
para.set_temperature_3(row[a+5])
para.set_time_4(row[a+6])
para.set_temperature_4(row[a+7])
para.set_co_2_upper_limit(row[a+8])
para.set_co_2_lower_limit(row[a+9])
para.set_cooling_start_temperature(row[a+10])
para.set_cooling_stop_temperature(row[a+11])
para.set_expect_humidity(row[a+12])
para.set_humidity_influence_range_of_air_temperature(row[a+13])
para.set_low_humidity_influence_on_air_temperature(row[a+14])
para.set_high_humidity_influence_on_air_temperature(row[a+15])
para.set_expect_light(row[a+16])
para.set_light_influence_on_air_temperature_slope(row[a+17])
para.set_high_light_influence_on_temperature(row[a+18])
para.set_low_light_influence_on_temperature(row[a+19])
para.set_frost_temperature(row[a+20])
para.set_indoor_temperature_lower_limit(row[a+21])
para.set_roof_vent_wind_speed_upper_limit(row[a+22])
para.set_roof_vent_rain_upper_limit(row[a+23])
para.set_heating_start_lowest_temperature(row[a+24])
para.set_heating_stop_highest_temperature(row[a+25])
para.set_month_to_open_thermal_screen(row[a+26])
para.set_month_to_close_thermal_screen(row[a+27])
para.set_time_to_open_thermal_screen(row[a+28])
para.set_time_to_close_thermal_screen(row[a+29])
para.set_temperature_to_open_side(row[a+30])
para.set_wait_time_to_open_side(row[a+31])
para.set_rani_upper_limit_to_close(row[a+32])
para.set_upper_limit_light_to_open_shade_screen_out(row[a+33])
para.set_upper_limit_light_to_open_shade_screen_in(row[a+34])
para.set_soil_humidity_to_start_irrigation(row[a+35])
para.set_soil_humidity_to_stop_irrigation(row[a+36])
para.set_temperature_to_open_fogging(row[a+37])
para.set_temperature_to_open_cooling_pad(row[a+38])
para.set_month_to_open_lighting(row[a+39])
para.set_month_to_close_lighting(row[a+40])
para.set_period_1_start_lighting(row[a+41])
para.set_period_1_stop_lighting(row[a+42])
para.set_period_2_start_lighting(row[a+43])
para.set_period_2_stop_lighting(row[a+44])
para.set_radiation_1_to_open_lighting(row[a+45])
para.set_radiation_2_to_open_lighting(row[a+46])
para.set_roof_vent_open_time(row[a+47])
para.set_side_vent_time(row[a+48])
para.set_shade_screen_out_time(row[a+49])
para.set_shade_screen_in_time(row[a+50])
para.set_thermal_screen_open_time(row[a+51])
return para.build_to_json()
print 'get parameter success'
