def update_teacher(id):
teacher = orm_session.query(Teacher).filter(Teacher.id==id).first()
firstname = request.form["firstname"].decode("utf-8")
lastname = request.form["lastname"].decode("utf-8")
birthdate = request.form["birthdate"].decode("utf-8")
validate_birthdate(birthdate)
nationality = request.form["nationality"].decode("utf-8")
visa_status = request.form["visa_status"].decode("utf-8")
salary_per_hour = request.form["salary_per_hour"].decode("utf-8")
if validate_form_field_not_empty(firstname, lastname, birthdate):
logger.info("Teacher's name is %s", firstname + ' ' + lastname)
teacher.firstname = firstname
teacher.lastname = lastname
teacher.birthdate = birthdate
teacher.nationality = nationality
teacher.visa_status = visa_status
teacher.salary_per_hour = salary_per_hour
orm_session.add(teacher)
orm_session.commit()
message.success("successful")
else:
message.error("Failed")
return redirect("teachers")
def update_teacher(id):
teacher = orm_session.query(Teacher).filter(Teacher.id == id).first()
firstname = request.form["firstname"].decode("utf-8")
lastname = request.form["lastname"].decode("utf-8")
birthdate = request.form["birthdate"].decode("utf-8")
validate_birthdate(birthdate)
nationality = request.form["nationality"].decode("utf-8")
visa_status = request.form["visa_status"].decode("utf-8")
salary_per_hour = request.form["salary_per_hour"].decode("utf-8")
if validate_form_field_not_empty(firstname, lastname, birthdate):
logger.info("Teacher's name is %s", firstname + ' ' + lastname)
teacher.firstname = firstname
teacher.lastname = lastname
teacher.birthdate = birthdate
teacher.nationality = nationality
teacher.visa_status = visa_status
teacher.salary_per_hour = salary_per_hour
orm_session.add(teacher)
orm_session.commit()
message.success("successful")
else:
message.error("Failed")
return redirect("teachers")
def edit_subject(id):
subject = orm_session.query(Subject).filter(Subject.id == id).first()
if subject:
message.success("successful!")
return render_template('edit-subject.html', subject=subject)
else:
message.error("Failed!")
return redirect("/")
def edit_subject(id):
subject = orm_session.query(Subject).filter(Subject.id == id).first()
if subject:
message.success("successful!")
return render_template('edit-subject.html', subject=subject)
else:
message.error("Failed!")
return redirect("/")
def delete_subject(id):
subject = orm_session.query(Subject).filter(Subject.id == id).first()
if subject:
message.success("successful!")
orm_session.delete(subject)
orm_session.commit()
else:
message.error("Failed!")
return redirect('/subjects')
def edit_course(id):
course = orm_session.query(Course).filter(Course.id == id).first()
logger.info("editing course: %s", course)
if course:
message.success("successful!")
return render_template('edit-course.html', course=course)
else:
message.error("Failed!")
return redirect(url_for("courses"))
def edit_course(id):
course = orm_session.query(Course).filter(Course.id == id).first()
logger.info("editing course: %s", course)
if course:
message.success("successful!")
return render_template('edit-course.html', course=course)
else:
message.error("Failed!")
return redirect(url_for("courses"))
def delete_subject(id):
subject = orm_session.query(Subject).filter(Subject.id == id).first()
if subject:
message.success("successful!")
orm_session.delete(subject)
orm_session.commit()
else:
message.error("Failed!")
return redirect('/subjects')
def edit_teacher(id):
teacher = orm_session.query(Teacher).filter(Teacher.id == id).first()
if teacher:
logger.info("Editing teacher %s", teacher)
message.success("successful")
return render_template('edit-teacher.html', teacher=teacher)
else:
message.error("Failed!")
return redirect(url_for("teachers"))
def edit_student(id):
student = orm_session.query(Student).filter(Student.id == id).first()
if student:
logger.info("student = %s", student)
message.success("successful!")
return render_template('edit-student.html', student=student)
else:
message.error("Failed!")
return redirect("/students")
def edit_teacher(id):
teacher = orm_session.query(Teacher).filter(Teacher.id==id).first()
if teacher:
logger.info("Editing teacher %s", teacher)
message.success("successful")
return render_template('edit-teacher.html', teacher=teacher)
else:
message.error("Failed!")
return redirect(url_for("teachers"))
def edit_student(id):
student = orm_session.query(Student).filter(Student.id==id).first()
if student:
logger.info("student = %s", student)
message.success("successful!")
return render_template('edit-student.html', student=student)
else:
message.error("Failed!")
return redirect("/students")
def delete(id):
todo = orm_session.query(model.Todo).filter_by(id=id).first()
if todo:
orm_session.delete(todo)
orm_session.commit()
message.success(u"刪除事項成功")
else:
message.error(u"找不到記錄")
redirect("/")
def delete_student(id):
student = orm_session.query(Student).filter(Student.id == id).first()
if student:
logger.info("student = %s", student)
orm_session.delete(student)
orm_session.commit()
orm_session.close()
message.success("sucessful!")
else:
message.error(u"找不到记录")
return redirect('/students')
def delete_teacher(id):
teacher = orm_session.query(Teacher).filter(Teacher.id == id).first()
if teacher:
logger.info("deleting teacher %s", teacher)
orm_session.delete(teacher)
orm_session.commit()
orm_session.close()
message.success("successful!")
else:
message.error(u"找不到记录")
return redirect(url_for("teachers"))
def delete_teacher(id):
teacher = orm_session.query(Teacher).filter(Teacher.id==id).first()
if teacher:
logger.info("deleting teacher %s", teacher)
orm_session.delete(teacher)
orm_session.commit()
orm_session.close()
message.success("successful!")
else:
message.error(u"找不到记录")
return redirect(url_for("teachers"))
def delete_student(id):
student = orm_session.query(Student).filter(Student.id==id).first()
if student:
logger.info("student = %s", student)
orm_session.delete(student)
orm_session.commit()
orm_session.close()
message.success("sucessful!")
else:
message.error(u"找不到记录")
return redirect('/students')
def new():
name = request.forms.get("name").decode("utf-8");
if len(name) > 0:
record = model.Todo(topic=name, status=False)
orm_session.add(record)
orm_session.commit()
message.success(u"新增事項成功")
else:
message.error(u"沒有輸入項目")
redirect("/")
def new_subject():
subject_name = request.form["name"].decode("utf-8")
duration = request.form["duration"].decode("utf-8")
tier = request.form["tier"].decode("utf-8")
if len(subject_name) > 0 and len(duration) > 0 and tier:
subject = Subject(name=subject_name, duration=duration, tier=tier)
orm_session.add(subject)
orm_session.commit()
message.success("successful!")
else:
message.error("Failed!")
return redirect('/subjects')
def new_subject():
subject_name = request.form["name"].decode("utf-8")
duration = request.form["duration"].decode("utf-8")
tier = request.form["tier"].decode("utf-8")
if len(subject_name) >0 and len(duration) > 0 and tier:
subject = Subject(name=subject_name, duration=duration, tier=tier)
orm_session.add(subject)
orm_session.commit()
message.success("successful!")
else:
message.error("Failed!")
return redirect('/subjects')
def new_course():
name = request.form["name"].decode("utf-8")
if len(name) > 0:
record = Course(name=name, active=True)
orm_session.add(record)
orm_session.commit()
message.success("sucessful!")
else:
message.error("Failed!")
return redirect(url_for('courses'))
def update_student(id):
student = orm_session.query(Student).filter(Student.id==id).first()
name = request.form["name"].decode("utf-8")
if student:
student.name = name
orm_session.add(student)
orm_session.commit()
message.success("successful")
else:
message.error("Failed")
return redirect("students")
def unfinish(id):
todo = orm_session.query(model.Todo).filter_by(id=id).first()
if todo:
orm_session.query(model.Todo).filter_by(id=id).update({
model.Todo.status: False
})
orm_session.commit()
message.success(u"恢復事項成功")
else:
message.error(u"找不到記錄")
redirect("/")
def update_student(id):
student = orm_session.query(Student).filter(Student.id == id).first()
name = request.form["name"].decode("utf-8")
if student:
student.name = name
orm_session.add(student)
orm_session.commit()
message.success("successful")
else:
message.error("Failed")
return redirect("students")
def new_course():
name = request.form["name"].decode("utf-8")
if len(name) > 0:
record = Course(name=name, active=True)
orm_session.add(record)
orm_session.commit()
message.success("sucessful!")
else:
message.error("Failed!")
return redirect(url_for('courses'))
def update_subject(id):
subject = orm_session.query(Subject).filter(Subject.id==id).first()
logger.info("Subject object = %s", subject)
name = request.form["name"].decode("utf-8")
duration = request.form["duration"].decode("utf-8")
if subject:
logger.info("Subject name = %s and duration = %s.\n", \
"textfield name = %s, textfield duration = %s\n",
subject.name, subject.duration, name ,duration)
if subject.name != name:
subject.name = name
if subject.duration != duration:
subject.duration = duration
orm_session.add(subject)
orm_session.commit()
message.success("successful")
else:
message.error("Failed!")
return redirect('/subjects')
def new_student():
firstname = request.form["firstname"].decode("utf-8")
lastname = request.form["lastname"].decode("utf-8")
if request.form["paid"] == 'on':
paid = True
else:
paid = False
if len(firstname) > 0 and len(lastname) > 0:
record = Student(firstname=firstname, lastname=lastname, paid=paid, active=True)
orm_session.add(record)
orm_session.commit()
message.success("sucessful!")
else:
message.error("Failed!")
return edirect("/students")
def save():
id = request.forms.get("id").decode("utf-8");
name = request.forms.get("name").decode("utf-8");
if id is None or id == "":
message.error(u"找不到記錄")
elif len(name) <= 0:
message.error(u"沒有輸入項目")
else:
todo = orm_session.query(model.Todo).filter_by(id=id).first()
if todo:
orm_session.query(model.Todo).filter_by(id=id).update({
model.Todo.topic: name
})
orm_session.commit()
message.success(u"編輯事項成功")
redirect("/")
def update_subject(id):
subject = orm_session.query(Subject).filter(Subject.id == id).first()
logger.info("Subject object = %s", subject)
name = request.form["name"].decode("utf-8")
duration = request.form["duration"].decode("utf-8")
if subject:
logger.info("Subject name = %s and duration = %s.\n", \
"textfield name = %s, textfield duration = %s\n",
subject.name, subject.duration, name ,duration)
if subject.name != name:
subject.name = name
if subject.duration != duration:
subject.duration = duration
orm_session.add(subject)
orm_session.commit()
message.success("successful")
else:
message.error("Failed!")
return redirect('/subjects')
def new_teacher():
firstname = request.form["firstname"].decode("utf-8")
lastname = request.form["lastname"].decode("utf-8")
birthdate = request.form["birthdate"].decode("utf-8")
validate_birthdate(birthdate)
nationality = request.form["nationality"].decode("utf-8")
visa_status = request.form["visa_status"].decode("utf-8")
salary_per_hour = request.form["salary_per_hour"].decode("utf-8")
if validate_form_field_not_empty(firstname, lastname, birthdate):
record = Teacher(firstname=firstname, lastname=lastname, \
birthdate=birthdate, nationality=nationality, visa_status=visa_status, \
salary_per_hour = salary_per_hour, active=True)
orm_session.add(record)
orm_session.commit()
message.success("sucessful")
else:
message.error("Failed!")
return redirect(url_for("teachers"))
def new_teacher():
firstname = request.form["firstname"].decode("utf-8")
lastname = request.form["lastname"].decode("utf-8")
birthdate = request.form["birthdate"].decode("utf-8")
validate_birthdate(birthdate)
nationality = request.form["nationality"].decode("utf-8")
visa_status = request.form["visa_status"].decode("utf-8")
salary_per_hour = request.form["salary_per_hour"].decode("utf-8")
if validate_form_field_not_empty(firstname, lastname, birthdate):
record = Teacher(firstname=firstname, lastname=lastname, \
birthdate=birthdate, nationality=nationality, visa_status=visa_status, \
salary_per_hour = salary_per_hour, active=True)
orm_session.add(record)
orm_session.commit()
message.success("sucessful")
else:
message.error("Failed!")
return redirect(url_for("teachers"))
def new_student():
firstname = request.form["firstname"].decode("utf-8")
lastname = request.form["lastname"].decode("utf-8")
if request.form["paid"] == 'on':
paid = True
else:
paid = False
if len(firstname) > 0 and len(lastname) > 0:
record = Student(firstname=firstname,
lastname=lastname,
paid=paid,
active=True)
orm_session.add(record)
orm_session.commit()
message.success("sucessful!")
else:
message.error("Failed!")
return edirect("/students")
results = database.rgr().result(mdb_conn.log_id, is_root)
result = results.summary()
if result.passes != result.total :
if is_root or verbose :
for test in results[1:] : # drop this
if test.status.status is not 'PASS' :
message.warning("[%(log_id)d, %(status)s] %(reason)s", log_id=test.log.log_id, **test.status)
result.summary()
return result
def tree(self, node) :
if node.name == 'test' :
target = self.getopt('target', node)
script = 'test_' + node.getContent()
if target == 'python' :
self.enqueue('python test_%s.py %s' % (node.getContent(), self.getopts(node)))
else :
self.enqueue('make ' + target + ' SCRIPT=test_' + node.getContent())
else :
self.enqueue('./regress -s ' + node.prop('nid'))
################################################################################
suite=regression(options.xml)
suite.run(options.subset).summary()
message.success('end of tests')
################################################################################
mdb.finalize_all()
order = ordering[0]
message.note('Iteration %(iter_cnt)d uses "%(order)s"', **locals())
if xml :
opt = database.optimize.options[order](xml=xml, **optimize_opts)
else :
opt = database.optimize.options[order](regressions, tests, **optimize_opts)
run = opt.run()
optimize_opts['previous'] = opt
if len(ordering) > 1 :
return iteration(ordering[1:], iter_cnt+1, run)
# always return last optimization run
return opt, run
opt, xml = iteration(options.order)
# annotate optimized coverage result to this invocation
opt.insert(mdb_conn.log_id)
################################################################################
if options.xml :
try :
outfile = options.xml % (regressions[0] if regressions else tests[0])
except :
outfile = options.xml
message.information('dumping optimize to ' + outfile)
with open(outfile, 'w') as desc :
xml.write(desc)
message.success('optimizing ends')
mdb.finalize_all()
if xml:
opt = database.optimize.options[order](xml=xml, **optimize_opts)
else:
opt = database.optimize.options[order](regressions, tests,
**optimize_opts)
run = opt.run()
optimize_opts['previous'] = opt
if len(ordering) > 1:
return iteration(ordering[1:], iter_cnt + 1, run)
# always return last optimization run
return opt, run
opt, xml = iteration(options.order)
# annotate optimized coverage result to this invocation
opt.insert(mdb_conn.log_id)
################################################################################
if options.xml:
try:
outfile = options.xml % (regressions[0] if regressions else tests[0])
except:
outfile = options.xml
message.information('dumping optimize to ' + outfile)
with open(outfile, 'w') as desc:
xml.write(desc)
message.success('optimizing ends')
mdb.finalize_all()
if test.status.status is not 'PASS':
message.warning("[%(log_id)d, %(status)s] %(reason)s",
log_id=test.log.log_id,
**test.status)
result.summary()
return result
def tree(self, node):
if node.name == 'test':
target = self.getopt('target', node)
script = 'test_' + node.getContent()
if target == 'python':
self.enqueue('python test_%s.py %s' %
(node.getContent(), self.getopts(node)))
else:
self.enqueue('make ' + target + ' SCRIPT=test_' +
node.getContent())
else:
self.enqueue('./regress -s ' + node.prop('nid'))
################################################################################
suite = regression(options.xml)
suite.run(options.subset).summary()
message.success('end of tests')
################################################################################
mdb.finalize_all()
