def tree():
data = [{
"children": [{
"children": [],
"name": "海林"
}, {
"children": [],
"name": "道固"
}, {
"children": [],
"name": "我"
}],
"name":
"雄哥"
}]
tree = Tree("雄哥的小弟阵容")
tree.add("", data)
# tree.render()
return render_template(
'tree.html',
tree=tree.render_embed(),
host=REMOTE_HOST,
script_list=tree.get_js_dependencies(),
)
def relation():
dbconn = pymysql.connect(host="***",
user="******",
password="******",
port=3306,
charset="utf8",
db="***")
#读取数据库JSON数据
sql = "select json from words_relation_json where id =1"
cursor = dbconn.cursor()
cursor.execute(sql)
data = cursor.fetchall()
dbconn.commit()
cursor.close()
dbconn.close()
#字符串转JSON
result = json.loads(data[0][0].replace("'", "\""))
#树图
tree = Tree(width=2000, height=2400)
tree.add("", result, tree_collapse_interval=1)
tree.render()
javascript_snippet = TRANSLATOR.translate(tree.options)
return render_template(
"relation.html",
chart_id=tree.chart_id,
host=REMOTE_HOST,
renderer=tree.renderer,
my_width="95%",
my_height=2400,
custom_function=javascript_snippet.function_snippet,
options=javascript_snippet.option_snippet,
script_list=tree.get_js_dependencies(),
)