[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_277":278,"_279":280},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",10,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/RequestList.tsx","latestPath","fileId","a792fc66-374d-11f0-b20a-9e149126039e","name","RequestList.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { CapturedRequest } from \"../../shared/types.ts\";\n\ninterface RequestListProps {\n requests: CapturedRequest[];\n}\n\nexport default function RequestList({ requests }: RequestListProps) {\n const [expandedRequest, setExpandedRequest] = useState(null);\n\n if (requests.length === 0) {\n return (\n

📭

\n No requests yet\n

\n Send a request to your URL and it will appear here\n

\n );\n }\n\n const toggleExpanded = (requestId: string) => {\n setExpandedRequest(expandedRequest === requestId ? null : requestId);\n };\n\n const getMethodBadgeClass = (method: string) => {\n const baseClass = \"method-badge \";\n switch (method.toUpperCase()) {\n case 'GET': return baseClass + \"method-get\";\n case 'POST': return baseClass + \"method-post\";\n case 'PUT': return baseClass + \"method-put\";\n case 'DELETE': return baseClass + \"method-delete\";\n case 'PATCH': return baseClass + \"method-patch\";\n case 'OPTIONS': return baseClass + \"method-options\";\n case 'HEAD': return baseClass + \"method-head\";\n default: return baseClass + \"method-options\";\n }\n };\n\n const formatJson = (str: string) => {\n try {\n const parsed = JSON.parse(str);\n return JSON.stringify(parsed, null, 2);\n } catch {\n return str;\n }\n };\n\n const isJsonString = (str: string) => {\n try {\n JSON.parse(str);\n return true;\n } catch {\n return false;\n }\n };\n\n return (\n

\n {requests.map((request) => {\n const isExpanded = expandedRequest === request.id;\n const hasBody = request.body && request.body.trim().length > 0;\n const hasQueryParams = Object.keys(request.query_params).length > 0;\n \n return (\n

toggleExpanded(request.id)}\n >\n

\n \n {request.method}\n \n

\n {new URL(request.url).pathname}\n

\n {new Date(request.timestamp).toLocaleString()}\n

\n {hasBody && (\n \n Body\n \n )}\n {hasQueryParams && (\n \n Query\n \n )}\n \n {isExpanded ? '▼' : '▶'}\n \n

\n\n {isExpanded && (\n

\n {/* URL Details */}\n

URL

\n {request.url}\n

\n\n {/* Query Parameters */}\n {hasQueryParams && (\n

Query Parameters

\n {JSON.stringify(request.query_params, null, 2)}\n

\n )}\n\n {/* Headers */}\n

Headers

\n {JSON.stringify(request.headers, null, 2)}\n

\n\n {/* Body */}\n {hasBody && (\n

Body

\n {isJsonString(request.body) \n ? formatJson(request.body)\n : request.body\n }\n

\n )}\n\n {/* Metadata */}\n

Metadata

\n {JSON.stringify({\n timestamp: request.timestamp,\n ip_address: request.ip_address,\n user_agent: request.user_agent\n }, null, 2)}\n

\n )}\n

\n );\n })}\n

\n );\n}","createdAt",["D",1747946711189],"branchVersion","branchId","3bd18b82-374d-11f0-8879-9e149126039e","id","3bd13e2a-374d-11f0-8879-9e149126039e","postPit",["D",1747946530404],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","2d487d52-cbc9-4a61-b392-31d4cf85f198","pinnedFileId","79e3e80c-374d-11f0-bc59-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","0132d666-d9e2-43c0-8d3f-94d10d615f1a","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",49,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nholden","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycE9WWjZnNEJWM1Vxc1l2V09HcFg3UTFxcDgifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":273,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":274,"_79":275,"_81":276,"_83":24},"tree",[168,173,180,182],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182],"counts",{"_158":61,"_159":133,"_160":61,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":156,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":157},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":150,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":151},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":143,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":145},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":135,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_26":138},"5f514f34-374d-11f0-84ce-9e149126039e","README.md","5f514fde-374d-11f0-84ce-9e149126039e","parentId",1,"latest",["D",1747946589959],"# RequestBin Clone\n\nA webhook testing service that captures HTTP requests and displays them in a user-friendly interface.\n\n## Features\n\n- Generate unique URLs for capturing webhook events\n- Persist all incoming requests with full details (headers, body, method, etc.)\n- Real-time UI for viewing captured requests\n- Support for all HTTP methods\n- JSON formatting and syntax highlighting\n- Request timestamps and metadata\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main React app\n│ │ ├── BinView.tsx # Individual bin viewer\n│ │ └── RequestList.tsx # Request list component\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Usage\n\n1. Visit the homepage to create a new request bin\n2. Copy the generated URL and use it as a webhook endpoint\n3. Send HTTP requests to the URL\n4. View captured requests in real-time on the bin page\n\n## API Endpoints\n\n- `GET /` - Homepage\n- `POST /api/bins` - Create a new bin\n- `GET /api/bins/:binId` - Get bin details and requests\n- `ALL /bin/:binId` - Capture webhook requests\n- `GET /bin/:binId/view` - View bin in UI","label",[130],"61ff4484-374d-11f0-90a3-9e149126039e","shared","93d389b9-55b6-4996-8f7d-a4df73827516",2,["D",1747946594452],"directory",[140],"7f7e8f9c-374d-11f0-97ab-9e149126039e","frontend","05e84ba7-8918-4048-8fbe-958570b2521f",6,["D",1747946643942],[147],"6626daf4-374d-11f0-a6e2-9e149126039e","backend","e910d39d-3b1e-4e7e-89fd-53fcd1d35e91",3,["D",1747946601426],[153],"pulls","branches","forks","envVars",{"_165":61,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":270,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_184":271,"_26":272},{"_42":266,"_31":258,"_29":252,"_132":154,"_40":41,"_39":155,"_134":57,"_37":267,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_184":268,"_26":269},{"_42":259,"_31":260,"_29":261,"_132":252,"_40":41,"_39":155,"_134":57,"_37":262,"_13":61,"_33":34,"_35":263,"_23":24,"_137":-5,"_184":264,"_26":265},{"_42":249,"_31":250,"_29":251,"_132":252,"_40":41,"_39":253,"_134":57,"_37":254,"_13":61,"_33":34,"_35":255,"_23":24,"_137":-5,"_184":256,"_26":257},{"_42":241,"_31":242,"_29":55,"_132":154,"_40":41,"_39":243,"_134":24,"_37":244,"_13":61,"_33":34,"_35":245,"_23":24,"_137":246,"_184":247,"_26":248},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":238,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_184":239,"_26":240},{"_42":234,"_31":217,"_29":213,"_132":148,"_40":41,"_39":229,"_134":57,"_37":235,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_184":236,"_26":237},{"_42":226,"_31":227,"_29":228,"_132":213,"_40":41,"_39":229,"_134":24,"_37":230,"_13":61,"_33":34,"_35":231,"_23":24,"_137":-5,"_184":232,"_26":233},{"_42":218,"_31":219,"_29":220,"_132":213,"_40":41,"_39":221,"_134":24,"_37":222,"_13":61,"_33":34,"_35":223,"_23":24,"_137":-5,"_184":224,"_26":225},{"_42":212,"_31":32,"_29":30,"_132":213,"_40":41,"_39":14,"_134":24,"_37":214,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_184":215,"_26":216},{"_42":205,"_31":206,"_29":207,"_132":148,"_40":41,"_39":149,"_134":24,"_37":208,"_13":61,"_33":20,"_35":209,"_23":24,"_137":-5,"_184":210,"_26":211},{"_42":197,"_31":198,"_29":199,"_132":148,"_40":41,"_39":200,"_134":57,"_37":201,"_13":61,"_33":34,"_35":202,"_23":24,"_137":-5,"_184":203,"_26":204},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":194,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_184":195,"_26":196},{"_42":187,"_31":188,"_29":189,"_132":141,"_40":41,"_39":142,"_134":57,"_37":190,"_13":61,"_33":34,"_35":191,"_23":24,"_137":-5,"_184":192,"_26":193},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":183,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_184":185,"_26":186},["D",1747946589959],"children",[],[130],"61ff1b80-374d-11f0-90a3-9e149126039e","types.ts","61ff1c48-374d-11f0-90a3-9e149126039e",["D",1747946594452],"export interface RequestBin {\n id: string;\n created_at: string;\n last_request_at?: string;\n request_count: number;\n}\n\nexport interface CapturedRequest {\n id: string;\n bin_id: string;\n method: string;\n url: string;\n headers: Record;\n body: string;\n query_params: Record;\n timestamp: string;\n ip_address?: string;\n user_agent?: string;\n}\n\nexport interface BinWithRequests {\n bin: RequestBin;\n requests: CapturedRequest[];\n}",[],[140,188],["D",1747946594452],[181],[140],"8264f98a-374d-11f0-944d-9e149126039e","index.tsx","8264fa5c-374d-11f0-944d-9e149126039e",7,["D",1747946648809],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[147,198],"7f7e6c06-374d-11f0-97ab-9e149126039e","index.html","7f7e6cd8-374d-11f0-97ab-9e149126039e",["D",1747946643942],"\n\n\n \n \n RequestBin Clone\n \n \n \n\n\n

\n \n\n",[],[147,206],"a792fba8-374d-11f0-b20a-9e149126039e","b28a3444-b9fd-4dce-b200-fe861d10c0c5",["D",1747946711189],[],[147,217,32],"components","9a6a5bb0-374d-11f0-84b4-9e149126039e","BinView.tsx","9a6a5c78-374d-11f0-84b4-9e149126039e",9,["D",1747946689110],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport RequestList from \"./RequestList.tsx\";\nimport type { BinWithRequests } from \"../../shared/types.ts\";\n\ninterface BinViewProps {\n binId: string;\n onGoHome: () => void;\n}\n\nexport default function BinView({ binId, onGoHome }: BinViewProps) {\n const [binData, setBinData] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [copied, setCopied] = useState(false);\n\n const binUrl = `${window.location.origin}/bin/${binId}`;\n\n const fetchBinData = async () => {\n try {\n const response = await fetch(`/api/bins/${binId}`);\n if (!response.ok) {\n throw new Error('Bin not found');\n }\n const data = await response.json();\n setBinData(data);\n setError(null);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'Failed to load bin');\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchBinData();\n \n // Poll for new requests every 3 seconds\n const interval = setInterval(fetchBinData, 3000);\n return () => clearInterval(interval);\n }, [binId]);\n\n const copyToClipboard = async () => {\n try {\n await navigator.clipboard.writeText(binUrl);\n setCopied(true);\n setTimeout(() => setCopied(false), 2000);\n } catch (err) {\n // Fallback for older browsers\n const textArea = document.createElement('textarea');\n textArea.value = binUrl;\n document.body.appendChild(textArea);\n textArea.select();\n document.execCommand('copy');\n document.body.removeChild(textArea);\n setCopied(true);\n setTimeout(() => setCopied(false), 2000);\n }\n };\n\n if (loading) {\n return (\n

Loading bin...

\n );\n }\n\n if (error) {\n return (\n

❌

Bin Not Found

{error}

\n \n Create New Bin\n \n

\n );\n }\n\n if (!binData) return null;\n\n return (\n

\n {/* Header */}\n

\n \n ← Back to Home\n \n

\n Request Bin: {binId}\n

\n Created: {new Date(binData.bin.created_at).toLocaleString()}\n

\n Requests: {binData.bin.request_count}\n

\n\n {/* URL Section */}\n

\n Your Request URL\n

\n {binUrl}\n

\n \n {copied ? 'Copied!' : 'Copy'}\n \n

\n Send HTTP requests to this URL and they'll appear below in real-time.\n

\n\n {/* Requests Section */}\n

\n Captured Requests ({binData.requests.length})\n

\n \n 🔄 Refresh\n \n

\n \n \n

\n );\n}",[],[147,217,219],"8ca4e0d6-374d-11f0-91d8-9e149126039e","App.tsx","8ca4e18a-374d-11f0-91d8-9e149126039e",8,["D",1747946666001],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport BinView from \"./BinView.tsx\";\n\ndeclare global {\n interface Window {\n __BIN_ID__?: string;\n }\n}\n\nexport default function App() {\n const [currentBinId, setCurrentBinId] = useState(null);\n const [isCreating, setIsCreating] = useState(false);\n\n useEffect(() => {\n // Check if we're viewing a specific bin\n if (window.__BIN_ID__) {\n setCurrentBinId(window.__BIN_ID__);\n }\n }, []);\n\n const createNewBin = async () => {\n setIsCreating(true);\n try {\n const response = await fetch('/api/bins', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n });\n \n const data = await response.json();\n if (data.success) {\n setCurrentBinId(data.bin.id);\n // Update URL without page reload\n window.history.pushState({}, '', `/bin/${data.bin.id}/view`);\n }\n } catch (error) {\n console.error('Failed to create bin:', error);\n } finally {\n setIsCreating(false);\n }\n };\n\n const goHome = () => {\n setCurrentBinId(null);\n window.history.pushState({}, '', '/');\n };\n\n if (currentBinId) {\n return ;\n }\n\n return (\n

\n 🪣 RequestBin Clone\n

\n Capture and inspect HTTP requests sent to your unique URL\n

\n \n

\n Create a Request Bin\n

\n Get a unique URL to capture webhook requests, form submissions, and API calls.\n Perfect for testing and debugging HTTP integrations.\n

\n \n \n {isCreating ? 'Creating...' : 'Create Request Bin'}\n \n

\n\n

🎯

\n Capture Requests\n

\n Send HTTP requests to your unique URL and see them appear in real-time\n

\n \n

🔍

\n Inspect Details\n

\n View headers, body, query parameters, and metadata for each request\n

\n \n

⚡

\n Real-time Updates\n

\n See new requests as they arrive without refreshing the page\n

\n );\n}",[],[147,217,227],"8ca5020a-374d-11f0-91d8-9e149126039e",["D",1747946666001],[175,176,177],[147,217],["D",1747946643942],[174,178,179],[147],"79e3e758-374d-11f0-bc59-9e149126039e","index.ts",5,["D",1747946634541],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { createBin, getBinWithRequests, saveRequest } from \"./database/queries.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Run migrations on startup\nawait runMigrations();\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Homepage\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Create a new bin\napp.post(\"/api/bins\", async c => {\n const binId = generateBinId();\n const bin = await createBin(binId);\n \n return c.json({\n success: true,\n bin,\n url: `${getBaseUrl(c)}/bin/${binId}`\n });\n});\n\n// Get bin details and requests\napp.get(\"/api/bins/:binId\", async c => {\n const binId = c.req.param(\"binId\");\n const binWithRequests = await getBinWithRequests(binId);\n \n if (!binWithRequests) {\n return c.json({ error: \"Bin not found\" }, 404);\n }\n \n return c.json(binWithRequests);\n});\n\n// View bin in UI\napp.get(\"/bin/:binId/view\", async c => {\n const binId = c.req.param(\"binId\");\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject bin ID for the frontend\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// Capture webhook requests (all methods)\napp.all(\"/bin/:binId\", async c => {\n const binId = c.req.param(\"binId\");\n \n // Check if bin exists\n const binWithRequests = await getBinWithRequests(binId);\n if (!binWithRequests) {\n return c.json({ error: \"Bin not found\" }, 404);\n }\n \n // Extract request details\n const method = c.req.method;\n const url = c.req.url;\n const headers: Record = {};\n \n // Convert headers to plain object\n c.req.header().forEach((value, key) => {\n headers[key] = value;\n });\n \n // Get body\n let body = \"\";\n try {\n body = await c.req.text();\n } catch (e) {\n // Body might be empty or invalid\n }\n \n // Extract query parameters\n const urlObj = new URL(url);\n const query_params: Record = {};\n urlObj.searchParams.forEach((value, key) => {\n query_params[key] = value;\n });\n \n // Get client info\n const ip_address = c.req.header(\"x-forwarded-for\") || c.req.header(\"x-real-ip\") || \"unknown\";\n const user_agent = c.req.header(\"user-agent\") || \"\";\n \n // Save the request\n await saveRequest({\n bin_id: binId,\n method,\n url,\n headers,\n body,\n query_params,\n ip_address,\n user_agent\n });\n \n return c.json({ \n success: true, \n message: \"Request captured successfully\",\n timestamp: new Date().toISOString()\n });\n});\n\nfunction generateBinId(): string {\n const chars = 'abcdefghijklmnopqrstuvwxyz0123456789';\n let result = '';\n for (let i = 0; i < 8; i++) {\n result += chars.charAt(Math.floor(Math.random() * chars.length));\n }\n return result;\n}\n\nfunction getBaseUrl(c: any): string {\n const url = new URL(c.req.url);\n return `${url.protocol}//${url.host}`;\n}\n\nexport default app.fetch;","postpit",[],[153,242],"6e5ba8c6-374d-11f0-b20a-9e149126039e","queries.ts","6e5ba970-374d-11f0-b20a-9e149126039e","cb0c684f-bdca-44d7-bb8b-6086c301dcc5",4,["D",1747946615196],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { BINS_TABLE, REQUESTS_TABLE } from \"./migrations.ts\";\nimport type { RequestBin, CapturedRequest, BinWithRequests } from \"../../shared/types.ts\";\n\nexport async function createBin(id: string): Promise {\n const now = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${BINS_TABLE} (id, created_at, request_count) VALUES (?, ?, ?)`,\n [id, now, 0]\n );\n\n return {\n id,\n created_at: now,\n request_count: 0\n };\n}\n\nexport async function getBin(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${BINS_TABLE} WHERE id = ?`,\n [id]\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n return {\n id: row[0] as string,\n created_at: row[1] as string,\n last_request_at: row[2] as string || undefined,\n request_count: row[3] as number\n };\n}\n\nexport async function saveRequest(request: Omit): Promise {\n const id = crypto.randomUUID();\n const timestamp = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${REQUESTS_TABLE} (\n id, bin_id, method, url, headers, body, query_params, timestamp, ip_address, user_agent\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id,\n request.bin_id,\n request.method,\n request.url,\n JSON.stringify(request.headers),\n request.body,\n JSON.stringify(request.query_params),\n timestamp,\n request.ip_address,\n request.user_agent\n ]\n );\n\n // Update bin's last_request_at and increment request_count\n await sqlite.execute(\n `UPDATE ${BINS_TABLE} \n SET last_request_at = ?, request_count = request_count + 1 \n WHERE id = ?`,\n [timestamp, request.bin_id]\n );\n\n return {\n id,\n ...request,\n timestamp\n };\n}\n\nexport async function getBinRequests(binId: string, limit: number = 50): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${REQUESTS_TABLE} \n WHERE bin_id = ? \n ORDER BY timestamp DESC \n LIMIT ?`,\n [binId, limit]\n );\n\n return result.rows.map(row => ({\n id: row[0] as string,\n bin_id: row[1] as string,\n method: row[2] as string,\n url: row[3] as string,\n headers: JSON.parse(row[4] as string),\n body: row[5] as string,\n query_params: JSON.parse(row[6] as string || '{}'),\n timestamp: row[7] as string,\n ip_address: row[8] as string,\n user_agent: row[9] as string\n }));\n}\n\nexport async function getBinWithRequests(binId: string): Promise {\n const bin = await getBin(binId);\n if (!bin) {\n return null;\n }\n\n const requests = await getBinRequests(binId);\n \n return {\n bin,\n requests\n };\n}",[],[153,258,250],"database","6626baec-374d-11f0-a6e2-9e149126039e","migrations.ts","6626bbaa-374d-11f0-a6e2-9e149126039e",["D",1747946601426],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst BINS_TABLE = 'request_bins_v1';\nconst REQUESTS_TABLE = 'captured_requests_v1';\n\nexport async function runMigrations() {\n // Create bins table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${BINS_TABLE} (\n id TEXT PRIMARY KEY,\n created_at TEXT NOT NULL,\n last_request_at TEXT,\n request_count INTEGER DEFAULT 0\n )`);\n\n // Create requests table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${REQUESTS_TABLE} (\n id TEXT PRIMARY KEY,\n bin_id TEXT NOT NULL,\n method TEXT NOT NULL,\n url TEXT NOT NULL,\n headers TEXT NOT NULL,\n body TEXT,\n query_params TEXT,\n timestamp TEXT NOT NULL,\n ip_address TEXT,\n user_agent TEXT,\n FOREIGN KEY (bin_id) REFERENCES ${BINS_TABLE} (id)\n )`);\n\n // Create index for faster queries\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_requests_bin_id ON ${REQUESTS_TABLE} (bin_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_requests_timestamp ON ${REQUESTS_TABLE} (timestamp DESC)`);\n}\n\nexport { BINS_TABLE, REQUESTS_TABLE };",[],[153,258,260],"6626dcb6-374d-11f0-a6e2-9e149126039e",["D",1747946601426],[170,171],[153,258],["D",1747946601426],[169,172],[153],["D",1747946530404],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":310,"_311":312,"_313":314,"_315":24,"_316":24,"_317":24,"_318":57,"_319":-5,"_320":-7,"_321":-7,"_322":61,"_323":24,"_324":24,"_325":-5,"_326":24,"_327":24,"_328":24,"_329":-5},"ENV",{"_281":282,"_283":284,"_285":85,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v10