On Wed, Mar 21, 2007 at 08:24:27PM -0700, Bill Moseley wrote:
> On Mon, Mar 19, 2007 at 07:41:45AM -0700, bklaas wrote:
> >
> > Sebastian-
> >
> > would you be willing to post your modified script here? If not, could
> > you email it to the address on my profile?
>
> Sure, soon as I can get the md5 generation to match up what Amarok is
> doing.... ;)
Oops -- I'm not Sebastian.
What do you want the script to do?
I just wrote an (unrelated) script that moved all my music files into
directories <artist>/<album> based on the id3 or meta tags.
So, my script will just scan the music folder and then try and find
the album art by creating the md5 hash that Amarok uses to store the
image file -- then look for the image and hard link it into the
album's directory.
Not sure what to do when a directory contains multiple tracks where the
artist/album don't all match. I believe there should only be one
image file per album folder.
amarok=>
select distinct
artist.name,
album.name,
md5(lower( artist.name || album.name ))
from
tags
join artist on tags.artist = artist.id
join album on tags.album = album.id
where
tags.album = 795;
name | name | md5
----------------------------+-------------+----------------------------------
Bob Marley And The Wailers | Natty Dread | 93273eeff74ade8dbc2cef6293775280
(1 row)
And the associated album art:
.kde/share/apps/amarok/albumcovers/large/93273eeff74ade8dbc2cef6293775280
--
Bill Moseley
[EMAIL PROTECTED]
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
