Example #1
0
def save_db_outdoor(Outdoor):
    with app.app_context():
        db = get_db()
        db.execute('INSERT INTO outdoor(update_time,temperature,humidity,radiation,co2,wind_direction,wind_speed,rain_snow,atmosphere)\
                   VALUES(?,?,?,?,?,?,?,?,?)',
                   [Outdoor.get_update_time(), Outdoor.get_temperature(), Outdoor.get_humidity(), Outdoor.get_radiation(),
                    Outdoor.get_co_2(),
                    Outdoor.get_wind_direction(), \
                    Outdoor.get_wind_speed(), Outdoor.get_rain(), Outdoor.get_atmosphere()])
        db.commit()
        db.close()
    print 'outdoor save success'
Example #2
0
def save_db_outdoor(Outdoor):
    with app.app_context():
        db = get_db()
        db.execute('INSERT INTO outdoor(update_time,temperature,humidity,radiation,co2,wind_direction,wind_speed,rain_snow,atmosphere)\
                   VALUES(?,?,?,?,?,?,?,?,?)',
                   [Outdoor.get_update_time(), Outdoor.get_temperature(), Outdoor.get_humidity(), Outdoor.get_radiation(),
                    Outdoor.get_co_2(),
                    Outdoor.get_wind_direction(),
                    Outdoor.get_wind_speed(), Outdoor.get_rain(), Outdoor.get_atmosphere()])
        db.commit()
        db.close()
    print 'outdoor save success'
Example #3
0
def save_db_outdoor(Outdoor):
    with app.app_context():
        db = get_db()
        db.cursor().execute(
            'insert into outdoor(update_time,temperature,humidity,radiation,co2,wind_direction,wind_speed,rain_snow,atmosphere)\
                   values(%s,%s,%s,%s,%s,%s,%s,%s,%s)', [
                Outdoor.get_update_time(),
                Outdoor.get_temperature(),
                Outdoor.get_humidity(),
                Outdoor.get_radiation(),
                Outdoor.get_co_2(),
                Outdoor.get_wind_direction(),
                Outdoor.get_wind_speed(),
                Outdoor.get_rain(),
                Outdoor.get_atmosphere()
            ])
        db.commit()
    print 'outdoor save success'