def delete(e):
try:
delCourse = request.get_json()
course_id = delCourse.get('delCourseID')
Course.deleteRecord(course_id)
return jsonify({'status': 'success'}), 200
except Exception as e:
return jsonify({'status': 'bad-request', 'error_message': e.__str__()}), 400
def get_student_course(e):
try:
student_id = request.args.get('student_id')
return jsonify({'status': 'success', 'course': Course.getStudentCourse(student_id)}), 200
except Exception as e:
return jsonify({'status': 'bad-request', 'error_message': e.__str__()}), 400
def get_all(e):
try:
records = Course.getAllRecord()
return jsonify({
'status': 'success',
'records': records,
}), 200
except Exception as e:
return jsonify({'status': 'bad-request', 'error_message': e.__str__()}), 400
def search_existent_course(e):
try:
searchCode = request.args.get('searchCode')
searchRecord = Course.searchCourseExistence(str(searchCode))
return jsonify({
'status': 'success',
'search_result': searchRecord,
}), 200
except Exception as e:
return jsonify({'status': 'bad-request', 'error_message': e.__str__()}), 400
def update_record(e):
try:
new_update = request.get_json()
course_id = new_update.get('course_id')
update_code = new_update.get('update_code')
update_name = new_update.get('update_name')
update_description = new_update.get('update_description')
updated_at = datetime.now(pytz.timezone('Asia/Ho_Chi_Minh')).strftime("%Y-%m-%d %H:%M:%S")
if new_update.get('semester_id') is None:
Course.updateRecord(course_id, str(update_code).strip(), str(update_name).strip(),
str(update_description).strip(), updated_at, '')
return jsonify({'status': 'success'}), 200
else:
Course.updateRecord(course_id, str(update_code).strip(), str(update_name).strip(),
str(update_description).strip(), updated_at, new_update.get('semester_id'))
return jsonify({'status': 'success'}), 200
except Exception as e:
return jsonify({'status': 'bad-request', 'error_message': e.__str__()}), 400
def create(e):
try:
new_lecture = request.get_json()
code = new_lecture.get('new_code')
name = new_lecture.get('new_name')
description = new_lecture.get('new_description')
semester_id = new_lecture.get('semester_id')
isCreated = Course.createRecord(str(code).strip().upper(), str(name).strip(), str(description).strip(),
int(semester_id))
if isCreated is True:
return jsonify({'status': 'success'}), 200
else:
return jsonify({'status': 'already-exist'}), 202
except Exception as e:
return jsonify({'status': 'bad-request', 'error_message': e.__str__()}), 400
def get_records(e):
try:
semester_id = request.args.get('semester_id')
page_index = request.args.get('page_index')
per_page = request.args.get('per_page')
sort_field = request.args.get('sort_field')
sort_order = request.args.get('sort_order')
record = Course.getRecord(semester_id, page_index, per_page, sort_field, sort_order)
return jsonify({
'status': 'success',
'records': record[0],
'page_number': record[1].page_number,
'page_size': record[1].page_size,
'num_pages': record[1].num_pages,
'total_results': record[1].total_results
}), 200
except Exception as e:
return jsonify({'status': 'bad-request', 'error_message': e.__str__()}), 400