![]() ![]() ![]() Copy and paste the following example into the query window and click Execute.This example creates the same stored procedure as above using a different procedure name. Which driver are you using and version of it (Ex: PostgreSQL 10.0): PostgreSQL v11. What could be preventing this from happening via Python? Does the executed SQL need to be committed? Is there a way to debug using the ResultProxy that is returned? Any advice here would be appreciated. In Object Explorer, connect to an instance of Database Engine. This is a TablePlus plugin which add copy table creation menu in left panel JavaScript 85 MIT 14 9 (1 issue needs help) 8 Updated Jul 20, 2022. How should I understand what is not working correctly in the above setup in order to properly debug? I literally run the exact same code through my database admin tool with no issues - the stored procedures execute as expected. Support estimate rows (TablePlus will estimate rows instead of count () while loading a large table). However, even though no errors are returned after running the above code in Python, when I check the database, I confirm that nothing has been executed (what is more telling is that the above commands take one or two seconds to complete whereas running these stored procedures successfully on the database admin tool takes about 5 minutes). 'DRIVER='ĭb_engine = create_engine(connection_string)ĭb_engine.execute("EXEC. ![]() After modifying my code to what is below, I am able to connect and run execute() from the db_engine that I created. I learned from a helpful post on StackOverflow about how to call stored procedures on SQL Server in python (pyodbc). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |