def save_query_job(self, request_graph, variates):
database = DatabaseConnector(self.settings, self.session)
# get userid
security = Security(self.settings, self.session, self.session['username'], '', '', '')
userid = security.get_user_id_by_username()
# Format strings
request_graph = urllib.parse.quote(request_graph)
variates = self.encode(str(variates))
query = '''
INSERT INTO query VALUES(
NULL,
?,
"wait",
strftime('%s', 'now'),
NULL,
NULL,
NULL,
NULL,
?,
?,
NULL,
NULL
)
'''
return database.execute_sql_query(query, (userid, request_graph, variates), get_id=True)
def list_query_jobs(self):
# get userid
security = Security(self.settings, self.session, self.session['username'], '', '', '')
userid = security.get_user_id_by_username()
database = DatabaseConnector(self.settings, self.session)
query = '''
SELECT id, state, start, end, data, file, preview, graph, variates, nrows, error
FROM query
WHERE user_id=?
'''
res = database.execute_sql_query(query, (userid, ))
result = []
for job in res:
dict_job = {}
dict_job['id'] = job[0]
dict_job['state'] = job[1]
dict_job['start'] = job[2]
dict_job['end'] = job[3]
dict_job['data'] = ''
if job[4]:
dict_job['data'] = json.loads(self.decode(job[4]))
dict_job['file'] = job[5]
dict_job['preview'] = job[6]
dict_job['graph'] = urllib.parse.unquote(job[7])
dict_job['variates'] = eval(self.decode(job[8]))
dict_job['nrows'] = job[9]
dict_job['error'] = job[10]
result.append(dict_job)
return result
def list_integration_jobs(self):
# get userid
security = Security(self.settings, self.session, self.session['username'], '', '', '')
userid = security.get_user_id_by_username()
database = DatabaseConnector(self.settings, self.session)
query = '''
SELECT id, filename, state, start, end, error
FROM integration
WHERE user_id=?
'''
res = database.execute_sql_query(query, (userid, ))
result = []
for job in res:
dict_job = {}
dict_job['id'] = job[0]
dict_job['filename'] = job[1]
dict_job['state'] = job[2]
dict_job['start'] = job[3]
dict_job['end'] = job[4]
dict_job['error'] = job[5]
result.append(dict_job)
return result
def save_integration_job(self, filename):
database = DatabaseConnector(self.settings, self.session)
# get userid
security = Security(self.settings, self.session, self.session['username'], '', '', '')
userid = security.get_user_id_by_username()
query = '''
INSERT INTO integration VALUES(
NULL,
?,
?,
"wait",
strftime('%s', 'now'),
NULL,
NULL
)
'''
return database.execute_sql_query(query, (userid, filename), get_id=True)