Re: [sqlalchemy] information schema with sqlalchemy and pymssql reflection and case sensitivity issue

2016-04-05 Thread Douglas Eisenstein
Bayer wrote: > > > > On 04/05/2016 02:15 PM, Douglas Eisenstein wrote: > > Thanks Mike for the response and issue creation. So, I've set that case > > sensitivity option to True, and we're getting another issue (edge case?) > > whereby when we reflect a singl

Re: [sqlalchemy] information schema with sqlalchemy and pymssql reflection and case sensitivity issue

2016-04-05 Thread Douglas Eisenstein
;", line 1, in self._metadata.quote File "", line 2, in quote File "/Users/adv/anaconda/lib/python2.7/site-packages/sqlalchemy/util/deprecations.py", line 106, in warned return fn(*args, **kwargs) File "/Users/adv/anaconda/lib/python2.7/site-pack

[sqlalchemy] information schema with sqlalchemy and pymssql reflection and case sensitivity issue

2016-04-04 Thread Douglas Eisenstein
Hi, Here's the situation, we're trying to reflect tables from SQL Server into metadata, and we're encountering a problem of case sensitivity, in particular when it executes the following query: SELECT [C].[COLUMN_NAME], [R].[TABLE_SCHEMA], [R].[TABLE_NAME], [R].[COLUMN_NAME], [REFERENTIAL_CONST