Source reported

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_156":157,"_158":159},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":122,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","feedback-val.ts","latestPath","fileId","42e22aaa-4609-11f1-b293-42b51c65c3df","name","fileType","http","content","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Portfolio Monitor — Source Feedback Val\n// Create this as a separate HTTP val in Val.town.\n// After creating it, copy its URL into your monitoring val's\n// FEEDBACK_VAL_URL environment variable.\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const source = url.searchParams.get(\"source\") ?? \"\";\n const ticker = url.searchParams.get(\"ticker\") ?? \"\";\n const ctx = `[feedback] source=\"${source}\" ticker=\"${ticker}\"`;\n\n if (!source) {\n console.warn(`${ctx} — rejected: missing source parameter`);\n return new Response(\"Missing source parameter\", { status: 400 });\n }\n\n const key = source.toLowerCase().trim().slice(0, 60);\n console.log(`${ctx} — report received, key=\"${key}\"`);\n\n // Step 1: ensure table exists\n try {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS pm_source_stats (\n source TEXT PRIMARY KEY,\n count INTEGER NOT NULL DEFAULT 0,\n score_sum REAL NOT NULL DEFAULT 0,\n last_updated TEXT NOT NULL DEFAULT '',\n user_reports INTEGER NOT NULL DEFAULT 0\n )`);\n console.log(`${ctx} — step 1 OK: table ready`);\n } catch (e) {\n console.error(`${ctx} — step 1 FAIL: CREATE TABLE:`, e);\n return errorPage(\n source,\n ticker,\n \"Database table could not be initialised.\",\n 503,\n );\n }\n\n // Step 2: add user_reports column if missing (idempotent migration)\n try {\n await sqlite.execute(\n \"ALTER TABLE pm_source_stats ADD COLUMN user_reports INTEGER NOT NULL DEFAULT 0\",\n );\n console.log(`${ctx} — step 2: user_reports column added (first run)`);\n } catch (e) {\n const msg = String(e);\n if (msg.includes(\"duplicate column\") || msg.includes(\"already exists\")) {\n console.log(`${ctx} — step 2 OK: user_reports column already present`);\n } else {\n // Unexpected but non-fatal — column may still exist, continue\n console.warn(\n `${ctx} — step 2 WARN: unexpected ALTER TABLE error (continuing):`,\n e,\n );\n }\n }\n\n // Step 3: upsert the report\n let reports = 1;\n try {\n await sqlite.execute({\n sql:\n `INSERT INTO pm_source_stats (source, count, score_sum, last_updated, user_reports)\n VALUES (?, 5, 5.0, date('now'), 1)\n ON CONFLICT(source) DO UPDATE SET\n user_reports = user_reports + 1,\n last_updated = date('now')`,\n args: [key],\n });\n console.log(`${ctx} — step 3 OK: upsert succeeded`);\n } catch (e) {\n console.error(`${ctx} — step 3 FAIL: upsert:`, e);\n return errorPage(\n source,\n ticker,\n \"Could not save your report. Please try again.\",\n 500,\n );\n }\n\n // Step 4: read back for confirmation (non-critical)\n try {\n const res = await sqlite.execute({\n sql:\n \"SELECT count, score_sum, user_reports FROM pm_source_stats WHERE source = ?\",\n args: [key],\n });\n const row = res.rows[0];\n if (row) {\n reports = Number(row[2]);\n const mean = (Number(row[1]) / Math.max(Number(row[0]), 1)).toFixed(1);\n console.log(\n `${ctx} — step 4 OK: reports=${reports} count=${row[0]} mean=${mean}`,\n );\n } else {\n console.warn(\n `${ctx} — step 4 WARN: write succeeded but read-back returned no rows`,\n );\n }\n } catch (e) {\n // Write succeeded — just can't confirm count. Non-critical.\n console.warn(\n `${ctx} — step 4 WARN: read-back failed (write still succeeded):`,\n e,\n );\n }\n\n console.log(`${ctx} — done. Penalty active from next monitoring run.`);\n return new Response(successPage(source, ticker, reports), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction successPage(source: string, ticker: string, reports: number): string {\n const penaltyText = reports === 1\n ? \"-1 on future articles\"\n : reports === 2\n ? \"-2 on future articles\"\n : \"-3 on future articles (maximum)\";\n return `\n\nSource reported\n\n\n\n\n

⚑ Source reported

Marked ${source}${\n ticker ? ` (${ticker})` : \"\"\n } as low quality.

A score penalty will apply to future articles from this source.

Penalty: ${penaltyText}

Total reports for this source: ${reports}

\n\n`;\n}\n\nfunction errorPage(\n source: string,\n ticker: string,\n message: string,\n status: number,\n): Response {\n const html = `\n\nError\n\n\n\n\n

Could not record report

${message}

${source}${\n ticker ? ` · ${ticker}` : \"\"\n }

\n\n`;\n return new Response(html, {\n status,\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}","import { blob } from \"https://esm.town/v/std/blob\";\n\n// Portfolio Monitor — Source Feedback Val\n// Deployed as a separate HTTP val. URL goes in FEEDBACK_VAL_URL env var on the monitor val.\n//\n// Uses blob storage (shared across all your vals) instead of SQLite (per-val, not shared).\n// The monitor drains pm_feedback_queue at startup and applies reports to its own SQLite.\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const source = url.searchParams.get(\"source\") ?? \"\";\n const ticker = url.searchParams.get(\"ticker\") ?? \"\";\n const ctx = `[feedback] source=\"${source}\" ticker=\"${ticker}\"`;\n\n if (!source) {\n console.warn(`${ctx} — rejected: missing source parameter`);\n return new Response(\"Missing source parameter\", { status: 400 });\n }\n\n const key = source.toLowerCase().trim().slice(0, 60);\n console.log(`${ctx} — report received, key=\"${key}\"`);\n\n let reports = 1;\n try {\n const queueKey = \"pm_feedback_queue\";\n const existing = (await blob.getJSON(queueKey) as Record | null) ?? {};\n existing[key] = (existing[key] ?? 0) + 1;\n reports = existing[key];\n await blob.setJSON(queueKey, existing);\n console.log(`${ctx} — queued. Total pending reports for this source: ${reports}`);\n } catch (e) {\n console.error(`${ctx} — failed to write to blob queue:`, e);\n return errorPage(source, ticker, \"Could not save your report. Please try again.\", 500);\n }\n\n console.log(`${ctx} — done. Will apply on next monitor run.`);\n return new Response(successPage(source, ticker, reports), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction successPage(source: string, ticker: string, reports: number): string {\n const penaltyText = reports === 1\n ? \"−1 on future articles\"\n : reports === 2\n ? \"−2 on future articles\"\n : \"−3 on future articles (maximum)\";\n\n return `\n\nSource reported\n\n\n\n\n

⚑ Source reported

Marked ${source}${ticker ? ` (${ticker})` : \"\"} as low quality.

The penalty will apply from the next monitoring run.

Penalty: ${penaltyText}

Reports queued for this source: ${reports}

\n\n`;\n}\n\nfunction errorPage(source: string, ticker: string, message: string, status: number): Response {\n return new Response(`\n\nError\n\n\n\n\n

Could not record report

${message}

${source}${ticker ? ` · ${ticker}` : \"\"}

\n\n`, { status, headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n}","createdAt",["D",1779180413074],"branchVersion","branchId","42df182e-4609-11f1-b293-42b51c65c3df","id","42de3274-4609-11f1-b293-42b51c65c3df","feedback-val",["D",1777714101569],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","398b578a-7377-4375-8442-3270d4e5f17b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d8b36-dddc-734f-93e5-9178e727c860","tursoName","42de3274460911f1b29342b51c65c3df","tursoHostname","42de3274460911f1b29342b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789510872811],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":25},"branch",{"_13":14,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","edouard123","handle","displayName","avatar","https://avatars.githubusercontent.com/u/22078941?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":151,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":152,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":153,"_81":154,"_83":155,"_85":25},"tree",[146],"files",[146],"counts",{"_135":60,"_136":137,"_138":60,"_139":140,"_141":142},"contents",[127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":122,"_38":131,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_27":134},"48a371d4-535f-11f1-81e6-ee650bb23af1","parentId","latest",["D",1779180413074],5,"label",[28],"pulls","branches",1,"forks","envVars",{"_143":60,"_145":60},"connections",{"_143":60,"_144":60},"count","unfilledCount","emptyCount",{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":122,"_38":147,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_148":149,"_27":150},["D",1779180413074],"children",[],[28],["D",1777714101569],["D",1789510872811],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":25},{"_13":14,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_79":-5,"_124":189,"_190":191,"_192":193,"_194":25,"_195":25,"_196":25,"_197":122,"_198":-5,"_199":-7,"_200":-7,"_201":60,"_202":25,"_203":25,"_204":-5,"_205":25,"_206":25,"_207":25,"_208":-5},"ENV",{"_160":161,"_162":163,"_164":86,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6