from taskbuffer.FileSpec import FileSpec from taskbuffer.DatasetSpec import DatasetSpec from taskbuffer.DBProxyPool import DBProxyPool import getpass passwd = getpass.getpass() pool = DBProxyPool('adbpro.usatlas.bnl.gov',passwd,2) proxy = pool.getProxy() import sys import commands job1 = JobSpec() job1.PandaID='NULL' job1.jobStatus='unknown' job1.computingSite="aaa" f11 = FileSpec() f11.lfn = 'in1.pool.root' f11.type = 'input' job1.addFile(f11) f12 = FileSpec() f12.lfn = 'out1.pool.root' f12.type = 'output' job1.addFile(f12) job2 = JobSpec() job2.PandaID='NULL' job2.jobStatus='unknown' job2.computingSite="bbb"
from taskbuffer.FileSpec import FileSpec from taskbuffer.DatasetSpec import DatasetSpec from taskbuffer.DBProxyPool import DBProxyPool import getpass passwd = getpass.getpass() pool = DBProxyPool('adbpro.usatlas.bnl.gov', passwd, 2) proxy = pool.getProxy() import sys import commands job1 = JobSpec() job1.PandaID = 'NULL' job1.jobStatus = 'unknown' job1.computingSite = "aaa" f11 = FileSpec() f11.lfn = 'in1.pool.root' f11.type = 'input' job1.addFile(f11) f12 = FileSpec() f12.lfn = 'out1.pool.root' f12.type = 'output' job1.addFile(f12) job2 = JobSpec() job2.PandaID = 'NULL' job2.jobStatus = 'unknown' job2.computingSite = "bbb"
break # check suffix if tableSuffix in ['',currentSuffix,previousSuffix]: print "Terminated since fresh PandID=%s found for '%s'" % (id,tableSuffix) sys.exit(0) print "PandaID:%s Suffix:%s" % (id,tableSuffix) # get FileSpec sqlFile = "SELECT %s FROM filesTable4 " % FileSpec.columnNames() sqlFile+= "WHERE PandaID=%s" % id statusF,resFs = proxyS.querySQLS(sqlFile) for resF in resFs: file = FileSpec() file.pack(resF) # create a dummy Job to set PandaID job = JobSpec() job.PandaID = id job.addFile(file) # file table fileTable = 'filesTable%s' % tableSuffix # check sqlFileCheck = "SELECT PandaID FROM %s WHERE rowID=%s" % (fileTable,file.rowID) statusC,resC = proxyN.querySQLS(sqlFileCheck) if len(resC) != 0: if resC[0][0] != id: print "PandaID mismatch PandaArchive:%s PandaDB:%s for rowID=%s" % \ (resC[0][0],id,file.rowID) else: print "rowID=%s not found" % file.rowID """ # construct SQL sqlFileIn = "INSERT INTO %s " % fileTable