python 写一个mysql 数据库操作类

最近经常使用mysql 做一些操作,想来想去,还是自己写一个自己的类.方便自己操作.

# -*- coding:utf-8 -*-

import pymysql
class pymysqlops:
    def __init__(self,host,database,user,password,port,charset):
        self.host = host
        self.database = database
        self.user = user
        self.password = password
        self.port = port
        self.charset = charset
    def db_connection(self):
        return pymysql.connect(host=self.host,database=self.database,user=self.user,password=self.password,port=self.port,charset=self.charset)

    def select_table_by_sql(self,sql):
        try:
            conn = self.db_connection()
            cur = conn.cursor()
            cur.execute(sql)
            data = cur.fetchall()
            cur.close()
            conn.close()
            return data
        except Exception as e:
            data = ("error with sql",sql,e)
            return data

    def Execute_sql(self,sql):
        conn