27 lines
1.0 KiB
Python
27 lines
1.0 KiB
Python
"""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)
|