aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGravatar Joe Banks <[email protected]>2023-09-04 20:26:04 +0100
committerGravatar Joe Banks <[email protected]>2023-09-04 20:26:04 +0100
commit857803703f9dd31ba328f6e95c3b2a2cf1590a82 (patch)
tree1a4b2aa3ec74e74326223b3479a8d0f697dac828
parentUpdate 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_.py63
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 ###