def post_student(payload):
data = request.get_json()
name = data['student_name']
classID = data['class_id']
new_student = Students(student_name=name, class_id=classID)
new_student.insert()
return jsonify({'success': True, 'students': new_student.format()})
def createStudent(student_id, student_firstname, student_lastname):
if Students.query.get(student_id) is None:
student = Students(id=student_id)
student.firstname = student_firstname
student.lastname = student_lastname
else:
student = Students.query.get(student_id)
return student
def student_create(student_number, pw):
student = Students.query.filter(
Students.student_number == student_number).first()
if student == None:
student = Students()
student.student_number = student_number
student.name = auth_sejong(student_number, pw)['name']
db.session.add(student)
db.session.commit()
return student
def add():
if request.method == "POST":
info = request.get_json() or {}
item = Students(first_name=info["first_name"],
last_name=info["last_name"],
age=info["age"],
course_id=info["course_id"])
if info["first_name"] == "":
return make_response(
jsonify({
"error": 400,
"message": "Bad Request. No first_name"
}))
elif info["last_name"] == "":
return make_response(
jsonify({
"error": 400,
"message": "Bad Request. No last_name"
}))
elif info["age"] == "":
return make_response(
jsonify({
"error": 400,
"message": "Bad Request. No age"
}))
elif info["course_id"] == "":
return make_response(
jsonify({
"error": 400,
"message": "Bad Request. No course_id"
}))
else:
db.session.add(item)
db.session.commit()
return jsonify({"response": "ok"})
def get(self, *args, **kwargs):
name = "ss"
age = 13
stu = Students(name, age)
stu.delete()
# stu.save()
# findOne = stu.find_one(name,age)
# if findOne==None:
# print "没有"
# else:
# for i in stu.find_one(name,age):
# print i
# info=stu.find_all()
# for i in info:
# print i
self.write('ok')
def get(self, *args, **kwargs):
#去数据库中提取数据
# stu = Students("fghjkiuhbn",567)
# stu.save()
# self.write("ok")
stus = Students.all()
self.render('students.html', stus=stus)
def get(self, *args, **kwargs):
# 查找数据库提取数据
# sql = 'select name, age from students;'
# sql = 'insert into students (name, age) values ("tom", 30);'
# stus = self.application.db.get_all_obj(sql, 'students', 'name', 'age')
# print(stus, '---------')
# self.application.ORM.insert(sql)
# s = Students('LAJOS', 20)
# s.save()
stus = Students.all()
print(stus, '+++++++++++++=')
self.write('lajos is a handsome man!')
def addstudent2(request):
#获取指定的班级
grade = Grades.objects.get(pk=1)
#创建学生对象
stu = Students.createStudent('zhangxueyou', True, 53, 'i am zhangxueyou',
grade, '2019-01-25', '2019-01-25')
stu.save()
# 去模型中取数据 应该包含新添加的'liudehua'
studentsList = Students.objects.all()
# 将数据传递给模板，模板再渲染页面，并将渲染好的页面返回给浏览器
return render(request, 'myApp/students.html', {"students": studentsList})
def new():
if request.method == 'POST':
if not request.form['name'] or not request.form[
'city'] or not request.form['addr']:
flash('Please enter all the fields', 'error')
else:
student = Students(request.form['name'], request.form['city'],
request.form['addr'], request.form['pin'])
db.session.add(student)
db.session.commit()
flash('Record was successfully added')
return redirect(url_for('show_all'))
return render_template('new.html')
def add_one_student():
if current_user.role != 'admin':
flash('You are not authorized to perform this action', 'danger')
return redirect(url_for('dashboard'))
dashboard_data = get_dashboard()
form = StudentRegistrationForm()
if form.validate_on_submit():
student = Students(name=form.name.data,
matricNo=form.matricNo.data,
email=form.email.data)
db.session.add(student)
db.session.commit()
flash('Student has been created', 'success')
return redirect(url_for('manage_student'))
return render_template('add_one_student.html',
form=form,
dashboard_data=dashboard_data)
def add_student():
if current_user.role != 'admin':
flash('You are not authorized to perform this action', 'danger')
return redirect(url_for('dashboard'))
dashboard_data = get_dashboard()
form = AdminAddFileForm()
if form.validate_on_submit():
added = False
file = form.fileInput.data
file_string = str(file.read(), 'utf-8')
student_dict = csv.DictReader(file_string.splitlines(),
skipinitialspace=True)
for student_details in student_dict:
try:
student = find_student(student_details['matricNo'])
if student is None: # Add the student if it is not inside the database
added = True
student = Students(name=student_details['name'],
matricNo=student_details['matricNo'],
email=student_details['email'])
db.session.add(student)
except:
flash('CSV contains incorrect fields', 'danger')
return redirect(url_for('manage_student'))
if added:
db.session.commit()
flash('Student details have been added', 'success')
else:
flash('No student details was added', 'info')
return redirect(url_for('manage_student'))
return render_template('admin_add_file.html',
form=form,
dashboard_data=dashboard_data,
legend='Add Student')
def insertionProcess():
id = request.form['id']
name = request.form['name']
file = request.files['pic']
imageName = file.filename
# converting the image file into binary data
imageData = file.read()
# converting the binary data to image
imageEncodings = fr.load_image_file(BytesIO(imageData))
imageEncodings = fr.face_encodings(imageEncodings)[0]
# np array to pickled binary
imageEncodingsBin = imageEncodings.dumps()
row = Students(id=id,
name=name,
imageName=imageName,
imageData=imageData,
imageEncodings=imageEncodingsBin)
db.session.add(row)
db.session.commit()
return redirect(url_for('viewAll'))