Remove read books on kobo reader from the command line

remove-read-kobo.md

Shell in the kobo, from the root :

sqlite3 -header .kobo/KoboReader.sqlite "SELECT ContentID FROM content WHERE BookTitle is null and ReadStatus = 2 ORDER BY Title;" | grep epub | sed 's!file:///mnt/onboard/!!' | while read f; do rm -f "$f"; done

To list before removal :

sqlite3 -header .kobo/KoboReader.sqlite "SELECT ContentID FROM content WHERE BookTitle is null and ReadStatus = 2 ORDER BY Title;" | grep epub | sed 's!file:///mnt/onboard/!!' | while read f; do echo "-> $f"; done

Using an online SQLite viewer like https://inloop.github.io/sqlite-viewer/ : list all read books

SELECT 
    Title,
    Attribution as Auteur,
    DateLastRead as DateTermine,
    ___PercentRead as PourcentageLu
FROM content 
WHERE ContentType = '6' 
    AND ReadStatus = 2  -- Terminé
    AND Title IS NOT NULL
    AND Title != ''
ORDER BY DateLastRead DESC;