Files
notifications-api/migrations/versions/0113_job_created_by_nullable.py
Cliff Hill 1157f5639d black, isort, flake8
Signed-off-by: Cliff Hill <Clifford.hill@gsa.gov>
2023-12-08 21:43:52 -05:00

26 lines
651 B
Python

"""empty message
Revision ID: 0113_job_created_by_nullable
Revises: 0112_add_start_end_dates
Create Date: 2017-07-27 11:12:34.938086
"""
# revision identifiers, used by Alembic.
revision = "0113_job_created_by_nullable"
down_revision = "0112_add_start_end_dates"
import sqlalchemy as sa
from alembic import op
from sqlalchemy.dialects import postgresql
def upgrade():
op.alter_column("jobs", "created_by_id", nullable=True)
def downgrade():
# This will error if there are any jobs with no created_by - we'll have to decide how to handle those as and when
# we downgrade
op.alter_column("jobs", "created_by_id", nullable=False)