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%%%%!!!"