def add_sample_tracks():
db.session.add(
Track(u'The Divine Conspiracy', u'Epica', u'The Divine Conspiracy',
u'Avalon'))
db.session.add(
Track(u'Second Stone', u'Epica', u'The Quantum Enigma',
u'Nuclear Blast'))
db.session.commit()
def find_or_insert_track(title, artist, album, label, playedtime):
title = title.strip()
artist = artist.strip()
album = album.strip()
label = label.strip()
# set label to "Not Available" if it is empty
if len(label) <= 0:
label = u"Not Available"
existing = Track.query.filter(Track.title == title, Track.artist == artist,
Track.album == album,
Track.label == label).first()
if existing is None:
track = Track(title, artist, album, label)
track.added = playedtime
db.session.add(track)
db.session.commit()
else:
track = existing
return track
