[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":49,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_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":25},"version",28,"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","main.tsx","latestPath","fileId","a5805faa-2761-11f0-86ff-569c3dd06744","name","fileType","http","content","/** @jsxImportSource https://esm.sh/react */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { useState, useEffect, Component } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { DragDropContext, Droppable, Draggable } from \"https://esm.sh/react-beautiful-dnd@13.1.1\";\n\nclass ErrorBoundary extends Component {\n constructor(props) {\n super(props);\n this.state = { hasError: false, error: null };\n }\n\n static getDerivedStateFromError(error) {\n return { hasError: true, error };\n }\n\n componentDidCatch(error, errorInfo) {\n console.error(\"Caught an error:\", error, errorInfo);\n }\n\n render() {\n if (this.state.hasError) {\n return

Something went wrong. Error: {this.state.error.toString()}

;\n }\n return this.props.children;\n }\n}\n\nfunction App() {\n console.log(\"Rendering App component\");\n const [categories, setCategories] = useState([]);\n const [newCategory, setNewCategory] = useState(\"\");\n const [newCard, setNewCard] = useState(\"\");\n const [textRepresentation, setTextRepresentation] = useState(\"\");\n\n useEffect(() => {\n fetchCategories();\n }, []);\n\n useEffect(() => {\n setTextRepresentation(categoriesToText(categories));\n }, [categories]);\n\n const fetchCategories = async () => {\n const response = await fetch(\"/categories\");\n if (response.ok) {\n const data = await response.json();\n setCategories(data);\n console.log(\"Categories fetched and set:\", data);\n data.forEach(category => console.log(`Category ${category.name} has ${category.cards.length} cards`));\n }\n };\n\n const addCategory = async () => {\n console.log(\"Adding category:\", newCategory);\n if (newCategory.trim()) {\n const response = await fetch(\"/categories\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ name: newCategory }),\n });\n if (response.ok) {\n setNewCategory(\"\");\n fetchCategories();\n }\n }\n };\n\n const deleteCard = async (cardId) => {\n console.log(\"Deleting card:\", cardId);\n const response = await fetch(`/cards/${cardId}`, {\n method: \"DELETE\",\n });\n if (response.ok) {\n fetchCategories();\n } else {\n console.error(\"Failed to delete card\");\n }\n };\n\n const deleteCategory = async (categoryId) => {\n console.log(\"Deleting category:\", categoryId);\n const response = await fetch(`/categories/${categoryId}`, {\n method: \"DELETE\",\n });\n if (response.ok) {\n fetchCategories();\n } else {\n console.error(\"Failed to delete category\");\n }\n };\n\n const addCard = async () => {\n if (newCard.trim()) {\n const response = await fetch(\"/cards\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ content: newCard, categoryId: null }),\n });\n if (response.ok) {\n setNewCard(\"\");\n fetchCategories();\n }\n }\n };\n\n const onDragEnd = async (result) => {\n console.log(\"onDragEnd called with result:\", result);\n if (!result.destination) return;\n\n const sourceIndex = result.source.index;\n const destIndex = result.destination.index;\n const sourceDroppableId = result.source.droppableId;\n const destDroppableId = result.destination.droppableId;\n\n const getCategory = (id) => categories.find(c => c.id?.toString() === id || (c.id === null && id === 'uncategorized'));\n const sourceCategory = getCategory(sourceDroppableId);\n const destCategory = getCategory(destDroppableId);\n\n if (!sourceCategory || !destCategory) {\n console.error(\"Source or destination category not found\");\n return;\n }\n\n if (sourceDroppableId === destDroppableId) {\n const newCards = Array.from(sourceCategory.cards);\n const [reorderedItem] = newCards.splice(sourceIndex, 1);\n newCards.splice(destIndex, 0, reorderedItem);\n\n const newCategories = categories.map(c =>\n c === sourceCategory ? { ...c, cards: newCards } : c\n );\n setCategories(newCategories);\n console.log(\"Categories updated:\", newCategories);\n } else {\n const sourceCards = Array.from(sourceCategory.cards);\n const destCards = Array.from(destCategory.cards);\n const [movedCard] = sourceCards.splice(sourceIndex, 1);\n destCards.splice(destIndex, 0, movedCard);\n\n const newCategories = categories.map(c =>\n c === sourceCategory ? { ...c, cards: sourceCards } :\n c === destCategory ? { ...c, cards: destCards } :\n c\n );\n\n setCategories(newCategories);\n console.log(\"Categories updated after move:\", newCategories);\n\n // Update the card's category on the server\n await fetch(`/cards/${movedCard.id}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ categoryId: destDroppableId === 'uncategorized' ? null : parseInt(destDroppableId) }),\n });\n }\n };\n\n const categoriesToText = (categories) => {\n return categories.map(category => {\n const categoryName = category.name;\n const cardsList = category.cards.map(card => `- ${card.content}`).join('\\n');\n return `${categoryName}\\n${cardsList}`;\n }).join('\\n\\n');\n };\n\n const textToCategories = (text) => {\n const lines = text.split('\\n');\n let currentCategory = null;\n const newCategories = [];\n\n lines.forEach(line => {\n line = line.trim();\n if (line === '') return;\n\n if (!line.startsWith('-')) {\n // This is a category name\n currentCategory = { name: line, cards: [] };\n newCategories.push(currentCategory);\n } else {\n // This is a card\n if (currentCategory) {\n currentCategory.cards.push({ content: line.substring(1).trim() });\n }\n }\n });\n\n return newCategories;\n };\n\n const handleTextChange = (e) => {\n setTextRepresentation(e.target.value);\n };\n\n const saveTextRepresentation = async () => {\n const newCategories = textToCategories(textRepresentation);\n try {\n const response = await fetch(\"/save\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(newCategories),\n });\n const data = await response.json();\n if (response.ok) {\n setCategories(data);\n console.log(\"Categories updated successfully\");\n } else {\n console.error(\"Failed to save changes:\", data.error, data.details);\n alert(`Failed to save changes: ${data.error}\\nDetails: ${data.details}`);\n }\n } catch (error) {\n console.error(\"Error saving changes:\", error);\n alert(`Error saving changes: ${error.message}`);\n }\n };\n\n return (\n

Card Sorting

\n setNewCategory(e.target.value)}\n placeholder=\"New category name\"\n />\n \n setNewCard(e.target.value)}\n placeholder=\"New card content\"\n />\n \n

\n \n

\n {categories.map((category) => (\n \n {(provided) => (\n \n

{category.name}

\n {category.id !== null && (\n \n )}\n

\n {category.cards.map((card, index) => (\n \n {(provided, snapshot) => (\n

\n \n {card.content}\n

\n \n

\n )}\n \n ))}\n {provided.placeholder}\n

\n )}\n \n ))}\n \n \n

Text Representation

\n \n \n

\n View Source\n

\n \n );\n}\n\nfunction client() {\n try {\n console.log(\"Starting client-side rendering\");\n const rootElement = document.getElementById(\"root\");\n if (rootElement) {\n console.log(\"Root element found, creating root\");\n const root = createRoot(rootElement);\n console.log(\"Rendering App component\");\n root.render(\n \n \n \n );\n } else {\n console.error(\"Root element not found\");\n }\n } catch (error) {\n console.error(\"Error in client-side rendering:\", error, error.stack);\n }\n}\nif (typeof document !== \"undefined\") { setTimeout(client, 0); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 1\n const KEY = \"cardSortDragDropApp\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_categories_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_cards_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT NOT NULL,\n category_id INTEGER,\n FOREIGN KEY (category_id) REFERENCES ${KEY}_categories_${SCHEMA_VERSION}(id)\n )\n `);\n\n const url = new URL(request.url);\n const path = url.pathname;\n\n if (path === \"/\" || path === \"\") {\n return new Response(`\n \n \n Card Sorting App\n \n \n \n

\n \n \n \n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n if (path === \"/categories\" && request.method === \"GET\") {\n const categories = await sqlite.execute(`SELECT * FROM ${KEY}_categories_${SCHEMA_VERSION}`);\n const cards = await sqlite.execute(`SELECT * FROM ${KEY}_cards_${SCHEMA_VERSION}`);\n \n const categoriesWithCards = categories.rows.map(category => ({\n ...category,\n cards: cards.rows.filter(card => card.category_id === category.id)\n }));\n\n // Add uncategorized cards\n categoriesWithCards.push({\n id: null,\n name: \"Uncategorized\",\n cards: cards.rows.filter(card => card.category_id === null)\n });\n\n return new Response(JSON.stringify(categoriesWithCards), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n\n if (path === \"/categories\" && request.method === \"POST\") {\n const { name } = await request.json();\n await sqlite.execute(`INSERT INTO ${KEY}_categories_${SCHEMA_VERSION} (name) VALUES (?)`, [name]);\n return new Response(\"Category added\", { status: 201 });\n }\n\n if (path === \"/cards\" && request.method === \"POST\") {\n const { content, categoryId } = await request.json();\n await sqlite.execute(`INSERT INTO ${KEY}_cards_${SCHEMA_VERSION} (content, category_id) VALUES (?, ?)`, [content, categoryId]);\n return new Response(\"Card added\", { status: 201 });\n }\n\n if (path.startsWith(\"/cards/\") && request.method === \"PATCH\") {\n const cardId = path.split(\"/\")[2];\n const { categoryId } = await request.json();\n await sqlite.execute(`UPDATE ${KEY}_cards_${SCHEMA_VERSION} SET category_id = ? WHERE id = ?`, [categoryId, cardId]);\n return new Response(\"Card updated\", { status: 200 });\n }\n\n if (path.startsWith(\"/categories/\") && request.method === \"DELETE\") {\n const categoryId = path.split(\"/\")[2];\n await sqlite.execute(`DELETE FROM ${KEY}_categories_${SCHEMA_VERSION} WHERE id = ?`, [categoryId]);\n await sqlite.execute(`UPDATE ${KEY}_cards_${SCHEMA_VERSION} SET category_id = NULL WHERE category_id = ?`, [categoryId]);\n return new Response(\"Category deleted\", { status: 200 });\n }\n\n if (path.startsWith(\"/cards/\") && request.method === \"DELETE\") {\n const cardId = path.split(\"/\")[2];\n await sqlite.execute(`DELETE FROM ${KEY}_cards_${SCHEMA_VERSION} WHERE id = ?`, [cardId]);\n return new Response(\"Card deleted\", { status: 200 });\n }\n\n if (path === \"/save\" && request.method === \"POST\") {\n const newCategories = await request.json();\n \n let response;\n let transactionStarted = false;\n\n try {\n // Start a transaction\n await sqlite.execute('BEGIN TRANSACTION');\n transactionStarted = true;\n\n // Clear existing categories and cards\n await sqlite.execute(`DELETE FROM ${KEY}_categories_${SCHEMA_VERSION}`);\n await sqlite.execute(`DELETE FROM ${KEY}_cards_${SCHEMA_VERSION}`);\n\n // Insert new categories and cards\n for (const category of newCategories) {\n if (category.name && category.name.toLowerCase() !== \"uncategorized\") {\n const result = await sqlite.execute(\n `INSERT INTO ${KEY}_categories_${SCHEMA_VERSION} (name) VALUES (?)`,\n [category.name]\n );\n const categoryId = result.lastInsertId;\n\n for (const card of (category.cards || [])) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_cards_${SCHEMA_VERSION} (content, category_id) VALUES (?, ?)`,\n [card.content, categoryId]\n );\n }\n } else {\n // Handle uncategorized cards if any\n for (const card of (category.cards || [])) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_cards_${SCHEMA_VERSION} (content, category_id) VALUES (?, NULL)`,\n [card.content]\n );\n }\n }\n }\n\n // Commit the transaction\n await sqlite.execute('COMMIT');\n \n // Fetch the updated categories and cards\n const categories = await sqlite.execute(`SELECT * FROM ${KEY}_categories_${SCHEMA_VERSION}`);\n const cards = await sqlite.execute(`SELECT * FROM ${KEY}_cards_${SCHEMA_VERSION}`);\n \n const categoriesWithCards = categories.rows.map(category => ({\n ...category,\n cards: cards.rows.filter(card => card.category_id === category.id)\n }));\n\n // Add uncategorized cards\n categoriesWithCards.push({\n id: null,\n name: \"Uncategorized\",\n cards: cards.rows.filter(card => card.category_id === null)\n });\n\n response = new Response(JSON.stringify(categoriesWithCards), {\n status: 200,\n headers: {\n \"Content-Type\": \"application/json\"\n }\n });\n } catch (error) {\n // If there's an error and we started a transaction, rollback\n if (transactionStarted) {\n await sqlite.execute('ROLLBACK');\n }\n console.error(\"Error saving changes:\", error.message);\n response = new Response(JSON.stringify({\n error: \"Error saving changes\",\n details: error.message\n }), { \n status: 500, \n headers: { \"Content-Type\": \"application/json\" } \n });\n }\n\n return response;\n }\n\n // If no route matches, return a 404 error\n return new Response(JSON.stringify({\n error: \"Not Found\",\n details: \"The requested resource was not found on this server.\"\n }), { status: 404, headers: { \"Content-Type\": \"application/json\" } });\n}\n\nconst css = `\nbody {\n font-family: Arial, sans-serif;\n margin: 0;\n padding: 20px;\n box-sizing: border-box;\n background-color: #f0f0f0;\n}\n\n.app {\n max-width: 1200px;\n margin: 0 auto;\n width: 100%;\n box-sizing: border-box;\n}\n\nh1 {\n text-align: center;\n color: #333;\n}\n\n.controls {\n display: flex;\n justify-content: center;\n align-items: center;\n margin-bottom: 20px;\n gap: 20px;\n}\n\n.control-group {\n display: flex;\n gap: 3px;\n align-items: center;\n}\n\ninput {\n padding: 8px;\n margin-right: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n}\n\nbutton {\n padding: 8px 16px;\n background-color: #4CAF50;\n white-space: nowrap;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n}\n\nbutton:hover {\n background-color: #45a049;\n}\n\n.categories {\n display: grid;\n grid-template-columns: repeat(auto-fill, minmax(250px, 1fr));\n gap: 20px;\n width: 100%;\n max-width: 1200px;\n margin: 0 auto;\n}\n\n.category {\n background-color: #fff;\n border-radius: 8px;\n padding: 16px;\n min-height: 150px;\n box-shadow: 0 2px 4px rgba(0,0,0,0.1);\n}\n\n.category h2 {\n margin-top: 0;\n color: #333;\n border-bottom: 2px solid #4CAF50;\n padding-bottom: 8px;\n}\n\n.card {\n width: 100%;\n background-color: #f9f9f9;\n border: 1px solid #ddd;\n border-radius: 4px;\n padding: 8px;\n margin-bottom: 8px;\n cursor: move;\n}\n\n.card:hover {\n background-color: #e9e9e9;\n}\n\n.card-wrapper {\n position: relative;\n}\n\n.delete-card {\n position: absolute;\n top: 5px;\n right: 5px;\n background: none;\n border: none;\n color: #999;\n font-size: 16px;\n cursor: pointer;\n padding: 0;\n line-height: 1;\n transition: color 0.3s ease;\n opacity: 0;\n}\n\n.card-wrapper:hover .delete-card {\n opacity: 1;\n}\n\n.category-header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n}\n\n.delete-category {\n background: none;\n border: none;\n color: #999;\n font-size: 18px;\n cursor: pointer;\n padding: 0;\n line-height: 1;\n transition: color 0.3s ease;\n}\n\n.delete-category:hover {\n color: #ff4444;\n}\n\n.delete-category:focus { outline: none; }\n\n.text-representation {\n margin-top: 20px;\n text-align: center;\n}\n\n.text-representation textarea {\n width: 100%;\n max-width: 600px;\n height: 200px;\n margin-bottom: 10px;\n padding: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n resize: vertical;\n}\n\n.footer {\n margin-top: 20px;\n text-align: center;\n}\n\n.footer a {\n color: #4CAF50;\n text-decoration: none;\n}\n\n.footer a:hover {\n text-decoration: underline;\n}\n`;","/** @jsxImportSource https://esm.sh/react */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction App() {\n const [categories, setCategories] = useState([]);\n const [newCategoryName, setNewCategoryName] = useState(\"\");\n const [newCardContent, setNewCardContent] = useState(\"\");\n const [textRepresentation, setTextRepresentation] = useState(\"\");\n\n useEffect(() => {\n fetchCategories();\n }, []);\n\n useEffect(() => {\n setTextRepresentation(categoriesToText(categories));\n }, [categories]);\n\n const fetchCategories = async () => {\n try {\n const response = await fetch(\"/categories\");\n if (response.ok) {\n const data = await response.json();\n setCategories(data);\n } else {\n console.error(\"Failed to fetch categories\");\n }\n } catch (error) {\n console.error(\"Error fetching categories:\", error);\n }\n };\n\n const addCategory = async () => {\n if (newCategoryName.trim()) {\n try {\n const response = await fetch(\"/categories\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ name: newCategoryName }),\n });\n if (response.ok) {\n setNewCategoryName(\"\");\n fetchCategories();\n } else {\n console.error(\"Failed to add category\");\n }\n } catch (error) {\n console.error(\"Error adding category:\", error);\n }\n }\n };\n\n const addCard = async (categoryId) => {\n if (newCardContent.trim()) {\n try {\n const response = await fetch(\"/cards\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ content: newCardContent, categoryId }),\n });\n if (response.ok) {\n setNewCardContent(\"\");\n fetchCategories();\n } else {\n console.error(\"Failed to add card\");\n }\n } catch (error) {\n console.error(\"Error adding card:\", error);\n }\n }\n };\n\n const deleteCategory = async (categoryId) => {\n try {\n const response = await fetch(`/categories/${categoryId}`, {\n method: \"DELETE\",\n });\n if (response.ok) {\n fetchCategories();\n } else {\n console.error(\"Failed to delete category\");\n }\n } catch (error) {\n console.error(\"Error deleting category:\", error);\n }\n };\n\n const deleteCard = async (cardId) => {\n try {\n const response = await fetch(`/cards/${cardId}`, {\n method: \"DELETE\",\n });\n if (response.ok) {\n fetchCategories();\n } else {\n console.error(\"Failed to delete card\");\n }\n } catch (error) {\n console.error(\"Error deleting card:\", error);\n }\n };\n\n const categoriesToText = (categories) => {\n return categories.map(category => {\n const cardsList = category.cards.map(card => `- ${card.content}`).join('\\n');\n return `${category.name}\\n${cardsList}`;\n }).join('\\n\\n');\n };\n\n const textToCategories = (text) => {\n const lines = text.split('\\n');\n const newCategories = [];\n let currentCategory = null;\n\n lines.forEach(line => {\n line = line.trim();\n if (line === '') return;\n\n if (!line.startsWith('-')) {\n currentCategory = { name: line, cards: [] };\n newCategories.push(currentCategory);\n } else if (currentCategory) {\n currentCategory.cards.push({ content: line.substring(1).trim() });\n }\n });\n\n return newCategories;\n };\n\n const handleTextChange = (e) => {\n setTextRepresentation(e.target.value);\n };\n\n const saveTextRepresentation = async () => {\n const newCategories = textToCategories(textRepresentation);\n try {\n const response = await fetch(\"/save\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(newCategories),\n });\n if (response.ok) {\n const updatedCategories = await response.json();\n setCategories(updatedCategories);\n console.log(\"Categories updated successfully\");\n } else {\n const errorData = await response.json();\n console.error(\"Failed to save changes:\", errorData);\n alert(`Failed to save changes: ${errorData.error}\\nDetails: ${errorData.details}`);\n }\n } catch (error) {\n console.error(\"Error saving changes:\", error);\n alert(`Error saving changes: ${error.message}`);\n }\n };\n\n return (\n

Card Sorting App

\n setNewCategoryName(e.target.value)}\n placeholder=\"New category name\"\n />\n \n

\n {categories.map((category) => (\n

{category.name}

\n \n

\n {card.content}\n \n

\n setNewCardContent(e.target.value)}\n placeholder=\"New card content\"\n />\n \n

\n ))}\n

Text Representation

\n \n \n

\n );\n}\n\nfunction client() {\n const root = createRoot(document.getElementById(\"root\"));\n root.render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 1;\n const KEY = \"cardSortDragDropApp\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_categories_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_cards_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT NOT NULL,\n category_id INTEGER,\n FOREIGN KEY (category_id) REFERENCES ${KEY}_categories_${SCHEMA_VERSION}(id)\n )\n `);\n\n const url = new URL(request.url);\n const path = url.pathname;\n\n if (path === \"/\" || path === \"\") {\n return new Response(`\n \n \n \n \n \n Card Sorting App\n \n \n \n

\n \n \n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n if (path === \"/categories\" && request.method === \"GET\") {\n try {\n const categories = await sqlite.execute(`SELECT * FROM ${KEY}_categories_${SCHEMA_VERSION}`);\n const cards = await sqlite.execute(`SELECT * FROM ${KEY}_cards_${SCHEMA_VERSION}`);\n \n const categoriesWithCards = categories.rows.map(category => ({\n ...category,\n cards: cards.rows.filter(card => card.category_id === category.id)\n }));\n\n return new Response(JSON.stringify(categoriesWithCards), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error fetching categories:\", error);\n return new Response(JSON.stringify({ error: \"Failed to fetch categories\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n if (path === \"/categories\" && request.method === \"POST\") {\n try {\n const { name } = await request.json();\n await sqlite.execute(`INSERT INTO ${KEY}_categories_${SCHEMA_VERSION} (name) VALUES (?)`, [name]);\n return new Response(\"Category added\", { status: 201 });\n } catch (error) {\n console.error(\"Error adding category:\", error);\n return new Response(JSON.stringify({ error: \"Failed to add category\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n if (path === \"/cards\" && request.method === \"POST\") {\n try {\n const { content, categoryId } = await request.json();\n await sqlite.execute(`INSERT INTO ${KEY}_cards_${SCHEMA_VERSION} (content, category_id) VALUES (?, ?)`, [content, categoryId]);\n return new Response(\"Card added\", { status: 201 });\n } catch (error) {\n console.error(\"Error adding card:\", error);\n return new Response(JSON.stringify({ error: \"Failed to add card\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n if (path.startsWith(\"/categories/\") && request.method === \"DELETE\") {\n try {\n const categoryId = path.split(\"/\")[2];\n await sqlite.execute(`DELETE FROM ${KEY}_categories_${SCHEMA_VERSION} WHERE id = ?`, [categoryId]);\n await sqlite.execute(`DELETE FROM ${KEY}_cards_${SCHEMA_VERSION} WHERE category_id = ?`, [categoryId]);\n return new Response(\"Category deleted\", { status: 200 });\n } catch (error) {\n console.error(\"Error deleting category:\", error);\n return new Response(JSON.stringify({ error: \"Failed to delete category\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n if (path.startsWith(\"/cards/\") && request.method === \"DELETE\") {\n try {\n const cardId = path.split(\"/\")[2];\n await sqlite.execute(`DELETE FROM ${KEY}_cards_${SCHEMA_VERSION} WHERE id = ?`, [cardId]);\n return new Response(\"Card deleted\", { status: 200 });\n } catch (error) {\n console.error(\"Error deleting card:\", error);\n return new Response(JSON.stringify({ error: \"Failed to delete card\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n if (path === \"/save\" && request.method === \"POST\") {\n try {\n const newCategories = await request.json();\n \n await sqlite.execute('BEGIN TRANSACTION');\n\n await sqlite.execute(`DELETE FROM ${KEY}_categories_${SCHEMA_VERSION}`);\n await sqlite.execute(`DELETE FROM ${KEY}_cards_${SCHEMA_VERSION}`);\n\n for (const category of newCategories) {\n const result = await sqlite.execute(\n `INSERT INTO ${KEY}_categories_${SCHEMA_VERSION} (name) VALUES (?)`,\n [category.name]\n );\n const categoryId = result.lastInsertId;\n\n for (const card of category.cards) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_cards_${SCHEMA_VERSION} (content, category_id) VALUES (?, ?)`,\n [card.content, categoryId]\n );\n }\n }\n\n await sqlite.execute('COMMIT');\n\n const updatedCategories = await sqlite.execute(`SELECT * FROM ${KEY}_categories_${SCHEMA_VERSION}`);\n const updatedCards = await sqlite.execute(`SELECT * FROM ${KEY}_cards_${SCHEMA_VERSION}`);\n \n const categoriesWithCards = updatedCategories.rows.map(category => ({\n ...category,\n cards: updatedCards.rows.filter(card => card.category_id === category.id)\n }));\n\n return new Response(JSON.stringify(categoriesWithCards), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error saving changes:\", error);\n await sqlite.execute('ROLLBACK');\n return new Response(JSON.stringify({ \n error: \"Failed to save changes\",\n details: error.message\n }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n\n return new Response(\"Not Found\", { status: 404 });\n}\n\nconst css = `\n body {\n font-family: Arial, sans-serif;\n line-height: 1.6;\n margin: 0;\n padding: 20px;\n background-color: #f4f4f4;\n }\n .app {\n max-width: 800px;\n margin: 0 auto;\n background-color: #fff;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 0 10px rgba(0,0,0,0.1);\n }\n h1 {\n text-align: center;\n color: #333;\n }\n .controls {\n margin-bottom: 20px;\n }\n input[type=\"text\"] {\n width: 70%;\n padding: 8px;\n margin-right: 10px;\n }\n button {\n padding: 8px 15px;\n background-color: #007bff;\n color: #fff;\n border: none;\n cursor: pointer;\n }\n button:hover {\n background-color: #0056b3;\n }\n .category {\n background-color: #f9f9f9;\n border: 1px solid #ddd;\n padding: 10px;\n margin-bottom: 10px;\n border-radius: 5px;\n }\n ul {\n list-style-type: none;\n padding: 0;\n }\n li {\n background-color: #fff;\n border: 1px solid #eee;\n padding: 5px;\n margin-bottom: 5px;\n display: flex;\n justify-content: space-between;\n align-items: center;\n }\n .text-representation {\n margin-top: 20px;\n }\n textarea {\n width: 100%;\n height: 200px;\n margin-bottom: 10px;\n }\n`;","createdAt",["D",1727802982369],"branchVersion","branchId","a57cee7e-2761-11f0-86ff-569c3dd06744","id","a57c9b7c-2761-11f0-86ff-569c3dd06744","cardSortDragDropApp",["D",1746196079018],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","4da41b95-98f3-4ccd-b2bf-bd1a5558f69c","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","cd9ed03e-e204-4250-b49c-f7aeab76bc29","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":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",29,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","trob","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybXFIWGhwanQ4bmJSeVgwWmw5MUdIS0ZaOEgifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_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":150,"_79":151,"_81":152,"_83":25},"tree",[144],"files",[144],"counts",{"_133":61,"_134":135,"_136":61,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"a65778c8-2761-11f0-86ff-569c3dd06744","parentId","latest",["D",1727802982369],27,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":61,"_143":61},"connections",{"_141":61,"_142":61},"count","unfilledCount","emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":145,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1727802982369],"children",[],[28],["D",1746196079018],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":49,"_195":-5,"_196":-7,"_197":-7,"_198":61,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":85,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v28