[sqlalchemy] Re: how to unit test with SQ

2007-12-18 Thread Paulino
, MetaData, create_engine from sqlalchemy.orm import relation, mapper, create_session mssql = create_engine('mssql://paulino:[EMAIL PROTECTED]/db') metadata = MetaData() metadata.bind = mssql session = create_session(bind=mssql) extratoTab = Table('ttfcmf201100', metadata, Column

[sqlalchemy] Can't insert records into a MS SQL database

2007-10-06 Thread Paulino
perform SET operation. I can insert records with this user account from python with pymssql in any database table, so it is not a permissions issue. Thank you for any help! Paulino PS: Here is the script, the commands i sent from IDLE and the complete traceback: from sqlalchemy import * db

[sqlalchemy] Re: Can't insert records into a MS SQL database

2007-10-06 Thread Paulino
session.flush() 2007-10-06 21:56:08,953 INFO sqlalchemy.engine.base.Engine.0x..f0 BEGIN 2007-10-06 21:56:09,171 INFO sqlalchemy.engine.base.Engine.0x..f0 ROLLBACK Traceback (most recent call last): (...) --~--~-~--~~~---~--~~ You received this message because