display.py 文件源码

def get_data():
    global data_dict
    conn = MySQLdb.Connection(host="localhost", user="root", passwd="123456",
charset="UTF8")
    conn.select_db('mms')
    cursor = conn.cursor(cursorclass=MySQLdb.cursors.DictCursor)
    cursor.execute("select * from t_data where item_id = (select max(item_id)from t_data)")
    conn.commit()
    tmp = cursor.fetchall()[0]
    data_dict['humidity'].set(tmp['humidity'])
    data_dict['temperature'].set(tmp['temperature'])
    data_dict['pressure'].set(tmp['pressure'])
    data_dict['sea_level_press'].set(tmp['sea_level_press'])
    data_dict['illuminance'].set(tmp['illuminance'])
    data_dict['API'].set(tmp['api'])
    data_dict['location'].set(0)
    data_dict['altitude'].set(tmp['altitude'])
    data_dict['rainfall'].set(tmp['rainfall'])
    cursor.close()
    conn.close()
    return data_dict