def setUp(self):
"""
set up shared array of type int with given size
"""
dassystems = ['dbs', 'sitedb', 'phedex']
daskeys = ['dataset', 'file', 'block', 'run', 'site', 'date', 'system']
parserdir = '/tmp'
self.dasqlparser = DASQueryParser(daskeys, dassystems)
def setUp(self):
"""
set up shared array of type int with given size
"""
dassystems = ['dbs', 'sitedb', 'phedex']
daskeys = ['dataset', 'file', 'block', 'run', 'site',
'date', 'system']
parserdir = '/tmp'
self.dasqlparser = DASQueryParser(daskeys, dassystems)
def parse_query(query, keys, services, verbose=False):
"""Get ply object for given query."""
mgr = DASQueryParser(keys, services, verbose=verbose)
return mgr.parse(query)
class testUtils(unittest.TestCase):
"""
A test class for the DAS task manager class
"""
def setUp(self):
"""
set up shared array of type int with given size
"""
dassystems = ['dbs', 'sitedb', 'phedex']
daskeys = ['dataset', 'file', 'block', 'run', 'site', 'date', 'system']
parserdir = '/tmp'
self.dasqlparser = DASQueryParser(daskeys, dassystems)
def test_spawn_functions(self):
"""Test spawn functions"""
val = 1
result = test_int(val)
expect = val
self.assertEqual(result, expect)
result = test_list(val)
expect = [val, val]
self.assertEqual(result, expect)
result = test_dict(val)
expect = {'val': val, 'array': [val, val]}
self.assertEqual(result, expect)
def test_spawn_class(self):
"""Test spawn class methods"""
val = 1
obj = MyTest(val)
result = spawn(obj.method, val + val)
expect = {'self.val': val, 'val': val + val}
self.assertEqual(result, expect)
def test_spawn_queue(self):
"""Test spawn_queue function"""
print("\n### test_spawn_queue")
queue = multiprocessing.Queue()
sleep = 2
# spawn 3 processes which will sleep for given time
time1 = time.time()
spawn_queue(queue, test_wait, sleep)
time1 = time.time() - time1
time2 = time.time()
spawn_queue(queue, test_wait, sleep)
time2 = time.time() - time2
time3 = time.time()
spawn_queue(queue, test_wait, sleep)
time3 = time.time() - time3
# get results from result queue
res1 = queue.get()
res2 = queue.get()
res3 = queue.get()
# compare max diff time between spawned processes
# print "times", time1, time2, time3
max_t = max(abs(time1 - time2), abs(time1 - time3), abs(time2 - time3))
result = True if max_t < sleep else False
expect = True
self.assertEqual(result, expect)
# check that returned results are consistent
self.assertEqual(res1, sleep)
self.assertEqual(res2, sleep)
self.assertEqual(res3, sleep)
def test_spawn_manager(self):
"""Test spawn_queue function"""
print("\n### test_spawn_manager")
mgr = SpawnManager()
sleep = 2
# spawn 3 processes which will sleep for given time
time1 = time.time()
mgr.spawn(test_wait, sleep)
time1 = time.time() - time1
time2 = time.time()
mgr.spawn(test_wait, sleep)
time2 = time.time() - time2
time3 = time.time()
mgr.spawn(test_wait, sleep)
time3 = time.time() - time3
# get results from result queue
result = mgr.join()
# check that returned results are consistent
self.assertEqual(result, [sleep, sleep, sleep])
# compare max diff time between spawned processes
max_t = max(abs(time1 - time2), abs(time1 - time3), abs(time2 - time3))
result = True if max_t < sleep else False
expect = True
self.assertEqual(result, expect)
def test_spawn_manager(self):
"""Test spawn_queue function"""
dasservices = ['dbs', 'dbs3']
daskeys = ['dataset']
parserdir = os.getcwd()
query = "dataset=/ZMM*/*/*"
q1 = self.dasqlparser.parse(query)
q2 = spawn(self.dasqlparser.parse, query)
self.assertEqual(q1, q2)
def parse_query(query, keys, services, verbose=False):
"""Get ply object for given query."""
mgr = DASQueryParser(keys, services, verbose=verbose)
return mgr.parse(query)
class testUtils(unittest.TestCase):
"""
A test class for the DAS task manager class
"""
def setUp(self):
"""
set up shared array of type int with given size
"""
dassystems = ['dbs', 'sitedb', 'phedex']
daskeys = ['dataset', 'file', 'block', 'run', 'site',
'date', 'system']
parserdir = '/tmp'
self.dasqlparser = DASQueryParser(daskeys, dassystems)
def test_spawn_functions(self):
"""Test spawn functions"""
val = 1
result = test_int(val)
expect = val
self.assertEqual(result, expect)
result = test_list(val)
expect = [val, val]
self.assertEqual(result, expect)
result = test_dict(val)
expect = {'val': val, 'array': [val, val]}
self.assertEqual(result, expect)
def test_spawn_class(self):
"""Test spawn class methods"""
val = 1
obj = MyTest(val)
result = spawn(obj.method, val+val)
expect = {'self.val': val, 'val': val+val}
self.assertEqual(result, expect)
def test_spawn_queue(self):
"""Test spawn_queue function"""
print("\n### test_spawn_queue")
queue = multiprocessing.Queue()
sleep = 2
# spawn 3 processes which will sleep for given time
time1 = time.time()
spawn_queue(queue, test_wait, sleep)
time1 = time.time()-time1
time2 = time.time()
spawn_queue(queue, test_wait, sleep)
time2 = time.time()-time2
time3 = time.time()
spawn_queue(queue, test_wait, sleep)
time3 = time.time()-time3
# get results from result queue
res1 = queue.get()
res2 = queue.get()
res3 = queue.get()
# compare max diff time between spawned processes
# print "times", time1, time2, time3
max_t = max(abs(time1-time2), abs(time1-time3), abs(time2-time3))
result = True if max_t < sleep else False
expect = True
self.assertEqual(result, expect)
# check that returned results are consistent
self.assertEqual(res1, sleep)
self.assertEqual(res2, sleep)
self.assertEqual(res3, sleep)
def test_spawn_manager(self):
"""Test spawn_queue function"""
print("\n### test_spawn_manager")
mgr = SpawnManager()
sleep = 2
# spawn 3 processes which will sleep for given time
time1 = time.time()
mgr.spawn(test_wait, sleep)
time1 = time.time()-time1
time2 = time.time()
mgr.spawn(test_wait, sleep)
time2 = time.time()-time2
time3 = time.time()
mgr.spawn(test_wait, sleep)
time3 = time.time()-time3
# get results from result queue
result = mgr.join()
# check that returned results are consistent
self.assertEqual(result, [sleep, sleep, sleep])
# compare max diff time between spawned processes
max_t = max(abs(time1-time2), abs(time1-time3), abs(time2-time3))
result = True if max_t < sleep else False
expect = True
self.assertEqual(result, expect)
def test_spawn_manager(self):
"""Test spawn_queue function"""
dasservices = ['dbs', 'dbs3']
daskeys = ['dataset']
parserdir = os.getcwd()
query="dataset=/ZMM*/*/*"
q1 = self.dasqlparser.parse(query)
q2 = spawn(self.dasqlparser.parse, query)
self.assertEqual(q1, q2)
def setUp(self):
"""
set up DAS core module
"""
self.debug = 0
dassystems = ['dbs', 'sitedb', 'phedex', 'google_maps',
'postalcode', 'ip_services']
daskeys = ['dataset', 'file', 'block', 'run', 'site',
'latitude', 'longitude', 'city', 'ip', 'date', 'system', 'zip']
parserdir = '/tmp'
self.dasqlparser = DASQueryParser(daskeys, dassystems, verbose=self.debug)
self.queries = {}
query = "queries=*"
mongo = {'fields': ['queries'], 'spec': {'queries': '*'}}
self.queries[query] = mongo
query = "queries date last 24h"
mongo = {'fields': ['queries'], 'spec': {'date': '24h'}}
self.queries[query] = mongo
query = "records=*"
mongo = {'fields': ['records'], 'spec': {'records': '*'}}
self.queries[query] = mongo
query = "records site=T1_CH_CERN"
mongo = {'fields': ['records'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "site=T1_CH_CERN"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "site site=T1_CH_CERN"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "site site=srm-cms.cern.ch"
mongo = {'fields': ['site'], 'spec': {'site': 'srm-cms.cern.ch'}}
self.queries[query] = mongo
query = "site site=cmssrm.fnal.gov"
mongo = {'fields': ['site'], 'spec': {'site': 'cmssrm.fnal.gov'}}
self.queries[query] = mongo
query = "site=T1_CH_CERN site"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "dataset=/a/b/c run=123 | grep dataset.size"
mongo = {'filters': {'grep': ['dataset.size']}, 'fields': None,
'spec': {'dataset': '/a/b/c', 'run': 123}}
self.queries[query] = mongo
query = "site=T1_CH_CERN system=sitedb"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}, 'system': 'sitedb'}
self.queries[query] = mongo
query = "zip=10000 | grep zip.Placemark.address | count(zip.Placemark.address)"
mongo = {'fields': ['zip'], 'spec': {'zip': 10000},
'filters': {'grep': ['zip.Placemark.address']},
'aggregators': [('count', 'zip.Placemark.address')] }
self.queries[query] = mongo
query = "city=Ithaca"
mongo = {'fields': ['city'], 'spec': {'city': 'Ithaca'}}
self.queries[query] = mongo
query = "zip=14850"
mongo = {'fields': ['zip'], 'spec': {'zip': 14850}}
self.queries[query] = mongo
query = "ip=137.138.141.145 | grep ip.City"
mongo = {'fields': ['ip'], 'spec': {'ip': '137.138.141.145'},
'filters': {'grep': ['ip.City']}}
self.queries[query] = mongo
query = 'latitude=11.1 longitude=-72'
mongo = {'fields': None, 'spec':{'latitude':11.1, 'longitude': -72}}
self.queries[query] = mongo
query = "site=T1_CH_CERN"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "run=20853"
mongo = {'fields': ['run'], 'spec': {'run': 20853}}
self.queries[query] = mongo
query = "run between [20853,20859]"
mongo = {'fields': ['run'], 'spec': {'run': {'$gte': 20853, '$lte': 20859}}}
self.queries[query] = mongo
query = "run in [1,2,3]"
mongo = {'fields': ['run'], 'spec': {'run': {'$in': [1,2,3]}}}
self.queries[query] = mongo
query = "file block=123 | grep file.size | sum(file.size)"
mongo = {'fields': ['file'], 'spec': {'block': 123},
'filters': {'grep': ['file.size']},
'aggregators': [('sum', 'file.size')]}
self.queries[query] = mongo
query = "block=/a/b/RECO#9f5c396b-b6a1"
mongo = {'fields': ['block'], 'spec': {'block': '/a/b/RECO#9f5c396b-b6a1'}}
self.queries[query] = mongo
query = "block dataset=/W/a_2/RECO"
mongo = {'fields': ['block'], 'spec': {'dataset': '/W/a_2/RECO'}}
self.queries[query] = mongo
query = "run date last 24h"
mongo = {'fields': ['run'], 'spec': {'date': '24h'}}
self.queries[query] = mongo
date1 = 20101201
date2 = 20101202
query = "run date between [%s, %s]" % (date1, date2)
mongo = {'fields': ['run'], 'spec': {'date': {'$lte': long(1291248000), '$gte': long(1291161600)}}}
self.queries[query] = mongo
query = "dataset file=/a/b run between [1,2] | grep file.name, file.age | unique | sum(file.size),max(file.size)"
mongo = {'fields': ['dataset'], 'spec':
{'run': {'$lte': 2, '$gte': 1}, 'file': '/a/b'},
'filters': {'grep': ['file.name', 'file.age'], 'unique': 1},
'aggregators': [('sum', 'file.size'), ('max', 'file.size')]}
self.queries[query] = mongo
query = "city = camelCase"
mongo = {'fields': ['city'], 'spec':{'city': 'camelCase'}}
self.queries[query] = mongo
query = "city = lowercase"
mongo = {'fields': ['city'], 'spec':{'city': 'lowercase'}}
self.queries[query] = mongo
query = "city = 'two words'"
mongo = {'fields': ['city'], 'spec':{'city': 'two words'}}
self.queries[query] = mongo
query = 'city = "two words"'
mongo = {'fields': ['city'], 'spec':{'city': 'two words'}}
self.queries[query] = mongo
#query=DASKEYtext
query = 'city = datasetPostfix'
mongo = {'fields': ['city'], 'spec':{'city': 'datasetPostfix'}}
self.queries[query] = mongo
#query=OPERATORtext (I don't expect query=OPERATOR to ever work)
query = 'city = betweenPostfix'
mongo = {'fields': ['city'], 'spec':{'city': 'betweenPostfix'}}
self.queries[query] = mongo
# query w/ filter which contains a key/value pair
query = 'block=/a/b/c | grep site=T1 '
mongo = {'fields': ['block'], 'spec': {'block': '/a/b/c'},
'filters': {'grep': ['site=T1']}}
self.queries[query] = mongo
# query w/ filter which contains a filter conditions
query = 'run dataset=/a/b/c | grep run.run_number>1, run.run_number<10 '
mongo = {'fields': ['run'], 'spec': {'dataset': '/a/b/c'},
'filters': {'grep': ['run.run_number>1', 'run.run_number<10']}}
self.queries[query] = mongo
# query w/ filter which contains a filter conditions
query = 'run dataset=/a/b/c | grep run.a>0, run.b>=0, run.c<=0'
mongo = {'fields': ['run'], 'spec': {'dataset': '/a/b/c'},
'filters': {'grep': ['run.a>0', 'run.b>=0', 'run.c<=0']}}
self.queries[query] = mongo
# query with DASKEY, date=value
query = 'dataset date=20110124'
mongo = {'fields': ['dataset'], 'spec': {'date': 1295827200}}
self.queries[query] = mongo
# query with DASKEY, date between [value1, value2]
query = 'dataset date between [20110124,20110126]'
mongo = {'fields': ['dataset'], 'spec': {'date': {'$gte': 1295827200, '$lte': 1296000000}}}
self.queries[query] = mongo
query = 'file=abcdeasdf'
mongo = {'fields': ['file'], 'spec': {'file': 'abcdeasdf'}}
self.queries[query] = mongo
query = 'file=abcdeasdf dataset=abcdes'
mongo = {'fields': None, 'spec': {'file': 'abcdeasdf', 'dataset': 'abcdes'}}
self.queries[query] = mongo
query = 'dataset date = 20080201'
mongo = {'fields': ['dataset'], 'spec': {'date': 1201824000}}
self.queries[query] = mongo
query = 'file dataset date = 20080201'
mongo = {'fields': ['file', 'dataset'], 'spec': {'date': 1201824000}}
self.queries[query] = mongo
query = 'dataset dataset=abcdes date = 20080201'
mongo = {'fields': ['dataset'], 'spec': {'date': 1201824000, 'dataset': 'abcdes'}}
self.queries[query] = mongo
query = 'file dataset dataset=abcdes date = 20080201'
mongo = {'fields': ['file', 'dataset'], 'spec': {'date': 1201824000, 'dataset': 'abcdes'}}
self.queries[query] = mongo
query = 'file=abcdeasdf file dataset dataset=abcdes date = 20080201'
mongo = {'fields': ['file', 'dataset'], 'spec': {'date': 1201824000, 'file': 'abcdeasdf', 'dataset': 'abcdes'}}
self.queries[query] = mongo
query = 'file dataset=bla | grep file.creation_time<1201824000'
mongo = {'fields': ['file'], 'spec': {'dataset': 'bla'},
'filters': {'grep': ['file.creation_time<1201824000']}}
self.queries[query] = mongo
query = 'file dataset=bla | grep file.creation_time<1201824000 | sort file.name'
mongo = {'fields': ['file'], 'spec': {'dataset': 'bla'},
'filters': {'grep': ['file.creation_time<1201824000'],
'sort':['file.name']}}
self.queries[query] = mongo
query = 'file dataset=bla | grep file.creation_time<1201824000 | sort file.name-'
mongo = {'fields': ['file'], 'spec': {'dataset': 'bla'},
'filters': {'grep': ['file.creation_time<1201824000'],
'sort':['file.name-']}}
self.queries[query] = mongo
class testDASQueryParser(unittest.TestCase):
"""
A test class for the DAS PLY parser/lexer
"""
def setUp(self):
"""
set up DAS core module
"""
self.debug = 0
dassystems = ['dbs', 'sitedb', 'phedex', 'google_maps',
'postalcode', 'ip_services']
daskeys = ['dataset', 'file', 'block', 'run', 'site',
'latitude', 'longitude', 'city', 'ip', 'date', 'system', 'zip']
parserdir = '/tmp'
self.dasqlparser = DASQueryParser(daskeys, dassystems, verbose=self.debug)
self.queries = {}
query = "queries=*"
mongo = {'fields': ['queries'], 'spec': {'queries': '*'}}
self.queries[query] = mongo
query = "queries date last 24h"
mongo = {'fields': ['queries'], 'spec': {'date': '24h'}}
self.queries[query] = mongo
query = "records=*"
mongo = {'fields': ['records'], 'spec': {'records': '*'}}
self.queries[query] = mongo
query = "records site=T1_CH_CERN"
mongo = {'fields': ['records'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "site=T1_CH_CERN"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "site site=T1_CH_CERN"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "site site=srm-cms.cern.ch"
mongo = {'fields': ['site'], 'spec': {'site': 'srm-cms.cern.ch'}}
self.queries[query] = mongo
query = "site site=cmssrm.fnal.gov"
mongo = {'fields': ['site'], 'spec': {'site': 'cmssrm.fnal.gov'}}
self.queries[query] = mongo
query = "site=T1_CH_CERN site"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "dataset=/a/b/c run=123 | grep dataset.size"
mongo = {'filters': {'grep': ['dataset.size']}, 'fields': None,
'spec': {'dataset': '/a/b/c', 'run': 123}}
self.queries[query] = mongo
query = "site=T1_CH_CERN system=sitedb"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}, 'system': 'sitedb'}
self.queries[query] = mongo
query = "zip=10000 | grep zip.Placemark.address | count(zip.Placemark.address)"
mongo = {'fields': ['zip'], 'spec': {'zip': 10000},
'filters': {'grep': ['zip.Placemark.address']},
'aggregators': [('count', 'zip.Placemark.address')] }
self.queries[query] = mongo
query = "city=Ithaca"
mongo = {'fields': ['city'], 'spec': {'city': 'Ithaca'}}
self.queries[query] = mongo
query = "zip=14850"
mongo = {'fields': ['zip'], 'spec': {'zip': 14850}}
self.queries[query] = mongo
query = "ip=137.138.141.145 | grep ip.City"
mongo = {'fields': ['ip'], 'spec': {'ip': '137.138.141.145'},
'filters': {'grep': ['ip.City']}}
self.queries[query] = mongo
query = 'latitude=11.1 longitude=-72'
mongo = {'fields': None, 'spec':{'latitude':11.1, 'longitude': -72}}
self.queries[query] = mongo
query = "site=T1_CH_CERN"
mongo = {'fields': ['site'], 'spec': {'site': 'T1_CH_CERN'}}
self.queries[query] = mongo
query = "run=20853"
mongo = {'fields': ['run'], 'spec': {'run': 20853}}
self.queries[query] = mongo
query = "run between [20853,20859]"
mongo = {'fields': ['run'], 'spec': {'run': {'$gte': 20853, '$lte': 20859}}}
self.queries[query] = mongo
query = "run in [1,2,3]"
mongo = {'fields': ['run'], 'spec': {'run': {'$in': [1,2,3]}}}
self.queries[query] = mongo
query = "file block=123 | grep file.size | sum(file.size)"
mongo = {'fields': ['file'], 'spec': {'block': 123},
'filters': {'grep': ['file.size']},
'aggregators': [('sum', 'file.size')]}
self.queries[query] = mongo
query = "block=/a/b/RECO#9f5c396b-b6a1"
mongo = {'fields': ['block'], 'spec': {'block': '/a/b/RECO#9f5c396b-b6a1'}}
self.queries[query] = mongo
query = "block dataset=/W/a_2/RECO"
mongo = {'fields': ['block'], 'spec': {'dataset': '/W/a_2/RECO'}}
self.queries[query] = mongo
query = "run date last 24h"
mongo = {'fields': ['run'], 'spec': {'date': '24h'}}
self.queries[query] = mongo
date1 = 20101201
date2 = 20101202
query = "run date between [%s, %s]" % (date1, date2)
mongo = {'fields': ['run'], 'spec': {'date': {'$lte': long(1291248000), '$gte': long(1291161600)}}}
self.queries[query] = mongo
query = "dataset file=/a/b run between [1,2] | grep file.name, file.age | unique | sum(file.size),max(file.size)"
mongo = {'fields': ['dataset'], 'spec':
{'run': {'$lte': 2, '$gte': 1}, 'file': '/a/b'},
'filters': {'grep': ['file.name', 'file.age'], 'unique': 1},
'aggregators': [('sum', 'file.size'), ('max', 'file.size')]}
self.queries[query] = mongo
query = "city = camelCase"
mongo = {'fields': ['city'], 'spec':{'city': 'camelCase'}}
self.queries[query] = mongo
query = "city = lowercase"
mongo = {'fields': ['city'], 'spec':{'city': 'lowercase'}}
self.queries[query] = mongo
query = "city = 'two words'"
mongo = {'fields': ['city'], 'spec':{'city': 'two words'}}
self.queries[query] = mongo
query = 'city = "two words"'
mongo = {'fields': ['city'], 'spec':{'city': 'two words'}}
self.queries[query] = mongo
#query=DASKEYtext
query = 'city = datasetPostfix'
mongo = {'fields': ['city'], 'spec':{'city': 'datasetPostfix'}}
self.queries[query] = mongo
#query=OPERATORtext (I don't expect query=OPERATOR to ever work)
query = 'city = betweenPostfix'
mongo = {'fields': ['city'], 'spec':{'city': 'betweenPostfix'}}
self.queries[query] = mongo
# query w/ filter which contains a key/value pair
query = 'block=/a/b/c | grep site=T1 '
mongo = {'fields': ['block'], 'spec': {'block': '/a/b/c'},
'filters': {'grep': ['site=T1']}}
self.queries[query] = mongo
# query w/ filter which contains a filter conditions
query = 'run dataset=/a/b/c | grep run.run_number>1, run.run_number<10 '
mongo = {'fields': ['run'], 'spec': {'dataset': '/a/b/c'},
'filters': {'grep': ['run.run_number>1', 'run.run_number<10']}}
self.queries[query] = mongo
# query w/ filter which contains a filter conditions
query = 'run dataset=/a/b/c | grep run.a>0, run.b>=0, run.c<=0'
mongo = {'fields': ['run'], 'spec': {'dataset': '/a/b/c'},
'filters': {'grep': ['run.a>0', 'run.b>=0', 'run.c<=0']}}
self.queries[query] = mongo
# query with DASKEY, date=value
query = 'dataset date=20110124'
mongo = {'fields': ['dataset'], 'spec': {'date': 1295827200}}
self.queries[query] = mongo
# query with DASKEY, date between [value1, value2]
query = 'dataset date between [20110124,20110126]'
mongo = {'fields': ['dataset'], 'spec': {'date': {'$gte': 1295827200, '$lte': 1296000000}}}
self.queries[query] = mongo
query = 'file=abcdeasdf'
mongo = {'fields': ['file'], 'spec': {'file': 'abcdeasdf'}}
self.queries[query] = mongo
query = 'file=abcdeasdf dataset=abcdes'
mongo = {'fields': None, 'spec': {'file': 'abcdeasdf', 'dataset': 'abcdes'}}
self.queries[query] = mongo
query = 'dataset date = 20080201'
mongo = {'fields': ['dataset'], 'spec': {'date': 1201824000}}
self.queries[query] = mongo
query = 'file dataset date = 20080201'
mongo = {'fields': ['file', 'dataset'], 'spec': {'date': 1201824000}}
self.queries[query] = mongo
query = 'dataset dataset=abcdes date = 20080201'
mongo = {'fields': ['dataset'], 'spec': {'date': 1201824000, 'dataset': 'abcdes'}}
self.queries[query] = mongo
query = 'file dataset dataset=abcdes date = 20080201'
mongo = {'fields': ['file', 'dataset'], 'spec': {'date': 1201824000, 'dataset': 'abcdes'}}
self.queries[query] = mongo
query = 'file=abcdeasdf file dataset dataset=abcdes date = 20080201'
mongo = {'fields': ['file', 'dataset'], 'spec': {'date': 1201824000, 'file': 'abcdeasdf', 'dataset': 'abcdes'}}
self.queries[query] = mongo
query = 'file dataset=bla | grep file.creation_time<1201824000'
mongo = {'fields': ['file'], 'spec': {'dataset': 'bla'},
'filters': {'grep': ['file.creation_time<1201824000']}}
self.queries[query] = mongo
query = 'file dataset=bla | grep file.creation_time<1201824000 | sort file.name'
mongo = {'fields': ['file'], 'spec': {'dataset': 'bla'},
'filters': {'grep': ['file.creation_time<1201824000'],
'sort':['file.name']}}
self.queries[query] = mongo
query = 'file dataset=bla | grep file.creation_time<1201824000 | sort file.name-'
mongo = {'fields': ['file'], 'spec': {'dataset': 'bla'},
'filters': {'grep': ['file.creation_time<1201824000'],
'sort':['file.name-']}}
self.queries[query] = mongo
def test_splitting(self):
"Test splitting around operators"
query = 'bla bla>1 oper>=1 oper!=1 oper<=1 oper<0'
result = relax(query, [])
expect = 'bla bla > 1 oper >= 1 oper != 1 oper <= 1 oper < 0'
self.assertEqual(expect, result)
query = 'run dataset=/a/b/c | grep run.a>0, run.b>=0, run.c<=0'
result = relax(query, [])
expect = 'run dataset = /a/b/c | grep run.a > 0 , run.b >= 0 , run.c <= 0'
self.assertEqual(expect, result)
def test_instance(self):
"""Test appearance of instance in a DAS query"""
query = 'dataset=/a/b/c instance=global'
mongo = {'fields': ['dataset'], 'spec': {'dataset':'/a/b/c'}, 'instance':'global'}
result = self.dasqlparser.parse(query)
self.assertEqual(mongo, result)
def test_parser(self):
"""Test DAS parser"""
print("\nChecking the DAS queries")
for query, expect in self.queries.items():
print(query)
result = self.dasqlparser.parse(query)
self.assertEqual(expect, result)
def test_parser_negate(self):
"""Test DAS PLY parser with negative results"""
mongo = {}
queries = {}
# query = 'run last 24h'
# queries[query] = mongo
query = 'run last dataset' # daskey operator daskey
queries[query] = mongo
query = 'dataset in 2010' # in operator expects array
queries[query] = mongo
# query = 'date in 24h'
# queries[query] = mongo
query = 'date last [20101010,20101012]'
queries[query] = mongo
query = 'dataset = /a/b/c dataset.size' # select is not DAS keyword
queries[query] = mongo
query = """dataset date in [20110124,2011]""" # wrong date value
queries[query] = mongo
query = "run in [abs,20859]" # wrong value in array, should be int
queries[query] = mongo
query = "dataset" # prevent usage of single keys
queries[query] = mongo
print("\nChecking negate DAS queries")
for query, expect in queries.items():
print(query)
def setUp(self):
"""
set up DAS core module
"""
self.debug = 0
dassystems = ["dbs", "sitedb", "phedex", "google_maps", "postalcode", "ip_services"]
daskeys = [
"dataset",
"file",
"block",
"run",
"site",
"latitude",
"longitude",
"city",
"ip",
"date",
"system",
"zip",
]
parserdir = "/tmp"
self.dasqlparser = DASQueryParser(daskeys, dassystems, verbose=self.debug)
self.queries = {}
query = "queries=*"
mongo = {"fields": ["queries"], "spec": {"queries": "*"}}
self.queries[query] = mongo
query = "queries date last 24h"
mongo = {"fields": ["queries"], "spec": {"date": "24h"}}
self.queries[query] = mongo
query = "records=*"
mongo = {"fields": ["records"], "spec": {"records": "*"}}
self.queries[query] = mongo
query = "records site=T1_CH_CERN"
mongo = {"fields": ["records"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "site=T1_CH_CERN"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "site site=T1_CH_CERN"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "site site=srm-cms.cern.ch"
mongo = {"fields": ["site"], "spec": {"site": "srm-cms.cern.ch"}}
self.queries[query] = mongo
query = "site site=cmssrm.fnal.gov"
mongo = {"fields": ["site"], "spec": {"site": "cmssrm.fnal.gov"}}
self.queries[query] = mongo
query = "site=T1_CH_CERN site"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "dataset=/a/b/c run=123 | grep dataset.size"
mongo = {"filters": {"grep": ["dataset.size"]}, "fields": None, "spec": {"dataset": "/a/b/c", "run": 123}}
self.queries[query] = mongo
query = "site=T1_CH_CERN system=sitedb"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}, "system": "sitedb"}
self.queries[query] = mongo
query = "zip=10000 | grep zip.Placemark.address | count(zip.Placemark.address)"
mongo = {
"fields": ["zip"],
"spec": {"zip": 10000},
"filters": {"grep": ["zip.Placemark.address"]},
"aggregators": [("count", "zip.Placemark.address")],
}
self.queries[query] = mongo
query = "city=Ithaca"
mongo = {"fields": ["city"], "spec": {"city": "Ithaca"}}
self.queries[query] = mongo
query = "zip=14850"
mongo = {"fields": ["zip"], "spec": {"zip": 14850}}
self.queries[query] = mongo
query = "ip=137.138.141.145 | grep ip.City"
mongo = {"fields": ["ip"], "spec": {"ip": "137.138.141.145"}, "filters": {"grep": ["ip.City"]}}
self.queries[query] = mongo
query = "latitude=11.1 longitude=-72"
mongo = {"fields": None, "spec": {"latitude": 11.1, "longitude": -72}}
self.queries[query] = mongo
query = "site=T1_CH_CERN"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "run=20853"
mongo = {"fields": ["run"], "spec": {"run": 20853}}
self.queries[query] = mongo
query = "run between [20853,20859]"
mongo = {"fields": ["run"], "spec": {"run": {"$gte": 20853, "$lte": 20859}}}
self.queries[query] = mongo
query = "run in [1,2,3]"
mongo = {"fields": ["run"], "spec": {"run": {"$in": [1, 2, 3]}}}
self.queries[query] = mongo
query = "file block=123 | grep file.size | sum(file.size)"
mongo = {
"fields": ["file"],
"spec": {"block": 123},
"filters": {"grep": ["file.size"]},
"aggregators": [("sum", "file.size")],
}
self.queries[query] = mongo
query = "block=/a/b/RECO#9f5c396b-b6a1"
mongo = {"fields": ["block"], "spec": {"block": "/a/b/RECO#9f5c396b-b6a1"}}
self.queries[query] = mongo
query = "block dataset=/W/a_2/RECO"
mongo = {"fields": ["block"], "spec": {"dataset": "/W/a_2/RECO"}}
self.queries[query] = mongo
query = "run date last 24h"
mongo = {"fields": ["run"], "spec": {"date": "24h"}}
self.queries[query] = mongo
date1 = 20101201
date2 = 20101202
query = "run date between [%s, %s]" % (date1, date2)
mongo = {"fields": ["run"], "spec": {"date": {"$lte": long(1291248000), "$gte": long(1291161600)}}}
self.queries[query] = mongo
query = (
"dataset file=/a/b run between [1,2] | grep file.name, file.age | unique | sum(file.size),max(file.size)"
)
mongo = {
"fields": ["dataset"],
"spec": {"run": {"$lte": 2, "$gte": 1}, "file": "/a/b"},
"filters": {"grep": ["file.name", "file.age"], "unique": 1},
"aggregators": [("sum", "file.size"), ("max", "file.size")],
}
self.queries[query] = mongo
query = "city = camelCase"
mongo = {"fields": ["city"], "spec": {"city": "camelCase"}}
self.queries[query] = mongo
query = "city = lowercase"
mongo = {"fields": ["city"], "spec": {"city": "lowercase"}}
self.queries[query] = mongo
query = "city = 'two words'"
mongo = {"fields": ["city"], "spec": {"city": "two words"}}
self.queries[query] = mongo
query = 'city = "two words"'
mongo = {"fields": ["city"], "spec": {"city": "two words"}}
self.queries[query] = mongo
# query=DASKEYtext
query = "city = datasetPostfix"
mongo = {"fields": ["city"], "spec": {"city": "datasetPostfix"}}
self.queries[query] = mongo
# query=OPERATORtext (I don't expect query=OPERATOR to ever work)
query = "city = betweenPostfix"
mongo = {"fields": ["city"], "spec": {"city": "betweenPostfix"}}
self.queries[query] = mongo
# query w/ filter which contains a key/value pair
query = "block=/a/b/c | grep site=T1 "
mongo = {"fields": ["block"], "spec": {"block": "/a/b/c"}, "filters": {"grep": ["site=T1"]}}
self.queries[query] = mongo
# query w/ filter which contains a filter conditions
query = "run dataset=/a/b/c | grep run.run_number>1, run.run_number<10 "
mongo = {
"fields": ["run"],
"spec": {"dataset": "/a/b/c"},
"filters": {"grep": ["run.run_number>1", "run.run_number<10"]},
}
self.queries[query] = mongo
# query w/ filter which contains a filter conditions
query = "run dataset=/a/b/c | grep run.a>0, run.b>=0, run.c<=0"
mongo = {
"fields": ["run"],
"spec": {"dataset": "/a/b/c"},
"filters": {"grep": ["run.a>0", "run.b>=0", "run.c<=0"]},
}
self.queries[query] = mongo
# query with DASKEY, date=value
query = "dataset date=20110124"
mongo = {"fields": ["dataset"], "spec": {"date": 1295827200}}
self.queries[query] = mongo
# query with DASKEY, date between [value1, value2]
query = "dataset date between [20110124,20110126]"
mongo = {"fields": ["dataset"], "spec": {"date": {"$gte": 1295827200, "$lte": 1296000000}}}
self.queries[query] = mongo
query = "file=abcdeasdf"
mongo = {"fields": ["file"], "spec": {"file": "abcdeasdf"}}
self.queries[query] = mongo
query = "file=abcdeasdf dataset=abcdes"
mongo = {"fields": None, "spec": {"file": "abcdeasdf", "dataset": "abcdes"}}
self.queries[query] = mongo
query = "dataset date = 20080201"
mongo = {"fields": ["dataset"], "spec": {"date": 1201824000}}
self.queries[query] = mongo
query = "file dataset date = 20080201"
mongo = {"fields": ["file", "dataset"], "spec": {"date": 1201824000}}
self.queries[query] = mongo
query = "dataset dataset=abcdes date = 20080201"
mongo = {"fields": ["dataset"], "spec": {"date": 1201824000, "dataset": "abcdes"}}
self.queries[query] = mongo
query = "file dataset dataset=abcdes date = 20080201"
mongo = {"fields": ["file", "dataset"], "spec": {"date": 1201824000, "dataset": "abcdes"}}
self.queries[query] = mongo
query = "file=abcdeasdf file dataset dataset=abcdes date = 20080201"
mongo = {"fields": ["file", "dataset"], "spec": {"date": 1201824000, "file": "abcdeasdf", "dataset": "abcdes"}}
self.queries[query] = mongo
query = "file dataset=bla | grep file.creation_time<1201824000"
mongo = {"fields": ["file"], "spec": {"dataset": "bla"}, "filters": {"grep": ["file.creation_time<1201824000"]}}
self.queries[query] = mongo
query = "file dataset=bla | grep file.creation_time<1201824000 | sort file.name"
mongo = {
"fields": ["file"],
"spec": {"dataset": "bla"},
"filters": {"grep": ["file.creation_time<1201824000"], "sort": ["file.name"]},
}
self.queries[query] = mongo
query = "file dataset=bla | grep file.creation_time<1201824000 | sort file.name-"
mongo = {
"fields": ["file"],
"spec": {"dataset": "bla"},
"filters": {"grep": ["file.creation_time<1201824000"], "sort": ["file.name-"]},
}
self.queries[query] = mongo
class testDASQueryParser(unittest.TestCase):
"""
A test class for the DAS PLY parser/lexer
"""
def setUp(self):
"""
set up DAS core module
"""
self.debug = 0
dassystems = ["dbs", "sitedb", "phedex", "google_maps", "postalcode", "ip_services"]
daskeys = [
"dataset",
"file",
"block",
"run",
"site",
"latitude",
"longitude",
"city",
"ip",
"date",
"system",
"zip",
]
parserdir = "/tmp"
self.dasqlparser = DASQueryParser(daskeys, dassystems, verbose=self.debug)
self.queries = {}
query = "queries=*"
mongo = {"fields": ["queries"], "spec": {"queries": "*"}}
self.queries[query] = mongo
query = "queries date last 24h"
mongo = {"fields": ["queries"], "spec": {"date": "24h"}}
self.queries[query] = mongo
query = "records=*"
mongo = {"fields": ["records"], "spec": {"records": "*"}}
self.queries[query] = mongo
query = "records site=T1_CH_CERN"
mongo = {"fields": ["records"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "site=T1_CH_CERN"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "site site=T1_CH_CERN"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "site site=srm-cms.cern.ch"
mongo = {"fields": ["site"], "spec": {"site": "srm-cms.cern.ch"}}
self.queries[query] = mongo
query = "site site=cmssrm.fnal.gov"
mongo = {"fields": ["site"], "spec": {"site": "cmssrm.fnal.gov"}}
self.queries[query] = mongo
query = "site=T1_CH_CERN site"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "dataset=/a/b/c run=123 | grep dataset.size"
mongo = {"filters": {"grep": ["dataset.size"]}, "fields": None, "spec": {"dataset": "/a/b/c", "run": 123}}
self.queries[query] = mongo
query = "site=T1_CH_CERN system=sitedb"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}, "system": "sitedb"}
self.queries[query] = mongo
query = "zip=10000 | grep zip.Placemark.address | count(zip.Placemark.address)"
mongo = {
"fields": ["zip"],
"spec": {"zip": 10000},
"filters": {"grep": ["zip.Placemark.address"]},
"aggregators": [("count", "zip.Placemark.address")],
}
self.queries[query] = mongo
query = "city=Ithaca"
mongo = {"fields": ["city"], "spec": {"city": "Ithaca"}}
self.queries[query] = mongo
query = "zip=14850"
mongo = {"fields": ["zip"], "spec": {"zip": 14850}}
self.queries[query] = mongo
query = "ip=137.138.141.145 | grep ip.City"
mongo = {"fields": ["ip"], "spec": {"ip": "137.138.141.145"}, "filters": {"grep": ["ip.City"]}}
self.queries[query] = mongo
query = "latitude=11.1 longitude=-72"
mongo = {"fields": None, "spec": {"latitude": 11.1, "longitude": -72}}
self.queries[query] = mongo
query = "site=T1_CH_CERN"
mongo = {"fields": ["site"], "spec": {"site": "T1_CH_CERN"}}
self.queries[query] = mongo
query = "run=20853"
mongo = {"fields": ["run"], "spec": {"run": 20853}}
self.queries[query] = mongo
query = "run between [20853,20859]"
mongo = {"fields": ["run"], "spec": {"run": {"$gte": 20853, "$lte": 20859}}}
self.queries[query] = mongo
query = "run in [1,2,3]"
mongo = {"fields": ["run"], "spec": {"run": {"$in": [1, 2, 3]}}}
self.queries[query] = mongo
query = "file block=123 | grep file.size | sum(file.size)"
mongo = {
"fields": ["file"],
"spec": {"block": 123},
"filters": {"grep": ["file.size"]},
"aggregators": [("sum", "file.size")],
}
self.queries[query] = mongo
query = "block=/a/b/RECO#9f5c396b-b6a1"
mongo = {"fields": ["block"], "spec": {"block": "/a/b/RECO#9f5c396b-b6a1"}}
self.queries[query] = mongo
query = "block dataset=/W/a_2/RECO"
mongo = {"fields": ["block"], "spec": {"dataset": "/W/a_2/RECO"}}
self.queries[query] = mongo
query = "run date last 24h"
mongo = {"fields": ["run"], "spec": {"date": "24h"}}
self.queries[query] = mongo
date1 = 20101201
date2 = 20101202
query = "run date between [%s, %s]" % (date1, date2)
mongo = {"fields": ["run"], "spec": {"date": {"$lte": long(1291248000), "$gte": long(1291161600)}}}
self.queries[query] = mongo
query = (
"dataset file=/a/b run between [1,2] | grep file.name, file.age | unique | sum(file.size),max(file.size)"
)
mongo = {
"fields": ["dataset"],
"spec": {"run": {"$lte": 2, "$gte": 1}, "file": "/a/b"},
"filters": {"grep": ["file.name", "file.age"], "unique": 1},
"aggregators": [("sum", "file.size"), ("max", "file.size")],
}
self.queries[query] = mongo
query = "city = camelCase"
mongo = {"fields": ["city"], "spec": {"city": "camelCase"}}
self.queries[query] = mongo
query = "city = lowercase"
mongo = {"fields": ["city"], "spec": {"city": "lowercase"}}
self.queries[query] = mongo
query = "city = 'two words'"
mongo = {"fields": ["city"], "spec": {"city": "two words"}}
self.queries[query] = mongo
query = 'city = "two words"'
mongo = {"fields": ["city"], "spec": {"city": "two words"}}
self.queries[query] = mongo
# query=DASKEYtext
query = "city = datasetPostfix"
mongo = {"fields": ["city"], "spec": {"city": "datasetPostfix"}}
self.queries[query] = mongo
# query=OPERATORtext (I don't expect query=OPERATOR to ever work)
query = "city = betweenPostfix"
mongo = {"fields": ["city"], "spec": {"city": "betweenPostfix"}}
self.queries[query] = mongo
# query w/ filter which contains a key/value pair
query = "block=/a/b/c | grep site=T1 "
mongo = {"fields": ["block"], "spec": {"block": "/a/b/c"}, "filters": {"grep": ["site=T1"]}}
self.queries[query] = mongo
# query w/ filter which contains a filter conditions
query = "run dataset=/a/b/c | grep run.run_number>1, run.run_number<10 "
mongo = {
"fields": ["run"],
"spec": {"dataset": "/a/b/c"},
"filters": {"grep": ["run.run_number>1", "run.run_number<10"]},
}
self.queries[query] = mongo
# query w/ filter which contains a filter conditions
query = "run dataset=/a/b/c | grep run.a>0, run.b>=0, run.c<=0"
mongo = {
"fields": ["run"],
"spec": {"dataset": "/a/b/c"},
"filters": {"grep": ["run.a>0", "run.b>=0", "run.c<=0"]},
}
self.queries[query] = mongo
# query with DASKEY, date=value
query = "dataset date=20110124"
mongo = {"fields": ["dataset"], "spec": {"date": 1295827200}}
self.queries[query] = mongo
# query with DASKEY, date between [value1, value2]
query = "dataset date between [20110124,20110126]"
mongo = {"fields": ["dataset"], "spec": {"date": {"$gte": 1295827200, "$lte": 1296000000}}}
self.queries[query] = mongo
query = "file=abcdeasdf"
mongo = {"fields": ["file"], "spec": {"file": "abcdeasdf"}}
self.queries[query] = mongo
query = "file=abcdeasdf dataset=abcdes"
mongo = {"fields": None, "spec": {"file": "abcdeasdf", "dataset": "abcdes"}}
self.queries[query] = mongo
query = "dataset date = 20080201"
mongo = {"fields": ["dataset"], "spec": {"date": 1201824000}}
self.queries[query] = mongo
query = "file dataset date = 20080201"
mongo = {"fields": ["file", "dataset"], "spec": {"date": 1201824000}}
self.queries[query] = mongo
query = "dataset dataset=abcdes date = 20080201"
mongo = {"fields": ["dataset"], "spec": {"date": 1201824000, "dataset": "abcdes"}}
self.queries[query] = mongo
query = "file dataset dataset=abcdes date = 20080201"
mongo = {"fields": ["file", "dataset"], "spec": {"date": 1201824000, "dataset": "abcdes"}}
self.queries[query] = mongo
query = "file=abcdeasdf file dataset dataset=abcdes date = 20080201"
mongo = {"fields": ["file", "dataset"], "spec": {"date": 1201824000, "file": "abcdeasdf", "dataset": "abcdes"}}
self.queries[query] = mongo
query = "file dataset=bla | grep file.creation_time<1201824000"
mongo = {"fields": ["file"], "spec": {"dataset": "bla"}, "filters": {"grep": ["file.creation_time<1201824000"]}}
self.queries[query] = mongo
query = "file dataset=bla | grep file.creation_time<1201824000 | sort file.name"
mongo = {
"fields": ["file"],
"spec": {"dataset": "bla"},
"filters": {"grep": ["file.creation_time<1201824000"], "sort": ["file.name"]},
}
self.queries[query] = mongo
query = "file dataset=bla | grep file.creation_time<1201824000 | sort file.name-"
mongo = {
"fields": ["file"],
"spec": {"dataset": "bla"},
"filters": {"grep": ["file.creation_time<1201824000"], "sort": ["file.name-"]},
}
self.queries[query] = mongo
def test_splitting(self):
"Test splitting around operators"
query = "bla bla>1 oper>=1 oper!=1 oper<=1 oper<0"
result = relax(query, [])
expect = "bla bla > 1 oper >= 1 oper != 1 oper <= 1 oper < 0"
self.assertEqual(expect, result)
query = "run dataset=/a/b/c | grep run.a>0, run.b>=0, run.c<=0"
result = relax(query, [])
expect = "run dataset = /a/b/c | grep run.a > 0 , run.b >= 0 , run.c <= 0"
self.assertEqual(expect, result)
def test_instance(self):
"""Test appearance of instance in a DAS query"""
query = "dataset=/a/b/c instance=global"
mongo = {"fields": ["dataset"], "spec": {"dataset": "/a/b/c"}, "instance": "global"}
result = self.dasqlparser.parse(query)
self.assertEqual(mongo, result)
def test_parser(self):
"""Test DAS parser"""
print("\nChecking the DAS queries")
for query, expect in self.queries.items():
print(query)
result = self.dasqlparser.parse(query)
self.assertEqual(expect, result)
def test_parser_negate(self):
"""Test DAS PLY parser with negative results"""
mongo = {}
queries = {}
# query = 'run last 24h'
# queries[query] = mongo
query = "run last dataset" # daskey operator daskey
queries[query] = mongo
query = "dataset in 2010" # in operator expects array
queries[query] = mongo
# query = 'date in 24h'
# queries[query] = mongo
query = "date last [20101010,20101012]"
queries[query] = mongo
query = "dataset = /a/b/c dataset.size" # select is not DAS keyword
queries[query] = mongo
query = """dataset date in [20110124,2011]""" # wrong date value
queries[query] = mongo
query = "run in [abs,20859]" # wrong value in array, should be int
queries[query] = mongo
query = "dataset" # prevent usage of single keys
queries[query] = mongo
print("\nChecking negate DAS queries")
for query, expect in queries.items():
print(query)
self.assertRaises(Exception, self.dasqlparser.parse, query)
