def getTeacherByLastName(lastName): ''' Get Teacher object from database using their Family Name ''' teacher_object = None teacher = Teacher() try: teacher_object = db.teachers.find_one({'lastName': lastName}) except: print "There was a problem with the database operation" if teacher_object: if "firstName" in teacher_object: teacher.setFirstName(teacher_object["firstName"]) if "lastName" in teacher_object: teacher.setLastName(teacher_object["lastName"]) if "teacherId" in teacher_object: teacher.setTeacherId(teacher_object["teacherId"]) else: print "Could not find teacher with family Name: ", lastName return return teacher
def parse_teacher_params(self): filename = self.config['data_storage_path'] wb = xlrd.open_workbook(filename + '/params.xlsx') sheet = wb.sheet_by_index(1) teachers = [] current_row = 1 while len(sheet.cell(current_row, 0).value) != 0: t_id = sheet.cell(current_row, 0).value t_name = sheet.cell(current_row, 1).value t_discipline = sheet.cell(current_row, 2).value.split(';') # list t_programs = sheet.cell(current_row, 3).value.split(';') # list t_priority = self.__parse_teacher_priority( sheet.cell(current_row, 4).value) t_ability = self.__parse_teacher_ability( sheet.cell(current_row, 5).value) t_workplan = self.__parse_teacher_workplan( sheet.cell(current_row, 4).value) t_changeplan = self.__parse_teacher_changeplan( sheet.cell(current_row, 4).value) teachers.append( Teacher(t_id, t_name, t_discipline, t_programs, t_priority, t_ability, t_workplan, t_changeplan)) return teachers
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('goals', sa.Column('id', sa.Integer(), nullable=False), sa.Column('key', sa.String(length=50), nullable=False), sa.Column('name', sa.String(length=100), nullable=False), sa.Column('icon', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id') ) op.create_table('teachers', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=100), nullable=False), sa.Column('about', sa.String(length=1000), nullable=False), sa.Column('rating', sa.Integer(), nullable=False), sa.Column('picture', sa.String(), nullable=False), sa.Column('price', sa.Integer(), nullable=False), sa.Column('free', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id') ) op.create_table('teachers_goals', sa.Column('teacher_id', sa.Integer(), nullable=True), sa.Column('goal_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['goal_id'], ['goals.id'], ), sa.ForeignKeyConstraint(['teacher_id'], ['teachers.id'], ) ) # ### end Alembic commands ### goals = [] for goal in reader.get_all_goals(): goals.append( Goal( key=goal['key'], name=goal['name'], icon=goal['icon'] )) teachers = [] for teacher in reader.get_all_teachers(): teachers.append( Teacher( id=teacher['id'], name=teacher['name'], about=teacher['about'], rating=teacher['rating'], picture=teacher['picture'], price=teacher['price'], goals=[goal for goal in goals if goal.key in teacher['goals']], free=json.dumps(teacher['free']) )) db.session.add_all(goals) db.session.add_all(teachers) db.session.commit()
def login(): user_list = _login() if user_list: user_list = user_list[1:-1] auth = user_list[9] user = None if auth == "stu": print("身份:学生") user = Student(*user_list) elif auth == "tea": print("身份:老师") user = Teacher(*user_list) elif auth == "admin": print("身份:管理员") user = Admin(*user_list) return user
def _register(user_type, *args, **kwargs): # *args **kwargs 可变长传参 # 工厂模式 if user_type == "stu": # 学生用户 user = Student(*args, **kwargs, auth="stu") elif user_type == "tea": # 老师 user = Teacher(*args, **kwargs, auth="tea") elif user_type == "admin": # 管理员 user = Admin(*args, **kwargs, auth="admin") else: raise TypeError("类型错误!") # 使用多态特性 user.insert_one()
def seed_teachers(db): for teach in teachers: teacher = teach.copy() user = UserModel.query.filter_by( username=teacher.pop('username')).first() if teacher['is_ausbildung'] == True: ausbilder = Teacher.query.filter( Teacher.user.has(username=teacher['ausbilder'])).first() if ausbilder: teacher['ausbilder'] = ausbilder if user: new_teacher = Teacher(**teacher, user_id=user.id) db.session.add(new_teacher) db.session.commit()
def post(self): json_data = request.get_json() data, errors = teacher_schema.load(data=json_data) if errors: return { 'message': 'Validation Errors', 'errors': errors }, HTTPStatus.BAD_REQUEST if Teacher.get_by_teacher_username(data.get('teacher_username')): return { 'message': 'Teacher already exists' }, HTTPStatus.BAD_REQUEST teacher = Teacher(**data) teacher.save() return teacher_schema.dump(teacher).data, HTTPStatus.CREATED
def RegisterUser(): if request.method == "GET": flash("Please login first!! (GET method used for registration)", "info") return redirect(url_for("home")) user_type = request.form.get("user_type") # Student or Teacher name = request.form.get("name") # Name email = request.form.get("email") # Email password = request.form.get("password") # Password verify_password = request.form.get("verify_password") if password != verify_password: flash("Password and verified password do not match!", "warning") return redirect(url_for("home")) if Teacher.query.filter_by(email=email).first() or Student.query.filter_by( email=email).first(): flash(f"User with email {email} already exists!", "danger") return redirect(url_for("home")) newUser = None if user_type == "student": newUser = Student(name, email, password) elif user_type == "teacher": newUser = Teacher(name, email, password) else: flash(f"Invalid user type {user_type}!", "danger") return redirect(url_for("home")) db.session.add(newUser) db.session.commit() session["name"] = newUser.name session["email"] = newUser.email session["verified"] = newUser.verified session["user_type"] = newUser.user_type flash("Registered successfully!", "success") return redirect(url_for("dashboard"))
def signup(): id_number = request.json['id_number'] full_name = request.json['full_name'] password = request.json['password'] accumulated_score = '100' user_group = request.json['user_group'] # teacher = request.json['teacher_checkbox'] if Student.get_or_none(id_number=id_number): resp = {"success": False} return jsonify(resp) # return jsonify(False) if Teacher.get_or_none(id_number=id_number): resp = {"success": False} return jsonify(resp) if user_group == "Student": new_user = Student(id_number=id_number, full_name=full_name, password=password, accumulated_score=accumulated_score) if user_group == "Teacher": new_user = Teacher(id_number=id_number, full_name=full_name, password=password) if not new_user.save(): resp = {"success": False} return jsonify(resp) access_token = create_access_token(identity=new_user.id_number) resp = {"success": True, "auth_token": access_token} return jsonify(resp)
from datasets.stdataset import ST_DATASET from models.teacher import Teacher from models.student import Student dataset = ST_DATASET stlist = [] teacherlist = [] for data in dataset: # print(data, end='\n\n') # print(data['type']) # print(data.get('ptype', 123), end='\n\n') ptype = data['type'] if ptype == 'student': # year, classname, name, dept, ptype, identity, bloodg student = Student(data['year'], data['classname'], data['name'], data['dept'], data['type'], data['id'], data['bloodg']) stlist.append(student) elif ptype == 'teacher': #name, identity, ptype, dept, designation, salary, bloodg teacher = Teacher(data['name'], data['id'], data['type'], data['dept'], data['designation'], data['salary'], data['bloodg']) teacherlist.append(teacher) print(stlist, end='\n\n') print(teacherlist)
from models.teacher import Teacher from models.calendar import * from models.favourite import * import random import names # restart database Student_Activity.delete().execute() Student_Club.delete().execute() Student.delete().execute() Teacher.delete().execute() Club.delete().execute() Activity.delete().execute() # seeding Teacher(id_number=0, full_name="Professor Albus Dumbledore", password="******").save() Student(id_number=11, full_name="Hermione Granger", password="******", creativity_score=67, leadership_score=88, respect_score=76).save() # Activity Activity( name="Student Exchange Program", description= " Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.", image= "https://jw-nextagram.s3-ap-southeast-1.amazonaws.com/191202-112930-student_exchange_act.png", qualify_pts=random.randint(100, 1000),
# sys.path.append('/models') import time import datetime from pymongo import MongoClient from bson.dbref import DBRef from bson import ObjectId from models.teacher import Teacher ## Initialize Database mongo_uri = "mongodb://*****:*****@ds133632.mlab.com:33632/himama-dev" client = MongoClient(mongo_uri) db = client['himama-dev'] ## Initialize Teacher Object jane = Teacher() def getTeacherById(teacherId): ''' Get Teacher object from database using their Teacher ID ''' teacher_object = None teacher = Teacher() try: teacher_object = db.teachers.find_one({'teacherId': teacherId}) except: print "There was a problem with the database operation" if teacher_object:
import peeweedbevolve from models import * # all import (*) being handled by __init__.py inside the 'models' folder from models.base_model import db # ================================================================= from models.student import Student from models.teacher import Teacher from models.calendar import * import random import names # seeding Teacher(id_number=0, full_name="admin", password="******").save() Student(id_number=11, full_name="fav student", password="******", creativity_score=random.randint(1000,5000), leadership_score=random.randint(1000,5000), respect_score=random.randint(1000,5000)).save() for i in random.sample(range(1,5),3): # Teacher tch_name = names.get_full_name() first, last = tch_name.split() Teacher(id_number=i, full_name=tch_name, password=last).save() # Student std_name = names.get_full_name() first, last = std_name.split() Student(id_number=i, full_name=std_name, password=last,