Automatic adding Internet Radio streams to LinuxMCE

[Dap-P]

Had some sparetime, and name some progress on the script,

New features:
- Use variable for tempfile
- Check if the Url is already in the DB before adding
- Reuse genre if it exists
- Adds genre if it not exists
- Uses SELECT MAX(id) to find out last added row

@sambuca, i couldn't get a working SELECT LAST_INSERT_ID, i think if it because i used 2 seperate mysql -e statements, If MAX(id) is not suitable, i have to make LAST_INSERT_ID working somehow

Attached is the new version

Anton

[Marie.O]

use it in the same connection, as I outlined in a previous post:

mysql pluto_media -e "INSERT INTO File (Filename) Values ('abcd'); SELECT LAST_INSERT();"

As you see, you have two statements, on a single connection. That way, you get the last inserted ID.

[Dap-P]

I thought it would work that way, when i realised it didn't work as plan. thanks!!!

Here 2 new scripts,
 - add radiostations with select_last_id
and
 - delete radiostations

Anton

[Marie.O]

The first file doesn't look right in line 25

[Dap-P]

What does not look right?
to me it seems correct, i do the insert, and last_insert in 1 command, with the output in $PK_File var

it even works for me

Anton

[WhateverFits]

What does not look right?
to me it seems correct, i do the insert, and last_insert in 1 command, with the output in $PK_File var

it even works for me

Anton

The lines are tuncated:

Code: [Select]

               PK_File=$(mysql pluto_media -e "insert into File (EK_MediaType,DateAdded,Filename,Missing,IsDirectory,IsNew) VALUES(43,NOW(),'$Url',0,0,1);$

                #Add Station Name to Database
                FK_Attribute=$(mysql pluto_media -e "insert into Attribute (FK_AttributeType,Name) VALUES(10,'$Station');select LAST_INSERT_ID() from Attri$


[Dap-P]

My mistake...

Here are the correct ones:

[WhateverFits]

Thanks! Looks good, now I can test it.

[Marie.O]

Looks much better. One more little thing. To get rid of the tail -1 you have, use

mysql pluto_media -ss -e "SELECT 123"

That way, it will only return the resultset without any fieldname etc. The two 's' are the reason for mysql to be (s)ilent.

[Dap-P]

New update

Added a description to the script,
added the -ss flag, and removed tail -n1
added the Download Url to a variable
in the delete script added a loop, so that it reads all urls, and checks that in the database


In general, would it be wise to add multiple files to the same radiostation? Now i just grab the first one.

Anton

[WhateverFits]

In general, would it be wise to add multiple files to the same radiostation? Now i just grab the first one.

So far, this looks rather good. I've tested the prior version and now I'm going to test this one. It works great! I did have a duplicate URL attempted to get inserted and it failed gracefully. Very nice. Now, can you give an example of multiple files and the same radiostation? Example XML would be good to know what you are talking about.

Thanks for the good work!

[Dap-P]

New update :

Now it is only 1 script

Added a show function, this will display all local radio stations, with their Url's and Genre

Anton

Edit: Somehow i broke the script... i will check it now
Edit 2: I think it is working again
I had to readd the tail -n1 for some commands, apparently the insert_last_id somehow returned multiple lines

[Dap-P]

Who has tested this, and what were the results?

Also, is it more clear, what i mean with multiple Urls for the same radiostation?


Anton

[ardirtbiker]

It worked for me.. no problems

Sent from my SCH-I535 using Tapatalk 4

[ladekribs]

It worked for me also, no problems either. Nice!

BR Stefan