Re: [sqlalchemy] quote=False for all columns in table

2017-07-01 Thread Seth P
Perfect. Thank you! On Friday, June 30, 2017 at 5:41:33 PM UTC-4, Mike Bayer wrote: > > > from sqlalchemy import Column, String, Integer, create_engine > from sqlalchemy.orm import Session > from sqlalchemy.ext.declarative import declarative_base > from sqlalchemy import event > > Base =

Re: [sqlalchemy] quote=False for all columns in table

2017-06-30 Thread Mike Bayer
On Fri, Jun 30, 2017 at 5:10 PM, Seth P wrote: > I'm just accessing a vendor-provided Oracle database. The database itself is > all upper(lower?) case (I'm new to Oracle), case insensitive if unquoted names are used. whereas I want my declarative > model columns to be

Re: [sqlalchemy] quote=False for all columns in table

2017-06-30 Thread Seth P
I'm just accessing a vendor-provided Oracle database. The database itself is all upper(lower?) case (I'm new to Oracle), whereas I want my declarative model columns to be camelCase (and the emitted SQL to be unquoted camelCase) to match the vendor's documentation. I could make the column names

Re: [sqlalchemy] quote=False for all columns in table

2017-06-30 Thread Mike Bayer
On Fri, Jun 30, 2017 at 4:31 PM, Seth P wrote: > Is there a way (when using declarative) to specify that all the columns of a > table should use quote=False without specifying it explicitly for each > column? Easiest is just to call your own my_column(...) function that sets

[sqlalchemy] quote=False for all columns in table

2017-06-30 Thread Seth P
Is there a way (when using declarative) to specify that all the columns of a table should use quote=False without specifying it explicitly for each column? I've tried setting __table_args__ = { 'quote_schema': False, 'quote': False }, but that just affects the schema and table name, not the