sqlalchemy-bot

`icontains`, `istartswith`, `iendswith`

13

**Migrated issue, originally created by jvanasco ([@jvanasco](https://github.com/jvanasco))** discussed previously in * https://groups.google.com/forum/#!searchin/sqlalchemy/icontains/sqlalchemy/MUyt8zYaP0c/ht4fGR9q9w8J * https://groups.google.com/forum/#!searchin/sqlalchemy/icontains/sqlalchemy/331XoToT4lk/RPjIYNTkSEIJ I tried doing this myself, but don't know enough of the internals to get this done...

have math operators + and - do something reasonable for dates and timedeltas (or raise)

5

**Migrated issue, originally created by Michael Bayer ([@zzzeek](https://github.com/zzzeek))** We can get support for "date2 - date1" pretty easily for most backends at this point, now that we have full control...

detect property being assigned to more than one parent, being assigned twice

8

**Migrated issue, originally created by Michael Bayer ([@zzzeek](https://github.com/zzzeek))** e.g.: ``` from sqlalchemy import * from sqlalchemy.orm import * from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() class A(Base): __tablename__ = 'a'...

implement in_() for relations

8

**Migrated issue, originally created by Anonymous** This would have to build upon the "optimized_compare" logic so that a JOIN would not be needed for the primary use case of a...

Record a history of when particular migrations were applied

12

**Migrated issue, originally created by Josh Kupershmidt ([@schmiddy](https://github.com/schmiddy))** I was a little surprised to see that the `alembic_version` table records only the current `version_num`, without even a timestamp indicating when...

op.add_column() and op.drop_column() should check for SchemaType, run through the events for that type, or perhaps just create/drop

14

**Migrated issue, originally created by Wichert Akkerman ([@wichert](https://github.com/wichert))** I have a data model which has a simple enum column: ``` size_type = schema.Column( types.Enum('normal', 'plus', name='size_type_type'), nullable=False, default='normal') ``` as...

take use_alter=True, other FK / foreign key / foreignkey constraint rules into account when autogenerating create_table / drop_table

19

**Migrated issue, originally created by Adrian Vogelsgesang ([@vogelsgesang](https://github.com/vogelsgesang))** If the schema contains circular dependencies, the order of the `CREATE TABLE` statements is incorrect. This is because `metadata.sorted_tables` (used [here](https://bitbucket.org/zzzeek/alembic/src/1c67b1ab8c6fe273d4e175a14f0df5d3cbbd0edc/alembic/autogenerate/compare.py?at=master&fileviewer=file-view-default#compare.py-73)) returns...

Autogenerate doesn't correctly handle postgresql enums

35

**Migrated issue, originally created by Ulrich Petri ([@ulope](https://github.com/ulope))** According to #67 enum types used in columns have to be explicitly created and destroyed. However the autogenerator currently doesn't produce those...

batch_alter_table forgets unchanged Enum CHECK constraint

19

**Migrated issue, originally created by Jeremy Field ([@jdf-id-au](https://github.com/jdf-id-au))** Using `batch_alter_table` to change an Enum in sqlite causes `CHECK` constraint for *another* Enum to be lost. Working example at [repo](https://bitbucket.org/jdf-id-au/alembic-bug-report). The...

support CHECK constraints for autogenerate

42

**Migrated issue, originally created by Alex Rothberg** If I start with the following and then uncomment the CheckConstraint, alembic does not handle the migration adding it or even print a...