Re: [sqlalchemy] Column vs Table constraints for Column(unique=True) in Postgres

2015-05-28 Thread rob
Thank Lucas. I've tried that as well. In all cases, SQLAlchemy always emits a table constraint. i.e., an additional CONSTRAINT clause in the CREATE TABLE command. Maybe I've poorly phrased my question and SQLAlchemy always emits table constraints? Here's an updated example. In all three

Re: [sqlalchemy] SQLAlchemy quoting of table names - Can't redefine 'quote' or 'quote_schema' arguments

2015-05-28 Thread Mike Bayer
On 5/28/15 7:13 PM, Adam Darwin wrote: Thanks for the response Michael as far as I can tell there is no reflective step in created the declarative_base the code is as posted. OK then you do not need the "extend_existing" flag, below is a test case which illustrates that even with this flag,

Re: [sqlalchemy] SQLAlchemy quoting of table names - Can't redefine 'quote' or 'quote_schema' arguments

2015-05-28 Thread Adam Darwin
Thanks for the response Michael as far as I can tell there is no reflective step in created the declarative_base the code is as posted. My table names in sybase are uppercase, if i try lower case it fails: ProgrammingError: (pyodbc.ProgrammingError) ('42000', '[42000] [Sybase][ODBC Driver][Adap

Re: [sqlalchemy] SQLAlchemy quoting of table names - Can't redefine 'quote' or 'quote_schema' arguments

2015-05-28 Thread Mike Bayer
On 5/27/15 10:34 PM, Adam Darwin wrote: Whilst upgrading from sqlalchemy 0.8 to 1.0.4 my ORM has broken with the error Can't redefine 'quote' or 'quote_schema' arguments I connect to a sybase db, and use a declarative_base | | Base=declarative_base() | | Using a standard method to create