[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","27fe99fbd4c9bcde616903c265d49161492efaf2","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_148":149,"_171":172,"_173":-5},"handle","SIR_FESTUS","name","MYHEALTHSOURCE","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":110,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":117,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","dc620e62-39d4-11f0-b108-9e149126039e","createdAt",["D",1748224684172],"deletedAt","legacyEnvVars","privacy","public","description","YOUR HEALTH, OUR CONCERN.","imageUrl","2b10de80-eda4-11ef-af12-67b5d5b0b458","pinnedFileId","pinPreview","screenshotVersion","likeCount",1,"a51dc885-90a2-4808-9e4d-5d1846e66b01","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0Q0FVZFBBU0Z0dlVTUVBsRGJyNzRMY0h0TSJ9","org",{"_93":94,"_133":130},"avatar","branch",{"_136":137,"_95":43,"_101":138,"_139":102,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},"version",45,"dc6257e6-39d4-11f0-b108-9e149126039e","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":150,"_95":151,"_152":153,"_154":155,"_156":138,"_157":158,"_159":160,"_103":161,"_136":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_97":168},"a550d280-39d6-11f0-8e32-9e149126039e","queries.ts","fileId","a550d366-39d6-11f0-8e32-9e149126039e","parentId","c530d2e2-f05e-441a-9f93-1440a8798e4b","branchId","branchVersion",8,"latest",true,["D",1748225450776],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { \n User, \n HealthMetric, \n BMIRecord, \n Appointment, \n Medication, \n HealthGoal, \n HealthArticle, \n Exercise, \n SymptomCheck, \n EmergencyContact,\n HealthDashboardData \n} from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(userData: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO users (name, email, date_of_birth, gender, emergency_contact)\n VALUES (?, ?, ?, ?, ?)\n `, [userData.name, userData.email, userData.dateOfBirth, userData.gender, userData.emergencyContact]);\n\n const userId = result.lastInsertRowid;\n return getUserById(userId);\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM users WHERE id = ?\", [id]);\n if (result.length === 0) throw new Error(\"User not found\");\n \n const user = result[0];\n return {\n id: user.id,\n name: user.name,\n email: user.email,\n dateOfBirth: user.date_of_birth,\n gender: user.gender,\n emergencyContact: user.emergency_contact,\n createdAt: user.created_at\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\"SELECT * FROM users WHERE email = ?\", [email]);\n if (result.length === 0) return null;\n \n const user = result[0];\n return {\n id: user.id,\n name: user.name,\n email: user.email,\n dateOfBirth: user.date_of_birth,\n gender: user.gender,\n emergencyContact: user.emergency_contact,\n createdAt: user.created_at\n };\n}\n\n// Health metrics queries\nexport async function addHealthMetric(metric: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO health_metrics (user_id, type, value, unit, notes)\n VALUES (?, ?, ?, ?, ?)\n `, [metric.userId, metric.type, metric.value, metric.unit, metric.notes || null]);\n\n const metricId = result.lastInsertRowid;\n return getHealthMetricById(metricId);\n}\n\nexport async function getHealthMetricById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM health_metrics WHERE id = ?\", [id]);\n if (result.length === 0) throw new Error(\"Health metric not found\");\n \n const metric = result[0];\n return {\n id: metric.id,\n userId: metric.user_id,\n type: metric.type,\n value: metric.value,\n unit: metric.unit,\n recordedAt: metric.recorded_at,\n notes: metric.notes\n };\n}\n\nexport async function getHealthMetricsByUser(userId: number, type?: string, limit: number = 50): Promise {\n let query = \"SELECT * FROM health_metrics WHERE user_id = ?\";\n const params: any[] = [userId];\n \n if (type) {\n query += \" AND type = ?\";\n params.push(type);\n }\n \n query += \" ORDER BY recorded_at DESC LIMIT ?\";\n params.push(limit);\n \n const result = await sqlite.execute(query, params);\n \n return result.map(metric => ({\n id: metric.id,\n userId: metric.user_id,\n type: metric.type,\n value: metric.value,\n unit: metric.unit,\n recordedAt: metric.recorded_at,\n notes: metric.notes\n }));\n}\n\n// BMI queries\nexport async function addBMIRecord(record: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO bmi_records (user_id, height, weight, bmi, category)\n VALUES (?, ?, ?, ?, ?)\n `, [record.userId, record.height, record.weight, record.bmi, record.category]);\n\n const recordId = result.lastInsertRowid;\n return getBMIRecordById(recordId);\n}\n\nexport async function getBMIRecordById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM bmi_records WHERE id = ?\", [id]);\n if (result.length === 0) throw new Error(\"BMI record not found\");\n \n const record = result[0];\n return {\n id: record.id,\n userId: record.user_id,\n height: record.height,\n weight: record.weight,\n bmi: record.bmi,\n category: record.category,\n calculatedAt: record.calculated_at\n };\n}\n\nexport async function getBMIHistoryByUser(userId: number, limit: number = 20): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM bmi_records WHERE user_id = ? \n ORDER BY calculated_at DESC LIMIT ?\n `, [userId, limit]);\n \n return result.map(record => ({\n id: record.id,\n userId: record.user_id,\n height: record.height,\n weight: record.weight,\n bmi: record.bmi,\n category: record.category,\n calculatedAt: record.calculated_at\n }));\n}\n\n// Appointment queries\nexport async function createAppointment(appointment: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO appointments (user_id, doctor_name, specialty, appointment_date, appointment_time, reason, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [appointment.userId, appointment.doctorName, appointment.specialty, appointment.appointmentDate, appointment.appointmentTime, appointment.reason, appointment.notes || null]);\n\n const appointmentId = result.lastInsertRowid;\n return getAppointmentById(appointmentId);\n}\n\nexport async function getAppointmentById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM appointments WHERE id = ?\", [id]);\n if (result.length === 0) throw new Error(\"Appointment not found\");\n \n const appointment = result[0];\n return {\n id: appointment.id,\n userId: appointment.user_id,\n doctorName: appointment.doctor_name,\n specialty: appointment.specialty,\n appointmentDate: appointment.appointment_date,\n appointmentTime: appointment.appointment_time,\n reason: appointment.reason,\n status: appointment.status,\n notes: appointment.notes,\n createdAt: appointment.created_at\n };\n}\n\nexport async function getAppointmentsByUser(userId: number, status?: string): Promise {\n let query = \"SELECT * FROM appointments WHERE user_id = ?\";\n const params: any[] = [userId];\n \n if (status) {\n query += \" AND status = ?\";\n params.push(status);\n }\n \n query += \" ORDER BY appointment_date ASC, appointment_time ASC\";\n \n const result = await sqlite.execute(query, params);\n \n return result.map(appointment => ({\n id: appointment.id,\n userId: appointment.user_id,\n doctorName: appointment.doctor_name,\n specialty: appointment.specialty,\n appointmentDate: appointment.appointment_date,\n appointmentTime: appointment.appointment_time,\n reason: appointment.reason,\n status: appointment.status,\n notes: appointment.notes,\n createdAt: appointment.created_at\n }));\n}\n\nexport async function updateAppointmentStatus(id: number, status: string, notes?: string): Promise {\n await sqlite.execute(`\n UPDATE appointments SET status = ?, notes = ? WHERE id = ?\n `, [status, notes || null, id]);\n \n return getAppointmentById(id);\n}\n\n// Medication queries\nexport async function addMedication(medication: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO medications (user_id, name, dosage, frequency, start_date, end_date, instructions)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [medication.userId, medication.name, medication.dosage, medication.frequency, medication.startDate, medication.endDate || null, medication.instructions]);\n\n const medicationId = result.lastInsertRowid;\n return getMedicationById(medicationId);\n}\n\nexport async function getMedicationById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM medications WHERE id = ?\", [id]);\n if (result.length === 0) throw new Error(\"Medication not found\");\n \n const medication = result[0];\n return {\n id: medication.id,\n userId: medication.user_id,\n name: medication.name,\n dosage: medication.dosage,\n frequency: medication.frequency,\n startDate: medication.start_date,\n endDate: medication.end_date,\n instructions: medication.instructions,\n isActive: Boolean(medication.is_active)\n };\n}\n\nexport async function getMedicationsByUser(userId: number, activeOnly: boolean = false): Promise {\n let query = \"SELECT * FROM medications WHERE user_id = ?\";\n const params: any[] = [userId];\n \n if (activeOnly) {\n query += \" AND is_active = 1\";\n }\n \n query += \" ORDER BY name ASC\";\n \n const result = await sqlite.execute(query, params);\n \n return result.map(medication => ({\n id: medication.id,\n userId: medication.user_id,\n name: medication.name,\n dosage: medication.dosage,\n frequency: medication.frequency,\n startDate: medication.start_date,\n endDate: medication.end_date,\n instructions: medication.instructions,\n isActive: Boolean(medication.is_active)\n }));\n}\n\n// Health goals queries\nexport async function createHealthGoal(goal: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO health_goals (user_id, title, description, target_value, current_value, unit, target_date, category)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [goal.userId, goal.title, goal.description, goal.targetValue, goal.currentValue, goal.unit, goal.targetDate, goal.category]);\n\n const goalId = result.lastInsertRowid;\n return getHealthGoalById(goalId);\n}\n\nexport async function getHealthGoalById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM health_goals WHERE id = ?\", [id]);\n if (result.length === 0) throw new Error(\"Health goal not found\");\n \n const goal = result[0];\n return {\n id: goal.id,\n userId: goal.user_id,\n title: goal.title,\n description: goal.description,\n targetValue: goal.target_value,\n currentValue: goal.current_value,\n unit: goal.unit,\n targetDate: goal.target_date,\n category: goal.category,\n isCompleted: Boolean(goal.is_completed),\n createdAt: goal.created_at\n };\n}\n\nexport async function getHealthGoalsByUser(userId: number, activeOnly: boolean = false): Promise {\n let query = \"SELECT * FROM health_goals WHERE user_id = ?\";\n const params: any[] = [userId];\n \n if (activeOnly) {\n query += \" AND is_completed = 0\";\n }\n \n query += \" ORDER BY target_date ASC\";\n \n const result = await sqlite.execute(query, params);\n \n return result.map(goal => ({\n id: goal.id,\n userId: goal.user_id,\n title: goal.title,\n description: goal.description,\n targetValue: goal.target_value,\n currentValue: goal.current_value,\n unit: goal.unit,\n targetDate: goal.target_date,\n category: goal.category,\n isCompleted: Boolean(goal.is_completed),\n createdAt: goal.created_at\n }));\n}\n\nexport async function updateHealthGoalProgress(id: number, currentValue: number): Promise {\n const goal = await getHealthGoalById(id);\n const isCompleted = currentValue >= goal.targetValue;\n \n await sqlite.execute(`\n UPDATE health_goals SET current_value = ?, is_completed = ? WHERE id = ?\n `, [currentValue, isCompleted ? 1 : 0, id]);\n \n return getHealthGoalById(id);\n}\n\n// Health articles queries\nexport async function getAllHealthArticles(category?: string, limit: number = 50): Promise {\n let query = \"SELECT * FROM health_articles\";\n const params: any[] = [];\n \n if (category) {\n query += \" WHERE category = ?\";\n params.push(category);\n }\n \n query += \" ORDER BY published_at DESC LIMIT ?\";\n params.push(limit);\n \n const result = await sqlite.execute(query, params);\n \n return result.map(article => ({\n id: article.id,\n title: article.title,\n content: article.content,\n category: article.category,\n author: article.author,\n publishedAt: article.published_at,\n tags: JSON.parse(article.tags || '[]'),\n readTime: article.read_time\n }));\n}\n\nexport async function getHealthArticleById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM health_articles WHERE id = ?\", [id]);\n if (result.length === 0) throw new Error(\"Article not found\");\n \n const article = result[0];\n return {\n id: article.id,\n title: article.title,\n content: article.content,\n category: article.category,\n author: article.author,\n publishedAt: article.published_at,\n tags: JSON.parse(article.tags || '[]'),\n readTime: article.read_time\n };\n}\n\n// Exercise queries\nexport async function getAllExercises(category?: string, difficulty?: string): Promise {\n let query = \"SELECT * FROM exercises\";\n const params: any[] = [];\n const conditions: string[] = [];\n \n if (category) {\n conditions.push(\"category = ?\");\n params.push(category);\n }\n \n if (difficulty) {\n conditions.push(\"difficulty = ?\");\n params.push(difficulty);\n }\n \n if (conditions.length > 0) {\n query += \" WHERE \" + conditions.join(\" AND \");\n }\n \n query += \" ORDER BY name ASC\";\n \n const result = await sqlite.execute(query, params);\n \n return result.map(exercise => ({\n id: exercise.id,\n name: exercise.name,\n category: exercise.category,\n description: exercise.description,\n instructions: JSON.parse(exercise.instructions),\n duration: exercise.duration,\n difficulty: exercise.difficulty,\n equipment: JSON.parse(exercise.equipment || '[]')\n }));\n}\n\n// Emergency contacts queries\nexport async function getEmergencyContacts(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM emergency_contacts ORDER BY is_default DESC, name ASC\");\n \n return result.map(contact => ({\n id: contact.id,\n name: contact.name,\n phone: contact.phone,\n relationship: contact.relationship,\n isDefault: Boolean(contact.is_default)\n }));\n}\n\n// Dashboard data query\nexport async function getDashboardData(userId: number): Promise {\n const user = await getUserById(userId);\n const recentMetrics = await getHealthMetricsByUser(userId, undefined, 10);\n const upcomingAppointments = await getAppointmentsByUser(userId, 'scheduled');\n const activeMedications = await getMedicationsByUser(userId, true);\n const activeGoals = await getHealthGoalsByUser(userId, true);\n const bmiHistory = await getBMIHistoryByUser(userId, 10);\n \n return {\n user,\n recentMetrics,\n upcomingAppointments,\n activeMedications,\n activeGoals,\n bmiHistory\n };\n}","deleted","label",[169,170,151],"backend","database","permalink","https://www.val.town/x/SIR_FESTUS/MYHEALTHSOURCE/code/backend/database/queries.ts","extension","actionData","errors"]