SQL-Viewer 2.4 [Script] 2009-10-25

[Owyn]

Bex:
Conflict between installing your script and the 1201+ upgrade process adding the new Export to OPML script.

Test case:
Clean install 1190 (new AppData MediaMonkey folder)
Install SQL Viewer
Install / upgrade to 1204.

The Export to OPML section does not get added to scripts.ini.

Works fine if I don't install SQL Viewer.

I think it might be caused by no blank line preceding the SQL Viewer section in scripts.ini.

See Mantis 3252

[Bex]

Hmm, I don't have any Export to OPML script either. Well, I have the script file but no Scripts.ini entry for it.
I don't think it's due to SQL-Viewer though. It seems that the OPML script fails to install properly (i.e. add the scripts.ini part) if your scripts.ini contains custom scripts. Sounds very strange though.

[nynaevelan]

I have two 3.1 installations, the one with scripts installed I do not have the script.ini entry for opml, the installation without any scripts has both the vbs file and the scripts.ini entry so something must be preventing it from being installed...

Nyn

[Bex]

The "Export to OPML"-script issue is fixed by Ludek in build 1205.

[Teknojnky]

Anyone know off hand what the sql update would be to clear all album volume level, only for db? Basically I want to clear it and let MM recalc and update in the background without having to clear it from 150k tracks too.

[nynaevelan]

Here's what I use:

Code: Select all

UPDATE Songs SET NormalizeTrack ='-999999.0' WHERE NormalizeTrack > '-999999.0'

Nyn

[Teknojnky]

Thanks, I'll give it go tonite.

[gege]

Anyone know off hand what the sql update would be to clear all album volume level, only for db? Basically I want to clear it and let MM recalc and update in the background without having to clear it from 150k tracks too.

What about Undo Volume Analyzing script?
It is a bit old, but I think it will work, with some tweaks...
You'll probably need to replace these lines...

Code: Select all

Sng.Leveling=-999999
Sng.UpdateDB
Sng.WriteTags

... by these...

Code: Select all

Sng.LevelingAlbum=-999999
Sng.UpdateDB
'Sng.WriteTags

... in order to have Album Leveling cleared (instead of Song Leveling) and only DB updated, not tags.

Of course, it will take you more time to complete the task than an SQL update...

Edit: Ok, nyn, you've beaten me

[nynaevelan]

Since we're on the subject of sql statements is there a way to create an autoplaylist or an sql statement that would identify albums that have some tracks with an original date??

Gege:

I thought of that but it is not as quick as SQL Viewer...

Nyn

[Bex]

Anyone know off hand what the sql update would be to clear all album volume level, only for db? Basically I want to clear it and let MM recalc and update in the background without having to clear it from 150k tracks too.

This will do it. No WHERE clause is needed since you want to update all tracks:
Album level:

Code: Select all

UPDATE Songs SET NormalizeAlbum =-999999.0

Track level:

Code: Select all

UPDATE Songs SET NormalizeTrack=-999999.0

(You know Tekno, but to others:)
Note that the tag of the tracks is not affected only the database.

[Bex]

Here's what I use:

Code: Select all

UPDATE Songs SET NormalizeTrack ='-999999.0' WHERE NormalizeTrack > '-999999.0'

Nyn

Even though this one works there is no need to use ' around Number fields. But SQLite is very forgiving and understands it anyway!
NormalizeTrack is for tracks I guess you meant NormalizeAlbum.

[Bex]

Since we're on the subject of sql statements is there a way to create an autoplaylist or an sql statement that would identify albums that have some tracks with an original date??

Gege:

I thought of that but it is not as quick as SQL Viewer...

Nyn

Here you go:

Code: Select all

SELECT ID, Artist, SongTitle, Album, OrigYear FROM Songs WHERE IDAlbum IN
(SELECT IDAlbum FROM Songs 
GROUP BY IDAlbum
HAVING COUNT(CASE WHEN OrigYear<=0 THEN 1 ELSE NULL END)<COUNT(*))

If you want I can add it to TI?

[nynaevelan]

Yes I would LOVE it if you added it to TI, but can you make one minor adjustment to the SQL, can you add the feature to have the results sent to a playlist? The playlist id is 7447.

Nyn

[Bex]

Sure!

Code: Select all

INSERT INTO PlaylistSongs (IDPlaylist, IDSong) SELECT ThePlaylistIdHere, Songs.ID FROM songs WHERE bla bla bla

ThePlaylistIdHere=7447
bla bla bla=

Code: Select all

IDAlbum IN
(SELECT IDAlbum FROM Songs 
GROUP BY IDAlbum
HAVING COUNT(CASE WHEN OrigYear<=0 THEN 1 ELSE NULL END)<COUNT(*))

Give this:

Code: Select all

INSERT INTO PlaylistSongs (IDPlaylist, IDSong) SELECT 7447, Songs.ID FROM songs WHERE IDAlbum IN
(SELECT IDAlbum FROM Songs 
GROUP BY IDAlbum
HAVING COUNT(CASE WHEN OrigYear<=0 THEN 1 ELSE NULL END)<COUNT(*))

A new node will added to TI in the next version!

[nynaevelan]

Thanks for the SQL and the future update to TI.

Nyn