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))