python执行多条sql语句,用多个用“;”分隔的语句执行SQL文件。使用pyodbc

I am currently writing a script to run multiple SQL files using Python, a little background before you mention alternative methods; this is to automate the scripts and Python is the only tools I have on our windows 2008 server. I have a script that works for one set but the issue is when the other set has two statements instead of one seperated by a ';' here is my code:

import os

import pyodbc

print ("Connecting via ODBC")

conn = pyodbc.connect('DSN=dsn', autocommit=True)

print ("Connected!\n")

inputdir = 'C:\\path'

cursor = conn.cursor()

for script in os.listdir(inputdir):

with open(inputdir+'\\' + script,'r') as inserts:

sqlScript = inserts.readlines()

sql = (" ".join(sqlScript))

cursor.execute(sql)<