[sqlalchemy] MemoryError in unitofwork.py

2007-04-25 Thread Brandon Goldfedder
I'm doing a fair number of session flushes as I update my data in the database. After about 53 of them (or so) I am getting the following exception: File build\bdist.win32\egg\sqlalchemy\orm\session.py, line 294, in flush File build\bdist.win32\egg\sqlalchemy\orm\unitofwork.py, line 181, in

[sqlalchemy] Re: Generated slow JOIN sql statement/specifying a left JOIN

2007-04-25 Thread Michael Bayer
On Apr 25, 2007, at 12:25 AM, Andreas Jung wrote: hmm..Why has this to do with self-referential mappers? Wouldn't the generated SQL be same if it wasn't a self-referential mapper but just mapper with a property for a one-to-many relationship? well no, the eager load paradigm is:

[sqlalchemy] Re: MemoryError in unitofwork.py

2007-04-25 Thread Michael Bayer
On Apr 24, 2007, at 10:59 AM, Brandon Goldfedder wrote: I'm doing a fair number of session flushes as I update my data in the database. After about 53 of them (or so) I am getting the following exception: File build\bdist.win32\egg\sqlalchemy\orm\session.py, line 294, in flush File

[sqlalchemy] Problems Inserting into Oracle using Bind Variables from Turbo Gears Controller

2007-04-25 Thread kap_ravi
Hi, I have configured Turbogears and created a quick-start web site with SQL Alchemy as the database modeler. The kid template pages where I showed some data from the database are working perfectly. But the part of the controller where I am trying to do an INSERT into a table of my oracle

[sqlalchemy] Re: Selectable/subquery for a (scalar) column?

2007-04-25 Thread Gaetan de Menten
Ok, I'm quite a bit stubborn at times, so I implemented this the way I thought because I think it makes much more sense this way. Attached is an experimental (as usual) patch to add a StatementProperty, so that you can define stuff like: mapper(Tag, tags_table, properties={ 'query_score':

[sqlalchemy] Problem with clear_mapper

2007-04-25 Thread Kevin Schmidt
Hi everyone, I have a problem using the following code (with sqlalchemy 0.3.6 and python2.5): mapperA = mapper(MyClass, self.tables['report_ia'], entity_name = 'REPIA', primary_key=[self.tables['report_ia'].c.id]) mapperB = mapper(MyClass, self.tables['report_ib'], entity_name = 'REPIB',

[sqlalchemy] Re: Problem with clear_mapper

2007-04-25 Thread Michael Bayer
On Apr 25, 2007, at 6:06 PM, Kevin Schmidt wrote: clear_mapper(customMapper) Running that I get: Processing Failure c /usr/lib/python2.5/site-packages/sqlalchemy/orm/__init__.py: 110:clear_mapper] im not sure what that error means, or if thats a full stack trace (if

[sqlalchemy] Re: MySQL schema and character_Set_results

2007-04-25 Thread Michael Bayer
On Apr 25, 2007, at 10:03 PM, Daniel Holth wrote: I need schema support and it works at all support in MySQL, so I had to change these things. It was'n't character_Set_results it was character_set_results. The older MySQL 4? doesn't have this value at all. Hopefully I will be fully

[sqlalchemy] Re: MySQL schema and character_Set_results

2007-04-25 Thread Daniel Holth
P.S. My application uses reflection. For MySQL it would make so much sense to combine table exists with show me the table, since they are the same request. We should cache the result. --~--~-~--~~~---~--~~ You received this message because you are subscribed to