class Song(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(150))
lyrics = db.Column(db.Text)
publication_date = db.Column(db.DateTime)
artist_id = db.Column(db.Integer, db.ForeignKey(Artist.id))
artist = db.relationship(Artist,
backref=db.backref('song', lazy='dynamic'))
def __init__(self, title, lyrics, artist, publication_date=None):
self.title = title
self.lyrics = lyrics
self.artist = artist
if publication_date is None:
publication_date = datetime.utcnow()
self.publication_date = publication_date
def __repr__(self):
return '<Song %r>' % self.title
def as_dict(self):
return {
'id': self.id,
'title': self.title,
'lyrics': self.lyrics,
'publication_date': self.publication_date,
'artist': self.artist.name
}
def __str__(self):
return str(self.as_dict())
class Genre(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(90))
def __init__(self, name):
self.name = name
def __repr__(self):
return '<Genre %r>' % self.name
class ArtificialTitle(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(180))
creation_date = db.Column(db.DateTime)
def __init__(self, title, creation_date=None):
self.title = title
if creation_date is None:
creation_date = datetime.utcnow()
self.creation_date = creation_date
def __repr__(self):
return '<ArtificialTitle %r>' % self.title
class Artist(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(160))
clean_name = db.Column(db.String(160))
cover = db.Column(db.Boolean, nullable=True)
formation_date = db.Column(db.DateTime)
country = db.Column(db.String(120))
genre_id = db.Column(db.Integer, db.ForeignKey(Genre.id))
genre = db.relationship(Genre,
backref=db.backref('artist', lazy='dynamic'))
def __init__(self,
name,
clean_name,
country,
genre,
formation_date=None,
cover=False):
self.name = name
self.clean_name = clean_name
self.country = country
if formation_date is None:
formation_date = datetime.utcnow()
self.cover = cover
self.formation_date = formation_date
self.genre = genre
def __repr__(self):
return '<Artist %r %r>' % (self.clean_name, self.name)
class ArtificialSong(db.Model):
id = db.Column(db.Integer, primary_key=True)
artificial_title_id = db.Column(db.Integer,
db.ForeignKey(ArtificialTitle.id))
artificial_title = db.relationship(ArtificialTitle,
backref=db.backref('artificialSong',
lazy='dynamic'))
lyrics = db.Column(db.Text)
model = db.Column(db.String(150))
creation_date = db.Column(db.DateTime)
# user_id = db.Column(db.Integer, db.ForeignKey(User.id))
# user = db.relationship(User, backref=db.backref('artificialSong', lazy='dynamic'))
base_artist_id = db.Column(db.Integer, db.ForeignKey(Artist.id))
base_artist = db.relationship(Artist,
backref=db.backref('artificialSong',
lazy='dynamic'))
def __init__(self,
artificial_title,
lyrics,
model,
base_artist,
creation_date=None):
self.artificial_title = artificial_title
self.lyrics = lyrics
self.model = model
self.base_artist = base_artist
if creation_date is None:
creation_date = datetime.utcnow()
self.creation_date = creation_date
def __repr__(self):
return '<ArtificialSong named: %r>' % self.artificial_title.title