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'