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()