MS-SQL doesnt seem to support composite primary keys. the composite
pk test in "reflection" should get a @testbase.unsupported('mssql')
added to it so that it doesnt run.
On Sep 10, 2006, at 6:30 PM, Kent Johnson wrote:
> Kent Johnson wrote:
>> Michael Bayer wrote:
>>> SQLAlchemy should be working with a DBAPI that has auto-commit
>>> turned off; this is because the Connection object supports its
>>> own "auto commit" feature.
>> OK, I'll look into reworking mssql to assume that adodbapi
>> connects to a DB with autocommit off.
>
> I have a version of mssql that works OK with an unmodified adodbapi
> - at least it commits changes!
>
> The reflection stuff is still problematic - even with the cursor
> change there are problems detecting identity fields and some of the
> reflect unit tests fail with errors like
> Multiple identity columns specified for table 'engine_multi'. Only
> one identity column per table is allowed.
>
> pymssql has the same problems with the reflection test...
>
> I'm not sure what to do with the changes?? I can put a diff
> somewhere but it will have the changes for datatypes also. Should I
> just make a new Trac ticket and upload the patch there?
>
> Kent
>
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
