Has anyone written something to dump the epg to a database?

koala

I'd like to run some reports on the EPG (basically, get a list of all movies in the guide. This is not straightforward, because channels here do not seem to add much structured information for this). I've been playing with /api/epg/events/grid?limit=9999999999999999999999, and it seems straightforward to upsert the data in SQLite/PostgreSQL... but I'm wondering if anyone has already implemented this, so I don't have to start from scratch.

Alternatively, what format is epgdb.v2 in? It has a header with GZIP00 in it, but it does not seem to be a .gz archive?

DeltaMikeCharlie

koala It has a header with GZIP00 in it, but it does not seem to be a .gz archive?

From memory, TVH uses an internal compression library when saving the EPG database. You can bypass this by browsing to the TVH server and navigating to 'Configuration -> General -> Base'. Look for 'EPG Settings' and then disable 'Compress EPG database'. Next time the EPG database is saved, it will be in an uncompressed format.

koala Alternatively, what format is epgdb.v2 in?

Don't quote me, but the internal database structure is just a stream of HTSP messages, one for each EPG record. There is a Python2 script somewhere on the system that can dump this data to the console.

tvheadend/tvheadendblob/master/support/epgdump

koala I've been playing with /api/epg/events/grid?limit=9999999999999999999999

There are also a number of filtering parameters that may be helpful.
https://docs.tvheadend.org/documentation/development/json-api/api-description/epg

koala epgdb.v2

Also, what version of TVH are you using? The latest uses epgdb.v3.

koala

Oh, it's 4.2.8- what some old version of LibreElec carries.

Eh, I think I'll go with the API. I would have preferred XMLTV, but I think the API JSON has a bit more information that might come in handy.

chewitt

koala it's 4.2.8- what some old version of LibreELEC carries.

LibreELEC also has the current Tvheadend 4.3 version in the addon repo.