💪 Andrew — fitness & health

Phase 1 — foundation. D1 + Pages, Cloudflare Access-locked to me only.

Loading…

—

🩺 System health

Checking…

🏗️ Phase 1 status — what's wired up

✅ Pages project apps/me deployed
✅ D1 database me-db schema migrated (17 tables)
✅ Pages Functions: /api/health, /api/workouts
⏳ Phase 2: import historical data from lifedash.db
⏳ Phase 3: feature parity — workouts UI, body metrics, strength, wellness, PRT/BCA, planner

📚 Phase 2 — data migration commands

Run these from ~/Projects/esmash-org/apps/me when ready to import:

# 1) Dump fitness tables from life-dashboard
sqlite3 ~/Projects/life-dashboard/data/lifedash.db \\
  ".dump workouts body_metrics strength_sets strength_routines daily_wellness \\
   prt_assessments bca_assessments equipment fitness_goals training_phases \\
   planned_workouts run_best_efforts body_photos opportunities race_trip_items" \\
  > /tmp/fitness-dump.sql

# 2) Strip SQLite-specific bits that D1 won't like
grep -v "^PRAGMA\\|^BEGIN\\|^COMMIT\\|sqlite_sequence" /tmp/fitness-dump.sql > /tmp/fitness-import.sql

# 3) Push to D1 (remote)
npx wrangler d1 execute me-db --remote --file=/tmp/fitness-import.sql

# 4) Verify
curl https://home.esmash.org/me/api/health