'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:
print template['name']
jobCollector = JobRunCollector(cxn=cxn)
]
jobs = [ {'template':'proc_param', 'warnings':'0', 'errors':'0', 'status':'finished', 'ack':'', 'log':'', 'startts':jobTimes[0], 'lasteventts':jobTimes[0], 'lastevent':'start'},
{'template':'log_puller', 'warnings':'0', 'errors':'1', 'status':'finished', 'ack':'', 'log':'', 'startts':jobTimes[1], 'lasteventts':jobTimes[1]+datetime.timedelta(minutes=-5), 'lastevent':'commit'},
{'template':'', 'warnings':'0', '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:
print template['name']
jobCollector = JobRunCollector(cxn=cxn)
