Exemple #1
0
 def getAllAlbums(self):
     d = sw.queryOnce(qc.query("music_dbfile"),"""
 SELECT 
    album.gid as album_mbid,
    album.name as album_name
 FROM  album
 LIMIT 20;
 """)
     for item in d: item['name']= item['album_name']
     return d
Exemple #2
0
 def getAllArtists(self):
     d = sw.queryOnce(qc.query("music_dbfile"),"""
 SELECT 
    artist.name as artist_name, artist.gid as artist_gid
 FROM artist
 """)
     for item in d: 
         item['name'] = item['artist_name']
         item['artist_mbid']= item['artist_gid']
     return d
Exemple #3
0
 def getAllTracks(self):
     d = sw.queryOnce(qc.query("music_dbfile"),"""
 SELECT 
    track.gid as track_mbid,
    track.name as track_name
 FROM  track 
 LIMIT 20;
 """)
     for item in d: item['name']= item['track_name']
     return d
Exemple #4
0
 def getMBIDAlbumMembers(self,gid):
     d = sw.queryOnce(qc.query("music_dbfile"),"""SELECT
 track.name as track_name, artist2.name as artist_name
 from album,albumjoin , artist as artist2, track, l_artist_track as art_track
 where album.gid = :gid
 AND albumjoin.album = album.id
 AND albumjoin.track = track.id
 AND art_track.link0 = artist2.id
 AND art_track.link1 = track.id
 LIMIT 20;
 """,params = {'gid':gid})
     for item in d: item['name']= item['artist_name']
     return d
Exemple #5
0
 def getMBIDAlbumInfo(self,gid):
     d = sw.queryOnce(qc.query("music_dbfile"),"""
 SELECT 
    album.gid as album_mbid,
    album.name as album_name,
    artist.name as artist_name
 FROM artist, album
 WHERE album.gid = :gid 
 AND   album.artist = artist.id 
 """,params={'gid':gid})    
     for item in d:
         item['name'] = item['album_name']
     return d
Exemple #6
0
 def getMBIDArtistTracks(self,gid):
     d = sw.queryOnce(qc.query("music_dbfile"),"""
 SELECT 
    track.gid as track_mbid,
    track.name as track_name,
    artist.name as artist_name
 FROM artist, track 
 WHERE artist.gid = :gid 
 AND   track.artist = artist.id 
 LIMIT 20;
 """,params = {"gid":gid})
     for item in d: 
         item['name']= item['track_name']
     return d 
Exemple #7
0
 def getMBIDAlbumTracks(self,gid):
     d = sw.queryOnce(qc.query("music_dbfile"),"""
 SELECT 
    track.gid as track_mbid,
    track.name as track_name,
    album.name as album_name,
    track.number as track_number,
    track.length as track_length
 FROM  album, albumjoin, track 
 WHERE album.gid = :gid 
 AND   albumjoin.album = album.id 
 AND   track.id = albumjoin.track
 ORDER BY track_number
 """,params = {"gid":gid})
     for item in d: item['name']= item['track_name']
     return d