12 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: autoload'ing metadata
FromSent OnAttachments
svilen25 Jul 2007 05:06 
svilen25 Jul 2007 08:05 
sdob...@sistechnology.com25 Jul 2007 12:39 
sdob...@sistechnology.com25 Jul 2007 15:46 
Marco Mariani26 Jul 2007 01:36 
svilen26 Jul 2007 02:10 
sdob...@sistechnology.com26 Jul 2007 10:50 
Christophe de VIENNE27 Jul 2007 02:44 
svilen27 Jul 2007 04:50 
Christophe de VIENNE27 Jul 2007 06:13 
Paul Johnston27 Jul 2007 13:06 
Rick Morrison27 Jul 2007 13:15 
Subject:[sqlalchemy] Re: autoload'ing metadata
From:Rick Morrison (rick@gmail.com)
Date:07/27/2007 01:15:25 PM
List:com.googlegroups.sqlalchemy

MSSQL is case-sensitive, and wants to see queries to INFORMATION_SCHEMA in UPPER CASE.

See mssql.py.uppercase_table() for the gory details, or rather, THE GORY DETAILS ;-)

On 7/27/07, Christophe de VIENNE <cdev@gmail.com> wrote:

Hi svil,

Still no luck. I don't know if the information_schema module is supposed to work well with pymssql. Anyway :

Traceback (most recent call last): File "autoload.py", line 233, in ? autoloader = AutoLoader( engine) File "autoload.py", line 100, in __init__ me.table_names = engine.execute( sqltext) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 773, in execute return connection.execute(statement, *multiparams, **params) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 517, in execute return Connection.executors[c](self, object, *multiparams, **params) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 557, in execute_clauseelement return self.execute_compiled(elem.compile(dialect=self.dialect, parameters=param), *multiparams, **params) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 568, in execute_compiled self._execute_raw(context) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 581, in _execute_raw self._execute(context) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 599, in _execute raise exceptions.SQLError(context.statement, context.parameters, e) sqlalchemy.exceptions.SQLError: (DatabaseError) internal error (SQL Server message 208, severity 16, state 1, line 1: Invalid object name 'information_schema.tables'. DB-Lib error message 20018, severity 5: General SQL Server error: Check messages from the SQL Server. ): SQL Server message 208, severity 16, state 1, line 1: Invalid object name 'information_schema.tables'. DB-Lib error message 20018, severity 5: General SQL Server error: Check messages from the SQL Server. 'SELECT tables_a3c4.table_name, tables_a3c4.table_schema \nFROM information_schema.tables AS tables_a3c4 \nWHERE tables_a3c4.table_schema = %(tables_table_schema)s' {'tables_table_schema': 'sf_tmp'}