def listJobs(self):
import json
data = []
try:
conn = sqlite3.connect(self.pathdb,uri=True)
conn.row_factory = sqlite3.Row
c = conn.cursor()
reqSql = """ SELECT jobid, type, state, start, end, data, file, preview, requestGraph, variates, nr FROM jobs"""
c.execute(reqSql)
rows = c.fetchall()
for row in rows:
d = {}
d['jobid'] = row['jobid']
d['type'] = row['type']
d['state'] = row['state']
d['start'] = row['start']
d['end'] = row['end']
if row['data'] != None :
d['data'] = json.loads(ParamManager.decode(row['data']))
if row['file'] != None :
d['file'] = row['file']
d['preview'] = row['preview']
d['requestGraph'] = urllib.parse.unquote(row['requestGraph'])
d['variates'] = eval(ParamManager.decode(row['variates']))
d['nr'] = row['nr']
data.append(d)
except sqlite3.OperationalError as e :
self.log.info("Jobs database does not exist .")
c.execute(reqSql)
conn.commit()
conn.close()
return data
def listJobs(self):
import json
data = []
try:
conn = sqlite3.connect(self.pathdb, uri=True)
conn.row_factory = sqlite3.Row
c = conn.cursor()
reqSql = """ SELECT jobid, type, state, start, end, data, file, preview, requestGraph, variates, nr FROM jobs"""
c.execute(reqSql)
rows = c.fetchall()
for row in rows:
d = {}
d['jobid'] = row['jobid']
d['type'] = row['type']
d['state'] = row['state']
d['start'] = row['start']
d['end'] = row['end']
if row['data'] != None:
d['data'] = json.loads(ParamManager.decode(row['data']))
if row['file'] != None:
d['file'] = row['file']
d['preview'] = row['preview']
d['requestGraph'] = urllib.parse.unquote(row['requestGraph'])
d['variates'] = eval(ParamManager.decode(row['variates']))
d['nr'] = row['nr']
data.append(d)
except sqlite3.OperationalError as e:
self.log.info("Jobs database does not exist .")
c.execute(reqSql)
conn.commit()
conn.close()
return data
def test_decode(self):
r = ParamManager.encode("@&###:::123%%%%!!!")
assert ParamManager.decode(r) == "@&###:::123%%%%!!!"
def test_decode(self):
r = ParamManager.encode("@&###:::123%%%%!!!")
assert ParamManager.decode(r) == "@&###:::123%%%%!!!"