def upgrade()

in src/Backend/migrations/versions/2023_05_12_214607-c25b24a75bec_add_columns_to_user.py [0:0]

• 21 lines of code
• 1 McCabe index (conditional complexity)

def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    status_enum_postgres = psql.ENUM(
        "PASSWORD", "FIREBASE", name="usertype", create_type=False
    )
    status_enum_postgres.create(op.get_bind(), checkfirst=False)
    op.add_column(
        "users", sa.Column("customer_id", sa.String(length=100), nullable=True)
    )
    op.add_column(
        "users",
        sa.Column(
            "type",
            status_enum_postgres,
            nullable=False,
        ),
    )
    op.add_column("users", sa.Column("password", sa.String(length=100), nullable=True))
    op.drop_constraint("users_firebase_id_key", "users", type_="unique")
    op.alter_column(
        "users", "firebase_id", new_column_name="external_id", nullable=True
    )