[{"_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","e3ca0a77ab07ff2ce3097208ffd6aa0e378d3c47","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,"_149":150,"_171":172,"_173":-5},"handle","ikeali","name","my-first-val1","path","backend/routes/polls.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,"_148":20},"id","8530577e-4074-11f0-9433-76b3cceeab13","createdAt",["D",1748952964333],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","1ef380b0-3f9f-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","screenshotVersion","likeCount","175dd161-d97e-4dae-8110-5f4423725a9e","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHd1OENvNzliczFIeTFodFNiYms3ejB3dTQifQ","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":139,"_140":141,"_142":108,"_143":144,"_145":116,"_146":96,"_147":94},"version",1,"853242b4-4074-11f0-9433-76b3cceeab13","projectId","forkedBranchId","336188a8-3f9f-11f0-9765-76b3cceeab13","forkedBranchVersion",26,"forkedProjectPrivacy","forkedProjectId","33614708-3f9f-11f0-9765-76b3cceeab13","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":152,"_153":154,"_155":156,"_157":136,"_158":135,"_159":160,"_103":161,"_134":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_97":168},"8534dbfa-4074-11f0-9433-76b3cceeab13","polls.ts","fileId","bdf9e74c-f3f9-47ed-a25c-3105a6e39aa9","parentId","cfe266a6-9350-47f7-af09-cf43ea4cf80d","branchId","branchVersion","latest",true,["D",1748952964333],"fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\nimport { \n createPoll, \n getPollById, \n getAllPolls, \n updatePoll, \n deletePoll,\n getSessionUser \n} from \"../database/queries.ts\";\nimport { requireAuth } from \"./auth.ts\";\nimport { sanitizeInput, isPollActive } from \"../../shared/utils.ts\";\nimport type { CreatePollRequest, ApiResponse, User } from \"../../shared/types.ts\";\n\nconst polls = new Hono();\n\n// Get all polls\npolls.get(\"/\", async (c) => {\n try {\n // Get user if authenticated (optional)\n let userId: number | undefined;\n const sessionId = getCookie(c, \"session_id\");\n if (sessionId) {\n const user = await getSessionUser(sessionId);\n if (user) userId = user.id;\n }\n\n const allPolls = await getAllPolls(userId);\n \n return c.json({ \n success: true, \n data: allPolls \n });\n\n } catch (error) {\n console.error(\"Get polls error:\", error);\n return c.json({ \n success: false, \n error: \"Internal server error\" \n }, 500);\n }\n});\n\n// Get specific poll\npolls.get(\"/:id\", async (c) => {\n try {\n const pollId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(pollId)) {\n return c.json({ \n success: false, \n error: \"Invalid poll ID\" \n }, 400);\n }\n\n // Get user if authenticated (optional)\n let userId: number | undefined;\n const sessionId = getCookie(c, \"session_id\");\n if (sessionId) {\n const user = await getSessionUser(sessionId);\n if (user) userId = user.id;\n }\n\n const poll = await getPollById(pollId, userId);\n \n if (!poll) {\n return c.json({ \n success: false, \n error: \"Poll not found\" \n }, 404);\n }\n\n return c.json({ \n success: true, \n data: poll \n });\n\n } catch (error) {\n console.error(\"Get poll error:\", error);\n return c.json({ \n success: false, \n error: \"Internal server error\" \n }, 500);\n }\n});\n\n// Create new poll (requires authentication)\npolls.post(\"/\", requireAuth, async (c) => {\n try {\n const user: User = c.get(\"user\");\n const body: CreatePollRequest = await c.req.json();\n\n // Validate input\n if (!body.title || !body.description || !body.options || !body.start_date || !body.end_date) {\n return c.json({ \n success: false, \n error: \"Title, description, options, start_date, and end_date are required\" \n }, 400);\n }\n\n if (!Array.isArray(body.options) || body.options.length < 2) {\n return c.json({ \n success: false, \n error: \"At least 2 options are required\" \n }, 400);\n }\n\n if (body.options.length > 10) {\n return c.json({ \n success: false, \n error: \"Maximum 10 options allowed\" \n }, 400);\n }\n\n // Validate dates\n const startDate = new Date(body.start_date);\n const endDate = new Date(body.end_date);\n const now = new Date();\n\n if (isNaN(startDate.getTime()) || isNaN(endDate.getTime())) {\n return c.json({ \n success: false, \n error: \"Invalid date format\" \n }, 400);\n }\n\n if (endDate <= startDate) {\n return c.json({ \n success: false, \n error: \"End date must be after start date\" \n }, 400);\n }\n\n if (endDate <= now) {\n return c.json({ \n success: false, \n error: \"End date must be in the future\" \n }, 400);\n }\n\n // Sanitize input\n const pollData: CreatePollRequest = {\n title: sanitizeInput(body.title),\n description: sanitizeInput(body.description),\n options: body.options.map(option => sanitizeInput(option)).filter(option => option.length > 0),\n start_date: body.start_date,\n end_date: body.end_date\n };\n\n if (pollData.options.length < 2) {\n return c.json({ \n success: false, \n error: \"At least 2 valid options are required after sanitization\" \n }, 400);\n }\n\n const poll = await createPoll(pollData, user.id);\n\n return c.json({ \n success: true, \n data: poll \n }, 201);\n\n } catch (error) {\n console.error(\"Create poll error:\", error);\n return c.json({ \n success: false, \n error: \"Internal server error\" \n }, 500);\n }\n});\n\n// Update poll (requires authentication and ownership or admin)\npolls.put(\"/:id\", requireAuth, async (c) => {\n try {\n const user: User = c.get(\"user\");\n const pollId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(pollId)) {\n return c.json({ \n success: false, \n error: \"Invalid poll ID\" \n }, 400);\n }\n\n const existingPoll = await getPollById(pollId);\n if (!existingPoll) {\n return c.json({ \n success: false, \n error: \"Poll not found\" \n }, 404);\n }\n\n // Check permissions\n if (existingPoll.creator_id !== user.id && !user.is_admin) {\n return c.json({ \n success: false, \n error: \"Permission denied\" \n }, 403);\n }\n\n const body = await c.req.json();\n const updates: any = {};\n\n // Only allow certain fields to be updated\n if (body.title !== undefined) {\n updates.title = sanitizeInput(body.title);\n }\n if (body.description !== undefined) {\n updates.description = sanitizeInput(body.description);\n }\n if (body.is_active !== undefined) {\n updates.is_active = Boolean(body.is_active);\n }\n if (body.start_date !== undefined) {\n const startDate = new Date(body.start_date);\n if (isNaN(startDate.getTime())) {\n return c.json({ \n success: false, \n error: \"Invalid start date format\" \n }, 400);\n }\n updates.start_date = body.start_date;\n }\n if (body.end_date !== undefined) {\n const endDate = new Date(body.end_date);\n if (isNaN(endDate.getTime())) {\n return c.json({ \n success: false, \n error: \"Invalid end date format\" \n }, 400);\n }\n updates.end_date = body.end_date;\n }\n\n const updatedPoll = await updatePoll(pollId, updates);\n\n return c.json({ \n success: true, \n data: updatedPoll \n });\n\n } catch (error) {\n console.error(\"Update poll error:\", error);\n return c.json({ \n success: false, \n error: \"Internal server error\" \n }, 500);\n }\n});\n\n// Delete poll (requires authentication and ownership or admin)\npolls.delete(\"/:id\", requireAuth, async (c) => {\n try {\n const user: User = c.get(\"user\");\n const pollId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(pollId)) {\n return c.json({ \n success: false, \n error: \"Invalid poll ID\" \n }, 400);\n }\n\n const existingPoll = await getPollById(pollId);\n if (!existingPoll) {\n return c.json({ \n success: false, \n error: \"Poll not found\" \n }, 404);\n }\n\n // Check permissions\n if (existingPoll.creator_id !== user.id && !user.is_admin) {\n return c.json({ \n success: false, \n error: \"Permission denied\" \n }, 403);\n }\n\n const deleted = await deletePoll(pollId);\n \n if (!deleted) {\n return c.json({ \n success: false, \n error: \"Failed to delete poll\" \n }, 500);\n }\n\n return c.json({ \n success: true \n });\n\n } catch (error) {\n console.error(\"Delete poll error:\", error);\n return c.json({ \n success: false, \n error: \"Internal server error\" \n }, 500);\n }\n});\n\n// Get poll results\npolls.get(\"/:id/results\", async (c) => {\n try {\n const pollId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(pollId)) {\n return c.json({ \n success: false, \n error: \"Invalid poll ID\" \n }, 400);\n }\n\n const poll = await getPollById(pollId);\n \n if (!poll) {\n return c.json({ \n success: false, \n error: \"Poll not found\" \n }, 404);\n }\n\n // Calculate percentages\n const total_votes = poll.options.reduce((sum, option) => sum + option.vote_count, 0);\n const optionsWithPercentage = poll.options.map(option => ({\n ...option,\n percentage: total_votes > 0 ? Math.round((option.vote_count / total_votes) * 100) : 0\n }));\n\n const results = {\n poll: {\n ...poll,\n options: optionsWithPercentage\n },\n total_votes\n };\n\n return c.json({ \n success: true, \n data: results \n });\n\n } catch (error) {\n console.error(\"Get poll results error:\", error);\n return c.json({ \n success: false, \n error: \"Internal server error\" \n }, 500);\n }\n});\n\nexport default polls;","deleted","label",[169,170,152],"backend","routes","permalink","https://www.val.town/x/ikeali/my-first-val1/code/backend/routes/polls.ts","extension","actionData","errors"]