Results 1 to 6 of 6

Thread: Quick Question - Locking Files in Bulk

  1. #1
    Join Date
    Mar 2012
    Posts
    126

    Default Quick Question - Locking Files in Bulk

    I'm working on validating all the metadata for my music (a daunting task).

    I'd like to lock all the files after I am done, and I'm hopeful that it will reduce indexing time as I add new stuff. Right now, all the music files are unlocked, and there are several hundred thousand of them, which would be painful through the GUI. I'm ensuring the metadata source is accurate (not using web metadata), as opposed to using the Mezzmo GUI, so once the metadata is set, I want it to ignore any file/object that has the "Locked" flag set.

    It doesn't look like the CLI offers this kind of bulk management.

    Is there a way to connect to the Mezzmo database directly, and if so, is there a query I can run that tells Mezzmo to tick the "Locked" flag on all the music files?

    Thanks!

  2. #2
    Join Date
    Jun 2012
    Posts
    1,006

    Default

    Quote Originally Posted by hsbrown2 View Post
    I'm working on validating all the metadata for my music (a daunting task).

    I'd like to lock all the files after I am done, and I'm hopeful that it will reduce indexing time as I add new stuff. Right now, all the music files are unlocked, and there are several hundred thousand of them, which would be painful through the GUI. I'm ensuring the metadata source is accurate (not using web metadata), as opposed to using the Mezzmo GUI, so once the metadata is set, I want it to ignore any file/object that has the "Locked" flag set.

    It doesn't look like the CLI offers this kind of bulk management.

    Is there a way to connect to the Mezzmo database directly, and if so, is there a query I can run that tells Mezzmo to tick the "Locked" flag on all the music files?

    Thanks!
    You can do it via the GUI for everything in a playlist. Select the first item in the playlist, hold down the shift key on the last item and click it. This should select all of the items. Then go to properties, and click the lock button in the top right corner and Click Ok.

    In the database there is a table called MGOFile and a column called lock. A 1 in that field indicates a lock for the file in that line. A 0 is unlocked.

  3. #3
    Join Date
    Mar 2012
    Posts
    126

    Default

    In the GUI is fine if you’re just doing a few, but if you try to shift+select too many at once, it bombs. With close to a million files using the GUI would take months, but update blah Set blah = 1 where blah=0 would be infinitely faster. What tools are there to execute queries? I think it’s SQLite but I’m not sure. Is there a free management studio somewhere? How do I connect to the DB?

  4. #4
    Join Date
    Jun 2012
    Posts
    1,006

    Default

    I use DB Browser for SQL Lite . It works great and you can write, run your own SQL statements or cut/paste in bulk. Just make sure you do a backup before starting.

  5. #5
    Join Date
    Mar 2012
    Posts
    126

    Default

    Perfect! UPDATE MGOFile SET Lock = '1' WHERE Lock = '0' worked like a charm (I just locked everything at this point, although there are a couple of items I still need to fix).

  6. #6
    Join Date
    Jun 2012
    Posts
    1,006

    Default

    Yep, that SQL query will do it. Glad it worked for you.

Similar Threads

  1. FFMPeg Locking Files
    By ftanner in forum Mezzmo Questions and Support
    Replies: 17
    Last Post: 08-15-2017, 09:21 AM
  2. Quick Question Regarding Category
    By hsbrown2 in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 03-22-2017, 12:23 PM
  3. Quick Question - NAS Support
    By mark11 in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 08-14-2012, 10:49 AM
  4. 2 quick question
    By richard_iii in forum Mezzmo Questions and Support
    Replies: 3
    Last Post: 01-20-2011, 11:16 AM
  5. Unable to download video files in bulk
    By aloha in forum DownloadStudio Wish List and Feedback
    Replies: 4
    Last Post: 10-11-2010, 07:53 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •