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

2019-07-25 Thread Mike Bayer
On Mon, Jul 22, 2019, at 10:51 PM, Jonathan Vanasco wrote: > > > 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

Re: [sqlalchemy] Pass timestamp with milliseconds to SQLAlchemy backed by SQLite3

2019-07-25 Thread Mike Bayer
Hi there - We would need some context for this. What does CREATE TABLE look like? What is the datatype in use? What does the logging output say, e.g. illustrate the SQL and result output with create_engine(..., echo='debug'). It looks like you are using some epochal oriented datatype but no

Re: [sqlalchemy] sqlalchemy.engine question

2019-07-25 Thread Jonathan Vanasco
Are you writing any code that queries this model or are you just letting the framework handle that? We'd need to see the actual code you are using to query the database. If you are not writing code that looks like 'session.query(model.AccessKeys)` yourself, then SqlAlchemy queries are being

Re: [sqlalchemy] sqlalchemy.engine question

2019-07-25 Thread Jonathan Vanasco
what does your sqlalchemy query code look like? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full