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