diff options
Diffstat (limited to 'fietsboek/updater/scripts/upd_20230103_lu8w3rwlz4ddcpms.py')
-rw-r--r-- | fietsboek/updater/scripts/upd_20230103_lu8w3rwlz4ddcpms.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/fietsboek/updater/scripts/upd_20230103_lu8w3rwlz4ddcpms.py b/fietsboek/updater/scripts/upd_20230103_lu8w3rwlz4ddcpms.py index 1630fbb..4362c2d 100644 --- a/fietsboek/updater/scripts/upd_20230103_lu8w3rwlz4ddcpms.py +++ b/fietsboek/updater/scripts/upd_20230103_lu8w3rwlz4ddcpms.py @@ -15,6 +15,7 @@ from pathlib import Path import brotli import gpxpy from sqlalchemy import create_engine +from sqlalchemy.sql import text from fietsboek.updater.script import UpdateScript @@ -37,7 +38,7 @@ class Up(UpdateScript): "FROM tracks, users " "WHERE tracks.owner_id = users.id;" ) - for row in connection.execute(sql): + for row in connection.execute(text(sql)): track_id, title, description, date_raw, date_tz, author_name = row if isinstance(date_raw, str): date_raw = datetime.datetime.strptime(date_raw, "%Y-%m-%d %H:%M:%S.%f") |