[{"_1":2,"_175":-5,"_176":-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,"_149":150,"_172":173,"_174":-5},"handle","cricks_unmixed4u","name","kuadratic","path","lib/index.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","c4dfe5aa-5141-11f0-a8c3-f69ea79377d9","createdAt",["D",1750800336613],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","0b86c720-ddc6-11ef-94bf-d1c3ffb48162","pinnedFileId","pinPreview","screenshotVersion","likeCount","7018ec7d-7a8e-4e8f-93d1-ab6a7334ca50","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJzSEJuSGdYT2dQSmprejVnU0VqalpDaWhKUSJ9","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",36,"c4e29c14-5141-11f0-a8c3-f69ea79377d9","projectId","forkedBranchId","cb6a155a-43e8-11f0-a2f5-76b3cceeab13","forkedBranchVersion",33,"forkedProjectPrivacy","forkedProjectId","cb69c7ee-43e8-11f0-a2f5-76b3cceeab13","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":152,"_153":154,"_155":156,"_157":136,"_158":159,"_160":161,"_103":162,"_134":163,"_164":165,"_166":167,"_168":20,"_169":-5,"_97":170},"abf61964-516a-11f0-83e4-f69ea79377d9","index.ts","fileId","f380c3aa-5143-11f0-9d89-f69ea79377d9","parentId","cc9ccd20-5142-11f0-bf0e-f69ea79377d9","branchId","branchVersion",32,"latest",true,["D",1750817904176],11,"fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { Hono } from \"https://esm.sh/hono@4.0.0\";\nimport { z } from \"https://esm.sh/zod@3.22.4\";\n\n// Zod schemas for validation\nconst VoteOptionSchema = z.object({\n id: z.string(),\n title: z.string(),\n description: z.string().optional(),\n voteCount: z.number()\n});\n\nconst VoteRecordSchema = z.object({\n id: z.number(),\n pollId: z.string(),\n optionId: z.string(),\n voterId: z.string(),\n timestamp: z.string()\n});\n\nconst VoteRequestSchema = z.object({\n pollId: z.string(),\n optionId: z.string(),\n voterId: z.string(),\n maxTotalVotes: z.number().positive(),\n maxVotesPerUser: z.number().positive()\n});\n\n// Types\ninterface VoteOption {\n id: string;\n title: string;\n description?: string;\n voteCount: number;\n}\n\ninterface VoteConfig {\n pollId: string;\n maxTotalVotes: number;\n maxVotesPerUser: number;\n options: Omit[];\n}\n\ninterface VoteRecord {\n id: number;\n pollId: string;\n optionId: string;\n voterId: string;\n timestamp: string;\n}\n\n// Database setup\nconst VOTES_TABLE = 'kuadratic_votes_1';\nconst OPTIONS_TABLE = 'kuadratic_options_1';\n\n// DEFINE SCHEMa for VOTES_TABLE using zod\nasync function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${VOTES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n poll_id TEXT NOT NULL,\n option_id TEXT NOT NULL,\n voter_id TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${OPTIONS_TABLE} (\n id TEXT PRIMARY KEY,\n poll_id TEXT NOT NULL,\n title TEXT NOT NULL,\n description TEXT,\n vote_count INTEGER DEFAULT 0\n )`);\n}\n\n// Database queries\nasync function getVoteCount(pollId: string): Promise {\n const result = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${VOTES_TABLE} WHERE poll_id = ?`,\n [pollId]\n );\n return result[0]?.count || 0;\n}\n\nasync function getUserVoteCount(pollId: string, voterId: string): Promise {\n const result = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${VOTES_TABLE} WHERE poll_id = ? AND voter_id = ?`,\n [pollId, voterId]\n );\n return result[0]?.count || 0;\n}\n\nasync function getOptions(pollId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${OPTIONS_TABLE} WHERE poll_id = ?`,\n [pollId]\n );\n \n // Validate and transform database results using zod schema\n return result.rows.map(row => {\n const validatedRow = VoteOptionSchema.parse({\n id: row.id,\n title: row.title,\n description: row.description,\n voteCount: row.vote_count\n });\n return validatedRow;\n });\n}\n\nasync function addVote(pollId: string, optionId: string, voterId: string): Promise {\n await sqlite.execute(\n `INSERT INTO ${VOTES_TABLE} (poll_id, option_id, voter_id) VALUES (?, ?, ?)`,\n [pollId, optionId, voterId]\n );\n \n await sqlite.execute(\n `UPDATE ${OPTIONS_TABLE} SET vote_count = vote_count + 1 WHERE id = ? AND poll_id = ?`,\n [optionId, pollId]\n );\n}\n\nasync function initializeOptions(config: VoteConfig): Promise {\n for (const option of config.options) {\n await sqlite.execute(\n `INSERT OR IGNORE INTO ${OPTIONS_TABLE} (id, poll_id, title, description, vote_count) VALUES (?, ?, ?, ?, 0)`,\n [option.id, config.pollId, option.title, option.description || null]\n );\n }\n}\n\n// API registration function\nexport function registerApiHandlers(app: Hono) {\n app.post('/api/vote', async (c) => {\n try {\n // Validate request body with zod\n const requestData = VoteRequestSchema.parse(await c.req.json());\n const { pollId, optionId, voterId, maxTotalVotes, maxVotesPerUser } = requestData;\n\n // Check vote limits\n const totalVotes = await getVoteCount(pollId);\n if (totalVotes >= maxTotalVotes) {\n return c.json({ error: 'Maximum total votes reached' }, 400);\n }\n\n const userVotes = await getUserVoteCount(pollId, voterId);\n if (userVotes >= maxVotesPerUser) {\n return c.json({ error: 'Maximum votes per user reached' }, 400);\n }\n\n await addVote(pollId, optionId, voterId);\n const options = await getOptions(pollId);\n \n return c.json({ success: true, options });\n } catch (error) {\n if (error instanceof z.ZodError) {\n return c.json({ error: 'Invalid request data', details: error.errors }, 400);\n }\n throw error;\n }\n });\n\n app.get('/api/results/:pollId', async (c) => {\n const pollId = c.req.param('pollId');\n const options = await getOptions(pollId);\n const totalVotes = await getVoteCount(pollId);\n \n return c.json({ options, totalVotes });\n });\n}\n\n// HTML Component Export\nfunction createVotingWidget(config: VoteConfig): string {\n const voterId = `voter_${Math.random().toString(36).substr(2, 9)}`;\n \n return `\n \n `;\n}\n\n// Initialize database on startup\nif (Deno.env.get('KUADRATIC_INITDB') || false )\n await initDatabase();\n\n// Export functions\nexport { createVotingWidget, initializeOptions };\n\n","deleted","label",[171,152],"lib","permalink","https://www.val.town/x/cricks_unmixed4u/kuadratic/code/lib/index.ts","extension","actionData","errors"]