KODI watched Episodes

The issue

Although Kodi is one of the better media centres out there, and I've been using it for some while ever since mediaportal went down hill, there have been some annoying changes that the developers make in removing key features from the user interface that are essential to the way people watch stored programs, such as;

How do I remove all the ticks for a watched TV series or program?

Kodi when it was XBMC and with the Confluence skin used to have a very useful option that if you right clicked the TV Series folder, you could unwatch the entire series.  When rebadged as Kodi they decided that this feature wasn't something people used - typical of developers who don't use something themselves, or talk to their community enough.

Having dug through some Kodi docs, and helpful people on line that have tried to solve this scenario, and without having to go through each item one by one to untick them I'm on the quest to write a script, and possibly a plug-in that will solve this long lost useful item of the media centre (yes I'm British so I will spell centre in this way, for the rest of you translate to center, until the UK and USA become a continent now that Brexit is in full swing and Europe in continuing to do what they've always done).  Tell you what though it would be a more impressive tunnel :-)

Sorry, I digress on issues that are of no interest at this moment in time.

The Tools

To achieve the desired result we need to now dig in to the Kodi database which is stored in the users home directory that you run Kodi as;

$HOME/.kodi/userdata/Database

From here we will need to work with the MyVideo??.db file, in my case MyVideo99.db

These files are sqlite3 database files so the following will be of use;

• sqlitebrowser
• A graphical tool for easily viewing the schema
• sqlite3
• CLI tool for working with these database files
• Handy if you prefer to write Shell scripts to control the DB schema and data
• sqlite3 python library
• import sqlite3

The Table

The table required is called files.