核心算法代码分享如下：

from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
from flask_marshmallow import Marshmallow
from sqlalchemy.sql import func

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:123456@localhost/baidumap_tour'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['JSON_AS_ASCII'] = False

db = SQLAlchemy(app)
ma = Marshmallow(app)

class Tour(db.Model):
    __tablename__ = 'tb_tour'  # 表名
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(500))
    grade = db.Column(db.String(20))
    address = db.Column(db.String(500))
    intro = db.Column(db.String(500))
    hot = db.Column(db.DECIMAL)
    price = db.Column(db.DECIMAL)
    msold = db.Column(db.Integer)
    lng = db.Column(db.DECIMAL)
    lat = db.Column(db.DECIMAL)
    img = db.Column(db.String(500))
    province = db.Column(db.String(90))
    city = db.Column(db.String(90))
    district = db.Column(db.String(90))

    def __init__(self, name, grade, address, intro, hot, price, msold, lng, lat, img, province, city, district):
        self.name = name
        self.grade = grade
        self.address = address
        self.intro = intro
        self.hot = hot
        self.price = price
        self.msold = msold
        self.lng = lng
        self.lat = lat
        self.img = img
        self.province = province
        self.city = city
        self.district = district

class TaskSchema(ma.Schema):
    class Meta:
        fields = ('name', 'grade')

task_schema = TaskSchema()
tasks_schema = TaskSchema(many=True)

class ChartSchema(ma.Schema):
    class Meta:
        fields = ('city', 'lng', 'lat')

chart_schema = ChartSchema()
chart_schema = ChartSchema(many=True)

class RankSchema(ma.Schema):
    class Meta:
        fields = ('name', 'value')

rank_schema = RankSchema()
rank_schema = RankSchema(many=True)

class HotSchema(ma.Schema):
    class Meta:
        fields = ('lng', 'lat', 'count')

hot_schema = HotSchema()
hot_schema = HotSchema(many=True)

@app.route('/')
def hello_world():  # put application's code here
    result = db.session.query(Tour.city, func.count('*').label('value')).group_by(Tour.city).filter(Tour.city != '').all()[:5]
    return jsonify(chart_schema.dump(result)), 200

@app.route('/hot_tour')
def hot_tour_site():  # put application's code here
    result = db.session.query(Tour.city, Tour.lng, Tour.lat).order_by(Tour.msold.desc()).all()[:30]
    # print(result)
    chart_schema.dump(result)
    return jsonify(chart_schema.dump(result))

@app.route('/city_rank')
def city_rank():  # put application's code here
    result = db.session.query(Tour.city.label("name"), func.sum(Tour.msold).label('value')).group_by(Tour.city).filter(Tour.city != '').all()[:20]
    # print(result)
    rank_schema.dump(result)
    return jsonify(rank_schema.dump(result))

@app.route('/tour_rank')
def tour_rank():  # put application's code here
    result = db.session.query(Tour.name, func.sum(Tour.msold).label('value')).group_by(Tour.name).filter(Tour.city != '').all()[:20]
    # print(result)
    rank_schema.dump(result)
    return jsonify(rank_schema.dump(result))

@app.route('/province_rank')
def province_rank():  # put application's code here
    province = request.json['province']
    result = db.session.query(Tour.name, func.sum(Tour.msold).label('value')).group_by(Tour.name).\
                filter(Tour.province == province).all()[:10]
    # result2 = db.session.query(Tour.name, func.sum(Tour.msold).label('value')).group_by(Tour.name). \
    #              filter(Tour.province == '海南').all()[:10]
    # result3 = db.session.query(Tour.name, func.sum(Tour.msold).label('value')).group_by(Tour.name). \
    #              filter(Tour.province == '上海').all()[:10]
    return jsonify(rank_schema.dump(result))

@app.route('/district_rank')
def district_rank():  # put application's code here
    result = db.session.query(Tour.district.label('name'), func.sum(Tour.msold).label('value')).group_by(Tour.district).\
                filter(Tour.district != '').order_by(func.sum(Tour.msold)).all()[:10]
    return jsonify(rank_schema.dump(result))

@app.route('/hotPlaceData')
def hotPlaceData():  # put application's code here
    result = db.session.query( Tour.lng, Tour.lat, Tour.msold.label('count')).order_by(Tour.msold.desc()).all()[:30]
    # print(result)
    return jsonify(hot_schema.dump(result)
)

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