def edit_(self, language=None, source=None, filename=None, **kwargs):
self._edit_permissions()
log.info(dict(submission_id=self.submission.id,
assignment_id=self.assignment.id,
language=language, filename=filename, source=source))
#self.submission.assignment = self.assignment
#if request.student:
# self.submission.student = request.student
if self.submission.language != language:
self.submission.language = language
if self.submission.source != source:
self.submission.source = source
if self.submission.filename != filename:
self.submission.filename = filename
if self.submission in DBSession.dirty:
self.submission.modified = datetime.now()
DBSession.add(self.submission)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
log.warn('Submission %d could not be saved', self.submission.id, exc_info=True)
flash('Your submission could not be saved!', 'error')
redirect(self.submission.url + '/edit')
else:
redirect(self.submission.url + '/result')
def submit(self, *args, **kwargs):
'''Create new submission for this assignment'''
if 'manage' not in request.permissions and \
request.user not in set(self.event.members) | set(self.event.tutorsandteachers):
abort(403)
if (not self.assignment.is_active and
not request.allowance(self.assignment)):
flash('This assignment is not active, you may not create a submission', 'warning')
redirect(url(self.assignment.url))
submission = Submission(
assignment=self.assignment,
filename=self.assignment.submission_filename or None,
source=self.assignment.submission_template or None,
language=self.assignment.allowed_languages[0] if self.assignment.allowed_languages else None,
user=request.user,
created=datetime.now(),
modified=datetime.now(),
)
DBSession.add(submission)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
log.warn('Error creating new submission', exc_info=True)
flash('Error creating new submission', 'error')
redirect(url(self.assignment.url))
else:
redirect(url(submission.url + '/edit'))
def submit(self, *args, **kwargs):
'''Create new submission for this assignment'''
if 'manage' not in request.permissions and \
request.user not in set(self.event.members) | set(self.event.tutorsandteachers):
abort(403)
if (not self.assignment.is_active
and not request.allowance(self.assignment)):
flash(
'This assignment is not active, you may not create a submission',
'warning')
redirect(url(self.assignment.url))
submission = Submission(
assignment=self.assignment,
filename=self.assignment.submission_filename or None,
source=self.assignment.submission_template or None,
language=self.assignment.allowed_languages[0]
if self.assignment.allowed_languages else None,
user=request.user,
created=datetime.now(),
modified=datetime.now(),
)
DBSession.add(submission)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
log.warn('Error creating new submission', exc_info=True)
flash('Error creating new submission', 'error')
redirect(url(self.assignment.url))
else:
redirect(url(submission.url + '/edit'))
def setUp(self):
super(TestEnrolling, self).setUp()
self.user = User(user_name='studentxxx',
display_name='Student XXX',
email_address='*****@*****.**')
DBSession.add(self.user)
transaction.commit()
self.extra_environ = dict(REMOTE_USER=self.user.user_name)
def edit_(self, *args, **kwargs):
self._get_session_data()
v = SubmissionForm.validate(kwargs)
language = v['language']
source = v['source']
filename = v['filename']
self.submission.assignment = self.assignment
self.submission.user = self.user
if self.submission.language != language:
self.submission.language = language
if self.submission.source != source:
self.submission.source = source
if self.submission.filename != filename:
self.submission.filename = filename
if self.submission in DBSession.dirty:
self.submission.modified = datetime.now()
DBSession.add(self.submission)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
log.warn('Submission %r could not be saved',
self.submission,
exc_info=True)
flash('Your submission could not be saved!', 'error')
redirect('./edit')
else:
# redirect(self.submission.url + '/result')
pass
(compilation, testruns, result) = self.submission.run_tests()
testruns = sorted(set(self.submission.testruns), key=lambda s: s.date)
result = self.submission.result
if result is True:
score = 1.0
else:
if testruns:
score = (float(len([t for t in testruns if t.result])) /
float(len(testruns)))
else:
score = 0.0
send = self._send_result(score, str(result))
log.info(send)
return dict(assignment=self.assignment,
submission=self.submission,
user=self.user,
compilation=compilation,
testruns=testruns,
result=result,
score=score)
def index(self, *args, **kwargs):
try:
server = oauth2.Server()
server.add_signature_method(oauth2.SignatureMethod_HMAC_SHA1())
req = oauth2.Request.from_request(
request.method, request.url, request.headers, request.params, request.query_string
)
params = server.verify_request(req, oauth2.Consumer(self.key, self.secret), None)
except:
log.debug("LTI Tool Provider OAuth Error", exc_info=True)
flash("LTI Tool Provider OAuth Error", "error")
abort(403)
else:
log.debug(params)
user_name = (
params.get("tool_consumer_info_product_family_code", "external")
+ "_"
+ params.get("tool_consumer_instance_guid", "external")
+ "_"
+ params.get("user_id")
)
user = User.query.filter_by(user_name=user_name).first()
if not user:
log.info("New user %s", user_name)
user = User(
user_name=user_name,
display_name=params.get("lis_person_name_full"),
email_address=params.get("lis_person_contact_email_primary"),
)
DBSession.add(user)
submission = Submission.query.filter(Submission.assignment == self.assignment, Submission.user == user).first()
if not submission:
submission = Submission(
assignment=self.assignment,
filename=self.assignment.submission_filename or None,
source=self.assignment.submission_template or None,
language=self.assignment.allowed_languages[0],
user=user,
created=datetime.now(),
modified=datetime.now(),
)
DBSession.add(submission)
DBSession.flush()
session["lti"] = True
session["params"] = params
session["user"] = user.id
session["submission"] = submission.id
session.save()
redirect("/lti/%d/edit" % self.assignment.id)
def index(self, *args, **kwargs):
try:
server = oauth2.Server()
server.add_signature_method(oauth2.SignatureMethod_HMAC_SHA1())
req = oauth2.Request.from_request(request.method, request.url,
request.headers, request.params,
request.query_string)
params = server.verify_request(
req, oauth2.Consumer(self.key, self.secret), None)
except:
log.debug('LTI Tool Provider OAuth Error', exc_info=True)
flash('LTI Tool Provider OAuth Error', 'error')
abort(403)
else:
log.debug(params)
user_name = (
params.get('tool_consumer_info_product_family_code', 'external') +
'_' + params.get('tool_consumer_instance_guid', 'external') + '_' +
params.get('user_id'))
user = User.query.filter_by(user_name=user_name).first()
if not user:
log.info('New user %s', user_name)
user = User(
user_name=user_name,
display_name=params.get('lis_person_name_full'),
email_address=params.get('lis_person_contact_email_primary'),
)
DBSession.add(user)
submission = Submission.query.filter(
Submission.assignment == self.assignment,
Submission.user == user).first()
if not submission:
submission = Submission(
assignment=self.assignment,
filename=self.assignment.submission_filename or None,
source=self.assignment.submission_template or None,
language=self.assignment.allowed_languages[0],
user=user,
created=datetime.now(),
modified=datetime.now(),
)
DBSession.add(submission)
DBSession.flush()
session['lti'] = True
session['params'] = params
session['user'] = user.id
session['submission'] = submission.id
session.save()
redirect('/lti/%d/edit' % self.assignment.id)
def edit_(self, *args, **kwargs):
self._get_session_data()
v = SubmissionForm.validate(kwargs)
language = v["language"]
source = v["source"]
filename = v["filename"]
self.submission.assignment = self.assignment
self.submission.user = self.user
if self.submission.language != language:
self.submission.language = language
if self.submission.source != source:
self.submission.source = source
if self.submission.filename != filename:
self.submission.filename = filename
if self.submission in DBSession.dirty:
self.submission.modified = datetime.now()
DBSession.add(self.submission)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
log.warn("Submission %r could not be saved", self.submission, exc_info=True)
flash("Your submission could not be saved!", "error")
redirect("./edit")
else:
# redirect(self.submission.url + '/result')
pass
(compilation, testruns, result) = self.submission.run_tests()
testruns = sorted(set(self.submission.testruns), key=lambda s: s.date)
result = self.submission.result
if result is True:
score = 1.0
else:
if testruns:
score = float(len([t for t in testruns if t.result])) / float(len(testruns))
else:
score = 0.0
send = self._send_result(score, str(result))
log.info(send)
return dict(
assignment=self.assignment,
submission=self.submission,
user=self.user,
compilation=compilation,
testruns=testruns,
result=result,
score=score,
)
def setUp(self):
"""Prepare model test fixture."""
try:
new_attrs = {}
new_attrs.update(self.attrs)
new_attrs.update(self.do_get_dependencies())
self.obj = self.klass(**new_attrs)
DBSession.add(self.obj)
DBSession.flush()
return self.obj
except:
DBSession.rollback()
raise
def test_integration_2(self):
test = Test(
assignment_id=42,
output_data=u'42 Bananas\n4711 Strawberrys\n1337 Apples\n',
splitlines=True, sort=True,
)
DBSession.add(test)
DBSession.flush()
test = DBSession.merge(test)
d = u'#Result:\n4711 Strawberrys\n42 Bananas\n1337 Apples\n'
result, _, expected, output, _ = test.validate(d)
converted_output = test.unconvert(test.convert(d))
assert result is True, (expected, output, converted_output)
def setUp(self):
"""Prepare model test fixture."""
try:
new_attrs = {}
new_attrs.update(self.attrs)
new_attrs.update(self.do_get_dependencies())
self.obj = self.klass(**new_attrs)
DBSession.add(self.obj)
DBSession.flush()
return self.obj
except:
DBSession.rollback()
raise
def test_integration_1(self):
test = Test(
assignment_id=42,
output_data=u'1.0,2.0,3.0\n4.0,5.0,6.0\n7.0,8.0,9.0\n',
separator=',', split=True, splitlines=True,
parse_float=True, float_precision=1,
)
DBSession.add(test)
DBSession.flush()
test = DBSession.merge(test)
d = u'#Result:\n1,2,3\n4,5,6\n,7,8,9\n'
result, _, expected, output, _ = test.validate(d)
converted_output = test.unconvert(test.convert(d))
assert result is True, (expected, output, converted_output)
def main():
args = parse_args()
load_config(args.conf_file)
#print model.DBSession.query(model.User.user_name).all()
events = Session.query(model.Event).all()
print[(i, e.name) for i, e in enumerate(events)]
event_id = raw_input('event_id: ')
event = events[int(event_id)]
fix_languages = raw_input("Allow all languages on all assignments? [y]")
if fix_languages == 'y':
l = Session.query(model.Language).all()
for a in Session.query(
model.Assignment).filter_by(event_id=event.id).all():
a = Session.merge(a)
a.allowed_languages = l
Session.add(a)
try:
transaction.commit()
except IntegrityError:
print traceback.format_exc()
transaction.abort()
fix_visible_tests = raw_input(
"Fix boolean visible attribute on tests? [y]")
if fix_visible_tests == 'y':
for a in Session.query(
model.Assignment).filter_by(event_id=event.id).all():
a = Session.merge(a)
print u'Assignment: %s' % a.name
for t in a.tests:
print u'Test %d, Output length %d' % (t.id, len(t.output))
visible = raw_input('Make test visible? [y]')
if visible == 'y':
t.visible = True
Session.add(t)
try:
transaction.commit()
except IntegrityError:
print traceback.format_exc()
transaction.abort()
def _test_attr(args):
kwargs, expected_output_data, good_output_data = args[0:3]
bad_output_data = args[4:]
test = Test(assignment_id=42, output_data=expected_output_data, **kwargs)
DBSession.add(test)
DBSession.flush()
test = DBSession.merge(test)
for d in good_output_data:
result, _, expected, output, _ = test.validate(d)
converted_output = test.unconvert(test.convert(d))
assert result is True, (expected, output, converted_output)
for d in bad_output_data:
result, _, expected, output, _ = test.validate(d)
converted_output = test.unconvert(test.convert(d))
assert result is False, (expected, output, converted_output)
def submit(self):
'''Create new submission for this assignment'''
if not self.assignment.is_active and \
not request.allowance(self.assignment):
flash('This assignment is not active, you may not create a submission', 'warning')
redirect(url(self.assignment.url))
submission = Submission(assignment=self.assignment, user=request.user,
created=datetime.now())
DBSession.add(submission)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
log.warn('Error creating new submission', exc_info=True)
flash('Error creating new submission', 'error')
redirect(url(self.assignment.url))
else:
redirect(url(submission.url + '/edit'))
def main():
args = parse_args()
load_config(args.conf_file)
#print model.DBSession.query(model.User.user_name).all()
events = Session.query(model.Event).all()
print[(i, e.name) for i, e in enumerate(events)]
event_id = raw_input('event_id: ')
event = events[int(event_id)]
while True:
teamname = raw_input("Team-Name: ")
if not isinstance(teamname, unicode):
teamname = teamname.decode('utf-8')
password = getpass("Password: "******"Next Team? [y]")
if next != 'y':
break
def clone(self):
s = Submission(
user=request.user,
assignment=self.submission.assignment,
filename=self.submission.filename,
source=self.submission.source,
language=self.submission.language,
)
DBSession.add(s)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
flash('Error cloning submission', 'error')
redirect(url(self.submission.url + '/show'))
finally:
s = DBSession.merge(s)
flash('Cloned submission %d from %d' % (s.id, self.submission.id), 'ok')
redirect(url(s.url + '/show'))
def clone(self, *args, **kwargs):
s = Submission(
user=request.user,
assignment=self.submission.assignment,
filename=self.submission.filename,
source=self.submission.source,
language=self.submission.language,
# TODO: Clone comment or not?
)
DBSession.add(s)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
flash('Error cloning submission', 'error')
redirect(url(self.submission.url + '/show'))
finally:
s = DBSession.merge(s)
flash('Cloned submission %d from %d' % (s.id, self.submission.id), 'ok')
redirect(url(s.url + '/show'))
def submit(self):
'''Create new submission for this assignment'''
if not self.assignment.is_active and \
not request.allowance(self.assignment):
flash(
'This assignment is not active, you may not create a submission',
'warning')
redirect(url(self.assignment.url))
submission = Submission(assignment=self.assignment,
user=request.user,
created=datetime.now())
DBSession.add(submission)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
log.warn('Error creating new submission', exc_info=True)
flash('Error creating new submission', 'error')
redirect(url(self.assignment.url))
else:
redirect(url(submission.url + '/edit'))
def edit_(self, language=None, source=None, filename=None, comment=None, *args, **kwargs):
self._edit_permissions()
log.debug(dict(submission_id=self.submission.id,
assignment_id=self.assignment.id,
language=language, filename=filename, source=source))
#self.submission.assignment = self.assignment
#if request.student:
# self.submission.student = request.student
if self.submission.language != language:
self.submission.language = language
if self.submission.source != source:
self.submission.source = source
if self.submission.filename != filename:
self.submission.filename = filename
# TODO: Only changing the comment should not trigger re-testing, but it does.
if self.submission.comment != comment:
self.submission.comment = comment
if self.submission in DBSession.dirty:
self.submission.modified = datetime.now()
if self.submission in DBSession.dirty:
DBSession.add(self.submission)
try:
DBSession.flush()
except SQLAlchemyError:
DBSession.rollback()
log.warn('Submission %r could not be saved', self.submission, exc_info=True)
flash('Your submission could not be saved!', 'error')
redirect(self.submission.url + '/edit')
else:
redirect(self.submission.url + '/result')
def enroll(self, password=None, lesson=None, team=None, *args, **kwargs):
'''Event enrolling page'''
params = {}
if not self.event.enroll:
flash('Enroll not allowed', 'error')
return HTTPForbidden()
if self.event.password and password != self.event.password:
if password:
flash('Wrong password', 'error')
c.text = u'Please enter the password to enroll for this event:'
c.form = PasswordEnrollForm
else:
if password:
params['password'] = password
if self.event.enroll == 'event':
try:
self.event._members.append(request.user)
DBSession.flush()
except SQLAlchemyError:
log.warn('Error while enrolling user %r for event %r:', request.user, self.event, exc_info=True)
flash('An error occured', 'error')
else:
flash('Enrolled for Event "%s"' % self.event.name,
'ok')
redirect(self.event.url)
if self.event.enroll in ('lesson_team', 'team', 'team_new') and team:
if self.event.enroll == 'team_new' and team == '__new__':
try:
lesson = Lesson.query.get(int(lesson))
except ValueError:
lesson = team = None
else:
# Get unique team name
q = Team.query.filter_by(lesson=lesson)
i = q.count() + 1
while True:
name = 'New Team %d' % i
t = q.filter_by(name=name).first()
if not t:
break
i = i + 1
team = Team(lesson=lesson, name=name)
DBSession.add(team)
else:
try:
team = Team.query.get(int(team))
except ValueError:
team = None
if team:
try:
team.members.append(request.user)
DBSession.flush()
except SQLAlchemyError:
log.warn('Error while enrolling user %r for team %r:', request.user, team, exc_info=True)
flash('An error occured', 'error')
lesson = lesson.id
else:
flash('Enrolled for Team "%s" in Lesson "%s" in Event "%s"'
% (team.name, team.lesson.name, self.event.name),
'ok')
redirect(self.event.url)
else:
flash('Selected Team does not exist', 'error')
if self.event.enroll in ('lesson', 'lesson_team', 'team', 'team_new') and not lesson:
c.text = u'Please select the lesson you would like to attend:'
c.form = LessonSelectionForm(event=self.event, action=url('', params))
if self.event.enroll == 'lesson' and lesson:
try:
lesson = Lesson.query.get(int(lesson))
except ValueError:
lesson = None
if lesson:
try:
lesson._members.append(request.user)
DBSession.flush()
except SQLAlchemyError:
log.warn('Error while enrolling user %r for lesson %r:', request.user, lesson, exc_info=True)
flash('An error occured', 'error')
else:
flash('Enrolled for Lesson "%s" in Event "%s"'
% (lesson.name, self.event.name),
'ok')
redirect(self.event.url)
else:
flash('Selected Lesson does not exist',
'error')
if self.event.enroll in ('lesson_team', 'team', 'team_new') and lesson:
try:
lesson = Lesson.query.get(int(lesson))
except ValueError:
lesson = None
else:
params['lesson'] = lesson.id
c.text = u'Please select the team in which you would like to work:'
c.form = TeamSelectionForm(
lesson=lesson,
new=bool(self.event.enroll == 'team_new'),
action=url('', params),
)
return dict(page='events', heading=u'Enroll for %s' % self.event.name)
events = Session.query(model.Event).all()
print [(i, e.name) for i,e in enumerate(events)]
event_id = raw_input('event_id: ')
event = events[int(event_id)]
fix_languages = raw_input("Allow all languages on all assignments? [y]")
if fix_languages == 'y':
l = Session.query(model.Language).all()
for a in Session.query(model.Assignment).filter_by(event_id=event.id).all():
a = Session.merge(a)
a.allowed_languages=l
Session.add(a)
try:
transaction.commit()
except IntegrityError:
print traceback.format_exc()
transaction.abort()
fix_visible_tests = raw_input("Fix boolean visible attribute on tests? [y]")
if fix_visible_tests == 'y':
for a in Session.query(model.Assignment).filter_by(event_id=event.id).all():
a = Session.merge(a)
print u'Assignment: %s' % a.name
for t in a.tests:
print u'Test %d, Output length %d' % (t.id, len(t.output))
def setup():
"""Function called by nose on module load"""
setup_db()
DBSession.add(User(id=4771, user_name='dummy', email_address='*****@*****.**'))
DBSession.flush()
def setup():
"""Function called by nose on module load"""
setup_db()
assignment = Assignment(id=42, name='Dummy', assignment_id=42)
DBSession.add(assignment)
DBSession.flush()
def setUp(self):
super(TestEnrolling, self).setUp()
self.user = User(user_name='studentxxx', display_name='Student XXX', email_address='*****@*****.**')
DBSession.add(self.user)
transaction.commit()
self.extra_environ = dict(REMOTE_USER=self.user.user_name)
print [(i, e.name) for i, e in enumerate(events)]
event_id = raw_input('event_id: ')
event = events[int(event_id)]
while True:
teamname = raw_input("Team-Name: ")
if not isinstance(teamname, unicode):
teamname = teamname.decode('utf-8')
password = getpass("Password: ")
if not isinstance(password, unicode):
password = password.decode('utf-8')
team = model.Team(name=teamname)
team.events.append(event)
Session.add(team)
student = model.Student(
user_name=teamname, display_name=teamname,
email_address=teamname + '@students.uni-mainz.de',
password=password,
teams=[team],
)
Session.add(student)
try:
transaction.commit()
except IntegrityError:
print traceback.format_exc()
transaction.abort()
def setup():
"""Function called by nose on module load"""
setup_db()
DBSession.add(
User(id=4771, user_name='dummy', email_address='*****@*****.**'))
DBSession.flush()
