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
-~----------~----~----~----~------~----~------~--~---

Reply via email to