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
