Database Questions

What database contains the list of every show that has ever been recorded?

Is the fact that a show has been watched persist after the show has been deleted? If so, where?

Thanks,
Ken

No

One question down, one to go.

What is the name of the database that contains the list of every show that has ever been recorded, and what folder is it in? Or, is this information kept in some other way?

You can access it on http://x:8089/dvr/programs

What if I want to edit the information for a particular program so It is no longer marked as having been downloaded?

This thread talks about it. You can search forums for /dvr/programs apis

I'm sorry it is taking me so long to understand what questions I need to ask.

If I issue the command:
curl -XGET "http:/192.168.0.232:8089/dvr/files" > Files.json
It appears to get me a list of every program ever recorded. Is this correct?

What I need is just a list of every recording for just one series. Is there an API command that makes this possible, or do I have to try to extract the information from the full list?

You can view the Series episodes in a number of places.

  • DVR > Manage > Shows and filter All Shows dropdown to just that show
  • Library > TV Shows and pick the show
  • Look at the directory on disk where the show was recorded to and local content import directories it was imported from

/dvr/files lists the metadata of recordings and imports on your disk (i.e. haven't been deleted)
/dvr/programs lists the Program ID's that were recorded or imported, including those you deleted (except for those where your pass is set to rerecord deleted)

Hope that helps

I think you are missing what I'm trying to do.

For a single series, I want a list of all episodes that have been recorded and then deleted. I imagine, that I could write a program to extract this information from the giant data file I get from ...DVR/FILES, but I was wondering if I could just get this information on a single series.

The /dvr/files is a list of all current recordings. It does not include deleted recordings.

You can use /dvr/groups for a list of shows.

That's because I can't read your mind.

That's the first time you stated what you're looking to do

The only thing that keeps a list of deleted episodes is /dvr/programs

Thank you for clearing that up. Is there any API call that returns information on episodes that have been watched, deleted, and are no longer in the trash?

Channels obviously knows this because it does not normally download them a second time.

Once a recording is deleted, the watch state in /dvr/files is gone.

You could grep the dvr log file for deleted recordings

grep "\[DVR\] Deleted.*Gilligan's Island" /volume1/docker/channels-dvr/data/channels-dvr.log > "/volume1/arkives/Deleted Gilligan's Island episodes.txt"
2022/02/27 17:28:41.669948 [DVR] Deleted #4213 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E19 1966-01-27 Seer Gilligan 2022-02-27-1630.mpg (user)
2022/02/27 17:28:41.817182 [DVR] Deleted #4212 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E18 1966-01-20 The Postman Cometh 2022-02-27-1600.mpg (user)
2022/04/09 21:49:50.314899 [DVR] Deleted #4327 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E29 1966-04-07 The Friendly Physician 2022-04-03-1630.mpg (user)
2022/04/09 21:49:50.538522 [DVR] Deleted #4326 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E27 1966-03-24 Ghost a Go Go 2022-04-03-1600.mpg (user)
2022/04/09 21:49:50.618514 [DVR] Deleted #4303 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E28 1966-03-31 Allergy Time 2022-03-27-1630.mpg (user)
2022/04/09 21:49:50.789878 [DVR] Deleted #4302 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E26 1966-03-17 Will the Real Mr Howell Please Stand Up 2022-03-27-1600.mpg (user)
2022/04/09 21:49:50.886519 [DVR] Deleted #4287 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E25 1966-03-10 Operation Steam Heat 2022-03-20-1630.mpg (user)
2022/04/09 21:49:50.967367 [DVR] Deleted #4286 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E24 1966-03-03 Feed the Kitty 2022-03-20-1600.mpg (user)
2022/04/09 21:49:51.022860 [DVR] Deleted #4263 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E23 1966-02-24 Ship Ahoax 2022-03-13-1630.mpg (user)
2022/04/09 21:49:51.181101 [DVR] Deleted #4262 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E22 1966-02-17 Forward March 2022-03-13-1600.mpg (user)
2022/04/09 21:49:51.275687 [DVR] Deleted #4238 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E21 1966-02-10 Gilligans Living Doll 2022-03-06-1630.mpg (user)
2022/04/09 21:49:51.367149 [DVR] Deleted #4237 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E20 1966-02-03 Love Me Love My Skipper 2022-03-06-1600.mpg (user)
2022/04/24 16:29:55.245265 [DVR] Deleted #4396 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S01E01 1964-09-26 Two on a Raft 2022-04-22-0730.mpg (user)
2022/05/24 10:08:25.467107 [DVR] Deleted #4659 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S02E05 1965-10-14 The Sweepstakes 2022-05-24-0830.mpg (user)
2022/05/24 10:08:25.686758 [DVR] Deleted #4650 /shares/dvr/TV/Gilligan's Island/Gilligan's Island S01E36 1965-06-12 A Nose by Any Other Name 2022-05-24-0600.mpg (user)

Yes, I understand that the watched state is gone. I will look into the log idea.

However, Channels knows what programs have been recorded since day 1. I'm sure that it is not using the log file for this. I'm still trying to find out how I can access the list of past recordings.

The list of programs ever recorded is in /dvr/programs

Got it. Is there a link I can match up to another database to identify which records in "programs" go to which shows?

Nope. What you see is all that we store

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.