Re: [sqlalchemy] possible bug on sqlite regarding automatic constraints when using alembic recommended naming conventions

2019-07-22 Thread Jonathan Vanasco
On Monday, July 22, 2019 at 9:36:10 PM UTC-4, Mike Bayer wrote: > > likely , the "create_constraint" flag should default to False for booleans > and enums. I think it was a mistake to default these to true, I think > people usually don't care. > Everything you said was apparent to me, but I

Re: [sqlalchemy] possible bug on sqlite regarding automatic constraints when using alembic recommended naming conventions

2019-07-22 Thread Mike Bayer
On Mon, Jul 22, 2019, at 6:01 PM, Jonathan Vanasco wrote: > Mike- > > I'm not sure if this is a bug or docs incompatibility issue, and I know > metadata may be going away soon... but I'm leaning towards a bug. > > I was setting up a test suite for a Pyramid plugin, and used the Alembic > nami

[sqlalchemy] Re: use sqlalchemy model to generate avro schema

2019-07-22 Thread Jonathan Vanasco
On Monday, July 22, 2019 at 7:47:51 PM UTC-4, Isaac Martin wrote: > > or straight-forward way of generating avro schema from a sqlalchemy model? > You can iterate the columns and relations of a SqlAlchemy model / table. Search terms like "iterate sqlachemy model columns" and you'll see many

[sqlalchemy] use sqlalchemy model to generate avro schema

2019-07-22 Thread Isaac Martin
Hey folks! I have a sqlalchemy model. I would like to define interaction between services as being constrained by a contract. For that contract, I wish to use avro schema. It would be nice to be able to generate new schema when I change the sqlalchemy model. Is anyone aware of a library or stra

[sqlalchemy] possible bug on sqlite regarding automatic constraints when using alembic recommended naming conventions

2019-07-22 Thread Jonathan Vanasco
Mike- I'm not sure if this is a bug or docs incompatibility issue, and I know metadata may be going away soon... but I'm leaning towards a bug. I was setting up a test suite for a Pyramid plugin, and used the Alembic naming conventions (https://alembic.sqlalchemy.org/en/latest/naming.html) as

[sqlalchemy] Re: disable notifications in terminal

2019-07-22 Thread Jonathan Vanasco
SqlAlchemy uses Python logging. SqlAlchemy Docs: https://docs.sqlalchemy.org/en/13/core/engines.html#dbengine-logging Python Logging Docs: https://docs.python.org/3/library/logging.html -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post e

[sqlalchemy] disable notifications in terminal

2019-07-22 Thread Mohsen Pahlevanzadeh
I use sqlalchemy and when I run my program , get the following notifications: // 2019-07-22 20:53:41,207 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1 2019-07-22 2