Michael,
You are right and that is what I have done.
I didn't appreciate that what I suggested would add overhead ;-(
Perhaps a line could be added to the Table constructor documentation
to point out that the "name" kwarg is ignored when the table name is
in mixed case (because this is not obvious)?
Thanks for your help,
Tim
On Apr 16, 5:35 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
