[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_296":297,"_298":299},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":59,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",15,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/routes/projects.ts","latestPath","fileId","30f9f7b8-3fb7-11f0-b953-76b3cceeab13","name","projects.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllProjects, createProject } from \"../database/queries.ts\";\nimport type { Project } from \"../../shared/types.ts\";\n\nconst projects = new Hono();\n\n// Get all projects\nprojects.get(\"/\", async (c) => {\n try {\n const allProjects = await getAllProjects();\n return c.json(allProjects);\n } catch (error) {\n console.error(\"Error fetching projects:\", error);\n return c.json({ error: \"Failed to fetch projects\" }, 500);\n }\n});\n\n// Create a new project\nprojects.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.title || !body.description || !body.category) {\n return c.json({ \n error: \"Missing required fields: title, description, and category are required\" \n }, 400);\n }\n \n // Validate category\n const validCategories = [\n \"Machine Learning\", \"NLP\", \"Computer Vision\", \n \"Generative AI\", \"Data Science\", \"Robotics\", \"Other AI\"\n ];\n \n if (!validCategories.includes(body.category)) {\n return c.json({ error: \"Invalid category\" }, 400);\n }\n \n const projectData: Omit = {\n title: body.title.trim(),\n description: body.description.trim(),\n link: body.link?.trim() || undefined,\n category: body.category\n };\n \n const newProject = await createProject(projectData);\n return c.json(newProject, 201);\n } catch (error) {\n console.error(\"Error creating project:\", error);\n return c.json({ error: \"Failed to create project\" }, 500);\n }\n});\n\nexport default projects;","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllProjects, createProject } from \"../database/queries.ts\";\nimport type { Project } from \"../../shared/types.ts\";\n\nconst projects = new Hono();\n\n// Get all projects\nprojects.get(\"/\", async (c) => {\n try {\n const allProjects = await getAllProjects();\n return c.json(allProjects);\n } catch (error) {\n console.error(\"Error fetching projects:\", error);\n return c.json({ error: \"Failed to fetch projects\" }, 500);\n }\n});\n\n// Create a new project\nprojects.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n console.log(\"Received project data:\", body);\n \n // Validate required fields\n if (!body.title || !body.description || !body.category) {\n return c.json({ \n error: \"Missing required fields: title, description, and category are required\" \n }, 400);\n }\n \n // Validate category\n const validCategories = [\n \"Machine Learning\", \"NLP\", \"Computer Vision\", \n \"Generative AI\", \"Data Science\", \"Robotics\", \"Other AI\"\n ];\n \n if (!validCategories.includes(body.category)) {\n return c.json({ error: \"Invalid category\" }, 400);\n }\n \n const projectData: Omit = {\n title: body.title.trim(),\n description: body.description.trim(),\n link: body.link?.trim() || undefined,\n category: body.category\n };\n \n console.log(\"Creating project with data:\", projectData);\n const newProject = await createProject(projectData);\n console.log(\"Created project:\", newProject);\n return c.json(newProject, 201);\n } catch (error) {\n console.error(\"Error creating project:\", error);\n return c.json({ error: \"Failed to create project\", details: error.message }, 500);\n }\n});\n\nexport default projects;","createdAt",["D",1748871787333],"branchVersion","branchId","0db0f680-3fb7-11f0-a1a7-76b3cceeab13","id","0dad7eec-3fb7-11f0-a1a7-76b3cceeab13","Community_AI_Project_Showcase",["D",1748871588946],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","ebddac60-3fb1-11f0-ad5b-814c56c8abb0","pinnedFileId","371aa552-3fb7-11f0-9480-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","bbdb79e9-4641-405b-b31c-3766f4f8592e","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ianochieng","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHhBVFdpc3RiNHFHZVZ1Um1CVHluTUpkenMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":292,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":293,"_81":294,"_83":295,"_85":25},"tree",[170,177,184,186],"files",[170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186],"counts",{"_160":63,"_161":135,"_162":63,"_163":164,"_165":166},"contents",[127,128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":154,"_32":155,"_30":156,"_134":-5,"_42":43,"_41":157,"_136":59,"_39":158,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":159},{"_44":148,"_32":149,"_30":150,"_134":-5,"_42":43,"_41":151,"_136":59,"_39":152,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":153},{"_44":141,"_32":142,"_30":143,"_134":-5,"_42":43,"_41":144,"_136":59,"_39":145,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":147},{"_44":131,"_32":132,"_30":133,"_134":-5,"_42":43,"_41":135,"_136":59,"_39":137,"_13":63,"_34":20,"_36":138,"_24":25,"_139":-5,"_27":140},"208d071c-3fb7-11f0-a5e5-76b3cceeab13","README.md","208d07c6-3fb7-11f0-a5e5-76b3cceeab13","parentId",1,"latest",["D",1748871620610],"# Community AI Project Showcase\n\nA web application for showcasing AI projects from the community. Users can submit their AI projects and browse through all submitted projects.\n\n## Features\n\n- Submit AI projects with title, description, link, and category\n- Browse all submitted projects in a card-based layout\n- Categories include: Machine Learning, NLP, Computer Vision, Generative AI, Data Science, Robotics, Other AI\n- Responsive design with TailwindCSS\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ └── projects.ts # Project API routes\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main React app\n│ │ ├── ProjectForm.tsx # Project submission form\n│ │ └── ProjectCard.tsx # Individual project display\n│ ├── index.html # HTML template\n│ └── index.tsx # React entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## API Endpoints\n\n- `GET /` - Serves the main application\n- `GET /api/projects` - Get all projects\n- `POST /api/projects` - Submit a new project\n\n## Tech Stack\n\n- Backend: Hono + SQLite\n- Frontend: React + TailwindCSS\n- Database: SQLite\n- Styling: TailwindCSS via Twind","label",[132],"238553d4-3fb7-11f0-ac23-76b3cceeab13","shared","6357d12e-f17b-4685-a713-10bfc7c8cbaa",2,["D",1748871625588],"directory",[142],"3ab36fe6-3fb7-11f0-8505-76b3cceeab13","frontend","d2cd8fb5-e6af-40b2-b90c-7585b076bf97",7,["D",1748871664476],[149],"26e72692-3fb7-11f0-8003-76b3cceeab13","backend","425b74b6-334b-4f5d-b568-679b4d6dd0da",3,["D",1748871631266],[155],"pulls","branches","forks","envVars",{"_167":63,"_169":63},"connections",{"_167":63,"_168":63},"count","unfilledCount","emptyCount",{"_44":154,"_32":155,"_30":156,"_134":-5,"_42":43,"_41":157,"_136":59,"_39":289,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_188":290,"_27":291},{"_44":285,"_32":277,"_30":271,"_134":156,"_42":43,"_41":157,"_136":59,"_39":286,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_188":287,"_27":288},{"_44":278,"_32":279,"_30":280,"_134":271,"_42":43,"_41":157,"_136":59,"_39":281,"_13":63,"_34":35,"_36":282,"_24":25,"_139":-5,"_188":283,"_27":284},{"_44":268,"_32":269,"_30":270,"_134":271,"_42":43,"_41":272,"_136":25,"_39":273,"_13":144,"_34":35,"_36":274,"_24":25,"_139":-5,"_188":275,"_27":276},{"_44":263,"_32":262,"_30":258,"_134":156,"_42":43,"_41":264,"_136":59,"_39":265,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_188":266,"_27":267},{"_44":257,"_32":33,"_30":31,"_134":258,"_42":43,"_41":14,"_136":25,"_39":259,"_13":135,"_34":35,"_36":38,"_24":25,"_139":-5,"_188":260,"_27":261},{"_44":249,"_32":250,"_30":57,"_134":156,"_42":43,"_41":251,"_136":59,"_39":252,"_13":135,"_34":253,"_36":254,"_24":25,"_139":-5,"_188":255,"_27":256},{"_44":148,"_32":149,"_30":150,"_134":-5,"_42":43,"_41":151,"_136":59,"_39":246,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_188":247,"_27":248},{"_44":242,"_32":225,"_30":219,"_134":150,"_42":43,"_41":237,"_136":59,"_39":243,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_188":244,"_27":245},{"_44":234,"_32":235,"_30":236,"_134":219,"_42":43,"_41":237,"_136":59,"_39":238,"_13":63,"_34":35,"_36":239,"_24":25,"_139":-5,"_188":240,"_27":241},{"_44":226,"_32":227,"_30":228,"_134":219,"_42":43,"_41":229,"_136":59,"_39":230,"_13":63,"_34":35,"_36":231,"_24":25,"_139":-5,"_188":232,"_27":233},{"_44":216,"_32":217,"_30":218,"_134":219,"_42":43,"_41":220,"_136":59,"_39":221,"_13":63,"_34":35,"_36":222,"_24":25,"_139":-5,"_188":223,"_27":224},{"_44":209,"_32":210,"_30":211,"_134":150,"_42":43,"_41":151,"_136":59,"_39":212,"_13":63,"_34":20,"_36":213,"_24":25,"_139":-5,"_188":214,"_27":215},{"_44":201,"_32":202,"_30":203,"_134":150,"_42":43,"_41":204,"_136":59,"_39":205,"_13":63,"_34":35,"_36":206,"_24":25,"_139":-5,"_188":207,"_27":208},{"_44":141,"_32":142,"_30":143,"_134":-5,"_42":43,"_41":144,"_136":59,"_39":198,"_13":63,"_34":146,"_36":-5,"_24":25,"_139":-5,"_188":199,"_27":200},{"_44":191,"_32":192,"_30":193,"_134":143,"_42":43,"_41":144,"_136":59,"_39":194,"_13":63,"_34":35,"_36":195,"_24":25,"_139":-5,"_188":196,"_27":197},{"_44":131,"_32":132,"_30":133,"_134":-5,"_42":43,"_41":135,"_136":59,"_39":187,"_13":63,"_34":20,"_36":138,"_24":25,"_139":-5,"_188":189,"_27":190},["D",1748871620610],"children",[],[132],"238537e6-3fb7-11f0-ac23-76b3cceeab13","types.ts","238538b8-3fb7-11f0-ac23-76b3cceeab13",["D",1748871625588],"export interface Project {\n id?: number;\n title: string;\n description: string;\n link?: string;\n category: ProjectCategory;\n created_at?: string;\n}\n\nexport type ProjectCategory = \n | \"Machine Learning\"\n | \"NLP\" \n | \"Computer Vision\"\n | \"Generative AI\"\n | \"Data Science\"\n | \"Robotics\"\n | \"Other AI\";\n\nexport const PROJECT_CATEGORIES: ProjectCategory[] = [\n \"Machine Learning\",\n \"NLP\",\n \"Computer Vision\", \n \"Generative AI\",\n \"Data Science\",\n \"Robotics\",\n \"Other AI\"\n];",[],[142,192],["D",1748871625588],[185],[142],"3d023f84-3fb7-11f0-96f2-76b3cceeab13","index.tsx","3d02404c-3fb7-11f0-96f2-76b3cceeab13",8,["D",1748871668351],"/** @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();",[],[149,202],"3ab354f2-3fb7-11f0-8505-76b3cceeab13","index.html","3ab355ce-3fb7-11f0-8505-76b3cceeab13",["D",1748871664476],"\n\n\n \n \n Community AI Project Showcase\n \n \n \n\n\n

\n \n\n",[],[149,210],"54a04492-3fb7-11f0-a902-76b3cceeab13","ProjectForm.tsx","54a04532-3fb7-11f0-a902-76b3cceeab13","b75bff5b-ce06-4bc4-9f42-ba40ac731846",10,["D",1748871707977],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Project, ProjectCategory } from \"../../shared/types.ts\";\nimport { PROJECT_CATEGORIES } from \"../../shared/types.ts\";\n\ninterface ProjectFormProps {\n onProjectSubmitted: (project: Project) => void;\n}\n\nexport default function ProjectForm({ onProjectSubmitted }: ProjectFormProps) {\n const [formData, setFormData] = useState({\n title: \"\",\n description: \"\",\n link: \"\",\n category: \"\" as ProjectCategory | \"\"\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n \n if (!formData.title.trim() || !formData.description.trim() || !formData.category) {\n setError(\"Please fill in all required fields\");\n return;\n }\n\n setIsSubmitting(true);\n \n try {\n const response = await fetch(\"/api/projects\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n title: formData.title.trim(),\n description: formData.description.trim(),\n link: formData.link.trim() || undefined,\n category: formData.category\n }),\n });\n\n if (response.ok) {\n const newProject = await response.json();\n onProjectSubmitted(newProject);\n setFormData({ title: \"\", description: \"\", link: \"\", category: \"\" });\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to submit project\");\n }\n } catch (error) {\n console.error(\"Error submitting project:\", error);\n setError(\"Failed to submit project. Please try again.\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n };\n\n return (\n

Submit Your AI Project

\n \n {error && (\n

\n {error}\n

\n )}\n\n

\n {/* Project Title */}\n

\n \n Project Title *\n \n \n

\n\n {/* Project Description */}\n

\n \n Short Project Description *\n \n \n

\n\n {/* Project Link */}\n

\n \n Link to Project (optional)\n \n \n

\n\n {/* Category */}\n

\n \n Category *\n \n \n \n {PROJECT_CATEGORIES.map((category) => (\n \n ))}\n \n

\n\n {/* Submit Button */}\n

\n \n {isSubmitting ? \"Submitting...\" : \"Submit Project\"}\n \n

\n );\n}",[],[149,225,217],"components","5d2fabf2-3fb7-11f0-895c-76b3cceeab13","ProjectCard.tsx","5d2facc4-3fb7-11f0-895c-76b3cceeab13",11,["D",1748871722331],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Project } from \"../../shared/types.ts\";\n\ninterface ProjectCardProps {\n project: Project;\n}\n\nconst categoryEmojis: Record = {\n \"Machine Learning\": \"🤖\",\n \"NLP\": \"💬\",\n \"Computer Vision\": \"👁️\",\n \"Generative AI\": \"✨\",\n \"Data Science\": \"📊\",\n \"Robotics\": \"🦾\",\n \"Other AI\": \"🧠\"\n};\n\nexport default function ProjectCard({ project }: ProjectCardProps) {\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n };\n\n return (\n

\n {/* Category Badge */}\n

\n \n {categoryEmojis[project.category] || \"🧠\"}\n {project.category}\n \n {project.created_at && (\n \n {formatDate(project.created_at)}\n \n )}\n

\n\n {/* Project Title */}\n

\n {project.title}\n

\n\n {/* Project Description */}\n

\n {project.description}\n

\n\n {/* Project Link */}\n {project.link && (\n

\n \n View Project\n \n \n

\n )}\n

\n );\n}",[],[149,225,227],"4801dac0-3fb7-11f0-af77-76b3cceeab13","App.tsx","4801dc5a-3fb7-11f0-af77-76b3cceeab13",9,["D",1748871686783],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport ProjectForm from \"./ProjectForm.tsx\";\nimport ProjectCard from \"./ProjectCard.tsx\";\nimport type { Project } from \"../../shared/types.ts\";\n\ndeclare global {\n interface Window {\n __INITIAL_PROJECTS__?: Project[];\n }\n}\n\nexport default function App() {\n const [projects, setProjects] = useState([]);\n const [showForm, setShowForm] = useState(false);\n const [loading, setLoading] = useState(false);\n\n useEffect(() => {\n // Use initial data if available, otherwise fetch\n if (window.__INITIAL_PROJECTS__) {\n setProjects(window.__INITIAL_PROJECTS__);\n } else {\n fetchProjects();\n }\n }, []);\n\n const fetchProjects = async () => {\n try {\n setLoading(true);\n const response = await fetch(\"/api/projects\");\n if (response.ok) {\n const data = await response.json();\n setProjects(data);\n }\n } catch (error) {\n console.error(\"Error fetching projects:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleProjectSubmitted = (newProject: Project) => {\n setProjects(prev => [newProject, ...prev]);\n setShowForm(false);\n };\n\n return (\n

\n {/* Header */}\n

\n 🤖 Community AI Project Showcase\n

\n Discover and share amazing AI projects from the community\n

\n setShowForm(!showForm)}\n className=\"bg-blue-600 hover:bg-blue-700 text-white px-6 py-3 rounded-lg font-medium transition-colors\"\n >\n {showForm ? \"Cancel\" : \"Submit Project\"}\n \n

\n\n

\n {/* Project Submission Form */}\n {showForm && (\n

\n \n

\n )}\n\n {/* Projects Grid */}\n

\n Featured Projects ({projects.length})\n

\n {loading && (\n

\n )}\n

\n\n {projects.length === 0 && !loading ? (\n

🚀

\n No projects yet\n

\n Be the first to share your AI project with the community!\n

\n setShowForm(true)}\n className=\"bg-blue-600 hover:bg-blue-700 text-white px-6 py-3 rounded-lg font-medium transition-colors\"\n >\n Submit First Project\n \n

\n ) : (\n

\n {projects.map((project) => (\n \n ))}\n

\n )}\n

\n\n {/* Footer */}\n \n

\n );\n}",[],[149,225,235],"4801fd2a-3fb7-11f0-af77-76b3cceeab13",["D",1748871686783],[179,180,181],[149,225],["D",1748871664476],[178,182,183],[149],"6057e434-3fb7-11f0-8dfe-76b3cceeab13","index.ts",12,["D",1748871727628],"http","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 { createProjectsTable } from \"./database/migrations.ts\";\nimport { getAllProjects } from \"./database/queries.ts\";\nimport projects from \"./routes/projects.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// Initialize database\nawait createProjectsTable();\n\n// API routes\napp.route(\"/api/projects\", projects);\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// Serve main page with initial data\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial projects data to avoid extra round-trip\n const initialProjects = await getAllProjects();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.text(\"Error loading page\", 500);\n }\n});\n\nexport default app.fetch;",[],[155,250],"83ee7840-3fb7-11f0-8560-76b3cceeab13","12147416-49ee-4c2d-b596-a617e15ebb83",["D",1748871787333],[],[155,262,33],"routes","30f9fd4e-3fb7-11f0-b953-76b3cceeab13",5,["D",1748871648167],[175],[155,262],"78adc27e-3fb7-11f0-82c2-76b3cceeab13","queries.ts","2bcebb48-3fb7-11f0-8c3f-76b3cceeab13","77524f03-3970-47f1-8f85-fff33de43764",14,["D",1748871768459],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { Project } from \"../../shared/types.ts\";\n\nexport async function getAllProjects(): Promise {\n const result = await sqlite.execute(`\n SELECT id, title, description, link, category, created_at \n FROM ${TABLE_NAME} \n ORDER BY created_at DESC\n `);\n \n if (!result.rows) {\n return [];\n }\n \n return result.rows.map(row => ({\n id: row[0] as number,\n title: row[1] as string,\n description: row[2] as string,\n link: row[3] as string | null,\n category: row[4] as Project['category'],\n created_at: row[5] as string\n }));\n}\n\nexport async function createProject(project: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLE_NAME} (title, description, link, category)\n VALUES (?, ?, ?, ?)\n `, [project.title, project.description, project.link || null, project.category]);\n \n const insertId = result.meta?.last_row_id;\n \n if (!insertId) {\n throw new Error(\"Failed to get insert ID\");\n }\n \n // Get the created project\n const createdProject = await sqlite.execute(`\n SELECT id, title, description, link, category, created_at \n FROM ${TABLE_NAME} \n WHERE id = ?\n `, [insertId]);\n \n if (!createdProject.rows || createdProject.rows.length === 0) {\n throw new Error(\"Failed to retrieve created project\");\n }\n \n const row = createdProject.rows[0];\n return {\n id: row[0] as number,\n title: row[1] as string,\n description: row[2] as string,\n link: row[3] as string | null,\n category: row[4] as Project['category'],\n created_at: row[5] as string\n };\n}",[],[155,277,269],"database","26e71ff8-3fb7-11f0-8003-76b3cceeab13","migrations.ts","26e72098-3fb7-11f0-8003-76b3cceeab13",["D",1748871631266],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'ai_projects_v1';\n\nexport async function createProjectsTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n link TEXT,\n category TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport { TABLE_NAME };",[],[155,277,279],"26e72886-3fb7-11f0-8003-76b3cceeab13",["D",1748871631266],[172,173],[155,277],["D",1748871631266],[171,174,176],[155],["D",1748871588946],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":329,"_330":331,"_332":333,"_334":25,"_335":25,"_336":25,"_337":59,"_338":-5,"_339":-7,"_340":-7,"_341":63,"_342":25,"_343":25,"_344":-5,"_345":25,"_346":25,"_347":25,"_348":-5},"ENV",{"_300":301,"_302":303,"_304":87,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v15