diff options
author | 2023-09-04 20:26:04 +0100 | |
---|---|---|
committer | 2023-09-04 20:26:04 +0100 | |
commit | 857803703f9dd31ba328f6e95c3b2a2cf1590a82 (patch) | |
tree | 1a4b2aa3ec74e74326223b3479a8d0f697dac828 | |
parent | Update Alembic to use asyncpg to run migrations (diff) |
Add migration to make some columns NOT NULLable
-rw-r--r-- | alembic/versions/03655ce2097b_new_not_null_constraints_on_messages_.py | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/alembic/versions/03655ce2097b_new_not_null_constraints_on_messages_.py b/alembic/versions/03655ce2097b_new_not_null_constraints_on_messages_.py new file mode 100644 index 0000000..66cb029 --- /dev/null +++ b/alembic/versions/03655ce2097b_new_not_null_constraints_on_messages_.py @@ -0,0 +1,63 @@ +""" +New NOT NULL constraints on messages and users table. + +Revision ID: 03655ce2097b +Revises: 563a15b2a76e +Create Date: 2023-09-04 20:17:03.543328 + +""" +import sqlalchemy as sa + +from alembic import op + +# revision identifiers, used by Alembic. +revision = "03655ce2097b" +down_revision = "563a15b2a76e" +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.alter_column("messages", "channel_id", + existing_type=sa.VARCHAR(), + nullable=False) + op.alter_column("messages", "author_id", + existing_type=sa.VARCHAR(), + nullable=False) + op.alter_column("messages", "is_deleted", + existing_type=sa.BOOLEAN(), + nullable=False) + op.alter_column("users", "bot", + existing_type=sa.BOOLEAN(), + nullable=False) + op.alter_column("users", "in_guild", + existing_type=sa.BOOLEAN(), + nullable=False) + op.alter_column("users", "pending", + existing_type=sa.BOOLEAN(), + nullable=False) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.alter_column("users", "pending", + existing_type=sa.BOOLEAN(), + nullable=True) + op.alter_column("users", "in_guild", + existing_type=sa.BOOLEAN(), + nullable=True) + op.alter_column("users", "bot", + existing_type=sa.BOOLEAN(), + nullable=True) + op.alter_column("messages", "is_deleted", + existing_type=sa.BOOLEAN(), + nullable=True) + op.alter_column("messages", "author_id", + existing_type=sa.VARCHAR(), + nullable=True) + op.alter_column("messages", "channel_id", + existing_type=sa.VARCHAR(), + nullable=True) + # ### end Alembic commands ### |