-#!/usr/bin/python2.7
-# -*- coding: iso-8859-15 -*-
"""Creates the image thumbnails or icons for sledruns to be used in the sledmap application.
Can be used in a python session or at the command line.
sledrunicondir=/home/philipp/www/winterrodeln.org/karte/mediawiki_icons
"""
-from __future__ import division
+
import argparse
-import sys
import os
-import ConfigParser
+import configparser
import hashlib
import MySQLdb
from PIL import Image, ImageFilter
sql = "select image from wrsledruncache where image is not null order by image"
cu.execute(sql)
for image, in cu:
- image = image.replace(u' ', u'_')
+ image = image.replace(' ', '_')
# Create md5sum out of the image filename
md5 = hashlib.md5()
md5.update(image.encode('UTF8'))
source_file = os.path.join(mediawiki_image_dir, hd[0], hd[0:2], image)
dest_file = os.path.join(dest_dir, image)
if ignore_existing and os.path.exists(dest_file): continue
- print(u'{0}...'.format(image))
+ print(('{0}...'.format(image)))
im = Image.open(source_file)
im = image_function(im)
im.save(dest_file, "JPEG")
:param inifile: filename of an .ini file or a list of .ini files.
:param mode: 'thumbnail' or 'icon'
"""
- config = ConfigParser.SafeConfigParser()
+ config = configparser.ConfigParser()
config.read(inifile)
host = config.get('mysql', 'host')
args = parser.parse_args()
update_image_dir_by_inifile(args.inifile, args.type)
-
-#!/usr/bin/python2.7
-# -*- coding: iso-8859-15 -*-
"""Updates the wrsledrun table (by calling wrpylib.wrmwcache.update_wrinncache()).
Can be used in a python session or at the command line.
"""
import sys
-import ConfigParser
+import configparser
from sqlalchemy.engine import create_engine
import wrpylib.wrmwcache
"""
:param inifile: filename of an .ini file or a list of .ini files.
"""
- config = ConfigParser.SafeConfigParser()
+ config = configparser.ConfigParser()
config.read(inifile)
host = config.get('mysql', 'host')
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=0'.format(host=host, dbname=dbname, user=user, passwd=passwd))
+ engine = create_engine('mysql://{user}@{host}:3306/{dbname}?charset=utf8&passwd={passwd}&use_unicode=0'.format(host=host, dbname=dbname, user=user, passwd=passwd))
# "use_unicode=0": see: https://sourceforge.net/tracker/?func=detail&aid=2837134&group_id=22307&atid=374932
wrpylib.wrmwcache.update_wrinncache(engine.connect())
if len(sys.argv) >= 2:
update_wrinncache(sys.argv[1:])
else:
- print 'Usage:\n{0} infile1.ini [inifile2.ini ...]'.format(sys.argv[0])
- print 'See: http://www.winterrodeln.org/trac/wiki/ConfigIni'
-
+ print('Usage:\n{0} infile1.ini [inifile2.ini ...]'.format(sys.argv[0]))
+ print('See: http://www.winterrodeln.org/trac/wiki/ConfigIni')
-#!/usr/bin/python2.7
-# -*- coding: iso-8859-15 -*-
"""Updates the wrmappathcache and wrmappointcache tables (by calling wrpylib.wrmwcache.update_wrmapcache()).
Can be used in a python session or at the command line.
"""
import sys
-import ConfigParser
+import configparser
from sqlalchemy.engine import create_engine
import wrpylib.wrmwcache
"""
:param inifile: filename of an .ini file or a list of .ini files.
"""
- config = ConfigParser.SafeConfigParser()
+ config = configparser.ConfigParser()
config.read(inifile)
host = config.get('mysql', 'host')
if len(sys.argv) >= 2:
update_wrmapcache(sys.argv[1:])
else:
- print 'Usage:\n{0} infile1.ini [inifile2.ini ...]'.format(sys.argv[0])
- print 'See: http://www.winterrodeln.org/trac/wiki/ConfigIni'
+ print('Usage:\n{0} infile1.ini [inifile2.ini ...]'.format(sys.argv[0]))
+ print('See: http://www.winterrodeln.org/trac/wiki/ConfigIni')
-#!/usr/bin/python2.7
-# -*- coding: iso-8859-15 -*-
"""
usage: updatewrregioncache.py [-h] inifile [inifile ...]
-h, --help show this help message and exit
"""
import argparse
-import ConfigParser
+import configparser
from sqlalchemy.engine import create_engine
import wrpylib.wrmwcache
"""
:param inifiles: list of .ini file names
"""
- config = ConfigParser.SafeConfigParser()
+ config = configparser.ConfigParser()
config.read(inifiles)
host = config.get('mysql', 'host')
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('mysql://{user}@{host}:3306/{dbname}?charset=utf8&passwd={passwd}&use_unicode=1'.format(host=host, dbname=dbname, user=user, passwd=passwd))
wrpylib.wrmwcache.update_wrregioncache(engine.connect())
args = parser.parse_args()
update_wrregioncache(args.inifile)
-
-
-
-#!/usr/bin/python2.7
-# -*- coding: iso-8859-15 -*-
"""Updates the wrreportcache table (by calling wrpylib.wrmwcache.update_wrreportcache()).
Can be used in a python session or at the command line.
"""
import sys
-import ConfigParser
+import configparser
from sqlalchemy.engine import create_engine
import wrpylib.wrmwcache
"""
:param inifile: filename of an .ini file or a list of .ini files.
"""
- config = ConfigParser.SafeConfigParser()
+ config = configparser.ConfigParser()
config.read(inifile)
host = config.get('mysql', 'host')
if len(sys.argv) >= 2:
update_wrreportcache(sys.argv[1:])
else:
- print 'Usage:\n{0} infile1.ini [inifile2.ini ...]'.format(sys.argv[0])
- print 'See: http://www.winterrodeln.org/trac/wiki/ConfigIni'
-
+ print('Usage:\n{0} infile1.ini [inifile2.ini ...]'.format(sys.argv[0]))
+ print('See: http://www.winterrodeln.org/trac/wiki/ConfigIni')
-#!/usr/bin/python2.7
-# -*- coding: iso-8859-15 -*-
"""Updates the wrsledrun table (by calling wrpylib.wrmwcache.update_wrsledruncache()).
Can be used in a python session or at the command line.
"""
import sys
-import ConfigParser
+import configparser
from sqlalchemy.engine import create_engine
import wrpylib.wrmwcache
"""
:param inifile: filename of an .ini file or a list of .ini files.
"""
- config = ConfigParser.SafeConfigParser()
+ config = configparser.ConfigParser()
config.read(inifile)
host = config.get('mysql', 'host')
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=0'.format(host=host, dbname=dbname, user=user, passwd=passwd))
+ engine = create_engine('mysql://{user}@{host}:3306/{dbname}?charset=utf8&passwd={passwd}&use_unicode=0'.format(host=host, dbname=dbname, user=user, passwd=passwd))
# "use_unicode=0": see: https://sourceforge.net/tracker/?func=detail&aid=2837134&group_id=22307&atid=374932
wrpylib.wrmwcache.update_wrsledruncache(engine.connect())
if len(sys.argv) >= 2:
update_wrsledruncache(sys.argv[1:])
else:
- print 'Usage:\n{0} infile1.ini [inifile2.ini ...]'.format(sys.argv[0])
- print 'See: http://www.winterrodeln.org/trac/wiki/ConfigIni'
-
+ print('Usage:\n{0} infile1.ini [inifile2.ini ...]'.format(sys.argv[0]))
+ print('See: http://www.winterrodeln.org/trac/wiki/ConfigIni')