2 messages in com.googlegroups.sqlalchemy[sqlalchemy] SQLAlchemy and Interbase...
FromSent OnAttachments
Dariusz Jakubowski31 Jan 2008 01:58 
Lele Gaifax31 Jan 2008 08:19 
Subject:[sqlalchemy] SQLAlchemy and Interbase 7.5
From:Dariusz Jakubowski (dari@gmail.com)
Date:01/31/2008 01:58:07 AM
List:com.googlegroups.sqlalchemy

Im trying to use clause "autoload=True" to automatically read table structure under Interbase 7.5. It does not work. Here is my code:

import sqlalchemy import sqlalchemy.orm engine = sqlalchemy.create_engine('firebird:// SYSDBA:masterkey@localhost:3050/d:/bazy/bw_adriana_old.gdb') engine.connect(); metadata = sqlalchemy.MetaData(engine) tabCountry = sqlalchemy.Table('country', metadata, autoload=True) class Country(object): def __repr__(self): return self.description sqlalchemy.orm.mapper(Country, tabCountry) Session = sqlalchemy.orm.sessionmaker(bind=engine, autoflush=True, transactional=True) [...rest of code...]

While "autoload=True" works with newest version of firebird, it does not with interbase. Is interbase supported in case of using "autoload=True" ? I can manually define all the fields, but i have over 300 tables to define... BTW - im using newest python, newest kinterbasdb, and newest sqlalchemy.