[sqlalchemy] Many tables in eagerloading

2007-09-04 Thread Arun Kumar PG
Guys, Was wondering if we have 10 tables or so which are related to each other and are required during let's say report generation then if I specify eagerloading for all those attributes which are related to these tables then down the line as the records in the table grows the temp tables

[sqlalchemy] Elixir performance

2007-09-04 Thread Acm
I am trying out Elixir 0.3.0 over SQLAlchemy 0.3.10 in a Python 2.5 environment. Are there any known performance issues with Elixir for CRUD (Create Select Update Delete) commands? Thanks. --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: Elixir performance

2007-09-04 Thread Gaetan de Menten
On 9/4/07, Acm [EMAIL PROTECTED] wrote: I am trying out Elixir 0.3.0 over SQLAlchemy 0.3.10 in a Python 2.5 environment. Are there any known performance issues with Elixir for CRUD (Create Select Update Delete) commands? Not that I know of. There shouldn't be any overhead (over raw

[sqlalchemy] Re: Many tables in eagerloading

2007-09-04 Thread Michael Bayer
On Sep 4, 2007, at 2:56 AM, Arun Kumar PG wrote: Guys, Was wondering if we have 10 tables or so which are related to each other and are required during let's say report generation then if I specify eagerloading for all those attributes which are related to these tables then down

[sqlalchemy] Re: FormAlchemy 0.1 released !

2007-09-04 Thread Alexandre Conrad
Hello, html = fa.FieldRender(bind=client, column='email').render() Nicely done, Alexandre! I see you are already planning to support input validation. Are you thinking of supporting alternate layouts such as a table grid? Yes, I'm working on validation right now. I'm reorganizing the

[sqlalchemy] Re: Many tables in eagerloading

2007-09-04 Thread svilen
On Tuesday 04 September 2007 17:12:26 Arun Kumar PG wrote: Good work svilan! couple questions from what you suggested: skipping creation of objects - only using the data, if time of creation gets critical. In my query wherein the eagerloading is being done on 8 tables if I manually run

[sqlalchemy] Re: adjacency list: filtering relations eagerly

2007-09-04 Thread stephen emslie
im going to play with this a little bit, but my first instinct is that you might want to use contains_eager('children.children', ...) for your deeper aliases. but im not sure if something might prevent that from working since i havent tested contains_eager in self- referential scenarios as

[sqlalchemy] Re: Many tables in eagerloading

2007-09-04 Thread Michael Bayer
On Sep 4, 2007, at 10:15 AM, Arun Kumar PG wrote: i thought so earlier but unfortunately i am on a lower version of mysql :( upgrade. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] max() arg is an empty sequence while trying to reflect bugzilla table (detailed diagnostics)max() arg is an empty sequence while trying to reflect bugzilla table (detailed diagnostics)

2007-09-04 Thread Marcin Kasperski
Test made on 0.4.0beta5. I tried to reflect the table from some well known application (bugzilla bugs table) from sqlalchemy import * db = create_engine('mysql://%s:[EMAIL PROTECTED]/bugs' % (username, password) ) metadata = MetaData(bind = db) bugs = Table('bugs', metadata, autoload =

[sqlalchemy] Re: creating a database through SQLAlchemy

2007-09-04 Thread Travis Kriplean
Thanks everyone! On 3 Sep, 01:13, Marco Mariani [EMAIL PROTECTED] wrote: TravisKriplean ha scritto: However, this seems a bit ugly. Is there a way to obtain a non- transactional connection from an engine in 0.3.10? If not, is it possible in 0.4? I use this with SA 0.3.10 and Postgres:

[sqlalchemy] Check it out:download free,stock information,knowledge base,hot videos,hot games and hot tickets...

2007-09-04 Thread iamhere
Check it out:download free,stock information,knowledge base,hot videos,hot games and hot tickets... http://groups.google.com/group/all-good-things/web/very-useful-websites --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Re: Many tables in eagerloading

2007-09-04 Thread Arun Kumar PG
bit tough as many apps on that server and won't be easy as of now. On 9/4/07, Michael Bayer [EMAIL PROTECTED] wrote: On Sep 4, 2007, at 10:15 AM, Arun Kumar PG wrote: i thought so earlier but unfortunately i am on a lower version of mysql :( upgrade. -- Cheers, - A