def __init__(self, cxn=None):
cxn = cxn or SharedConnection()
self.jobs = []
qry = 'select job_template.template_name, job_instance.* from job_instance LEFT OUTER JOIN job_template ON (job_instance.template = job_template.id)'
res = cxn.execute(qry)
for row in res:
self.jobs.append(self._parseJob(row))
def __init__(self, cxn=None):
cxn = cxn or SharedConnection()
self.templates = []
qry = 'SELECT * FROM job_template'
res = cxn.execute(qry)
for row in res:
self.templates.append(self._parseTemplate(row))
'errors': '0',
'status': 'finished',
'ack': '',
'log': '',
'startts': jobTimes[2],
'lasteventts': jobTimes[2] + datetime.timedelta(minutes=-10),
'lastevent': ''
},
]
parser = OptionParser()
parser.add_option('--user', default='jobtracker')
options, args = parser.parse_args()
conninfo = 'dbname=crontracker user={user}'.format(user=options.user)
cxn = SharedConnection(conninfo=conninfo, autocommit=True)
qry = 'DELETE FROM job_instance'
cxn.execute(qry)
qry = 'DELETE FROM job_template'
cxn.execute(qry)
for template in templates:
cxn.execute(insertTemplateSQL(template))
for job in jobs:
cxn.execute(insertJobRunSQL(job))
templateCollector = TemplateCollector(cxn=cxn)
for template in templateCollector:
