[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","isTeamOrgMember","ENV",{"_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":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","16f2931b3e0f3a1f0749f6d2640b9447dd6106a9","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_148":149,"_171":172,"_173":-5},"handle","technicalmickey","name","New","path","backend/database/queries.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_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","a97497c8-3348-11f0-a40f-9e149126039e","createdAt",["D",1747504762212],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","7fe129d0-3348-11f0-b519-ff88f6bc2fe6","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","772ac466-0e98-4801-ab1f-b9723ce9ee40","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeEVZUTFZaWd0QlNuSHhycnNKUU5rUzdOSlUifQ","org",{"_94":95,"_133":130,"_12":112},"avatar","branch",{"_136":137,"_96":44,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":97,"_146":95},"version",12,"a974cf72-3348-11f0-a40f-9e149126039e","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":150,"_96":151,"_152":153,"_154":155,"_156":138,"_157":158,"_159":160,"_104":161,"_136":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_98":168},"d69805fa-3348-11f0-a1c2-9e149126039e","queries.ts","fileId","d6980690-3348-11f0-a1c2-9e149126039e","parentId","aeaf0973-d6ab-4740-86e4-24c24aa193f5","branchId","branchVersion",3,"latest",true,["D",1747504837940],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, EVENTS_TABLE, REGISTRATIONS_TABLE } from \"./migrations.ts\";\nimport { User, Event, Registration } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(user: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (name, email, password_hash) VALUES (?, ?, ?) RETURNING id`,\n [user.name, user.email, user.password_hash]\n );\n return result.rows[0].id;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE email = ?`,\n [email]\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 * FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rows.length > 0 ? result.rows[0] as User : null;\n}\n\n// Event queries\nexport async function createEvent(event: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${EVENTS_TABLE} \n (title, description, location, start_date, end_date, organizer_id, max_attendees, is_public) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING id`,\n [\n event.title, \n event.description, \n event.location, \n event.start_date, \n event.end_date, \n event.organizer_id, \n event.max_attendees, \n event.is_public ? 1 : 0\n ]\n );\n return result.rows[0].id;\n}\n\nexport async function updateEvent(id: number, event: Partial): Promise {\n // Build dynamic update query based on provided fields\n const updates: string[] = [];\n const values: any[] = [];\n\n if (event.title !== undefined) {\n updates.push(\"title = ?\");\n values.push(event.title);\n }\n if (event.description !== undefined) {\n updates.push(\"description = ?\");\n values.push(event.description);\n }\n if (event.location !== undefined) {\n updates.push(\"location = ?\");\n values.push(event.location);\n }\n if (event.start_date !== undefined) {\n updates.push(\"start_date = ?\");\n values.push(event.start_date);\n }\n if (event.end_date !== undefined) {\n updates.push(\"end_date = ?\");\n values.push(event.end_date);\n }\n if (event.max_attendees !== undefined) {\n updates.push(\"max_attendees = ?\");\n values.push(event.max_attendees);\n }\n if (event.is_public !== undefined) {\n updates.push(\"is_public = ?\");\n values.push(event.is_public ? 1 : 0);\n }\n\n updates.push(\"updated_at = datetime('now')\");\n values.push(id);\n\n if (updates.length === 0) {\n return false;\n }\n\n const result = await sqlite.execute(\n `UPDATE ${EVENTS_TABLE} SET ${updates.join(\", \")} WHERE id = ?`,\n values\n );\n \n return result.rowsAffected > 0;\n}\n\nexport async function deleteEvent(id: number): Promise {\n // First delete all registrations for this event\n await sqlite.execute(\n `DELETE FROM ${REGISTRATIONS_TABLE} WHERE event_id = ?`,\n [id]\n );\n \n // Then delete the event\n const result = await sqlite.execute(\n `DELETE FROM ${EVENTS_TABLE} WHERE id = ?`,\n [id]\n );\n \n return result.rowsAffected > 0;\n}\n\nexport async function getEventById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT e.*, u.name as organizer_name \n FROM ${EVENTS_TABLE} e\n JOIN ${USERS_TABLE} u ON e.organizer_id = u.id\n WHERE e.id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n // Get registration count\n const countResult = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${REGISTRATIONS_TABLE} WHERE event_id = ?`,\n [id]\n );\n \n const event = result.rows[0] as Event;\n return {\n ...event,\n registration_count: countResult.rows[0].count\n };\n}\n\nexport async function getAllEvents(options: {\n limit?: number;\n offset?: number;\n organizerId?: number;\n upcoming?: boolean;\n searchTerm?: string;\n}): Promise<{ events: Event[]; total: number }> {\n const { limit = 10, offset = 0, organizerId, upcoming, searchTerm } = options;\n \n let whereConditions = [\"1=1\"];\n const params: any[] = [];\n \n if (organizerId) {\n whereConditions.push(\"e.organizer_id = ?\");\n params.push(organizerId);\n }\n \n if (upcoming) {\n whereConditions.push(\"e.start_date >= datetime('now')\");\n }\n \n if (searchTerm) {\n whereConditions.push(\"(e.title LIKE ? OR e.description LIKE ? OR e.location LIKE ?)\");\n const searchPattern = `%${searchTerm}%`;\n params.push(searchPattern, searchPattern, searchPattern);\n }\n \n // Get total count\n const countResult = await sqlite.execute(\n `SELECT COUNT(*) as count \n FROM ${EVENTS_TABLE} e\n WHERE ${whereConditions.join(\" AND \")}`,\n params\n );\n \n // Get events with pagination\n const queryParams = [...params, limit, offset];\n const result = await sqlite.execute(\n `SELECT e.*, u.name as organizer_name,\n (SELECT COUNT(*) FROM ${REGISTRATIONS_TABLE} r WHERE r.event_id = e.id) as registration_count\n FROM ${EVENTS_TABLE} e\n JOIN ${USERS_TABLE} u ON e.organizer_id = u.id\n WHERE ${whereConditions.join(\" AND \")}\n ORDER BY e.start_date ASC\n LIMIT ? OFFSET ?`,\n queryParams\n );\n \n return {\n events: result.rows as Event[],\n total: countResult.rows[0].count\n };\n}\n\n// Registration queries\nexport async function registerForEvent(eventId: number, userId: number): Promise {\n try {\n await sqlite.execute(\n `INSERT INTO ${REGISTRATIONS_TABLE} (event_id, user_id) VALUES (?, ?)`,\n [eventId, userId]\n );\n return true;\n } catch (error) {\n console.error(\"Error registering for event:\", error);\n return false;\n }\n}\n\nexport async function cancelRegistration(eventId: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${REGISTRATIONS_TABLE} WHERE event_id = ? AND user_id = ?`,\n [eventId, userId]\n );\n \n return result.rowsAffected > 0;\n}\n\nexport async function updateRegistrationStatus(id: number, status: string): Promise {\n const result = await sqlite.execute(\n `UPDATE ${REGISTRATIONS_TABLE} SET status = ? WHERE id = ?`,\n [status, id]\n );\n \n return result.rowsAffected > 0;\n}\n\nexport async function getEventRegistrations(eventId: number): Promise {\n const result = await sqlite.execute(\n `SELECT r.*, u.name, u.email \n FROM ${REGISTRATIONS_TABLE} r\n JOIN ${USERS_TABLE} u ON r.user_id = u.id\n WHERE r.event_id = ?\n ORDER BY r.registration_date DESC`,\n [eventId]\n );\n \n return result.rows as Registration[];\n}\n\nexport async function getUserRegistrations(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT r.*, e.title as event_title, e.start_date, e.end_date, e.location\n FROM ${REGISTRATIONS_TABLE} r\n JOIN ${EVENTS_TABLE} e ON r.event_id = e.id\n WHERE r.user_id = ?\n ORDER BY e.start_date ASC`,\n [userId]\n );\n \n return result.rows as Registration[];\n}\n\nexport async function isUserRegistered(eventId: number, userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM ${REGISTRATIONS_TABLE} WHERE event_id = ? AND user_id = ?`,\n [eventId, userId]\n );\n \n return result.rows.length > 0;\n}","deleted","label",[169,170,151],"backend","database","permalink","https://www.val.town/x/technicalmickey/New/code/backend/database/queries.ts","extension","actionData","errors"]