主要思路是:先从数据库取出来数据,然后进行数据处理,最后写接口供别人使用。
代码奉上
#_*_coding=utf-8 _*
#__author__ = 'chubby_superman'
import pymysql
from flask import Flask
import flask_restful
import json
import demjson
db = pymysql.connect('r','sd','ab1234_','ptest')
def mysql_data(db):
x = db.cursor()
try:
x.execute("select * from order_trade WHERE id = 4;")
except Exception as e:
db.rollback()
db.commit()
db.close()
return x.fetchall(),x.description #如果x.fetchone是空呢?怎么处理
'''
mysql_data()取数据库数据
'''
a = mysql_data(db)
ziduan_list=[]
for i in range(len(a[1])):
ziduan_list.append(a[1][i][0])
jsonData=[]
for row in a[0]:
result = {}
result[ziduan_list[0]]=row[0]
result[ziduan_list[1]]=row[1]
result[ziduan_list[2]]=row[2]
result[ziduan_list[3]]=row[3]
result[ziduan_list[4]]=row[4]
result[ziduan_list[5]]=row[5]
result[ziduan_list[6]]=row[6]
result[ziduan_list[7]]=row[7]
result[ziduan_list[8]]=demjson.decode(row[8])
result[ziduan_list[9]]=row[9]
result[ziduan_list[10]]=int(row[10])
result[ziduan_list[11]]=int(row[11])
result[ziduan_list[12]]=int(row[12])
result[ziduan_list[13]]=int(row[13])
result[ziduan_list[14]]=row[14]
result[ziduan_list[15]]=row[15]
result[ziduan_list[16]]=row[16]
result[ziduan_list[17]]=row[17]
result[ziduan_list[18]]=row[18]
result[ziduan_list[19]]=row[19]
result[ziduan_list[20]]=row[20]
result[ziduan_list[21]]=row[21]
result[ziduan_list[22]]=row[22]
result[ziduan_list[23]]=row[23]
result[ziduan_list[24]]=row[24]
result[ziduan_list[25]]=row[25]
result[ziduan_list[26]]=row[26]
jsonData.append(result)
results = json.dumps(jsonData,ensure_ascii=False)
results = json.loads(results)
'''
处理数据
'''
app = Flask(__name__)
api = flask_restful.Api(app)
class HelloWorld(flask_restful.Resource):
def get(self):
return results
api.add_resource(HelloWorld, '/')
'''
写接口
'''
if __name__ == '__main__':
app.run(host='127.0.0.1',port=5000)