"""Rollup tables (Chapter 06) — primary source for Overview widgets (Ch08).
Both are site-wide (no log_file_id), consistent with Ch01's single-site scope.
"""
from __future__ import annotations

from app.extensions import db


class RequestStatsHourly(db.Model):
    __tablename__ = "request_stats_hourly"

    date_hour = db.Column(db.DateTime, primary_key=True)
    path: str = db.Column(db.String(2048), primary_key=True)
    status_code: int = db.Column(db.SmallInteger, primary_key=True)
    count: int = db.Column(db.Integer, nullable=False, default=0)
    bytes_sent_sum: int = db.Column(db.BigInteger, nullable=False, default=0)


class RequestStatsDaily(db.Model):
    __tablename__ = "request_stats_daily"

    date = db.Column(db.Date, primary_key=True)
    count: int = db.Column(db.Integer, nullable=False, default=0)
    unique_ips: int = db.Column(db.Integer, nullable=False, default=0)
    bytes_sum: int = db.Column(db.BigInteger, nullable=False, default=0)
    error_count: int = db.Column(db.Integer, nullable=False, default=0)