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