def companies(request):
query_string = request.GET['q']
query = ''.join([
"SELECT equilar_id, company FROM companies WHERE lower(company) LIKE '%",
query_string.lower(),
"%' LIMIT 10;"
])
rows = Db.execute(query)
my_id = lambda x: ' - '.join([x[1], str(x[0])])
f = lambda x: {'id': my_id(x), 'text': x[1]}
dicts = map(f, rows) + [{'text': 'Company Not Found', 'id': -1}]
return JsonResponse({'items': dicts})
