commit | author | age
|
0409cf
|
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 |
0409cf
|
7 |
NAMING_CONVENTION = { |
a03714
|
8 |
"ix": "ix_%(column_0_label)s", |
0409cf
|
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) |