Michael Bayer wrote:
> 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.
There are two tests that need this:
testcompositefk
testmultipk
testbasic also is failing for a different reason - it tries to create a
MSDateTime with too many parameters. I don't have a clue on this one.
Here is the stack trace:
ERROR: testbasic (__main__.ReflectionTest)
----------------------------------------------------------------------
Traceback (most recent call last):
File "engine\reflection.py", line 71, in testbasic
addresses = Table('engine_email_addresses', meta, autoload = True)
File "d:\misc\sqlalchemy\lib\sqlalchemy\schema.py", line 138, in __call__
metadata.engine.reflecttable(table)
File "d:\misc\sqlalchemy\lib\sqlalchemy\engine\base.py", line 491, in
reflecttable
self.dialect.reflecttable(conn, table)
File "d:\misc\sqlalchemy\lib\sqlalchemy\databases\mssql.py", line
475, in reflecttable
remotetable = schema.Table(referred_table, table.metadata,
autoload=True, autoload_with=connection, schema=referred_schema)
File "d:\misc\sqlalchemy\lib\sqlalchemy\schema.py", line 136, in __call__
autoload_with.reflecttable(table)
File "d:\misc\sqlalchemy\lib\sqlalchemy\engine\base.py", line 306, in
reflecttable
return self.__engine.reflecttable(table, connection=self, **kwargs)
File "d:\misc\sqlalchemy\lib\sqlalchemy\engine\base.py", line 491, in
reflecttable
self.dialect.reflecttable(conn, table)
File "d:\misc\sqlalchemy\lib\sqlalchemy\databases\mssql.py", line
413, in reflecttable
coltype = coltype(*args)
TypeError: __init__() takes at most 2 arguments (3 given)
Kent
>
> 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
