[sqlalchemy] Re: 'lazy=False' with polymorphic joined tables

2007-12-17 Thread Alexandre Conrad
Michael Bayer wrote: i havent looked yet but this is likely a bug in eager loading when it interacts with polymorphic. are you on trunk ? Nope. I just installed SQLAlchemy-0.4.2dev_r3952. And it's now working. SA 0.4.1: [...] FROM companies JOIN suppliers ON companies.id = suppliers.id

[sqlalchemy] Firebird status and some testsuite issues

2007-12-17 Thread Lele Gaifax
Hi all, I was finally able to spend a little time on the Firebird backend, and I'm glad to say that I'm currently down to this test summary: Ran 1030 tests in 63.169s FAILED (failures=7, errors=187) There are still some real issue, but most of the failures and errors come from a few common

[sqlalchemy] Re: Using ORM Object as an intermadiate holder

2007-12-17 Thread Utku Altinkaya
On 16 Aralık, 22:22, Michael Bayer [EMAIL PROTECTED] wrote: On Dec 15, 11:02 pm, Utku Altinkaya [EMAIL PROTECTED] wrote: I do not want to lose invalid values, becouse I want to send them to the user again, so while using object as intermediate holder I have to set attributes invalid

[sqlalchemy] Re: Fwd: [elixir] warnings on exit

2007-12-17 Thread Ryszard Szopa
On Dec 13, 5:49 pm, Michael Bayer [EMAIL PROTECTED] wrote: these are some cleanup messages which occur during the final gc of objects in the session. ive tried to work around them a bit but they still persist for some applications ( i havent yet been able to reproduce them and im

[sqlalchemy] Problem with Relashionship

2007-12-17 Thread [EMAIL PROTECTED]
Please people help me My Simple Model class Record: has_field('special_number',Unicode(100)) belongs_to('person',of_kind='Person') class Person: has_field('name',Unicode(100)) = Use this:

[sqlalchemy] Hi to ALL. I just join this group.

2007-12-17 Thread [EMAIL PROTECTED]
Greetings to all http://milearmida.tripod.com/widescreen-wallpapers-naruto.html widescreen wallpapers naruto http://milearmida.tripod.com/index.html naruto wallpapers http://milearmida.tripod.com/naruto-akatsuki-wallpapers.html naruto akatsuki wallpapers

[sqlalchemy] Re: Many-To-One...What I'm doing wrong?

2007-12-17 Thread Marcos
That works. Thank's a lot. Marcos. I will continue asking. Soon... On Dec 14, 7:20 pm, [EMAIL PROTECTED] wrote: your 'iva' table-column AND 'iva' attribute/relation/property have same name, Thats what the error says. either rename one of them (e.g. the column to become iva_id), or use that

[sqlalchemy] Re: Python in instead of list of or_ values.

2007-12-17 Thread Michael Bayer
On Dec 17, 2007, at 11:32 AM, Justin wrote: Using the Django ORM you can write: MyModel.objects.filter(property__in=['list', 'of', 'values']) ...and It will OR those values for you. Does SQLAlchemy have a similar shortcut? table.c.somecol.in_([list of values])

[sqlalchemy] Re: Fwd: [elixir] warnings on exit

2007-12-17 Thread Michael Bayer
On Dec 16, 2007, at 7:29 PM, Ryszard Szopa wrote: On Dec 13, 5:49 pm, Michael Bayer [EMAIL PROTECTED] wrote: these are some cleanup messages which occur during the final gc of objects in the session. ive tried to work around them a bit but they still persist for some applications ( i

[sqlalchemy] Re: Firebird status and some testsuite issues

2007-12-17 Thread Michael Bayer
On Dec 17, 2007, at 8:59 AM, Lele Gaifax wrote: A. some tests do a textual comparison against an expected statement; this breaks on FB, because the dialect inserts an explicit PK field:: AssertionError: Testing for query 'INSERT INTO users (user_name) VALUES (?)' params

[sqlalchemy] Re: Python in instead of list of or_ values.

2007-12-17 Thread Justin Driscoll
Thanks! - Justin On Dec 17, 2007 11:44 AM, Michael Bayer [EMAIL PROTECTED] wrote: On Dec 17, 2007, at 11:32 AM, Justin wrote: Using the Django ORM you can write: MyModel.objects.filter(property__in=['list', 'of', 'values']) ...and It will OR those values for you. Does SQLAlchemy

[sqlalchemy] Re: obtaining previous value in mapper.extension.after_*

2007-12-17 Thread Michael Bayer
On Dec 16, 2007, at 3:26 PM, [EMAIL PROTECTED] wrote: and another issue around attribute.get_history... i have a descriptor that is autosetting some defaultvalue at first get. a descriptor on top of the InstrumentedAttribute itself ? id wonder how you are configuring that.

[sqlalchemy] Re: obtaining previous value in mapper.extension.after_*

2007-12-17 Thread sdobrev
Michael Bayer wrote: On Dec 16, 2007, at 3:26 PM, [EMAIL PROTECTED] wrote: and another issue around attribute.get_history... i have a descriptor that is autosetting some defaultvalue at first get. a descriptor on top of the InstrumentedAttribute itself ? id wonder how you are

[sqlalchemy] Re: obtaining previous value in mapper.extension.after_*

2007-12-17 Thread sdobrev
yes and no, as i said i'm replacing the __dict__ with something special; so its IA riding on top of me (;-) but otherwise its that. no renaming, i dont want someone (thats can be me, later) to be able to workaround either me or SA. then have your magic __dict__ implement the same

[sqlalchemy] traversal order of ClauseVistor

2007-12-17 Thread Esceo
Hi, I am just wondering about the traversal order of ClauseVistor, does it have to be in a set order? I am eagerloading lots (1000s) of relations, and query compilation take a long time, a profiling revealed that most of the time was spent in traverse. So, I am just wondering if the performance

[sqlalchemy] Re: traversal order of ClauseVistor

2007-12-17 Thread Michael Bayer
On Dec 17, 2007, at 10:38 PM, Esceo wrote: Hi, I am just wondering about the traversal order of ClauseVistor, does it have to be in a set order? I am eagerloading lots (1000s) of relations, and query compilation take a long time, a profiling revealed that most of the time was spent in

[sqlalchemy] Re: traversal order of ClauseVistor

2007-12-17 Thread Esceo
Hi Michael, Thanks for the quick reply. What I am in fact doing is undefer all fields, eagerload all relations (and undefer the corresponding fields) for a corresponding model. (ended up being 9xx options altogether) And yes, I am on 0.3.11 (and probably is unable to move onto a 0.4 as I am

[sqlalchemy] Re: traversal order of ClauseVistor

2007-12-17 Thread Esceo
Hi, Seeing so many improvements and benefits, I might as well migrate to 0.4 Just few things I wanted to make sure before I start on that. Inside the 0.4 branch, 1) are we still generating anonymous labels with a width of 4 char ('anon_0fda') etc? 2) there is a bug inside 0.3's strategies

[sqlalchemy] Re: traversal order of ClauseVistor

2007-12-17 Thread Michael Bayer
On Dec 18, 2007, at 12:57 AM, Esceo wrote: Hi Michael, Thanks for the quick reply. What I am in fact doing is undefer all fields, eagerload all relations (and undefer the corresponding fields) for a corresponding model. (ended up being 9xx options altogether) And yes, I am on 0.3.11

[sqlalchemy] Re: traversal order of ClauseVistor

2007-12-17 Thread Esceo
no, 0.4 is almost a total rewrite of 0.3's internals.Of course its possible since its been done, but then youd just be left with... 0.4! Which you can just download. I'm not sure how extensive your elixir/SA hacks are but the Elixir project has also been improving and updating,

[sqlalchemy] Re: traversal order of ClauseVistor

2007-12-17 Thread Michael Bayer
On Dec 18, 2007, at 1:34 AM, Esceo wrote: Hi, Seeing so many improvements and benefits, I might as well migrate to 0.4 Just few things I wanted to make sure before I start on that. Inside the 0.4 branch, 1) are we still generating anonymous labels with a width of 4 char ('anon_0fda')