今天博主终于完成了API接口管理平台，最后差的就是数据库的维护，

博主这里介绍下平台的设计原理，首先基于python，利用flask的web框架+bootstrap前端框架完成，先阶段完成了前台展示页

二期要加入登录退出，后台管理

下面是文档结构图

涉及的python第三方模块：flask、flask-bootstrap、sqlalchemy

整体页面的布局：页头的导航，右侧的API分类，页面信息

页面信息内容包括：接口说明，请求参数，返回参数，请求示例，返回示例

下面是定义数据库对象的model.py 文件

#!/usr/bin/env python
# -*- coding: utf-8 -*-


from sqlalchemy import Column, create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
import json
import sys
# 导入数据库所有表字段类型
from sqlalchemy.dialects.mysql import \
    BIGINT, BINARY, BIT, BLOB, BOOLEAN, CHAR, DATE, \
    DATETIME, DECIMAL, DECIMAL, DOUBLE, ENUM, FLOAT, INTEGER, \
    LONGBLOB, LONGTEXT, MEDIUMBLOB, MEDIUMINT, MEDIUMTEXT, NCHAR, \
    NUMERIC, NVARCHAR, REAL, SET, SMALLINT, TEXT, TIME, TIMESTAMP, \
    TINYBLOB, TINYINT, TINYTEXT, VARBINARY, VARCHAR, YEAR

# 创建对象的基类:
Base = declarative_base()

reload(sys)
sys.setdefaultencoding("utf-8")


# 定义api表对象
class Api(Base):
    # 表的名字:
    __tablename__ = 'api'

    # 表的结构:
    id = Column(INTEGER(10), primary_key=True)
    name = Column(VARCHAR(50))
    url = Column(TEXT)
    method = Column(VARCHAR(10))
    service = Column(VARCHAR(50))
    access_token = Column(VARCHAR(255))
    reqParam = Column(TEXT)
    response = Column(TEXT)
    requestExam = Column(TEXT)
    responseExam = Column(TEXT)


# 定义model表对象
class Model(Base):
    # 表的名字:
    __tablename__ = 'model'

    # 表的结构:
    id = Column(VARCHAR(25), primary_key=True)
    name = Column(VARCHAR(50))
    ch_name = Column(VARCHAR(50))
    from_id = Column(VARCHAR(25))

下面是试图views.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-


from app import app
from flask import render_template, flash, redirect, session, url_for, request, g
from models import Api, Model
from config import connect_db
import json
import sys

reload(sys)
sys.setdefaultencoding("utf-8")


@app.route("/")
@app.route("/index")
def index():
    return render_template("index.html")


@app.route("/<id>", methods=["GET", "POST"])
def model(id):
    all_name = []
    db = connect_db()
    conn = db()
    table_model = conn.query(Model).filter(Model.name == id).one()
    model_name = table_model.name
    model_ch_name = table_model.ch_name
    model_all = conn.query(Model).filter(Model.from_id == table_model.id).all()
    for i in range(len(model_all)):
        name = {"ch_name": model_all[i].ch_name, "name": model_all[i].name}
        all_name.append(name)
    conn.close()
    return render_template("model.html",
                           model_name=model_name,
                           model_ch_name=model_ch_name,
                           all_name=all_name)


@app.route("/desk/<id>")
def form(id):
    all_names = []
    db = connect_db()
    conn = db()
    table_model = conn.query(Model).filter(Model.name == id).one()
    model_all = conn.query(Model).filter(Model.from_id == table_model.from_id).all()
    for i in range(len(model_all)):
        name = {"ch_name": model_all[i].ch_name, "name": model_all[i].name}
        all_names.append(name)
    model_id = conn.query(Model).filter(Model.id == table_model.from_id).one()
    model_ch_name = model_id.ch_name
    model_name = model_id.name
    table_api = conn.query(Api).filter(Api.id == tab