[sqlalchemy] automated table documentation

2018-11-15 Thread Chris Frey
It occurs to me that if it were possible to add documentation as an argument to Column(), it would be possible to use the sqlalchemy meta data to generate pretty end-user programmer documentation for tables. I see a 'doc' argument already exists in Column. Are there tools that make use of this?

[sqlalchemy] Forcing filters to use same type as field

2017-02-22 Thread Chris Frey
Hi, We're using MySQL, and we have tables that use a GUID as the ID. Unfortunately, if the GUID starts with a number, and if you select using an integer, mysql will helpfully convert for you: mysql> select id from table where id = 2; +-+ | id

Re: constraint names not as strict as expected

2015-11-19 Thread Chris Frey
On Wed, Nov 18, 2015 at 11:23:11PM -0500, Mike Bayer wrote: > if you change your naming convention, then that would show up as a bunch > of brand new constraints in the model and a whole bunch of constraints > removed in the model, so in theory would produce a lot of add constraint > / drop

constraint names not as strict as expected

2015-11-18 Thread Chris Frey
In the alembic documentation, there is an entire page devoted to naming constraints: http://alembic.readthedocs.org/en/latest/naming.html So I assumed that if constraints had a naming scheme defined, then those names would be detected if changed. My specific use case is as follows. My