database query for videos

For discussion related to MythTV which doesn't belong in another forum.

Moderator: Forum Moderators

Post Reply
mtrax
Junior
Posts: 40
Joined: Sat Aug 16, 2014 6:44 am
Australia

database query for videos

Post by mtrax » Sun Jun 14, 2020 2:51 am

how do I figure out what query to use?
I want to query the most recent "videos" imported"
is this using the videometadata table?
I got this but what happens when you rename and re-scan?

wmorrison
Senior
Posts: 129
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: database query for videos

Post by wmorrison » Sat Aug 08, 2020 6:37 pm

What are you using for database access? I'm using DBeaver now, both directly on my MythTV box and also on my Windows laptop via ssh tunnel. Works great for browsing tables.

Most of my queries are to get info on program schedule and recordings, not videos, but maybe this will get you started:

select title,subtitle,inetref,filename,insertdate from videometadata
where date(insertdate) > date_sub(CURDATE(), interval 30 day)
order by insertdate DESC;

Post Reply