def fetch_popular_interests(request):
'''
Returns a list of the 15 most popular interests based on the number of
users who have them.
'''
try:
cursor = connection.cursor()
sql = "SELECT interest_id, count(interest_id) \
FROM app_userprofile_interests \
GROUP BY interest_id"
cursor.execute(sql, [])
interest_ids = [(item[0], item[1]) for item in cursor.fetchall()]
results = []
for item in interest_ids:
temp = Interest.objects.get(id=item[0])
results.append((temp.name, item[1]))
# order descending by frequency
results = sorted(results, key=lambda tup: tup[1], reverse=True)
data = { 'result': SUCCESS,
'message': '',
'data': results }
response = JSONResponse(data)
except:
print traceback.format_exc()
data = { 'result': ERROR,
'message': 'There was an error getting the list of popular interests.'}
response = JSONResponse(data)
response.status_code = 500
return response
def fetch_interests(request):
'''
Returns a list of all interests currently in the database
'''
try:
cursor = connection.cursor()
sql = "SELECT name FROM app_interest ORDER BY name"
cursor.execute(sql, [])
interests = [item[0] for item in cursor.fetchall()]
data = { 'result': SUCCESS,
'message': '',
'data': interests }
response = JSONResponse(data)
except:
data = { 'result': ERROR,
'message': 'There was an error retrieving interests from the sever.' }
response = JSONResponse(data)
response.status_code = 500
return response
def remove_interest(request):
'''
Remove an interest from the user's list of interests.
'''
data = json.loads(request.body)
try:
interest = Interest.objects.get(name=data['interest'].lower())
profile = UserProfile.objects.get(user=request.user)
profile.interests.remove(interest)
profile.save()
data = { 'result': SUCCESS,
'message': '' }
response = JSONResponse(data)
except:
data = { 'result': ERROR,
'message': 'There was an error removing an interest from your profile.' }
response = JSONResponse(data)
response.status_code = 409
return response
def add_interest(request):
'''
Add a new interest to the user's list of interests. If the interest
doesn't already exist, first add a new interest object to the database.
'''
data = json.loads(request.body)
try:
interest, created = Interest.objects.get_or_create(name=data['interest'].lower())
profile = UserProfile.objects.get(user=request.user)
profile.interests.add(interest)
profile.save()
data = { 'result': SUCCESS,
'message': ''}
response = JSONResponse(data)
except:
data = { 'result': ERROR,
'message': 'There was a problem adding an interest to your profile.'}
response = JSONResponse(data)
response.status_code = 409
return response
def update_avatar(request):
'''
Update the user's profile picture
'''
try:
if request.method == 'POST':
profile = UserProfile.objects.get(user=request.user)
profile.avatar = request.FILES['file']
profile.save()
serializer = user.UserSerializer(request.user)
data = {'result': SUCCESS,
'message': '',
'user': serializer.data }
response = JSONResponse(data)
else:
raise
except:
data = {'result': ERROR,
'message': 'There was an error processing your request.'}
response = JSONResponse(data)
response.status_code = 500
return response