def discussion_countries(request, course_id='all'):
if api.views.is_cached(request):
return api.views.api_cacherender(request)
courses = {}
if course_id == 'all':
courses = api.views.get_all_courses()
else:
course = api.views.get_course(course_id)
if course is None:
return api.views.api_render(request, {'error': 'Unknown course code'}, status.HTTP_404_NOT_FOUND)
courses[course_id] = course
#print courses
DiscussionForum.connect_to_mongo()
data = {}
data['country_dict'] = {}
data['country_enrol'] = {}
data['post_total'] = 0
#data['user_total'] = 0
for course in courses.values():
df_map = DiscussionForum.post_user_country(course)
for country, num in df_map['country_dict'].items():
data['post_total'] += num
if country in data['country_dict']:
data['country_dict'][country] += num
else:
data['country_dict'][country] = num
#remove duplicate of user?
for item in df_map['country_enrol']:
#data['user_total'] += item['userSum']
if item['_id'] in data['country_enrol']:
data['country_enrol'][item['_id']] += item['userSum']
else:
data['country_enrol'][item['_id']] = item['userSum']
data['country_post'] = []
data['post_max'] = 0
for country, num in data['country_dict'].items():
post_percentage = round(num * 100 / float(data['post_total']), 2)
data['country_post'].append([country, num, post_percentage])
if post_percentage > data['post_max']:
data['post_max'] = post_percentage
data['country_post_enrol'] = []
data['post_enrol_max'] = 0
for country, userSum in data['country_enrol'].items():
if country in data['country_dict']:
pe_percentage = round(data['country_dict'][country] * 100 / float(userSum), 2)
post_enrol = [country, data['country_dict'][country], userSum, pe_percentage]
if pe_percentage > data['post_enrol_max']:
data['post_enrol_max'] = pe_percentage
else:
post_enrol = [country, 0, userSum, 0]
data['country_post_enrol'].append(post_enrol)
return api.views.api_render(request, data, status.HTTP_200_OK)
def discussion_dates(request, course_id):
if api.views.is_cached(request):
return api.views.api_cacherender(request)
course = api.views.get_course(course_id)
if course is None:
return api.views.api_render(request, {'error': 'Unknown course code'},
status.HTTP_404_NOT_FOUND)
DiscussionForum.connect_to_mongo()
group_by_date = DiscussionForum.group_by_date(course)
print "0"
data = {}
data['min_date'] = ''
data['max_date'] = ''
data['comment_datecounts'] = []
data['thread_datecounts'] = []
data['comment_datecountsaggregate'] = []
data['thread_datecountsaggregate'] = []
if group_by_date['max_date'] is not None and group_by_date[
'min_date'] is not None:
delta = group_by_date['max_date'] - group_by_date['min_date']
data['min_date'] = str(group_by_date['min_date'])
data['max_date'] = str(group_by_date['max_date'])
for i in range(delta.days + 1):
dateinside = group_by_date['min_date'] + timedelta(days=i)
str_date = str(dateinside)
if dateinside in group_by_date['comment']:
#data['comment_datecounts'][str_date] = group_by_date['comment'][dateinside]
data['comment_datecounts'].append(
[str_date, group_by_date['comment'][dateinside]])
else:
#data['comment_datecounts'][str_date] = 0
data['comment_datecounts'].append([str_date, 0])
if dateinside in group_by_date['comment_thread']:
#data['thread_datecounts'][str_date] = group_by_date['comment_thread'][dateinside]
data['thread_datecounts'].append(
[str_date, group_by_date['comment_thread'][dateinside]])
else:
#data['thread_datecounts'][str_date] = 0
data['thread_datecounts'].append([str_date, 0])
comm_total = 0
thread_total = 0
for str_date, count in data['comment_datecounts']:
comm_total += count
data['comment_datecountsaggregate'].append([str_date, comm_total])
for str_date, count in data['thread_datecounts']:
thread_total += count
data['thread_datecountsaggregate'].append([str_date, thread_total])
return api.views.api_render(request, data, status.HTTP_200_OK)
def discussion_dates(request, course_id):
if api.views.is_cached(request):
return api.views.api_cacherender(request)
course = api.views.get_course(course_id)
if course is None:
return api.views.api_render(request, {'error': 'Unknown course code'}, status.HTTP_404_NOT_FOUND)
DiscussionForum.connect_to_mongo()
group_by_date = DiscussionForum.group_by_date(course)
print "0"
data = {}
data['min_date'] = ''
data['max_date'] = ''
data['comment_datecounts'] = []
data['thread_datecounts'] = []
data['comment_datecountsaggregate'] = []
data['thread_datecountsaggregate'] = []
if group_by_date['max_date'] is not None and group_by_date['min_date'] is not None:
delta = group_by_date['max_date'] - group_by_date['min_date']
data['min_date'] = str(group_by_date['min_date'])
data['max_date'] = str(group_by_date['max_date'])
for i in range(delta.days + 1):
dateinside = group_by_date['min_date'] + timedelta(days=i)
str_date = str(dateinside)
if dateinside in group_by_date['comment']:
#data['comment_datecounts'][str_date] = group_by_date['comment'][dateinside]
data['comment_datecounts'].append([str_date, group_by_date['comment'][dateinside]])
else:
#data['comment_datecounts'][str_date] = 0
data['comment_datecounts'].append([str_date, 0])
if dateinside in group_by_date['comment_thread']:
#data['thread_datecounts'][str_date] = group_by_date['comment_thread'][dateinside]
data['thread_datecounts'].append([str_date, group_by_date['comment_thread'][dateinside]])
else:
#data['thread_datecounts'][str_date] = 0
data['thread_datecounts'].append([str_date, 0])
comm_total = 0
thread_total = 0
for str_date, count in data['comment_datecounts']:
comm_total += count
data['comment_datecountsaggregate'].append([str_date, comm_total])
for str_date, count in data['thread_datecounts']:
thread_total += count
data['thread_datecountsaggregate'].append([str_date, thread_total])
return api.views.api_render(request, data, status.HTTP_200_OK)
def discussion_category(request, course_id):
if api.views.is_cached(request):
return api.views.api_cacherender(request)
course = api.views.get_course(course_id)
if course is None:
return api.views.api_render(request, {'error': 'Unknown course code'},
status.HTTP_404_NOT_FOUND)
json_file = course['dbname'].replace("_", "-") + '.json'
courseinfo = loadcourseinfo(json_file)
if courseinfo is None:
return api.views.api_render(request,
{'error': 'Can not find course info'},
status.HTTP_404_NOT_FOUND)
data = {}
discussions = []
data['categories'] = get_discussions(courseinfo, discussions)
DiscussionForum.connect_to_mongo()
db_df = DiscussionForum.mongo_client['discussion_forum']
col_df = db_df[course['discussiontable']]
data['min_date'] = str(DiscussionForum.min_date(col_df))
data['max_date'] = str(DiscussionForum.max_date(col_df))
data['popular_number'] = 20
for category in data['categories']:
category_id = category['discussion_id']
data[category_id] = {}
category_group_by_date = DiscussionForum.category_group_by_date(
col_df, category_id)
data[category_id]['thread_datecount'] = sorted(
category_group_by_date['thread'].iteritems())
data[category_id]['comment_datecounts'] = sorted(
category_group_by_date['comment'].iteritems())
data[category_id]['ccomment_datecounts'] = sorted(
category_group_by_date['ccomment'].iteritems())
category_sort_by_answer = DiscussionForum.category_sort_by_answer(
col_df, category_id, data['popular_number'])
data[category_id]['popular_threads'] = category_sort_by_answer[
'popular_threads']
data[category_id]['zones'] = category_sort_by_answer['zones']
return api.views.api_render(request, data, status.HTTP_200_OK)
def discussion_top(request, course_id='all'):
if api.views.is_cached(request):
return api.views.api_cacherender(request)
courses = {}
if course_id == 'all':
courses = api.views.get_all_courses()
else:
course = api.views.get_course(course_id)
if course is None:
return api.views.api_render(request, {'error': 'Unknown course code'}, status.HTTP_404_NOT_FOUND)
courses[course_id] = course
DiscussionForum.connect_to_mongo()
up_num = 10
data = {}
for course_id, course in courses.items():
data[course_id] = DiscussionForum.sort_by_votes(course, up_num)
return api.views.api_render(request, data, status.HTTP_200_OK)
def discussion_top(request, course_id='all'):
if api.views.is_cached(request):
return api.views.api_cacherender(request)
courses = {}
if course_id == 'all' or course_id == 'allcourses':
courses = api.views.get_all_courses()
else:
course = api.views.get_course(course_id)
if course is None:
return api.views.api_render(request,
{'error': 'Unknown course code'},
status.HTTP_404_NOT_FOUND)
courses[course_id] = course
DiscussionForum.connect_to_mongo()
up_num = 10
data = {}
for course_id, course in courses.items():
data[course_id] = DiscussionForum.sort_by_votes(course, up_num)
return api.views.api_render(request, data, status.HTTP_200_OK)
def discussion_category(request, course_id):
if api.views.is_cached(request):
return api.views.api_cacherender(request)
course = api.views.get_course(course_id)
if course is None:
return api.views.api_render(request, {'error': 'Unknown course code'}, status.HTTP_404_NOT_FOUND)
json_file = course['dbname'].replace("_", "-") + '.json'
courseinfo = loadcourseinfo(json_file)
if courseinfo is None:
return api.views.api_render(request, {'error': 'Can not find course info'}, status.HTTP_404_NOT_FOUND)
data = {}
discussions = []
data['categories'] = get_discussions(courseinfo, discussions)
DiscussionForum.connect_to_mongo()
db_df = DiscussionForum.mongo_client['discussion_forum']
col_df = db_df[course['discussiontable']]
data['min_date'] = str(DiscussionForum.min_date(col_df))
data['max_date'] = str(DiscussionForum.max_date(col_df))
data['popular_number'] = 20
for category in data['categories']:
category_id = category['discussion_id']
data[category_id] = {}
category_group_by_date = DiscussionForum.category_group_by_date(col_df, category_id)
data[category_id]['thread_datecount'] = sorted(category_group_by_date['thread'].iteritems())
data[category_id]['comment_datecounts'] = sorted(category_group_by_date['comment'].iteritems())
data[category_id]['ccomment_datecounts'] = sorted(category_group_by_date['ccomment'].iteritems())
category_sort_by_answer = DiscussionForum.category_sort_by_answer(col_df, category_id, data['popular_number'])
data[category_id]['popular_threads'] = category_sort_by_answer['popular_threads']
data[category_id]['zones'] = category_sort_by_answer['zones']
return api.views.api_render(request, data, status.HTTP_200_OK)
def discussion_countries(request, course_id='all'):
if api.views.is_cached(request):
return api.views.api_cacherender(request)
courses = {}
if course_id == 'all' or course_id == 'allcourses':
courses = api.views.get_all_courses()
else:
course = api.views.get_course(course_id)
if course is None:
return api.views.api_render(request,
{'error': 'Unknown course code'},
status.HTTP_404_NOT_FOUND)
courses[course_id] = course
#print courses
DiscussionForum.connect_to_mongo()
data = {}
data['country_dict'] = {}
data['country_enrol'] = {}
data['post_total'] = 0
#data['user_total'] = 0
for course in courses.values():
df_map = DiscussionForum.post_user_country(course)
for country, num in df_map['country_dict'].items():
data['post_total'] += num
if country in data['country_dict']:
data['country_dict'][country] += num
else:
data['country_dict'][country] = num
#remove duplicate of user?
for item in df_map['country_enrol']:
#data['user_total'] += item['userSum']
if item['_id'] in data['country_enrol']:
data['country_enrol'][item['_id']] += item['userSum']
else:
data['country_enrol'][item['_id']] = item['userSum']
data['country_post'] = []
data['post_max'] = 0
for country, num in data['country_dict'].items():
post_percentage = round(num * 100 / float(data['post_total']), 2)
data['country_post'].append([country, num, post_percentage])
if post_percentage > data['post_max']:
data['post_max'] = post_percentage
data['country_post_enrol'] = []
data['post_enrol_max'] = 0
for country, userSum in data['country_enrol'].items():
if country in data['country_dict']:
pe_percentage = round(
data['country_dict'][country] * 100 / float(userSum), 2)
post_enrol = [
country, data['country_dict'][country], userSum, pe_percentage
]
if pe_percentage > data['post_enrol_max']:
data['post_enrol_max'] = pe_percentage
else:
post_enrol = [country, 0, userSum, 0]
data['country_post_enrol'].append(post_enrol)
return api.views.api_render(request, data, status.HTTP_200_OK)