[mythtv-users] Moving xmltv data 1 hour back on one channel
Simon Hobson
linux at thehobsons.co.uk
Sat Sep 7 08:56:24 UTC 2013
Could you do it manually with a script ?
Just a simple script that is triggered after a grabber run and does something along the lines of :
select ... , (time - 1 hour) as time, 'y' as channel, ... from listingstable where channel = 'x' into temp ;
delete from listingstable where channel = 'y' ;
insert into listings select * from temp ;
And calls mythbackened to trigger a reschedule.
I'll leave it to someone who's not very rusty with SQL (and familiar with MySQL) to work out the right syntax.
More information about the mythtv-users
mailing list