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
