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,