def get_track_row(self):
row = self.db.fetchone()
tid = row['track_id']
position = row['position']
ptid = row['id']
self.db.commit_statement('''select * from tracks where id = ?''', [row['track_id']])
row = self.db.fetchone()
del row['id']
t = Track(**row)
t.id = tid
t.position = position
t.ptid = ptid
return t
def get_track_row(self):
row = self.db.fetchone()
tid = row["track_id"]
position = row["position"]
ptid = row["id"]
self.db.commit_statement("""select * from tracks where id = ?""", [row["track_id"]])
row = self.db.fetchone()
del row["id"]
t = Track(**row)
t.id = tid
t.position = position
t.ptid = ptid
return t
def _get_tracks_list(self, query): self._cur.execute(query) rows = self._cur.fetchall() result = [] for row in rows: t = Track() t.id = row["id"] t.subfile_no = row["subfile_no"] t.title = row["title"] t.offset = row["offset"] t.size = row["size"] t.filehash = row["filehash"] t.created_at = row["created_at"] result.append(t) return result;
def get_all_tracks(self):
self.db.commit_statement('''select * from playlist_tracks where playlist_id = ?''', [int(self.id)])
row = self.db.fetchone()
tracks = []
while row != None:
tracks.append((str(row['id']), row['track_id'])) # FIXME: broken!
row = self.db.fetchone()
ret_tracks = []
for track in tracks:
# TODO: replace with an SQL statement that instantly creates a Track object
self.db.commit_statement('''select * from tracks where id = ?''', [track[1]])
row = self.db.fetchone()
del row['id']
t = Track(**row)
t.id = track[0] # add the playlist-to-track id instead
ret_tracks.append(t)
return ret_tracks
def get_track_nbr(self, nbr):
self.db.commit_statement('''select * from playlist_tracks where playlist_id = ?''', [int(self.id)])
row = self.db.fetchone()
# There is probably a much smarter way to fetch a specific row number
i = 0
while i < nbr:
row = self.db.fetchone()
i = i + 1
tid = row['id']
self.db.commit_statement('''select * from tracks where id = ?''', [row['track_id']])
row = self.db.fetchone()
del row['id']
t = Track(**row)
t.id = tid
return t
def get_all_tracks(self):
self.db.commit_statement(
"""select * from playlist_tracks where playlist_id = ? order by position""", [int(self.id)]
)
row = self.db.fetchone()
tracks = []
while row != None:
tracks.append((str(row["id"]), row["track_id"])) # FIXME: broken!
row = self.db.fetchone()
ret_tracks = []
for track in tracks:
# TODO: replace with an SQL statement that instantly creates a Track object
self.db.commit_statement("""select * from tracks where id = ?""", [track[1]])
row = self.db.fetchone()
del row["id"]
t = Track(**row)
t.id = track[0]
ret_tracks.append(t)
return ret_tracks
def get_all_tracks(self):
self.db.commit_statement('''select * from playlist_tracks where playlist_id = ? order by position''', [int(self.id)])
row = self.db.fetchone()
tracks = []
while row != None:
tracks.append((str(row['id']), row['track_id'], row['votes'])) # FIXME: broken!
row = self.db.fetchone()
ret_tracks = []
for track in tracks:
# TODO: replace with an SQL statement that instantly creates a Track object
self.db.commit_statement('''select * from tracks where id = ?''', [track[1]])
row = self.db.fetchone()
oldid = row['id']
del row['id']
t = Track(**row)
t.id = track[0]
t.votes = str(track[2])
t.voters = t.get_all_voting_users(oldid)
ret_tracks.append(t)
return ret_tracks
