def handle(self, *args, **options):
if options['datebefore']:
max_timestamp = calendar.timegm(time.strptime(options['datebefore'], '%d/%m/%Y %H:%M'))
else:
max_timestamp = calendar.timegm(time.gmtime())
if options['dateafter']:
min_timestamp = calendar.timegm(time.strptime(options['dateafter'], '%d/%m/%Y %H:%M'))
else:
min_timestamp = 0
if options['enrollments']:
# Get enrollments
enrollments = CourseStudent.objects.exclude(timestamp__lte=min_timestamp).filter(timestamp__lte=max_timestamp)
self.message("%d enrollments between %d and %d" % (enrollments.count(), min_timestamp, max_timestamp))
#Send each enrollment entry as xAPI statement
bar = pyprind.ProgBar(enrollments.count())
for enrollment in enrollments:
try:
geolocation = {
'lat': enrollment.pos_lat,
'lon': enrollment.pos_lon
}
timestamp = time.gmtime(enrollment.timestamp)
learnerEnrollsInMooc(enrollment.student, enrollment.course, geolocation, timestamp)
except:
self.error('ERROR sending an statement for user %s in enrollment with timestamp %s' % (enrollment.student, time.strftime("%d/%m/%Y %H:%M:%S", timestamp)))
if options['debug']:
exc_type, exc_value, exc_traceback = sys.exc_info()
self.error('Exception %s: %s' % (exc_type, exc_value))
traceback.print_tb(exc_traceback, limit=5, file=sys.stdout)
continue
bar.update()
self.message('\nEnrollments succesfully exported')
if options['accesses']:
# Get history
history_col = mongodb.get_db().get_collection('history')
histories = history_col.find({'$and': [
{'timestamp': {'$lte': max_timestamp * 1000} },
{'timestamp': {'$gte': min_timestamp * 1000} }
]})
self.message("%d histories until %d" % (histories.count(), max_timestamp))
# Send each history entry as xAPI Statement
bar = pyprind.ProgBar(histories.count())
for history in histories:
course = None
try:
user_id = str(int(history['user_id']))
user = User.objects.get(pk=user_id)
if 'course_id' in history:
course_id = str(int(history['course_id']))
course = Course.objects.get(pk=course_id)
page = {}
page['url'] = history['url']
if course:
page['name'] = course.name
page['description'] = course.name
else:
page['name'] = ''
page['description'] = ''
geolocation = {
'lat': history['lat'],
'lon': history['lon']
}
timestamp = time.gmtime(history['timestamp']/1000)
learnerAccessAPage(user, page, course, geolocation, timestamp)
except:
self.error('ERROR sending a statement for user %s in history with timestamp %s' % (history['user_id'], time.strftime("%d/%m/%Y %H:%M:%S", timestamp)))
if options['debug']:
exc_type, exc_value, exc_traceback = sys.exc_info()
self.error('Exception %s: %s' % (exc_type, exc_value))
traceback.print_tb(exc_traceback, limit=5, file=sys.stdout)
continue
bar.update()
self.message('\nHistory succesfully exported')
if options['forum']:
# Get forum entries
if options['datebefore']:
max_date = time.strftime('%Y-%m-%dT%H:%M',time.strptime(options['datebefore'], '%d/%m/%Y %H:%M'))
else:
max_date = time.strftime('%Y-%m-%dT%H:%M',time.gmtime())
if options['dateafter']:
min_date = time.strftime('%Y-%m-%dT%H:%M',time.strptime(options['dateafter'], '%d/%m/%Y %H:%M'))
else:
min_date = '1970-01-01T00:00'
forum_col = mongodb.get_db().get_collection('forum_post')
forum_posts = forum_col.find({'$and': [
{'date': {'$lte': max_date} },
{'date': {'$gte': min_date} }
]})
self.message("%d forum posts between %s and %s" % (forum_posts.count(), min_date, max_date))
# Send each post entry as xAPI Statement
bar = pyprind.ProgBar(forum_posts.count())
for post in forum_posts:
course = None
try:
user_id = str(int(post['id_user']))
user = User.objects.get(pk=user_id)
if 'category_slug' in post:
course_slug = str(post['category_slug'])
course = Course.objects.get(slug=course_slug)
page = {}
post_url = "https://%s%s" % (settings.API_URI, reverse('course_forum_post', kwargs={'course_slug': course_slug, 'post_id': post['_id']})),
page['url'] = post_url[0]
if 'is_child' in post:
is_child = bool(post['is_child'])
else:
is_child = False
if is_child:
page['type'] = 'threadreply'
page['description'] = "This is a forum message"
else:
page['type'] = 'threadpost'
page['description'] = "This is a thread-opening forum message"
if 'title' in post:
page['name'] = post['title']
else:
page['name'] = "Unnamed post"
geolocation = {
'lat': 0.0,
'lon': 0.0
}
timestamp = time.strptime(post['date'], '%Y-%m-%dT%H:%M:%S.%f')
learnerSubmitsAResource(user, page, course, geolocation, timestamp)
except:
self.error('\nERROR sending a statement for user %s in post with timestamp %s' % (post['id_user'], post['date']))
if options['debug']:
exc_type, exc_value, exc_traceback = sys.exc_info()
self.error('Exception %s: %s' % (exc_type, exc_value))
traceback.print_tb(exc_traceback, limit=5, file=sys.stdout)
continue
bar.update()
self.message('\nForum succesfully exported')
if options['tasks']:
# Get tasks entries
if options['datebefore']:
max_date = datetime.fromtimestamp(time.mktime(time.strptime(options['datebefore'], '%d/%m/%Y %H:%M')))
else:
max_date = datetime.fromtimestamp(time.mktime(time.gmtime()))
if options['dateafter']:
min_date = datetime.fromtimestamp(time.mktime(time.strptime(options['dateafter'], '%d/%m/%Y %H:%M')))
else:
min_date = datetime.fromtimestamp(time.mktime(time.strptime('1970-01-01T00:00', '%d/%m/%Y %H:%M')))
tasks_col = mongodb.get_db().get_collection('answers')
tasks_entries = tasks_col.find({'$and': [
{'date': {'$lte': max_date} },
{'date': {'$gte': min_date} }
]})
self.message("%d task submission entries between %s and %s" % (tasks_entries.count(), options['dateafter'], options['datebefore']))
# Send each task entry as xAPI Statement
bar = pyprind.ProgBar(tasks_entries.count())
for task in tasks_entries:
course = None
try:
user_id = str(int(task['user_id']))
user = User.objects.get(pk=user_id)
if 'course_id' in task:
course_id = int(task['course_id'])
course = Course.objects.get(pk=course_id)
page = {}
task_url = "https://%s%s#unit%s/kq%s/q" % (settings.API_URI, reverse('course_classroom', kwargs={'course_slug': course.slug}),task['unit_id'],task['kq_id']),
page['url'] = task_url[0]
page['type'] = 'task'
kq = KnowledgeQuantum.objects.get(pk=task['kq_id'])
page['name'] = kq.title
page['description'] = 'Task for course %s' % (course.name)
geolocation = {
'lat': 0.0,
'lon': 0.0
}
timestamp = task['date'].timetuple()
learnerSubmitsAResource(user, page, course, geolocation, timestamp)
except:
self.error('\nERROR sending a statement for user %s in task with timestamp %s' % (task['user_id'], task['date']))
if options['debug']:
exc_type, exc_value, exc_traceback = sys.exc_info()
self.error('Exception %s: %s' % (exc_type, exc_value))
traceback.print_tb(exc_traceback, limit=5, file=sys.stdout)
continue
bar.update()
self.message('\nTask submission entries succesfully exported')
if options['peerassessments']:
# Get peerassessments entries
if options['datebefore']:
max_date = datetime.fromtimestamp(time.mktime(time.strptime(options['datebefore'], '%d/%m/%Y %H:%M')))
else:
max_date = datetime.fromtimestamp(time.mktime(time.gmtime()))
if options['dateafter']:
min_date = datetime.fromtimestamp(time.mktime(time.strptime(options['dateafter'], '%d/%m/%Y %H:%M')))
else:
min_date = datetime.fromtimestamp(time.mktime(time.strptime('1970-01-01T00:00', '%d/%m/%Y %H:%M')))
prs_col = mongodb.get_db().get_collection('peer_review_submissions')
prs_entries = prs_col.find({'$and': [
{'created': {'$lte': max_date} },
{'created': {'$gte': min_date} }
]})
self.message("%d peer review submission entries between %s and %s" % (prs_entries.count(), options['dateafter'], options['datebefore']))
# Send each peer review submission entry as xAPI Statement
bar = pyprind.ProgBar(prs_entries.count())
for pr in prs_entries:
course = None
try:
user_id = str(int(pr['author']))
user = User.objects.get(pk=user_id)
if 'course' in pr:
course_id = int(pr['course'])
course = Course.objects.get(pk=course_id)
page = {}
pr_url = "https://%s%s#unit%s/kq%s/p" % (settings.API_URI, reverse('course_classroom', kwargs={'course_slug': course.slug}),pr['unit'],pr['kq']),
page['url'] = pr_url[0]
page['type'] = 'assessment'
kq = KnowledgeQuantum.objects.get(pk=pr['kq'])
page['name'] = kq.title
page['description'] = 'Peer assesment for course %s' % (course.name)
geolocation = {
'lat': 0.0,
'lon': 0.0
}
timestamp = pr['created'].timetuple()
learnerSubmitsAResource(user, page, course, geolocation, timestamp)
except:
self.error('\nERROR sending a statement for user %s in peer review submission with timestamp %s' % (pr['author'], pr['created']))
if options['debug']:
exc_type, exc_value, exc_traceback = sys.exc_info()
self.error('Exception %s: %s' % (exc_type, exc_value))
traceback.print_tb(exc_traceback, limit=5, file=sys.stdout)
continue
bar.update()
self.message('\nPeer assessment submission entries succesfully exported')
if options['peerreviews']:
# Get peerassessments entries
if options['datebefore']:
max_date = datetime.fromtimestamp(time.mktime(time.strptime(options['datebefore'], '%d/%m/%Y %H:%M')))
else:
max_date = datetime.fromtimestamp(time.mktime(time.gmtime()))
if options['dateafter']:
min_date = datetime.fromtimestamp(time.mktime(time.strptime(options['dateafter'], '%d/%m/%Y %H:%M')))
else:
min_date = datetime.fromtimestamp(time.mktime(time.strptime('1970-01-01T00:00', '%d/%m/%Y %H:%M')))
prr_col = mongodb.get_db().get_collection('peer_review_reviews')
prr_entries = prr_col.find({'$and': [
{'created': {'$lte': max_date} },
{'created': {'$gte': min_date} }
]})
self.message("%d peer review submission entries between %s and %s" % (prr_entries.count(), options['dateafter'], options['datebefore']))
# Send each peer review submission entry as xAPI Statement
bar = pyprind.ProgBar(prr_entries.count())
for pr in prr_entries:
course = None
try:
user_id = str(int(pr['reviewer']))
user = User.objects.get(pk=user_id)
if 'course' in pr:
course_id = int(pr['course'])
course = Course.objects.get(pk=course_id)
kq = KnowledgeQuantum.objects.get(pk=pr['kq'])
assignment = PeerReviewAssignment.objects.get(kq__id=pr['kq'])
page = {}
pr_url = "https://%s%s" % (settings.API_URI, reverse('course_review_review', kwargs={'course_slug': course.slug, 'assignment_id': assignment.id})),
page['url'] = pr_url[0]
page['type'] = 'peerfeedback'
page['name'] = kq.title
page['description'] = 'Peer assesment for course %s' % (course.name)
geolocation = {
'lat': 0.0,
'lon': 0.0
}
score = get_peer_review_review_score(pr) *2 / 10
result = {
'score': score,
'comment': pr['comment']
}
timestamp = pr['created'].timetuple()
learnerSubmitsAResource(user, page, course, geolocation, timestamp, result=result)
except:
self.error('\nERROR sending a statement for user %s in peer review submission with timestamp %s' % (pr['author'], pr['created']))
if options['debug']:
exc_type, exc_value, exc_traceback = sys.exc_info()
self.error('Exception %s: %s' % (exc_type, exc_value))
traceback.print_tb(exc_traceback, limit=5, file=sys.stdout)
continue
bar.update()
self.message('\nPeer review submission entries succesfully exported')
def free_enrollment(request, course_slug):
course, permission = get_course_if_user_can_view_and_permission(course_slug, request)
if permission:
if request.method == 'POST':
if course.has_groups:
groupNames = {
'es': 'Grupo',
'en': 'Group',
'fr': 'Groupe',
'pt': 'Grupo',
'de': 'Gruppe',
'it': 'Gruppo'
}
if request.user.get_profile().language and request.user.get_profile().language in groupNames:
language = request.user.get_profile().language
else:
language = request.LANGUAGE_CODE
print 'Language = %s' % (language)
groupCollection = mongodb.get_db().get_collection('groups')
groups = groupCollection.find({ 'id_course': course.id, 'lang': language }).sort("size",pymongo.ASCENDING)
if groups:
new_member = {"id_user": request.user.id, "username": request.user.username,
"first_name":request.user.first_name, "last_name":request.user.last_name,
"email": request.user.email, "karma": request.user.get_profile().karma, "country": request.user.get_profile().country,
"language": language}
if groups.count() > 0:
group = groups[0]
if(len(group["members"]) <= course.group_max_size):
group["members"].append(new_member)
if "size" in group:
group["size"] += 1
else:
group["size"] = len(group["members"])
groupCollection.update({'_id': ObjectId(group["_id"])}, {"$set": {"members": group["members"], "size": group["size"]}})
else:
group = {"id_course": course.id, "name": groupNames[language] + str(groups.count()+1), "hashtag": course.hashtag+groupNames[language] + str(groups.count()+1) ,"lang": language, "size": 1, "members": []}
group["members"].append(new_member)
groupCollection.insert(group)
else:
group = {"id_course": course.id, "name": groupNames[language] + str(groups.count()+1), "hashtag": course.hashtag+groupNames[language] + str(groups.count()+1), "lang": language, "size": 1, "members": []}
group["members"].append(new_member)
groupCollection.insert(group)
user = request.user
lat = request.POST["latitude"]
lon = request.POST["longitude"]
geolocation = {
'lat': lat,
'lon': lon
}
old_course_status = 'f'
if course.created_from:
if course.created_from.students.filter(pk=user.pk):
old_course_status = 'n'
course.students.through.objects.create(student=user,
course=course,
old_course_status=old_course_status,
timestamp=int(round(time.time())),
pos_lat=lat,
pos_lon=lon)
if getattr(settings, 'FREE_ENROLLMENT_CONSISTENT', False):
enroll_course_at_idp(request.user, course)
# Send xAPI event
x_api.learnerEnrollsInMooc(user, course, geolocation)
success(request,
_(u'Congratulations, you have successfully enroll in the course %(course)s')
% {'course': unicode(course)})
return HttpResponseRedirect(reverse('course_dashboard',
args=(course.slug, )))