[sqlalchemy] how to run a stored procedure?

2010-07-15 Thread Lukasz Szybalski
Hello, I need to get data out of sqlserver by running this stored procedure. From there I convert few fields and add the processed rows to a mysql table that I have created. How can I do the following in sqlalchemy? Is there a pythonic way? Assuming I already have the database connection? What

Re: [sqlalchemy] how to run a stored procedure?

2010-07-15 Thread David Gardner
take a look at: http://www.sqlalchemy.org/docs/reference/sqlalchemy/expressions.html?highlight=sql.func#sqlalchemy.sql.expression.func On 07/15/2010 12:29 PM, Lukasz Szybalski wrote: Hello, I need to get data out of sqlserver by running this stored procedure. From there I convert few fields

[sqlalchemy] How to run a stored procedure?

2009-05-08 Thread Daniel
Hello, I've created a stored procedure in MSSQL. I'm not sure how to use it in SQLAlchemy. The stored procedure is called 'claim_highest_priority_work' and I can call it directly as follows: result = conn.execute('claim_highest_priority_work') I know it runs because I see the result in the