def do_POST(self):
try:
if self.path.endswith('/student/add'):
ctype, pdict = cgi.parse_header(
self.headers.getheader('content-type'))
if ctype == 'multipart/form-data':
fields = cgi.parse_multipart(self.rfile, pdict)
student_name = fields.get("name")[0]
student_address = fields.get("address")[0]
student_city = fields.get("city")[0]
student_stream = fields.get("stream")[0]
student_gender = fields.get("gender")[0]
new_student = Student(name=student_name,
address=student_address,
city=student_city,
stream=student_stream,
gender=student_gender)
db.add_into_database(new_student)
self.add_redirect_headers()
if self.path.endswith("/edit"):
ctype, pdict = cgi.parse_header(
self.headers.getheader('content-type'))
if ctype == 'multipart/form-data':
fields = cgi.parse_multipart(self.rfile, pdict)
student_name = fields.get("name")[0]
student_address = fields.get("address")[0]
student_city = fields.get("city")[0]
student_stream = fields.get("stream")[0]
student_gender = fields.get("gender")[0]
print(student_name, student_address, student_city,
student_stream, student_gender)
new_student = Student(name=student_name,
address=student_address,
city=student_city,
stream=student_stream,
gender=student_gender)
student_name = self.path.split("/")[2]
db.updateStudentData(student_name, new_student)
self.add_redirect_headers()
if self.path.endswith("/delete"):
student_name = self.path.split("/")[2]
db.deleteStudent(student_name)
self.add_redirect_headers()
except Exception as e:
print e
def verify_user():
if request.method == "POST":
form = ResetPasswordSubmit()
if form.validate_on_submit():
user_name = form.user_name.data
pwd = form.password.data
confirm = form.confirm.data
app.logger.debug("Attempting to verify user to reset password: "******"reset_password_success"))
else:
flash("Passwords do not match.")
else:
form = ResetPasswordSubmit()
token = request.args.get("token")
verified_token = Student.verify_token(token)
if verified_token:
student = dbSession.query(Student).filter_by(user_name=verified_token).first()
if student:
form.user_name.data = student.user_name
else:
app.logger.warning("Token verification failed while resetting the password.")
return render_template("token-verification-error.html")
return render_template("reset-pwd.html", form=form)
def detect_faces_in_image(file_stream,name,ID):
# Load the uploaded image file
img = face_recognition.load_image_file(file_stream)
# Get face encodings for any faces in the uploaded image
face_encodings = face_recognition.face_encodings(img)[0]
face_encodings_list = face_encodings.tolist()
newStudent = Student(
name=name,
encoding= face_encodings_list,
id=ID)
ids = []
students = session.query(Student).all()
for student in students:
ids.append(student.id)
if int(ID) in ids:
return render_template('duplicate.html')
else:
session.add(newStudent)
session.commit()
#flash(' %s is Successfully Registered' % (newStudent.name))
return render_template('registered.html')
def endpoint_classroom(id):
if request.method == 'GET':
classroom = session.query(Classroom).filter(Classroom.id == id).first()
if classroom:
classroom_json = query_result_to_json(classroom)
return jsonify(classroom_json)
else:
return jsonify([])
elif request.method == 'POST':
if login_session.get('user_id'):
name = request.args.get('name')
desc = request.args.get('description')
if name and desc:
new_student = Student(name=name,
description=desc,
user_id=login_session.get('user_id'),
classroom_id=id)
session.add(new_student)
session.commit()
json_student = query_result_to_json(new_student)
return jsonify(json_student)
return jsonify([])
elif request.method == 'DELETE':
if login_session.get('user_id'):
classroom = session.query(Classroom)
classroom = classroom.filter(Classroom.id == id).first()
session.delete(classroom)
session.commit()
else:
return "Restricted Method"
def makeANewRecord(first_name, last_name, dob, amount_due):
addedstudent = Student(first_name=first_name,
last_name=last_name,
dob=dob,
amount_due=amount_due)
session.add(addedstudent)
session.commit()
return jsonify(Student=addedstudent.serialize)
def detect_faces_in_image(file_stream, name, ID):
# Load the uploaded image file
img = face_recognition.load_image_file(file_stream)
# Get face encodings for any faces in the uploaded image
face_encodings = face_recognition.face_encodings(img)[0]
face_encodings_list = face_encodings.tolist()
newStudent = Student(name=name, encoding=face_encodings_list, id=ID)
session.add(newStudent)
session.commit()
return "done"
def newStudent():
if request.method == 'POST':
newStudent = Student(first_name=request.form['name'],
last_name=request.form['last_name'],
dob=request.form['dob'],
amount_due=request.form['amount_due'])
session.add(newStudent)
session.commit()
return redirect(url_for('showStudent'))
else:
return render_template('newStudent.html')
def addStudent():
newStudentName = request.form.get("name")
newStudent = Student(name=newStudentName)
session.add(newStudent)
session.commit()
return jsonify({
'status': 'success',
'id': newStudent.id,
'name': newStudent.name
})
def addStudents():
if request.method == 'POST':
route = session.query(Route).filter(Route.route_number == request.form['route_number']).one()
new_student = Student(name = request.form['name'], roll_no = request.form['roll_no'], contact = request.form['contact'],
son_of = request.form['son_of'], branch = request.form['branch'], course = request.form['course'], year = request.form['year'],
college = request.form['college'], issue_date = request.form['issue_date'], end_date = request.form['end_date'], route = route)
session.add(new_student)
session.commit()
return redirect(url_for('showStudents'))
else:
return render_template('studentnew.html')
def newStudent():
if request.method == 'POST':
newStudent = Student(sb_id=request.form['sbid'],
name=request.form['name'],
email=request.form['email'],
cellphone=request.form['cellphone'])
session.add(newStudent)
session.commit()
flash('Student "%s" added' % newStudent.name)
return redirect(url_for('showStudents'))
else:
return render_template('newstudent.html',
username=login_session['username'])
def convert(self):
student = Student()
student.user_name = self.USER_NAME
student.first_name = self.FIRST_NAME
student.last_name = self.LAST_NAME
student.email = self.EMAIL
student.create_time = self.CREATE_TIME
semester = session.query(Semester).filter_by(id=self.SEMESTER_ID).first()
if semester == None:
print 'Semester Not found for:'
print self.USER_NAME
enrollment = Enrollment(student=student, semester=semester)
if enrollment == None:
print 'Enrollment Not populated for:'
print self.USER_NAME
return student, enrollment
def newTutorStudent(tutor_id):
if 'username' not in login_session:
return redirect('/login')
quer2 = session.query(Tutor).filter_by(id=tutor_id).one()
if login_session['user_id'] != quer2.user_id:
flash('Cant Add New Student To others Tutor ')
return redirect(url_for('showTutorStudent', tutor_id=tutor_id))
if request.method == 'POST':
quer = Student(name=request.form['name'],
gender=request.form['gender'],
tutor_id=tutor_id,
user_id=login_session['user_id'])
session.add(quer)
session.commit()
flash('New Student Added')
return redirect(url_for('showTutorStudent', tutor_id=tutor_id))
else:
return render_template('newStudent.html',
i=tutor_id,
log=login_session)
def classrooms(id):
if request.method == 'GET':
if login_session.get('user_id'):
classroom_result = session.query(Classroom)
classroom_result = classroom_result.filter(Classroom.id == id)
classroom_result = classroom_result.first()
classroom = query_result_to_json(classroom_result)
students_result = session.query(Student)
student_cid = Student.classroom_id
students_result = students_result.filter(student_cid == id)
students_result = students_result.all()
students = ""
if students_result:
students = query_result_to_json(students_result)
return render_template("classroom.html",
STATE=create_state(),
classroom=classroom,
students=students)
else:
return redirect('/')
elif request.method == 'POST':
if login_session.get('user_id'):
name = request.form.get('name')
desc = request.form.get('description')
print(name)
print(desc)
if name:
new_student = Student(name=name,
description=desc,
user_id=login_session.get('user_id'),
classroom_id=id)
session.add(new_student)
session.commit()
return redirect("/classrooms/{}".format(id))
def post(self):
args = request_args3.parse_args()
if args['perform_action'] == "get_all_students":
print "students api"
students_query_result = session.query(Student).all()
print students_query_result
students = []
for s in students_query_result:
students.append(s.serialize)
return jsonify(students=students)
if args['perform_action'] == 'get_student_by_id':
student_query_result = session.query(Student).filter(
Student.id == args['id']).one()
student = student_query_result.serialize
return jsonify(student=student)
if args['perform_action'] == 'add_student':
route_of_student = session.query(Route).filter(
Route.route_number == args['route_number']).one()
student = Student(name=args['name'],
roll_no=args['roll_no'],
contact=args['contact'],
son_of=args['son_of'],
branch=args['branch'],
course=args['course'],
year=args['year'],
college=args['college'],
issue_date=args['issue_date'],
end_date=args['end_date'],
route=route_of_student)
session.add(student)
session.commit()
return jsonify(message="New student Created")
if args['perform_action'] == 'delete_student':
student = session.query(Student).filter(
Student.id == args['id']).one()
session.delete(student)
session.commit()
return jsonify(message="Student Deleted")
if args['perform_action'] == "update_student":
student = session.query(Student).filter(
Student.id == args[id]).one()
session.delete(student)
route_of_student = session.query(Route).filter(
Route.route_number == args['route_number']).one()
student = Student(name=args['name'],
roll_no=args['roll_no'],
contact=args['contact'],
son_of=args['son_of'],
branch=args['branch'],
course=args['course'],
year=args['year'],
college=args['college'],
issue_date=args['issue_date'],
end_date=args['end_date'],
route=route_of_student)
session.add(student)
session.commit()
return jsonify(message="Student updated")
from database_setup import Course, Student, Base
engine = create_engine('sqlite:///classes.db')
# Bind the engine to the metadata of the Base class so that the
# declaratives can be accessed through a DBSession instance
# initialize database:
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# add to database:
student1 = Student(name="Sam Wilson")
session.add(student1)
student2 = Student(name="Alicia Carter")
session.add(student2)
student3 = Student(name="Michael Fox")
session.add(student3)
student4 = Student(name="Anna Smith")
session.add(student4)
course1 = Course(name="Algebra I", teacher="Mr. Alberts")
course1.students.append(student1)
course1.students.append(student2)
course1.students.append(student3)
# }
dummy_data = {
"Mrs Smith": [],
"Mr Langley": [],
"Mrs Exelby": [],
"Mr Deppe": []
}
engine = create_engine("sqlite:///classroomdb.db")
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# Parse dummy_data - Create Category & Item combinations
for classroom_name in dummy_data:
cat = Classroom(name=classroom_name, user_id=1)
session.add(cat)
for student_name in dummy_data[classroom_name]:
query = session.query(Student).filter_by(name=student_name).first()
if query == None:
item = Student(name=student_name,
description="No Description",
classroom=cat,
user_id=1)
session.add(item)
print("Added Item: {}".format(student_name))
else:
print("{} already exists. Skipping.".format(student_name))
session.commit()
vehicle2 = Vehicle(vehicle_number = 'HR019659', vehicle_type = 'Bus', model = 'Swaraj Mazada', year = '2014', insurance_validity = '01/12/2016', ut_permit_validity = '01/12/2016', haryana_permit_validity = '01/12/2016', punjab_permit_validity = '01/12/2016', passenger_tax_paid_upto = '01/12/2016', pollution_certificate_validity = '01/12/2016', fitness_valid_upto = '01/12/2016', excise_tax_paid_upto = '01/12/2016', last_service = '01/10/2016', next_service = '01/12/2016', last_battery_change = '01/10/2012', driver = driver2, route = route2) session.add(vehicle2) vehicle3 = Vehicle(vehicle_number = 'HR014695', vehicle_type = 'Bus', model = 'Tata', year = '2015', insurance_validity = '01/12/2016', ut_permit_validity = '01/12/2016', haryana_permit_validity = '01/12/2016', punjab_permit_validity = '01/12/2016', passenger_tax_paid_upto = '01/12/2016', pollution_certificate_validity = '01/12/2016', fitness_valid_upto = '01/12/2016', excise_tax_paid_upto = '01/12/2016', last_service = '01/10/2016', next_service = '01/12/2016', last_battery_change = '01/10/2012', driver = driver3, route = route3) session.add(vehicle1) session.commit() student1 = Student(name = "Rishabh Thukral", roll_no = '1444268', contact = '9466309992', son_of = 'Mukesh Thukral', branch = 'CSE', course = 'BTech', year = '3', college = 'CGC-COE', issue_date = '01/06/2016', end_date = '01/06/2017', route = route1) session.add(student1) student2 = Student(name = "Rohit Thukral", roll_no = '1444273', contact = '9466309992', son_of = 'Mukesh Thukral', branch = 'CSE', course = 'BTech', year = '3', college = 'CGC-COE', issue_date = '01/06/2016', end_date = '01/06/2017', route = route2) session.add(student2) student3 = Student(name = "Rishi Thukral", roll_no = '1443268', contact = '9466309992', son_of = 'Mukesh Thukral', branch = 'CSE', course = 'BTech', year = '3', college = 'CGC-COE', issue_date = '01/06/2016', end_date = '01/06/2017', route = route3) session.add(student1) session.commit() print "added items!" vehicle1 = session.query(Vehicle).all()
reader = csv.reader(f)
data = list(reader)
for i in data:
school = random.choice(schools)
if (school.type == "ES"):
grade = random.choice(es_grades)
elif (school.type == "MS"):
grade = random.choice(ms_grades)
elif (school.type == "HS"):
grade = random.choice(hs_grades)
student = Student(first_name=i[1],
last_name=i[2],
email=i[3],
address=i[4],
city=i[5],
state=i[6],
zip=i[7],
phone=i[8][2:],
grade=grade,
school=school)
session.add(student)
session.commit()
print "Added students"
with open('teacher_data.csv', 'rb') as f:
reader = csv.reader(f)
data = list(reader)
for i in data:
school = random.choice(schools)
if (school.type == "ES"):
def create_new_student(self, password, student_university_ID, name, surname, student_type, student_year, phone_number):
new_student = Student(password=password, student_university_ID=student_university_ID, name=name, surname=surname, student_type=student_type, student_year=student_year, phone_number=phone_number)
db.session.add(new_student)
db.session.commit()
return new_student
user_name = row[3].strip()
first_name = row[4].strip()
last_name = row[5].strip()
email = row[6].strip()
alias_name = row[7].strip()
semester = session.query(Semester).filter_by(year=year, season=season, course_no=course_no).first()
if semester == None:
print 'One or more semester configuration not found.'
sys.exit(10)
is_student_exists = session.query(Student).filter_by(user_name=user_name).count()
is_student_enrolled = session.query(Enrollment).filter_by(student_id=user_name, semester=semester).count()
if is_student_exists == 0:
student = Student(user_name=user_name, first_name=first_name, last_name=last_name, email=email, alias_name=alias_name)
enrollment = Enrollment(student=student, semester=semester)
session.add(student)
session.add(enrollment)
else:
if is_student_enrolled == 0:
student = session.query(Student).filter_by(user_name=user_name).first()
enrollment = Enrollment(student=student, semester=semester)
session.add(enrollment)
elif requested_operation == 'update':
for row in reader:
year = row[0].strip()
season = row[1].strip()
course_no = row[2].strip()
user_name = row[3].strip()
first_name = row[4].strip()
