[sqlalchemy] ResourceClosedError

2011-11-06 Thread AZ (Wei-Ning Huang)
Hi list, I've been getting ResoruceClosedError with MySQL server, which worked fine with SQLite. I'am using Celery queue, and those erros always happen within the celery tasks. @celery.task def do_something(): records = SomeTable.pop_timeout() and for SomeTable.pop_timeout(),

Re: [sqlalchemy] ResourceClosedError

2011-11-06 Thread Wei-Ning Huang
Hi Michael, Thanks for the quick and detailed reply, but I still have some questions. 2011/11/6 Michael Bayer mike...@zzzcomputing.com On Nov 6, 2011, at 3:54 AM, AZ (Wei-Ning Huang) wrote: Hi list, I've been getting ResoruceClosedError with MySQL server, which worked fine

Re: [sqlalchemy] ResourceClosedError

2011-11-06 Thread Wei-Ning Huang
Hi Michael, 2011/11/7 Michael Bayer mike...@zzzcomputing.com On Nov 6, 2011, at 8:41 AM, Wei-Ning Huang wrote: db.query(Table).filter(...).update({'stamp': stamp}) db.commit() results = db.query(Table).filter_by(stamp=stamp).all() # ResourceClosedError raised here

[sqlalchemy] How to search a particular hour?

2010-02-18 Thread Ning
: (NotSupportedError) ('Python type Function not supported.) can any one help me on this? Ning -- 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 email

[sqlalchemy] Re: How to import different version of SQLachlemy?

2009-12-09 Thread Ning
thank so much! It sloved the problem. I think the reason for my previous script not working is because i try to import different package in one windows. Thanks again for all of your help! Ning On Dec 9, 9:30 am, werner wbru...@free.fr wrote: Ning wrote: Hello I am new to python. I have

[sqlalchemy] Why my python script can use in the server but not from the client machine?

2009-12-09 Thread Ning
Hi I have written a script connect a table in the database. It works perfectly when I was doing the testing in the sever. But i am not able to connect from the client. The client login has the same premission as the loginning account in the sever. Any thoughts. Please see my script below: In

[sqlalchemy] How to import different version of SQLachlemy?

2009-12-08 Thread Ning
info here 529 requirements.extend(dist.requires(req.extras)[::-1]) 530 processed[req] = True VersionConflict: (sqlalchemy 0.4.0 (c:\pythonxy\python26\lib\site- packages\sqlalchemy-0.4.0-py2.6.egg), Requirement.parse ('sqlalchemy==0.5.6')) any help will be more than welcome. :D Ning -- You received

[sqlalchemy] Re: How to Connect SQL Sever 2005 using sqlalchemy

2008-12-30 Thread Ning
In addition to the previous email, pyodbc is also required. Otherwise, sqlalchemy will not extract data from MS SQL sever 2005. On Dec 30, 9:42 am, Ning station.n...@gmail.com wrote: thank you so much. I have changed sql2005 to msql. then, it works perfectly now. many thanks again. Ning

[sqlalchemy] How to Connect SQL Sever 2005 using sqlalchemy

2008-12-29 Thread Ning
94 def translate_connect_args(self, names): ImportError: unknown database 'sql2005' It will be so thankful, if there is any one could help! Many thanks! Ning --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups