用Python写一个简单的接口开发

用到Python的Flask库，写一个查询接口
连接mysql数据库就不赘述，上篇博客已经写过

1.简单的查询接口，查询所有

一般用post接口，代码如下

import pymysql
import os
import json
from flask import Flask,request
app =Flask(__name__)

@app.route('/index',methods=['POST'])
def getconn():
    conn = pymysql.connect(host="ip没写真实的", user="mnet_business", password="mnet@123", database="testmnet")
    cursor = conn.cursor()
    sql = "select * from serv_user_info "
    cursor.execute(sql)
    data = cursor.fetchall()
    print(data)
    para=[]
    for i in data:
        text={'id':i[0],'mobile':i[1],'password:':i[2],'username':i[3],'state':i[4],'nickname:':i[5],'org_code':i[6],'login_availble:':i[7]}
        para.append(text)
    return json.dumps(para,ensure_ascii=False,indent=4)
if __nam