Python SQLLocation.by_domain Examples

Example #1

def get_test_district_locations_id(domain):
    return [
        sql_location.location_id
        for sql_location in SQLLocation.by_domain(domain).filter(
            location_type__code=const.LocationTypes.DISTRICT)
        if sql_location.metadata.get('is_test_location', 'real') == 'test'
    ]

Example #2

File: queries.py Project: kkrampa/commcare-hq

def get_test_district_locations_id(domain):
    return [
        sql_location.location_id
        for sql_location in SQLLocation.by_domain(domain).filter(location_type__code=const.LocationTypes.DISTRICT)
        if sql_location.metadata.get('is_test_location', 'real') == 'test'
    ]

Example #3

File: v0_1.py Project: tstalka/commcare-hq

def _user_locations_ids(project, show_administrative):
    locations = SQLLocation.by_domain(project.name)
    if show_administrative == 'False':
        locations = locations.filter(location_type__administrative=True)
    # admins and users not assigned to a location can see and edit everything
    return locations.values_list('location_id', flat=True)

Example #4

File: v0_1.py Project: ansarbek/commcare-hq

def _user_locations_ids(project, show_administrative):
    locations = SQLLocation.by_domain(project.name)
    if show_administrative == 'False':
        locations = locations.filter(location_type__administrative=True)
    # admins and users not assigned to a location can see and edit everything
    return locations.values_list('location_id', flat=True)