[sqlalchemy] Re: how to display all the tables of my DB

Hi, I've used slightly different approach: sel=SELECT table_name FROM all_tables WHERE owner='XXX' # ORACLE sel=show tables # MySQL sel=SELECT name FROM SQLITE_MASTER WHERE type='table' # SQLite con=dbengine.connect() metadata=DynamicMetaData() tList = con.execute(sel)

[sqlalchemy] Re: Help with saving mapped objects to pylons session

its likely because the process in which you are trying to unpickle does not have the mappers compiled. the mapper compilation step is where the attribute gets added to Invoice at the class level. On Mar 22, 2007, at 8:30 PM, HD Mail wrote: Hi, I am having problems with saving/restoring

[sqlalchemy] Re: alias not used with relationship to arbitary select

I think the issue is you cant put a task_status ordering in your Task mapper since that table is not part of its mapping. http://www.sqlalchemy.org/trac/wiki/ FAQ#ImusinglazyFalsetocreateaJOINOUTERJOINandSQLAlchemyisnotconstructing

[sqlalchemy] Re: ORACLE db name in table definitions

Thanks, it works. On Mar 23, 10:56 am, Michael Bayer [EMAIL PROTECTED] wrote: dont stick foo.bar in your table name. use the schema=DBNAME parameter on your Table. On Mar 23, 2007, at 9:41 AM, vkuznet wrote: Hi, I've got a new DB to handle and the account is setup in a way that I

[sqlalchemy] [PATCH] Filtered one_to_many relationships (Experimental)

Hi list, The recent work that Michael has done about bringing SelectResults functionality to Query made me think: what if that allowed me to do what I've always wanted to have ever since I started using ORMs? The thing I've wanted to do is to have one-to-many relations that you can filter when

[sqlalchemy] Eager loading self referential mapper

Could anyone please explain me a little why self referantial mappers cannot be eager-loading. Is this not yet integrated in SQLAlchemy or theoratically impossible or impractical? Ciao Koen --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: Eager loading self referential mapper

--On 23. März 2007 16:14:26 + Koen Bok [EMAIL PROTECTED] wrote: Could anyone please explain me a little why self referantial mappers cannot be eager-loading. Is this not yet integrated in SQLAlchemy or theoratically impossible or impractical? Do you really want to load a possibly

[sqlalchemy] Re: Eager loading self referential mapper

its not theoretically impossible, but it is theoretically ridiculously complicated to do automatically, and also would have to limit the depth arbitrarily to one or two levels (which means, someone wants level 5 off their eager loader, then they come back to complain). each level of

[sqlalchemy] Re: [PATCH] Filtered one_to_many relationships (Experimental)

OK, this is actually something people have asked for a lot. in the beginning, recently, etc. also for different reasons...i.e. convenience, or performance, etc. So, first off let me start by illustrating how this use case is done right now. Assuming your Address mapper has a

[sqlalchemy] Re: Eager loading self referential mapper

Yeah, I am sure the tree will never be deeper than 3 or 4 levels. Koen On Mar 23, 5:24 pm, Andreas Jung [EMAIL PROTECTED] wrote: --On 23. März 2007 16:14:26 + Koen Bok [EMAIL PROTECTED] wrote: Could anyone please explain me a little why self referantial mappers cannot be

[sqlalchemy] SQLAlchemy 0.3.6 released

This is the first post-Pycon release and includes the new Query object which merges in all of the functionality of SelectResults. More docs have been added, including some description of the new Query methods. The generated documentation has been broken up into separate pages per module,

[sqlalchemy] Video sharing social network Teenwag seeks great Python hackers we ll wear Python T-shirts at startup school $100K $5K sign on $2k referral

Video sharing social network Teenwag seeks great Python hackers we ll wear Python T-shirts at startup school $100K $5K sign on $2k referral http://www.teenwag.com/showvideo/352 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the