import datetime
-import json
import re
from sqlalchemy import orm
from sqlalchemy.orm.session import Session
>>> 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)
# 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())