class User(UserMixin, database.Model):
id = database.Column(database.Integer, primary_key=True)
login = database.Column(database.String(64), nullable=False, index=True)
password = database.Column(database.String(128), nullable=False)
email = database.Column(database.String(256), nullable=False)
playlists = database.relationship('Playlist', backref='user')
def set_passwpord(self, password):
self.password = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password, password)
class Music(database.Model):
id = database.Column(database.Integer, primary_key=True)
title = database.Column(database.String(150), nullable=False, index=True)
source = database.Column(database.String(150), nullable=False)
sound_url = database.Column(database.String(250), nullable=False)
duration = database.Column(database.Integer, nullable=False)
loop = database.Column(database.Boolean, nullable=False)
vote = database.Column(database.Integer, nullable=False)
style_tags = database.relationship('Style', secondary=music_style)
scene_tags = database.relationship('Scene', secondary=music_scene)
genre = database.Column(database.Integer,
database.ForeignKey('genre.id'),
nullable=False)
class Playlist(database.Model):
id = database.Column(database.Integer, primary_key=True)
title = database.Column(database.String(32), nullable=False)
musics = database.relationship('Music', secondary=playlist_music)
user_id = database.Column(database.Integer,
database.ForeignKey('user.id'),
nullable=False)
class Genre(database.Model):
id = database.Column(database.Integer, primary_key=True)
name = database.Column(database.String(32), nullable=False, index=True)