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