Beispiel #1
0
 def search_track(self, string):
 
     sql = """
         SELECT
             tracks.name, tracks.duration, tracks.numalbum, tracks.id, tracks.license, tracks.id3genre, albums.id, albums.name, artists.id, artists.name, tracks.uid
         FROM
             tracks, albums, artists
         WHERE
             tracks.name LIKE '%""" + string + """%' and tracks.album_id=albums.id and albums.artist_id=artists.id LIMIT """ + str(self.parent.settings.get_value("PERFORMANCE", "db_search_limit"))
     ret = self.query(sql)
     tracks=[]
     for track in ret:
         tr = Track()
         tr.name = track[0]
         tr.duration = track[1]
         tr.numalbum = track[2]
         tr.id = track[3]
         tr.license = track[4]
         tr.id3genre = track[5]
         tr.album_id = track[6]
         tr.album_name = track[7]
         tr.artist_id = track[8]
         tr.artist_name = track[9]
         tr.uid = track[10]
         tr.stream = "http://api.jamendo.com/get2/stream/track/redirect/?id=%i&streamencoding=%s" % (track[3], self.parent.settings.get_value("JAMENDO", "format_stream", "mp31"))
         tracks.append(tr)
     return tracks
Beispiel #2
0
    def get_trackinfos2(self, trackid):
        sql = """
            SELECT
                tracks.name, tracks.duration, tracks.numalbum, tracks.license, tracks.album_id, tracks.artist_id, artists.name, albums.name, tracks.uid, tracks.id3genre, tracks.id
            FROM
                tracks, albums, artists
            WHERE
                tracks.id=%s and albums.id=tracks.album_id and artists.id=tracks.artist_id
            """ % str(trackid)
        ret = self.query(sql)
        if ret == []:
            return []
        ret = ret[0]
        tr = Track()
        tr.name = ret[0]
        tr.duration = ret[1]
        tr.numalbum = ret[2]
        tr.license = ret[3]
        tr.album_id = ret[4]
        tr.artist_id = ret[5]
        tr.artist_name = ret[6]
        tr.album_name = ret[7]
        tr.uid = ret[8]
        tr.id3genre = ret[9]
        tr.id = ret[10]
        tr.stream = "http://api.jamendo.com/get2/stream/track/redirect/?id=%i&streamencoding=%s" % (ret[10], self.parent.settings.get_value("JAMENDO", "format_stream", "mp31"))
#        tracks.append(tr)
        return tr
Beispiel #3
0
 def albumtracks(self, id):
     sql = """
         SELECT
             tracks.name, tracks.duration, tracks.numalbum, tracks.license, tracks.album_id, tracks.artist_id, artists.name, albums.name, tracks.uid, tracks.id3genre, tracks.id
         FROM
             tracks, albums, artists
         WHERE
             tracks.album_id=%s and albums.id=%s and artists.id=albums.artist_id
         """ % (str(id), str(id))
     ret = self.query(sql)
     tracks=[]
     for track in ret:
         tr = Track()
         tr.name = track[0]
         tr.duration = track[1]
         tr.numalbum = track[2]
         tr.license = track[3]
         tr.album_id = track[4]
         tr.artist_id = track[5]
         tr.artist_name = track[6]
         tr.album_name = track[7]
         tr.uid = track[8]
         tr.id3genre = track[9]
         tr.id = track[10]
         tr.stream = "http://api.jamendo.com/get2/stream/track/redirect/?id=%i&streamencoding=%s" % (track[10], self.parent.settings.get_value("JAMENDO", "format_stream", "mp31"))
         tracks.append(tr)
     return tracks
Beispiel #4
0
    def get_multiple_trackinfos(self, tracks):
        track_string = "("
        for track in tracks:
            track_string += " tracks.id=%s or" % track
        track_string = track_string[:-3] + ") and tracks.artist_id=artists.id and albums.id=tracks.album_id"
        sql = """
            SELECT
                tracks.name, tracks.duration, tracks.numalbum, tracks.license, tracks.album_id, tracks.artist_id, artists.name, albums.name, tracks.uid, tracks.id3genre, tracks.id
            FROM
                tracks, artists, albums
            WHERE 
                %s
            """ % track_string

        ret = self.query(sql)

        tracks=[]
        for track in ret:
            tr = Track()
            tr.name = track[0]
            tr.duration = track[1]
            tr.numalbum = track[2]
            tr.license = track[3]
            tr.album_id = track[4]
            tr.artist_id = track[5]
            tr.artist_name = track[6]
            tr.album_name = track[7]
            tr.uid = track[8]
            tr.id3genre = track[9]
            tr.id = track[10]
            tr.stream = "http://api.jamendo.com/get2/stream/track/redirect/?id=%i&streamencoding=%s" % (track[10], self.parent.settings.get_value("JAMENDO", "format_stream", "mp31"))
            tracks.append(tr)
        return tracks