drawing=Table( Column('id', <SNIP all the columns /> )
tags=Table ( 'tags', engine,
Column ( 'id', Integer, primary_key=True,nullable=False ),
Column ( 'name', VARCHAR(20), nullable=False,index='ix_tags_name' ) )
drawing_tags = Table ( 'drawing_tags', engine,
Column ( 'drawing_id', Integer, ForeignKey(' drawings.id'),primary_key=True,nullable=False ),
Column ( 'tag_id', Integer, ForeignKey('tags.id'), primary_key=True,nullable=False ) )
class Tag(object):
pass
class Drawing(object):
pass
mapper(Drawing,drawing,
properties={
'tags':relation(Tag,secondary=drawing_tags)
}
)
mapper(Tag,tags,properties={'drawings':relation(Drawing,secondary=drawing_tags)})
The following works:
d=s.query(Drawing).get( <whatever_id> )
d.tags
[ the, list, of, tags ]
The following also works
t=s.query(Tag).get( <whatever_id> )
t.drawings
[ the, list, of, drawings ]
The last one here doesn't quite work though:
d=s.query(Drawing).select_by( name == <whatever tag name> )
for name I've tried name, tag_name and a few others. the query can't resolve those properties. The docs were a little unclear as to whether we needed = or == for the operator so I tried both but neither worked.
The only thing that worked was to use tags.c.name == <whatever_id> but then the query is as follows:
SELECT drawings.id, <snipped columns />
FROM tags, drawings
WHERE tags.name = <whatever_name> ORDER BY drawings.id
Notice that the from clause isn't doing the join on drawing_tags. The resulting data set contains all the drawings instead of the joined drawings on the association table.
So, am I missing something here? Has a bug been introduced or am I doing something wrong.
Thanks
Dennis
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
