python.AtlRunQueryTier0 Namespace Reference

Functions
def	GetTier0_allDatasets (cursor, runlist, dsnamepattern=[])
def	GetTier0_datasetsAndTypes (cursor, runlist)

Function Documentation

GetTier0_allDatasets()

def python.AtlRunQueryTier0.GetTier0_allDatasets	(		cursor,
			runlist,
			dsnamepattern = []
	)

Definition at line 19 of file AtlRunQueryTier0.py.

def GetTier0_allDatasets( cursor, runlist, dsnamepattern = [] ):
    res = {}
    pos = 0
    blocksize = 200
    # build dataset selection string
    dsselstring = ''
    for p in dsnamepattern:
        p = p.replace('*','%')
        dsselstring += "LOWER(DATASETNAME) like LOWER('%s') OR " % p
    if dsselstring:
        dsselstring = 'and (' + dsselstring[:len(dsselstring)-4] + ')'
 
    # do selection
    while pos<len(runlist):
        cursor.execute("SELECT DISTINCT RUNNR,DATASETNAME,TYPE,PSTATES,DDM,NFILES,TOTSIZE,TOTEVENTS,CREATIONTIME FROM dataset WHERE RUNNR in (%s) and TYPE!='LOG' %s and not DATASETNAME like '%%.LOG%%'"% (','.join([str(i) for i in runlist[pos:pos+blocksize]]), dsselstring))
        r = cursor.fetchall()
        for e in r:
            res.setdefault(e[0],[]).append((e[1],e[2],e[3],e[4],e[5],e[6],e[7],e[8]))
        pos += blocksize
 
    return res
 

GetTier0_datasetsAndTypes()

def python.AtlRunQueryTier0.GetTier0_datasetsAndTypes	(		cursor,
			runlist
	)

Definition at line 41 of file AtlRunQueryTier0.py.

def GetTier0_datasetsAndTypes( cursor, runlist ):
    res = {}
    pos = 0
    blocksize = 200
    while pos<len(runlist):
        cursor.execute("SELECT DISTINCT RUNNR,DATASETNAME,TYPE,PSTATES FROM dataset WHERE RUNNR in (%s) and TYPE!='LOG' and not DATASETNAME like '%%.LOG%%'"% ','.join([str(i) for i in runlist[pos:pos+blocksize]]))
        r = cursor.fetchall()
        for e in r:
            res.setdefault(e[0],[]).append((e[1],e[2],e[3]))
        pos += blocksize
 
    return res