def new_choice():
'input choice question'
if request.method == 'POST':
db = dbwrap.session()
multi = 0
if len(request.POST.type.strip()) > 0:
multi = 1
choice_list = request.POST.itema.strip() \
+ '@' + request.POST.itemb.strip() \
+ '@' + request.POST.itemc.strip() \
+ '@' + request.POST.itemd.strip()
q = model.ChoiceQuestion(
descr=request.POST.descr.strip(),
multi=multi, choice_list=choice_list,
note=request.POST.note.strip())
db.add(q)
db.commit()
redirect(app.get_url('question', qid=q.id))
# any local variables can be used in the template
return locals()
def setUp(self):
dbwrap.connect(connect='sqlite:///:memory:')
dbwrap.Base.metadata.create_all()
db = dbwrap.session()
model.create_sample_data()
self.db = db
def new_truefalse():
'input true-false question'
if request.method == 'POST':
db = dbwrap.session()
# any local variables can be used in the template
return locals()
def new_snapshot():
'input snapshot question'
if request.method == 'POST':
db = dbwrap.session()
# any local variables can be used in the template
return locals()
def user_list():
'A simple page from a dabase.'
db = dbwrap.session()
users = db.query(model.User).order_by(model.User.name)
# any local variables can be used in the template
return locals()
def question_list():
'A simple page from a dabase.'
db = dbwrap.session()
questions = db.query(model.ChoiceQuestion).order_by(model.ChoiceQuestion.id)
# any local variables can be used in the template
return locals()
def user_list():
'A simple page from a dabase.'
db = dbwrap.session()
users = db.query(model.User).order_by(model.User.name)
# any local variables can be used in the template
return locals()
def setUp(self):
dbwrap.connect(connect='sqlite:///:memory:')
dbwrap.Base.metadata.create_all()
db = dbwrap.session()
model.create_sample_data()
self.db = db
from webtest import TestApp
from bottle import TEMPLATE_PATH
TEMPLATE_PATH.insert(0, '../views')
self.app = website.build_application()
self.harness = TestApp(self.app)
def new_essay():
'input essay question'
if request.method == 'POST':
db = dbwrap.session()
descr = request.POST.descr.strip()
q = model.EssayQuestion(
descr=descr,
note=request.POST.note.strip())
db.add(q)
db.commit()
# any local variables can be used in the template
return locals()
def new_user():
'A sample of interacting with a form and a database.'
form = NewUserFormProcessor(request.forms.decode())
if request.method == 'POST' and form.validate():
db = dbwrap.session()
sean = model.User(
full_name=form.full_name.data, name=form.name.data,
email_address=form.email_address.data)
db.add(sean)
db.commit()
redirect(app.get_url('user', username=form.name.data))
# any local variables can be used in the template
return locals()
def new_user():
'A sample of interacting with a form and a database.'
form = NewUserFormProcessor(request.forms.decode())
if request.method == 'POST' and form.validate():
db = dbwrap.session()
sean = model.User(full_name=form.full_name.data,
name=form.name.data,
email_address=form.email_address.data)
db.add(sean)
db.commit()
redirect(app.get_url('user', username=form.name.data))
# any local variables can be used in the template
return locals()
def create_sample_data():
from bottledbwrap import dbwrap
dbwrap.connect()
dbwrap.Base.metadata.create_all()
db = dbwrap.session()
sean = User(
full_name='Sean Reifschneider', name='sean',
email_address='*****@*****.**')
db.add(sean)
evi = User(
full_name='Evi Nemeth', name='evi',
email_address='*****@*****.**')
db.add(evi)
dmr = User(
full_name='Dennis Ritchie', name='dmr',
email_address='*****@*****.**')
db.add(dmr)
dmr = User(
full_name='Peichao Wang', name='pwang',
email_address='*****@*****.**')
db.add(dmr)
db.commit()
q = TrueFalseQuestion(descr=u'幻想与一般的创造想象区别在于，幻想中所创造的形象总是体现着个人的愿望，并指向未来。',
note=u'对')
db.add(q)
q = ChoiceQuestion(multi=1, descr=u'教育目的就其表述和内容而言具有（ ）特征。',
choice_list=u'抽象性@理想性@可操作性@终极性', note=u'ABD')
db.add(q)
q = ChoiceQuestion(multi=1, descr=u'下列关于复式教学叙述正确的是( )。',
choice_list=u'复式教学就是对两个以上年级的学生进行教学的一种教学组织形式@复式教学适用于学生多、教室少的情况下教学@复式教学课堂教师的教学和学生的自学或做作业同时进行@复式教学情景下的学生的基本技能和自学能力相对较弱',
note=u'ABC')
db.add(q)
db.commit()
def create_sample_data():
from bottledbwrap import dbwrap
dbwrap.connect()
dbwrap.Base.metadata.create_all()
db = dbwrap.session()
sean = User(full_name='Sean Reifschneider',
name='sean',
email_address='*****@*****.**')
db.add(sean)
evi = User(full_name='Evi Nemeth',
name='evi',
email_address='*****@*****.**')
db.add(evi)
dmr = User(full_name='Dennis Ritchie',
name='dmr',
email_address='*****@*****.**')
db.add(dmr)
db.commit()
def create_sample_data():
from bottledbwrap import dbwrap
dbwrap.connect()
dbwrap.Base.metadata.create_all()
db = dbwrap.session()
sean = User(
full_name='Sean Reifschneider', name='sean',
email_address='*****@*****.**')
db.add(sean)
evi = User(
full_name='Evi Nemeth', name='evi',
email_address='*****@*****.**')
db.add(evi)
dmr = User(
full_name='Dennis Ritchie', name='dmr',
email_address='*****@*****.**')
db.add(dmr)
db.commit()
def question_by_id(qid):
from bottledbwrap import dbwrap
db = dbwrap.session()
q = db.query(ChoiceQuestion).filter_by(id=qid).first()
return q
def user_by_name(name):
from bottledbwrap import dbwrap
db = dbwrap.session()
user = db.query(User).filter_by(name=name).first()
return user
def user_by_name(name):
from bottledbwrap import dbwrap
db = dbwrap.session()
user = db.query(User).filter_by(name=name).first()
return user
