python-mysql数据库操作封装

class mysql_config():

    def get_config(self, name):
        config = {
            'testdb': {
                'host': '127.0.0.1',
                'user': 'root',
                'password': '123',
                'database': 'test',
                'port': 3306
            }
        }
        return config[name]

import mysql.connector
from db_config import mysql_config
m_config = mysql_config()


class db_mysql_detail():

    def __init__(self, name):
        self.__name = name
        self.__conn = self.build_conn(name)
        self.__cursor = self.__conn.cursor()

    @property       
    def conn(self):
        return self.__conn

    def build_conn(self, name):
        try:
            config = m_config.get_config(name)
            con = mysql.connector.connect(**config)
            return con
        except mysql.connector.Error as err:
            print('Something wrong: %s' % format(err))


    def getAll(self,sql):
        self.__cursor.execute(sql)
        return self.__cursor.fetchall()

    def close(self):
        pass

from db_mysql import db_mysql_detail

obj = db_mysql_detail('testdb')
sql = 'select * from user'
data = obj.getAll(sql)
print(data)