flask接口

 官方文档：https://flask.palletsprojects.com/en/1.1.x/quickstart/#quickstart

import pandas as pd
from flask import Flask
import pymysql
from sshtunnel import SSHTunnelForwarder

app = Flask(__name__)

@app.route('/hello/<week>')
这个是本地连接远程服务器的代码，只要数据库不关闭，就可以创建动态的url
def helloworld(week):
    server = SSHTunnelForwarder(
        ssh_address_or_host=(),  # 指定ssh登录的跳转机的address
        ssh_username='',  # 跳转机的用户
        ssh_password='',  # 跳转机的密码
        remote_bind_address=()
    server.start()
    config = {
        'host': '',
        'user': '',
        'password': '',
        'port': server.local_bind_port,
        'db': '',
        'charset': '',
    }

    con = pymysql.connect(**config)
    sql = 'SELECT * FROM table_name WHERE week="{}"'.format(week)
    df = pd.read_sql(sql, con).to_json(force_ascii=False, orient='index')
    return df


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

代码很lower以后要改的，新学的