Example #1
0
def campuses(request):
    prefix = request.GET.get('q')
    limit = request.GET.get('limit', '10')
    try:
        limit = int(limit)
    except ValueError:
        limit = 10
    limit = clamp(limit, 1, 1000)
    if prefix:
        cursor = connections['ak'].cursor()
        prefix = prefix + '%'
        cursor.execute("SELECT distinct value FROM core_userfield "
                       "WHERE name=\"campus\" and value LIKE %s ORDER BY value LIMIT %s",
                       [prefix, limit])
        values = [row[0] for row in cursor.fetchall()]
        if not values:
            prefix = '%' + prefix
            cursor.execute("SELECT distinct value FROM core_userfield "
                           "WHERE name=\"campus\" and value LIKE %s ORDER BY value LIMIT %s",
                           [prefix, limit])
            values = [row[0] for row in cursor.fetchall()]
    else:
        values = []

    return HttpResponse(json.dumps(values), content_type='application/json')
Example #2
0
def sources(request):
    prefix = request.GET.get('q')
    limit = request.GET.get('limit', '10')
    try:
        limit = int(limit)
    except ValueError:
        limit = 10
    limit = clamp(limit, 1, 1000)
    if prefix:
        cursor = connections['ak'].cursor()
        prefix = prefix + '%'
        cursor.execute("SELECT distinct source FROM core_user "
                       "WHERE source LIKE %s ORDER BY source LIMIT %s",
                       [prefix, limit])
        sources = [row[0] for row in cursor.fetchall()]
    else:
        sources = []
    return HttpResponse(json.dumps(sources), content_type='application/json')