From d5b6a4ea27f8c905e613363aab365066ad6d9cda Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Fri, 5 Mar 2021 18:08:17 +0100 Subject: auth stuff. generate secret and create user from the cli --- .../versions/202103051807_make_username_unique.py | 41 ++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 animism-align/cli/app/sql/versions/202103051807_make_username_unique.py (limited to 'animism-align/cli/app/sql/versions') diff --git a/animism-align/cli/app/sql/versions/202103051807_make_username_unique.py b/animism-align/cli/app/sql/versions/202103051807_make_username_unique.py new file mode 100644 index 0000000..e8f4985 --- /dev/null +++ b/animism-align/cli/app/sql/versions/202103051807_make_username_unique.py @@ -0,0 +1,41 @@ +"""make username unique + +Revision ID: 135ba3ff136a +Revises: 5de5fdfbe69a +Create Date: 2021-03-05 18:07:36.955364 + +""" +from alembic import op +import sqlalchemy as sa +import sqlalchemy_utc +from sqlalchemy.dialects import mysql + +# revision identifiers, used by Alembic. +revision = '135ba3ff136a' +down_revision = '5de5fdfbe69a' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.alter_column('episode', 'episode_number', + existing_type=mysql.INTEGER(), + nullable=True) + op.alter_column('episode', 'release_date', + existing_type=mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=256), + nullable=True) + op.create_unique_constraint(None, 'user', ['username']) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_constraint(None, 'user', type_='unique') + op.alter_column('episode', 'release_date', + existing_type=mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=256), + nullable=False) + op.alter_column('episode', 'episode_number', + existing_type=mysql.INTEGER(), + nullable=False) + # ### end Alembic commands ### -- cgit v1.2.3-70-g09d2