Im dveloping an app with Pylons and using sqlalchemy reflection on a postgres db. It all seems to work so far, but when I run tests using nose I get the following error
Traceback (most recent call last): File "/home/webjunkie/www/env/bin/nosetests", line 8, in <module> load_entry_point('nose==0.11.3', 'console_scripts', 'nosetests')() File "/home/webjunkie/www/env/lib/python2.6/site-packages/ nose-0.11.3- py2.6.egg/nose/core.py", line 117, in __init__ **extra_args) File "/usr/lib/python2.6/unittest.py", line 816, in __init__ self.parseArgs(argv) File "/home/webjunkie/www/env/lib/python2.6/site-packages/ nose-0.11.3- py2.6.egg/nose/core.py", line 134, in parseArgs self.config.configure(argv, doc=self.usage()) File "/home/webjunkie/www/env/lib/python2.6/site-packages/ nose-0.11.3- py2.6.egg/nose/config.py", line 324, in configure self.plugins.begin() File "/home/webjunkie/www/env/lib/python2.6/site-packages/ nose-0.11.3- py2.6.egg/nose/plugins/manager.py", line 93, in __call__ return self.call(*arg, **kw) File "/home/webjunkie/www/env/lib/python2.6/site-packages/ nose-0.11.3- py2.6.egg/nose/plugins/manager.py", line 161, in simple result = meth(*arg, **kw) File "/home/webjunkie/www/env/lib/python2.6/site-packages/ Pylons-1.0- py2.6.egg/pylons/test.py", line 74, in begin relative_to=path) File "/home/webjunkie/www/env/lib/python2.6/site- packages/PasteDeploy-1.3.3-py2.6.egg/paste/deploy/loadwsgi.py", line 204, in loadapp return loadobj(APP, uri, name=name, **kw) File "/home/webjunkie/www/env/lib/python2.6/site- packages/PasteDeploy-1.3.3-py2.6.egg/paste/deploy/loadwsgi.py", line 225, in loadobj return context.create() File "/home/webjunkie/www/env/lib/python2.6/site- packages/PasteDeploy-1.3.3-py2.6.egg/paste/deploy/loadwsgi.py", line 625, in create return self.object_type.invoke(self) File "/home/webjunkie/www/env/lib/python2.6/site- packages/PasteDeploy-1.3.3-py2.6.egg/paste/deploy/loadwsgi.py", line 110, in invoke return fix_call(context.object, context.global_conf, **context.local_conf) File "/home/webjunkie/www/env/lib/python2.6/site- packages/PasteDeploy-1.3.3-py2.6.egg/paste/deploy/util/ fixtypeerror.py", line 57, in fix_call val = callable(*args, **kw) File "/var/www/Mascotitas/mascotitas/config/middleware.py", line 37, in make_app config = load_environment(global_conf, app_conf) File "/var/www/Mascotitas/mascotitas/config/environment.py", line 49, in load_environment init_model(engine) File "/var/www/Mascotitas/mascotitas/model/__init__.py", line 89, in init_model user_table = schema.Table('users', Base.metadata, autoload=True, autoload_with=engine) File "/home/webjunkie/www/env/lib/python2.6/site- packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/schema.py", line 209, in __new__ table._init(name, metadata, *args, **kw) File "/home/webjunkie/www/env/lib/python2.6/site- packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/schema.py", line 257, in _init include_columns=include_columns) File "/home/webjunkie/www/env/lib/python2.6/site- packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/base.py", line 1863, in reflecttable self.dialect.reflecttable(conn, table, include_columns) File "/home/webjunkie/www/env/lib/python2.6/site- packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/default.py", line 228, in reflecttable return insp.reflecttable(table, include_columns) File "/home/webjunkie/www/env/lib/python2.6/site- packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/reflection.py", line 411, in reflecttable raise exc.NoSuchTableError(table.name) sqlalchemy.exc.NoSuchTableError: users Nose is configured to use an sqlite db. My model init is as follows Session.configure(bind=engine, autoflush=True, autocommit=False) Base.metadata.reflect(bind=engine) user_table = schema.Table('users', Base.metadata, autoload=True, autoload_with=engine) orm.mapper(User, user_table) Im using sqlalchemy 6.5 what could be the problem?. Any help is appreciated. -- 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.