def for_student(student_id, date_from = None, date_to = None): """ Retrives lessons for student filtered by date Keyword arguments: student_id - int ID of a student date_from - date in iso format string (!) or None (default: None) date_to - date in iso format string (!) or None (default: None) """ # Check if student exists try: Student.get_by_id(student_id) except Student.DoesNotExist: raise NoSuchDBRecordException("Student with id {} does not exist in database".format(student_id)) query = (Lesson .select(Lesson.name, Lesson.start, Lesson.end, Lesson.date, Room.name, Room.address, Group.name) .join(Group) .join(StudentToGroup) .join(Student) .switch(Lesson) .join(Room) .switch(Lesson) .where(Student.id == student_id) .order_by(Lesson.date, Lesson.start) ) if date_from != None: query = query.where(Lesson.date > date.fromisoformat(date_from)) if date_to != None: query = query.where(Lesson.date < date.fromisoformat(date_to)) return query_to_json_mapper(query)
def update(): #values = url.split('?')[-1] pk = int(request.args.get('id')) print pk student = Student( name=request.args.get('name'), gender=request.args.get('gender'), teacher=request.args.get('teacher'), grade=int(request.args.get('grade')), ) student.update().where(Student.id == pk) return render_template('index.html')
def create_student(): body = json.loads(request.data) email = body["email"] club_ids = body["club_ids"] student = Student( email=email ) existing_student = Student.query.filter_by(email=email).first() if existing_student is not None: db.session.delete(existing_student) club_list = [] for id in club_ids: club = Club.query.filter_by(id=id).first() if club is not None: student.clubs.append(club) club_list.append(club.name) else: return json.dumps({"Success": False, "data": "Club does not exist!"}), 201 db.session.add(student) db.session.commit() EMAIL_ADDRESS = '*****@*****.**' EMAIL_PASSWORD = '******' smtplibObj = smtplib.SMTP('smtp.gmail.com', 587) smtplibObj.ehlo() smtplibObj.starttls() smtplibObj.login(EMAIL_ADDRESS, EMAIL_PASSWORD) club_message = '' for club in club_list: club_message += club + '\n ' subject = 'Clubby confirmation email' body = ' You have successfully registered in our Clubby notification system! Here is a list of ' + ( 'project teams you subscribed: \n\n ') + club_message + '\n You will receive email notification when ' + ( 'these teams update their application info.') msg = f'Subject: {subject}\n\n{body}' try: smtplibObj.sendmail(EMAIL_ADDRESS, email, msg) except: print("Internal error") return json.dumps({"Success": False, "data": "Email is not valid!"}), 400 return json.dumps({"Success": True, "data": student.serialize()}), 201
def add(): try: student = Student( name=request.args.get('name'), gender=request.args.get('gender'), teacher=request.args.get('teacher'), grade=int(request.args.get('grade')), ) student.save() flash("%s 已增加" % student.name) except Exception as e: flash(str(e)) return redirect(url_for('index'))
def add_student_to_user(user_id): body = json.loads(request.data) if body.get("description") is None: return failure_response( missing_parameter_response(body, ["description"])) user = User.query.filter_by(id=user_id).first() if user is None: return failure_response("Given user id is not associated with a user!") desc = body.get("description") new_student = Student(user_id=user_id, description=desc) user.student.append(new_student) DB.session.add(new_student) DB.session.commit() return success_response(new_student.serialize(), 201)
def create(data, fail_silently=False): students_affected = ( Student.select(Student.id) .join(StudentToGroup) .join(Group) .where(Group.id == data['group']) ) count_conflict_lessons = ( Lesson.select() .join(Room).switch(Lesson) .join(Lecturer).switch(Lesson) .join(Group).join(StudentToGroup).join(Student).switch(Lesson) .where( (Lesson.date == data['date']) & ( (data['start'] >= Lesson.start) & (data['start'] <= Lesson.end) | (data['end'] >= Lesson.start) & ( data['end'] <= Lesson.end) ) & ( (Lesson.room == data['room']) | (Lesson.lecturer == data['lecturer']) | (Lesson.group == data['group']) ) ) .group_by(Lesson) .count() ) if (count_conflict_lessons == 0): l = Lesson(**data) l.save() elif not fail_silently: raise Exception(f'Lessons conflicting: {count_conflict_lessons}')
def select(): try: pk = int(request.args.get('id')) student = Student.select().where(Student.id == pk) return render_template('update.html', student=student[0]) except Exception as e: flash(str(e))
def save(): email_adress = request.form["email_adress"] dob = request.form["dob"] course = request.form["course"] names = request.form["names"] gender = request.form["gender"] country = request.form["country"] try: Student.create(email_adress=email_adress, dob=dob, course=course, names=names, gender=gender, country=country) except peewee.IntegrityError: return "Record alreasdy exists" return render_template("form.html")
def run(args, db): from db import Student, TranscriptEntry as Entry id = args.student if id.startswith('0') or id.startswith('2'): s = Student.get(student_id=int(id)) else: s = Student.get(username=id) print('%-20s %09d %s' % (s.name(), s.student_id, s.email())) for e in Entry.select().where(Entry.student == s.student_id).order_by(Entry.year, Entry.term): if e.mark is None: continue print('%4s %-4s %04d%02d %3d' % ( e.subject, e.code, e.year, e.term, e.mark))
def rm(): try: pk = int(request.args.get('id')) student = Student.get(id=pk) student.delete_instance() flash("%s 已删除" % student.name) except Exception as e: flash(str(e)) return redirect(url_for('index'))
def menu(): print "Welcome!" while 1: print "1. Add a student" print "2. Delete student data" print "3. Modify student details" print "4. List all students" print "5. Add a course" print "6. Delete course data" print "7. Modify course details" print "8. List all courses" print "9. Enroll student in course" print "10. Show enrollments of a student" print "11. Show enrollments of a course" print "12. Archive old enrollments" print "13. Exit" ch = raw_input("What would you like to do? ") if ch == "1": Student.new_student(students, branches) elif ch == "2": Student.delete_student(students, enrollments) elif ch == "3": Student.modify_student(students) elif ch == "4": Student.list_students(students, branches) elif ch == "5": Course.new_course(courses, branches) elif ch == "6": Course.delete_course(courses, enrollments) elif ch == "7": Course.modify_course(courses) elif ch == "8": Course.list_courses(courses, branches) elif ch == "9": Enrollment.new_enrollment(enrollments, students, courses) elif ch == "10": Enrollment.list_enrollments_stu(enrollments, archived_enrolls, students, courses) elif ch == "11": Enrollment.list_enrollments_cou(enrollments, archived_enrolls, students, courses) elif ch == "12": Enrollment.archive_enrollments(enrollments, archived_enrolls) elif ch == "13": print "\nBye!\n" break else: print "\nNot Valid Choice! Try again!\n" save()
def menu(): print "Welcome!" while 1: print "1. Add a student" print "2. Delete student data" print "3. Modify student details" print "4. List all students" print "5. Add a course" print "6. Delete course data" print "7. Modify course details" print "8. List all courses" print "9. Enroll student in course" print "10. Show enrollments of a student" print "11. Show enrollments of a course" print "12. Archive old enrollments" print "13. Exit" ch = raw_input("What would you like to do? ") if ch == "1": Student.new_student(students, branches) elif ch == "2": Student.delete_student(students, enrollments) elif ch == "3": Student.modify_student(students) elif ch == "4": Student.list_students(students, branches) elif ch == "5": Course.new_course(courses, branches) elif ch == "6": Course.delete_course(courses, enrollments) elif ch == "7": Course.modify_course(courses) elif ch == "8": Course.list_courses(courses, branches) elif ch == "9": Enrollment.new_enrollment(enrollments, students, courses) elif ch == "10": Enrollment.list_enrollments_stu(enrollments, archived_enrolls, students, courses) elif ch == "11": Enrollment.list_enrollments_cou(enrollments, archived_enrolls, students, courses) elif ch == "12": Enrollment.archive_enrollments(enrollments, archived_enrolls) elif ch == "13": print "\nBye!\n" break else: print "\nNot Valid Choice! Try again!\n" save()
def add(): info = raw_input('请输入学员信息(姓名,性别,年龄,所在地,qq号)各项信息之间用逗号分隔:') if ',' in info: columns = info.split(',') elif ',' in info: columns = info.split(',') db = get_db() if db: no = max(db.keys()) + 1 # 编号递增 else: no = 1 columns.insert(0, no) student = Student(*columns) db[no] = student save_db(db)
def update(no=None): if not no: try: no = int(raw_input("输入学员编号:")) except TypeError: print '编号类型错误' update() info = raw_input('请输入学员信息(姓名,性别,年龄,所在地,qq号)各项信息之间用逗号分隔:') if ',' in info: columns = info.split(',') elif ',' in info: columns = info.split(',') columns = map(str.strip, columns) db = get_db() columns.insert(0, no) student = Student(*columns) db[no] = student save_db(db)
def insert(): rooms = [{ 'name': '1', 'address': 'address1', 'id': 1 }, { 'name': '10', 'address': 'address1', 'id': 2 }, { 'name': '20', 'address': 'address1', 'id': 3 }, { 'name': '30', 'address': 'address1', 'id': 4 }, { 'name': '40', 'address': 'address1', 'id': 5 }, { 'name': '1', 'address': 'address2', 'id': 6 }, { 'name': '5', 'address': 'address2', 'id': 7 }, { 'name': '10', 'address': 'address2', 'id': 8 }, { 'name': '15', 'address': 'address2', 'id': 9 }, { 'name': '20', 'address': 'address2', 'id': 10 }] Room.insert_many(rooms).execute() lecturers = [{ 'name': 'Lecturer One' }, { 'name': 'Lecturer One' }, { 'name': 'Lecturer Two' }, { 'name': 'Lecturer Three' }, { 'name': 'Lecturer Four' }] Lecturer.insert_many(lecturers).execute() groups = [{ 'name': 'stream1', 'id': 1 }, { 'name': 'stream2', 'id': 2 }, { 'name': 'group1', 'parentGroupId': 1, 'id': 3 }, { 'name': 'group2', 'parentGroupId': 1, 'id': 4 }, { 'name': 'group3', 'parentGroupId': 2, 'id': 5 }, { 'name': 'group4', 'parentGroupId': 2, 'id': 6 }, { 'name': 'group5', 'id': 7 }] Group.insert_many(groups).execute() students = [{'id': i, 'name': 'student ' + str(i)} for i in range(1, 41)] Student.insert_many(students).execute() stg = [{'StudentID': i, 'GroupID': 1} for i in range(1, 21)] stg += [{'StudentID': i, 'GroupID': 2} for i in range(21, 41)] stg += [{'StudentID': i, 'GroupID': 3} for i in range(1, 11)] stg += [{'StudentID': i, 'GroupID': 4} for i in range(11, 21)] stg += [{'StudentID': i, 'GroupID': 5} for i in range(21, 31)] stg += [{'StudentID': i, 'GroupID': 6} for i in range(31, 41)] stg += [{'StudentID': i, 'GroupID': 7} for i in range(1, 41, 5)] StudentToGroup.insert_many(stg).execute() dates = [ date(2020, 2, 10), date(2020, 2, 11), date(2020, 2, 12), date(2020, 2, 13) ] times = [(time(9, 30), time(11, 5)), (time(11, 15), time(12, 50)), (time(13, 40), time(15, 15))] lessons = [] for d in dates: (s, e) = times[0] #print(e) lessons.append({ 'group': 1, 'room': 1, 'lecturer': 1, 'name': 'Lecture', 'start': s, 'end': e, 'date': d }) lessons.append({ 'group': 2, 'room': 2, 'lecturer': 2, 'name': 'Lecture', 'start': s, 'end': e, 'date': d }) (s, e) = times[1] lessons.append({ 'group': 3, 'room': 3, 'lecturer': 3, 'name': 'Practice', 'start': s, 'end': e, 'date': d }) lessons.append({ 'group': 4, 'room': 4, 'lecturer': 4, 'name': 'Practice', 'start': s, 'end': e, 'date': d }) lessons.append({ 'group': 5, 'room': 1, 'lecturer': 1, 'name': 'Practice', 'start': s, 'end': e, 'date': d }) lessons.append({ 'group': 6, 'room': 2, 'lecturer': 2, 'name': 'Practice', 'start': s, 'end': e, 'date': d }) (s, e) = times[2] lessons.append({ 'group': 7, 'room': 3, 'lecturer': 3, 'name': 'Elective', 'start': s, 'end': e, 'date': d }) print(lessons) Lesson.insert_many(lessons).execute()
def students(): return Student.select()
def home(): students = Student.select() return render_template("users_table.html", students=students)
def deleting_students(id): s = Student.get(Student.id == id) s.delete_instance() return redirect(url_for('home'))
def index(): students = Student.select() return render_template('index.html', students=students)
def lessons_students(student_id): return render_template('lessons/student.html', student=Student.get_by_id(student_id))