Thanks Nick,
Not sure I get what you mean though?
Ian
On Sat, 23 Mar 2019 at 22:40, Nicholas Vrtis <nick.vr...@gmail.com> wrote:
> Don't have the code with me.. but I do something similar. I use the
> annotate: protocol when SOAP asks for the file name, and pass along the SQL
> row ID from the db. That puts it in the meta.
>
> Nick
>
> On Saturday, March 23, 2019, Ian Bonham <ian.bon...@gmail.com> wrote:
>
>> Good afternoon all,
>>
>> I wonder if anyone could offer some advice please?
>> I'm building a recipe for 'Soap and it's working rather well. However I
>> would like to know if there is a way to grab the currently playing file
>> name as it begins?
>> Basically I have a MariaDB with all my tracks in, and I want to use a
>> system call from my .liq script to push a mysql update via bash to update
>> the database with the "Last Played" datetime.
>>
>> I am trying :
>> *#!/usr/bin/liquidsoap -v*
>>
>> *def process_metadata(metadata)*
>> * file_name = ""*
>> * file_name = metadata["filename"]*
>> *# [("file_name","#{file_name}")]*
>> *end*
>>
>> and then am using :
>> *stream = on_track(process_metadata, stream)*
>>
>> *cmd = "mysql -u suffolksoundadmin -phackme -e \"UPDATE
>> \`Music\`.\`Tracks\` SET \`playcount\` = \`playcount\` +1, \`lastplay\` =
>> NOW() WHERE \`Music\`.\`Tracks\`.\`filename\` = '#{file_name}';\""*
>>
>> *system(cmd)*
>>
>> I just can't get the thing to work though. When I try to call the script,
>> it bombs out with:
>> *At line 40, char 7-198: the variable filename used here has not been*
>> * previously defined.*
>>
>> If anyone could offer some guidance I'd be really grateful.
>> Many Thanks,
>>
>> Ian
>>
>> _______________________________________________
> Savonet-users mailing list
> Savonet-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/savonet-users
>
--
Kindest Regards,
Ian Bonham
ian.bon...@gmail.com
Mobile : +44 (0)7396 103 957
Skype : ian.bonham
_______________________________________________
Savonet-users mailing list
Savonet-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/savonet-users
