Пример #1
0
def save_db_indoor(Indoor):
    with app.app_context():
        db = get_db()
        db.execute(
            'INSERT INTO indoor(node_number,update_time,temperature,humidity,radiation,co2) VALUES(?,?,?,?,?,?)',
            [
                Indoor.get_name(),
                Indoor.get_update_time(),
                Indoor.get_temperature(),
                Indoor.get_humidity(),
                Indoor.get_radiation(),
                Indoor.get_co2()
            ])
        db.commit()
        db.close()
    print 'indoor save success'
Пример #2
0
def save_db_indoor(Indoor):
    with app.app_context():
        db = get_db()
        indoor_node = "indoor_node_" + Indoor.get_name()
        db.cursor().execute(
            'insert into ' + indoor_node +
            '(node,update_time,temperature,humidity,radiation,co2) values(%s,%s,%s,%s,%s,%s)',
            [
                Indoor.get_name(),
                get_current_time(),
                Indoor.get_temperature(),
                Indoor.get_humidity(),
                Indoor.get_radiation(),
                Indoor.get_co2()
            ])
        db.commit()
        db.cursor().close()
        db.close()
    print 'indoor save success'
Пример #3
0
def save_db_indoor(Indoor):
    with app.app_context():
        db = get_db()
        db.execute('INSERT INTO indoor(node_number,update_time,temperature,humidity,radiation,co2) VALUES(?,?,?,?,?,?)',
                   [Indoor.get_name(), Indoor.get_update_time(), Indoor.get_temperature(), Indoor.get_humidity(),
                    Indoor.get_radiation(), Indoor.get_co2()])
        db.commit()
        db.close()
    print 'indoor save success'