| commit | author | age | ||
| 73c256 | 1 | from sqlalchemy.ext.declarative import declarative_base |
| SP | 2 | from sqlalchemy.schema import MetaData |
| 3 | ||
| 022a6e | 4 | # Recommended naming convention used by Alembic, as various different database |
| SP | 5 | # providers will autogenerate vastly different names making migrations more |
| 9c84d8 | 6 | # difficult. See: http://alembic.zzzcomputing.com/en/latest/naming.html |
| 73c256 | 7 | NAMING_CONVENTION = { |
| a03714 | 8 | "ix": "ix_%(column_0_label)s", |
| 73c256 | 9 | "uq": "uq_%(table_name)s_%(column_0_name)s", |
| SP | 10 | "ck": "ck_%(table_name)s_%(constraint_name)s", |
| 11 | "fk": "fk_%(table_name)s_%(column_0_name)s_%(referred_table_name)s", | |
| 12 | "pk": "pk_%(table_name)s" | |
| 13 | } | |
| 14 | ||
| 15 | metadata = MetaData(naming_convention=NAMING_CONVENTION) | |
| 16 | Base = declarative_base(metadata=metadata) | |
