dosemate / dose_service.py
DoseMate
Deploy DoseMate to Hugging Face Spaces
a0c836f
Raw History Blame Contribute Delete
1.93 kB
"""Helpers for turning ScheduleEntry rows into concrete DoseEvent instances.
Kept dependency-light (only SQLAlchemy + stdlib) so both the schedule router and
the APScheduler job can import it without pulling heavy packages.
"""
from datetime import datetime, date, timedelta
from typing import Optional
from sqlalchemy.orm import Session
from database import ScheduleEntry, DoseEvent
def materialize_day(db: Session, user_id: int, day: Optional[date] = None) -> int:
"""Create pending DoseEvent rows for the given user/day from their schedule.
Idempotent: skips (schedule_entry, day) pairs that already have an event.
Returns the number of events created.
"""
if day is None:
day = date.today()
entries = db.query(ScheduleEntry).filter(
ScheduleEntry.user_id == user_id
).all()
created = 0
for entry in entries:
hour, minute = (int(x) for x in entry.dose_time.split(":"))
scheduled_for = datetime.combine(day, datetime.min.time()).replace(
hour=hour, minute=minute
)
exists = db.query(DoseEvent).filter(
DoseEvent.schedule_entry_id == entry.id,
DoseEvent.scheduled_for == scheduled_for,
).first()
if exists:
continue
db.add(DoseEvent(
user_id=user_id,
schedule_entry_id=entry.id,
drug_name=entry.drug_name,
scheduled_for=scheduled_for,
status="pending",
))
created += 1
if created:
db.commit()
return created
def materialize_all_users(db: Session, day: Optional[date] = None) -> int:
"""Materialize today's doses for every user that has schedule entries."""
user_ids = [
row[0]
for row in db.query(ScheduleEntry.user_id).distinct().all()
]
total = 0
for uid in user_ids:
total += materialize_day(db, uid, day)
return total