I am unable to create a view if I put a where condition See below for
error. However I am able to create a view if I do not have a where
condition. Any idea why this restriction is posed by Sql Alchemy?
=====================================================================
mySelect = select([table], table.c.vt_start == '20101211')
engine.execute("CREATE TEMP VIEW myview AS %s" %
mySelect.compile(engine));
==================================================================
Stack Trace:
=========
engine.execute("CREATE TEMP VIEW myview AS %s" %
mySelect.compile(engine));
File "/prod/tools/infra/SQLAlchemy-0.5.5-py2.5.egg/sqlalchemy/engine/
base.py", line 824, in execute
return Connection.executors[c](self, object, multiparams, params)
File "/prod/tools/infra/SQLAlchemy-0.5.5-py2.5.egg/sqlalchemy/engine/
base.py", line 888, in _execute_text
return self.__execute_context(context)
File "/prod/tools/infra/SQLAlchemy-0.5.5-py2.5.egg/sqlalchemy/engine/
base.py", line 896, in __execute_context
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File "/prod/tools/infra/SQLAlchemy-0.5.5-py2.5.egg/sqlalchemy/engine/
base.py", line 950, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor,
context)
File "/prod/tools/infra/SQLAlchemy-0.5.5-py2.5.egg/sqlalchemy/engine/
base.py", line 931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exc.OperationalError: (OperationalError) parameters are not
allowed in views 'CREATE TEMP VIEW myview AS SELECT eee.z,
eee.tt_start, eee.tt_end, eee.vt_start, eee.vt_end \nFROM eee \nWHERE
eee.vt_start = ?' ()
--
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.
