Michael Bayer posted this on gmane.comp.python.sqlalchemy.user:
> heres how im running it:
>
> z-eeks-Computer:~/dev/sqlalchemy classic$ export PYTHONPATH=./lib/:./
> test/
> z-eeks-Computer:~/dev/sqlalchemy classic$ python threadlocal-
> association.py
> testdelete (__main__.AssociationTest) ... ok
> testinsert (__main__.AssociationTest) ... ok
> testmodify (__main__.AssociationTest) ... ok
> testreplace (__main__.AssociationTest) ... ok
The test doesn't pass on my Windows setup, neither with sqlite nor with
PostgreSQL. But, oddly enough, I've tested on a linux machine and it works
like a charm. But my model code still doesn't work in any of the setups.
So I've made a very little test with a portion of my model code. The test
doesn't work, and I've tried with threadlocal, without it, usind Bound and
DynamicMetadata, and usinf sqlite and PostgreSQL engines, to no avail.
The culprits are the relationships which use an association object; if I
delete them, all the model works, but defining them makes the code to fail.
Here is the test code:
-------------------------------------------------------------------------
import testbase
from sqlalchemy import *
class AssociationTest(testbase.PersistTest):
def setUpAll(self):
self.install_threadlocal()
global table_originals, table_people, table_isauthor, metadata,
Originals, People, IsAuthor
metadata = BoundMetaData(testbase.db)
table_originals = Table('Originals', metadata,
Column('ID', Integer, primary_key=True),
Column('Title', String(200), nullable=False),
Column('Date', Date ),
)
table_people = Table('People', metadata,
Column('ID', Integer, primary_key=True),
Column('Name', String(140), nullable=False),
Column('Country', CHAR(2), default='es'),
)
table_isauthor = Table('IsAuthor', metadata,
Column('OriginalsID', Integer, ForeignKey('Originals.ID'),
default=None),
Column('PeopleID', Integer, ForeignKey('People.ID'),
default=None),
Column('Kind', CHAR(1), default='A'),
)
metadata.create_all()
class Base(object):
def __init__(self, **kw):
for k,v in kw.iteritems():
setattr(self, k, v)
def display(self):
c = [ "%s=%s" % (col.key, repr(getattr(self, col.key))) for col
in self.c ]
return "%s(%s)" % (self.__class__.__name__, ', '.join(c))
def __repr__(self):
return self.display()
def __str__(self):
return self.display()
class Originals(Base):
order = [table_originals.c.Title, table_originals.c.Date]
class People(Base):
order = [table_people.c.Name]
class IsAuthor(Base):
pass
assign_mapper(Originals, table_originals, order_by=Originals.order)
assign_mapper(People, table_people, order_by=People.order)
assign_mapper(IsAuthor, table_isauthor, primary_key=
[table_isauthor.c.OriginalsID, table_isauthor.c.PeopleID,
table_isauthor.c.Kind])
Originals.mapper.add_properties({
'people': relation(IsAuthor, association=People),
'authors': relation(People, secondary=table_isauthor,
backref='written',
primaryjoin=and_(Originals.c.ID==table_isauthor.c.OriginalsID,
table_isauthor.c.Kind=='A')),
'title': table_originals.c.Title,
'date': table_originals.c.Date,
})
People.mapper.add_properties({
'originals': relation(IsAuthor, association=Originals),
'name': table_people.c.Name,
'country': table_people.c.Country,
})
IsAuthor.mapper.add_properties({
'original': relation(Originals, lazy=False),
'person': relation(People, lazy=False),
'kind': table_isauthor.c.Kind,
})
def tearDown(self):
for t in metadata.table_iterator(reverse=True):
t.delete().execute()
def tearDownAll(self):
clear_mappers()
metadata.drop_all()
def testinsert(self):
p = People(Name='name', Country='es')
objectstore.flush()
if __name__ == "__main__":
testbase.main()
-------------------------------------------------------------------------
Regards,
Raul Garcia.
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
