def index(request):
context = {}
query_string = ''
found_entries = None
entry_query = Q()
try:
# get tweets within the last 24 hours and that belong to AZ counties
#date_from_utc = timezone.now() - timedelta(days=1)
if ('q' in request.GET) and request.GET['q'].strip():
query_string = request.GET['q']
entry_query = get_query(query_string, ['text',])
mood_by_geo = Tweet.objects.filter(
county__in=AZ_COUNTIES #, created_dt__gte=date_from_utc,
).filter(entry_query).values(
'county').annotate(
avg_index=Avg(Case(When(sentiment_index__gt=0, then=1),
When(sentiment_index__lt=0, then=-1),
default=0.001,
output_field=DecimalField())),
num_tweets=Count('county'))
mood_by_geo_json = json.dumps(list(mood_by_geo))
context = {'tweet_stats': mood_by_geo,
'mood_by_geo': mood_by_geo_json,
'query_string': query_string,}
except Tweet.DoesNotExist:
raise Http404("tweet does not exist")
return render_to_response('index.html', context)
def search(request):
query_string = ''
found_entries = None
if ('q' in request.GET) and request.GET['q'].strip():
query_string = request.GET['q']
entry_query = get_query(query_string, ['title', 'body',])
found_entries = Tweets.objects.filter(entry_query).order_by(
'-pub_date')
return render_to_response('search/search_results.html',
{ 'query_string': query_string, 'found_entries': found_entries },
context_instance=RequestContext(request))