def get_bar() -> bar:
sql = """
select sex,count(1) as cnt from user group by sex
"""
datas = db_manage.query_data(sql)
c = (Bar().add_xaxis([data['sex'] for data in datas]).add_yaxis(
"数量", [data['cnt'] for data in datas]).set_global_opts(
title_opts=opts.TitleOpts(title="Pie-基本示例", subtitle="Pie-基本示例")))
return c
def get_pie() -> pie:
sql = """
select sex,count(1) as cnt from user group by sex
"""
datas = db_manage.query_data(sql)
c = (Pie().add(
"", [(data['sex'], data['cnt']) for data in datas]).set_global_opts(
title_opts=opts.TitleOpts(title="Pie-基本示例")).set_series_opts(
label_opts=opts.LabelOpts(formatter="{b}: {c}")))
return c
def SUPPLIERLIST():
Region = request.form.get('Region')
Material = request.form.get('Material')
if Material == 'All':
sql = "select * from suppliers where Region=" + "'" + str(Region) + "'"
else:
sql = "select * from suppliers where Region=" + "'" + str(
Region) + "'" + " and " + str(Material) + "='*'"
datas_pmsuppliers = db_manage.query_data(sql)
return render_template("pages/LINKTOSUPPLIERS/SUPPLIERLIST.html",
datas_pmsuppliers=datas_pmsuppliers)
def get_line(sql, xaxis_name, yaxis_name) -> Line:
datas = db_manage.query_data(sql)
# datas_pr = db_manage.query_data(sql_pr)
# print(list(data.values()) for data in datas)
c = (Line().add_xaxis(
[list(data.values())[0] for data in datas]).add_yaxis(
series_name="",
y_axis=[list(data.values())[1] for data in datas],
is_smooth=True,
label_opts=opts.LabelOpts(is_show=False),
).set_global_opts(
xaxis_opts=opts.AxisOpts(name=xaxis_name,
type_="value",
position="middle"),
yaxis_opts=opts.AxisOpts(name=yaxis_name,
type_="value",
position="middle"),
))
return c
def DetailsofGrade(gradeNum, densityNum, pages):
# WARNING: use bleach or something similar to clean the data (escape JavaScript code)
# You may need to store the data in database here
grade = request.form.get('Grade')
density = request.form.get('Density')
if grade is None:
grade = gradeNum
if density is None:
density = densityNum
# pages = pages
# print(grade, pages)
# print(densityNum)
current_app.config['UPLOADED_PATH'] = os.path.join(basedir,
'../../Data/uploads/',
grade)
title = str(grade)
body = Detail.query.filter(Detail.title == grade).first()
form = PostForm(title=grade, body=body.text)
# form = PostForm(title=gradeNum)
# print(form.validate_on_submit())
# if form.validate_on_submit():
title = form.title.data
new_body = form.body.data
# detail = Detail(title=title, text=body)
body.text = str(new_body)
db.session.commit()
if str(density) == "plastic":
sql_ss = "select 应变" + pages + ",应力" + pages + " from " + str(
grade) + "_ss"
sql_ss_num = "select count(1) from information_schema.COLUMNS where TABLE_SCHEMA='python_mysql' and " \
"TABLE_NAME='" + str(grade) + "_ss'"
else:
sql_ss = "select 应变" + pages + ",应力" + pages + " from " + str(
grade) + str(density) + "_ss"
# print(sql_ss)
sql_ss_num = "select count(1) from information_schema.`COLUMNS` where TABLE_SCHEMA='python_mysql' and " \
"TABLE_NAME='" + str(grade) + str(density) + "_ss'"
sql_pr = "select 轴向伸长量,横向减少量 from " + str(grade) + "_pr"
ss_num = db_manage.query_data(sql_ss_num)
ss_num = [list(num.values())[0] for num in ss_num]
ss_num = ss_num[0] // 2
line_ss = get_line(sql_ss, "应变", "应力")
if str(density) == "plastic":
line_pr = get_line(sql_pr, "轴向伸长量", "横向减少量")
return render_template("pages/SEARCH BY GRADE/DetailsofGrade.html",
line_options_ss=line_ss.dump_options(),
line_options_pr=line_pr.dump_options(),
gradeNum=grade,
densityNum=density,
ssNum=ss_num,
form=form,
title=title,
body=body.text)
else:
return render_template("pages/SEARCH BY GRADE/DetailsofGrade.html",
line_options_ss=line_ss.dump_options(),
gradeNum=grade,
densityNum=density,
ssNum=ss_num,
form=form,
title=title,
body=body.text)
def show_user(user_id):
sql = "select * from user where id=" + user_id
datas = db_manage.query_data(sql)
user = datas[0]
return render_template("pages/test/show_user.html", user=user)
def show_users():
form = PostForm()
sql = "select id,name from user"
datas = db_manage.query_data(sql)
return render_template("pages/test/show_users.html", datas=datas, form=form)