[{"_1":2,"_172":-5,"_173":-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","0fffb492b08724537e73cd8bc4c3f31babbf0bd5","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,"_146":147,"_169":170,"_171":-5},"handle","seipatiannah1","name","happinessregistrationportal","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","981d20c0-3506-11f0-865a-9e149126039e","createdAt",["D",1747696288659],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","555cc760-2451-11f0-8dad-2dee4ee35618","pinnedFileId","pinPreview","screenshotVersion","likeCount","e97c22cc-7020-469e-906a-83c9e0b81892","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd01sQnpEeHZwTkU4bXZuZEF4SUxwd044MkIifQ","org",{"_93":94,"_131":128,"_12":111},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",14,"981d629c-3506-11f0-865a-9e149126039e","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":156,"_157":158,"_103":159,"_134":32,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"89721870-3509-11f0-aa7a-9e149126039e","queries.ts","fileId","89721974-3509-11f0-aa7a-9e149126039e","parentId","faab415e-d92e-4ec5-b2dd-b6f674ef4fc7","branchId","branchVersion",3,"latest",true,["D",1747697552517],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, CHILDREN_TABLE, POLICY_ACCEPTANCE_TABLE } from \"./migrations.ts\";\n\n// Types\nexport interface User {\n id: number;\n email: string;\n full_name: string;\n phone: string;\n role: \"parent\" | \"admin\" | \"staff\";\n created_at: string;\n updated_at: string;\n}\n\nexport interface Child {\n id: number;\n parent_id: number;\n full_name: string;\n date_of_birth: string;\n age_group: \"less_than_6_months\" | \"6_months_to_2_years\" | \"3_to_6_years\";\n allergies: string | null;\n special_needs: string | null;\n emergency_contact: string;\n created_at: string;\n updated_at: string;\n}\n\nexport interface PolicyAcceptance {\n id: number;\n user_id: number;\n operating_hours_accepted: number;\n fee_structure_accepted: number;\n health_safety_accepted: number;\n attendance_policy_accepted: number;\n accepted_at: string | null;\n}\n\n// User queries\nexport async function createUser(\n email: string,\n passwordHash: string,\n fullName: string,\n phone: string,\n role: \"parent\" | \"admin\" | \"staff\" = \"parent\"\n): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (email, password_hash, full_name, phone, role)\n VALUES (?, ?, ?, ?, ?)\n RETURNING id`,\n [email, passwordHash, fullName, phone, role]\n );\n \n // Create empty policy acceptance record\n if (result.rows.length > 0) {\n const userId = result.rows[0].id;\n await sqlite.execute(\n `INSERT INTO ${POLICY_ACCEPTANCE_TABLE} (user_id)\n VALUES (?)`,\n [userId]\n );\n return userId;\n }\n \n throw new Error(\"Failed to create user\");\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, full_name, phone, role, created_at, updated_at\n FROM ${USERS_TABLE}\n WHERE email = ?`,\n [email]\n );\n \n return result.rows.length > 0 ? result.rows[0] as User : null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, full_name, phone, role, created_at, updated_at\n FROM ${USERS_TABLE}\n WHERE id = ?`,\n [id]\n );\n \n return result.rows.length > 0 ? result.rows[0] as User : null;\n}\n\nexport async function getPasswordHashByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT password_hash FROM ${USERS_TABLE} WHERE email = ?`,\n [email]\n );\n \n return result.rows.length > 0 ? result.rows[0].password_hash : null;\n}\n\n// Child queries\nexport async function createChild(\n parentId: number,\n fullName: string,\n dateOfBirth: string,\n ageGroup: \"less_than_6_months\" | \"6_months_to_2_years\" | \"3_to_6_years\",\n allergies: string | null,\n specialNeeds: string | null,\n emergencyContact: string\n): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${CHILDREN_TABLE} \n (parent_id, full_name, date_of_birth, age_group, allergies, special_needs, emergency_contact)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [parentId, fullName, dateOfBirth, ageGroup, allergies, specialNeeds, emergencyContact]\n );\n \n if (result.rows.length > 0) {\n return result.rows[0].id;\n }\n \n throw new Error(\"Failed to create child record\");\n}\n\nexport async function getChildById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CHILDREN_TABLE} WHERE id = ?`,\n [id]\n );\n \n return result.rows.length > 0 ? result.rows[0] as Child : null;\n}\n\nexport async function getChildrenByParentId(parentId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CHILDREN_TABLE} WHERE parent_id = ?`,\n [parentId]\n );\n \n return result.rows as Child[];\n}\n\nexport async function getAllChildren(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CHILDREN_TABLE}`\n );\n \n return result.rows as Child[];\n}\n\n// Policy acceptance queries\nexport async function getPolicyAcceptance(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${POLICY_ACCEPTANCE_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n return result.rows.length > 0 ? result.rows[0] as PolicyAcceptance : null;\n}\n\nexport async function updatePolicyAcceptance(\n userId: number,\n operatingHours: boolean,\n feeStructure: boolean,\n healthSafety: boolean,\n attendancePolicy: boolean\n): Promise {\n const allAccepted = operatingHours && feeStructure && healthSafety && attendancePolicy;\n const acceptedAt = allAccepted ? \"datetime('now')\" : null;\n \n await sqlite.execute(\n `UPDATE ${POLICY_ACCEPTANCE_TABLE}\n SET operating_hours_accepted = ?,\n fee_structure_accepted = ?,\n health_safety_accepted = ?,\n attendance_policy_accepted = ?,\n accepted_at = ${acceptedAt ? acceptedAt : \"NULL\"}\n WHERE user_id = ?`,\n [\n operatingHours ? 1 : 0,\n feeStructure ? 1 : 0,\n healthSafety ? 1 : 0,\n attendancePolicy ? 1 : 0,\n userId\n ]\n );\n}","deleted","label",[167,168,149],"backend","database","permalink","https://www.val.town/x/seipatiannah1/happinessregistrationportal/code/backend/database/queries.ts","extension","actionData","errors"]