[{"_1":2,"_184":-5,"_185":-5},"loaderData",{"_3":4,"_96":97},"root",{"_5":6,"_37":38,"_69":70},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20,"_36":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","preferencesChatPanelState","notificationCount",0,"flagDenols","isBusinessOrgMember","isHigherTownieTier","ENV",{"_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,"_65":66,"_67":68},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","3fe650e0bae9a5355a83ddb9051b7952684e33a5","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","API_URL","https://api.val.town","clerkState",{"_71":72},"__internal_clerk_state",{"_73":74,"_75":48,"_76":77,"_78":77,"_79":20,"_80":77,"_81":77,"_82":77,"_83":77,"_84":85,"_94":20,"_95":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",{"_86":20,"_19":20,"_87":77,"_88":89,"_90":77,"_91":48,"_92":20,"_93":77},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_98":99,"_100":101,"_102":103,"_104":105,"_161":162,"_181":182,"_183":-5},"handle","kfcafe","name","gastly","path","main.ts","project",{"_106":107,"_100":101,"_108":109,"_110":-5,"_111":20,"_112":113,"_114":-5,"_115":-5,"_12":116,"_117":-5,"_118":20,"_119":-5,"_120":-5,"_121":33,"_14":122,"_123":124,"_125":126,"_127":128,"_129":-5,"_130":131,"_132":131,"_133":134,"_135":134,"_136":134,"_137":131,"_138":131,"_23":139,"_142":143,"_147":148,"_160":20},"id","84d195ce-3310-11f1-a1d1-42b51c65c3df","createdAt",["D",1775628146600],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","019c79d0-c930-77af-a02e-be2ab0469c2b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019c79d0-c930-77af-a02e-c12eb9f377e8","tursoName","84d195ce331011f1a1d142b51c65c3df","tursoHostname","84d195ce331011f1a1d142b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1775724028437],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_98":99,"_140":141},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOXZJWmFtbmNhNEJ2TWVmZnVJenRaeFY4b3IifQ","org",{"_98":99,"_144":141,"_12":116,"_145":146},"avatar","tier","free","branch",{"_149":150,"_100":46,"_106":151,"_152":107,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":101,"_159":99},"version",12,"84d236c8-3310-11f1-a1d1-42b51c65c3df","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_106":163,"_100":103,"_164":165,"_166":-5,"_167":151,"_168":169,"_170":171,"_108":172,"_149":173,"_174":175,"_176":177,"_178":20,"_179":-5,"_102":180},"edcb59f2-3324-11f1-8c3d-42b51c65c3df","fileId","84d4cb54-3310-11f1-a1d1-42b51c65c3df","parentId","branchId","branchVersion",8,"latest",true,["D",1775636912641],4,"fileType","http","content","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","deleted","label",[103],"permalink","https://www.val.town/x/kfcafe/gastly/code/main.ts","extension","actionData","errors"]