This seems like a shot in the dark, but maybe someone familiar with pylons and/or SQL alchemy can answer this question for me:
Can SQL Alchemy create a class from the results of a stored procedure (particularly with MSSQL)? I can't find any documentation demonstrating the usage of stored procedures in the docs (although they say they can be used...) and googling hasn't turned up much. Unfortunately I don't have the option of not using stored procedures, either. Suggestions?
Background: I have access to a database almost exclusively through stored procedures. Some stored procedures just return values, some return single results (one row one column), and some return tabular data. I really don't get access to the source of the sprocs or direct access to the tables.
Question
Vlad
This seems like a shot in the dark, but maybe someone familiar with pylons and/or SQL alchemy can answer this question for me:
Can SQL Alchemy create a class from the results of a stored procedure (particularly with MSSQL)? I can't find any documentation demonstrating the usage of stored procedures in the docs (although they say they can be used...) and googling hasn't turned up much. Unfortunately I don't have the option of not using stored procedures, either. Suggestions?
Background: I have access to a database almost exclusively through stored procedures. Some stored procedures just return values, some return single results (one row one column), and some return tabular data. I really don't get access to the source of the sprocs or direct access to the tables.
Link to comment
Share on other sites
0 answers to this question
Recommended Posts