python-Selenium自动化测试笔记（2）——文件与数据库操作

用Python操作数据库和文件：

操作mysql:

import pymysql


class MySQLOP:

    def insert_sql(self, user, password, database, value, host='127.0.0.7'):
        conn = pymysql.connect(host=host, user=user, password=password, database=database, charset="utf8")
        cursor = conn.cursor()
        sql_1 = value  # e.g. "insert user values (123456,'张三',1,'P0001','2020-06-14');"
        cursor.execute(sql_1)
        conn.commit()

    def select_sql(self, user, password, database, value, host='127.0.0.7'):
        conn = pymysql.connect(host=host, user=user, password=password, database=database, charset="utf8")
        cursor = conn.cursor()
        sql = value  # e.g."SELECT * from user;"
        cursor.execute(sql)
        datas = cursor.fetchall()
        return datas

操作excel,使用xlwi