python 获取mysql 库信息/表信息/表结构/索引

最新推荐文章于 2024-08-13 04:20:26 发布

canyazhuo0960

最新推荐文章于 2024-08-13 04:20:26 发布

阅读量2.8k

点赞数 1

文章标签：数据库 python

原文链接：http://blog.51cto.com/hequan/2414914

版权

本文介绍了如何使用Python连接到MySQL数据库并获取库信息、表信息、表结构以及索引的详细步骤。核心代码来源于GitHub上的'Yearning'项目，提供了便捷的数据操作接口。

摘要由CSDN通过智能技术生成

python 获取mysql 库信息/表信息/表结构/索引

核心代码

来自 https://github.com/cookieY/Yearning 此项目

con_database.py


import pymysql

class SQLgo(object):
    def __init__(self, ip=None, user=None, password=None, db=None, port=None):
        self.ip = ip
        self.user = user
        self.password = password
        self.db = db
        self.port = int(port)
        self.con = object

    @staticmethod
    def addDic(theIndex, word, value):
        theIndex.setdefault(word, []).append(value)

    def __enter__(self):
        self.con = pymysql.connect(
            host=self.ip,
            user=self.user,
            passwd=self.password,
            db=self.db,
            charset='utf8mb4',
            port=self.port
        )
        return self

    def __exit__(self, exc_type, exc_val, exc_tb):
        self.con.close()

    def search(self, sql=None):
        data_dict = []
        id = 0
        with self.con.cursor(cursor=pymysql.cursors.DictCursor) as cursor:
            sqllist = sql
            cursor.execute(sqllist)
            result = cursor.fetchall()
            for field in cursor.description:
                if id == 0:
                    data_dict.append({'title': field[0], "key": fie