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 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()
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()