Remove downloaded and already read rakuyomi chapters

rakuyomi_cleaner.py

import base64
import hashlib
import os
import sqlite3

# Customize so that it points to both the db file and the downloads folder
dbfile = 'D:\\.adds\\koreader\\rakuyomi\\database.db'
download_path = "D:\\.adds\\koreader\\rakuyomi\\downloads"

def generate_filename(source, manga, chapter):
    hasher = hashlib.sha256()
    hasher.update(source.encode('utf-8'))
    hasher.update(manga.encode('utf-8'))
    hasher.update(chapter.encode('utf-8'))
    hash_result = hasher.digest()
    encoded_hash_bytes = base64.urlsafe_b64encode(hash_result)
    encoded_hash = encoded_hash_bytes.rstrip(b'=').decode('utf-8')
    output_filename = f"{encoded_hash}"    
    return output_filename

con = sqlite3.connect(dbfile)
cur = con.cursor()
manga_chapters_read = [a for a in cur.execute("select * from chapter_state where read=1")]
con.close()

for chapter in manga_chapters_read:
    file_name = generate_filename(chapter[0], chapter[1], chapter[2])
    chapter_file = f"{download_path}\\{file_name}.cbz"
    if os.path.exists(chapter_file):
        os.remove(chapter_file)
print("Done")