correction (just made some edits):
http://www.sqlalchemy.org/docs_02/
datamapping.myt#datamapping_selectrelations_jointo
On May 16, 2006, at 7:36 PM, Michael Bayer wrote:
select_by uses python keyword arguments, where each keyword
represents a property established on your mapper (or a sub-
mapper). it does not currently (yet?) support a function-based
query language that deals with property names...if you want boolean
operations, you have to deal with column objects, i.e.
results = mapper.select(mytable.c.priority != 3)
version 0.2 has some extra helper features to create joins across
relationships, such as if "priority" is not on the immediate mapper
but is in a child mapper....the new functions, "join_to" and
"join_via" are described here:
http://www.sqlalchemy.org/docs_02/
datamapping.myt#datamapping_relations_lazyload_relselectby
On May 16, 2006, at 7:23 PM, Keith Edmunds wrote:
I've run into what is either a bug or a misunderstanding. The line:
results = mapper.select_by(priority = 3)
does exactly what I'd expect, producing a result set filtered by
priority.
The line:
results = mapper.select_by(priority != 3)
gives:
NameError: name 'priority' is not defined
Can anyone shed some light?
Thanks
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your
job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?
cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your
job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?
cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
