def __init__(self, controller):
self.__controller = controller
self.store = Store()
self.student = Student(model=self, controller=self.__controller)
self.activity = Activity(controller=self.__controller,
store=self.store)
def updateCGPAForAllStudents():
for student in Student.select():
cgpa = GPACalculator.calculateGpaForStudent(student)
update_student = Student()
update_student.roll = student.roll
update_student.cgpa = cgpa
studentDAO = StudentDAO()
if (cgpa is not None):
studentDAO.createOrUpdateModel(update_student)
def create_new_user(self, username, password, query):
try:
new_user = Users()
new_user.user_name = username
new_user.hashed_password = bcrypt.hashpw(password.encode('utf-8'),
bcrypt.gensalt())
new_user.school_id = query.school_id
new_user.first_name = query.first_name
new_user.last_name = query.last_name
new_user.user_type = query.user_type
new_user.email = query.email
new_user.profession = query.profession
new_user.save()
if query.user_type.lower() == "teacher":
new_teacher = Teacher()
new_teacher.user_id = new_user.user_id
new_teacher.has_system_access = True
new_teacher.save()
response.body = json.dumps({
'success':
'Successfully created teacher ' + new_user.user_name +
' with id ' + str(new_user.user_id),
'id':
new_user.user_id
})
response.status = 200
elif query.user_type.lower() == "student":
new_student = Student()
new_student.user_id = new_user.user_id
new_student.has_system_access = False
new_student.save()
response.body = json.dumps({
'success':
'Successfully created student ' + new_user.user_name +
' with id ' + str(new_user.user_id),
'id':
new_user.user_id
})
response.status = 200
else:
response.body = json.dumps({'error': 'Unknown user type'})
response.status = 500
except Exception as e:
response.body = json.dumps({'error': str(e)})
response.status = 500
return response
def add_student():
# часть функционала обрабатывает GET, а часть POST запросы, сделаем условие
form = StudentForm()
if form.validate_on_submit():
name = form.name.data
email = form.email.data
phone = form.phone.data
try:
student = Student(name=name, email=email, phone=phone)
db.session.add(student)
db.session.commit()
except:
print('Что -то пошло не так')
return redirect(url_for('students.index')) # возврат на пустую форму
#form = StudentForm() # иначе вернем форму
return render_template('student/add_student.html', form=form)
def dictionaryToModel(self, dictionary):
student = Student()
for key in dictionary:
setattr(student, key, dictionary[key])
return student
x = elem.text.split(':')
# print(x)
if ('SGPA' in x[0]):
# print('yes',x[1].strip())
try:
gpa_value = float(x[1].strip())
except Exception:
print("Exception occurred in extracting GPA")
traceback.print_exc()
else:
gpa_flag = True
if (gpa_flag):
list_td = soup.find_all("td",
attrs={
"align": "center",
"class": "underlineresult"
})
for elem in list_td:
text = elem.text.strip()
if (re.search("^0012105010", text)):
class_roll = text
if (gpa_flag and class_roll):
print(exam_roll, class_roll, gpa_value)
student = Student()
student.roll = class_roll
student.gpa5 = gpa_value
studentDAO = StudentDAO()
studentDAO.createOrUpdateModel(student)
except Exception:
print("Exception occurred")
traceback.print_exc()
