[sqlalchemy] Performance Difference

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] Query Object

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, sen

[sqlalchemy] Re: Self Join

On Tue, Sep 15, 2009 at 5:53 AM, Michael Bayer wrote: > > 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' >

[sqlalchemy] Re: Self Join

On Tue, Sep 15, 2009 at 5:53 AM, Michael Bayer wrote: > > 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' >

[sqlalchemy] Self Join

thing I did in my Raw SQL solution no. 2 I've been trying but getting weird results. If someone can please help me, here's my test case http://pastebin.com/m3f8a95c8 rgds, Paulo --~--~-~--~~~---~--~~ You received this message because you are subscribed to th

[sqlalchemy] Self Join

thing I did in my Raw SQL solution no. 2 I've been trying but getting weird results. If someone can please help me, here's is my test case http://pastebin.com/m3f8a95c8 rgds, Paulo --~--~-~--~~~---~--~~ You received this message because you are subscribed to th

[sqlalchemy] @propert

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 "sqlal

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

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 wrote: > Any chance this is the second iteration of declaring the User class in

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

rgumentError: Mapper Mapper|User|users could not assemble any primary key columns for mapped table 'users' Any ideas why this happens? rgds, Paulo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "

[sqlalchemy] Re: Errors on using Postgres' COPY FROM

Thanks a lot. I will check it. Paulo On Mon, May 25, 2009 at 6:19 PM, Michael Bayer wrote: > > As I said, the issue lies with the usage of the psycopg2 dbapi.  Write > a test case using only psycopg2: > > import psycopg2 > conn = psycopg2.connect(user=user, passwd=

[sqlalchemy] Re: Errors on using Postgres' COPY FROM

tab delimited files to input, and the command fails with different types of inputs, integer, floats, etc. A larger file also fails in the middle, a shorter file also fails. Testing all the possible input sizes on psql, everything is smooth and the inputs are accepted. Thanks Paulo Michael