in Python/length_of_stay_utils.py [0:0]
def alter_column(table, column, data_type, connection_string):
pyodbc_cnxn = pyodbc.connect(connection_string)
pyodbc_cursor = pyodbc_cnxn.cursor()
pyodbc_cursor.execute("ALTER TABLE {} ALTER COLUMN {} {};".format(table, column, data_type))
pyodbc_cursor.close()
pyodbc_cnxn.commit()
pyodbc_cnxn.close()