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 [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.
