#!/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))

#!/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 == table_model.id).one()

    name = table_api.name

    url = table_api.url

    method = table_api.method

    service = json.loads(table_api.service)

    access_token = json.loads(table_api.access_token)

    reqparam = json.loads(table_api.reqParam)

    response = json.loads(table_api.response)

    request_exam = table_api.requestExam

    response_exam = table_api.responseExam

    conn.close()

    return render_template("form.html",

                           url=url,

                           method=method,

                           name=name,

                           all_names=all_names,

                           model_name=model_name,

                           model_ch_name=model_ch_name,

                           service=service,

                           access_token=access_token,

                           reqparam=reqparam,

                           response=response,

                           request_exam=request_exam,

                           response_exam=response_exam)