def student_delete(student_pk):
student = Student.get(pk=student_pk)
if request.method == 'GET':
return render_template('student_delete.html', student=student)
if request.method == 'POST':
student.delete()
return redirect(url_for('students'))
def student_delete(student_pk):
student = Student.get(pk=student_pk)
if request.method == 'GET':
return render_template('student_delete.html', student=student)
if request.method == 'POST':
student.delete()
return redirect(url_for('students'))
def get_current_user():
"""Returns an object of Student or Teacher class, whose credentials are currently saved in session."""
if session['logged_in']:
if session['type'] == 'S':
return Student.get(Student.username == session['username'])
elif session['type'] == 'T':
return Teacher.get(Teacher.username == session['username'])
def prijava1(email, lozinka):
student = Student.get(email_studenta=email)
if student:
student = student.to_dict()
if student["lozinka_studenta"] == lozinka:
return student
else:
return "Kriva lozinka"
else:
return "Korisnik ne postoji"
def student_update(student_pk):
student = Student.get(pk=student_pk)
if request.method == 'GET':
return render_template('student_update.html', student=student)
elif request.method == 'POST':
student.first_name = request.form['first_name']
student.last_name = request.form['last_name']
student.alias = request.form['alias']
student.grad_year = request.form['grad_year']
student.email = request.form['email']
student.save()
return redirect(url_for('student_view', student_pk=student_pk))
def student_update(student_pk):
student = Student.get(pk=student_pk)
if request.method == 'GET':
return render_template('student_update.html', student=student)
elif request.method == 'POST':
student.first_name = request.form['first_name']
student.last_name = request.form['last_name']
student.alias = request.form['alias']
student.grad_year = request.form['grad_year']
student.email = request.form['email']
student.save()
return redirect(url_for('student_view', student_pk=student_pk))
def add_grade_():
form = AddGradeForm()
if form.validate_on_submit():
try:
with db.transaction():
grade = Grade.create(
student=Student.get(Student.username == form.student_select.data),
subject=Subject.get(Subject.name == form.subject_select.data),
teacher=get_current_user(),
grade=form.grade.data
)
except DatabaseError:
flash('An error occurred while adding a grade')
else:
flash('Grade ' + str(grade.grade) + ' assigned to student ' + str(grade.student))
return redirect(url_for('groups', group=grade.student.username))
flash_errors(form)
students = Student.select()
subjects = Subject.select()
return render_template('add_grade.html', students=students, subjects=subjects, form=form)
def student_login_():
form = StudentLoginForm()
if form.validate_on_submit():
try:
student = Student.get(username=form.username.data)
# adequate salt is stored in the password itself
stored_password = student.password.encode('utf-8')
password_to_check = form.password.data.encode('utf-8')
password = hashpw(password_to_check, stored_password)
if password != stored_password:
raise WrongPassword('Wrong password')
except WrongPassword:
flash('Wrong password')
except Student.DoesNotExist:
flash('Wrong username or password')
else:
authorize_student(student)
return redirect(url_for('student_profile'))
flash_errors(form)
return render_template('student_login.html', form=form)
def student_view(student_pk):
student = Student.get(pk=student_pk)
return render_template("student_view.html", student=student)
print("绩点计算完毕")
if __name__ == "__main__":
# 连接数据库，建立数据表
try:
db.connect()
db.create_tables([
Student, ClassSchedule, Class, YearGrade, TermGrade, OneLessonGrade
])
except:
pass
# 查找学生，若不存在则创建账号
try:
student = Student.get(Student.studentnumber == "xxxxxxxx")
except Exception as e:
student = Student(studentnumber="xxxxxxxx",
password="******") # 用自己的教务系统账号密码
student.save()
spider = ZhengFangSpider(student,
baseUrl="http://202.195.144.168/jndx") # 实例化爬虫
spider.loginWithOutCode()
if student.name is None:
spider.getStudentBaseInfo()
spider.getStudentGrade()
spider.calculateOneTermAndOneYearGPA()
spider.getClassSchedule()
def student_view(student_pk):
student = Student.get(pk=student_pk)
return render_template("student_view.html", student=student)
def student_profile_foreign_(username):
student = Student.get(Student.username == username)
subjects = Subject.select()
grades = Grade.select().where(Grade.student == student)
return render_template('student_profile.html', student=student, subjects=subjects, grades=grades)
oneClass.save()
print "成功获取课表"
if __name__ == "__main__":
# 连接数据库，建立数据表
try:
db.connect()
db.create_tables([Student,Code, ClassSchedule,Class,YearGrade,TermGrade,OneLessonGrade])
except:
pass
# 查找学生，若不存在则创建账号
try:
student = Student.get(Student.stuNumber == "你的学号")
except Exception ,e:
student = Student(stuNumber="你的学号", password="******")#用自己的教务系统账号密码
student.save()
print e
# 实例化爬虫
login("你的学号","你的密码")
getStudentInfo()
getStudentGrade()
getClassSchedule()
