Index all the files in the source directory.
For each file, check if the file exists in the destination directory.
(Ignore the file extension, only check for the file name).
If the file does not exist:
Connect to the MySQL database.
Lookup the filename in the “filename” column of the “files” table, get the “trackid”.
Lookup the “trackid” (from above) in the “id” column of the “tracks” table, get the “artist” and “title”.
Lookup the “artist” (from above) in the “id” column of the “artists” table.
List any files that were skipped because they could not be found in the database in a text file on the desktop.
Create a copy of the file in the destination directory.
- The resolution must be 1280 × 720.
- The metadata must contact the “artist” and “title” gained from the MySQL search.
- The file name must be the same as the source, the extension must be MP4.