Hi,
That fixed that issue. However, now I'm getting an error that my 2nd
table doesn't exist:
sqlalchemy.exc.NoSuchTableError: tableTwo
This is weird since it's been around since 2007 and has lots of data
in it. I tried changing the name to all lowercase and all uppercase,
but the error remains the same. I also tried removing the schema line
to no avail.
Here's the complete traceback:
File "D:\pyRetention\Scripts\paster", line 5, in <module>
pkg_resources.run_script('pastescript==1.7.3', 'paster')
File "c:\Python25\Lib\site-packages\pkg_resources.py", line 448, in
run_script
self.require(requires)[0].run_script(script_name, ns)
File "c:\Python25\Lib\site-packages\pkg_resources.py", line 1166, in
run_script
execfile(script_filename, namespace, namespace)
File "c:\Python25\Lib\site-packages\pastescript-1.7.3-py2.5.egg\EGG-
INFO\scripts\paster", line 18, in <module>
command.run()
File "c:\Python25\Lib\site-packages\pastescript-1.7.3-py2.5.egg\paste
\script\command.py", line 84, in run
invoke(command, command_name, options, args[1:])
File "c:\Python25\Lib\site-packages\pastescript-1.7.3-py2.5.egg\paste
\script\command.py", line 123, in invoke
exit_code = runner.run(args)
File "c:\Python25\Lib\site-packages\pastescript-1.7.3-py2.5.egg\paste
\script\command.py", line 218, in run
result = self.command()
File "c:\Python25\Lib\site-packages\pastescript-1.7.3-py2.5.egg\paste
\script\serve.py", line 276, in command
relative_to=base, global_conf=vars)
File "c:\Python25\Lib\site-packages\pastescript-1.7.3-py2.5.egg\paste
\script\serve.py", line 313, in loadapp
**kw)
File "c:\Python25\Lib\site-packages\pastedeploy-1.3.3-py2.5.egg\paste
\deploy\loadwsgi.py", line 204, in loadapp
return loadobj(APP, uri, name=name, **kw)
File "c:\Python25\Lib\site-packages\pastedeploy-1.3.3-py2.5.egg\paste
\deploy\loadwsgi.py", line 225, in loadobj
return context.create()
File "c:\Python25\Lib\site-packages\pastedeploy-1.3.3-py2.5.egg\paste
\deploy\loadwsgi.py", line 625, in create
return self.object_type.invoke(self)
File "c:\Python25\Lib\site-packages\pastedeploy-1.3.3-py2.5.egg\paste
\deploy\loadwsgi.py", line 110, in invoke
return fix_call(context.object, context.global_conf,
**context.local_conf)
File "c:\Python25\Lib\site-packages\pastedeploy-1.3.3-py2.5.egg\paste
\deploy\util\fixtypeerror.py", line 57, in fix_call
val = callable(*args, **kw)
File "D:\pyRetention\pyRetention\pyretention\config\middleware.py",
line 35, in make_app
app = make_base_app(global_conf, full_stack=True, **app_conf)
File "c:\Python25\Lib\site-packages\turbogears2-2.0-py2.5.egg\tg
\configuration.py", line 588, in make_base_app
load_environment(global_conf, app_conf)
File "c:\Python25\Lib\site-packages\turbogears2-2.0-py2.5.egg\tg
\configuration.py", line 438, in load_environment
self.setup_sqlalchemy()
File "c:\Python25\Lib\site-packages\turbogears2-2.0-py2.5.egg\tg
\configuration.py", line 393, in setup_sqlalchemy
self.package.model.init_model(engine)
File "d:\pyRetention\pyRetention\pyretention\model\__init__.py", line
70, in init_model
autoload=True, autoload_with=engine)
File "c:\Python25\Lib\site-packages\sqlalchemy-0.5.4p2-py2.5.egg
\sqlalchemy\schema.py", line 113, in __call__
return type.__call__(self, name, metadata, *args, **kwargs)
File "c:\Python25\Lib\site-packages\sqlalchemy-0.5.4p2-py2.5.egg
\sqlalchemy\schema.py", line 239, in __init__
autoload_with.reflecttable(self, include_columns=include_columns)
File "c:\Python25\Lib\site-packages\sqlalchemy-0.5.4p2-py2.5.egg
\sqlalchemy\engine\base.py", line 1265, in reflecttable
self.dialect.reflecttable(conn, table, include_columns)
File "c:\Python25\Lib\site-packages\sqlalchemy-0.5.4p2-py2.5.egg
\sqlalchemy\databases\mssql.py", line 1255, in reflecttable
raise exc.NoSuchTableError(table.name)
What do you think? MS SQL being stupid? Thanks for your help.
- Mike
On Jun 3, 2:51 pm, "Michael Bayer" <mike...@zzzcomputing.com> wrote:
> the MSSQL has had a lot of fixes over the course of 0.5 so definitely get
> on the latest 0.5 first.
>
> Mike wrote:
>
> > Hi,
>
> > I am working on a TurboGears 2 application that uses SqlAlchemy 0.5.1.
> > I am using reflection and am having a lot of trouble with it. Anyway,
> > here's the error I am getting:
>
> > Traceback (most recent call last):
> > File "V:\PythonPackages\Development\pyRetention\Scripts\paster-
> > script.py", line 8, in <module>
> > load_entry_point('pastescript==1.7.3', 'console_scripts', 'paster')
> > ()
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \pastescript-1.7.3-py2.5.egg\past
> > e\script\command.py", line 84, in run
> > invoke(command, command_name, options, args[1:])
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \pastescript-1.7.3-py2.5.egg\past
> > e\script\command.py", line 123, in invoke
> > exit_code = runner.run(args)
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \pastescript-1.7.3-py2.5.egg\past
> > e\script\appinstall.py", line 68, in run
> > return super(AbstractInstallCommand, self).run(new_args)
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \pastescript-1.7.3-py2.5.egg\past
> > e\script\command.py", line 218, in run
> > result = self.command()
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \pastescript-1.7.3-py2.5.egg\past
> > e\script\appinstall.py", line 456, in command
> > self, config_file, section, self.sysconfig_install_vars
> > (installer))
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \pastescript-1.7.3-py2.5.egg\past
> > e\script\appinstall.py", line 598, in setup_config
> > mod.setup_app, command, filename, section, vars)
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \pastescript-1.7.3-py2.5.egg\past
> > e\script\appinstall.py", line 612, in _call_setup_app
> > func(command, conf, vars)
> > File "D:\pyRetention\pyRetention\pyretention\websetup.py", line 18,
> > in setup_app
> > load_environment(conf.global_conf, conf.local_conf)
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \turbogears2-2.0-py2.5.egg\tg\con
> > figuration.py", line 438, in load_environment
> > self.setup_sqlalchemy()
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \turbogears2-2.0-py2.5.egg\tg\con
> > figuration.py", line 393, in setup_sqlalchemy
> > self.package.model.init_model(engine)
> > File "D:\pyRetention\pyRetention\pyretention\model\__init__.py",
> > line 64, in init_model
> > autoload_with=engine)
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \sqlalchemy-0.5.1-py2.5.egg\sqlal
> > chemy\schema.py", line 113, in __call__
> > return type.__call__(self, name, metadata, *args, **kwargs)
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \sqlalchemy-0.5.1-py2.5.egg\sqlal
> > chemy\schema.py", line 239, in __init__
> > autoload_with.reflecttable(self, include_columns=include_columns)
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \sqlalchemy-0.5.1-py2.5.egg\sqlal
> > chemy\engine\base.py", line 1265, in reflecttable
> > self.dialect.reflecttable(conn, table, include_columns)
> > File "v:\pythonpackages\development\pyretention\lib\site-packages
> > \sqlalchemy-0.5.1-py2.5.egg\sqlal
> > chemy\databases\mssql.py", line 1157, in reflecttable
> > coltype = coltype(*args, **kwargs)
> > TypeError: __init__() takes at most 2 arguments (3 given)
>
> > I'm not sure what it is talking about. Here are my sample tables
> > though:
>
> > tbl_checks = Table("tableOne", metadata, autoload=True,
> > autoload_with=engine)
> > mapper(Checks, tbl_checks)
>
> > tbl_test = Table("tableTwo", metadata, autoload=True,
> > autoload_with=engine,
> > schema="DBName.dbo")
> > mapper(Test, tbl_test)
>
> > My databases were provided by a vendor and are on Microsoft SQL Server
> > 2000. By analyzing my code in WingWare's debugger, it looks like the
> > first table is getting reflected correctly in the line
> > "self.dialect.reflecttable(conn, table, include_columns)" at least.
>
> > Any pointers would be great. I am using Python 2.5 if that matters.
>
> > Thanks!
>
> > Mike
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
