On Apr 16, 2008, at 12:22 PM, Dr.T wrote:
>
> Oracle however becomes case sensitive when quotes are used and if a
> table is created with a quoted name, you must always quote references
> to it thereafter, which most people would not want!
>
> To sort this out, I thought that I could just pass the "quote=False"
> kwarg through to the Table constructor, which Elixir does via its
> "using_table_options" clause.
>
> This does not work however.
>
> To investigate, using the SQLAlchemy tutorial example, I generated a
> table directly in SQLAlchemy, as follows:
>
> users_table = Table('usersTable', metadata,
> Column('id', Integer, primary_key=True),
> Column('name', String(40)),
> Column('fullname', String(100)),
> Column('password', String(15)),
> quote=False
> )
>
> Sure enough, the table name is quoted and the quote=False is ignored.
>
> Would it be possible to amend the code to respect the quote kwarg
> regardless of the capitalization of the table name?
Theres no reason to do so, and it would add additional expression
overhead to the "_requires_quotes" call which is a very heavily used
method. Just specify your tablename as all lowercase, and no quotes
will be used. Oracle will record the tablename as "USERSTABLE"
regardless of the casing present, if quotes arent used, so the end
effect is the same.
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
