Flask中Python连接mysql

import pymysql
import pprint

def get_conn():
    return pymysql.connect(
        host='127.0.0.1',
        user = 'root',
        password='root',
        database='itcast'
    )


def query_data(sql):
    conn = get_conn()
    try:
        cursor = conn.cursor(pymysql.cursors.DictCursor)
        cursor.execute(sql)
        return cursor.fetchall()
    finally:
        conn.close()


def insert_or_update(sql):
    conn = get_conn()
    try:
        cursor = conn.cursor()
        cursor.execute(sql)
        conn.commit()
    finally:
        conn.close()



if __name__ == '__main__':
    sql = "select * from dept"
    datas = query_data(sql)
    pprint.pprint(datas)