python 3.7 二： 操作 mysql

pip3 install pymysql

mysql_utils.py

import pymysql
from ..config.read_config import ConfigUtil


class MysqlUtils:
    host = ''
    port = 3306
    user = ''
    password = ''
    schema = ''

    def __init__(self, path, file_name):
        config = ConfigUtil()
        config.set_prop(path, file_name)
        self.host = config.get_prop("db", "host")
        self.port = int(config.get_prop("db", "port"))
        self.user = config.get_prop("db", "user")
        self.password = config.get_prop("db", "pass")
        self.schema = config.get_prop("db", "schema")

    def open(self):
        self.db = pymysql.connect(self.host, self.user, self.password, self.schema, self.port)

    def close(self):
        self.db.close()

    def insert(self, sql, var):
        return self.execute_common(sql, var)

    def delete(self, sql, var):
        return self.execute_common(sql, var)

    def update(self, sql, var):
        return self.execute_common(sql, var)

    def select(self, sql, var):
        result = None
        cursor = self.db.cursor()
        try:
            if var is None or len(var) == 0:
                cursor.execute(sql)
                result = cursor.fetchall()
            else:
                cursor.execute(sql, var)
                result = cursor.fetchall()
            self.db.commit()

        except:
            self.db.rollback()

        return result

    def execute_common(self, sql, var):
        result = False
        cursor = self.db.cursor()
        try:
            if var is None or len(var) == 0:
                cursor.execute(sql)
            else:
                cursor.execute(sql, var)
            self.db.commit()
            result = True
        except:
            self.db.rollback()
        return result

test.py

def save_mysql():
    mysql = MysqlUtils("conf", "persistent.config")
    mysql.open()
    mysql.insert("insert into test(name) value ('7')", None)
    mysql.close()
    print(results)

ps 配置参考 https://blog.youkuaiyun.com/qzqanzc/article/details/84256754