def test_objects(self):
assert session.query(self.Note).count() == 0
for t in 'abcdef':
n = self.Note()
n.title = n.note = n.importance = t
session.add(n)
session.commit()
assert session.query(self.Note).count() == 6
def _query_view(self, request):
"""Doing a single query."""
query = session.query(Author)
result1 = query.filter(Author.first_name.like("Pas%")).count()
result2 = query.all()
return Response(str(result1))
def edit_submit_view(req, nid):
# find note
note = session.query(Note).get(nid)
# TODO: check if note exists
note.title = req.form.get('title')
note.note = req.form.get('text')
note.importance = req.form.get('importance')
session.add(note)
session.commit()
return render_response('notes_success.jinja')
def _test_author_queries(self):
"""Tries to query the previously creates authors."""
query = session.query(Author)
result = query.filter_by(first_name="Pascal").one()
assert result.first_name == "Pascal"
assert result.last_name == "Hartig"
result = query.get(2)
assert result.first_name == "Ali"
assert result.last_name == "Afshar"
def edit_view(req, nid):
# find note
note = session.query(Note).get(nid)
# TODO: check if note exists
return render_response('notes_edit.jinja', note=note)
def index_view(req):
return render_response('notes_index.jinja',
notes=session.query(Note).order_by(Note.id))
