Blockaden durch epg2vdr (oder scraper2vdr)

#!/usr/bin/env python3
from contextlib import closing
from pathlib import Path
import mysql.connector as mariadb
host="192.168.1.173"
user="epg2vdr"
password="epg"
database="epg2vdr"

mariadb_connection = mariadb.connect(host=host, user=user, password=password, database=database)
with closing(mariadb_connection.cursor()) as c:
    c.execute("SELECT imagenamefs from epg2vdr.imagerefs")
    result = c.fetchall()
image_names = {img for (img,) in result}

for f in Path('/var/cache/vdr/epgimages/images/').glob('*.jpg'):
    if f.name in image_names:
        # print("keeping file", f.name)
        pass
    else:
        print("unused image", f.name)
        #f.unlink() # uncomment to delete files

#!/usr/bin/env python3
from contextlib import closing
from pathlib import Path
import mysql.connector as mariadb

host="192.168.1.173"
user="epg2vdr"
password="epg"
database="epg2vdr"
simulate = True

def remove_file(f: Path):
    if not simulate:
        f.unlink()

mariadb_connection = mariadb.connect(host=host, user=user, password=password, database=database)

with closing(mariadb_connection.cursor()) as c:
    c.execute("SELECT imagenamefs from epg2vdr.imagerefs")
    result = c.fetchall()

image_names = {img for (img,) in result}

unused_images = set()
for f in Path('/var/cache/vdr/epgimages/images/').glob('*.jpg'):
    if f.name in image_names:
        pass
        #print("keep image", f.name)
    else:
        print("delete unused image", f.name)
        unused_images.add(f)
        remove_file(f)

for f in Path('/var/cache/vdr/epgimages/').glob('*.jpg'):
    if f.is_symlink():
        try:
            t = f.resolve(strict=True)
        except IOError:
            print("dead symlink", f)
            remove_file(f)
        else:
            if t in unused_images:
                print("removing obsolete symlink", f)
                remove_file(f)

root@gate (dev u=) ~/PLUGINS/vdr-plugin-epg2vdr> zgrep "Cleanup finished, removed" /var/log/vdr.log*
/var/log/vdr.log.1:Feb 10 12:02:26 gate vdr: epg2vdr: Cleanup finished, removed (5657) images and (7026) symlinks
/var/log/vdr.log.1:Feb 11 00:11:41 gate vdr: epg2vdr: Cleanup finished, removed (1542) images and (2604) symlinks
/var/log/vdr.log.2.gz:Feb  9 11:41:16 gate vdr: epg2vdr: Cleanup finished, removed (1232) images and (2458) symlinks
/var/log/vdr.log.2.gz:Feb  9 23:51:10 gate vdr: epg2vdr: Cleanup finished, removed (9276) images and (10779) symlinks
/var/log/vdr.log.3.gz:Feb  8 11:27:49 gate vdr: epg2vdr: Cleanup finished, removed (18302) images and (20538) symlinks
/var/log/vdr.log.3.gz:Feb  8 23:34:49 gate vdr: epg2vdr: Cleanup finished, removed (1388) images and (2596) symlinks
/var/log/vdr.log.4.gz:Feb  7 23:04:50 gate vdr: epg2vdr: Cleanup finished, removed (380) images and (737) symlinks
/var/log/vdr.log.5.gz:Feb  6 17:37:01 gate vdr: epg2vdr: Cleanup finished, removed (15402) images and (16402) symlinks
/var/log/vdr.log.5.gz:Feb  7 05:42:46 gate vdr: epg2vdr: Cleanup finished, removed (1488) images and (2767) symlinks
/var/log/vdr.log.6.gz:Feb  5 17:20:49 gate vdr: epg2vdr: Cleanup finished, removed (16325) images and (17328) symlinks
/var/log/vdr.log.6.gz:Feb  6 05:27:14 gate vdr: epg2vdr: Cleanup finished, removed (1286) images and (2057) symlinks
/var/log/vdr.log.7.gz:Feb  4 17:03:43 gate vdr: epg2vdr: Cleanup finished, removed (10968) images and (11983) symlinks
/var/log/vdr.log.7.gz:Feb  5 05:09:58 gate vdr: epg2vdr: Cleanup finished, removed (1814) images and (2906) symlinks