[sqlalchemy] Query Object

2010-03-08 Thread Paulo Aquino
Are there performance difference between the following line of codes. a. for instance in Query: -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send

[sqlalchemy] Performance Difference

2010-03-08 Thread Paulo Aquino
Are there performance difference between the following line of codes. a. for instance in Query: print instance.id b. for instance in Query.all(): print instance.id -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group,

[sqlalchemy] Re: Self Join

2009-09-16 Thread Paulo Aquino
On Tue, Sep 15, 2009 at 5:53 AM, Michael Bayer mike...@zzzcomputing.comwrote: Paulo Aquino wrote: I have 2 tables 'Product' and 'ProductPrice'. I want to get all valid products, a product is valid if it has both a valid 'Selling' and 'Buying' ProductPrice type. A ProductPrice is valid

[sqlalchemy] Re: Self Join

2009-09-16 Thread Paulo Aquino
On Tue, Sep 15, 2009 at 5:53 AM, Michael Bayer mike...@zzzcomputing.comwrote: Paulo Aquino wrote: I have 2 tables 'Product' and 'ProductPrice'. I want to get all valid products, a product is valid if it has both a valid 'Selling' and 'Buying' ProductPrice type. A ProductPrice is valid

[sqlalchemy] Self Join

2009-09-14 Thread Paulo Aquino
I have 2 tables 'Product' and 'ProductPrice'. I want to get all valid products, a product is valid if it has both a valid 'Selling' and 'Buying' ProductPrice type. A ProductPrice is valid if the valid_from date = date.today() and valid_to = date.today(). Product Table: id | sku | principal

[sqlalchemy] Self Join

2009-09-14 Thread Paulo Aquino
I have 2 tables 'Product' and 'ProductPrice'. I want to get all valid products, a product is valid if it has both a valid 'Selling' and 'Buying' ProductPrice type. A ProductPrice is valid if the valid_from date = date.today() and valid_to = date.today(). Product Table: id | sku | principal

[sqlalchemy] @propert

2009-09-10 Thread Paulo Aquino
I add a python property to my class, can i make this query able? Anyone knows of a good sample on how to do this, I would really appreciate. rgds, Paulo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] Re: http://www.sqlalchemy.org/docs/05/ormtutorial.html

2009-09-03 Thread Paulo Aquino
I guess it's ipython cause when I tried saving the tutorial source code in a file and run python .py everything is working fine. Yeah you're right seems ridiculous. :) On Thu, Sep 3, 2009 at 11:10 PM, Mike Conley mconl...@gmail.com wrote: Any chance this is the second iteration of declaring