Originally this was among my very first three requests, but it was made only now. Thanks, DZAladan!
#!/usr/bin/env python #-*- coding: UTF-8 -*- import sqlite3 import mutagen.id3 from mutagen.easyid3 import EasyID3 from mutagen.mp3 import MP3 from subprocess import call def getStuff(database): conn = sqlite3.connect(database) c = conn.cursor() result = c.execute("SELECT LocalCopyPath, Title, Album, Artist, Composer, Genre, Year FROM MUSIC WHERE Id IN (SELECT MusicId FROM SHOULDKEEPON)") stuff =  for track in result: stuff.append(track) # Let's be good programmers and close the connection to database, even though there were only read operations conn.
New year thanks ---------------
And as a new year begin, time for me to thank some people from the latest:
Once again I promote this track I made. Read the description at YouTube for more details if you’re interested in them.
[@SoapieSolar], [@Haiku_Oezu], [@fsLeg], looks like you're the best people of this year. Yaaaay!
Nailed it! This year wasn’t a waste after all.