def seed_data():
ron_key = Student(student_id=423491377, first_name ="Ron", last_name = "Weasley").put()
harry_key = Student (student_id=423491782, first_name ="Harry", last_name = "Potter").put()
hermione_key = Student(student_id=423491249, first_name="Hermione", last_name="Granger").put()
malfoy_key = Student(student_id=42391043, first_name="Draco", last_name="Malfoy").put()
crabbe_key = Student(student_id=42391122, first_name="Vincent", last_name="Crabbe").put()
goyle_key = Student(student_id=42391063, first_name="Gregory", last_name="Goyle").put()
ron_wand=Wand(length = 14.0, material = "willow", core="unicorn", owner=ron_key)
harry_wand=Wand(length = 11.0, material = "holly", core="phoenix feather", owner=harry_key)
hermione_wand = Wand(length=10.75, material="vinewood", core="dragon heartstring", owner=hermione_key)
ron_wand.put()
harry_wand.put()
hermione_wand.put()
gryff = House(name="Gryffindor", mascot="Lion", students=[ron_key, harry_key, hermione_key])
snakes = House(name="Slytherin", mascot="Snake", students=[malfoy_key, crabbe_key, goyle_key])
hufflepuff = House(name="Hufflepuff", mascot="Badger", students=[])
ravenclaw = House(name="Ravenclaw", mascot="Eagle", students=[])
gryff.put()
snakes.put()
hufflepuff.put()
ravenclaw.put()
potions = Course(name="Potions", location="dungeon")
dada = Course(name="Defense Against the Dark Arts", location="3C")
transfiguration = Course(name="Transfiguration", location="Class 34")
potions_key = potions.put()
dada_key = dada.put()
transfiguration_key = transfiguration.put()
#dada
Enrollment(student=ron_key, course=dada_key).put()
Enrollment(student=harry_key, course=dada_key).put()
Enrollment(student=hermione_key, course=dada_key).put()
#potions
Enrollment(student=hermione_key, course=potions_key).put()
Enrollment(student=ron_key, course=potions_key).put()
Enrollment(student=malfoy_key, course=potions_key).put()
Enrollment(student=crabbe_key, course=potions_key).put()
Enrollment(student=goyle_key, course=potions_key).put()
#tranfirguration
Enrollment(student=harry_key, course=transfiguration_key).put()
Enrollment(student=hermione_key, course=transfiguration_key).put()
Enrollment(student=crabbe_key, course=transfiguration_key).put()
Enrollment(student=goyle_key, course=transfiguration_key).put()
snape = Teacher(name="Severus Snape", years_experience=5, classes_taught=[potions_key])
snape.put()
moody = Teacher(name="Alastor Moody", years_experience=1, classes_taught=[dada_key])
moody.put()
mcgonagall = Teacher(name="Minerva McGonagall", years_experience=12, classes_taught=[transfiguration_key])
mcgonagall.put()
def setUp(self):
self.school = School(name='Minnesota')
db.session.add(self.school)
db.session.commit()
self.tch = Teacher(first_name='Jess',
last_name='Christensen',
title='K4-2nd Sped',
school_id=self.school.id,
username='******',
password='******')
db.session.add(self.tch)
db.session.commit()
self.stu = Student(first_name='Fake',
last_name='Kid',
dob=date(2012, 1, 24),
grade=1,
teacher_id=self.tch.id,
dis_area='OHI')
db.session.add(self.stu)
db.session.commit()
self.iep = IEP(student_id=self.stu.id, teacher_id=self.tch.id)
db.session.add(self.iep)
db.session.commit()
def setUp(self):
School.query.delete()
Teacher.query.delete()
self.client = app.test_client()
self.school = School(name='Minnesota')
db.session.add(self.school)
db.session.commit()
self.teacher = Teacher(first_name='Maria',
last_name='Aldapa',
title='Teacher',
school_id=self.school.id,
username='******',
password='******')
self.data = {
'first_name': self.teacher.first_name,
'last_name': self.teacher.last_name,
'title': self.teacher.title,
'school_id': self.teacher.school_id,
'username': self.teacher.username,
'password': self.teacher.password,
'confirm': self.teacher.password
}
def otherUserRegistration():
if(session['logged_in'] == True): #if user login
if(request.method == 'GET'):
return render_template('OtherUsersRegistrationPage.html')
elif(request.method == 'POST'):
try:
userId = request.json['user_id']
name = request.json['name']
userNIC = request.json['userNIC']
userType = request.json['userType']
newUser = ""
if(userType == "teacher"): #if a teache, create new teacher object
newUser = Teacher(userId, name, userNIC)
if(userType == "admin"): #if a admin create new admin object
newUser = Admin(userId, name, userNIC)
DataPipelineObj.insert_data(newUser) #Add details to the database
return jsonify({'status':"User successfully registered"})
except:
return jsonify({'status':"Fill the required details"})
else:
abort(405)
else: #if user not login
return render_template('showSignIn.html')
def jsonTeacherCrud_V0(request):
if request.is_ajax():
#lg = request.GET.getlist('postData')
action = request.GET.get('action', None)
#INSERT COMMAND
if (action=="insert"):
codeAfm = request.GET.get('codeAfm', None)
codeGrad = request.GET.get('codeGrad', None)
codeSpec = request.GET.get('codeSpec', None)
name = request.GET.get('name', None)
surname = request.GET.get('surname', None)
"""
try:
except IntegrityError:
transaction.rollback()
"""
Teacher(name=name , surname = surname, codeAfm = codeAfm, codeGrad = codeGrad , codeSpec = codeSpec).save()
#t0.save() # Succeeds, but may be undone by transaction rollback
#c.save() # Succeeds, but a.save() may have been undone
#print ("New Record has id %d.\n", $mysqli->insert_id)
dictData = "Success"
#print dictData
jsonData = json.dumps(dictData)
#print jsonData
return HttpResponse(jsonData, content_type='application/json')
#UPDATE COMMAND
if (action=="update"):
id = request.GET.get('id', None)
codeAfm = request.GET.get('codeAfm', None)
codeGrad = request.GET.get('codeGrad', None)
codeSpec = request.GET.get('codeSpec', None)
name = request.GET.get('name', None)
surname = request.GET.get('surname', None)
Teacher.objects.filter(id=id).update(name=name , surname = surname, codeAfm = codeAfm, codeGrad = codeGrad , codeSpec = codeSpec ,)
#DELETE COMMAND
if (action=="delete"):
id = request.GET.get('id', None)
try:
Teacher.objects.filter(id=id).delete()
except IntegrityError:
transaction.rollback()
#result = "error"
#printf ("Deleted Record has id %d.\n", $_GET['EmployeeID']);
result = "success"
#return HttpResponse(result, content_type='application/json')
#SELECT is default
else:
dictData = Teacher.objects.all().values()
#print dictData
jsonData = json.dumps(list(dictData))
return HttpResponse(jsonData, content_type='application/json')
# all others error
else:
raise Http404
def register():
if request.method=='GET':
return render_template("register.html")
else:
name=request.form.get("name")
course=request.form.get("course")
teacher= Teacher(name, course)
session["teacher"]=serialize(teacher)
return redirect(url_for("index"))
def save(self):
user = Account(**self.data)
user.save()
if self.role.data == 1:
stuusr = Student(stuid=self.username.data)
stuusr.save()
if self.role.data == 3:
teausr = Teacher(teaid=self.username.data)
teausr.save()
return self.username.data, self.role.data
def create_teacher():
name = input('输入讲师名字 >> ').strip()
pas = input('输入讲师密码 >> ').strip()
level = input('输入讲师级别 >> ').strip()
teacher_list = [obj.name for obj in Teacher.get_obj_list()]
if name in teacher_list:
print('\033[31;1m讲师已经存在，不可重复创建\033[0m')
else:
teacher = Teacher(name, pas, level)
teacher.save()
print('\033[32;1m讲师[%s] 创建成功\033[0m' % name)
def teacher_upload_process_controller():
file = request.files['file']
rows = get_row_values(file)
rows=rows[1:]
for column in rows:
new_teacher = Teacher(
id=generate_key(),
name=column[0],
email=column[1])
new_teacher.put()
return render_template('all_done.html')
def create_teacher():
""" Create a teacher """
data = request.get_json()
new_id = uuid4()
new_teacher = Teacher(id=new_id, name=data['name'], last_name=data['last_name'])
db.session.add(new_teacher)
db.session.commit()
return jsonify({
'message': 'New teacher created!',
'id': new_id
})
def add_teacher():
#if request.args.get():
# id = request.args.get('id')
# ecode = request.args.get('ecode')
# Name = request.args.get('Name')
id = 11
ecode = '1011'
Name = "ABD!"
new = Teacher(id=1002, ecode='EN', Name='Aditya')
db.session.add(new)
db.session.commit()
return "New entry added"
def post(self):
if GetTeacher(users.get_current_user()) == None:
new_teacher = Teacher(parent=root_parent())
new_teacher.user = users.get_current_user()
new_teacher.email = (users.get_current_user()).email()
new_teacher.code = randint(100,999)
new_teacher.put()
self.redirect('/teacherSession')
else:
newCode = randint(100,999)
currentTeacher = GetTeacher(users.get_current_user())
currentTeacher.code = newCode
currentTeacher.put()
self.redirect('/teacherSession')
def create(request):
ID = request.GET["id"]
d = RequestContext(request, {"number": ID})
p = Yonghu.objects.filter(Number=ID)
for i in p:
if i.Leibie == "teacher":
if request.POST:
post = request.POST
new_teacher = Teacher(
Name=post["Name"],
Profession=post["Profession"],
Information=post["Information"],
Foundation=post["Foundation"],
Research=post["Research"],
Tel=post["Tel"],
Work=post["Work"],
Education=post["Education"],
Position=post["Position"],
Rongyu=post["Rongyu"],
Jianzhi=post["Jianzhi"],
Rfield=post["Rfield"],
Number=Yonghu.objects.get(Number=ID),
)
new_teacher.save()
c = RequestContext(request, {
"teacher": new_teacher,
"number": ID,
})
return render_to_response("sunyan4.html", c)
else:
return render_to_response("sunyan3.html")
else:
if request.POST:
post = request.POST
new_student = Student(
Name=post["Name"],
Profession=post["Profession"],
Tel=post["Tel"],
Xuenian=post["Xuenian"],
Number=Yonghu.objects.get(Number=ID),
)
new_student.save()
c = RequestContext(request, {
"student": new_student,
"number": ID,
})
return render_to_response("sunyan1.html", c)
else:
return render_to_response("sunyan2.html")
def load_teachers_data_to_db():
teachers = get_teachers_data()
for teacher in teachers:
teacher_data = Teacher(
name=teacher['name'],
email='{}@school.com'.format(teacher['name'].replace(' ', '_')),
about=teacher['about'],
rating=teacher['rating'],
picture=teacher['picture'],
price=teacher['price'],
)
db.session.add(teacher_data)
db.session.commit()
def add_teacher():
form = addTeacher()
if form.validate_on_submit():
new_teacher = Teacher()
new_teacher.id = form.id.data
new_teacher.name = form.name.data
db.session.add(new_teacher)
new_user = User()
new_user.id = form.id.data
new_user.set_password(form.password.data)
db.session.add(new_user)
db.session.commit()
flash('添加老师成功', 'success')
return redirect(url_for('index_admin.manage_teacher'))
return render_template('admin/add_teacher.html', form=form)
def teachers(request):
if request.method == "POST":
lform = NewProject(request.POST)
if lform.is_valid():
name = lform.cleaned_data['name']
tr = Teacher()
tr.name = name
tr.save()
teachers = Teacher.objects.all()
return render(request, 'teachers.html', {
'newproject': NewProject(),
'teachers': teachers
})
def create_teachers():
print("Creating teacher")
teachers_entries = []
for teacher in teachers:
new_entry = Teacher(id=teacher['id'],
name=teacher['name'],
about=teacher['about'],
rating=teacher['rating'],
picture=teacher['picture'],
price=teacher['price'],
goals=",".join(teacher['goals']),
free=json.dumps(teacher['free']))
teachers_entries.append(new_entry)
db.session.add_all(teachers_entries)
db.session.commit()
db.create_all()
def setUp(self):
self.school = School(name='Minnesota')
db.session.add(self.school)
db.session.commit()
self.tch = Teacher(first_name='Jess',
last_name='Christensen',
title='K4-2nd Sped',
school_id=self.school.id,
username='******',
password='******')
db.session.add(self.tch)
db.session.commit()
self.stu = Student(first_name='Fake',
last_name='Kid',
dob=date(2012, 1, 24),
grade=1,
teacher_id=self.tch.id,
dis_area='OHI')
db.session.add(self.stu)
db.session.commit()
self.guardian = Guardian(first_name='Fake',
last_name='Dad',
relation='Dad',
username='******',
password='******')
self.guardian2 = Guardian(first_name='Fake',
last_name='Mom',
relation='Mom',
username='******',
password='******')
db.session.add(self.guardian)
db.session.add(self.guardian2)
db.session.commit()
self.family = Family(guardian_id=self.guardian.id,
student_id=self.stu.id)
self.family2 = Family(guardian_id=self.guardian2.id,
student_id=self.stu.id)
db.session.add(self.family)
db.session.add(self.family2)
db.session.commit()
def setUp(self):
self.school = School(name='Coultrap')
db.session.add(self.school)
db.session.commit()
self.tch = Teacher(first_name='Jess',
last_name='Christensen',
title='K4-2nd Sped',
school_id=self.school.id,
username='******',
password='******')
self.reg_obj = Teacher.register(first_name=self.tch.first_name,
last_name=self.tch.last_name,
title=self.tch.title,
school_id=self.tch.school_id,
username=self.tch.username,
password=self.tch.password)
def create_teacher(jwt):
body = request.get_json()
print("body: ", body)
name = body.get('name', '')
try:
teacher = Teacher(name=name)
teacher.save()
selection = Teacher.query.all()
current_teachers = paginate_model(request, selection)
return jsonify({
'success': True,
'total_teachers': len(selection),
'teachers': current_teachers
}), 200
except Exception as e:
abort(422)
def create_teacher():
try:
name = input('请输入老师姓名:').strip()
password = input('请输入登陆密码:').strip()
level = input('请输入老师级别:').strip()
teacher_name_list = [obj.name for obj in Teacher.get_all_obj_list()]
if name in teacher_name_list:
raise Exception('\033[43;1m老师[%s] 已存在，不可重复创建\033[0m' % name)
obj = Teacher(name, password, level)
obj.save()
status = True
error = ''
data = '\033[33;1m老师[%s] 级别[%s] 时间[%s] 创建成功 \033[0m' % (
obj.name, obj.level, obj.create_time)
except Exception as e:
status = False
error = str(e)
data = ''
return {'status': status, 'error': error, 'data': data}
def post(self):
_user_parser = reqparse.RequestParser()
_user_parser.add_argument("username",
type=str,
required=True,
help="This field cannot be blank.")
_user_parser.add_argument("password",
type=str,
required=True,
help="This field cannot be blank.")
_user_parser.add_argument("first_name",
type=str,
required=True,
help="This field cannot be blank.")
_user_parser.add_argument("last_name",
type=str,
required=True,
help="This field cannot be blank.")
_user_parser.add_argument("is_teacher",
type=bool,
required=True,
help="This field cannot be blank.")
_user_parser.add_argument("class_name",
type=str,
required=True,
help="This field cannot be blank.")
data = _user_parser.parse_args()
if User.find_by_username(data["username"]):
return {'message': 'A user with that name already exists'}
if not Lesson.find_by_name(data['class_name']):
return {'message': 'There is no class with that name'}
teacher = Teacher(username=data['username'],
first_name=data['first_name'],
last_name=data['last_name'],
is_teacher=data['is_teacher'],
class_name=data['class_name'])
teacher.set_password(data['password'])
teacher.save_to_db()
return {"message": "Teacher Created!"}, 201
def submit_form(self):
for teacher in enumerate(self.lbteacher.get(0, END)):
if teacher[1] == self.teacher_name.get() and self.new_teacher.get(
) == 0:
messagebox.showerror("Opps!", "You have forgotten something")
return
teacher = Teacher(self.teacher_id, self.teacher_name.get(),
self.teacher_surname.get(), self.teacher_phone.get(),
self.teacher_email.get(),
self.teacher_position.get())
if self.new_teacher.get() == 1:
add_teacher(self.db, teacher)
else:
update_teacher(self.db, teacher, self.teacher_id)
messagebox.showinfo("Okey!", "Your order has been applied")
def setUp(self):
self.school = School(name='Minnesota')
db.session.add(self.school)
db.session.commit()
self.tch = Teacher(first_name='Jess',
last_name='Christensen',
title='K4-2nd Sped',
school_id=self.school.id,
username='******',
password='******')
db.session.add(self.tch)
db.session.commit()
self.stu = Student(first_name='Fake',
last_name='Kid',
dob=date(2012, 1, 24),
grade=1,
teacher_id=self.tch.id,
dis_area='OHI')
db.session.add(self.stu)
db.session.commit()
self.iep = IEP(student_id=self.stu.id, teacher_id=self.tch.id)
db.session.add(self.iep)
db.session.commit()
self.goal = Goal(iep_id=self.iep.id,
goal="Increase CWPM to 23",
standard="Read with fluency")
db.session.add(self.goal)
db.session.commit()
self.cw_data = ClassworkData(goal_id=self.goal.id,
baseline="12 CWPM",
current="15 CWPM",
attainment="23 CWPM")
db.session.add(self.cw_data)
db.session.commit()
def register():
error = None
form = RegisterForm(request.form)
if form.validate_on_submit():
teacher = Teacher(
first_name=form.first_name.data,
last_name=form.last_name.data,
email=form.email.data,
password=form.password.data,
)
try:
teacher.put()
teacher_id = teacher.key.id()
flash(u'Teacher %s successfully saved.' % teacher_id, 'success')
return redirect(url_for('login'))
except CapabilityDisabledError:
flash(u'App Engine Datastore is currently in read-only mode.',
'info')
return redirect(url_for('register'))
return render_template('register.html', form=form)
def teacherRegister():
if request.method == 'GET':
form = RegisterFormTeacher()
return render_template('教师注册页面.html', form=form)
else:
form = RegisterFormTeacher(request.form)
if form.validate_on_submit():
user = Teacher()
user.id = form.id.data
user.name = form.name.data
user.setPassword(form.password.data)
if Teacher.query.get(user.id) is not None:
flash("此工号已经被注册！！！！")
return render_template('教师注册页面.html', form=form)
db.session.add(user)
db.session.commit()
return redirect('index')
else:
flash("输入有误，请重新输入")
return render_template('教师注册页面.html', form=form)
def add_teachers_to_db():
teachers_list = [{
"fullname": "ПетроваПП",
"qualification": "Стажер"
}, {
"fullname": "СидоровСС",
"qualification": "Оператор"
}, {
"fullname": "ДенисоваДД",
"qualification": "Выпускник"
}, {
"fullname": "ЛенинЛЛ",
"qualification": "Практикант"
}]
for i in teachers_list:
fullname = i["fullname"]
qualification = i["qualification"]
to_db = Teacher(fullname, qualification)
db.session.add(to_db)
db.session.commit()
def teacher_controller(id):
name = request.values.get('name')
email = request.values.get('email')
if id:
teacher = Teacher.query(Teacher.id==id).get()
if teacher:
if request.method == 'GET':
if request.values.get('json'):
return json.dumps(dict(teacher=teacher.json))
return render_template('teacher_view.html',teacher = teacher, title = "Teacher List")
elif request.method == 'PUT':
teacher = edit_parser(teacher,request)
teacher.put()
return 'Value Updated', 204
elif request.method == 'DELETE':
teacher.key.delete()
return 'Item deleted', 204
else:
return 'Method Not Allowed'
else:
if request.method == 'GET':
teacher_list = Teacher.query().fetch(1000)
entries=None
if teacher_list:
entries = [teacher.dto() for teacher in teacher_list]
if request.values.get('json'):
return json.dumps(dict(teacher=entries))
return render_template('teacher.html',teacher_entries = entries, title = "Teacher List")
elif request.method == 'POST':
teacher = Teacher()
teacher = new_parser(teacher,request)
teacher.put()
url = '/teacher/'
if request.values.get('json'):
url = '/teacher/json=true'
return redirect(url)
else:
return abort(405)
def create_teacher(ano_para):
if request.json["type"] == "3.3as": #待修改
teacher = Teacher()
tnounique = 1
tnolist = db.session.execute('SELECT tno FROM TeacherInfo;').fetchall()
for tno in tnolist:
if request.json['tno'] == tno[0]:
tnounique = 0
if tnounique == 1:
teacher.tno = request.json['tno']
teacher.tname = request.json['tname']
teacher.sex = request.json['sex']
teacher.age = request.json['age']
db.session.add(teacher)
db.session.commit()
return jsonify({ #待修改
'type': '3.3ar',
'success': 'true'
})
else:
return jsonify({ #待修改
'type': '3.3ar',
'success': 'false'
})
def admin_add_teacher():
form = AddPersonForm()
if form.validate_on_submit():
if form.addtype.data == 'single':
id = form.id.data
name = form.name.data
email = form.email.data
password = form.password.data
if id is None or id == "":
flash(u'工号不能为空')
return render_template('adminAddTeacher.html', form=form)
if not id.isdigit():
flash(u'工号必须为整数')
return render_template('adminAddTeacher.html', form=form)
teacher = Teacher.query.get(int(id) + DEFAULT)
if teacher is not None:
flash(u'教师已经存在，不能重复添加')
return render_template('adminAddTeacher.html', form=form)
if password is None or password == "": #：如果密码为空，则默认密码为工号
password = str(id)
teacher = Teacher(id=int(id),
name=name,
email=email,
password=password)
db.session.add(teacher)
db.session.commit()
flash(u'添加教师成功')
return redirect(url_for('teacher_list'))
else:
errorList = []
isError = False
isAdd = False
address = upload(form.file.data,
['xls', 'xlsx']) #：将文件保存到服务器并返回文件地址
if address is None:
flash(u'请选择正确的文件格式上传文件')
return render_template('adminAddTeacher.html', form=form)
#：使用xlrd模块读取excel文件
data = xlrd.open_workbook(address)
table = data.sheets()[0]
for i in range(table.nrows):
line = table.row_values(i)
try:
if type(eval(str(line[0]))) == float or str(
line[0]).isdigit():
id = int(line[0])
teacher = Teacher.query.get(int(id) + DEFAULT)
if teacher is not None:
isError = True
errorList.append(id)
continue
isAdd = True
name = line[1]
email = str(line[2])
password = str(line[3])
if password is None or password == "":
password = str(id)
teacher = Teacher(id=int(id),
name=name,
email=email,
password=password)
db.session.add(teacher)
except:
continue #：对不符合的数据不做处理，直接跳过
#：删除上传的文件
if os.path.exists(address):
os.remove(address)
#：对错误结果进行处理
if isError:
message = u'教师'
for error in errorList:
message += '"' + str(error) + '" '
message += u'已经存在，不能重复添加'
flash(message)
db.session.commit()
return render_template('adminAddTeacher.html', form=form)
elif isAdd:
db.session.commit()
flash(u'全部教师添加成功')
return redirect(url_for('teacher_list'))
else:
flash(u'请选择正确的文件格式上传文件')
return render_template('adminAddTeacher.html', form=form)
return render_template('adminAddTeacher.html', form=form)
