def students(): #form = StudentSearchForm() if request.method == 'POST': def stu_init_func(row): s = Student(row['id'], row['Student Name'], row['Date Enrolled'], row['Email']) return s request.save_to_database(field_name='file', session=db.session, table=Student, initializer=stu_init_func) record = Student.query.all() comp_tbl = Comp.query.all() for r in record: # test=r.id for c in comp_tbl: d = Competancy_rec(mark=0, comp_id=c.descrip, clinician_id='1', student_id=r.id) db.session.add(d) db.session.commit() records = Student.query.all() return render_template('students.html', title='Students.html', Student=records)
def student_import(): if request.method == 'POST': def student_init_func(row): #shop_id=Shop.query.filter_by(shopname=row['shop_id']).first() student = Student() student.firstname=row['firstname'] student.lastname=row['lastname'] student.school=row['school'] student.course=row['course'] student.sex=row['sex'] student.province=row['province'] student.city=row['city'] student.area=row['area'] student.address=row['address'] student.parent=row['parent'] student.phone1=row['phone1'] student.phone2=row['phone2'] student.shop_id=current_user.shop_id return student request.save_to_database(field_name='file', session=db.session, table=Student, initializer=student_init_func) return redirect('/student') return render_template('student_import.html')
def upload_categories(): def table_init_func(row): return Category(row['name']) request.save_to_database(field_name='file', session=db.session, table=Category, initializer=table_init_func) return excel.make_response_from_a_table(db.session, Category, "xls")
def about(): if request.method == 'POST': def comp_init_func(row): c = Comp(row['Description'], row['Code'], row['Rotation Name']) return c request.save_to_database( field_name ='file', session=db.session, table=Comp, initializer=comp_init_func) return render_template('about.html', title='About')
def import_case(): if (request.method == 'POST'): def ref_init_func(row): r = Reference() r.resource_type = row['RESOURCE_TYPE'] r.booking_ref = row['BOOKING_REF'] r.expire_on = datetime.datetime.strptime(str(row['EXPIRE_ON']) + " 16:00:00", "%Y-%m-%d %H:%M:%S") return r request.save_to_database(field_name='file', session=db.session, \ table=Reference, \ initializer=(ref_init_func)) flash('HRP Course Registration cases created.') return render_template('admin_acknowledge.html') return render_template('import.html', title='Import HRP Training Registration Cases')
def import_slot(): if (request.method == 'POST'): def resource_init_func(row): r = Resource() r.rtype = row['TYPE'] r.location = row['LOCATION'] r.description = row['DESCRIPTION'] r.capacity = row['CAPACITY'] r.available = row['CAPACITY'] return r request.save_to_database(field_name='file', session=db.session, \ table=Resource, \ initializer=(resource_init_func)) flash('HRP Training timeslots created.') return render_template('admin_acknowledge.html') return render_template('import.html', title='Import HRP Training Timeslot')
def do_import_transcendental(): # Clean Database and recreate database Transcendental.query.delete() if request.method == "POST": def init_func(row): transcendental = Transcendental(row['id'], row['name'], row['Key'], row['Description'], row['Video']) transcendental.id = row['id'] return transcendental request.save_to_database(field_name='file', session=db.session, table=Transcendental, initializers=[init_func]) return '''
def students(): #form = StudentSearchForm() if request.method == 'POST': def stu_init_func(row): s = Student(row['id'], row['Student Name'], row['Date Enrolled'], row['Email']) return s request.save_to_database(field_name='file', session=db.session, table=Student, initializer=stu_init_func) records = Student.query.all() return render_template('students.html', title='Students.html', Student=records)
def do_import(): # Clean Database and recreate database Composition.query.delete() if request.method == "POST": def init_func(row): composition = Composition( row['composition_name'], row['composer'], row['description'], row['video_link'] ) composition.id = row['id'] return composition request.save_to_database( field_name='file', session=db.session, table=Composition, initializers=[init_func]) return '''
def import_case(): if request.method == 'POST': def ref_init_func(row): r = Reference() r.resource_type = row['RESOURCE_TYPE'] r.booking_ref = row['BOOKING_REF'] print(f"......{type(row['EXPIRE_ON'])}") r.expire_on = datetime.datetime.strptime(str(row['EXPIRE_ON']), \ "%Y-%m-%d %H:%M:%S") return r request.save_to_database(field_name='file', session=db.session, \ table=Reference, \ initializer=ref_init_func) flash('HTMB cases created') return render_template('acknowledge.html') return render_template('import.html', title='Import HTMB Referrals')
def teacher_import(): if request.method == 'POST': def teacher_init_func(row): teacher = Teacher() teacher.firstname=row['firstname'] teacher.lastname=row['lastname'] teacher.fee=row['fee'] teacher.course=row['course'] teacher.sex=row['sex'] teacher.resume=row['resume'] teacher.phone=row['phone'] teacher.wx=row['wx'] teacher.shop_id=current_user.shop_id return teacher request.save_to_database(field_name='file', session=db.session, table=Teacher, initializer=teacer_init_func) return redirect('/teacher') return render_template('teacher_import.html')
def students(): if current_user.level == 1 or current_user.level == 2: form2 = SearchbyNameForm() students = '' if form2.validate_on_submit(): #searching by name students = Student.query.filter(Student.name.contains(form2.name.data)).all() if request.method == 'POST': def stu_init_func(row): s = Student(row['id'],row['Student Name'], row['Date Enrolled'], row['Email']) return s request.save_to_database( field_name ='file', session=db.session, table=Student, initializer=stu_init_func) record = Student.query.all() comp_tbl = Comp.query.all() p = bcrypt.generate_password_hash('password').decode('utf-8') for r in record: s = User2(username=r.studentid, email=r.email, password=p, level=3, rotation1='Student', rotation2=r.studentid) # automatically adding students user accounts db.session.add(s) db.session.commit() # test=r.id for c in comp_tbl: d = Competancy_rec(mark=0, comp_id=c.descrip, comp_name=c.rot_name, clinician_id=current_user.id, student_id=r.studentid) #automatically building comp rec table for each student db.session.add(d) db.session.commit() records = Student.query.all() return render_template('students.html', title='Students.html', Student=records, records=records, form2=form2, students=students) else: flash('ONLY CLINICIANS CAN ACCESS THIS PAGE','danger') return redirect(url_for('home'))