flask下直接展示mysql数据库 字段

在工作中，会导出一份mysql的html来查看，用的是就是路过秋天大神的那个工具，所以想自己用那个样式直接在后端写一个页面做展示！

前端页面

from flask import Flask,request,render_template
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db' #这里用这个是不行的　注意修改为ｍｙｓｑｌ　才可以正常使用
db = SQLAlchemy(app)


@app.route("/listModel", methods=["GET"])
def listModel():
    dbName = request.args.get("dbname","ｘｘ")
    tableStr = """select table_name,table_comment from information_schema.tables where TABLE_TYPE='BASE TABLE' and table_schema='{}'""".format(
        dbName)
    resultList = db.engine.execute(tableStr)
    _infoList = []
    if resultList:
        for index, result in enumerate(resultList):
            tableName = result[0]
            filedStr = """select ORDINAL_POSITION,column_name,COLUMN_COMMENT,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,numeric_precision,numeric_scale,COLUMN_KEY,COLUMN_DEFAULT,IS_NULLABLE from information_schema.columns where  table_schema='{}' and table_name='{}'""".format(
                dbName, tableName)
            filedList = db.engine.execute(filedStr)
            _infolist = []
            if filedList:
                for field in filedList:
                    if field[5]:
                        CHARACTER_MAXIMUM_LENGTH = field[5]
                    elif field[4]:
                        CHARACTER_MAXIMUM_LENGTH = field[4]
                    else:
                        CHARACTER_MAXIMUM_LENGTH = 0
                    if field[9] == "YES":
                        IS_NULLABLE = "Y"
                    else:
                        IS_NULLABLE = "N"
                    _infoDict = {
                        "ORDINAL_POSITION": field[0],
                        "column_name": field[1],
                        "COLUMN_COMMENT": field[2],
                        "DATA_TYPE": field[3],
                        "CHARACTER_MAXIMUM_LENGTH": CHARACTER_MAXIMUM_LENGTH,
                        "numeric_scale": field[6] if field[6] else 0,
                        "COLUMN_KEY": "Y" if field[7] else "",
                        "COLUMN_DEFAULT": field[8] if field[8] else "",
                        "IS_NULLABLE": IS_NULLABLE,
                    }
                    _infolist.append(_infoDict)
            infoDict = {
                "index": index + 1,
                "tableName": tableName,
                "table_comment": result[1],
                "fields": _infolist
            }
            _infoList.append(infoDict)
    return render_template("demos.html", rows=_infoList,dbName=dbName)


if __name__ == '__main__':
    app.run()

然后是 html 静态页面

### html



    

'text-align:center;background-image: url("{{ url_for("static",filename='18066.jpg') }}")'>
'width:800px; margin:20px auto; text-align:left;'>
    'index'>
        
'text-align:center; line-height:50px;'>数据库设计文档
        
数据库名：{{ dbName }}
        '1' cellpadding='0'>
            
            {% for x in rows %}
                
            {% endfor %}
        

            

                
'width:40px; '>序号
                
表名
                
说明
            
            

                    
'text-align:center;'>{{ x.index }}
                    
'#{{ x.tableName }}'>{{ x.tableName }}
                    
{{ x.table_comment }}
                
    
    {% for x in rows %}
        '{{ x.tableName }}'>
        
'margin-top:30px;'>'#index'
                                         style='float:right; margin-top:6px;'>返回目录表名：{{ x.tableName }}
        
        
说明：{{ x.table_comment }}
        
数据列：
        '1' cellpadding='0'>
            
            {% for z in x.fields %}
            
                {% endfor %}
        

            

                
'width:40px; '>序号
                
名称
                
数据类型
                
长度
                
小数位
                
允许空值
                
主键
                
默认值
                
说明
            
            

                
'text-align:center;'>{{ z.ORDINAL_POSITION }}
                
{{ z.column_name }}
                
'center'>{{ z.DATA_TYPE }}
                
'center'>{{ z.CHARACTER_MAXIMUM_LENGTH }}
                
'center'>{{ z.numeric_scale }}
                
'center'>{{ z.IS_NULLABLE }}
                
'center'>{{ z.COLUMN_KEY }}
                
{{ z.COLUMN_DEFAULT }}
                
{{ z.COLUMN_COMMENT }}
            

    {% endfor %}