From 48bcde810febe8dc9f74eb8569e8eb637f9d6c12 Mon Sep 17 00:00:00 2001 From: Joe Banks Date: Mon, 8 Apr 2024 04:39:22 +0100 Subject: Track whether a category has been deleted --- ...1590e74_add_deleted_column_to_category_model.py | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 alembic/versions/01b101590e74_add_deleted_column_to_category_model.py (limited to 'alembic') diff --git a/alembic/versions/01b101590e74_add_deleted_column_to_category_model.py b/alembic/versions/01b101590e74_add_deleted_column_to_category_model.py new file mode 100644 index 0000000..1325bd2 --- /dev/null +++ b/alembic/versions/01b101590e74_add_deleted_column_to_category_model.py @@ -0,0 +1,31 @@ +""" +Add deleted column to Category model. + +Revision ID: 01b101590e74 +Revises: c09a64cac3cb +Create Date: 2024-04-08 04:39:00.198882 + +""" +import sqlalchemy as sa + +from alembic import op + +# revision identifiers, used by Alembic. +revision = "01b101590e74" +down_revision = "c09a64cac3cb" +branch_labels = None +depends_on = None + + +def upgrade() -> None: + """Apply the current migration.""" + # ### commands auto generated by Alembic - please adjust! ### + op.add_column("categories", sa.Column("deleted", sa.Boolean(), nullable=False)) + # ### end Alembic commands ### + + +def downgrade() -> None: + """Revert the current migration.""" + # ### commands auto generated by Alembic - please adjust! ### + op.drop_column("categories", "deleted") + # ### end Alembic commands ### -- cgit v1.2.3