User script for pywikibot (https://gerrit.wikimedia.org/r/pywikibot/core.git).

[philipp/winterrodeln/wrpylib.git] / scripts / updatewrregioncache.py

diff --git a/scripts/updatewrregioncache.py b/scripts/updatewrregioncache.py
index 41270cae0c4d79a91af7ccc0d9b31e40997f0d29..0a258ac1154fc828ea01adc647ef157a876fc8ef 100755 (executable)
--- a/scripts/updatewrregioncache.py
+++ b/scripts/updatewrregioncache.py
@@ -1,5 +1,4 @@
-#!/usr/bin/python2.7
-# -*- coding: iso-8859-15 -*-
+#!/usr/bin/python3
 """
 usage: updatewrregioncache.py [-h] inifile [inifile ...]
 
@@ -8,13 +7,13 @@ wrpylib.wrmwcache.update_wrregioncache()).
 
 positional arguments:
   inifile     inifile.ini (See:
-              http://www.winterrodeln.org/trac/wiki/ConfigIni)
+              https://www.winterrodeln.org/trac/wiki/ConfigIni)
 
 optional arguments:
   -h, --help  show this help message and exit
 """
 import argparse
-import ConfigParser
+import configparser
 from sqlalchemy.engine import create_engine
 import wrpylib.wrmwcache
 
@@ -23,7 +22,7 @@ def update_wrregioncache(inifiles):
     """
     :param inifiles: list of .ini file names
     """
-    config = ConfigParser.SafeConfigParser()
+    config = configparser.ConfigParser()
     config.read(inifiles)
 
     host = config.get('mysql', 'host')
@@ -31,16 +30,13 @@ def update_wrregioncache(inifiles):
     user = config.get('mysql', 'user_name')
     passwd = config.get('mysql', 'user_pass')
 
-    engine = create_engine(u'mysql://{user}@{host}:3306/{dbname}?charset=utf8&passwd={passwd}&use_unicode=1'.format(host=host, dbname=dbname, user=user, passwd=passwd))
+    engine = create_engine(f'mysql://{user}@{host}:3306/{dbname}?passwd={passwd}&charset=utf8mb4')
     wrpylib.wrmwcache.update_wrregioncache(engine.connect())
 
 
 if __name__=='__main__':
-    parser = argparse.ArgumentParser(description='Updates the wrregioncache table (by calling wrpylib.wrmwcache.update_wrregioncache()).')
-    parser.add_argument('inifile', nargs='+', help='inifile.ini (See: http://www.winterrodeln.org/trac/wiki/ConfigIni)')
+    parser = argparse.ArgumentParser(description='Updates the wrregioncache table.')
+    parser.add_argument('inifile', nargs='+', help='inifile.ini, see: https://www.winterrodeln.org/trac/wiki/ConfigIni')
     args = parser.parse_args()
 
     update_wrregioncache(args.inifile)
-
-
-