models.py

from app import db
from flask_login import UserMixin


class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(100), unique=True)
    password = db.Column(db.String(100))
    name = db.Column(db.String(1000))
    power = db.Column(db.Integer)
    coins = db.Column(db.Integer)
    nb_games = db.Column(db.Integer)
    nb_wins = db.Column(db.Integer)
    monsters = db.relationship('Monster', backref='user', lazy=True)
    match_history = db.relationship('Match', backref='user', lazy=True)


class Monster(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100))
    level = db.Column(db.Integer)
    defense = db.Column(db.Integer)
    attack = db.Column(db.Integer)
    power = db.Column(db.Integer)  # to calculate the level of the player
    rarity = db.Column(db.String(100))  # common, rare, epic, legendary
    img_path = db.Column(db.String(1000))
    description = db.Column(db.String(1000))
    amount = db.Column(db.Integer)  # number of this monster in the deck
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)  # id of the user that owns this monster


class Match(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    opponent = db.Column(db.String(100))
    reward_coin = db.Column(db.Integer)
    win = db.Column(db.String(1))  # y or n
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    reward_monster_name = db.Column(db.String(1000))  # name of the monster that the user won
    reward_monster_amount = db.Column(db.Integer)  # number of this monster that the user won


class ShopItem(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    price = db.Column(db.Integer)
    last_update = db.Column(db.DateTime)
    monster_name = db.Column(db.String(100))
    monster_rarity = db.Column(db.String(100))
    monster_img_path = db.Column(db.String(1000))
    monster_bought = db.Column(db.Integer)  # number of times this monster has been bought today
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)