Query The Recording Schedule From The Command Line (1 Viewer)

[CyberSimian]

I have been using MP as my DVR for around three months now (MP 1.9.0 pre, aMPed skin, 32-bit Vista). It worked straight out of the box, but the "tweaks" take much longer!

I have an occasional problem that I could solve by writing a batch script that did some extra processing at certain times. But I need as input to this script details of the recording schedule (specifically: details of the next programme that is due to record).

The script that I would write would be in the obscure REXX scripting language, but I really doubt that there is a REXX interface to MP. So what I am looking for is a command-line tool that would query the recording schedule, and then write it to a temporary file in some defined format. The command-line tool could be an EXE file written in a compiled language, or it could be a script written in some other language (VBS, PYTHON, ...); the only requirement is that it be invokable from the command line, and write the output to a file.

Can anyone point me to an existing tool or script, or provide a sample of how to do it? (My knowledge of VBS is almost zero, and my knowledge of PYTHON and other scripting languages is completely zero, so it might need to be a fairly complete example!) Thank you.

-- from CyberSimain in the UK

 

[Vasilich]

as all the schedules are stored in DB, maybe it is easier to let script query the database instead of involving MP into it?
smth like http://dev.mysql.com/doc/refman/5.6/en/batch-mode.html may help

 

[CyberSimian]

as all the schedules are stored in DB, maybe it is easier to let script query the database instead of involving MP into it?
smth like http://dev.mysql.com/doc/refman/5.6/en/batch-mode.html may help

Thank you! Using an SQL script might well provide what I need. I will read the on-line help that you referenced.

I vaguely remember that the REXX scripting language does have an interface to SQL, although that may not be the MySQL that MP 1.9 uses. I have never used SQL, so this is all new to me!

-- from CyberSimian in the UK