class Track(db.Model):
# primary key
id = db.Column(db.Integer, primary_key=True)
# track info
track_name = db.Column(db.String, nullable=False)
track_length = db.Column(db.Float, nullable=False)
# album id is a foreign key column in this table indicating which tracks
# are on which album
album_id = db.Column(db.Integer, db.ForeignKey('album.id'), nullable=True)
# there is a relationship which band member(s) wrote which tracks (many to many)
member_track = db.relationship('Member',
secondary='trackbandmember',
backref='track',
lazy=True)
# relationship between Setlist and track
set_list_track = db.relationship('Setlist',
cascade='all, delete',
backref='track',
lazy=True)
def __repr__(self):
return f"track('{self.track_name}', '{self.track_length}', '{self.album_id}')"
class Setlist(db.Model):
# primary key
id = db.Column(db.Integer, primary_key=True)
#set list info
show_id = db.Column(db.Integer, db.ForeignKey('shows.id'), nullable=False)
track_id = db.Column(db.Integer, db.ForeignKey('track.id'), nullable=False)
def __repr__(self):
return f"setlist('{self.show_id}', '{self.track_id}')"
class Member(db.Model):
# primary key
id = db.Column(db.Integer, primary_key=True)
# band member info
member_name = db.Column(db.String, nullable=False)
instrument = db.Column(db.String, nullable=False)
birthdate = db.Column(db.String, nullable=False)
def __repr__(self):
return f"member('{self.member_name}', '{self.instrument}', {self.birthdate})"
class Shows(db.Model):
# primary key
id = db.Column(db.Integer, primary_key=True)
city = db.Column(db.String, nullable=False)
# relationship between Setlist and track
set_list_show = db.relationship('Setlist',
cascade='all, delete',
backref='shows',
lazy=True)
def __repr__(self):
return f"show('{self.id}','{self.city}')"
class Album(db.Model):
# primary key of table
id = db.Column(db.Integer, primary_key=True)
# album info
album_name = db.Column(db.String, nullable=False)
release_date = db.Column(db.String, nullable=False)
# there is a relationship which is album contains many tracks
# and tracks come from a single album (many to one)
track = db.relationship('Track',
cascade='all, delete',
backref='album',
lazy=True)
# display the album info
def __repr__(self):
return f"album('{self.album_name}', '{self.release_date}')"
id = db.Column(db.Integer, primary_key=True)
# band member info
member_name = db.Column(db.String, nullable=False)
instrument = db.Column(db.String, nullable=False)
birthdate = db.Column(db.String, nullable=False)
def __repr__(self):
return f"member('{self.member_name}', '{self.instrument}', {self.birthdate})"
# associative table between tracks and members that represents
# the many to many relationship
trackbandmember = db.Table(
'trackbandmember',
db.Column('track_id', db.Integer, db.ForeignKey('track.id')),
db.Column('member_id', db.Integer, db.ForeignKey('member.id')))
# Table of Tool shows
class Shows(db.Model):
# primary key
id = db.Column(db.Integer, primary_key=True)
city = db.Column(db.String, nullable=False)
# relationship between Setlist and track
set_list_show = db.relationship('Setlist',
cascade='all, delete',
backref='shows',
lazy=True)