models.py

from datetime import date
from flask_sqlalchemy import SQLAlchemy
from flask_login import UserMixin
from werkzeug.security import generate_password_hash, check_password_hash

db = SQLAlchemy()

def xp_for_difficulty(difficulty: int) -> int:
    # Ajustável: knob principal
    table = {1: 10, 2: 20, 3: 35, 4: 55, 5: 80}
    return table.get(difficulty, 20)

def level_from_xp(total_xp: int) -> int:
    # Curva simples: cada nível exige mais XP
    level = 1
    xp_needed = 100
    remaining = total_xp
    while remaining >= xp_needed:
        remaining -= xp_needed
        level += 1
        xp_needed = int(xp_needed * 1.25)
    return level

class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    password_hash = db.Column(db.String(255), nullable=False)

    total_xp = db.Column(db.Integer, default=0)
    coins = db.Column(db.Integer, default=0)

    streak = db.Column(db.Integer, default=0)
    last_completion_date = db.Column(db.Date, nullable=True)

    tasks = db.relationship("Task", backref="user", lazy=True)

    def set_password(self, password: str):
        self.password_hash = generate_password_hash(password)

    def check_password(self, password: str) -> bool:
        return check_password_hash(self.password_hash, password)

    @property
    def level(self) -> int:
        return level_from_xp(self.total_xp)

class Task(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False)

    title = db.Column(db.String(120), nullable=False)
    difficulty = db.Column(db.Integer, default=2)  # 1–5
    attr = db.Column(db.String(8), default="INT")  # INT/FOR/VIT/CAR

    created_at = db.Column(db.DateTime, server_default=db.func.now())

class CompletionLog(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, nullable=False)
    task_id = db.Column(db.Integer, nullable=False)
    completed_on = db.Column(db.Date, nullable=False, default=date.today)
    xp_gained = db.Column(db.Integer, nullable=False, default=0)

from datetime import date
#Quests diárias
class DailyQuest(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, nullable=False)

    # Pode ligar a uma Task existente (opcional)
    task_id = db.Column(db.Integer, nullable=True)

    title = db.Column(db.String(160), nullable=False)
    difficulty = db.Column(db.Integer, default=2)  # 1–5
    attr = db.Column(db.String(8), default="INT")

    quest_date = db.Column(db.Date, nullable=False, default=date.today)
    is_completed = db.Column(db.Boolean, default=False)
#Atributos
from datetime import date

class UserAttribute(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, nullable=False)
    name = db.Column(db.String(8), nullable=False)  # INT/FOR/VIT/CAR
    value = db.Column(db.Integer, default=0)

    __table_args__ = (db.UniqueConstraint("user_id", "name", name="uq_user_attr"),)

class Reward(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, nullable=False)
    title = db.Column(db.String(120), nullable=False)
    cost = db.Column(db.Integer, default=10)
    is_active = db.Column(db.Boolean, default=True)

class RewardRedemption(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, nullable=False)
    reward_id = db.Column(db.Integer, nullable=False)
    redeemed_on = db.Column(db.Date, nullable=False, default=date.today)
    cost_paid = db.Column(db.Integer, nullable=False, default=0)