コード例 #1
0
ファイル: dbthreaded.py プロジェクト: potato/burnstation2
 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"),
         )
         self.check_cache(tr)
         tracks.append(tr)
     return tracks
コード例 #2
0
ファイル: dbthreaded.py プロジェクト: asciimoo/burnstation2
 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
コード例 #3
0
ファイル: dbthreaded.py プロジェクト: potato/burnstation2
 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"),
     )
     self.check_cache(tr)
     #        tracks.append(tr)
     return tr
コード例 #4
0
ファイル: dbthreaded.py プロジェクト: asciimoo/burnstation2
    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