#40 automatically create groups

open
nobody
None
5
2003-11-23
2003-11-23
snotblower
No

This automatically creates groups and populates them...
currently 2 criteria:

1) if you have an artist with more than 50 songs,
create a group named after the artist and populate it.
(ignores artist /^various/).
2) For each genre represented in the songs database,
create a group named after the genre and populate it.

I noticed that there is not a key on the name field,
which means it is possible to create multiple groups
with the same name. The db fix is to fix that in the
table. This should make it safe to rerun the autogroup
script (and ignore a zillion errors).

oh and... I havent played with sql in over 15 years. I
suspect someone with a little more recent experience
would have a better way to insert this junk. I did it
brute force because doing it any other way would force
me to actually read documentation. Ugh.

Discussion

  • snotblower
    snotblower
    2003-11-23

    perl script to create groups automatically

     
    Attachments