"""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