Flask

1、# 新手搭建flask框架并启动以及flask启动接口地址的修改

from flask import Flask, request, jsonify
import sqlite3
import sys

app = Flask(__name__)


def get_base_path():
    system_info = sys.platform
    if system_info == 'linux':
        base_path = '/home/aaron/polish_main/Data/'
    else:
        base_path = '../Data/'
    return base_path


@app.route('/polish-time', methods=['GET'])
def getTime():
    stfb = request.args.get("stfb").strip()
    if stfb:
        with sqlite3.connect(get_base_path() + 'polish.db') as conn:
            cur = conn.cursor()
            cur.execute('SELECT DISTINCT shitifeibahao from polish_history')
            shitifeibas = cur.fetchall()
            shitifeiba_list = [f[0] for f in shitifeibas]
            if stfb not in shitifeiba_list:
                return jsonify({"code": 2001, "msg": "stfb dosen't exist!"})
            y_pre_sql = f"""
            SELECT feibahao,tuozhijincaoshijian,yicishijian_pre from polish_history 
            WHERE xianbie =12 and shitifeibahao='{stfb}'
            order by tuozhijincaoshijian DESC 
            """
            cur.execute(y_pre_sql)
            data = cur.fetchall()
            return jsonify({'code': 200, "msg": 'success', 'data': data})
    else:
        return jsonify({"code": 2001, "msg": "Invalid request!"})


if __name__ == '__main__':
    # app.run()
    app.run(host='10.227.10.40', port=5012)