def getAllIds():
""" Method to read all jobs from jobtabelle
Args: -
Returns:
jobIds (list): the record matching the id
"""
with jobdb:
queryResult = Job.select(getattr(Job, JOBTABLE.id_field)).dicts()
jobIds = []
# iterating reopens db connection!!
for i in queryResult:
jobIds.append(i[JOBTABLE.id_field])
log.debug("Information read from jobtable.")
jobdb.close()
return jobIds
def getJobById(jobid):
""" Method to read job from jobtabelle by id
Args:
jobid (int): id of job
Returns:
record (dict): the record matching the id
"""
try:
with jobdb:
queryResult = Job.select().where(
getattr(Job, JOBTABLE.id_field) == jobid).get()
record = model_to_dict(queryResult)
log.info("Information read from jobtable for job with id " +
str(record['idpk_jobs']) + ".")
except Job.DoesNotExist:
record = None
jobdb.close()
return record