hi there,
when I try to reflect a postges db like this:
Base2 = declarative_base(engine)
Base2.metadata.reflect()
I get a key error (see below).
however, if I define its class using autoload, things are fine
class dokstatus(Base2):
#__table__ = tables2["dokstatus"]
__tablename__ = 'dokstatus'
__autoload__ = True
__table_args__ = {'autoload_with' : engine}
there are many other tables (some 120) in the database and I do not know
which table is the culprit.
Now my questions:
- how can I "fix" the error
- is there a way to selectively reflect tables?
thanks
robert
File
"/home/zope/ruagaeroV2/eggs/SQLAlchemy-0.5.1-py2.4.egg/sqlalchemy/engine/base.py",
line 1265, in reflecttable
self.dialect.reflecttable(conn, table, include_columns)
File
"/home/zope/ruagaeroV2/eggs/SQLAlchemy-0.5.1-py2.4.egg/sqlalchemy/databases/postgres.py",
line 656, in reflecttable
schema.Index(name, *[table.columns[c] for c in columns],
File
"/home/zope/ruagaeroV2/eggs/SQLAlchemy-0.5.1-py2.4.egg/sqlalchemy/util.py",
line 634, in __getitem__
return self._data[key]
zope.configuration.xmlconfig.ZopeXMLConfigurationError: File
"/home/zope/ruagaeroV2/parts/instance/etc/site.zcml", line 14.2-14.55
ZopeXMLConfigurationError: File
"/home/zope/ruagaeroV2/parts/instance/etc/package-includes/003-ruagaero.intradevcontent-configure.zcml",
line 1.0-1.68
KeyError: u'oid'
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
