Re: [sqlalchemy] problems with multi-table mapping on IronPython

2010-07-11 Thread Harry Percival
thanks Michael. I took a look at README.unittests, but had some difficulties running them with ironpython (ipy setup.py test fails, and nosetests.exe doesn't allow you to specificy an interpreter). Still, i found some help on the interwebs, as well as in the nose __init__.py. eventually i was

Re: [sqlalchemy] problems with multi-table mapping on IronPython

2010-07-11 Thread Michael Bayer
On Jul 11, 2010, at 10:04 AM, Harry Percival wrote: thanks Michael. I took a look at README.unittests, but had some difficulties running them with ironpython (ipy setup.py test fails, and nosetests.exe doesn't allow you to specificy an interpreter). Still, i found some help on the

Re: [sqlalchemy] problems with multi-table mapping on IronPython

2010-07-10 Thread Harry Percival
OK, just in case anyone else is foolishly trying to run SQLA on ironpython, here's the workaround I've found: instead of attempting to use the mapper directly on the join: j = join(movies_table,md_table).join(directors_table) mapper(MoviesAndDirectors,j) #ipy errors here use a mapper on a

Re: [sqlalchemy] problems with multi-table mapping on IronPython

2010-07-10 Thread Michael Bayer
On Jul 10, 2010, at 12:07 PM, Harry Percival wrote: OK, just in case anyone else is foolishly trying to run SQLA on ironpython, here's the workaround I've found: instead of attempting to use the mapper directly on the join: j = join(movies_table,md_table).join(directors_table)

Re: [sqlalchemy] problems with multi-table mapping on IronPython

2010-07-08 Thread Harry Percival
Here's the source code of my test - let me know if I'm doing anything wrong here from sqlalchemy import create_engine from sqlalchemy.orm import mapper from sqlalchemy.sql.expression import join from sqlalchemy.orm.session import sessionmaker from sqlalchemy.schema import MetaData import

Re: [sqlalchemy] problems with multi-table mapping on IronPython

2010-07-06 Thread Michael Bayer
On Jul 6, 2010, at 4:18 AM, Harry Percival wrote: Hi, I've got an error which occurs in ironpython but not in cpython. can anyone replicate? See attached. I'm using IPY 2.6. string:1: DeprecationWarning: object.__init__() takes no parameters for type _keyed_weakref string:1:

Re: [sqlalchemy] problems with multi-table mapping on IronPython

2010-07-06 Thread Harry Percival
Hi Michael, thanks for replying - the reason I attached a zipfile is because sqlite isn't supported natively on ironpython, so I've had to include the source and a dll for it. So, if you did have time to open it up and take a peek, I'd very much appreciate it. Alternatively, how can I run the