You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
137 lines
5.8 KiB
137 lines
5.8 KiB
from flask import Flask, render_template
|
|
from flask import jsonify
|
|
from MyDatabase import Mydb,InsideProvinceClass,InsideSummaryClass,OutsideSummaryClass,TopOverseasInputClass
|
|
|
|
app = Flask(__name__) #先生成对象
|
|
|
|
@app.route('/')
|
|
def hello_flask():
|
|
return render_template('hello.html')
|
|
|
|
#************* ludi****************
|
|
@app.route('/inside_conRelativeAndComein')
|
|
def inside_conReAndCome():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
#print("******************")
|
|
results=db.inside_conRelativeAndComein()
|
|
#conRelative,comein,relativetime
|
|
print(results)
|
|
return jsonify(conRelative=[x[0] for x in results],comein=[x[1] for x in results],relativetime=[x[2] for x in results])
|
|
|
|
@app.route('/inside_curConAndConfirmed')
|
|
def inside_curConAndConfirmed():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.inside_curConAndConfirmed()
|
|
#confirm,curConfirm,date
|
|
print(results)
|
|
return jsonify(confirm=[x[0] for x in results],curConfirm=[x[1] for x in results],date=[x[2] for x in results])
|
|
|
|
@app.route('/inside_cruedAnddied')
|
|
def inside_cruedAnddied():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.inside_cruedAnddied()
|
|
#crued,died,date
|
|
print(results)
|
|
return jsonify(crued=[x[0] for x in results],died=[x[1] for x in results],date=[x[2] for x in results])
|
|
|
|
@app.route('/inside_cruedAnddieRate')
|
|
def inside_cruedAnddieRate():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.inside_cruedAnddieRate()
|
|
#cruedrate,diedrate,date
|
|
print(results)
|
|
return jsonify(cruedrate=[x[0] for x in results],diedrate=[x[1] for x in results],date=[x[2] for x in results])
|
|
|
|
|
|
# ********chengzw*************
|
|
@app.route('/province_topn_curconfirm')
|
|
def pic_pie():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.curConfirm_top5_proince()
|
|
return jsonify(pub_date=results[0][0], privinces=[x[2] for x in results], curConfirms=[x[1] for x in results])
|
|
|
|
@app.route('/province_confirmrelative')
|
|
def pic_bar():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.Confirm_proince()
|
|
return jsonify(pub_date=results[0][0], privinces=[x[2] for x in results], Confirms=[x[1] for x in results])
|
|
|
|
@app.route('/American_confirmrelative')
|
|
def pic_line():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.American_confirmrelative()
|
|
return jsonify(data=[x[0] for x in results],confirmrelative=[x[1] for x in results])
|
|
|
|
@app.route('/confirmRelative_top10_country')
|
|
def confirmRelative_top10_country():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.confirmRelative_top10_country()
|
|
return jsonify(date=results[0][0],area=[x[2] for x in results],confirmRelative=[x[1] for x in results])
|
|
|
|
@app.route('/insideAndoutside_ConfirmRelative')
|
|
def insideAndoutside_ConfirmRelative():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.insideAndoutside_ConfirmRelative()
|
|
#date,outnum,innum
|
|
return jsonify(date=[x[0] for x in results],outnum=[x[1] for x in results],innum=[x[2] for x in results])
|
|
|
|
@app.route('/outside_diedAndcrued')
|
|
def outside_diedAndcrued():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.outside_diedAndcrued()
|
|
#confirmed,curConfirmed,date
|
|
return jsonify(crued=[x[0] for x in results],died=[x[1] for x in results],date=[x[2] for x in results])
|
|
|
|
@app.route('/chinaCurconfirmed')
|
|
def chinaCurconfirmed():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.chinaCurconfirmed()
|
|
#time,curConfirmed,area
|
|
return jsonify(time=results[0][0],curConfirmed=[x[1] for x in results],area=[x[2] for x in results])
|
|
|
|
@app.route('/chinaConfirmed')
|
|
def chinaConfirmed():
|
|
db=Mydb('localhost','root','123456','cov2019_data')
|
|
results=db.chinaConfirmed()
|
|
#time,confirmed,area
|
|
return jsonify(time=results[0][0],confirmed=[x[1] for x in results],area=[x[2] for x in results])
|
|
|
|
# ********************caigy**************************
|
|
@app.route('/SummaryDataOut')
|
|
def get_data():
|
|
bd = OutsideSummaryClass('localhost','root','123456','cov2019_data')
|
|
result = bd.data_result()
|
|
return jsonify(pub_date=result[0],datas = list(result[1:9]))
|
|
|
|
@app.route('/OutsideConfirmed_7days')
|
|
def get_7datas():
|
|
bd = OutsideSummaryClass('localhost','root','123456','cov2019_data')
|
|
results = bd.data_7days()
|
|
return jsonify(time = [x[1] for x in results], curconfirmed = [x[0] for x in results])
|
|
|
|
@app.route('/ProvinceConfirmed_top5')
|
|
def get_province_curconfirm_topn():
|
|
mydb = InsideProvinceClass('localhost','root','123456','cov2019_data')
|
|
results = mydb.get_data("curconfirm",5)
|
|
return jsonify(pub_date=results[0][2], privinces=[x[0] for x in results], curConfirms=[x[1] for x in results])
|
|
|
|
@app.route('/ProvinceAsymptomatic_top10')
|
|
def get_province_asymptomatic_top10():
|
|
mydb = InsideProvinceClass('localhost','root','123456','cov2019_data')
|
|
results = mydb.get_data("asymptomatic",10)
|
|
return jsonify(pub_date=results[0][2], provinces=[x[0] for x in results], asymptomatic=[x[1] for x in results])
|
|
|
|
@app.route('/ProvinceConfirmedRelative_top7')
|
|
def get_province_confirmedrelative_top7():
|
|
mydb = InsideProvinceClass('localhost','root','123456','cov2019_data')
|
|
results = mydb.get_data("confirmedrelative",7)
|
|
return jsonify(pub_date=results[0][2], privinces=[x[0] for x in results], confirmedrelative=[x[1] for x in results])
|
|
|
|
@app.route('/OverseasInput_top10')
|
|
def get_topOverseasInput():
|
|
db = Mydb('localhost','root','123456','cov2019_data')
|
|
result = db.get_overseas_data()
|
|
return jsonify(pub_date = result[0][1],provinces = [x[0] for x in result], data = [x[2] for x in result])
|
|
|
|
if __name__ == "__main__":
|
|
app.run() |