search

Club-Alpin-Annecy / collectives-materiel

0 stars 1 forks source link

Alembic doesn't delete unique columns #45

Closed hug0be closed 2 years ago

hug0be commented 2 years ago

Lorsque j'ajoute une nouvelle migration add_equipment_roles (voir #44), alembic ne run pas ma migration lors de l'update Au lieu de ça, elle se termine à la migration add_reference_prefix (qui ajoute une colonne dans EquipmentType), dont voici le code :

def upgrade():
    op.add_column(
        "equipment_types",
        sa.Column("reference_prefix", sa.String(length=10), nullable=False),
    )
    op.create_unique_constraint(None, "equipment_types", ["reference_prefix"])

def downgrade():
    op.drop_constraint(None, "equipment_types", type_="unique")
    op.drop_column("equipment_types", "reference_prefix")

PS : lorsque je retente un flask db upgrade : sqlite3.OperationalError: duplicate column name: reference_prefix Traceback : traceback.txt