Way of telling if a scheduled recording has been added/deleted

[bgowland]

Clutching at straws here but is there an 'external' way to tell if a new recording has been scheduled (or an existing one cancelled)? By 'external' I mean not using a plugin within NextPVR.

Cheers,
Brian

[sub]

No. You'd probably have to poll the database, comparing with the results last time you polled.

[bgowland]

No. You'd probably have to poll the database, comparing with the results last time you polled.

I had a feeling you might say that.

Querying the sqlite_sequence table for the 'seq' value will be light-weight enough for checking for new recordings but checking for deletions will be a bit heavier. Oh well, thanks as ever for the response.

Cheers,
Brian

[bgowland]

Just to revisit this...

As there's no external way of telling if a recording has been scheduled / cancelled - is there an 'internal' way? In other words, is there an event which plugins can listen for so they receive schedule/cancel notifications?

Cheers,
Brian

[mvallevand]

Certainly not sub approved, but if you created a new table you could add a trigger to keep a list of deleted oid's that you could manage externally.

Code:

create table [bgowland] (
    [scheduled_recording_oid] integer NOT NULL
);

Code:

create trigger deleteRecording after delete on scheduled_recording
begin
insert into bgowland (scheduled_recording_oid) values (old.oid);
end

Martin

[bgowland]

Thanks Martin. Something to think about but obviously not ideal and, as you say, not an approved approach.

Ideally I was hoping that I could create a 'dummy' plugin for ndroid (ideally without UI but I can't remember if that's possible). If there are events that plugins can register for I could pass data through to the ndroid service. Just running through possible approaches for syncing actions across devices.

Cheers,
Brian

[sub]

As there's no external way of telling if a recording has been scheduled / cancelled - is there an 'internal' way? In other words, is there an event which plugins can listen for so they receive schedule/cancel notifications?

No. The event system only works for events in the local process. If I used it to notify of new recordings being scheduled, you'd only hear about some of the recordings, since some would be scheduled by the recording service, and possibly other instances of the client.

[mvallevand]

Thanks Martin. Something to think about but obviously not ideal and, as you say, not an approved approach.

I woke up thinking that the solution was like overkill anyway. Just use "Attach" to link your database and npvr.db3 and then it is a simple matter of doing this when necessary

select * from myscheduled_recordings where myoid not in (select oid from npvr.scheduled_recording)

Martin

[bgowland]

you'd only hear about some of the recordings, since some would be scheduled by the recording service, and possibly other instances of the client.

Of course, thanks. It had occurred to me that it wouldn't work for activity via NEWA, but I hadn't considered npvr clients or recordings generated by the service as part of a recurring recording, for example.

Just use "Attach" to link your database and npvr.db3 and then it is a simple matter of doing this when necessary

select * from myscheduled_recordings where myoid not in (select oid from npvr.scheduled_recording)

Actually that's a nice approach - I hadn't thought of that, thanks.

I was really just clutching at straws again to try to avoid polling for DB changes but I realise it's my only option. My dev versions of ndroid and the service are C2DM enabled which I intend to use to sync ndroid clients. For it to be of use, the service needs to push messages out ASAP after a schedule/cancel action and I'm just slightly worried that polling too frequently might have a detrimental effect. Guess I'll just have to try it.

Cheers,
Brian