def test_string_contains(self, table_): filter_ = Filter(table_, "name LIKE par") assert filter_.table == [ { "id": 1, "owner_id": 2, "name": "parrot" }, ]
def test_string_comparison(self, table_): filter_ = Filter(table_, "name = parrot") assert filter_.table == [ { "id": 1, "owner_id": 2, "name": "parrot" }, ]
def test_double_logical_filtering(self, table_): filter_ = Filter(table_, "id = 3 OR owner_id = 2") assert filter_.table == [ { "id": 1, "owner_id": 2, "name": "parrot" }, { "id": 3, "owner_id": 1, "name": "cat" }, ]
def test_simple_filtering(self, table_): filter_ = Filter(table_, "id > 1 AND owner_id = 1") assert filter_.table == [ { "id": 2, "owner_id": 1, "name": "dog" }, { "id": 3, "owner_id": 1, "name": "cat" }, ]