Re: [sqlalchemy] Re: InsertFromSelect on SQL server

2011-08-19 Thread Michael Bayer
the attached patch is against r113a7ed95335. Test program is attached, relevant output using PyODBC + FreeTDS: CREATE TABLE t2 ( id INTEGER NOT NULL IDENTITY(1,1), data VARCHAR(50) NULL, PRIMARY KEY (id) ) 2011-08-19 10:34:42,142 INFO sqlalchemy.engine.base.Engine ()

Re: [sqlalchemy] Re: InsertFromSelect on SQL server

2011-08-18 Thread Michael Bayer
On Aug 18, 2011, at 1:19 PM, Massi wrote: > I got: > > File "C:\Python26\lib\site-packages\sqlalchemy-0.7.2-py2.6-win32.egg > \sqlalchemy\engine\base.py", line 2285, in execute >return connection.execute(statement, *multiparams, **params) > File "C:\Python26\lib\site-packages\sqlalchemy-0

Re: [sqlalchemy] Re: InsertFromSelect on SQL server

2011-08-18 Thread Michael Bayer
On Aug 18, 2011, at 1:06 PM, Massi wrote: > I changed the code to (SA 0.7.2 with pyodbc2.1.9): > > class InsertFromSelect(Executable, ClauseElement) : >_execution_options =\ > > Executable._execution_options.union({'autocommit': True}) >def __init__(self, table, select) : >self.