Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sql = [ u"ALTER TABLE {tab_mc} ADD bez_UR number(38,8)".format(tab_mc = mc_results),
- u"UPDATE TP_MC_STAT set test_col = 1000",
- # u"DROP TABLE TP_MC_STAT", ##WHEN TABLE IS NOT DELETED, NEXT SQL RAISE AN EXCEPTION
- u"CREATE TABLE TP_MC_STAT (test_col int)",
- u"UPDATE TP_MC_STAT set test_col = 4"]
- sde_connector.startTransaction()
- for row in sql:
- try:
- sde_connector.execute(row)
- except Exception as err:
- raise Exception(row," ...>>>... ",err.message)
- sde_connector.commitTransaction()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement