def on_get(self, req, resp): data = dict() data['rating_criteria'] = dict() if req.get_json('criterion_id') == '__all__': criteria = StudentCharacterRatingCriteria.query.all() row_ctr = 0 for criterion in criteria: data['rating_criteria'][row_ctr] = dict() for scope in req.scope: try: data['rating_criteria'][row_ctr][scope] = getattr(criterion, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the rating criteria.') row_ctr += 1 else: criterion = db.Session.query(StudentCharacterRatingCriteria).filter_by( criterion_id=req.get_json('criterion_id') ).one() data['rating_criteria'] = dict() for scope in req.scope: try: data['rating_criteria'][scope] = getattr(criterion, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the criteria.') response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code?', 'Successful rating criteria retrieval', 'Rating criteria successfully gathered.', data )
def on_get(self, req, resp): monthly_attendances = db.Session.query(StudentMonthlyAttendance).filter_by( student_id=req.get_json('student_id') ).order_by(StudentMonthlyAttendance.school_year.desc(), StudentMonthlyAttendance.quarter.desc(), StudentMonthlyAttendance.month.desc()).all() row_ctr = 0 data = dict() data['student'] = dict() for monthly_attendance in monthly_attendances: data['student'][row_ctr] = dict() for scope in req.scope: try: data['student'][row_ctr][scope] = getattr(monthly_attendance, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the student monthly attendance.') row_ctr += 1 response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code?', 'Successful student attendance retrieval', 'Attendance successfully gathered.', data )
def on_get(self, req, resp): data = dict() data['month_days'] = dict() if req.get_json('school_year') == '__all__': years = StudentMonthlyRequiredDays.query.order_by(StudentMonthlyRequiredDays.school_year.desc()).all() row_ctr = 0 for year in years: data['month_days'][row_ctr] = dict() for scope in req.scope: try: data['month_days'][row_ctr][scope] = getattr(year, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the rating criteria.') row_ctr += 1 else: year = db.Session.query(StudentMonthlyRequiredDays).filter_by( school_year=req.get_json('school_year') ).one() data['month_days'] = dict() for scope in req.scope: try: data['month_days'][scope] = getattr(year, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the criteria.') response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code?', 'Successful monthly required days retrieval', 'Monthly required days successfully gathered.', data )
def on_get(self, req, resp): data = dict() year_advisors = db.Session.query(BatchAdvisor).filter_by( advisor=req.get_json('teacher_id')).all().order_by( BatchAdvisor.batch_year.desc(), BatchAdvisor.school_year.desc()) data = dict() data['batch'] = dict() ctr = 0 for year_advisor in year_advisors: data['batch'][ctr] = dict() for scope in req.scope: try: data['batch'][ctr][scope] = getattr(year_advisor, scope) except AttributeError: raise APIUnprocessableEntityError( 'Invalid scope \'{0}\''.format(scope), 'Scope is not part of the student.') response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code?', 'Successful batch advisor data retrieval', 'Batch advisor data successfully gathered.', data)
def on_get(self, req, resp): data = dict() data['teacher'] = dict() if req.get_json('teacher_id') == '__all__': teachers = User.query.filter_by(user_type='teacher').all().order_by(User.last_name.asc(), User.first_name.asc(), User.middle_name.asc(), User.id_number.asc()) row_ctr = 0 for teacher in teachers: data['teacher'][row_ctr] = dict() for scope in req.scope: try: data['teacher'][row_ctr][scope] = getattr(teacher, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the teacher.') row_ctr += 1 else: teacher = db.Session.query(Teacher).filter_by(teacher_id=req.get_json('teacher_id')).one() data['teacher'] = dict() for scope in req.scope: try: data['teacher'][scope] = getattr(teacher, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the teacher.') response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code?', 'Successful teacher data retrieval', 'Teacher data successfully gathered.', data )
def on_get(self, req, resp): data = dict() data['teacher_position'] = dict() if req.get_json('teacher_position_id') == '__all__': positions = TeacherPositionList.query.all() position_ctr = 0 for position in positions: data['teacher_position'][position_ctr] = dict() for scope in req.scope: try: data['teacher_position'][position_ctr][scope] = getattr(position, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the user.') position_ctr += 1 else: position = db.Session.query(TeacherPositionList).filter_by(position_id=req.get_json('id')).one() data['teacher_position'] = dict() for scope in req.scope: try: data['teacher_position'][scope] = getattr(position, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the user.') response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code?', 'Successful teacher position retrieval', 'Teacher position successfully gathered.', data )
def on_post(self, req, resp): id_number = req.get_json('id_number') user_type = req.get_json('user_type') username = req.get_json('username') password = req.get_json('password') first_name = req.get_json('first_name') middle_name = req.get_json('middle_name') last_name = req.get_json('last_name') age = req.get_json('age') birth_date = req.get_json('birth_date') # TODO: Add profile picture upload support. new_user = User(id_number, user_type, username, password, first_name, middle_name, last_name, age, birth_date) db.Session.add(new_user) db.Session.commit() if user_type == 'admin': db.Session.add(Admin(new_user.user_id)) elif user_type == 'teacher': db.Session.add(Teacher(new_user.user_id)) else: # Oh, it's a student then. db.Session.add(Student(new_user.user_id, 1)) # Assume that it is a 7th grader. db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'User created successfully', 'New user {0} has been created.'.format(username))
def on_get(self, req, resp): data = dict() data['student'] = dict() if req.get_json('student_id') == '__all__': students = Student.query.all() row_ctr = 0 for student in students: data['student'][row_ctr] = dict() for scope in req.scope: try: data['student'][row_ctr][scope] = getattr(student, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the student.') row_ctr += 1 else: student = db.Session.query(Student).filter_by(student_id=req.get_json('student_id')).one() data['student'] = dict() for scope in req.scope: try: data['student'][scope] = getattr(student, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the student.') response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code?', 'Successful student data retrieval', 'Student data successfully gathered.', data )
def on_get(self, req, resp): grades = db.Session.query(StudentSubjectPendingGrade).filter_by( student_id=req.get_json('student_id'), subject_id=req.get_json('subject_id'), school_year=req.get_json('school_year') ).order_by(StudentSubjectPendingGrade.quarter.desc()) quarter_ctr = 0 data = dict() data['student'] = dict() for grade in grades: data['student'][quarter_ctr] = dict() for scope in req.scope: try: data['student'][quarter_ctr][scope] = getattr(grade, scope) except AttributeError: raise APIUnprocessableEntityError('Invalid scope \'{0}\''.format(scope), 'Scope is not part of the user.') quarter_ctr += 1 response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code?', 'Successful student subject grades retrieval', 'Subject grades successfully gathered.', data )
def on_delete(self, req, resp): settings = db.Session.query(VariableSettings).one() db.Session.delete(settings) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Settings deleted successfully', 'Settings has been deleted.')
def on_post(self, req, resp): name = req.get_json('position_name') db.Session.add(TeacherPositionList(name)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Teacher position created successfully', 'New position {0} has been created.'.format(name) )
def on_delete(self, req, resp): batch = db.Session.query(Batch).filter_by( batch_year=req.get_json('batch_year')).one() db.Session.delete(batch) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Batch year deleted successfully', 'Batch year has been deleted.')
def on_delete(self, req, resp): position = db.Session.query(TeacherPositionList)\ .filter_by(position_id=req.get_json('teacher_position_id')).one() db.Session.delete(position) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Position deleted successfully', 'Position {0} has been deleted.'.format(position.position_name) )
def on_post(self, req, resp): student_id = req.get_json('student_id') batch_year = req.get_json('batch_year') db.Session.add(StudentBatch(student_id, batch_year)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Added new student batch year successfully', 'New batch year for {0} has been added.'.format(student_id) )
def on_post(self, req, resp): criterion_id = req.get_json('criterion_id') criterion_description = req.get_json('criterion_description') db.Session.add(StudentCharacterRatingCriteria(criterion_id, criterion_description)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Added new criterion successfully', 'New criterion for {0} has been added.'.format(criterion_id) )
def on_delete(self, req, resp): user = db.Session.query(User).filter_by( user_id=req.get_json('user_id')).one() db.Session.delete(user) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'User deleted successfully', 'User {0} has been deleted.'.format(user.username))
def on_post(self, req, resp): teacher_id = req.get_json('teacher_id') position_id = req.get_json('teacher_position_id') school_year = req.get_json('school_year') db.Session.add(TeacherPosition(teacher_id, position_id, school_year)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Teacher position created successfully', 'New position {0} has been created.'.format(position_id) )
def on_delete(self, req, resp): student_batch_year = db.Session.query(StudentStatus).filter_by(student_id=req.get_json('student_id'), batch_year=req.get_json('batch_year') ).one() db.Session.delete(student_batch_year) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Student batch year deleted successfully', 'Batch year of student {0} has been deleted.'.format(req.get_json('student_id')) )
def on_delete(self, req, resp): section = db.Session.query(Section).filter_by( section_id=req.get_json('section_id')).one() db.Session.delete(section) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Section successfully', 'Section {0} has been deleted.'.format(req.get_json('section_id')))
def on_post(self, req, resp): student_id = req.get_json('student_id') section_id = req.get_json('section_id') school_year = req.get_json('school_year') db.Session.add(StudentSection(student_id, section_id, school_year)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Added new student section successfully', 'New section for {0} has been added.'.format(student_id) )
def on_delete(self, req, resp): student_month_days = db.Session.query(StudentStatus).filter_by(month_id=req.get_json('month'), school_year=req.get_json('school_year') ).one() db.Session.delete(student_month_days) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Month deleted successfully', 'Month {0} has been deleted.'.format(student_month_days.month) )
def on_put(self, req, resp): student_month_days = db.Session.query(StudentStatus).filter_by(month=req.get_json('month'), school_year=req.get_json('school_year') ).one() student_month_days.required_days = req.get_json('required_days').strip() db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Required days for a month updated successfully', 'Required days of month {0} has been updated.'.format(student_month_days.month) )
def on_post(self, req, resp): month = req.get_json('month') school_year = req.get_json('school_year') days_required = req.get_json('days_required') db.Session.add(StudentMonthlyRequiredDays(month, school_year, days_required)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Added new monthly required days successfully', 'New required days has been added.' )
def on_post(self, req, resp): batch_year = req.get_json('batch_year') school_year = req.get_json('school_year') advisor_id = req.get_json('teacher_id') db.Session.add(BatchAdvisor(batch_year, school_year, advisor_id)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Added new batch advisor successfully', 'New batch advisor has been added.')
def on_delete(self, req, resp): subject = db.Session.query(StudentSubject).filter_by(student_id=req.get_json('student_id'), subject_id=req.get_json('subject_id'), school_year=req.get_json('school_year') ).one() db.Session.delete(subject) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Student subject deleted successfully', 'Subject of student {0} has been deleted.'.format(req.get_json('student_id')) )
def on_post(self, req, resp): student_id = req.get_json('student_id') gwa = req.get_json('gwa') quarter = req.get_json('quarter') school_year = req.get_json('school_year') db.Session.add(StudentGWA(student_id, gwa, quarter, school_year)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Added new student GWA successfully', 'New GWA for {0} has been added.'.format(student_id) )
def on_delete(self, req, resp): criterion = db.Session.query(StudentCharacterRatingCriteria).filter_by( criterion_id=req.get_json('criterion_id') ).one() db.Session.delete(criterion) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Criterion deleted successfully', 'Criterion has been deleted.'.format(req.get_json('student_id')) )
def on_put(self, req, resp): grade = db.Session.query(StudentSubjectPendingGrade).filter_by(student_id=req.get_json('student_id'), subject_id=req.get_json('subject_id'), school_year=req.get_json('school_year'), quarter=req.get_json('quarter') ).one() grade.grade = req.get_json('grade').strip() db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Student status updated successfully', 'Status of student {0} has been updated.'.format(grade.student_id) )
def on_post(self, req, resp): student_id = req.get_json('student_id') subject_id = req.get_json('subject_id') school_year = req.get_json('school_year') quarter = req.get_json('quarter') grade = req.get_json('grade') db.Session.add(StudentSubjectGrade(student_id, subject_id, school_year, quarter, grade)) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_201, 'Ignacio! Where is the damn internal code again?', 'Added new student subject grade successfully', 'New grade for {0} has been added.'.format(student_id) )
def on_delete(self, req, resp): student_status = db.Session.query(StudentStatus).filter_by(student_id=req.get_json('student_id'), quarter=req.get_json('quarter'), year_level=req.get_json('year_level'), school_year=req.get_json('school_year') ).one() db.Session.delete(student_status) db.Session.commit() response.set_successful_response( resp, falcon.HTTP_200, 'Ignacio! Where is the damn internal code again?', 'Student status deleted successfully', 'Status of student {0} has been deleted.'.format(req.get_json('student_id')) )