Code
#!/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.
