[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_240":241,"_242":243},"routes/_app.x.$handle.$name",{"_101":100,"_32":45,"_110":91,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":59,"_128":-5,"_129":-5,"_130":131},"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":53,"_54":55,"_18":56,"_57":31,"_58":59,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",113,"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","web.http.tsx","latestPath","fileId","17b6c84e-010a-11f0-81d5-569c3dd06744","name","fileType","http","content","/** @jsxImportSource npm:react */\n/** @jsxImportSourceTypes npm:@types/react */\nimport { renderToString } from \"npm:react-dom/server\";\nimport { EnhancedSearchResult, searchFileContentWithContext } from \"./db.ts\";\n\n// Helper to highlight the search terms in the code\nfunction highlightText(text: string, searchTerm: string): JSX.Element {\n if (!searchTerm) return <>{text};\n\n const regex = new RegExp(\n `(${searchTerm.replace(/[.*+?^${}()|[\\]\\\\]/g, \"\\\\$&\")})`,\n \"gi\",\n );\n const parts = text.split(regex);\n\n return (\n <>\n {parts.map((part, i) =>\n regex.test(part)\n ? {part}\n : {part}\n )}\n \n );\n}\n\n// CodeBlock component for displaying code with line numbers\nfunction CodeBlock(\n { matchedLines, searchTerm }: {\n matchedLines: EnhancedSearchResult[\"matchedLines\"];\n searchTerm: string;\n },\n) {\n return (\n

\n      {matchedLines.map((line, index) => (\n        line.lineNumber === -1 ? (\n          ...
\n        ) : (\n          \n            {line.lineNumber}\n            \n              {highlightText(line.lineContent, searchTerm)}\n            \n          
\n        )\n      ))}\n

\n );\n}\n\n// Format date to relative time\nfunction formatRelativeTime(dateString: string): string {\n const date = new Date(dateString);\n const now = new Date();\n const secondsAgo = Math.floor((now.getTime() - date.getTime()) / 1000);\n\n // Define time periods in seconds\n const minute = 60;\n const hour = minute * 60;\n const day = hour * 24;\n const week = day * 7;\n const month = day * 30;\n const year = day * 365;\n\n if (secondsAgo < minute) {\n return \"just now\";\n } else if (secondsAgo < hour) {\n const minutes = Math.floor(secondsAgo / minute);\n return `${minutes} ${minutes === 1 ? \"min\" : \"mins\"} ago`;\n } else if (secondsAgo < day) {\n const hours = Math.floor(secondsAgo / hour);\n return `${hours} ${hours === 1 ? \"hour\" : \"hours\"} ago`;\n } else if (secondsAgo < week) {\n const days = Math.floor(secondsAgo / day);\n return `${days} ${days === 1 ? \"day\" : \"days\"} ago`;\n } else if (secondsAgo < month) {\n const weeks = Math.floor(secondsAgo / week);\n return `${weeks} ${weeks === 1 ? \"week\" : \"weeks\"} ago`;\n } else if (secondsAgo < year) {\n const months = Math.floor(secondsAgo / month);\n return `${months} ${months === 1 ? \"month\" : \"months\"} ago`;\n } else {\n const years = Math.floor(secondsAgo / year);\n return `${years} ${years === 1 ? \"year\" : \"years\"} ago`;\n }\n}\n\n// Format date for tooltip (full date)\nfunction formatFullDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n}\n\n// Search result component\nfunction SearchResult(\n { result, searchTerm }: { result: EnhancedSearchResult; searchTerm: string },\n) {\n const relativeTime = formatRelativeTime(result.updated_at);\n const fullDate = formatFullDate(result.updated_at);\n\n return (\n

\n \n {result.project_name}\n \n \n {result.name}\n \n \n {result.totalMatches} {result.totalMatches === 1 ? \"match\" : \"matches\"}\n \n

\n \n @{result.username}\n \n •\n \n Updated {relativeTime}\n \n

\n \n

\n );\n}\n\n// Pagination component\nfunction Pagination({\n currentPage,\n totalPages,\n searchTerm,\n}: {\n currentPage: number;\n totalPages: number;\n searchTerm: string;\n}) {\n if (totalPages <= 1) return null;\n\n // Create an array of page numbers to display\n const pageNumbers: (number | string)[] = [];\n const maxPagesToShow = 7; // Odd number works best for symmetry\n\n if (totalPages <= maxPagesToShow) {\n // Show all pages if there are fewer than maxPagesToShow\n for (let i = 1; i <= totalPages; i++) {\n pageNumbers.push(i);\n }\n } else {\n // Always include first page\n pageNumbers.push(1);\n\n // Calculate range around current page\n const leftSide = Math.floor(maxPagesToShow / 2);\n const rightSide = maxPagesToShow - leftSide - 1;\n\n // Determine if we need to show ellipsis\n if (currentPage > leftSide + 1) {\n pageNumbers.push(\"...\");\n }\n\n // Determine the range of pages to show around current page\n let rangeStart = Math.max(2, currentPage - leftSide);\n let rangeEnd = Math.min(totalPages - 1, currentPage + rightSide);\n\n // Adjust range if at the beginning\n if (currentPage - leftSide < 2) {\n rangeEnd = Math.min(totalPages - 1, maxPagesToShow - 1);\n }\n\n // Adjust range if at the end\n if (currentPage + rightSide > totalPages - 1) {\n rangeStart = Math.max(2, totalPages - maxPagesToShow + 2);\n }\n\n // Add the range of pages\n for (let i = rangeStart; i <= rangeEnd; i++) {\n pageNumbers.push(i);\n }\n\n // Add ellipsis if needed\n if (rangeEnd < totalPages - 1) {\n pageNumbers.push(\"...\");\n }\n\n // Always include last page if not already included\n if (rangeEnd < totalPages) {\n pageNumbers.push(totalPages);\n }\n }\n\n return (\n

\n {currentPage > 1 && (\n \n « Previous\n \n )}\n\n

\n {pageNumbers.map((page, index) => (\n typeof page === \"number\"\n ? (\n \n {page}\n \n )\n : {page}\n ))}\n

\n\n {currentPage < totalPages && (\n \n Next »\n \n )}\n

\n );\n}\n\n// Main search page component\nfunction SearchPage({\n results,\n searchTerm,\n totalResults,\n currentPage,\n totalPages,\n executionTimeMs,\n}: {\n results: EnhancedSearchResult[];\n searchTerm: string;\n totalResults: number;\n currentPage: number;\n totalPages: number;\n executionTimeMs: number;\n}) {\n return (\n \n \n ValTown Project Code Search\n \n \n \n \n

ValTown Project Code Search

\n \n \n \n

\n\n

\n \n \n \n\n {searchTerm && (\n

\n {totalResults > 0\n ? (\n

\n Found {totalResults} {totalResults === 1 ? \"result\" : \"results\"} for \"{searchTerm}\"\n \n ({executionTimeMs}ms)\n \n

\n {totalResults > results.length && (\n

\n Showing results {(currentPage - 1) * 10 + 1}-{Math.min(\n currentPage * 10,\n totalResults,\n )} of {totalResults}\n

\n )}\n

\n )\n : (\n

\n No results found for \"{searchTerm}\"{\" \"}\n \n ({executionTimeMs}ms)\n \n

\n )}\n

\n )}\n\n

\n {results.length > 0\n ? (\n <>\n {results.map((result, index) => (\n \n ))}\n\n \n \n )\n : searchTerm\n ? (\n

No matching code found. Try a different search term.

\n )\n : null}\n

\n      {matchedLines.map((line, index) => (\n        line.lineNumber === -1 ? (\n          ...
\n        ) : (\n          \n            {line.lineNumber}\n            \n              {highlightText(line.lineContent, searchTerm)}\n            \n          
\n        )\n      ))}\n

\n \n {result.project_name}\n \n \n {result.name}\n \n \n {result.totalMatches} {result.totalMatches === 1 ? \"match\" : \"matches\"}\n \n

\n \n @{result.username}\n \n •\n \n Updated {relativeTime}\n \n

\n \n

\n {currentPage > 1 && (\n \n « Previous\n \n )}\n\n

\n {pageNumbers.map((page, index) => (\n typeof page === \"number\"\n ? (\n \n {page}\n \n )\n : {page}\n ))}\n

\n\n {currentPage < totalPages && (\n \n Next »\n \n )}\n

ValTown Project Code Search

\n \n \n \n

\n\n

\n \n \n \n\n {searchTerm && (\n

\n {totalResults > 0\n ? (\n

\n Found {totalResults} {totalResults === 1 ? \"result\" : \"results\"} for \"{searchTerm}\"\n \n ({executionTimeMs}ms)\n \n

\n {totalResults > results.length && (\n

\n Showing results {(currentPage - 1) * 10 + 1}-{Math.min(\n currentPage * 10,\n totalResults,\n )} of {totalResults}\n

\n )}\n

\n )\n : (\n

\n No results found for \"{searchTerm}\"{\" \"}\n \n ({executionTimeMs}ms)\n \n

\n )}\n

\n )}\n\n

\n {results.length > 0\n ? (\n <>\n {results.map((result, index) => (\n \n ))}\n\n \n \n )\n : searchTerm\n ? (\n

No matching code found. Try a different search term.

\n )\n : null}\n

\n \n \n );\n}\n\nasync function handler(req: Request): Promise {\n const url = new URL(req.url);\n const searchTerm = url.searchParams.get(\"q\") || \"\";\n const pageParam = url.searchParams.get(\"page\") || \"1\";\n\n // Ensure page is a valid number\n const page = Math.max(1, parseInt(pageParam, 10) || 1);\n const pageSize = 10; // Results per page\n\n // Perform search if there's a query\n const searchResponse = searchTerm\n ? await searchFileContentWithContext(searchTerm, 2, page, pageSize) // Show 2 lines of context\n : {\n results: [],\n totalResults: 0,\n page: 1,\n pageSize,\n totalPages: 0,\n executionTimeMs: 0,\n };\n\n return new Response(\n renderToString(\n ,\n ),\n {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n },\n );\n}\n\nexport default handler;","createdAt",["D",1744141032051],"branchVersion","branchId","cdebffc6-0105-11f0-90bd-569c3dd06744","id","cdebb08e-0105-11f0-90bd-569c3dd06744","vtProjectSearch",["D",1741978488970],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Val Town Code Search","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/f2d8682d-afb1-4430-4fb3-46c2eb807000/square512?exp=1789577999&sig=bda3813e55607c40419d4d8d3256e8e22e83e400b06cfe7590ec078f8fc37a3f","418c1e39-eb48-4f2f-8c97-122ece94631c","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion",122,"likeCount",7,"orgId","ba7bb5fb-1abb-4ffb-8f3d-7c244782e5f7","tursoName","cdebb08e010511f090bd569c3dd06744","tursoHostname","cdebb08e010511f090bd569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789534231467],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":-5,"_106":107,"_108":59},"branch",{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"isOwned",228,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","valdottown","handle","displayName","Val Town ","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJyWnQ5cFE0c3pleVRCSEVTWmxzaXJsTUlGciJ9","tier","business","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":235,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":31,"_58":59,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":236,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":237,"_85":238,"_87":239,"_89":25},"tree",[206,207,208,209,210,211,212],"files",[206,207,208,209,210,211,212],"counts",{"_194":195,"_196":197,"_198":197,"_199":200,"_201":202},"contents",[132,133,134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":186,"_32":187,"_30":188,"_140":-5,"_41":42,"_40":189,"_141":25,"_38":190,"_13":191,"_33":153,"_35":192,"_24":25,"_144":-5,"_27":193},{"_43":180,"_32":181,"_30":182,"_140":-5,"_41":42,"_40":64,"_141":25,"_38":183,"_13":152,"_33":20,"_35":184,"_24":25,"_144":-5,"_27":185},{"_43":173,"_32":174,"_30":175,"_140":-5,"_41":42,"_40":176,"_141":25,"_38":177,"_13":152,"_33":20,"_35":178,"_24":25,"_144":-5,"_27":179},{"_43":164,"_32":165,"_30":166,"_140":-5,"_41":42,"_40":167,"_141":25,"_38":168,"_13":169,"_33":170,"_35":171,"_24":25,"_144":-5,"_27":172},{"_43":156,"_32":157,"_30":158,"_140":-5,"_41":42,"_40":159,"_141":25,"_38":160,"_13":161,"_33":153,"_35":162,"_24":25,"_144":-5,"_27":163},{"_43":147,"_32":148,"_30":149,"_140":-5,"_41":42,"_40":150,"_141":25,"_38":151,"_13":152,"_33":153,"_35":154,"_24":25,"_144":-5,"_27":155},{"_43":139,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_141":25,"_38":142,"_13":143,"_33":34,"_35":37,"_24":25,"_144":145,"_27":146},"de0ca31a-14b0-11f0-a6a6-569c3dd06744","parentId","latest",["D",1744141032051],28,"label","codesearch",[28],"eb546a0a-108a-11f0-ac3b-569c3dd06744","test","e680ff02-108a-11f0-a7e2-569c3dd06744",111,["D",1743684928807],1,"script","console.log(import.meta.url);",[148],"6844f4f6-0110-11f0-bf3f-569c3dd06744","search.ts","d6691026-010a-11f0-85fd-569c3dd06744",96,["D",1741983042887],4,"import { getAllFiles } from \"./db.ts\";\n\nconst files = await getAllFiles();\n\nconsole.log(files);\n",[157],"32ce518e-1090-11f0-ad5a-569c3dd06744","import.ts","0e6ad670-0107-11f0-8303-569c3dd06744",112,["D",1743687196210],51,"interval","import ValTown from \"npm:@valtown/sdk\";\nimport { upsertFile, upsertProject } from \"./db.ts\";\nconst vt = new ValTown();\n\nlet offset = 0;\nconst limit = 100; // Standard pagination limit\nlet hasMoreProjects = true;\n\nwhile (hasMoreProjects) {\n const projects = await vt.projects.list({ offset, limit });\n\n if (projects.data.length === 0) {\n hasMoreProjects = false;\n continue;\n }\n\n for (const project of projects.data) {\n console.log(project.name);\n const branches = await vt.projects.branches.list(project.id, {});\n await upsertProject({\n id: project.id,\n url: project.links.html,\n name: project.name,\n username: project.author.username || \"\",\n updated_at: branches.data.find((branch) => branch.name === \"main\")?.updatedAt || new Date().toISOString(),\n });\n for await (\n const file of vt.projects.files.retrieve(project.id, { path: \"\", limit: 10, offset: 0, recursive: true })\n ) {\n if (file.type === \"directory\") {\n continue;\n }\n const content = await vt.projects.files.getContent(\n project.id,\n { path: file.path },\n );\n await upsertFile({\n id: file.id,\n url: file.links.html,\n project_id: project.id,\n name: file.name,\n content: await content.text(),\n updated_at: file.updatedAt,\n });\n }\n }\n\n offset += projects.data.length;\n}\n\nexport default {};",[165],"09910e4a-0110-11f0-9619-569c3dd06744","deno.lock","63819a86-0107-11f0-a5d6-569c3dd06744",90,["D",1741982884002],"{\n \"version\": \"4\",\n \"specifiers\": {\n \"npm:@libsql/client@*\": \"0.14.0\",\n \"npm:@types/node@*\": \"22.12.0\",\n \"npm:@types/react@*\": \"19.0.10\",\n \"npm:@valtown/sdk@*\": \"0.36.0\",\n \"npm:react-dom@*\": \"19.0.0_react@19.0.0\",\n \"npm:react@*\": \"19.0.0\",\n \"npm:zod@*\": \"3.24.2\"\n },\n \"npm\": {\n \"@libsql/client@0.14.0\": {\n \"integrity\": \"sha512-/9HEKfn6fwXB5aTEEoMeFh4CtG0ZzbncBb1e++OCdVpgKZ/xyMsIVYXm0w7Pv4RUel803vE6LwniB3PqD72R0Q==\",\n \"dependencies\": [\n \"@libsql/core\",\n \"@libsql/hrana-client\",\n \"js-base64\",\n \"libsql\",\n \"promise-limit\"\n ]\n },\n \"@libsql/core@0.14.0\": {\n \"integrity\": \"sha512-nhbuXf7GP3PSZgdCY2Ecj8vz187ptHlZQ0VRc751oB2C1W8jQUXKKklvt7t1LJiUTQBVJuadF628eUk+3cRi4Q==\",\n \"dependencies\": [\n \"js-base64\"\n ]\n },\n \"@libsql/darwin-arm64@0.4.7\": {\n \"integrity\": \"sha512-yOL742IfWUlUevnI5PdnIT4fryY3LYTdLm56bnY0wXBw7dhFcnjuA7jrH3oSVz2mjZTHujxoITgAE7V6Z+eAbg==\"\n },\n \"@libsql/darwin-x64@0.4.7\": {\n \"integrity\": \"sha512-ezc7V75+eoyyH07BO9tIyJdqXXcRfZMbKcLCeF8+qWK5nP8wWuMcfOVywecsXGRbT99zc5eNra4NEx6z5PkSsA==\"\n },\n \"@libsql/hrana-client@0.7.0\": {\n \"integrity\": \"sha512-OF8fFQSkbL7vJY9rfuegK1R7sPgQ6kFMkDamiEccNUvieQ+3urzfDFI616oPl8V7T9zRmnTkSjMOImYCAVRVuw==\",\n \"dependencies\": [\n \"@libsql/isomorphic-fetch\",\n \"@libsql/isomorphic-ws\",\n \"js-base64\",\n \"node-fetch@3.3.2\"\n ]\n },\n \"@libsql/isomorphic-fetch@0.3.1\": {\n \"integrity\": \"sha512-6kK3SUK5Uu56zPq/Las620n5aS9xJq+jMBcNSOmjhNf/MUvdyji4vrMTqD7ptY7/4/CAVEAYDeotUz60LNQHtw==\"\n },\n \"@libsql/isomorphic-ws@0.1.5\": {\n \"integrity\": \"sha512-DtLWIH29onUYR00i0GlQ3UdcTRC6EP4u9w/h9LxpUZJWRMARk6dQwZ6Jkd+QdwVpuAOrdxt18v0K2uIYR3fwFg==\",\n \"dependencies\": [\n \"@types/ws\",\n \"ws\"\n ]\n },\n \"@libsql/linux-arm64-gnu@0.4.7\": {\n \"integrity\": \"sha512-WlX2VYB5diM4kFfNaYcyhw5y+UJAI3xcMkEUJZPtRDEIu85SsSFrQ+gvoKfcVh76B//ztSeEX2wl9yrjF7BBCA==\"\n },\n \"@libsql/linux-arm64-musl@0.4.7\": {\n \"integrity\": \"sha512-6kK9xAArVRlTCpWeqnNMCoXW1pe7WITI378n4NpvU5EJ0Ok3aNTIC2nRPRjhro90QcnmLL1jPcrVwO4WD1U0xw==\"\n },\n \"@libsql/linux-x64-gnu@0.4.7\": {\n \"integrity\": \"sha512-CMnNRCmlWQqqzlTw6NeaZXzLWI8bydaXDke63JTUCvu8R+fj/ENsLrVBtPDlxQ0wGsYdXGlrUCH8Qi9gJep0yQ==\"\n },\n \"@libsql/linux-x64-musl@0.4.7\": {\n \"integrity\": \"sha512-nI6tpS1t6WzGAt1Kx1n1HsvtBbZ+jHn0m7ogNNT6pQHZQj7AFFTIMeDQw/i/Nt5H38np1GVRNsFe99eSIMs9XA==\"\n },\n \"@libsql/win32-x64-msvc@0.4.7\": {\n \"integrity\": \"sha512-7pJzOWzPm6oJUxml+PCDRzYQ4A1hTMHAciTAHfFK4fkbDZX33nWPVG7Y3vqdKtslcwAzwmrNDc6sXy2nwWnbiw==\"\n },\n \"@neon-rs/load@0.0.4\": {\n \"integrity\": \"sha512-kTPhdZyTQxB+2wpiRcFWrDcejc4JI6tkPuS7UZCG4l6Zvc5kU/gGQ/ozvHTh1XR5tS+UlfAfGuPajjzQjCiHCw==\"\n },\n \"@types/node-fetch@2.6.12\": {\n \"integrity\": \"sha512-8nneRWKCg3rMtF69nLQJnOYUcbafYeFSjqkw3jCRLsqkWFlHaoQrr5mXmofFGOx3DKn7UfmBMyov8ySvLRVldA==\",\n \"dependencies\": [\n \"@types/node@22.12.0\",\n \"form-data\"\n ]\n },\n \"@types/node@18.19.80\": {\n \"integrity\": \"sha512-kEWeMwMeIvxYkeg1gTc01awpwLbfMRZXdIhwRcakd/KlK53jmRC26LqcbIt7fnAQTu5GzlnWmzA3H6+l1u6xxQ==\",\n \"dependencies\": [\n \"undici-types@5.26.5\"\n ]\n },\n \"@types/node@22.12.0\": {\n \"integrity\": \"sha512-Fll2FZ1riMjNmlmJOdAyY5pUbkftXslB5DgEzlIuNaiWhXd00FhWxVC/r4yV/4wBb9JfImTu+jiSvXTkJ7F/gA==\",\n \"dependencies\": [\n \"undici-types@6.20.0\"\n ]\n },\n \"@types/react@19.0.10\": {\n \"integrity\": \"sha512-JuRQ9KXLEjaUNjTWpzuR231Z2WpIwczOkBEIvbHNCzQefFIT0L8IqE6NV6ULLyC1SI/i234JnDoMkfg+RjQj2g==\",\n \"dependencies\": [\n \"csstype\"\n ]\n },\n \"@types/ws@8.18.0\": {\n \"integrity\": \"sha512-8svvI3hMyvN0kKCJMvTJP/x6Y/EoQbepff882wL+Sn5QsXb3etnamgrJq4isrBxSJj5L2AuXcI0+bgkoAXGUJw==\",\n \"dependencies\": [\n \"@types/node@22.12.0\"\n ]\n },\n \"@valtown/sdk@0.36.0\": {\n \"integrity\": \"sha512-u0qq351WEKyndUx9fNWOn1+2vKiNuos/rEkazV79HznSyqsMkCwCPSBTML568exd2iLOVh4obXloD1sDWt9IEQ==\",\n \"dependencies\": [\n \"@types/node@18.19.80\",\n \"@types/node-fetch\",\n \"abort-controller\",\n \"agentkeepalive\",\n \"form-data-encoder\",\n \"formdata-node\",\n \"node-fetch@2.7.0\"\n ]\n },\n \"abort-controller@3.0.0\": {\n \"integrity\": \"sha512-h8lQ8tacZYnR3vNQTgibj+tODHI5/+l06Au2Pcriv/Gmet0eaj4TwWH41sO9wnHDiQsEj19q0drzdWdeAHtweg==\",\n \"dependencies\": [\n \"event-target-shim\"\n ]\n },\n \"agentkeepalive@4.6.0\": {\n \"integrity\": \"sha512-kja8j7PjmncONqaTsB8fQ+wE2mSU2DJ9D4XKoJ5PFWIdRMa6SLSN1ff4mOr4jCbfRSsxR4keIiySJU0N9T5hIQ==\",\n \"dependencies\": [\n \"humanize-ms\"\n ]\n },\n \"asynckit@0.4.0\": {\n \"integrity\": \"sha512-Oei9OH4tRh0YqU3GxhX79dM/mwVgvbZJaSNaRk+bshkj0S5cfHcgYakreBjrHwatXKbz+IoIdYLxrKim2MjW0Q==\"\n },\n \"call-bind-apply-helpers@1.0.2\": {\n \"integrity\": \"sha512-Sp1ablJ0ivDkSzjcaJdxEunN5/XvksFJ2sMBFfq6x0ryhQV/2b/KwFe21cMpmHtPOSij8K99/wSfoEuTObmuMQ==\",\n \"dependencies\": [\n \"es-errors\",\n \"function-bind\"\n ]\n },\n \"combined-stream@1.0.8\": {\n \"integrity\": \"sha512-FQN4MRfuJeHf7cBbBMJFXhKSDq+2kAArBlmRBvcvFE5BB1HZKXtSFASDhdlz9zOYwxh8lDdnvmMOe/+5cdoEdg==\",\n \"dependencies\": [\n \"delayed-stream\"\n ]\n },\n \"csstype@3.1.3\": {\n \"integrity\": \"sha512-M1uQkMl8rQK/szD0LNhtqxIPLpimGm8sOBwU7lLnCpSbTyY3yeU1Vc7l4KT5zT4s/yOxHH5O7tIuuLOCnLADRw==\"\n },\n \"data-uri-to-buffer@4.0.1\": {\n \"integrity\": \"sha512-0R9ikRb668HB7QDxT1vkpuUBtqc53YyAwMwGeUFKRojY/NWKvdZ+9UYtRfGmhqNbRkTSVpMbmyhXipFFv2cb/A==\"\n },\n \"delayed-stream@1.0.0\": {\n \"integrity\": \"sha512-ZySD7Nf91aLB0RxL4KGrKHBXl7Eds1DAmEdcoVawXnLD7SDhpNgtuII2aAkg7a7QS41jxPSZ17p4VdGnMHk3MQ==\"\n },\n \"detect-libc@2.0.2\": {\n \"integrity\": \"sha512-UX6sGumvvqSaXgdKGUsgZWqcUyIXZ/vZTrlRT/iobiKhGL0zL4d3osHj3uqllWJK+i+sixDS/3COVEOFbupFyw==\"\n },\n \"dunder-proto@1.0.1\": {\n \"integrity\": \"sha512-KIN/nDJBQRcXw0MLVhZE9iQHmG68qAVIBg9CqmUYjmQIhgij9U5MFvrqkUL5FbtyyzZuOeOt0zdeRe4UY7ct+A==\",\n \"dependencies\": [\n \"call-bind-apply-helpers\",\n \"es-errors\",\n \"gopd\"\n ]\n },\n \"es-define-property@1.0.1\": {\n \"integrity\": \"sha512-e3nRfgfUZ4rNGL232gUgX06QNyyez04KdjFrF+LTRoOXmrOgFKDg4BCdsjW8EnT69eqdYGmRpJwiPVYNrCaW3g==\"\n },\n \"es-errors@1.3.0\": {\n \"integrity\": \"sha512-Zf5H2Kxt2xjTvbJvP2ZWLEICxA6j+hAmMzIlypy4xcBg1vKVnx89Wy0GbS+kf5cwCVFFzdCFh2XSCFNULS6csw==\"\n },\n \"es-object-atoms@1.1.1\": {\n \"integrity\": \"sha512-FGgH2h8zKNim9ljj7dankFPcICIK9Cp5bm+c2gQSYePhpaG5+esrLODihIorn+Pe6FGJzWhXQotPv73jTaldXA==\",\n \"dependencies\": [\n \"es-errors\"\n ]\n },\n \"es-set-tostringtag@2.1.0\": {\n \"integrity\": \"sha512-j6vWzfrGVfyXxge+O0x5sh6cvxAog0a/4Rdd2K36zCMV5eJ+/+tOAngRO8cODMNWbVRdVlmGZQL2YS3yR8bIUA==\",\n \"dependencies\": [\n \"es-errors\",\n \"get-intrinsic\",\n \"has-tostringtag\",\n \"hasown\"\n ]\n },\n \"event-target-shim@5.0.1\": {\n \"integrity\": \"sha512-i/2XbnSz/uxRCU6+NdVJgKWDTM427+MqYbkQzD321DuCQJUqOuJKIA0IM2+W2xtYHdKOmZ4dR6fExsd4SXL+WQ==\"\n },\n \"fetch-blob@3.2.0\": {\n \"integrity\": \"sha512-7yAQpD2UMJzLi1Dqv7qFYnPbaPx7ZfFK6PiIxQ4PfkGPyNyl2Ugx+a/umUonmKqjhM4DnfbMvdX6otXq83soQQ==\",\n \"dependencies\": [\n \"node-domexception\",\n \"web-streams-polyfill@3.3.3\"\n ]\n },\n \"form-data-encoder@1.7.2\": {\n \"integrity\": \"sha512-qfqtYan3rxrnCk1VYaA4H+Ms9xdpPqvLZa6xmMgFvhO32x7/3J/ExcTd6qpxM0vH2GdMI+poehyBZvqfMTto8A==\"\n },\n \"form-data@4.0.2\": {\n \"integrity\": \"sha512-hGfm/slu0ZabnNt4oaRZ6uREyfCj6P4fT/n6A1rGV+Z0VdGXjfOhVUpkn6qVQONHGIFwmveGXyDs75+nr6FM8w==\",\n \"dependencies\": [\n \"asynckit\",\n \"combined-stream\",\n \"es-set-tostringtag\",\n \"mime-types\"\n ]\n },\n \"formdata-node@4.4.1\": {\n \"integrity\": \"sha512-0iirZp3uVDjVGt9p49aTaqjk84TrglENEDuqfdlZQ1roC9CWlPk6Avf8EEnZNcAqPonwkG35x4n3ww/1THYAeQ==\",\n \"dependencies\": [\n \"node-domexception\",\n \"web-streams-polyfill@4.0.0-beta.3\"\n ]\n },\n \"formdata-polyfill@4.0.10\": {\n \"integrity\": \"sha512-buewHzMvYL29jdeQTVILecSaZKnt/RJWjoZCF5OW60Z67/GmSLBkOFM7qh1PI3zFNtJbaZL5eQu1vLfazOwj4g==\",\n \"dependencies\": [\n \"fetch-blob\"\n ]\n },\n \"function-bind@1.1.2\": {\n \"integrity\": \"sha512-7XHNxH7qX9xG5mIwxkhumTox/MIRNcOgDrxWsMt2pAr23WHp6MrRlN7FBSFpCpr+oVO0F744iUgR82nJMfG2SA==\"\n },\n \"get-intrinsic@1.3.0\": {\n \"integrity\": \"sha512-9fSjSaos/fRIVIp+xSJlE6lfwhES7LNtKaCBIamHsjr2na1BiABJPo0mOjjz8GJDURarmCPGqaiVg5mfjb98CQ==\",\n \"dependencies\": [\n \"call-bind-apply-helpers\",\n \"es-define-property\",\n \"es-errors\",\n \"es-object-atoms\",\n \"function-bind\",\n \"get-proto\",\n \"gopd\",\n \"has-symbols\",\n \"hasown\",\n \"math-intrinsics\"\n ]\n },\n \"get-proto@1.0.1\": {\n \"integrity\": \"sha512-sTSfBjoXBp89JvIKIefqw7U2CCebsc74kiY6awiGogKtoSGbgjYE/G/+l9sF3MWFPNc9IcoOC4ODfKHfxFmp0g==\",\n \"dependencies\": [\n \"dunder-proto\",\n \"es-object-atoms\"\n ]\n },\n \"gopd@1.2.0\": {\n \"integrity\": \"sha512-ZUKRh6/kUFoAiTAtTYPZJ3hw9wNxx+BIBOijnlG9PnrJsCcSjs1wyyD6vJpaYtgnzDrKYRSqf3OO6Rfa93xsRg==\"\n },\n \"has-symbols@1.1.0\": {\n \"integrity\": \"sha512-1cDNdwJ2Jaohmb3sg4OmKaMBwuC48sYni5HUw2DvsC8LjGTLK9h+eb1X6RyuOHe4hT0ULCW68iomhjUoKUqlPQ==\"\n },\n \"has-tostringtag@1.0.2\": {\n \"integrity\": \"sha512-NqADB8VjPFLM2V0VvHUewwwsw0ZWBaIdgo+ieHtK3hasLz4qeCRjYcqfB6AQrBggRKppKF8L52/VqdVsO47Dlw==\",\n \"dependencies\": [\n \"has-symbols\"\n ]\n },\n \"hasown@2.0.2\": {\n \"integrity\": \"sha512-0hJU9SCPvmMzIBdZFqNPXWa6dqh7WdH0cII9y+CyS8rG3nL48Bclra9HmKhVVUHyPWNH5Y7xDwAB7bfgSjkUMQ==\",\n \"dependencies\": [\n \"function-bind\"\n ]\n },\n \"humanize-ms@1.2.1\": {\n \"integrity\": \"sha512-Fl70vYtsAFb/C06PTS9dZBo7ihau+Tu/DNCk/OyHhea07S+aeMWpFFkUaXRa8fI+ScZbEI8dfSxwY7gxZ9SAVQ==\",\n \"dependencies\": [\n \"ms\"\n ]\n },\n \"js-base64@3.7.7\": {\n \"integrity\": \"sha512-7rCnleh0z2CkXhH67J8K1Ytz0b2Y+yxTPL+/KOJoa20hfnVQ/3/T6W/KflYI4bRHRagNeXeU2bkNGI3v1oS/lw==\"\n },\n \"libsql@0.4.7\": {\n \"integrity\": \"sha512-T9eIRCs6b0J1SHKYIvD8+KCJMcWZ900iZyxdnSCdqxN12Z1ijzT+jY5nrk72Jw4B0HGzms2NgpryArlJqvc3Lw==\",\n \"dependencies\": [\n \"@libsql/darwin-arm64\",\n \"@libsql/darwin-x64\",\n \"@libsql/linux-arm64-gnu\",\n \"@libsql/linux-arm64-musl\",\n \"@libsql/linux-x64-gnu\",\n \"@libsql/linux-x64-musl\",\n \"@libsql/win32-x64-msvc\",\n \"@neon-rs/load\",\n \"detect-libc\"\n ]\n },\n \"math-intrinsics@1.1.0\": {\n \"integrity\": \"sha512-/IXtbwEk5HTPyEwyKX6hGkYXxM9nbj64B+ilVJnC/R6B0pH5G4V3b0pVbL7DBj4tkhBAppbQUlf6F6Xl9LHu1g==\"\n },\n \"mime-db@1.52.0\": {\n \"integrity\": \"sha512-sPU4uV7dYlvtWJxwwxHD0PuihVNiE7TyAbQ5SWxDCB9mUYvOgroQOwYQQOKPJ8CIbE+1ETVlOoK1UC2nU3gYvg==\"\n },\n \"mime-types@2.1.35\": {\n \"integrity\": \"sha512-ZDY+bPm5zTTF+YpCrAU9nK0UgICYPT0QtT1NZWFv4s++TNkcgVaT0g6+4R2uI4MjQjzysHB1zxuWL50hzaeXiw==\",\n \"dependencies\": [\n \"mime-db\"\n ]\n },\n \"ms@2.1.3\": {\n \"integrity\": \"sha512-6FlzubTLZG3J2a/NVCAleEhjzq5oxgHyaCU9yYXvcLsvoVaHJq/s5xXI6/XXP6tz7R9xAOtHnSO/tXtF3WRTlA==\"\n },\n \"node-domexception@1.0.0\": {\n \"integrity\": \"sha512-/jKZoMpw0F8GRwl4/eLROPA3cfcXtLApP0QzLmUT/HuPCZWyB7IY9ZrMeKw2O/nFIqPQB3PVM9aYm0F312AXDQ==\"\n },\n \"node-fetch@2.7.0\": {\n \"integrity\": \"sha512-c4FRfUm/dbcWZ7U+1Wq0AwCyFL+3nt2bEw05wfxSz+DWpWsitgmSgYmy2dQdWyKC1694ELPqMs/YzUSNozLt8A==\",\n \"dependencies\": [\n \"whatwg-url\"\n ]\n },\n \"node-fetch@3.3.2\": {\n \"integrity\": \"sha512-dRB78srN/l6gqWulah9SrxeYnxeddIG30+GOqK/9OlLVyLg3HPnr6SqOWTWOXKRwC2eGYCkZ59NNuSgvSrpgOA==\",\n \"dependencies\": [\n \"data-uri-to-buffer\",\n \"fetch-blob\",\n \"formdata-polyfill\"\n ]\n },\n \"promise-limit@2.7.0\": {\n \"integrity\": \"sha512-7nJ6v5lnJsXwGprnGXga4wx6d1POjvi5Qmf1ivTRxTjH4Z/9Czja/UCMLVmB9N93GeWOU93XaFaEt6jbuoagNw==\"\n },\n \"react-dom@19.0.0_react@19.0.0\": {\n \"integrity\": \"sha512-4GV5sHFG0e/0AD4X+ySy6UJd3jVl1iNsNHdpad0qhABJ11twS3TTBnseqsKurKcsNqCEFeGL3uLpVChpIO3QfQ==\",\n \"dependencies\": [\n \"react\",\n \"scheduler\"\n ]\n },\n \"react@19.0.0\": {\n \"integrity\": \"sha512-V8AVnmPIICiWpGfm6GLzCR/W5FXLchHop40W4nXBmdlEceh16rCN8O8LNWm5bh5XUX91fh7KpA+W0TgMKmgTpQ==\"\n },\n \"scheduler@0.25.0\": {\n \"integrity\": \"sha512-xFVuu11jh+xcO7JOAGJNOXld8/TcEHK/4CituBUeUb5hqxJLj9YuemAEuvm9gQ/+pgXYfbQuqAkiYu+u7YEsNA==\"\n },\n \"tr46@0.0.3\": {\n \"integrity\": \"sha512-N3WMsuqV66lT30CrXNbEjx4GEwlow3v6rr4mCcv6prnfwhS01rkgyFdjPNBYd9br7LpXV1+Emh01fHnq2Gdgrw==\"\n },\n \"undici-types@5.26.5\": {\n \"integrity\": \"sha512-JlCMO+ehdEIKqlFxk6IfVoAUVmgz7cU7zD/h9XZ0qzeosSHmUJVOzSQvvYSYWXkFXC+IfLKSIffhv0sVZup6pA==\"\n },\n \"undici-types@6.20.0\": {\n \"integrity\": \"sha512-Ny6QZ2Nju20vw1SRHe3d9jVu6gJ+4e3+MMpqu7pqE5HT6WsTSlce++GQmK5UXS8mzV8DSYHrQH+Xrf2jVcuKNg==\"\n },\n \"web-streams-polyfill@3.3.3\": {\n \"integrity\": \"sha512-d2JWLCivmZYTSIoge9MsgFCZrt571BikcWGYkjC1khllbTeDlGqZ2D8vD8E/lJa8WGWbb7Plm8/XJYV7IJHZZw==\"\n },\n \"web-streams-polyfill@4.0.0-beta.3\": {\n \"integrity\": \"sha512-QW95TCTaHmsYfHDybGMwO5IJIM93I/6vTRk+daHTWFPhwh+C8Cg7j7XyKrwrj8Ib6vYXe0ocYNrmzY4xAAN6ug==\"\n },\n \"webidl-conversions@3.0.1\": {\n \"integrity\": \"sha512-2JAn3z8AR6rjK8Sm8orRC0h/bcl/DqL7tRPdGZ4I1CjdF+EaMLmYxBHyXuKL849eucPFhvBoxMsflfOb8kxaeQ==\"\n },\n \"whatwg-url@5.0.0\": {\n \"integrity\": \"sha512-saE57nupxk6v3HY35+jzBwYa0rKSy0XR8JSxZPwgLr7ys0IBzhGviA1/TUGJLmSVqs8pb9AnvICXEuOHLprYTw==\",\n \"dependencies\": [\n \"tr46\",\n \"webidl-conversions\"\n ]\n },\n \"ws@8.18.1\": {\n \"integrity\": \"sha512-RKW2aJZMXeMxVpnZ6bck+RswznaxmzdULiBr6KY7XkTnW8uvt0iT9H5DkHUChXrc+uurzwa0rVI16n/Xzjdz1w==\"\n },\n \"zod@3.24.2\": {\n \"integrity\": \"sha512-lY7CDW43ECgW9u1TcT3IoXHflywfVqDYze4waEz812jR/bZ8FHDsl7pFQoSZTz5N+2NqRXs8GBwnAwo3ZNxqhQ==\"\n }\n },\n \"redirects\": {\n \"https://esm.town/v/jxnblk/valTownBadge02\": \"https://esm.town/v/jxnblk/valTownBadge02?v=6\",\n \"https://esm.town/v/jxnblk/valTownBadgeMiddleware\": \"https://esm.town/v/jxnblk/valTownBadgeMiddleware?v=10\",\n \"https://esm.town/v/std/API_URL\": \"https://esm.town/v/std/API_URL?v=5\",\n \"https://esm.town/v/stevekrouse/sqlite\": \"https://esm.town/v/stevekrouse/sqlite?v=13\"\n },\n \"remote\": {\n \"https://esm.town/v/jxnblk/valTownBadge02?v=6\": \"a34a1c0776985492ad9df112628fd43f3e26c60f4ca0de8fc2755b111827f9b2\",\n \"https://esm.town/v/jxnblk/valTownBadgeMiddleware?v=10\": \"1e849149e69f0c5f78f4613d813a57437dbfec0b246a3862aee7dd5805640716\",\n \"https://esm.town/v/std/API_URL?v=5\": \"46109f905a50e32281d3ffbe7b9c8209a778290c5274d83d131fba2d26c4974d\",\n \"https://esm.town/v/stevekrouse/sqlite?v=13\": \"3b613197e9da35db335dc2726c062c61f9247439c10a0c64c118994e200ffa46\"\n }\n}\n",[174],"340432d2-0107-11f0-a4a7-569c3dd06744","deno.json","2def76cc-0107-11f0-b674-569c3dd06744",["D",1741979089748],"{\n \"tasks\": {\n },\n \"imports\": {\n }\n}\n",[181],"b08b8bde-0f3a-11f0-a01d-569c3dd06744","db.ts","d351ab06-0109-11f0-ac23-569c3dd06744",109,["D",1743540519284],16,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { z } from \"npm:zod\";\n\n// Original example code\nconst tablePrefix = \"vt_project_search_v2\";\n\n// Create tables for project file content search\nawait sqlite.batch([\n // Projects table\n `CREATE TABLE IF NOT EXISTS ${tablePrefix}_projects (\n id TEXT PRIMARY KEY,\n url TEXT NOT NULL,\n name TEXT NOT NULL,\n username TEXT NOT NULL,\n updated_at TIMESTAMP NOT NULL\n )`,\n\n // Files table with foreign key to projects\n `CREATE TABLE IF NOT EXISTS ${tablePrefix}_files (\n id TEXT PRIMARY KEY,\n url TEXT NOT NULL,\n project_id TEXT NOT NULL,\n name TEXT NOT NULL,\n content TEXT,\n updated_at TIMESTAMP NOT NULL,\n FOREIGN KEY (project_id) REFERENCES ${tablePrefix}_projects(id)\n )`,\n\n // Create index for faster text searches\n `CREATE INDEX IF NOT EXISTS idx_${tablePrefix}_files_content ON ${tablePrefix}_files(content)`,\n\n // Create index for project lookups\n `CREATE INDEX IF NOT EXISTS idx_${tablePrefix}_files_project_id ON ${tablePrefix}_files(project_id)`,\n]);\n\n// Define types with Zod schemas\nconst ProjectSchema = z.object({\n id: z.string(),\n url: z.string(),\n name: z.string(),\n username: z.string(),\n updated_at: z.string().datetime(),\n});\n\nconst FileSchema = z.object({\n id: z.string(),\n url: z.string(),\n project_id: z.string(),\n name: z.string(),\n content: z.string().nullable(),\n updated_at: z.string().datetime(),\n});\n\nconst ProjectWithFilesSchema = ProjectSchema.extend({\n files: z.array(FileSchema).optional(),\n});\n\n// TypeScript interfaces derived from Zod schemas\ntype Project = z.infer;\ntype File = z.infer;\ntype ProjectWithFiles = z.infer;\n\n// Search result type\ntype FileSearchResult = File & {\n project_name: string;\n username: string;\n};\n\n// Helper functions for project and file management\n\n/**\n * Get a project by ID\n */\nasync function getProject(projectId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${tablePrefix}_projects WHERE id = ?`,\n [projectId],\n );\n\n if (result.rows.length === 0) return null;\n\n try {\n return ProjectSchema.parse(result.rows[0]);\n } catch (error) {\n console.error(\"Invalid project data:\", error);\n return null;\n }\n}\n\n\n\n/**\n * Insert or update a project if it's newer than existing data\n */\nexport async function upsertProject(project: Project): Promise {\n // Convert Date object to string if needed\n const updatedAt = project.updated_at;\n\n // Check if project exists and compare timestamps\n const existingProject = await getProject(project.id);\n\n if (!existingProject) {\n // Insert new project\n await sqlite.execute(\n `INSERT INTO ${tablePrefix}_projects (id, url, name, username, updated_at) VALUES (?, ?, ?, ?, ?)`,\n [project.id, project.url, project.name, project.username, updatedAt],\n );\n return true; // Inserted\n } else if (updatedAt > existingProject.updated_at) {\n // Update existing project if newer\n await sqlite.execute(\n `UPDATE ${tablePrefix}_projects SET url = ?, name = ?, username = ?, updated_at = ? WHERE id = ?`,\n [project.url, project.name, project.username, updatedAt, project.id],\n );\n return true; // Updated\n }\n\n return false; // Not updated (existing data is newer)\n}\n\n/**\n * Get a file by ID\n */\nasync function getFile(fileId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${tablePrefix}_files WHERE id = ?`,\n [fileId],\n );\n\n if (result.rows.length === 0) return null;\n\n try {\n return FileSchema.parse(result.rows[0]);\n } catch (error) {\n console.error(\"Invalid file data:\", error);\n return null;\n }\n}\n\n/**\n * Insert or update a file if it's newer than existing data\n */\nexport async function upsertFile(file: File): Promise {\n // Convert Date object to string if needed\n\n // Check if file exists and compare timestamps\n const existingFile = await getFile(file.id);\n\n if (!existingFile) {\n // Insert new file\n await sqlite.execute(\n `INSERT INTO ${tablePrefix}_files (id, url, project_id, name, content, updated_at)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n file.id,\n file.url,\n file.project_id,\n file.name,\n file.content,\n file.updated_at,\n ],\n );\n return true; // Inserted\n } else if (file.updated_at > existingFile.updated_at) {\n // Update existing file if newer\n await sqlite.execute(\n `UPDATE ${tablePrefix}_files SET url = ?, project_id = ?, name = ?, content = ?, updated_at = ?\n WHERE id = ?`,\n [\n file.url,\n file.project_id,\n file.name,\n file.content,\n file.updated_at,\n file.id,\n ],\n );\n return true; // Updated\n }\n\n return false; // Not updated (existing data is newer)\n}\n\n/**\n * Enhanced search result with code context\n */\nexport type EnhancedSearchResult = FileSearchResult & {\n matchedLines: {\n lineNumber: number;\n lineContent: string;\n isMatch: boolean;\n }[];\n totalMatches: number;\n};\n\n/**\n * Extract matched lines with context around matches\n */\nfunction extractMatchedLines(\n content: string,\n searchText: string,\n contextLines: number = 2,\n): EnhancedSearchResult[\"matchedLines\"] {\n if (!content) return [];\n\n const lines = content.split(\"\\n\");\n const matchedLineIndices: number[] = [];\n\n // Find all matching lines\n for (let i = 0; i < lines.length; i++) {\n if (lines[i].toLowerCase().includes(searchText.toLowerCase())) {\n matchedLineIndices.push(i);\n }\n }\n\n // Create groups of matched lines with context\n const result: {\n lineNumber: number;\n lineContent: string;\n isMatch: boolean;\n }[] = [];\n const processedLines = new Set();\n\n for (const matchIndex of matchedLineIndices) {\n // Calculate range for context\n const startLine = Math.max(0, matchIndex - contextLines);\n const endLine = Math.min(lines.length - 1, matchIndex + contextLines);\n\n // Add lines with context\n for (let i = startLine; i <= endLine; i++) {\n if (!processedLines.has(i)) {\n result.push({\n lineNumber: i + 1, // 1-based line number for display\n lineContent: lines[i],\n isMatch: matchedLineIndices.includes(i),\n });\n processedLines.add(i);\n }\n }\n\n // Add a separator between non-contiguous blocks\n if (\n result.length > 0 && result[result.length - 1].lineNumber !== endLine + 1\n ) {\n result.push({\n lineNumber: -1, // Sentinel value for separator\n lineContent: \"...\",\n isMatch: false,\n });\n }\n }\n\n return result;\n}\n\n/**\n * Search for files containing specific text\n */\nexport async function searchFileContent(\n searchText: string,\n): Promise {\n const result = await sqlite.execute(\n `SELECT f.*, p.name as project_name, p.url as project_url, p.username\n FROM ${tablePrefix}_files f\n JOIN ${tablePrefix}_projects p ON f.project_id = p.id\n WHERE f.content LIKE ?`,\n [`%${searchText}%`],\n );\n\n const FileSearchResultSchema = FileSchema.extend({\n project_name: z.string(),\n project_url: z.string(),\n username: z.string(),\n });\n\n try {\n return z.array(FileSearchResultSchema).parse(result.rows);\n } catch (error) {\n console.error(\"Invalid search results:\", error);\n return [];\n }\n}\n\n/**\n * Search response with pagination and timing info\n */\nexport type SearchResponse = {\n results: EnhancedSearchResult[];\n totalResults: number;\n page: number;\n pageSize: number;\n totalPages: number;\n executionTimeMs: number;\n};\n\n/**\n * Count total search results\n */\nexport async function countSearchResults(searchText: string): Promise {\n const result = await sqlite.execute(\n `SELECT COUNT(*) as total\n FROM ${tablePrefix}_files f\n JOIN ${tablePrefix}_projects p ON f.project_id = p.id\n WHERE f.content LIKE ?`,\n [`%${searchText}%`],\n );\n\n return Number(result.rows[0]?.total) || 0;\n}\n\n/**\n * Enhanced search that returns matched content with context and pagination\n */\nexport async function searchFileContentWithContext(\n searchText: string,\n contextLines: number = 2,\n page: number = 1,\n pageSize: number = 10,\n): Promise {\n if (!searchText.trim()) {\n return {\n results: [],\n totalResults: 0,\n page,\n pageSize,\n totalPages: 0,\n executionTimeMs: 0,\n };\n }\n\n const startTime = performance.now();\n\n // Calculate pagination parameters\n const offset = (page - 1) * pageSize;\n\n // Get total count for pagination\n const totalResults = await countSearchResults(searchText);\n const totalPages = Math.ceil(totalResults / pageSize);\n\n // Get paginated results\n const result = await sqlite.execute(\n `SELECT f.*, p.name as project_name, p.url as project_url, p.username\n FROM ${tablePrefix}_files f\n JOIN ${tablePrefix}_projects p ON f.project_id = p.id\n WHERE f.content LIKE ?\n LIMIT ? OFFSET ?`,\n [`%${searchText}%`, pageSize, offset],\n );\n\n const FileSearchResultSchema = FileSchema.extend({\n project_name: z.string(),\n project_url: z.string(),\n username: z.string(),\n });\n\n let results: EnhancedSearchResult[] = [];\n\n try {\n const fileResults = z.array(FileSearchResultSchema).parse(result.rows);\n\n results = fileResults.map((result) => {\n const matchedLines = extractMatchedLines(\n result.content || \"\",\n searchText,\n contextLines,\n );\n const totalMatches = matchedLines.filter((line) => line.isMatch).length;\n\n return {\n ...result,\n matchedLines,\n totalMatches,\n };\n });\n } catch (error) {\n console.error(\"Invalid search results:\", error);\n }\n\n const endTime = performance.now();\n const executionTimeMs = Math.round(endTime - startTime);\n\n return {\n results,\n totalResults,\n page,\n pageSize,\n totalPages,\n executionTimeMs,\n };\n}\n",[187],"pulls",0,"branches",3,"forks","envVars",{"_203":195,"_205":195},"connections",{"_203":195,"_204":195},"count","unfilledCount","emptyCount",{"_43":186,"_32":187,"_30":188,"_140":-5,"_41":42,"_40":189,"_141":25,"_38":232,"_13":191,"_33":153,"_35":192,"_24":25,"_144":-5,"_214":233,"_27":234},{"_43":180,"_32":181,"_30":182,"_140":-5,"_41":42,"_40":64,"_141":25,"_38":229,"_13":152,"_33":20,"_35":184,"_24":25,"_144":-5,"_214":230,"_27":231},{"_43":173,"_32":174,"_30":175,"_140":-5,"_41":42,"_40":176,"_141":25,"_38":226,"_13":152,"_33":20,"_35":178,"_24":25,"_144":-5,"_214":227,"_27":228},{"_43":164,"_32":165,"_30":166,"_140":-5,"_41":42,"_40":167,"_141":25,"_38":223,"_13":169,"_33":170,"_35":171,"_24":25,"_144":-5,"_214":224,"_27":225},{"_43":156,"_32":157,"_30":158,"_140":-5,"_41":42,"_40":159,"_141":25,"_38":220,"_13":161,"_33":153,"_35":162,"_24":25,"_144":-5,"_214":221,"_27":222},{"_43":147,"_32":148,"_30":149,"_140":-5,"_41":42,"_40":150,"_141":25,"_38":217,"_13":152,"_33":153,"_35":154,"_24":25,"_144":-5,"_214":218,"_27":219},{"_43":139,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_141":25,"_38":213,"_13":143,"_33":34,"_35":37,"_24":25,"_144":145,"_214":215,"_27":216},["D",1744141032051],"children",[],[28],["D",1743684928807],[],[148],["D",1741983042887],[],[157],["D",1743687196210],[],[165],["D",1741982884002],[],[174],["D",1741979089748],[],[181],["D",1743540519284],[],[187],["D",1741978488970],["D",1789534231467],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_18":-5,"_106":107,"_108":59},{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"ctx",{"_83":-5,"_129":273,"_274":275,"_276":277,"_278":25,"_279":25,"_280":25,"_281":59,"_282":-5,"_283":-7,"_284":-7,"_285":195,"_286":25,"_287":25,"_288":-5,"_289":25,"_290":25,"_291":25,"_292":-5},"ENV",{"_244":245,"_246":247,"_248":91,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272},"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 · v113