Omit empty parameters in key/value templates.

[philipp/winterrodeln/wrpylib.git] / wrpylib / wrintermaps.py

diff --git a/wrpylib/wrintermaps.py b/wrpylib/wrintermaps.py
index a1245257a24fe60d79822a3dbed17fcab7c6a9df..538be78b9a704856fe4b9a388d209adb6cd0ff98 100644 (file)
--- a/wrpylib/wrintermaps.py
+++ b/wrpylib/wrintermaps.py
@@ -1,5 +1,4 @@
 import datetime
-import json
 import re
 from sqlalchemy import orm
 from sqlalchemy.orm.session import Session
@@ -37,7 +36,7 @@ def update_wrintermapssledrun(session: Session, json_content: dict):
 
     >>> import json
     >>> from sqlalchemy.engine import create_engine
-    >>> engine = create_engine('mysql://philipp@localhost:3306/philipp_winterrodeln_wiki?charset=utf8&use_unicode=1')
+    >>> engine = create_engine('mysql://philipp@localhost:3306/philipp_winterrodeln_wiki?charset=utf8mb4')
     >>> Session = orm.sessionmaker(bind=engine)
     >>> with open('2019-12-06_090500.json') as fp:
     >>>     content = json.load(fp)
@@ -119,16 +118,3 @@ def update_wrintermapsreport(session: Session, json_content: dict, last_check: d
 
     # add JSON content to intermaps_report
     insert_json_to_intermapsreport(session, json_content, last_check)
-    session.commit()
-
-
-if __name__ == '__main__':
-    from sqlalchemy.engine import create_engine
-    engine = create_engine('mysql://philipp@localhost:3306/philipp_winterrodeln_wiki?charset=utf8&use_unicode=1')
-    SessionMaker = orm.sessionmaker(bind=engine)
-    filename = '/home/philipp/daten/Winterrodeln/Intermaps/intermaps_winterrodeln_2019-12-06_090501.json'
-    with open(filename) as fp:
-        content = json.load(fp)
-    session = SessionMaker()
-    update_wrintermapssledrun(session, content)
-    update_wrintermapsreport(session, content, datetime.datetime.now())