Flask与echarts的使用

init.py(初始化)

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from config import Config

app = Flask(__name__)

app.config.from_object(Config)

db = SQLAlchemy(app)

config.py(配置类)

class Config(object):
    SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://user:password@localhost:3306/db'
    SQLALCHEMY_TRACK_MODIFICATIONS = True
    #设置每次请求结束后会自动提交数据库中的改动
    SQLALCHEMY_COMMIT_ON_TEARDOWN = True

models.py(数据库关系模型)

from __init__ import db

class flight(db.Model):
 __tablename__ = 'flight' #表名
 _id = db.Column(db.Integer(),primary_key=True) #字段，主键
 _name = db.Column(db.String(255)) #字段
 _year = db.Column(db.String(255)) #字段
 _count = db.Column(db.Integer()) #字段

 #对象属性
 def __repr__(self):
     return '<flight %s>'%self._name

app.py(main方法运行模块)

#导包
from __init__ import app,db
from models import flight
from flask import render_template
#路由路径
@app.route('/')
def index():
   data = db.session.query(flight).all()
   res_val = {}
   for i in data:
       res_val[i._name] = [x._count for x in db.session.query(flight).filter(flight._name == i._name).all()]
   return render_template('index7.html',res_val=res_val)


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