def get_terms(): genres = [] artist = Artist.select() genre_list = [a.genres for a in artist if a.genres] for l in genre_list: for i in l: genres.append(i['name']) term_count = Counter(genres) return term_count
def update_term(): term_counts = get_terms() artist = Artist.select() for a in artist: temp_terms = {} if a.genres: for g in a.genres: if g['name'] in term_counts: temp_terms[g['name']] = term_counts[g['name']] #temp_terms.append({g['name']: term_counts[g['name']]}) #print g['name'], term_counts[g['name']] top_term = max(temp_terms.iterkeys(), key = (lambda k: temp_terms[k])) a.term1 = top_term a.save()
def get_artist_by_name(_name:str): query = Artist.select().where(Artist.name == _name) try: _artist = { 'id':query[0].id, 'name':query[0].name, 'genre':query[0].genre, 'image_link':query[0].image_link, 'bio':query[0].bio} return _artist except: _artist = { 'id':0, 'name':'not found', 'genre':'not found', 'image_link':'not found', 'bio':'not found'} return _artist
def get_all_artists(): list_Artist = Artist.select() dicts_Artist = [] for x in range(len(list_Artist)): try: _artist = { 'id':list_Artist[x].id, 'name':list_Artist[x].name, 'genre':list_Artist[x].genre, 'image_link':list_Artist[x].image_link, 'bio':list_Artist[x].bio} dicts_Artist.append(_artist) except: _artist = { 'id':0, 'name':'not found', 'genre':'not found', 'image_link':'not found', 'bio':'not found'} dicts_Artist.append(_artist) return dicts_Artist
def index(self): artists = Artist.select(["id", "name", "unique_name", "state"]) return self.serve_template("index.html", title="Home", artists=artists)
def main(): band = Artist.select().where(Artist.name == "Kutless").get() print("[+] found: " + band.name)
import peewee from models import Album, Artist band = Artist.select().where(Artist.name == "Kutless").get() print band.name # shortcut method band = Artist.get(Artist.name == "Kutless") print band.name # change band name band.name = "Beach Boys" band.save() album = Album.select().join(Artist).where((Album.title == "Thrive") & (Artist.name == "Newsboys")).get() album.title = "Step Up to the Microphone" album.save() query = Album.select().join(Artist) qry_filter = ((Album.title == "Step Up to the Microphone") & (Artist.name == "Newsboys")) album = query.where(qry_filter).get() print album
# edit_data.py import peewee from models import Album, Artist band = Artist.select().where(Artist.name=="Kutless").get() print (band.name) # shortcut method band = Artist.get(Artist.name=="Kutless") print (band.name) # change band name band.name = "Beach Boys" band.save() album = Album.select().join(Artist).where( (Album.title=="Thrive") & (Artist.name == "Newsboys") ).get() album.title = "Step Up to the Microphone" album.save()
def show_all(): artists = Artist.select() for artist in artists: ui.display(format_artist(artist))
media_type="CD") album_one.save() albums = [{"artist": new_artist, "title": "Hell is for Wimps", "release_date": datetime.date(1990, 07, 31), "publisher": "Sparrow", "media_type": "CD" }, {"artist": new_artist, "title": "Love Liberty Disco", "release_date": datetime.date(1999, 11, 16), "publisher": "Sparrow", "media_type": "CD" }, {"artist": new_artist, "title": "Thrive", "release_date": datetime.date(2002, 03, 26), "publisher": "Sparrow", "media_type": "CD"} ] Album.insert_many(albums).execute() bands = ["MXPX", "Kutless", "Thousand Foot Krutch"] for band in bands: artist = Artist.create(name=band) artist.save() for art in Artist.select(): print(art.name)
def get_artists(): selection = Artist.select().where(Artist.echonest_response.is_null(True)) artist_list = [artist.artist_id for artist in selection] return artist_list