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: