def enroll(event_id):
user = logged_in_user_or_404()
event = Event.query.get(event_id)
form = EnrollmentForm()
form.audit.query = Audit.query.filter(Audit.event==event)
if form.validate_on_submit():
enrollment = Enrollment()
enrollment.user = user
enrollment.user_id = user.id
enrollment.audit = form.audit.data
enrollment.audit_id = enrollment.audit.id
enrollment.enrollment_date = datetime.datetime.now()
subjects = []
if form.subject_de.data:
subjects.append('de')
if form.subject_en.data:
subjects.append('en')
if form.subject_ru.data:
subjects.append('ru')
if form.subject_fr.data:
subjects.append('fr')
if form.subject_es.data:
subjects.append('es')
enrollment.subjects = json.dumps(subjects)
if enrollment.audit.available_seats() <= 1:
flash(u"Sie können sich für diese Prüfung nicht mehr anmelden, da das Maximum der Teilnehmeranzahl erreicht ist. Bitte wählen Sie einen anderen Termin.")
enrollment = None
else:
db_session.add(enrollment)
db_session.commit()
return redirect(url_for('profile'))
return render_template("enroll.html", **locals())
def enrollment():
if not session.get('username'):
return redirect(url_for('login'))
courseID = request.form.get('courseID')
courseTitle = request.form.get('title')
user_id = session.get('user_id')
if courseID:
if Enrollment.objects(user_id=user_id, courseID=courseID):
flash(
f"Oops! You are already registered in this course {courseTitle}!",
"danger")
return redirect(url_for("courses"))
else:
Enrollment(user_id=user_id, courseID=courseID).save()
flash(f"You are enrolled in {courseTitle}!", "success")
classes = list(
User.objects.aggregate(*[{
'$lookup': {
'from': 'enrollment',
'localField': 'user_id',
'foreignField': 'user_id',
'as': 'r1'
}
}, {
'$unwind': {
'path': '$r1',
'includeArrayIndex': 'r1_id',
'preserveNullAndEmptyArrays': False
}
}, {
'$lookup': {
'from': 'course',
'localField': 'r1.courseID',
'foreignField': 'courseID',
'as': 'r2'
}
}, {
'$unwind': {
'path': '$r2',
'preserveNullAndEmptyArrays': False
}
}, {
'$match': {
'user_id': user_id
}
}, {
'$sort': {
'courseID': 1
}
}]))
return render_template("enrollment.html",
enrollment=True,
title="Enrollment",
classes=classes)
def enrollUser(user_id, course_id):
enroll1 = Enrollment(user_id=user_id,
course_id=course_id,
term="Spring 2020",
grade="IP")
db.session.add(enroll1)
try:
db.session.commit()
return "Success"
except Exception as e:
print(e)
return "Failed"
def enroll(eventid):
current_seats = len(
db.session.query(Enrollment).filter(
Enrollment.event_id == eventid).all())
print(get_jwt_identity())
if current_seats < db.session.query(Event).filter(
Event.id == eventid).first().seats:
enroll = Enrollment(event_id=eventid)
db.session.add(enroll)
return {"status": "success"}
else:
return {"status": "error"}
def enroll_course(courseID):
course = Course.query.get_or_404(courseID)
if not (course in [enrolled.course for enrolled in g.user.enrollments]):
enroll = Enrollment(user_id=g.user.id, course_id=courseID)
db.session.add(enroll)
db.session.commit()
add_assignments(enroll.id)
flash(f"Successfully enrolled in { course.title }")
else:
flash(f"Failed to enroll in { course.title }")
return redirect("/")
def student_dashboard():
enrollment_obj = Enrollment.query.filter_by(user_id=current_user.user_id).all()
classes = [Classes.query.get(enroll.get_class_id())
for enroll in enrollment_obj]
if request.method == 'POST':
enrollment_code = request.form['enrollment_code']
# Add a new enrollment to the Enrollment table
class_id = Classes.query.filter_by(
enrollment_code=enrollment_code).first().get_id()
new_enrollment = Enrollment(
class_id=class_id,
user_id=current_user.user_id,
dropped=False
)
db.session.add(new_enrollment)
db.session.commit()
flash('Registration Successful!', category='success')
return redirect(url_for('auth.student_class_page', id=class_id))
return render_template('student_dashboard.html', title='Student Dashboard', classes=classes)
def populatePreviousSemesters(email):
user = User.query.filter_by(email=email).first()
courses = db.session.query(Course.id).all()
print(courses)
random.shuffle(courses)
print(courses)
grades = ["A", "A-", "B+", "B", "B-", "C+", "C", "C-"]
term = "Spring 2019"
x = 0
for course in courses:
enroll = Enrollment(user_id=user.id,
course_id=course[0],
term=term,
grade=random.choice(grades))
db.session.add(enroll)
x += 1
if x is 4:
term = "Fall 2019"
elif x is 8:
break
db.session.commit()
def enroll():
data = api_message()
if User.query.filter_by(id=data.user_id).first() and \
Course.query.filter_by(id=data.course_id).first():
# Add enrollment entry to table
new_enroll = Enrollment(data.user_id, data.course_id)
db.session.add(new_enroll)
db.session.commit()
data = {
'message': "Successfully enrolled the course."
}
resp = jsonify(data)
resp.status_code = 201
return resp
else:
return not_found()
def enrollments_processing(event_id):
user_id = session.get('user_id', None)
today = datetime.datetime.today()
date = today.strftime("%Y-%m-%d-%H:%M")
if user_id == None:
return {'error': 'User authorization failed'}, 400
enrollments = db.session.query(Enrollment)
event = db.session.query(Event).get(event_id)
user = db.session.query(Participant).get(user_id)
enrollment_with_user = enrollments.filter_by(
event=event, participant=user).one_or_none()
if request.method == 'POST':
enrollments = enrollments.filter_by(event=event).all()
if enrollment_with_user:
return {"error": "The user is already registered"}, 400
if len(enrollments) < event.seats:
new_enrollment_schema = EnrollmentSchema()
new_enrollment = Enrollment(datetime=date,
event=event,
participant=user)
db.session.add(new_enrollment)
db.session.commit()
try:
db.session.commit()
except:
return jsonify(), 500
return jsonify(new_enrollment_schema.dump(new_enrollment)), 201, \
{'Location': f'/enrollments/{new_enrollment.id}'}
else:
return {"error": "Not enough seats"}, 400
elif request.method == 'DELETE':
if enrollment_with_user:
db.session.delete(enrollment_with_user)
try:
db.session.commit()
except:
return jsonify(), 500
return 204
else:
return jsonify(), 204
def create_enrollment_with_tuple(tuple):
return Enrollment(tuple[0], tuple[1])
def seed_data():
ron_key = Student(student_id=423491377, first_name ="Ron", last_name = "Weasley").put()
harry_key = Student (student_id=423491782, first_name ="Harry", last_name = "Potter").put()
hermione_key = Student(student_id=423491249, first_name="Hermione", last_name="Granger").put()
malfoy_key = Student(student_id=42391043, first_name="Draco", last_name="Malfoy").put()
crabbe_key = Student(student_id=42391122, first_name="Vincent", last_name="Crabbe").put()
goyle_key = Student(student_id=42391063, first_name="Gregory", last_name="Goyle").put()
ron_wand=Wand(length = 14.0, material = "willow", core="unicorn", owner=ron_key)
harry_wand=Wand(length = 11.0, material = "holly", core="phoenix feather", owner=harry_key)
hermione_wand = Wand(length=10.75, material="vinewood", core="dragon heartstring", owner=hermione_key)
ron_wand.put()
harry_wand.put()
hermione_wand.put()
gryff = House(name="Gryffindor", mascot="Lion", students=[ron_key, harry_key, hermione_key])
snakes = House(name="Slytherin", mascot="Snake", students=[malfoy_key, crabbe_key, goyle_key])
hufflepuff = House(name="Hufflepuff", mascot="Badger", students=[])
ravenclaw = House(name="Ravenclaw", mascot="Eagle", students=[])
gryff.put()
snakes.put()
hufflepuff.put()
ravenclaw.put()
potions = Course(name="Potions", location="dungeon")
dada = Course(name="Defense Against the Dark Arts", location="3C")
transfiguration = Course(name="Transfiguration", location="Class 34")
potions_key = potions.put()
dada_key = dada.put()
transfiguration_key = transfiguration.put()
#dada
Enrollment(student=ron_key, course=dada_key).put()
Enrollment(student=harry_key, course=dada_key).put()
Enrollment(student=hermione_key, course=dada_key).put()
#potions
Enrollment(student=hermione_key, course=potions_key).put()
Enrollment(student=ron_key, course=potions_key).put()
Enrollment(student=malfoy_key, course=potions_key).put()
Enrollment(student=crabbe_key, course=potions_key).put()
Enrollment(student=goyle_key, course=potions_key).put()
#tranfirguration
Enrollment(student=harry_key, course=transfiguration_key).put()
Enrollment(student=hermione_key, course=transfiguration_key).put()
Enrollment(student=crabbe_key, course=transfiguration_key).put()
Enrollment(student=goyle_key, course=transfiguration_key).put()
snape = Teacher(name="Severus Snape", years_experience=5, classes_taught=[potions_key])
snape.put()
moody = Teacher(name="Alastor Moody", years_experience=1, classes_taught=[dada_key])
moody.put()
mcgonagall = Teacher(name="Minerva McGonagall", years_experience=12, classes_taught=[transfiguration_key])
mcgonagall.put()
def create(nanodegree_key, status):
""" Create a new enrollment """
enrollment = Enrollment(nanodegree_key=nanodegree_key, status=status)
return enrollment.save()
