Database format changed

This forum is for questions / discussions regarding development of addons / tweaks for MediaMonkey.

Moderator: Gurus

Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: Database format changed

Post by Owyn » Mon Nov 09, 2009 2:24 pm

Yep. The SQL Viewer is an invaluable tool.

I use it almost daily and at times extensively. Just about every SELECT I have written for a script has been unit-tested in the viewer. And, a lot of scripts are not required because I just need to see the llibrary data in a way that MM can't show me via the UI.

PS: Remember, you can't break anything with a SELECT, it just reads the data. UPDATE and DELETE however are for experienced use only, and preferably with a recent backup. :)
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Database format changed

Post by Bex » Mon Nov 09, 2009 2:28 pm

Thanks, Owyn!

An update of that script is actually in the workshop right now. We'll see when it gets released.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: Database format changed

Post by Owyn » Tue Nov 10, 2009 7:13 am

FYI: I just now had a need to do some Genre cleanups myself.

I used Bex's Tagging Inconsistencies script to find low usage genres.

Navigate to Library->Files to Edit
Expand Tagging Inconsistencies node
Expand Genres node
Expand Few Tracks node

Bob's your uncle.
Now you have a review list and can edit track data/genres completely within MM.

Sort of off topic, but, it is best to look for a native or integrated (e.g. the Tagging Inconsistencies script) solution to an update problem.

If the list is a bit long, I just pick an arbritary point to stop cleaning up for a while and go back to the "node" later.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies

Post Reply