ozh/remove-read-kobo.md

Last active March 10, 2024 11:39

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ozh/4968d6054b5ca83ec0e2d385c7edc51e.js"></script>
Save ozh/4968d6054b5ca83ec0e2d385c7edc51e to your computer and use it in GitHub Desktop.

Download ZIP

Remove read books on kobo reader from the command line

Raw

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

Author

ozh commented Jul 12, 2022

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