BTW, this is using 0.6 beta1 build 6743 on Grok, reflecting a view from an Oracle (10.2) 10g DB.
-- Jeffrey D Peterson Webmaster Crary Industries, Inc. From: sqlalchemy@googlegroups.com [mailto:sqlalch...@googlegroups.com] On Behalf Of Jeff Peterson Sent: Wednesday, February 10, 2010 2:29 PM To: sqlalchemy@googlegroups.com Subject: [sqlalchemy] Warnings take a really long time / NotImplementedError First spin though, I get these errors/warnings: /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'objid' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'LONG RAW' of column 'data' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'source_rowid' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'arowid' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'browid' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'crowid' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'at_rowid' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'drowid' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'row_a' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'row_b' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'row_c' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'textkey' ret = fn(self, con, *args, **kw) /home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'object_id' ret = fn(self, con, *args, **kw) 2010-02-10 14:00:33,891 ERROR [SiteError] http://portal-dev.craryindustries.com/testsa.html Traceback (most recent call last): File "/home/zope/.buildout/eggs/zope.publisher-3.4.9-py2.5.egg/zope/publisher/publish.py", line 133, in publish result = publication.callObject(request, obj) File "/home/zope/.buildout/eggs/grok-1.0-py2.5.egg/grok/publication.py", line 89, in callObject return super(ZopePublicationSansProxy, self).callObject(request, ob) File "/home/zope/.buildout/eggs/zope.app.publication-3.4.3-py2.5.egg/zope/app/publication/zopepublication.py", line 167, in callObject return mapply(ob, request.getPositionalArguments(), request) File "/home/zope/.buildout/eggs/zope.publisher-3.4.9-py2.5.egg/zope/publisher/publish.py", line 108, in mapply return debug_call(obj, args) File "/home/zope/.buildout/eggs/zope.publisher-3.4.9-py2.5.egg/zope/publisher/publish.py", line 114, in debug_call return obj(*args) File "/home/zope/.buildout/eggs/grokcore.view-1.12.2-py2.5.egg/grokcore/view/components.py", line 64, in __call__ return mapply(self.render, (), self.request) File "/home/zope/.buildout/eggs/zope.publisher-3.4.9-py2.5.egg/zope/publisher/publish.py", line 108, in mapply return debug_call(obj, args) File "/home/zope/.buildout/eggs/zope.publisher-3.4.9-py2.5.egg/zope/publisher/publish.py", line 114, in debug_call return obj(*args) File "/home/zope/development/grokenv/projects/portal/src/portal/lib/db/sql_alchemy_test.py", line 30, in render session = rdb.Session() File "/home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/orm/scoping.py", line 52, in __call__ return self.registry() File "build/bdist.linux-i686/egg/sqlalchemy/util.py", line 1225, in __call__ File "/home/zope/.buildout/eggs/z3c.saconfig-0.9.1-py2.5.egg/z3c/saconfig/scopedsession.py", line 12, in session_factory return utility.sessionFactory() File "/home/zope/.buildout/eggs/z3c.saconfig-0.9.1-py2.5.egg/z3c/saconfig/utility.py", line 70, in sessionFactory kw['bind'] = engine_factory() File "/home/zope/.buildout/eggs/z3c.saconfig-0.9.1-py2.5.egg/z3c/saconfig/utility.py", line 165, in __call__ notify(EngineCreatedEvent(engine)) File "/home/zope/.buildout/eggs/zope.event-3.4.0-py2.5.egg/zope/event/__init__.py", line 23, in notify subscriber(event) File "/home/zope/.buildout/eggs/zope.component-3.4.0-py2.5.egg/zope/component/event.py", line 26, in dispatch for ignored in zope.component.subscribers(event, None): File "/home/zope/.buildout/eggs/zope.component-3.4.0-py2.5.egg/zope/component/_api.py", line 130, in subscribers return sitemanager.subscribers(objects, interface) File "/home/zope/.buildout/eggs/zope.component-3.4.0-py2.5.egg/zope/component/registry.py", line 290, in subscribers return self.adapters.subscribers(objects, provided) File "/home/zope/.buildout/eggs/zope.interface-3.4.1-py2.5-linux-i686.egg/zope/interface/adapter.py", line 535, in subscribers subscription(*objects) File "/home/zope/development/grokenv/projects/portal/src/portal/lib/db/oracled.py", line 20, in engine_created rdb.setupDatabase(metadata) File "/home/zope/.buildout/eggs/megrok.rdb-0.10-py2.5.egg/megrok/rdb/setup.py", line 21, in setupDatabase createTables(metadata) File "/home/zope/.buildout/eggs/megrok.rdb-0.10-py2.5.egg/megrok/rdb/setup.py", line 93, in createTables metadata.create_all(engine) File "build/bdist.linux-i686/egg/sqlalchemy/schema.py", line 1934, in create_all File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1403, in create File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1434, in _run_visitor File "build/bdist.linux-i686/egg/sqlalchemy/sql/visitors.py", line 86, in traverse File "build/bdist.linux-i686/egg/sqlalchemy/sql/visitors.py", line 197, in traverse File "build/bdist.linux-i686/egg/sqlalchemy/sql/visitors.py", line 191, in traverse_using File "/home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/ddl.py", line 42, in visit_metadata self.traverse_single(table) File "build/bdist.linux-i686/egg/sqlalchemy/sql/visitors.py", line 76, in traverse_single File "/home/zope/.buildout/eggs/SQLAlchemy-0.6-py2.5.egg/sqlalchemy/engine/ddl.py", line 55, in visit_table self.connection.execute(schema.CreateTable(table)) File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1045, in execute File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 1091, in _execute_ddl File "build/bdist.linux-i686/egg/sqlalchemy/sql/expression.py", line 1262, in compile File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 629, in compile File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 642, in process File "build/bdist.linux-i686/egg/sqlalchemy/sql/visitors.py", line 47, in _compiler_dispatch File "build/bdist.linux-i686/egg/sqlalchemy/sql/compiler.py", line 979, in visit_create_table File "build/bdist.linux-i686/egg/sqlalchemy/sql/compiler.py", line 1063, in get_column_specification File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 685, in process File "build/bdist.linux-i686/egg/sqlalchemy/sql/visitors.py", line 47, in _compiler_dispatch File "build/bdist.linux-i686/egg/sqlalchemy/sql/compiler.py", line 1284, in visit_null NotImplementedError: Can't generate DDL for the null type Then refresh the page and everything works perfectly. Seems like it's reflecting the views properly just running into a couple rough spots. Is there any way to skip/speed up the unrecognized column warnings? Also any insight on the NotImplemented Error? TIA, -- Jeffrey D Peterson Webmaster Crary Industries, Inc. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.