[sqlalchemy] Re: Empty ResultProxy, but SQL statement yields results

2008-12-29 Thread Philip
I apologize, that was a typo. In my script I am actually printing the same variable that I am incrementing. My example should read: print Count: + str(count) The problem is that the printed count is not the actual number of records returned if printed query is run using another MySQL client. I

[sqlalchemy] Re: schema inspection api

2008-12-29 Thread Michael Bayer
Randall's work with reflection is targeted for the 0.6 series. the focus of 0.6 so far is a refactor of engine/dialect organization so that's the best place to put his new features. Work has already started and it will be most of what we're working on once 0.5 is released, which

[sqlalchemy] How to Connect SQL Sever 2005 using sqlalchemy

2008-12-29 Thread Ning
Hi all, I am pretty new for using sqlalcemy. I am able to connect postgre database, but we recently moved data from postgre to SQL sever 2005. I have tried to connect sql sever 2005 as following: DB = sqlalchemy.create_engine('''sql2005://user_name:passw...@server/ database''') Then, i got

[sqlalchemy] Re: Empty ResultProxy, but SQL statement yields results

2008-12-29 Thread Michael Bayer
turn on DEBUG logging for sqlalchemy.engine (also works with create_engine(..., echo='debug') ) and take a look at the rendered SQL as well as the result rows returned. On Dec 29, 2008, at 9:08 AM, Philip wrote: I apologize, that was a typo. In my script I am actually printing the same

[sqlalchemy] Re: ANN: Sprox First Beta Release

2008-12-29 Thread Jorge Vargas
On Mon, Dec 29, 2008 at 4:26 AM, percious perciou...@gmail.com wrote: Sprox is ready for it's first beta release. Now, this release is 0.5b4 because of sprox's heritage, and therefore it's level of maturity. Sprox has a new website up at www.sprox.org. This site is of course generated with

[sqlalchemy] Re: Subqueries as secondary tables

2008-12-29 Thread Michael Bayer
On Dec 29, 2008, at 11:01 AM, Alan Shields wrote: So far so good. I've run into one more problem, though. I'm getting: ProgrammingError: (ProgrammingError) subquery in FROM cannot refer to other relations of same query level when I attempt to eagerload('apples'). So, because I can't

[sqlalchemy] Re: Subqueries as secondary tables

2008-12-29 Thread Alan Shields
On Mon, Dec 29, 2008 at 8:45 AM, Michael Bayer mike...@zzzcomputing.com wrote: dkp_pool is not in the outer FROM list because you've set the FROM clause of the outer query to series of joins which do not include that table. From where would you like the max() function to pull its column ?

[sqlalchemy] Re: Subqueries as secondary tables

2008-12-29 Thread Michael Bayer
On Dec 29, 2008, at 1:53 PM, Alan Shields wrote: My apologies, but I don't see what you're saying. I'm a bit confused how pool_table in the run2pool_a subquery is being turned into a subquery as well when there's an eagerload. I dont either since you've only been sending code fragments

[sqlalchemy] Re: Subqueries as secondary tables

2008-12-29 Thread Michael Bayer
First, tell me if the query I've written below is equivalent to what you're trying to select. The basic idea is that the first nested subquery which joins dkp_run to _last_run_date_by_character is not needed. I'm pretty sure this is the case but you have the more ingrained knowledge of

[sqlalchemy] Re: Subqueries as secondary tables

2008-12-29 Thread Michael Bayer
OK, its true the secondary route with relation() is the only one that works with eagerload, the correlation thing was a false start. Attached is a script illustrating both an eager relation(), as well as an explcit Query approach. The usage of declarative is just a typing saver and is not

[sqlalchemy] Re: Subqueries as secondary tables

2008-12-29 Thread Alan Shields
Perfect! Thank you very much. If you're ever in Portland, Oregon, I owe you a drink. Alan --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: How can I know the state of an instances?

2008-12-29 Thread Chen Houwu
Thanks, I found the the related document here: http://www.sqlalchemy.org/docs/05/session.html?highlight=dirty But from the api refrence, I can't find any clue. On 12月28日, 上午1时23分, Michael Bayer mike...@zzzcomputing.com wrote: if instance in session: do something else: do

[sqlalchemy] Problem about connecting to postgres

2008-12-29 Thread Chen Houwu
I am new to postgres and TG2. I can connect the a postgres database using pgAdminIII with the acount: usernam:chw password:chw Here is the connect string in develepment.ini: sqlalchemy.url=postgres://chw:chw:5...@127.0.0.1/docman but when I run paster setup-app develepment.ini, I got the