I tried to the same py scripts with sqllite and that works fine. The issues seems to be with pyodbc however I am using the version from the site. http://code.google.com/p/pyodbc/downloads/detail?name=pyodbc-2.1.3.win32-py2.6.exe&can=2&q=
My db.py file has all my tables and mappers in it and the columns are defined there and not in the classes. here is my engine/session stuff: engine = create_engine(connection) metadata = MetaData(engine) Session = scoped_session(sessionmaker(bind=engine, autoflush=False, autocommit=True)) On Sun, Apr 5, 2009 at 10:31 PM, Michael Trier <mtr...@gmail.com> wrote: > On Sun, Apr 5, 2009 at 9:46 PM, Michael Bayer <mike...@zzzcomputing.com>wrote: > >> and i would also suggest investigating if the DBAPI you're using is >> somehow different than the one you've used with 2.5, or unsupported on >> py2.6. >> >> On Apr 5, 2009, at 7:59 PM, Michael Mileusnich wrote: >> >> The code used to work in 2.5. A simple add and flush was all I needed to >> do. I tried to use a commit but that did not work either. Am I missing >> something here? >> >> On Sun, Apr 5, 2009 at 4:58 PM, Michael Bayer >> <mike...@zzzcomputing.com>wrote: >> >>> >>> this is not an error, it is only a warning. There should be no >>> difference in behavior between py2.5 and 2.6. The code you have below >>> may not necessarily create any data if you didn't commit your >>> transaction. >>> >>> On Apr 5, 2009, at 6:05 PM, Michael Mileusnich wrote: >>> >>> > I have been working with Python 2.5 and SQLAlchemy. I recently >>> > upgraded to Python 2.6 on my Windows machine and I receive the >>> > following message: >>> > >>> > D:\Python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy >>> > \databases\ms >>> > sql.py:977: DeprecationWarning: object.__new__() takes no parameters >>> > return super(MSSQLDialect, cls).__new__(cls, *args, **kwargs) >>> > >>> > I have a script that creates my tables and inserts data. The tables >>> > get created however they are empty. >>> > >>> > Here is some example code that does not work: >>> > >>> > from sqlalchemy.orm import * >>> > >>> > from db import * >>> > >>> > session = getsession() >>> > >>> > new_serv = server(SERVER = "test") >>> > session.add(new_serv) >>> > session.flush() >>> > >>> > >>> > >>> > > >>> >>> >>> > I'm using the latest pyodbc with 2.6.1 version of python and all tests run > fine. If you provide a test script I can dig into it. > > -- > Michael Trier > http://blog.michaeltrier.com/ > http://thisweekindjango.com/ > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---