Read Me

    * SqlTagger
      </wiki/moin.cgi/SqlTagger?action=fullsearch&context=180&value=linkto%3A%22SqlTagger%22>

Contents

   1. Summary <#Summary>
   2. Downloading <#Downloading>
   3. Installation <#Installation>
   4. Running the Program <#Running_the_Program>
   5. SQLite Function Extensions <#SQLite_Function_Extensions>
   6. Changing Audio Tags <#Changing_Audio_Tags>
   7. Examples <#Examples>
         1. Fix Genres <#Fix_Genres>
         2. Merge a Two-disc Album Into a Single Virtual Album
            <#Merge_a_Two-disc_Album_Into_a_Single_Virtual_Album>
         3. Show File Types <#Show_File_Types>
         4. Set the Comment Based On Other Fields
            <#Set_the_Comment_Based_On_Other_Fields>
         5. Show The Five Longest Files <#Show_The_Five_Longest_Files>


    Summary

Edit audio tags using SQL.

Reads tags of audio files from a directory, loads them into a temporary
SQLite database, accepts SQL queries to modify this database, then saves
any changes back to the audio files.

It's useful for performing complex updates that would be difficult or
tedious with conventional taggers. It's a complement to conventional
taggers like EasyTAG <http://easytag.sourceforge.net/>, not a replacement.


    Downloading

The program is available on SourceForge:
https://sourceforge.net/projects/sqltagger/files/


    Installation

Copy the file anywhere in your path. You need Python 2.x as well as
these modules:

    * apsw
    * tagpy 

In Ubuntu you can install those with this command:

$ sudo apt-get install python-apsw python-tagpy


    Running the Program

To run the program:

$ sqltagger.py /path/to/audio/directory

[ wait for reading ]

Enter an SQL command, or "help" for more options.
SQL-Tagger>

For full details and examples, see https://sites.google.com/site/joatca/projects/sql-tagger

Author: Fraser McCrossan

Bug reports or comments to me: frasermccrossan@gmail.com