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 ()

[sqlalchemy] Re: InsertFromSelect on SQL server

2011-08-19 Thread Massi
Mike, I tried to apply the new patch but it was rejected (working on windows 7 and using patch from GnuWin32); it seems that the target lines in you patch are misaligned with those in my SA source files. I tried to make the changes by hand, but I could not get it working. I still get the 'postfetch

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

[sqlalchemy] Re: InsertFromSelect on SQL server

2011-08-18 Thread Massi
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.7.2-py2.6-win32.egg \sqlalchemy\engine\base.py", line

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.

[sqlalchemy] Re: InsertFromSelect on SQL server

2011-08-18 Thread Massi
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.table = table self.select = select @compiler.co