[{"_1":2,"_178":-5,"_179":-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","64602b05c9a02becc3d4aac52b7346fd8c14b4dc","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,"_155":156,"_175":176,"_177":-5},"handle","dcm31","name","pmf-survey","path","db.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":111,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":32,"_14":119,"_120":121,"_122":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_141":142,"_154":20},"id","7d9310a4-fa75-11f0-aded-42dde27851f2","createdAt",["D",1769404297336],"deletedAt","legacyEnvVars","privacy","public","description","Superhuman PMF Framework - measure product-market fit","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","d663a026-6449-42f6-9156-1d4a2d64d38c","tursoName","7d9310a4fa7511f0aded42dde27851f2","tursoHostname","7d9310a4fa7511f0aded42dde27851f2-val-town.aws-us-east-2.turso.io","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_134":135},"profileImageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/260ec866-bb5d-4641-4bfe-526cca896a00/square512","org",{"_94":95,"_138":135,"_12":113,"_139":140},"avatar","tier","pro","branch",{"_143":144,"_96":44,"_102":145,"_146":103,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":97,"_153":95},"version",21,"7d938fa2-fa75-11f0-aded-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":157,"_96":99,"_158":159,"_160":-5,"_161":145,"_162":163,"_164":165,"_104":166,"_143":167,"_168":169,"_170":171,"_172":20,"_173":-5,"_98":174},"99299eb2-fa7c-11f0-a539-42dde27851f2","fileId","a019aea8-fa75-11f0-8990-42dde27851f2","parentId","branchId","branchVersion",20,"latest",true,["D",1769407350079],5,"fileType","script","content","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TABLE_NAME = \"responses\";\nconst INSIGHTS_TABLE = \"insights\";\n\nlet tablesCreated = false;\n\nexport interface SurveyResponse {\n id: number;\n timestamp: number;\n disappointment: \"very\" | \"somewhat\" | \"not\";\n user_type: string;\n main_benefit: string;\n improvement: string;\n email?: string;\n persona?: string;\n analysis?: string;\n}\n\nexport interface Insights {\n id: number;\n timestamp: number;\n pmf_score: number;\n segmented_pmf_score: number;\n total_responses: number;\n very_disappointed_count: number;\n somewhat_disappointed_count: number;\n not_disappointed_count: number;\n hxc_profile: string;\n top_benefits: string;\n top_improvements: string;\n roadmap_double_down: string;\n roadmap_address_gaps: string;\n personas_in_segment: string;\n}\n\nasync function ensureTables(): Promise {\n if (tablesCreated) return;\n \n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n disappointment TEXT NOT NULL,\n user_type TEXT NOT NULL,\n main_benefit TEXT NOT NULL,\n improvement TEXT NOT NULL,\n email TEXT,\n persona TEXT,\n analysis TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${INSIGHTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n pmf_score REAL NOT NULL,\n segmented_pmf_score REAL NOT NULL,\n total_responses INTEGER NOT NULL,\n very_disappointed_count INTEGER NOT NULL,\n somewhat_disappointed_count INTEGER NOT NULL,\n not_disappointed_count INTEGER NOT NULL,\n hxc_profile TEXT,\n top_benefits TEXT,\n top_improvements TEXT,\n roadmap_double_down TEXT,\n roadmap_address_gaps TEXT,\n personas_in_segment TEXT\n )\n `);\n \n tablesCreated = true;\n}\n\nexport async function storeResponse(data: {\n disappointment: \"very\" | \"somewhat\" | \"not\";\n user_type: string;\n main_benefit: string;\n improvement: string;\n email?: string;\n}): Promise {\n await ensureTables();\n \n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (timestamp, disappointment, user_type, main_benefit, improvement, email)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [Date.now(), data.disappointment, data.user_type, data.main_benefit, data.improvement, data.email || null],\n );\n return Number(result.lastInsertRowid);\n}\n\nexport async function updateResponseAnalysis(id: number, persona: string, analysis: string): Promise {\n await ensureTables();\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET persona = ?, analysis = ? WHERE id = ?`,\n [persona, analysis, id],\n );\n}\n\nexport async function getAllResponses(): Promise {\n await ensureTables();\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY timestamp DESC`);\n return rowsToObjects(result) as SurveyResponse[];\n}\n\nexport async function getResponseById(id: number): Promise {\n await ensureTables();\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n const rows = rowsToObjects(result);\n return (rows[0] as SurveyResponse) || null;\n}\n\nexport async function getResponsesByDisappointment(level: \"very\" | \"somewhat\" | \"not\"): Promise {\n await ensureTables();\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE disappointment = ? ORDER BY timestamp DESC`,\n [level],\n );\n return rowsToObjects(result) as SurveyResponse[];\n}\n\nexport async function getResponseCounts(): Promise<{\n total: number;\n very: number;\n somewhat: number;\n not: number;\n}> {\n await ensureTables();\n const result = await sqlite.execute(`\n SELECT \n COUNT(*) as total,\n SUM(CASE WHEN disappointment = 'very' THEN 1 ELSE 0 END) as very,\n SUM(CASE WHEN disappointment = 'somewhat' THEN 1 ELSE 0 END) as somewhat,\n SUM(CASE WHEN disappointment = 'not' THEN 1 ELSE 0 END) as not_count\n FROM ${TABLE_NAME}\n `);\n const rows = rowsToObjects(result);\n const row = rows[0] as any;\n return {\n total: Number(row?.total) || 0,\n very: Number(row?.very) || 0,\n somewhat: Number(row?.somewhat) || 0,\n not: Number(row?.not_count) || 0,\n };\n}\n\nexport async function storeInsights(data: Omit): Promise {\n await ensureTables();\n await sqlite.execute(\n `INSERT INTO ${INSIGHTS_TABLE} \n (timestamp, pmf_score, segmented_pmf_score, total_responses, \n very_disappointed_count, somewhat_disappointed_count, not_disappointed_count,\n hxc_profile, top_benefits, top_improvements, roadmap_double_down, roadmap_address_gaps, personas_in_segment)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n Date.now(),\n data.pmf_score,\n data.segmented_pmf_score,\n data.total_responses,\n data.very_disappointed_count,\n data.somewhat_disappointed_count,\n data.not_disappointed_count,\n data.hxc_profile,\n data.top_benefits,\n data.top_improvements,\n data.roadmap_double_down,\n data.roadmap_address_gaps,\n data.personas_in_segment,\n ],\n );\n}\n\nexport async function getLatestInsights(): Promise {\n await ensureTables();\n const result = await sqlite.execute(\n `SELECT * FROM ${INSIGHTS_TABLE} ORDER BY timestamp DESC LIMIT 1`,\n );\n const rows = rowsToObjects(result);\n return (rows[0] as Insights) || null;\n}\n\n// Helper to convert rows array to objects\nfunction rowsToObjects(result: { columns: string[]; rows: unknown[][] }): Record[] {\n return result.rows.map((row) => {\n const obj: Record = {};\n result.columns.forEach((col, idx) => {\n obj[col] = row[idx];\n });\n return obj;\n });\n}\n","deleted","label",[99],"permalink","https://www.val.town/x/dcm31/pmf-survey/code/db.ts","extension","actionData","errors"]