[sqlalchemy] Re: problems with mapper inheritance and eager loader

2007-01-29 Thread Michael Bayer
On Jan 29, 2007, at 11:30 AM, Manlio Perillo wrote: The problem is that sometimes (at random, but I'm not sure), SQLAlchemy wants to use the lazy loader for comments, when I do session.load (Derived). thats sometimes due to an eager degrade. eager loading will generally not issue

[sqlalchemy] Re: Column and business object verification??

2007-01-29 Thread chris e
On Jan 29, 1:49 am, Julien Cigar [EMAIL PROTECTED] wrote: Michael Bayer wrote: On Jan 24, 1:50 am, chris e [EMAIL PROTECTED] wrote: I am planning on using sqlalchemy to build the api for a database I am developing, and I was wondering if there is any type of column verification that

[sqlalchemy] Re: polymorphic mapping with more than 2 level of inheritance

2007-01-29 Thread svilen
here's something about postgres: pu_A = polymorphic_union( { 'A': table_A, 'B': table_B, }, 'atype', 'pu_A', ) #concrete On postgres, the above fails - does not like the 'pu_A'. If it's lowercase/omitted, it's ok. i think

[sqlalchemy] Re: polymorphic mapping with more than 2 level of inheritance

2007-01-29 Thread sdobrev
here next portion - 3 kinds, one case per kind. all tests pass with rev 2267 of that branch. try that rev specifically, since i want to take whats there and do another pass. im trying to get it so that the entire science of parent table, child table, polymorphic selectables, primary join -

[sqlalchemy] Re: polymorphic mapping with more than 2 level of inheritance

2007-01-29 Thread sdobrev
here next portion - 3 kinds, one case per kind. hm.hmmm. on sqlite they were 3 failing - now only 2; on postgres all 3 fail... The cirlcular dep one - is there because i cannot get where the circ-dep is. The post-updates are invented by the mincut algo, and i don't see why such configuration

[sqlalchemy] Informix SA backend

2007-01-29 Thread askel
Hello everybody, I have done some initial implementation of Informix as one of SA backend. It is currently using InformixDB 2.3. I'd like to share what was already implemented with SA community. Database schema reflection needs pretty much work. Also, I don't have access to anything but IDS

[sqlalchemy] Re: #446: Two deletions cascading to the same object can result in an error

2007-01-29 Thread Michael Bayer
On Jan 29, 8:19 pm, Ian Kelly [EMAIL PROTECTED] wrote: I can live with this response, but I still consider it a bug. If I have to manually remove the instances whenever I delete an object where this exception is possible, then I might as well just be doing the entire cascade for the

[sqlalchemy] Re: Informix SA backend

2007-01-29 Thread Michael Bayer
if you click on the login link near the upper right, and log in with the username/password guest/guest, the view of the ticket will produce a comments box as well as a button in which you can upload attachments. you can attach the file(s) for your implementation, for example. On Jan 29,

[sqlalchemy] work directly with table clauses in transactions?

2007-01-29 Thread Kumar McMillan
I'm trying to work on something where it's necessary to discover table objects and then perform inserts and deletes in a transaction. It's proving very cumbersome to try and locate the existing mappers for these tables or create them automatically so I'm now trying to work directly with