def save_db_parameter(Parameter):
with app.app_context():
db=get_db()
db.execute('insert into parameter(update_time,time1,temperature1,time2,temperature2,time3,temperature3,time4,temperature4, co2_upper_limit,co2_lower_limit, cooling_start_temperature,cooling_stop_temperature,\
expect_humidity,humidity_influence_range_of_air_temperature,low_humidity_influence_on_air_temperature,high_humidity_influence_on_air_temperature,expect_light,light_influence_on_air_temperature_slope,high_light_influence_on_temperature,low_light_influence_on_temperature,frost_temperature,\
indoor_temperature_lower_limit,roof_vent_wind_speed_upper_limit,roof_vent_rain_upper_limit, heating_start_lowest_temperature,heating_stop_highest_temperature, month_to_open_thermal_screen,month_to_close_thermal_screen,time_to_open_thermal_screen,time_to_close_thermal_screen, temperature_to_open_side,\
wait_time_to_open_side,rain_upper_limit_to_close, upper_limit_light_to_open_shade_screen_out,upper_limit_light_to_open_shade_screen_in,soil_humidity_to_start_irrigation,soil_humidity_to_stop_irrigation,temperature_to_open_fogging,temperature_to_open_cooling_pad,\
month_to_open_lighting,month_to_close_lighting,period1_start_lighting,period1_stop_lighting,period2_start_lighting,period2_stop_lighting,radiation1_to_open_lighting,radiation2_to_open_lighting,roof_vent_open_time,side_vent_open_time,shade_screen_out_open_time,\
shade_screen_in_open_time,thermal_screen_open_time ) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)',\
[get_current_time(),Parameter.get_time_1(),Parameter.get_temperature_1(),Parameter.get_time_2(),Parameter.get_temperature_2(),Parameter.get_time_3(),Parameter.get_temperature_3(),Parameter.get_time_4(),Parameter.get_temperature_4(),Parameter.get_co_2_upper_limit(),Parameter.get_co_2_lower_limit(),
Parameter.get_cooling_start_temperature(),Parameter.get_cooling_stop_temperature(),
Parameter.get_expect_humidity(),Parameter.get_humidity_influence_range_of_air_temperature(),Parameter.get_low_humidity_influence_on_air_temperature(),Parameter.get_high_humidity_influence_on_air_temperature(),Parameter.get_expect_light(),Parameter.get_light_influence_on_air_temperature_slope(),
Parameter.get_high_light_influence_on_temperature(),Parameter.get_low_light_influence_on_temperature(),Parameter.get_frost_temperature(),Parameter.get_indoor_temperature_lower_limit(),Parameter.get_roof_vent_wind_speed_upper_limit(),Parameter.get_roof_vent_rain_upper_limit(),
Parameter.get_heating_start_lowest_temperature(),Parameter.get_heating_stop_highest_temperature(),Parameter.get_month_to_open_thermal_screen(),Parameter.get_month_to_close_thermal_screen(),Parameter.get_time_to_open_thermal_screen(),Parameter.get_time_to_close_thermal_screen(),
Parameter.get_temperature_to_open_side(),
Parameter.get_wait_time_to_open_side(),
Parameter.get_rani_upper_limit_to_close(),
Parameter.get_upper_limit_light_to_open_shade_screen_out(),
Parameter.get_upper_limit_light_to_open_shade_screen_in(),
Parameter.get_soil_humidity_to_start_irrigation(),
Parameter.get_soil_humidity_to_stop_irrigation(),
Parameter.get_temperature_to_open_fogging(),
Parameter.get_temperature_to_open_cooling_pad(),
Parameter.get_month_to_open_lighting(),
Parameter.get_month_to_close_lighting(),
Parameter.get_period_1_start_lighting(),
Parameter.get_period_1_stop_lighting(),
Parameter.get_period_2_start_lighting(),
Parameter.get_period_2_stop_lighting(),
Parameter.get_radiation_1_to_open_lighting(),
Parameter.get_radiation_2_to_open_lighting(),
Parameter.get_roof_vent_open_time(),
Parameter.get_side_vent_time(),
Parameter.get_shade_screen_out_time(),
Parameter.get_shade_screen_in_time(),
Parameter.get_thermal_screen_open_time()
])
db.commit()
print 'parameter save success'
