def python_html():
#retrieve input parameters
script, output_variable = utils.retrieveScriptInfo(request.get_json())
user_id, knowage_address = utils.retrieveKnowageInfo(
request.headers, request.get_json())
dataset_name, datastore_request = utils.retrieveDatasetInfo(
request.get_json())
# check authentication
if not security.userIsAuthenticated(user_id, knowage_address):
return "Error: authentication failed", 401
#retrieve dataset
if dataset_name != "":
dataset_file = "tmp/" + dataset_name + ".pckl"
df = utils.getDatasetAsDataframe(user_id, knowage_address,
dataset_name, datastore_request)
df.to_pickle(dataset_file)
script = "import pandas as pd\n" + dataset_name + " = pd.read_pickle(\"" + dataset_file + "\")\n" + script
#execute script
try:
namespace = {output_variable: ""}
exec(script, namespace)
except Exception as e:
return str(e), 400
#collect script result
html = namespace[output_variable]
#remove dataset tmp file
try:
os.remove(dataset_file)
except Exception:
pass
return html, 200
def python_img():
# retrieve input parameters
script, img_file = utils.retrieveScriptInfo(request.get_json())
user_id, knowage_address = utils.retrieveKnowageInfo(
request.headers, request.get_json())
dataset_name, datastore_request = utils.retrieveDatasetInfo(
request.get_json())
document_id, widget_id = utils.retrieveWidgetInfo(request.get_json())
# test
if not security.userIsAuthorizedForFunctionality(
user_id, knowage_address, constants.EDIT_PYTHON_SCRIPTS):
print("Unauthorized")
else:
print("Authorized")
# check authentication
if not security.userIsAuthenticated(user_id, knowage_address):
return "Error: authentication failed", 401
# retrieve dataset
if dataset_name != "":
dataset_file = constants.TMP_FOLDER + dataset_name + ".pckl"
df = utils.getDatasetAsDataframe(user_id, knowage_address,
dataset_name, datastore_request)
df.to_pickle(dataset_file)
script = "import pandas as pd\n" + dataset_name + " = pd.read_pickle(\"" + dataset_file + "\")\n" + script
# execute script
try:
namespace = {}
exec(script, namespace)
except Exception as e:
return str(e), 400
# collect script result
with open(img_file, "rb") as f:
encoded_img = base64.b64encode(f.read())
#delete temp files
try:
os.remove(img_file)
os.remove(dataset_file)
except Exception:
pass
return "<img src=\"data:image/;base64, " + encoded_img.decode(
'utf-8') + "\" style=\"width:100%;height:100%;\">", 200
def python_bokeh():
# retrieve input parameters
script = request.get_json()['script']
widget_id = request.get_json()['widget_id']
script_file_name = constants.TMP_FOLDER + "bokeh_script_" + str(
widget_id) + ".txt"
user_id, knowage_address = utils.retrieveKnowageInfo(
request.headers, request.get_json())
dataset_name, datastore_request = utils.retrieveDatasetInfo(
request.get_json())
# check authentication
if not security.userIsAuthenticated(user_id, knowage_address):
return "Error: authentication failed", 401
#destroy old bokeh server
if utils.serverExists(widget_id):
utils.destroyServer(widget_id)
# retrieve dataset
if dataset_name != "":
dataset_file = constants.TMP_FOLDER + dataset_name + ".pckl"
df = utils.getDatasetAsDataframe(user_id, knowage_address,
dataset_name, datastore_request)
df.to_pickle(dataset_file)
script = "import pandas as pd\n" + dataset_name + " = pd.read_pickle(\"" + dataset_file + "\")\n" + script
#function executed by bokeh server
def modify_doc(doc):
# retrieve script from file
with open(script_file_name, "r") as bk_file:
bk_script = bk_file.read()
#replace curdoc() with keyword "curdoc_"
bk_script = bk_script.replace("curdoc()", "curdoc_")
# execute script
namespace = {'curdoc_': doc}
exec(bk_script, namespace)
#secondary thread function (bokeh server)
def bk_worker():
server = Server({'/bkapp' + str(widget_id): modify_doc},
io_loop=IOLoop(),
allow_websocket_origin=["localhost:8080"],
port=cuncurrency_manager.ports_dict[widget_id])
with cuncurrency_manager.lck:
cuncurrency_manager.active_servers.update(
{widget_id: server}) #{widget_id : bokeh_server}
server.start()
server.io_loop.start()
#flush script content to file so that modify_doc() can retrieve the code to be executed
with open(script_file_name, "w") as bokeh_file:
bokeh_file.write(script)
#instance a bokeh server for the widget if not instanciated yet
if not utils.serverExists(widget_id): #allocate bokeh server
t = Thread(target=bk_worker) #thread that hosts bokeh server
with cuncurrency_manager.lck:
cuncurrency_manager.active_threads.update(
{widget_id: t}) #{widget_id : thread}
cuncurrency_manager.ports_dict.update({
widget_id:
utils.findFreePort()
}) #{widget_id : port_number_of_bokeh_server}
t.start()
#serve plot
jscript = server_document("http://localhost:" +
str(cuncurrency_manager.ports_dict[widget_id]) +
"/bkapp" + str(widget_id))
return render_template("embed.html", script=jscript)