def test_relation_filter_no_schemas(): relations_config = { 'persons': { 'relation_name': 'persons', 'schemas': [util.ALL_SCHEMAS] } } query_filter = util.build_relations_filter(relations_config, SCHEMA_NAME) assert query_filter == "( relname = 'persons' )"
def test_relation_filter_regex(): relations_config = { 'persons': { 'relation_regex': 'b.*', 'schemas': [util.ALL_SCHEMAS] } } query_filter = util.build_relations_filter(relations_config, SCHEMA_NAME) assert query_filter == "( relname ~ 'b.*' )"
def test_relation_filter(): relations_config = { 'breed': { 'relation_name': 'breed', 'schemas': ['public'] } } query_filter = util.build_relations_filter(relations_config, SCHEMA_NAME) assert query_filter == "( relname = 'breed' AND schemaname = ANY(array['public']::text[]) )"