I´m sorry but that does not seem to work either...I will paste the
exact example I´m testing, and maybe you can try it out. This is using
python 2.4 and sqlalchemy 0.15 under windows, by the way...
test.py
---
from sqlalchemy.ext.activemapper import ActiveMapper, column,
one_to_many, one_to_one
from sqlalchemy import objectstore, and_, or_, ForeignKey, String,
Integer, DateTime, Binary, Boolean, Date, backref
import sqlalchemy.ext.activemapper as activemapper
class MyClass1(ActiveMapper):
class mapping:
__table__ = "my_tab1"
id = column(Integer, primary_key=True)
myclasses = one_to_many('MyClass2', backref='parent')
class MyClass2(ActiveMapper):
class mapping:
__table__ = "my_tab2"
id = column(Integer, primary_key=True)
parent_id = column(Integer, foreign_key='my_tab1.id')
myclasses = one_to_many('MyClass3', backref='parent') #If you
comment out this line, everything will work just fine...
class MyClass3(ActiveMapper):
class mapping:
__table__ = "my_tab3"
id = column(Integer, primary_key=True)
parent_id = column(Integer, foreign_key='my_tab2.id')
activemapper.engine.connect('sqlite://filename=:memory:')
activemapper.create_tables()
mc1_1 = MyClass1()
mc2_1 = MyClass2()
mc2_2 = MyClass2()
mc1_1.myclasses.append(mc2_1)
mc2_2.parent=mc1_1
for x in mc1_1.myclasses:
print x
---
With the marked line commented out you get the two classes printed at
the end, so everything seems in order. But with the "one_to_many"
relationship enabled in MyClass2 you get an exception, KeyError,
because it does not find the 'parent' key in MyClass2 when
"mc1_1.myclasses.append(mc2_1)" gets executed.
Thanks for your help.
Gabriel.
Qvx escribió:
I have it like this and it works:
class MyClass1(ActiveMapper):
class mapping:
__table__ = "my_tab1"
id = column(Integer, primary_key=True)
myclasses = one_to_many('MyClass2', backref='parent')
class MyClass2(ActiveMapper):
class mapping:
__table__ = "my_tab2"
id = column(Integer, primary_key=True)
parent_id = column(Integer, foreign_key='my_tab1.id')
myclasses = one_to_many('MyClass3', backref='parent')
class MyClass3(ActiveMapper):
class mapping:
__table__ = "my_tab3"
id = column(Integer, primary_key=True)
parent_id = column(Integer, foreign_key='my_tab2.id')
On 4/4/06, Gabriel
Jacobo <[EMAIL PROTECTED]>
wrote:
Hi!
I´ve been trying SQLAlchemy using Activemapper for a couple of days
and I´ve found an issue that I did not see reflected anywhere else, so
please excuse if this is a silly question.
The thing is I have a schema that´s similar to the one stated at the
end
of the message. Basically it consists of three tables, each of which is
related in a kind of one parent- multiple child relation to each other,
that is...MyClass1 "owns" multiple MyClass2, and MyClass2 in turn
"owns"
multiple MyClass3. Each class, where apropriate, keeps a list of their
children and receives a backref to their parent.
I don´t know if there is a fundamental problem in this way of doing
things, but the point is this just doesn´t work. And the problem seems
to be in the backrefs. For example, if I do the following:
m1 = MyClass1()
m2 = MyClass2()
m1.myclasses.append(m2)
The code will fail, saying that MyClass2 does not have a "parent"
attribute. I believe this happens because the code for ActiveMapper
processes relations as follows:
1) It adds a mapper for MyClass1 to handle its relations. Seeing that
MyClass1 has a backref, it modifies MyClass2 to add the backref.
2) It adds a mapper for MyClass2 to handle its relations, in this case
with MyClass3. But in doing this, the process erases the backref
(represented by the "parent" attribute) to MyClass1! I´ve tested this by
painfully executing step by step until I found a point where this can
be
easily seen (I believe in the assign_mapper function that gets called by
ActiveMapper).
I´ve tried replacing the backrefs by what is called "Circular Mapping"
in the docs, using AddProperty to the mapper, but it does not seem to
work, probably because I am not doing it right. My final question would
then be if there is some way to accomplish what I´m trying to do with
ActiveMapper, or with the "traditional" method for using SQLAlchemy. If
this solution should involve modifying ActiveMapper I would be glad to
do it as it provides a much clearer schema than using the traditional
method.
Of course, if I eliminate the backref in MyClass1 or the one-to-many
relation in Class2, everything works fine, but this is not what I intend
to do.
Thanks for any help you can give me!
Gabriel.
PD: The schema...
class MyClass1(Activemapper):
class mapping:
__table__ = "MyClass1"
id = column(Integer, primary_key=True)
myclasses = one_to_many('MyClass2', colname='parent_id',
backref='parent')
class MyClass2(Activemapper):
class mapping:
__table__ = "MyClass1"
id = column(Integer, primary_key=True)
parent_id = column(Integer,
foreign_key=ForeignKey('MyClass1.id'))
myclasses = one_to_many('MyClass3', colname='parent_id',
backref='parent')
class MyClass3(Activemapper):
class mapping:
__table__ = "MyClass3"
id = column(Integer, primary_key=True)
parent_id = column(Integer, foreign_key=ForeignKey('
MyClass2.id'))
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
|
