New to this group so, first, Hello to all. I have been trying to work SQLAlchemy into Grok via megrok.rdb, I was able to do it immediately for postgres without issue, and now have been at it for a bit with Oracle and I have some questions/issues.
First, some background: python 2.5.4 grok 1.0 SQLA 0.5.7 and 0.6beta1 megrok.rdb 0.10.0 Here is what I am seeing: For production I will need to connect as user "webserv" who has no ownership at all only select grants, and will only have access to views. Currently, with what I have deciphered for myself, I can't do this. I cannot reflect a view at all, it complains about primary keys which I can understand, but is there a way around this as it's not practical to ask our DBA to put pks on the hundreds of views I will possibly need to access, if he can at all. I can reflect a table as long as I connect as the table owner which as I stated before I will not be able to do. What configuration flag am I missing or parameter I am not passing to make this ok? Is it possible at all? In my reading I get the impression it is but I can't see how. Also. When I do get it to work I get a list of warnings while reflection takes place (when using 0.5.7 this come from base.py): /home/zope/.buildout/eggs/SQLAlchemy-0.6.0-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.0-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.0-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.0-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.0-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.0-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.0-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.0-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.0-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.0-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.0-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.0-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.0-py2.5.egg/sqlalchemy/engine/ reflection.py:40: SAWarning: Did not recognize type 'ROWID' of column 'object_id' ret = fn(self, con, *args, **kw) it takes a very long time for this to finish. Once it's finished the query works and any subsequent page refresh is fast, i.e. it's not being repeated. Hopefully I have explained this well enough. TIA, Jeff Peterson
-- 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.