2022丝路通：产品查询接口

代码

from flask import Flask, render_template, redirect, url_for, request, abort, jsonify
#from test_ansible2 import do_ansible
import pymysql
import json

app = Flask("EmailDemo", static_folder="static", template_folder="templates")
app.config["JSON_AS_ASCII"] = False

conn1 = pymysql.connect(host='localhost', user='root', password='123456', port=3306,
                           db='silkroad')


####### 杩滅▼寮€鏈 #####

#鏌ョ湅鍏ㄩ儴鏈烘埧鍒楄〃
@app.route('/product', methods=['GET', 'POST'])
def get_rooms_list():
    conn1.ping(reconnect=True)
    cur = conn1.cursor()
    sql = "SELECT * from shop_info  LIMIT 4"
    cur.execute(sql)
    u = cur.fetchall()
    jsondata = []
    for row in u:
        result = {}
        result['id'] = row[0]
        result['from_url']=row[1]
        result['name'] = row[1]
        result['link'] = row[2]
        result['company'] = row[3]
        result['price'] = row[4]
        result['contact'] = row[5]
        result['one_type'] = row[6]
        result['two_type'] = row[7]
        jsondata.append(result)
    return jsonify(jsondata)
    abort(404)

if __name__ == '__main__':
    app.run(host='0.0.0.0',debug=True)
    conn1.close()