kportertx wrote: > > @ 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.
ok so, you called create_all() after all modules imported, "test" is created, and that will fix your problem. > > 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 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 -~----------~----~----~----~------~----~------~--~---