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()