Hi Gilles -
if you've imported models, you need to refer to Series as models.Series,
unless you imported Series individually which seems to not be the case.
The second part of things, if you call query.filter(), you get a new Query
object back, just like with most Query methods, until you do one of the
following: iterate it, e.g. for x in query:, or call one of .all(),
.one(), or .first().
On Aug 30, 2014, at 11:12 AM, Gilles Coulais gilles.coul...@gmail.com wrote:
Hi all,
I'm starting to have a look at sqlalchemy and Flask and have a problem I
can't figure out. I have a set of models and am trying to play with the
corresponding database in a python console. Here is my models file:
http://snipurl.com/297pxcw
The following query will execute as expected and return a list of Series
objects, as present in the database
from book_catalog import models, db
series = models.Series.query.all()
for serie in series:
print serie.id, serie.name
1 Nikopol
But executing the following query will return an error:
nikopol = models.Series.query.filter(Series.name == 'Nikopol')
Traceback (most recent call last):
File stdin, line 1, in module
NameError: name 'Series' is not defined
I tried the following, which is executing, but returning a Query object (not
exactly what I'm trying to do ;) )
nikopol = models.Series.query.filter(models.Series.name == 'Nikopol')
print nikopol
SELECT series.id AS series_id, series.name AS series_name
FROM series
WHERE series.name = :name_1
Can anyone explain what I'm doing wrong here? I'm using SqlAlchemy 0.9.7
sqlalchemy.__version__
'0.9.7'
Thanks a lot in advance.
Gilles
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an
email to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.