Re: [Sqlalchemy-users] SQLAlchemy 0.2.4 released

2006-06-28 Thread HD Mail
Nice checkin comments ! Thanks for all the work. Huy one word : BUGS ! which are fixed. I think everyone that is using 0.2.3 is going to want this one, as there was a lot broken with the new mapper compilation feature (as promised !) thats now fixed, and some pretty important

Re: [Sqlalchemy-users] Association object does not work with the threadlocal mod

2006-06-28 Thread Raul Garcia
Michael Bayer [mailto:[EMAIL PROTECTED] heres a diff. the test framework has the threadlocal thing turned off by default and also plays some games with it. you should be able to remove all the save() statements from the tests and everything should keep working; with threadlocal

Re: [Sqlalchemy-users] Association object does not work with the threadlocal mod

2006-06-28 Thread Michael Bayer
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

Re: [Sqlalchemy-users] many to many question on select_by

2006-06-28 Thread Dennis Muhlestein
On 6/28/06, Dennis Muhlestein [EMAIL PROTECTED] wrote: I've set up a simple many-to-many relation almost exactly as the 0.2.4 docs specify for using a secondary table:drawing=Table( Column('id', SNIP all the columns / )tags=Table ( 'tags', engine, Column ( 'id', Integer,

Re: [Sqlalchemy-users] Specifying order (and perhaps other keyword arguments) when using ActiveMapper

2006-06-28 Thread Jonathan LaCour
Charles Duffy wrote: So -- that quick first cut is seeming to be good enough for my immediate needs, such that not too much more is likely to happen to it unless someone looks at it and provides a poke in the form of well, we'll think about merging this *if* you do something. Jonathan,

Re: [Sqlalchemy-users] many to many question on select_by

2006-06-28 Thread Dennis Muhlestein
On 6/28/06, Michael Bayer [EMAIL PROTECTED] wrote: dennis -im not getting these results. can you attach a more complete test program ?Sure enough, I deleted everything from my model except those few tables and I got the correct result to. It must be something that I'm adding later. I suspect it is

Re: [Sqlalchemy-users] SQLAlchemy 0.2.4 released - Firebird Patch missing?

2006-06-28 Thread Brad Clements
I see my last Firebird patch still hasn't been applied. It's the one that adds support for type_conv I submitted it 2 or 3 times already. I've attached it again. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or

Re: [Sqlalchemy-users] many to many question on select_by

2006-06-28 Thread Dennis Muhlestein
On 6/28/06, Dennis Muhlestein [EMAIL PROTECTED] wrote: On 6/28/06, Michael Bayer [EMAIL PROTECTED] wrote: dennis -im not getting these results. can you attach a more complete test program ?Sure enough, I deleted everything from my model except those few tables and I got the correct result to. It

[Sqlalchemy-users] build ClauseElement with object

2006-06-28 Thread Randall Smith
How do I build a ClauseElement using a mapped object. Say I have a mapped object I got like so: county = session.query(Counties).get(1) I want to use this to construct a query. How do I build a ClauseElement with it? # This does not work, but it expresses what I'm trying to do. expr =

[Sqlalchemy-users] compatible with Python v2.2.1 and MySQLdb 0.9.2 ???

2006-06-28 Thread Jens Diemer
Is SQLAlchemy is compatible with Python v2.2.1 and MySQLdb 0.9.2 ??? I have found nothing on the SQLAlchemy webpages. I consider to use SQLAlchemy in PyLucid. But my web provider has only these old versions available. -- Mfg. Jens Diemer CMS in pure Python CGI: http://www.pylucid.org

Re: [Sqlalchemy-users] many to many question on select_by

2006-06-28 Thread Dennis Muhlestein
OK, I was right, cascade_mappers is the culprit. I have a few other tables that also have relations to the drawings table. Before upgrading to 2.x, I'd set those relations up with cascade mappers. Adding any one of those relations back causes the recursion error. I can add the properties manually

Re: [Sqlalchemy-users] SQLAlchemy 0.2.4 released - Firebird Patch missing?

2006-06-28 Thread Michael Bayer
first im seeing it for wahtever reason committed in 1672. (hm thought you were in the users file...i can set you up with that) On Jun 28, 2006, at 1:52 PM, Brad Clements wrote: I see my last Firebird patch still hasn't been applied. It's the one that adds support for type_conv I

Re: [Sqlalchemy-users] compatible with Python v2.2.1 and MySQLdb 0.9.2 ???

2006-06-28 Thread Jens Diemer
Jens Diemer schrieb: Is SQLAlchemy is compatible with Python v2.2.1 and MySQLdb 0.9.2 ??? I have patched the source and insert from __future__ import generators, so yield is available. I take sets.py from Python 2.4 But i have at least two problems: File sqlalchemy\types.py, line 202, in

Re: [Sqlalchemy-users] SQLAlchemy 0.2.4 released - Firebird Patch missing?

2006-06-28 Thread Brad Clements
On 28 Jun 2006 at 15:04, Michael Bayer wrote: first im seeing it for wahtever reason committed in 1672. Thanks. I think I first sent it to the list when it got jammed up 2 or 3 weeks ago, then I sent you a direct copy along with some other problem reports, so maybe it got lost there. No

Re: [Sqlalchemy-users] many to many question on select_by

2006-06-28 Thread Dennis Muhlestein
On 6/28/06, Michael Bayer [EMAIL PROTECTED] wrote: oh boy cascade_mapper is just evil.Did you see the test case I sent? It isn't working when I manually define it either. (for just one table) Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with

[Sqlalchemy-users] many to many question on select_by

2006-06-28 Thread Dennis Muhlestein
I've set up a simple many-to-many relation almost exactly as the 0.2.4 docs specify for using a secondary table:drawing=Table( Column('id', SNIP all the columns / )tags=Table ( 'tags', engine,Column ( 'id', Integer, primary_key=True,nullable=False ), Column ( 'name', VARCHAR(20),

Re: [Sqlalchemy-users] compatible with Python v2.2.1 and MySQLdb 0.9.2 ???

2006-06-28 Thread William K. Volkman
Hello, On Wed, 2006-06-28 at 12:40, Jens Diemer wrote: Jens Diemer schrieb: Is SQLAlchemy is compatible with Python v2.2.1 and MySQLdb 0.9.2 ??? I have patched the source and insert from __future__ import generators, so yield is available. I take sets.py from Python 2.4 But i have at

Re: [Sqlalchemy-users] compatible with Python v2.2.1 and MySQLdb 0.9.2 ???

2006-06-28 Thread Michael Bayer
or you could get your ISP to install python 2.4. 2.2 has some stability issues with weakrefs (which SA uses). On Jun 28, 2006, at 2:40 PM, Jens Diemer wrote: Jens Diemer schrieb: Is SQLAlchemy is compatible with Python v2.2.1 and MySQLdb 0.9.2 ??? I have patched the source and insert from

Re: [Sqlalchemy-users] many to many question on select_by

2006-06-28 Thread Dennis Muhlestein
On 6/28/06, Michael Bayer [EMAIL PROTECTED] wrote: so much for 0.2.4.this was a pretty small endless-loop check fix,which is repaired in 1673.the amazing thing is that nobody has comeacross this one for many versions, its been in there for awhile. I wonder if this fixes another small issue I'm

Re: [Sqlalchemy-users] compatible with Python v2.2.1 and MySQLdb 0.9.2 ???

2006-06-28 Thread Michael Bayer
what breaks going from 2.3 to 2.4 ? just curious. On Jun 28, 2006, at 7:10 PM, William K. Volkman wrote: Just FYI, On Wed, 2006-06-28 at 16:41, Michael Bayer wrote: or you could get your ISP to install python 2.4. 2.2 has some stability issues with weakrefs (which SA uses). Moving our