[{"_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","d3026818d5337426b43916cf1aa0346cb5756d0e","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","prashamtrivedi","name","ganeshotsav-2025-forms","path","backend/database.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":72,"_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","6728461a-7a03-11f0-8206-0224a6c84d84","createdAt",["D",1755281548265],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","1591349e-125d-4fb7-930d-cf293627961f","pinnedFileId","pinPreview","screenshotVersion","likeCount","4d7791fe-1f5b-4867-8b6e-34823c16ee48","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaUF5OXE3VlcwNVRwRU9wSTRmcE1DZ0FSM1UifQ","org",{"_93":94,"_131":128},"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",575,"67287388-7a03-11f0-8206-0224a6c84d84","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":160,"_161":162,"_163":164,"_165":20,"_166":-5,"_97":167},"9b18d534-8354-11f0-9e3a-0224a6c84d84","database.ts","fileId","2d995fd6-7a05-11f0-99ee-0224a6c84d84","parentId","2cea9302-7a05-11f0-a792-0224a6c84d84","branchId","branchVersion",571,"latest",true,["D",1756305985088],77,"fileType","script","content","import {sqlite} from \"https://esm.town/v/std/sqlite\"\nimport {CulturalFormData, LegacyCulturalFormData, Child} from \"../shared/types.ts\"\n\nconst TABLE_NAME = \"ganeshotsav-2025-cultural\"\nconst TABLE_NAME_V2 = \"ganeshotsav-2025-cultural-v2\"\n\nexport async function initializeDatabase(): Promise {\n // Initialize quiz database\n await initializeQuizDatabase()\n // Create original table for backward compatibility\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \"${TABLE_NAME}\" (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n block_number TEXT NOT NULL,\n mobile_number TEXT NOT NULL,\n kids_name TEXT NOT NULL,\n age INTEGER NOT NULL,\n performance_name TEXT NOT NULL,\n custom_performance TEXT,\n youtube_link TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(mobile_number, block_number)\n )\n `)\n\n // Create new table with updated schema\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \"${TABLE_NAME_V2}\" (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n block_number TEXT NOT NULL,\n mobile_number TEXT NOT NULL,\n children TEXT NOT NULL, -- JSON field storing Child[] array\n performance_type TEXT NOT NULL CHECK(performance_type IN ('combined', 'separate')),\n performance_name TEXT NOT NULL,\n custom_performance TEXT,\n youtube_link TEXT,\n effective_age INTEGER NOT NULL, -- Computed age for sorting\n performance_done INTEGER DEFAULT 0, -- Boolean field for performance completion status\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(mobile_number, block_number)\n )\n `)\n\n // Add performance_done column to existing table if it doesn't exist\n try {\n await sqlite.execute(`\n ALTER TABLE \"${TABLE_NAME_V2}\" \n ADD COLUMN performance_done INTEGER DEFAULT 0\n `)\n console.log(\"Added performance_done column to existing table\")\n } catch (error) {\n // Column might already exist, which is fine\n console.log(\"performance_done column already exists or other error:\", error.message)\n }\n}\n\nexport function calculateEffectiveAge(children: Child[], performanceType: 'combined' | 'separate'): number {\n if (children.length === 0) {\n throw new Error(\"Children array cannot be empty\")\n }\n \n if (performanceType === 'combined') {\n // For combined performances, use minimum age\n return Math.min(...children.map(child => child.age))\n } else {\n // For separate performances, use the age of the single child (or first if multiple)\n return children[0].age\n }\n}\n\nexport function validateChildren(children: Child[]): { valid: boolean; error?: string } {\n if (!Array.isArray(children) || children.length === 0) {\n return { valid: false, error: \"At least 1 child is required\" }\n }\n\n if (children.length > 5) {\n return { valid: false, error: \"Maximum 5 children allowed per registration\" }\n }\n\n for (let i = 0; i < children.length; i++) {\n const child = children[i]\n \n if (!child.name || typeof child.name !== 'string' || child.name.trim() === '') {\n return { valid: false, error: `Child ${i + 1}: Name is required` }\n }\n\n if (!child.age || typeof child.age !== 'number' || child.age < 3) {\n return { valid: false, error: `Child ${i + 1}: Age must be 3 or above` }\n }\n }\n\n return { valid: true }\n}\n\nexport async function saveFormData(data: CulturalFormData): Promise {\n // Validate children array\n const validation = validateChildren(data.children)\n if (!validation.valid) {\n throw new Error(validation.error)\n }\n\n // Calculate effective age\n const effectiveAge = calculateEffectiveAge(data.children, data.performance_type)\n\n // Store in new table format\n await sqlite.execute({\n sql: `\n INSERT INTO \"${TABLE_NAME_V2}\" \n (name, block_number, mobile_number, children, performance_type, performance_name, custom_performance, youtube_link, effective_age, performance_done)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(mobile_number, block_number) \n DO UPDATE SET \n name = excluded.name,\n children = excluded.children,\n performance_type = excluded.performance_type,\n performance_name = excluded.performance_name,\n custom_performance = excluded.custom_performance,\n youtube_link = excluded.youtube_link,\n effective_age = excluded.effective_age,\n updated_at = CURRENT_TIMESTAMP\n `, args: [\n data.name,\n data.block_number,\n data.mobile_number,\n JSON.stringify(data.children),\n data.performance_type,\n data.performance_name,\n data.custom_performance,\n data.youtube_link,\n effectiveAge,\n data.performance_done ? 1 : 0\n ]\n })\n}\n\nexport async function getCulturalActivities(): Promise {\n // Get submissions from new table (v2)\n const result = await sqlite.execute(`\n SELECT * FROM \"${TABLE_NAME_V2}\" \n ORDER BY effective_age ASC, name ASC\n `)\n\n const rows: CulturalFormData[] = result.rows?.map(row => {\n const rowObj = Object.fromEntries(row.map((value, index) => [result.columns[index], value])) as any\n \n return {\n id: rowObj.id,\n name: rowObj.name,\n block_number: rowObj.block_number,\n mobile_number: rowObj.mobile_number,\n children: JSON.parse(rowObj.children) as Child[],\n performance_type: rowObj.performance_type as 'combined' | 'separate',\n performance_name: rowObj.performance_name,\n custom_performance: rowObj.custom_performance || '',\n youtube_link: rowObj.youtube_link || '',\n effective_age: rowObj.effective_age,\n performance_done: Boolean(rowObj.performance_done)\n }\n }) || []\n\n return rows\n}\n\nexport async function getCulturalActivitiesByPerformanceType(performanceType?: 'combined' | 'separate'): Promise {\n let sql = `SELECT * FROM \"${TABLE_NAME_V2}\"`\n let args: any[] = []\n\n if (performanceType) {\n sql += ` WHERE performance_type = ?`\n args.push(performanceType)\n }\n\n sql += ` ORDER BY effective_age ASC, name ASC`\n\n const result = await sqlite.execute({ sql, args })\n\n const rows: CulturalFormData[] = result.rows?.map(row => {\n const rowObj = Object.fromEntries(row.map((value, index) => [result.columns[index], value])) as any\n \n return {\n id: rowObj.id,\n name: rowObj.name,\n block_number: rowObj.block_number,\n mobile_number: rowObj.mobile_number,\n children: JSON.parse(rowObj.children) as Child[],\n performance_type: rowObj.performance_type as 'combined' | 'separate',\n performance_name: rowObj.performance_name,\n custom_performance: rowObj.custom_performance || '',\n youtube_link: rowObj.youtube_link || '',\n effective_age: rowObj.effective_age,\n performance_done: Boolean(rowObj.performance_done)\n }\n }) || []\n\n return rows\n}\n\nexport async function updatePerformanceDoneStatus(id: number, isDone: boolean): Promise {\n try {\n console.log(\"Attempting to update performance done status for ID:\", id, \"to:\", isDone)\n \n // First check if the record exists\n const checkResult = await sqlite.execute({\n sql: `SELECT id FROM \"${TABLE_NAME_V2}\" WHERE id = ?`,\n args: [id]\n })\n \n if (!checkResult.rows || checkResult.rows.length === 0) {\n console.log(\"No record found with ID:\", id)\n return false\n }\n \n // Update the performance_done status\n const updateResult = await sqlite.execute({\n sql: `UPDATE \"${TABLE_NAME_V2}\" SET performance_done = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n args: [isDone ? 1 : 0, id]\n })\n \n console.log(\"Update result:\", updateResult)\n \n // Verify the update was successful\n const verifyResult = await sqlite.execute({\n sql: `SELECT performance_done FROM \"${TABLE_NAME_V2}\" WHERE id = ?`,\n args: [id]\n })\n \n const updated = verifyResult.rows && verifyResult.rows.length > 0 && \n Boolean(verifyResult.rows[0][0]) === isDone\n console.log(\"Update verified:\", updated)\n \n return updated\n } catch (error) {\n console.error(\"Error updating performance done status:\", error)\n return false\n }\n}\n\nexport async function deleteRegistration(id: number): Promise {\n try {\n console.log(\"Attempting to delete registration with ID:\", id)\n \n // First check if the record exists\n const checkResult = await sqlite.execute({\n sql: `SELECT id FROM \"${TABLE_NAME_V2}\" WHERE id = ?`,\n args: [id]\n })\n \n console.log(\"Record exists check:\", checkResult.rows?.length || 0, \"records found\")\n \n if (!checkResult.rows || checkResult.rows.length === 0) {\n console.log(\"No record found with ID:\", id)\n return false\n }\n \n // Now delete the record\n const deleteResult = await sqlite.execute({\n sql: `DELETE FROM \"${TABLE_NAME_V2}\" WHERE id = ?`,\n args: [id]\n })\n \n console.log(\"Delete result:\", deleteResult)\n \n // Check if the record was actually deleted\n const verifyResult = await sqlite.execute({\n sql: `SELECT id FROM \"${TABLE_NAME_V2}\" WHERE id = ?`,\n args: [id]\n })\n \n const deleted = !verifyResult.rows || verifyResult.rows.length === 0\n console.log(\"Deletion verified:\", deleted)\n \n return deleted\n } catch (error) {\n console.error(\"Error deleting registration:\", error)\n return false\n }\n}\n\nexport async function getCulturalActivitiesSummary(): Promise<{\n totalKids: number,\n performanceCounts: Record,\n ageCounts: Record,\n performanceTypeCounts: Record\n}> {\n try {\n // Count total children from new table\n const childrenResult = await sqlite.execute(`\n SELECT children FROM \"${TABLE_NAME_V2}\"\n `)\n\n let totalKids = 0\n if (childrenResult.rows) {\n childrenResult.rows.forEach((row: any) => {\n const children = JSON.parse(row[0]) as Child[]\n totalKids += children.length\n })\n }\n\n // Performance counts\n const performanceResult = await sqlite.execute(`\n SELECT \n CASE \n WHEN performance_name = 'other' AND custom_performance != '' THEN custom_performance\n ELSE performance_name\n END as performance,\n COUNT(*) as count\n FROM \"${TABLE_NAME_V2}\"\n GROUP BY performance\n ORDER BY count DESC\n `)\n\n // Age counts based on effective age\n const ageResult = await sqlite.execute(`\n SELECT \n CASE \n WHEN effective_age <= 5 THEN '0-5'\n WHEN effective_age <= 8 THEN '6-8'\n WHEN effective_age <= 12 THEN '9-12'\n WHEN effective_age <= 16 THEN '13-16'\n ELSE '17+'\n END as age_group,\n COUNT(*) as count\n FROM \"${TABLE_NAME_V2}\"\n GROUP BY age_group\n ORDER BY age_group\n `)\n\n // Performance type counts\n const performanceTypeResult = await sqlite.execute(`\n SELECT performance_type, COUNT(*) as count\n FROM \"${TABLE_NAME_V2}\"\n GROUP BY performance_type\n `)\n\n const performanceCounts: Record = {}\n if (performanceResult.rows) {\n performanceResult.rows.forEach((row: any) => {\n const performance = row[0]\n const count = row[1]\n performanceCounts[performance] = count || 0\n })\n }\n\n const ageCounts: Record = {}\n if (ageResult.rows) {\n ageResult.rows.forEach((row: any) => {\n const age_group = row[0]\n const count = row[1]\n ageCounts[age_group] = count || 0\n })\n }\n\n const performanceTypeCounts: Record = {}\n if (performanceTypeResult.rows) {\n performanceTypeResult.rows.forEach((row: any) => {\n const type = row[0]\n const count = row[1]\n performanceTypeCounts[type] = count || 0\n })\n }\n\n return {\n totalKids,\n performanceCounts,\n ageCounts,\n performanceTypeCounts\n }\n } catch (error) {\n console.error(\"Error getting summary:\", error)\n return {\n totalKids: 0,\n performanceCounts: {},\n ageCounts: {},\n performanceTypeCounts: {}\n }\n }\n}\n// Quiz Registration Constants and Functions\nimport {QuizTeamData, QuizTeamMember, QuizSummary} from \"../shared/types.ts\"\n\nconst QUIZ_TABLE_NAME = \"ganeshotsav-2025-quiz\"\n\nexport async function initializeQuizDatabase(): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \"${QUIZ_TABLE_NAME}\" (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n team_name TEXT NOT NULL UNIQUE,\n parent_name TEXT NOT NULL,\n contact_number TEXT NOT NULL,\n members TEXT NOT NULL,\n member_count INTEGER NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `)\n}\n\nexport function validateQuizTeamMembers(members: QuizTeamMember[]): { valid: boolean; error?: string } {\n if (!Array.isArray(members) || members.length === 0) {\n return { valid: false, error: \"At least 1 team member is required\" }\n }\n\n if (members.length > 6) {\n return { valid: false, error: \"Maximum 6 members allowed per team\" }\n }\n\n const names = members.map(member => member.name.toLowerCase().trim())\n const uniqueNames = new Set(names)\n if (names.length !== uniqueNames.size) {\n return { valid: false, error: \"Duplicate member names are not allowed within a team\" }\n }\n\n for (let i = 0; i < members.length; i++) {\n const member = members[i]\n \n if (!member.name || typeof member.name !== \"string\" || member.name.trim() === \"\") {\n return { valid: false, error: `Member ${i + 1}: Name is required` }\n }\n\n if (!member.age || typeof member.age !== \"number\" || member.age < 6) {\n return { valid: false, error: `Member ${i + 1}: Age must be 6 or above` }\n }\n }\n\n return { valid: true }\n}\n\nexport async function validateQuizTeamName(teamName: string): Promise<{ valid: boolean; error?: string }> {\n if (!teamName || typeof teamName !== \"string\" || teamName.trim() === \"\") {\n return { valid: false, error: \"Team name is required\" }\n }\n\n const trimmedName = teamName.trim()\n \n // Check length\n if (trimmedName.length < 3 || trimmedName.length > 30) {\n return { valid: false, error: \"Team name must be between 3 and 30 characters\" }\n }\n\n // Check for appropriate characters (allow letters, numbers, spaces, and common punctuation in multiple languages)\n const validPattern = /^[\\w\\s\\u0900-\\u097F\\u0A80-\\u0AFF\\u0A00-\\u0A7F\\-\\.,!]+$/\n if (!validPattern.test(trimmedName)) {\n return { valid: false, error: \"Team name contains invalid characters\" }\n }\n\n // Check for inappropriate content (basic filter)\n const inappropriateWords = ['test', 'dummy', 'fake', 'admin', 'null', 'undefined']\n const lowerName = trimmedName.toLowerCase()\n for (const word of inappropriateWords) {\n if (lowerName.includes(word)) {\n return { valid: false, error: \"Please choose a more appropriate team name\" }\n }\n }\n\n // Check for uniqueness in database\n const result = await sqlite.execute({\n sql: `SELECT id FROM \"${QUIZ_TABLE_NAME}\" WHERE team_name = ? COLLATE NOCASE`,\n args: [trimmedName]\n })\n\n if (result.rows && result.rows.length > 0) {\n return { valid: false, error: \"Team name already exists. Please choose a different name.\" }\n }\n\n return { valid: true }\n}\n\nexport async function saveQuizTeamData(data: QuizTeamData): Promise {\n const teamNameValidation = await validateQuizTeamName(data.team_name)\n if (!teamNameValidation.valid) {\n throw new Error(teamNameValidation.error)\n }\n\n const membersValidation = validateQuizTeamMembers(data.members)\n if (!membersValidation.valid) {\n throw new Error(membersValidation.error)\n }\n\n const contactRegex = /^[6-9]\\d{9}$/\n if (!contactRegex.test(data.contact_number)) {\n throw new Error(\"Contact number must be a valid 10-digit Indian mobile number\")\n }\n\n await sqlite.execute({\n sql: `\n INSERT INTO \"${QUIZ_TABLE_NAME}\" \n (team_name, parent_name, contact_number, members, member_count)\n VALUES (?, ?, ?, ?, ?)\n `, args: [\n data.team_name.trim(),\n data.parent_name.trim(),\n data.contact_number.trim(),\n JSON.stringify(data.members),\n data.members.length\n ]\n })\n}\n\nexport async function getQuizTeams(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM \"${QUIZ_TABLE_NAME}\" \n ORDER BY created_at DESC\n `)\n\n const rows: QuizTeamData[] = result.rows?.map(row => {\n const rowObj = Object.fromEntries(row.map((value, index) => [result.columns[index], value])) as any\n \n return {\n id: rowObj.id,\n team_name: rowObj.team_name,\n parent_name: rowObj.parent_name,\n contact_number: rowObj.contact_number,\n members: JSON.parse(rowObj.members) as QuizTeamMember[],\n created_at: rowObj.created_at,\n updated_at: rowObj.updated_at\n }\n }) || []\n\n return rows\n}\n\nexport async function deleteQuizTeam(teamName: string): Promise {\n try {\n console.log(\"Attempting to delete quiz team:\", teamName)\n \n const checkResult = await sqlite.execute({\n sql: `SELECT team_name FROM \"${QUIZ_TABLE_NAME}\" WHERE team_name = ? COLLATE NOCASE`,\n args: [teamName]\n })\n \n console.log(\"Team exists check:\", checkResult.rows?.length || 0, \"records found\")\n \n if (!checkResult.rows || checkResult.rows.length === 0) {\n console.log(\"No team found with name:\", teamName)\n return false\n }\n \n const deleteResult = await sqlite.execute({\n sql: `DELETE FROM \"${QUIZ_TABLE_NAME}\" WHERE team_name = ? COLLATE NOCASE`,\n args: [teamName]\n })\n \n console.log(\"Delete result:\", deleteResult)\n \n const verifyResult = await sqlite.execute({\n sql: `SELECT team_name FROM \"${QUIZ_TABLE_NAME}\" WHERE team_name = ? COLLATE NOCASE`,\n args: [teamName]\n })\n \n const deleted = !verifyResult.rows || verifyResult.rows.length === 0\n console.log(\"Deletion verified:\", deleted)\n \n return deleted\n } catch (error) {\n console.error(\"Error deleting quiz team:\", error)\n return false\n }\n}\n\nexport async function getQuizSummary(): Promise {\n try {\n const teams = await getQuizTeams()\n const totalTeams = teams.length\n \n let totalMembers = 0\n const ageCounts: Record = {}\n const teamSizeCounts: Record = {}\n \n teams.forEach(team => {\n const teamSize = team.members.length\n totalMembers += teamSize\n \n const sizeKey = `${teamSize} member${teamSize !== 1 ? \"s\" : \"\"}`\n teamSizeCounts[sizeKey] = (teamSizeCounts[sizeKey] || 0) + 1\n \n team.members.forEach(member => {\n const ageGroup = \n member.age <= 8 ? \"6-8\" :\n member.age <= 10 ? \"9-10\" :\n member.age <= 12 ? \"11-12\" :\n member.age <= 14 ? \"13-14\" :\n member.age <= 16 ? \"15-16\" :\n member.age <= 18 ? \"17-18\" : \"19+\"\n \n ageCounts[ageGroup] = (ageCounts[ageGroup] || 0) + 1\n })\n })\n \n const averageTeamSize = totalTeams > 0 ? Math.round((totalMembers / totalTeams) * 10) / 10 : 0\n \n return {\n totalTeams,\n totalMembers,\n averageTeamSize,\n ageCounts,\n teamSizeCounts\n }\n } catch (error) {\n console.error(\"Error getting quiz summary:\", error)\n return {\n totalTeams: 0,\n totalMembers: 0,\n averageTeamSize: 0,\n ageCounts: {},\n teamSizeCounts: {}\n }\n }\n}\n","deleted","label",[168,149],"backend","permalink","https://www.val.town/x/prashamtrivedi/ganeshotsav-2025-forms/code/backend/database.ts","extension","actionData","errors"]