Changeset 30 for mymrc

Timestamp:

07/20/07 09:52:25 (5 years ago)

Author:

dlefevre

Message:

Update

Files:

• mymrc/trunk/mymrc/src/db/audioqueries.py (modified) (2 diffs)

mymrc/trunk/mymrc/src/db/audioqueries.py

@@ -75 +75 @@
     ## Get the list of all albums from a given artist.
     def artistAlbums(self, aArtistName):
-        query = """SELECT audio_album.title AS album
+        query = """SELECT DISTINCT audio_album.title AS album
 FROM audio_artist, audio_album, audio_song
 WHERE audio_song.album_id = audio_album.id AND
@@ -119 +119 @@
     #  @param self The object pointer. 
     def addArtist(self, aArtist):
-        print "AddArtist: ", aArtist
         query = """INSERT INTO audio_artist(name)
 SELECT ?