mirror of
https://github.com/GSA/notifications-api.git
synced 2025-12-14 09:12:06 -05:00
69 lines
1.8 KiB
Python
69 lines
1.8 KiB
Python
"""empty message
|
|
|
|
Revision ID: 0056_minor_updates
|
|
Revises: 0055_service_whitelist
|
|
Create Date: 2016-10-04 09:43:42.321138
|
|
|
|
"""
|
|
|
|
# revision identifiers, used by Alembic.
|
|
revision = "0056_minor_updates"
|
|
down_revision = "0055_service_whitelist"
|
|
|
|
import sqlalchemy as sa
|
|
from alembic import op
|
|
|
|
|
|
def upgrade():
|
|
### commands auto generated by Alembic - please adjust! ###
|
|
op.alter_column(
|
|
"service_whitelist",
|
|
"recipient",
|
|
existing_type=sa.VARCHAR(length=255),
|
|
nullable=False,
|
|
)
|
|
op.alter_column(
|
|
"services", "research_mode", existing_type=sa.BOOLEAN(), nullable=False
|
|
)
|
|
op.alter_column(
|
|
"services_history", "research_mode", existing_type=sa.BOOLEAN(), nullable=False
|
|
)
|
|
op.create_foreign_key(
|
|
"templates_history_service_id_fkey",
|
|
"templates_history",
|
|
"services",
|
|
["service_id"],
|
|
["id"],
|
|
)
|
|
op.create_foreign_key(
|
|
"templates_history_created_by_id_fkey",
|
|
"templates_history",
|
|
"users",
|
|
["created_by_id"],
|
|
["id"],
|
|
)
|
|
### end Alembic commands ###
|
|
|
|
|
|
def downgrade():
|
|
### commands auto generated by Alembic - please adjust! ###
|
|
op.drop_constraint(
|
|
"templates_history_service_id_fkey", "templates_history", type_="foreignkey"
|
|
)
|
|
op.drop_constraint(
|
|
"templates_history_created_by_id_fkey", "templates_history", type_="foreignkey"
|
|
)
|
|
op.alter_column(
|
|
"services_history", "research_mode", existing_type=sa.BOOLEAN(), nullable=True
|
|
)
|
|
op.alter_column(
|
|
"services", "research_mode", existing_type=sa.BOOLEAN(), nullable=True
|
|
)
|
|
op.alter_column(
|
|
"service_whitelist",
|
|
"recipient",
|
|
existing_type=sa.VARCHAR(length=255),
|
|
nullable=True,
|
|
)
|
|
### end Alembic commands ###
|