Python build_relations_filter Beispiele

Beispiel #1

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' )"

Beispiel #2

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.*' )"

Beispiel #3

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[]) )"