ah yes, thats busted.
On Apr 23, 2006, at 4:07 PM, Gambit wrote:
Hey Mike,
I was thinking more of this one:
class User(object):
pass
class Keyword(object):
pass
Keyword.mapper = mapper(Keyword, keywords)
User.mapper = mapper(User, users, properties={
'keywords':relation(Keyword.mapper,
primaryjoin=users.c.user_id==userkeywords.c.user_id,
secondaryjoin=userkeywords.c.keyword_id==keywords.c.keyword_id
)
})
right before the Lazy/Eager Joins Multiple Times to One Table section.
-G
On Sunday, April 23, 2006, 9:30:25 PM, you wrote:
gambit -
this doc ?
# define a mapper that does many-to-many on the 'itemkeywords'
association
# table
Article.mapper = mapper(Article, articles, properties = dict(
keywords = relation(mapper(Keyword, keywords), itemkeywords,
lazy=False)
)
)
"itemkeywords" is the secondary table in that one.
On Apr 23, 2006, at 1:25 PM, Gambit wrote:
Hey Michael,
So the docs will be updated with this, then?
-G
On Sunday, April 23, 2006, 5:54:33 PM, you wrote:
you need the "secondary" table explicit in a many-to-many join:
Information.mapper.add_property('datas', relation(Data.mapper,
rel_table,
primaryjoin=info_table.c.pk==rel_table.c.info_pk,
secondaryjoin=rel_table.c.data_pk==data_table.c.pk))
On Apr 23, 2006, at 8:39 AM, Gambit wrote:
Hey All,
I'm trying to reproduce, almost exactly, the many to many
relationship in the
docs (search for the 'secondaryjoin' keyword) and am
encountering an
ArgumentError:
sqlalchemy.exceptions.ArgumentError: Property 'datas' specified
with secondary
join condition but no secondary argument.
I've attached a working test case to this email, and the debug
output. As
you'll note, it's virtually identical to the example in the
documentation.
Operating environment is:
Windows XP SP2
Cygwin
Python 2.4.3
SQLALchemy 0.1.6 rev 1320
SQLite
Cheers,
-G
<many_to_many_test.log>
<many_to_many_test.py>
-------------------------------------------------------
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
