From: Philipp Spitzer <philipp@spitzer.priv.at>
Date: Tue, 23 Sep 2025 17:44:56 +0000 (+0200)
Subject: Make constructing database URL more robust.
X-Git-Url: https://git.toastfreeware.priv.at/chrisu/seepark.git/commitdiff_plain/14b0005a675787bfb0f90fe318c2090a1edeb045?hp=a2a05d24bf5570ae05f20d1f6a2c91c456ce7a5c

Make constructing database URL more robust.
---

diff --git a/owm.py b/owm.py
index 1a55892..bd6ba6e 100755
--- a/owm.py
+++ b/owm.py
@@ -18,7 +18,7 @@ import os
 from pprint import pprint
 
 import sqlalchemy
-from sqlalchemy import create_engine, Table
+from sqlalchemy import create_engine, Table, URL
 
 from seeparklib.openweathermap import openweathermap_json
 
@@ -81,7 +81,8 @@ def write_db(config, url, weather_json, weather_data):
     host = config.get('database','hostname')
     db = config.get('database','database')
 
-    engine = create_engine('mysql+mysqldb://{}:{}@{}/{}'.format(user, pwd, host, db), echo=False)
+    db_url = URL.create(drivername='mysql+mysqldb', username=user, password=pwd, host=host, database=db)
+    engine = create_engine(db_url, echo=False)
     with engine.connect() as conn:
         row = dict(cityid=config.get('openweathermap', 'cityid'), url=url, result=json.dumps(weather_json))
         row.update(weather_data)