python mysql操作封装库_python-mysql数据库操作封装

前言：最近在学python，学到有关数据库的操作之时，想着把数据库的配置抽离出来，下面把代码贴出来~

db_config.pyclass 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]

通过config这个dict，用name去检索配置，一般数据库的配置分测试服（开发）数据库还有正式服数据库

db_mysqlimport 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

使用pip下载mysql包，import类mysql.connector

assist.pyfrom db_mysql import db_mysql_detail

obj = db_mysql_detail('testdb')

sql = 'select * from user'

data = obj.getAll(sql)

print(data)

进行测试