@ Michael Bayer,
Sorry forgot to post the new error from the code without elixir, also
there was a problem with the session.commit statement in that last
post. It was supposed to be session.commit() not session.commit.
Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/cherrypy/
_cprequest.py", line 606, in respond
cherrypy.response.body = self.handler()
File "/usr/local/lib/python2.6/dist-packages/cherrypy/
_cpdispatch.py", line 25, in __call__
return self.callable(*self.args, **self.kwargs)
File "WebTest.py", line 124, in index
session.commit()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 673, in commit
self.transaction.commit()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 378, in commit
self._prepare_impl()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 362, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 1354, in flush
self._flush(objects)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 1432, in _flush
flush_context.execute()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
unitofwork.py", line 257, in execute
UOWExecutor().execute(self, tasks)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
unitofwork.py", line 720, in execute
self.execute_save_steps(trans, task)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
unitofwork.py", line 735, in execute_save_steps
self.save_objects(trans, task)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
unitofwork.py", line 726, in save_objects
task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
mapper.py", line 1387, in _save_obj
c = connection.execute(statement.values(value_params), params)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 824, in execute
return Connection.executors[c](self, object, multiparams, params)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 874, in _execute_clauseelement
return self.__execute_context(context)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 896, in __execute_context
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 950, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor,
context)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
OperationalError: (OperationalError) no such table: tests u'INSERT
INTO tests (name) VALUES (?)' ['network+']
Here is the corrected code
Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/cherrypy/
_cprequest.py", line 606, in respond
cherrypy.response.body = self.handler()
File "/usr/local/lib/python2.6/dist-packages/cherrypy/
_cpdispatch.py", line 25, in __call__
return self.callable(*self.args, **self.kwargs)
File "WebTest.py", line 124, in index
session.commit()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 673, in commit
self.transaction.commit()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 378, in commit
self._prepare_impl()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 362, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 1354, in flush
self._flush(objects)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
session.py", line 1432, in _flush
flush_context.execute()
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
unitofwork.py", line 257, in execute
UOWExecutor().execute(self, tasks)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
unitofwork.py", line 720, in execute
self.execute_save_steps(trans, task)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
unitofwork.py", line 735, in execute_save_steps
self.save_objects(trans, task)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
unitofwork.py", line 726, in save_objects
task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/
mapper.py", line 1387, in _save_obj
c = connection.execute(statement.values(value_params), params)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 824, in execute
return Connection.executors[c](self, object, multiparams, params)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 874, in _execute_clauseelement
return self.__execute_context(context)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 896, in __execute_context
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 950, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor,
context)
File "/usr/local/lib/python2.6/dist-packages/sqlalchemy/engine/
base.py", line 931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
OperationalError: (OperationalError) no such table: tests u'INSERT
INTO tests (name) VALUES (?)' ['network+']
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
