[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_174":175,"_176":177},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_131":-5,"_20":132,"_22":133,"_134":135,"_136":137,"_25":138,"_24":-5,"_139":-5,"_140":-5,"_141":53,"_142":143,"_144":45,"_145":-5,"_146":-5,"_147":148},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","kfcafe","name","gastly","branchName","main","version","path","","project",{"_34":74,"_13":14,"_46":75,"_76":-5,"_77":53,"_78":79,"_80":79,"_81":-5,"_82":-5,"_83":84,"_85":-5,"_86":53,"_87":-5,"_88":-5,"_89":48,"_90":91,"_92":93,"_94":95,"_96":97,"_98":-5,"_99":100,"_101":100,"_102":103,"_104":103,"_105":103,"_106":100,"_107":100,"_108":109,"_110":111,"_112":113,"_114":53},"tree",[65,66],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":56,"_13":57,"_37":58,"_39":-5,"_40":41,"_42":59,"_44":45,"_46":60,"_17":61,"_49":62,"_51":63,"_52":53,"_54":-5,"_18":64},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":19,"_52":53,"_54":-5,"_18":55},"id","50e8d4ca-331f-11f1-8252-42b51c65c3df","new-file-1470.ts","fileId","50e8d560-331f-11f1-8252-42b51c65c3df","parentId","branchId","84d236c8-3310-11f1-a1d1-42b51c65c3df","branchVersion",2,"latest",true,"createdAt",["D",1775634501959],0,"fileType","script","content","deleted",false,"label",[36],"edcb59f2-3324-11f1-8c3d-42b51c65c3df","main.ts","84d4cb54-3310-11f1-a1d1-42b51c65c3df",8,["D",1775636912641],4,"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\ntype BuyRule = {\n id: string;\n targetName: string;\n allowedSets: string[];\n allowedConditions: string[];\n maxPricePerCard: number;\n budgetCap: number;\n schedule: string;\n dryRun: boolean;\n excludeLots: boolean;\n excludeGraded: boolean;\n preferShippingAwareRanking: boolean;\n enabled: boolean;\n createdAt: string;\n updatedAt: string;\n};\n\ntype RunRecord = {\n id: string;\n status: string;\n summary: string;\n dryRun: boolean;\n ruleId?: string;\n startedAt: string;\n finishedAt: string;\n listingsCollected: number;\n selectedListingCount: number;\n plannedSubtotal: number;\n};\n\nconst jsonHeaders = {\n \"content-type\": \"application/json; charset=utf-8\",\n \"access-control-allow-origin\": \"*\",\n \"access-control-allow-methods\": \"GET,POST,OPTIONS\",\n \"access-control-allow-headers\": \"content-type\",\n};\n\nlet schemaReady: Promise | null = null;\n\nfunction initSchema(): Promise {\n if (!schemaReady) {\n schemaReady = (async () => {\n await sqlite.execute(`\n create table if not exists buy_rules (\n id text primary key,\n payload text not null,\n updated_at text not null\n )\n `);\n await sqlite.execute(`\n create table if not exists run_records (\n id text primary key,\n payload text not null,\n updated_at text not null\n )\n `);\n })();\n }\n\n return schemaReady;\n}\n\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data, null, 2), {\n status,\n headers: jsonHeaders,\n });\n}\n\nfunction parseList(value: unknown): string[] {\n if (Array.isArray(value)) {\n return value.map((item) => String(item).trim()).filter(Boolean);\n }\n\n if (typeof value === \"string\") {\n return value.split(\",\").map((item) => item.trim()).filter(Boolean);\n }\n\n return [];\n}\n\nfunction parseNumber(value: unknown): number {\n const number = Number(value ?? 0);\n return Number.isFinite(number) ? number : 0;\n}\n\nfunction parseBoolean(value: unknown, fallback = false): boolean {\n if (typeof value === \"boolean\") {\n return value;\n }\n\n if (typeof value === \"string\") {\n const normalized = value.trim().toLowerCase();\n if ([\"true\", \"1\", \"yes\", \"on\"].includes(normalized)) {\n return true;\n }\n if ([\"false\", \"0\", \"no\", \"off\"].includes(normalized)) {\n return false;\n }\n }\n\n return fallback;\n}\n\nfunction normalizeRule(input: Record): BuyRule {\n const now = new Date().toISOString();\n\n return {\n id: typeof input.id === \"string\" && input.id.trim() ? input.id : crypto.randomUUID(),\n targetName: typeof input.targetName === \"string\" && input.targetName.trim() ? input.targetName.trim() : \"Gastly\",\n allowedSets: parseList(input.allowedSets),\n allowedConditions: parseList(input.allowedConditions),\n maxPricePerCard: parseNumber(input.maxPricePerCard),\n budgetCap: parseNumber(input.budgetCap),\n schedule: typeof input.schedule === \"string\" ? input.schedule.trim() : \"\",\n dryRun: parseBoolean(input.dryRun, true),\n excludeLots: parseBoolean(input.excludeLots, true),\n excludeGraded: parseBoolean(input.excludeGraded, true),\n preferShippingAwareRanking: parseBoolean(input.preferShippingAwareRanking, true),\n enabled: parseBoolean(input.enabled, true),\n createdAt: typeof input.createdAt === \"string\" ? input.createdAt : now,\n updatedAt: now,\n };\n}\n\nasync function listRules(): Promise {\n await initSchema();\n const rows = await sqlite.execute<{ payload: string }>(\n \"select payload from buy_rules order by updated_at desc\",\n );\n\n return rows.rows.map((row) => JSON.parse(row.payload) as BuyRule);\n}\n\nasync function saveRule(payload: Record): Promise {\n await initSchema();\n const rule = normalizeRule(payload);\n\n await sqlite.execute({\n sql: `\n insert into buy_rules (id, payload, updated_at)\n values (?, ?, ?)\n on conflict(id) do update set\n payload = excluded.payload,\n updated_at = excluded.updated_at\n `,\n args: [rule.id, JSON.stringify(rule), rule.updatedAt],\n });\n\n return rule;\n}\n\nasync function listRuns(): Promise {\n await initSchema();\n const rows = await sqlite.execute<{ payload: string }>(\n \"select payload from run_records order by updated_at desc limit 20\",\n );\n\n return rows.rows.map((row) => JSON.parse(row.payload) as RunRecord);\n}\n\nasync function saveRun(run: RunRecord): Promise {\n await initSchema();\n await sqlite.execute({\n sql: `\n insert into run_records (id, payload, updated_at)\n values (?, ?, ?)\n on conflict(id) do update set\n payload = excluded.payload,\n updated_at = excluded.updated_at\n `,\n args: [run.id, JSON.stringify(run), run.finishedAt],\n });\n\n return run;\n}\n\nasync function createTestRun(): Promise {\n const [firstRule] = await listRules();\n const now = new Date().toISOString();\n const ruleName = firstRule?.targetName ?? \"Gastly\";\n const dryRun = firstRule?.dryRun ?? true;\n\n const run: RunRecord = {\n id: crypto.randomUUID(),\n status: dryRun ? \"dry-run\" : \"completed\",\n summary: `${ruleName} ${dryRun ? \"dry-run\" : \"run\"} completed.`,\n dryRun,\n ruleId: firstRule?.id,\n startedAt: now,\n finishedAt: now,\n listingsCollected: 0,\n selectedListingCount: 0,\n plannedSubtotal: 0,\n };\n\n return saveRun(run);\n}\n\nasync function handleRules(request: Request): Promise {\n if (request.method === \"POST\") {\n const payload = await request.json().catch(() => ({}));\n const rule = await saveRule((payload ?? {}) as Record);\n return json({ ok: true, rule });\n }\n\n const rules = await listRules();\n return json({ ok: true, rules });\n}\n\nasync function handleRuns(): Promise {\n const runs = await listRuns();\n return json({ ok: true, runs });\n}\n\nasync function handleTestRun(): Promise {\n const run = await createTestRun();\n return json({\n ok: true,\n mode: \"manual\",\n dryRun: run.dryRun,\n triggeredAt: run.startedAt,\n summary: {\n startedAt: run.startedAt,\n finishedAt: run.finishedAt,\n rulesLoaded: run.ruleId ? 1 : 0,\n catalogsResolved: 0,\n registriesVisited: 0,\n listingsCollected: run.listingsCollected,\n listingsPlanned: run.selectedListingCount,\n plannedSubtotal: run.plannedSubtotal,\n selectedListingCount: run.selectedListingCount,\n persisted: true,\n cartTriggered: false,\n emailTriggered: false,\n rules: [],\n },\n });\n}\n\nexport default async function handler(request: Request): Promise {\n const url = new URL(request.url);\n\n if (request.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: jsonHeaders });\n }\n\n if (url.pathname === \"/api/rules\") {\n return handleRules(request);\n }\n\n if (url.pathname === \"/api/runs\") {\n return handleRuns();\n }\n\n if (url.pathname === \"/api/test-run\") {\n return handleTestRun();\n }\n\n if (url.pathname === \"/\") {\n return json({ ok: true, service: \"gastly-backend\" });\n }\n\n return json({ ok: false, error: \"not_found\" }, 404);\n}\n",[57],{"_34":56,"_13":57,"_37":58,"_39":-5,"_40":41,"_42":59,"_44":45,"_46":71,"_17":61,"_49":62,"_51":63,"_52":53,"_54":-5,"_68":72,"_18":73},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":19,"_52":53,"_54":-5,"_68":69,"_18":70},["D",1775634501959],"children",[],[36],["D",1775636912641],[],[57],"84d195ce-3310-11f1-a1d1-42b51c65c3df",["D",1775628146600],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","019c79d0-c930-77af-a02e-be2ab0469c2b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019c79d0-c930-77af-a02e-c12eb9f377e8","tursoName","84d195ce331011f1a1d142b51c65c3df","tursoHostname","84d195ce331011f1a1d142b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789492855745],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_130":126},"org",{"_11":12,"_124":-5,"_125":126,"_83":84,"_127":128,"_129":53},"branch",{"_17":115,"_13":16,"_34":41,"_116":74,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":14,"_123":12},"isOwned",12,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOXZJWmFtbmNhNEJ2TWVmZnVJenRaeFY4b3IifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":74,"_13":14,"_46":169,"_76":-5,"_77":53,"_78":79,"_80":79,"_81":-5,"_82":-5,"_83":84,"_85":-5,"_86":53,"_87":-5,"_88":-5,"_89":48,"_90":91,"_92":93,"_94":95,"_96":170,"_98":-5,"_99":100,"_101":100,"_102":103,"_104":103,"_105":103,"_106":100,"_107":100,"_108":171,"_110":172,"_112":173,"_114":53},[163,164],"files",[163,164],"counts",{"_153":48,"_154":155,"_156":48,"_31":157,"_158":159},[149,150],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":56,"_13":57,"_37":58,"_39":-5,"_40":41,"_42":59,"_44":45,"_46":60,"_17":61,"_49":62,"_51":63,"_52":53,"_54":-5,"_18":152},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":19,"_52":53,"_54":-5,"_18":151},[36],[57],"pulls","branches",1,"forks",{"_160":48,"_162":48},"connections",{"_160":48,"_161":48},"count","unfilledCount","emptyCount",{"_34":56,"_13":57,"_37":58,"_39":-5,"_40":41,"_42":59,"_44":45,"_46":71,"_17":61,"_49":62,"_51":63,"_52":53,"_54":-5,"_68":167,"_18":168},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":19,"_52":53,"_54":-5,"_68":165,"_18":166},[],[36],[],[57],["D",1775628146600],["D",1789492855745],{"_11":12,"_130":126},{"_11":12,"_124":-5,"_125":126,"_83":84,"_127":128,"_129":53},{"_17":115,"_13":16,"_34":41,"_116":74,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":14,"_123":12},"ctx",{"_108":-5,"_146":207,"_208":209,"_210":211,"_212":53,"_213":53,"_214":53,"_215":45,"_216":-5,"_217":-7,"_218":-7,"_219":48,"_220":53,"_221":53,"_222":-5,"_223":53,"_224":53,"_225":53,"_226":-5},"ENV",{"_178":179,"_180":181,"_182":16,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206},"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"]

Code