Has anyone successfully executed an insert\\delete SQL statement to a SQL database via Python in the Shutdown Script?
Question
Connect and execute Microsoft SQL on Python Shutdown Script
+1This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Have a look at using the pyodbc module, see also this discussion on StackOverflow: https://stackoverflow.com/a/33787509
The SQL Server writers also have a parameter you can set, containing a SQL command to execute at the end:
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.