#!/usr/bin/python3
"""
usage: updatewrregioncache.py [-h] inifile [inifile ...]

Updates the wrregioncache table (by calling
wrpylib.wrmwcache.update_wrregioncache()).

positional arguments:
  inifile     inifile.ini (See:
              https://www.winterrodeln.org/trac/wiki/ConfigIni)

optional arguments:
  -h, --help  show this help message and exit
"""
import argparse
import configparser
from sqlalchemy.engine import create_engine
import wrpylib.wrmwcache


def update_wrregioncache(inifiles):
    """
    :param inifiles: list of .ini file names
    """
    config = configparser.ConfigParser()
    config.read(inifiles)

    host = config.get('mysql', 'host')
    dbname = config.get('mysql', 'dbname')
    user = config.get('mysql', 'user_name')
    passwd = config.get('mysql', 'user_pass')

    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.')
    parser.add_argument('inifile', nargs='+', help='inifile.ini, see: https://www.winterrodeln.org/trac/wiki/ConfigIni')
    args = parser.parse_args()

    update_wrregioncache(args.inifile)