From 6f0a8c3351a9b293beb1d2eba16c1bcfa7d1a33b Mon Sep 17 00:00:00 2001 From: Daniel Schadt Date: Sat, 3 Jan 2026 22:52:36 +0100 Subject: fix enum name for Postgres In Postgres, enums must have a name. The auto-generated name for journey.Visibility and track.Visibility was the same ("visibility"), which caused issues. --- fietsboek/alembic/versions/20251230_f9ca03541351.py | 2 +- fietsboek/models/journey.py | 5 ++++- 2 files changed, 5 insertions(+), 2 deletions(-) diff --git a/fietsboek/alembic/versions/20251230_f9ca03541351.py b/fietsboek/alembic/versions/20251230_f9ca03541351.py index e82f7fa..363c6c1 100644 --- a/fietsboek/alembic/versions/20251230_f9ca03541351.py +++ b/fietsboek/alembic/versions/20251230_f9ca03541351.py @@ -21,7 +21,7 @@ def upgrade(): sa.Column('owner_id', sa.Integer(), nullable=False), sa.Column('title', sa.Text(), nullable=False), sa.Column('description', sa.Text(), nullable=False), - sa.Column('visibility', sa.Enum('PRIVATE', 'FRIENDS', 'LOGGED_IN', 'PUBLIC', name='visibility'), nullable=False), + sa.Column('visibility', sa.Enum('PRIVATE', 'FRIENDS', 'LOGGED_IN', 'PUBLIC', name='journey_visibility'), nullable=False), sa.Column('link_secret', sa.Text(), nullable=True), sa.ForeignKeyConstraint(['owner_id'], ['users.id'], name=op.f('fk_journeys_owner_id_users')), sa.PrimaryKeyConstraint('id', name=op.f('pk_journeys')) diff --git a/fietsboek/models/journey.py b/fietsboek/models/journey.py index 5b75878..0f1639e 100644 --- a/fietsboek/models/journey.py +++ b/fietsboek/models/journey.py @@ -74,7 +74,10 @@ class Journey(Base): owner_id: Mapped[int] = mapped_column(Integer, ForeignKey("users.id"), nullable=False) title: Mapped[str] = mapped_column(Text, nullable=False) description: Mapped[str] = mapped_column(Text, nullable=False) - visibility: Mapped[Visibility] = mapped_column(Enum(Visibility), nullable=False) + visibility: Mapped[Visibility] = mapped_column( + Enum(Visibility, name="journey_visibility"), + nullable=False, + ) link_secret: Mapped[str | None] = mapped_column(Text) owner: Mapped["models.User"] = relationship("User", back_populates="journeys") -- cgit v1.2.3