respect track date when downgradinggpx-influx

1 files changed, 6 insertions, 4 deletions

diff --git a/fietsboek/updater/scripts/upd_20251109_nm561argcq1s8w27.py b/fietsboek/updater/scripts/upd_20251109_nm561argcq1s8w27.py
index 05a7233..e3e5e47 100644
--- a/fietsboek/updater/scripts/upd_20251109_nm561argcq1s8w27.py
+++ b/fietsboek/updater/scripts/upd_20251109_nm561argcq1s8w27.py
@@ -108,13 +108,17 @@ class Down(UpdateScript):
         connection = engine.connect()
         data_dir = Path(config["fietsboek.data_dir"])
 
-        query = text("SELECT id, title, description FROM tracks;")
+        query = text("SELECT id, title, description, date_raw FROM tracks;")
 
         for row in connection.execute(query):
             gpx = gpxpy.gpx.GPX()
             gpx.description = row.description
             gpx.name = row.title
 
+            start_date = row.date_raw
+            if isinstance(start_date, str):
+                start_date = datetime.datetime.fromisoformat(start_date)
+
             segment = gpxpy.gpx.GPXTrackSegment()
             points_query = text("""
                 SELECT longitude, latitude, elevation, time_offset
@@ -126,9 +130,7 @@ class Down(UpdateScript):
                         latitude=point.latitude,
                         longitude=point.longitude,
                         elevation=point.elevation,
-                        # This is wrong, should take proper track start time
-                        # into account:
-                        time=datetime.datetime.fromtimestamp(point.time_offset),
+                        time=start_date + datetime.timedelta(seconds=point.time_offset),
                     )
                 )
             track = gpxpy.gpx.GPXTrack()