diff options
| author | Daniel Schadt <kingdread@gmx.de> | 2026-09-27 21:44:50 +0200 |
|---|---|---|
| committer | Daniel Schadt <kingdread@gmx.de> | 2026-09-27 21:44:50 +0200 |
| commit | 77a12c168822ec62a1669103f9e94a8d5d30c0b3 (patch) | |
| tree | a4934fc951a8c3c461fddc1482f1425c60297aa1 | |
| parent | c48b6a287a5f107328558f53d0e08110df7ea522 (diff) | |
| download | fietsboek-77a12c168822ec62a1669103f9e94a8d5d30c0b3.tar.gz fietsboek-77a12c168822ec62a1669103f9e94a8d5d30c0b3.tar.bz2 fietsboek-77a12c168822ec62a1669103f9e94a8d5d30c0b3.zip | |
more climb metadata in database
| -rw-r--r-- | fietsboek/models/climb.py | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/fietsboek/models/climb.py b/fietsboek/models/climb.py index 3dd8d17..33ee0e2 100644 --- a/fietsboek/models/climb.py +++ b/fietsboek/models/climb.py @@ -4,7 +4,7 @@ from typing import TYPE_CHECKING from pyramid.httpexceptions import HTTPNotFound from pyramid.request import Request -from sqlalchemy import ForeignKey, Integer, LargeBinary, Text, select +from sqlalchemy import Float, ForeignKey, Integer, LargeBinary, Text, select from sqlalchemy.orm import Mapped, mapped_column, relationship from .meta import Base @@ -22,7 +22,14 @@ class Climb(Base): track_id: Mapped[int] = mapped_column(Integer, ForeignKey("tracks.id"), nullable=False) automatic_name: Mapped[str | None] = mapped_column(Text) given_name: Mapped[str | None] = mapped_column(Text) - image: Mapped[bytes] = mapped_column(LargeBinary) + image: Mapped[bytes] = mapped_column(LargeBinary, nullable=False) + profile: Mapped[bytes] = mapped_column(LargeBinary, nullable=False) + + avg_grade: Mapped[float] = mapped_column(Float, nullable=False) + length: Mapped[float] = mapped_column(Float, nullable=False) + lowest_elevation: Mapped[float] = mapped_column(Float, nullable=False) + highest_elevation: Mapped[float] = mapped_column(Float, nullable=False) + category: Mapped[int | None] = mapped_column(Integer, nullable=True) start_index: Mapped[int] = mapped_column(Integer, nullable=False) end_index: Mapped[int] = mapped_column(Integer, nullable=False) |