def query():
# 设置数据
period = range(1978, 2014)
db = ProvinceStatisticsDatabase()
if request.method == 'POST':
form_data = request.form
print(form_data)
period_chosen = form_data.getlist('period')
region_chosen = re.split(',', form_data.getlist('hregion')[0])
variables_chosen = form_data.getlist('variable')
print(period_chosen)
print(region_chosen)
print(variables_chosen)
conds = {'region': region_chosen, 'year': period_chosen, 'variable': variables_chosen}
mdata = db.find(conds)
header = mdata['header']
data = mdata['data']
print(mdata)
fdata = [header]
fdata.extend(data)
print(fdata)
filename = str(uuid.uuid1()) + '.xlsx'
session['filename'] = filename
outfile = ''.join([TEMP_FILE_FOLDER, filename])
print(url_for('myapp.index'))
moutexcel = Excel(outfile)
moutexcel.new().append(fdata, 'mysheet')
moutexcel.close()
return render_template("queryresult.html", header=header, data=data)
return render_template("query.html", period=period)
def ajaxtwo():
db = AQIDatabase()
if request.method == 'POST':
form_data = request.form
cities = form_data.getlist('city')
start_date = form_data.get('startpick')
end_date = form_data.get('endpick')
conds = {'region': cities, 'sdate': start_date, 'edate': end_date}
mdata = db.find(conds)
header = mdata['header']
data = mdata['data']
print(mdata)
fdata = [header]
fdata.extend(data)
print(fdata)
filename = str(uuid.uuid1()) + '.xlsx'
session['filename'] = filename
outfile = 'E:\\gitwork\\application\\webapp\\static\\file\\' + filename
moutexcel = Excel(outfile)
moutexcel.new().append(fdata, 'mysheet')
moutexcel.close()
return render_template("queryresult.html", header=header, data=data)
return render_template('ajaxtwo.html', cities=db.city)
from bokeh.plotting import figure
from bokeh.embed import components
from bokeh.charts import Bar, output_file, show
from bokeh.sampledata.autompg import autompg as df
from webapp.dist.lib.file.class_Excel import Excel
import pandas as pd
mexcel = Excel('E:/gitwork/application/webapp/static/file/2016-01-08/c80e8748-b5f8-11e5-887a-f582ef2c4802.xlsx')
mdata = mexcel.read()
index = mdata.pop(0)
mdata = pd.DataFrame(mdata,columns=index)
print(index)
print(mdata)
plot = figure()
plot.circle([1,2], [3,4])
script, div = components(plot)
print(script)
print(div)
print(df)
p = Bar(mdata, 'city', values='PM25', title="Total MPG by CYL")
output_file("bar.html")
show(p)
script, div = components(p)
print(script)
