def test_filter_and_limit():
grid = Grid(columns={'id': {}, 'site': {}})
grid.append({
'id': 'id1',
'site': MARKER,
'equip': 'Chicago',
'geoPostalCode': "78280",
'ahu': MARKER,
'geoCity': 'Chicago',
'curVal': 76
})
grid.append({
'id': 'id2',
'hvac': MARKER,
'geoPostalCode': "23220",
'curVal': 75
})
grid.append({
'equip': 'Chicago',
'hvac': MARKER,
'siteRef': Ref('id1'),
'curVal': 74
})
assert len(grid.filter('not acme', limit=1)) == 1
def test_grid_filter():
grid = Grid(
columns={
'id': {},
'site': {},
'equip': {},
'geoPostalCode': {},
'ahu': {},
'geoCity': {},
'curVal': {},
'hvac': {},
'siteRef': {}
})
grid.append({
'id': 'id1',
'site': MARKER,
'equip': 'Chicago',
'geoPostalCode': "78280",
'ahu': MARKER,
'geoCity': 'Chicago',
'curVal': 76
})
grid.append({
'id': 'id2',
'hvac': MARKER,
'geoPostalCode': "23220",
'curVal': 75
})
grid.append({
'equip': 'Chicago',
'hvac': MARKER,
'siteRef': Ref('id1'),
'curVal': 74
})
result = grid.filter('site')
assert len(result) == 1
assert result['id1']
result = grid.filter('equip == "Chicago"')
assert len(result) == 2
assert result[0]['id'] == 'id1'
assert result[1]['equip'] == 'Chicago'
result = grid.filter('not id')
assert len(result) == 1
assert result[0]['equip'] == 'Chicago'
def test_grid_specification_filter_sample():
grid = Grid(
columns={
'id': {},
'site': {},
'equip': {},
'geoPostalCode': {},
'ahu': {},
'geoCity': {},
'curVal': {},
'hvac': {},
'siteRef': {}
})
grid.append({
'id': 'id1',
'site': MARKER,
'equip': 'Chicago',
'geoPostalCode': "78280",
'ahu': MARKER,
'geoCity': 'Chicago',
'curVal': 76
})
grid.append({
'id': 'id2',
'hvac': MARKER,
'geoPostalCode': "23220",
'curVal': 75
})
grid.append({
'equip': 'Chicago',
'hvac': MARKER,
'siteRef': Ref('id1'),
'curVal': 74
})
# specification samples
result = grid.filter('geoPostalCode == "23220"')
assert len(result) == 1
assert result[0]['id'] == 'id2'
result = grid.filter('geoPostalCode != "23220"')
assert len(result) == 1
assert result[0]['id'] == 'id1'
result = grid.filter('curVal < 75')
assert len(result) == 1
assert result[0]['siteRef'] == Ref('id1')
result = grid.filter('curVal <= 75')
assert len(result) == 2
assert result[0]['id'] == 'id2'
assert result[1]['siteRef'] == Ref('id1')
result = grid.filter('curVal > 75')
assert len(result) == 1
assert result[0]['id'] == 'id1'
result = grid.filter('curVal >= 75')
assert len(result) == 2
assert result[0]['id'] == 'id1'
assert result[1]['id'] == 'id2'
result = grid.filter('site or equip')
assert len(result) == 2
assert result[0]['id'] == 'id1'
assert result[1]['siteRef'] == Ref('id1')
result = grid.filter('equip and hvac')
assert len(result) == 1
assert result[0]['siteRef'] == Ref('id1')
result = grid.filter('equip and not ahu')
assert len(result) == 1
assert result[0]['siteRef'] == Ref('id1')
result = grid.filter('equip and siteRef->geoCity == "Chicago"')
assert len(result) == 1
assert result[0]['equip'] == 'Chicago'
