[{"_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",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/routes/messages.ts","latestPath","fileId","c8806912-3fa5-11f0-8bef-76b3cceeab13","name","messages.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\nimport type { ApiResponse, CreateMessageRequest } from \"../../shared/types.ts\";\nimport { \n createMessage, \n getMessagesBetweenUsers, \n getConversationsForUser,\n markMessagesAsRead,\n getUserBySession \n} from \"../database/queries.ts\";\n\nconst messages = new Hono();\n\n// Middleware to check authentication\nasync function requireAuth(c: any, next: any) {\n const sessionId = getCookie(c, \"session\");\n if (!sessionId) {\n return c.json({\n success: false,\n error: \"Authentication required\"\n }, 401);\n }\n \n const user = await getUserBySession(sessionId);\n if (!user) {\n return c.json({\n success: false,\n error: \"Invalid session\"\n }, 401);\n }\n \n c.set(\"user\", user);\n await next();\n}\n\n// Get all conversations for current user\nmessages.get(\"/conversations\", requireAuth, async (c) => {\n try {\n const user = c.get(\"user\");\n const conversations = await getConversationsForUser(user.id);\n \n return c.json({\n success: true,\n data: { conversations }\n });\n } catch (error) {\n console.error(\"Get conversations error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch conversations\"\n }, 500);\n }\n});\n\n// Get messages between current user and another user\nmessages.get(\"/with/:userId\", requireAuth, async (c) => {\n try {\n const user = c.get(\"user\");\n const otherUserId = parseInt(c.req.param(\"userId\"));\n \n const messageList = await getMessagesBetweenUsers(user.id, otherUserId);\n \n // Mark messages from the other user as read\n await markMessagesAsRead(otherUserId, user.id);\n \n return c.json({\n success: true,\n data: { messages: messageList }\n });\n } catch (error) {\n console.error(\"Get messages error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch messages\"\n }, 500);\n }\n});\n\n// Send a new message\nmessages.post(\"/\", requireAuth, async (c) => {\n try {\n const user = c.get(\"user\");\n const messageData: CreateMessageRequest = await c.req.json();\n \n if (!messageData.content || !messageData.recipient_id) {\n return c.json({\n success: false,\n error: \"Missing required fields\"\n }, 400);\n }\n \n if (messageData.recipient_id === user.id) {\n return c.json({\n success: false,\n error: \"Cannot send message to yourself\"\n }, 400);\n }\n \n const message = await createMessage({\n sender_id: user.id,\n recipient_id: messageData.recipient_id,\n plant_id: messageData.plant_id,\n content: messageData.content\n });\n \n return c.json({\n success: true,\n data: { message }\n });\n } catch (error) {\n console.error(\"Send message error:\", error);\n return c.json({\n success: false,\n error: \"Failed to send message\"\n }, 500);\n }\n});\n\n// Mark messages as read\nmessages.post(\"/mark-read/:userId\", requireAuth, async (c) => {\n try {\n const user = c.get(\"user\");\n const otherUserId = parseInt(c.req.param(\"userId\"));\n \n await markMessagesAsRead(otherUserId, user.id);\n \n return c.json({\n success: true\n });\n } catch (error) {\n console.error(\"Mark messages read error:\", error);\n return c.json({\n success: false,\n error: \"Failed to mark messages as read\"\n }, 500);\n }\n});\n\nexport default messages;","createdAt",["D",1748864171443],"branchVersion","branchId","e61f6046-3fa4-11f0-9a27-76b3cceeab13","id","e61eefd0-3fa4-11f0-9a27-76b3cceeab13","Plantswap",["D",1748863791639],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","8f95f100-3f99-11f0-ad5b-814c56c8abb0","pinnedFileId","d82cf402-3fa5-11f0-9df8-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","1291092d-4555-4d42-9be9-bb35ea8e9131","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",23,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","catalina906","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHdwRlkyOVRrY3MwMTE0NWxMbFFETG9XRXkifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":236,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":237,"_79":238,"_81":239,"_83":24},"tree",[161,169,171],"files",[161,162,163,164,165,166,167,168,169,170,171],"counts",{"_151":61,"_152":132,"_153":61,"_154":155,"_156":157},"contents",[125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":57,"_37":149,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":57,"_37":142,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":57,"_37":134,"_13":61,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"8056dafe-3fa5-11f0-af4a-76b3cceeab13","README.md","8056db9e-3fa5-11f0-af4a-76b3cceeab13","parentId",1,"latest",["D",1748864050374],"# Plant Exchange App\n\nA community platform for sharing, donating, and exchanging plant cuttings, potted plants, and trees.\n\n## Features\n\n- **User Profiles**: Create and manage personal profiles with contact information\n- **Plant Listings**: Upload photos and details of plants available for donation/exchange\n- **Messaging System**: Direct communication between users for coordinating exchanges\n- **Plant Categories**: Support for cuttings, potted plants, and trees\n- **Search & Browse**: Find plants by type, location, or availability\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── auth.ts # User authentication\n│ │ ├── plants.ts # Plant CRUD operations\n│ │ ├── messages.ts # Messaging system\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono app entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── Profile.tsx # User profile management\n│ │ ├── PlantCard.tsx # Plant listing display\n│ │ ├── PlantForm.tsx # Add/edit plant form\n│ │ └── Messages.tsx # Messaging interface\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Tech Stack\n\n- **Backend**: Hono (TypeScript API framework)\n- **Database**: SQLite with Val Town's sqlite service\n- **Frontend**: React with TypeScript\n- **Styling**: TailwindCSS\n- **Storage**: Val Town blob storage for images\n- **Authentication**: Simple session-based auth\n\n## Getting Started\n\nThe app is automatically deployed on Val Town. Visit the HTTP endpoint to start using the application.","label",[129],"85be8096-3fa5-11f0-82f4-76b3cceeab13","shared","815437b6-14ff-40a6-b433-ce5e94630a0c",2,["D",1748864059429],"directory",[139],"8d5a52a8-3fa5-11f0-ad57-76b3cceeab13","backend","9769a4e8-f653-49e9-88ac-f861b8cee418",3,["D",1748864072204],[146],"pulls","branches","forks","envVars",{"_158":61,"_160":61},"connections",{"_158":61,"_159":61},"count","unfilledCount","emptyCount",{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":57,"_37":233,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_173":234,"_26":235},{"_42":229,"_31":221,"_29":215,"_131":147,"_40":41,"_39":148,"_133":57,"_37":230,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_173":231,"_26":232},{"_42":222,"_31":223,"_29":224,"_131":215,"_40":41,"_39":148,"_133":57,"_37":225,"_13":61,"_33":34,"_35":226,"_23":24,"_136":-5,"_173":227,"_26":228},{"_42":212,"_31":213,"_29":214,"_131":215,"_40":41,"_39":216,"_133":57,"_37":217,"_13":61,"_33":34,"_35":218,"_23":24,"_136":-5,"_173":219,"_26":220},{"_42":208,"_31":195,"_29":189,"_131":147,"_40":41,"_39":203,"_133":57,"_37":209,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_173":210,"_26":211},{"_42":200,"_31":201,"_29":202,"_131":189,"_40":41,"_39":203,"_133":24,"_37":204,"_13":61,"_33":34,"_35":205,"_23":24,"_136":-5,"_173":206,"_26":207},{"_42":196,"_31":32,"_29":30,"_131":189,"_40":41,"_39":14,"_133":57,"_37":197,"_13":61,"_33":34,"_35":36,"_23":24,"_136":-5,"_173":198,"_26":199},{"_42":186,"_31":187,"_29":188,"_131":189,"_40":41,"_39":190,"_133":57,"_37":191,"_13":61,"_33":34,"_35":192,"_23":24,"_136":-5,"_173":193,"_26":194},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":57,"_37":183,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_173":184,"_26":185},{"_42":176,"_31":177,"_29":178,"_131":140,"_40":41,"_39":141,"_133":57,"_37":179,"_13":61,"_33":34,"_35":180,"_23":24,"_136":-5,"_173":181,"_26":182},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":57,"_37":172,"_13":61,"_33":20,"_35":135,"_23":24,"_136":-5,"_173":174,"_26":175},["D",1748864050374],"children",[],[129],"85be79e8-3fa5-11f0-82f4-76b3cceeab13","types.ts","85be7a92-3fa5-11f0-82f4-76b3cceeab13",["D",1748864059429],"// Shared types for the Plant Exchange App\n\nexport interface User {\n id: number;\n username: string;\n email: string;\n full_name: string;\n location?: string;\n bio?: string;\n created_at: string;\n}\n\nexport interface Plant {\n id: number;\n user_id: number;\n title: string;\n description: string;\n category: 'cutting' | 'potted' | 'tree';\n availability: 'available' | 'pending' | 'exchanged';\n image_url?: string;\n location?: string;\n created_at: string;\n updated_at: string;\n // Joined data\n user?: User;\n}\n\nexport interface Message {\n id: number;\n sender_id: number;\n recipient_id: number;\n plant_id?: number;\n content: string;\n created_at: string;\n read: boolean;\n // Joined data\n sender?: User;\n recipient?: User;\n plant?: Plant;\n}\n\nexport interface Conversation {\n other_user: User;\n last_message: Message;\n unread_count: number;\n}\n\nexport interface CreateUserRequest {\n username: string;\n email: string;\n full_name: string;\n location?: string;\n bio?: string;\n}\n\nexport interface CreatePlantRequest {\n title: string;\n description: string;\n category: 'cutting' | 'potted' | 'tree';\n location?: string;\n image?: File;\n}\n\nexport interface CreateMessageRequest {\n recipient_id: number;\n plant_id?: number;\n content: string;\n}\n\nexport interface LoginRequest {\n username: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[139,177],["D",1748864059429],[170],[139],"beb371ae-3fa5-11f0-8ffd-76b3cceeab13","plants.ts","beb37280-3fa5-11f0-8ffd-76b3cceeab13","a4ebf7be-3104-47f3-9fd7-8f7f22e2b8b5",6,["D",1748864155000],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport type { ApiResponse, CreatePlantRequest } from \"../../shared/types.ts\";\nimport { \n createPlant, \n getPlantById, \n getAllPlants, \n getPlantsByUser,\n updatePlant,\n deletePlant,\n getUserBySession \n} from \"../database/queries.ts\";\n\nconst plants = new Hono();\n\n// Middleware to check authentication\nasync function requireAuth(c: any, next: any) {\n const sessionId = getCookie(c, \"session\");\n if (!sessionId) {\n return c.json({\n success: false,\n error: \"Authentication required\"\n }, 401);\n }\n \n const user = await getUserBySession(sessionId);\n if (!user) {\n return c.json({\n success: false,\n error: \"Invalid session\"\n }, 401);\n }\n \n c.set(\"user\", user);\n await next();\n}\n\n// Get all plants with optional filtering\nplants.get(\"/\", async (c) => {\n try {\n const category = c.req.query(\"category\");\n const availability = c.req.query(\"availability\") || \"available\";\n \n const plantList = await getAllPlants(category, availability);\n \n return c.json({\n success: true,\n data: { plants: plantList }\n });\n } catch (error) {\n console.error(\"Get plants error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch plants\"\n }, 500);\n }\n});\n\n// Get single plant by ID\nplants.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const plant = await getPlantById(id);\n \n if (!plant) {\n return c.json({\n success: false,\n error: \"Plant not found\"\n }, 404);\n }\n \n return c.json({\n success: true,\n data: { plant }\n });\n } catch (error) {\n console.error(\"Get plant error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch plant\"\n }, 500);\n }\n});\n\n// Get plants by user\nplants.get(\"/user/:userId\", async (c) => {\n try {\n const userId = parseInt(c.req.param(\"userId\"));\n const userPlants = await getPlantsByUser(userId);\n \n return c.json({\n success: true,\n data: { plants: userPlants }\n });\n } catch (error) {\n console.error(\"Get user plants error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch user plants\"\n }, 500);\n }\n});\n\n// Create new plant\nplants.post(\"/\", requireAuth, async (c) => {\n try {\n const user = c.get(\"user\");\n const formData = await c.req.formData();\n \n const title = formData.get(\"title\") as string;\n const description = formData.get(\"description\") as string;\n const category = formData.get(\"category\") as \"cutting\" | \"potted\" | \"tree\";\n const location = formData.get(\"location\") as string;\n const imageFile = formData.get(\"image\") as File;\n \n if (!title || !description || !category) {\n return c.json({\n success: false,\n error: \"Missing required fields\"\n }, 400);\n }\n \n let imageUrl: string | undefined;\n \n // Handle image upload if provided\n if (imageFile && imageFile.size > 0) {\n try {\n const imageBuffer = await imageFile.arrayBuffer();\n const imageKey = `plant-images/${user.id}-${Date.now()}-${imageFile.name}`;\n \n // Store image as base64 in blob storage\n const base64Image = btoa(String.fromCharCode(...new Uint8Array(imageBuffer)));\n await blob.setJSON(imageKey, {\n data: base64Image,\n contentType: imageFile.type,\n filename: imageFile.name\n });\n \n imageUrl = `/api/images/${imageKey}`;\n } catch (imageError) {\n console.error(\"Image upload error:\", imageError);\n // Continue without image rather than failing the whole request\n }\n }\n \n const plantData = {\n user_id: user.id,\n title,\n description,\n category,\n availability: \"available\" as const,\n image_url: imageUrl,\n location: location || undefined\n };\n \n const plant = await createPlant(plantData);\n \n return c.json({\n success: true,\n data: { plant }\n });\n } catch (error) {\n console.error(\"Create plant error:\", error);\n return c.json({\n success: false,\n error: \"Failed to create plant\"\n }, 500);\n }\n});\n\n// Update plant\nplants.put(\"/:id\", requireAuth, async (c) => {\n try {\n const user = c.get(\"user\");\n const id = parseInt(c.req.param(\"id\"));\n \n const existingPlant = await getPlantById(id);\n if (!existingPlant || existingPlant.user_id !== user.id) {\n return c.json({\n success: false,\n error: \"Plant not found or unauthorized\"\n }, 404);\n }\n \n const updates = await c.req.json();\n const plant = await updatePlant(id, updates);\n \n return c.json({\n success: true,\n data: { plant }\n });\n } catch (error) {\n console.error(\"Update plant error:\", error);\n return c.json({\n success: false,\n error: \"Failed to update plant\"\n }, 500);\n }\n});\n\n// Delete plant\nplants.delete(\"/:id\", requireAuth, async (c) => {\n try {\n const user = c.get(\"user\");\n const id = parseInt(c.req.param(\"id\"));\n \n const existingPlant = await getPlantById(id);\n if (!existingPlant || existingPlant.user_id !== user.id) {\n return c.json({\n success: false,\n error: \"Plant not found or unauthorized\"\n }, 404);\n }\n \n await deletePlant(id);\n \n return c.json({\n success: true\n });\n } catch (error) {\n console.error(\"Delete plant error:\", error);\n return c.json({\n success: false,\n error: \"Failed to delete plant\"\n }, 500);\n }\n});\n\nexport default plants;",[],[146,195,187],"routes","c8806854-3fa5-11f0-8bef-76b3cceeab13",["D",1748864171443],[],[146,195,32],"ae168f16-3fa5-11f0-8ffd-76b3cceeab13","auth.ts","ae169006-3fa5-11f0-8ffd-76b3cceeab13",5,["D",1748864127123],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getCookie, setCookie, deleteCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\nimport type { ApiResponse, CreateUserRequest, LoginRequest } from \"../../shared/types.ts\";\nimport { \n createUser, \n getUserByUsername, \n getUserBySession, \n createSession, \n deleteSession \n} from \"../database/queries.ts\";\n\nconst auth = new Hono();\n\n// Register new user\nauth.post(\"/register\", async (c) => {\n try {\n const userData: CreateUserRequest = await c.req.json();\n \n // Check if username already exists\n const existingUser = await getUserByUsername(userData.username);\n if (existingUser) {\n return c.json({\n success: false,\n error: \"Username already exists\"\n }, 400);\n }\n \n const user = await createUser(userData);\n const sessionId = await createSession(user.id);\n \n setCookie(c, \"session\", sessionId, {\n httpOnly: true,\n secure: true,\n sameSite: \"Strict\",\n maxAge: 7 * 24 * 60 * 60 // 7 days\n });\n \n return c.json({\n success: true,\n data: { user }\n });\n } catch (error) {\n console.error(\"Registration error:\", error);\n return c.json({\n success: false,\n error: \"Failed to register user\"\n }, 500);\n }\n});\n\n// Login user (simple username-based login for demo)\nauth.post(\"/login\", async (c) => {\n try {\n const { username }: LoginRequest = await c.req.json();\n \n const user = await getUserByUsername(username);\n if (!user) {\n return c.json({\n success: false,\n error: \"User not found\"\n }, 404);\n }\n \n const sessionId = await createSession(user.id);\n \n setCookie(c, \"session\", sessionId, {\n httpOnly: true,\n secure: true,\n sameSite: \"Strict\",\n maxAge: 7 * 24 * 60 * 60 // 7 days\n });\n \n return c.json({\n success: true,\n data: { user }\n });\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json({\n success: false,\n error: \"Failed to login\"\n }, 500);\n }\n});\n\n// Get current user\nauth.get(\"/me\", async (c) => {\n try {\n const sessionId = getCookie(c, \"session\");\n if (!sessionId) {\n return c.json({\n success: false,\n error: \"Not authenticated\"\n }, 401);\n }\n \n const user = await getUserBySession(sessionId);\n if (!user) {\n deleteCookie(c, \"session\");\n return c.json({\n success: false,\n error: \"Invalid session\"\n }, 401);\n }\n \n return c.json({\n success: true,\n data: { user }\n });\n } catch (error) {\n console.error(\"Get user error:\", error);\n return c.json({\n success: false,\n error: \"Failed to get user\"\n }, 500);\n }\n});\n\n// Logout user\nauth.post(\"/logout\", async (c) => {\n try {\n const sessionId = getCookie(c, \"session\");\n if (sessionId) {\n await deleteSession(sessionId);\n }\n \n deleteCookie(c, \"session\");\n \n return c.json({\n success: true\n });\n } catch (error) {\n console.error(\"Logout error:\", error);\n return c.json({\n success: false,\n error: \"Failed to logout\"\n }, 500);\n }\n});\n\nexport default auth;",[],[146,195,201],"ae169bd2-3fa5-11f0-8ffd-76b3cceeab13",["D",1748864127123],[166,167,168],[146,195],"a449dcfe-3fa5-11f0-8d41-76b3cceeab13","queries.ts","a449ddb2-3fa5-11f0-8d41-76b3cceeab13","121e08ac-8cd9-414c-8fc4-ad315c169330",4,["D",1748864110685],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, Plant, Message, Conversation } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(userData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO users (username, email, full_name, location, bio) \n VALUES (?, ?, ?, ?, ?) RETURNING *`,\n [userData.username, userData.email, userData.full_name, userData.location || null, userData.bio || null]\n );\n return result[0] as User;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM users WHERE id = ?`, [id]);\n return result[0] as User || null;\n}\n\nexport async function getUserByUsername(username: string): Promise {\n const result = await sqlite.execute(`SELECT * FROM users WHERE username = ?`, [username]);\n return result[0] as User || null;\n}\n\nexport async function updateUser(id: number, updates: Partial): Promise {\n const fields = Object.keys(updates).filter(key => key !== 'id' && key !== 'created_at');\n if (fields.length === 0) return getUserById(id);\n \n const setClause = fields.map(field => `${field} = ?`).join(', ');\n const values = fields.map(field => updates[field as keyof User]);\n \n await sqlite.execute(\n `UPDATE users SET ${setClause} WHERE id = ?`,\n [...values, id]\n );\n return getUserById(id);\n}\n\n// Plant queries\nexport async function createPlant(plantData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO plants (user_id, title, description, category, availability, image_url, location) \n VALUES (?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n [\n plantData.user_id,\n plantData.title,\n plantData.description,\n plantData.category,\n plantData.availability || 'available',\n plantData.image_url || null,\n plantData.location || null\n ]\n );\n return result[0] as Plant;\n}\n\nexport async function getPlantById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT p.*, u.username, u.full_name, u.location as user_location\n FROM plants p\n JOIN users u ON p.user_id = u.id\n WHERE p.id = ?`,\n [id]\n );\n \n if (!result[0]) return null;\n \n const row = result[0] as any;\n return {\n ...row,\n user: {\n id: row.user_id,\n username: row.username,\n full_name: row.full_name,\n location: row.user_location,\n email: '', // Don't expose email in plant listings\n bio: '',\n created_at: ''\n }\n } as Plant;\n}\n\nexport async function getPlantsByUser(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM plants WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n return result as Plant[];\n}\n\nexport async function getAllPlants(category?: string, availability?: string): Promise {\n let query = `\n SELECT p.*, u.username, u.full_name, u.location as user_location\n FROM plants p\n JOIN users u ON p.user_id = u.id\n WHERE 1=1\n `;\n const params: any[] = [];\n \n if (category) {\n query += ` AND p.category = ?`;\n params.push(category);\n }\n \n if (availability) {\n query += ` AND p.availability = ?`;\n params.push(availability);\n }\n \n query += ` ORDER BY p.created_at DESC`;\n \n const result = await sqlite.execute(query, params);\n \n return result.map((row: any) => ({\n ...row,\n user: {\n id: row.user_id,\n username: row.username,\n full_name: row.full_name,\n location: row.user_location,\n email: '',\n bio: '',\n created_at: ''\n }\n })) as Plant[];\n}\n\nexport async function updatePlant(id: number, updates: Partial): Promise {\n const fields = Object.keys(updates).filter(key => \n !['id', 'user_id', 'created_at', 'updated_at', 'user'].includes(key)\n );\n if (fields.length === 0) return getPlantById(id);\n \n const setClause = fields.map(field => `${field} = ?`).join(', ');\n const values = fields.map(field => updates[field as keyof Plant]);\n \n await sqlite.execute(\n `UPDATE plants SET ${setClause}, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [...values, id]\n );\n return getPlantById(id);\n}\n\nexport async function deletePlant(id: number): Promise {\n const result = await sqlite.execute(`DELETE FROM plants WHERE id = ?`, [id]);\n return result.length > 0;\n}\n\n// Message queries\nexport async function createMessage(messageData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO messages (sender_id, recipient_id, plant_id, content) \n VALUES (?, ?, ?, ?) RETURNING *`,\n [messageData.sender_id, messageData.recipient_id, messageData.plant_id || null, messageData.content]\n );\n return result[0] as Message;\n}\n\nexport async function getMessagesBetweenUsers(user1Id: number, user2Id: number): Promise {\n const result = await sqlite.execute(\n `SELECT m.*, \n s.username as sender_username, s.full_name as sender_name,\n r.username as recipient_username, r.full_name as recipient_name,\n p.title as plant_title\n FROM messages m\n JOIN users s ON m.sender_id = s.id\n JOIN users r ON m.recipient_id = r.id\n LEFT JOIN plants p ON m.plant_id = p.id\n WHERE (m.sender_id = ? AND m.recipient_id = ?) \n OR (m.sender_id = ? AND m.recipient_id = ?)\n ORDER BY m.created_at ASC`,\n [user1Id, user2Id, user2Id, user1Id]\n );\n \n return result.map((row: any) => ({\n ...row,\n sender: {\n id: row.sender_id,\n username: row.sender_username,\n full_name: row.sender_name,\n email: '',\n bio: '',\n created_at: ''\n },\n recipient: {\n id: row.recipient_id,\n username: row.recipient_username,\n full_name: row.recipient_name,\n email: '',\n bio: '',\n created_at: ''\n },\n plant: row.plant_id ? {\n id: row.plant_id,\n title: row.plant_title,\n user_id: 0,\n description: '',\n category: 'cutting' as const,\n availability: 'available' as const,\n created_at: '',\n updated_at: ''\n } : undefined\n })) as Message[];\n}\n\nexport async function getConversationsForUser(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT DISTINCT\n CASE \n WHEN m.sender_id = ? THEN m.recipient_id \n ELSE m.sender_id \n END as other_user_id,\n u.username, u.full_name, u.location,\n (SELECT content FROM messages m2 \n WHERE (m2.sender_id = ? AND m2.recipient_id = other_user_id)\n OR (m2.sender_id = other_user_id AND m2.recipient_id = ?)\n ORDER BY m2.created_at DESC LIMIT 1) as last_content,\n (SELECT created_at FROM messages m2 \n WHERE (m2.sender_id = ? AND m2.recipient_id = other_user_id)\n OR (m2.sender_id = other_user_id AND m2.recipient_id = ?)\n ORDER BY m2.created_at DESC LIMIT 1) as last_created_at,\n (SELECT COUNT(*) FROM messages m2 \n WHERE m2.sender_id = other_user_id AND m2.recipient_id = ? AND m2.read = FALSE) as unread_count\n FROM messages m\n JOIN users u ON (CASE WHEN m.sender_id = ? THEN m.recipient_id ELSE m.sender_id END) = u.id\n WHERE m.sender_id = ? OR m.recipient_id = ?\n ORDER BY last_created_at DESC`,\n [userId, userId, userId, userId, userId, userId, userId, userId, userId]\n );\n \n return result.map((row: any) => ({\n other_user: {\n id: row.other_user_id,\n username: row.username,\n full_name: row.full_name,\n location: row.location,\n email: '',\n bio: '',\n created_at: ''\n },\n last_message: {\n id: 0,\n sender_id: 0,\n recipient_id: 0,\n content: row.last_content,\n created_at: row.last_created_at,\n read: false\n },\n unread_count: row.unread_count\n })) as Conversation[];\n}\n\nexport async function markMessagesAsRead(senderId: number, recipientId: number): Promise {\n await sqlite.execute(\n `UPDATE messages SET read = TRUE \n WHERE sender_id = ? AND recipient_id = ? AND read = FALSE`,\n [senderId, recipientId]\n );\n}\n\n// Session queries\nexport async function createSession(userId: number): Promise {\n const sessionId = crypto.randomUUID();\n const expiresAt = new Date(Date.now() + 7 * 24 * 60 * 60 * 1000); // 7 days\n \n await sqlite.execute(\n `INSERT INTO sessions (id, user_id, expires_at) VALUES (?, ?, ?)`,\n [sessionId, userId, expiresAt.toISOString()]\n );\n \n return sessionId;\n}\n\nexport async function getUserBySession(sessionId: string): Promise {\n const result = await sqlite.execute(\n `SELECT u.* FROM users u\n JOIN sessions s ON u.id = s.user_id\n WHERE s.id = ? AND s.expires_at > CURRENT_TIMESTAMP`,\n [sessionId]\n );\n \n return result[0] as User || null;\n}\n\nexport async function deleteSession(sessionId: string): Promise {\n await sqlite.execute(`DELETE FROM sessions WHERE id = ?`, [sessionId]);\n}",[],[146,221,213],"database","8d5a44e8-3fa5-11f0-ad57-76b3cceeab13","migrations.ts","8d5a4600-3fa5-11f0-ad57-76b3cceeab13",["D",1748864072204],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport async function runMigrations() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n email TEXT UNIQUE NOT NULL,\n full_name TEXT NOT NULL,\n location TEXT,\n bio TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Plants table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n category TEXT NOT NULL CHECK (category IN ('cutting', 'potted', 'tree')),\n availability TEXT NOT NULL DEFAULT 'available' CHECK (availability IN ('available', 'pending', 'exchanged')),\n image_url TEXT,\n location TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE\n )\n `);\n\n // Messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n sender_id INTEGER NOT NULL,\n recipient_id INTEGER NOT NULL,\n plant_id INTEGER,\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n read BOOLEAN DEFAULT FALSE,\n FOREIGN KEY (sender_id) REFERENCES users (id) ON DELETE CASCADE,\n FOREIGN KEY (recipient_id) REFERENCES users (id) ON DELETE CASCADE,\n FOREIGN KEY (plant_id) REFERENCES plants (id) ON DELETE SET NULL\n )\n `);\n\n // Sessions table for simple authentication\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n expires_at DATETIME NOT NULL,\n FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_plants_user_id ON plants (user_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_plants_category ON plants (category)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_plants_availability ON plants (availability)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_messages_sender ON messages (sender_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_messages_recipient ON messages (recipient_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_messages_plant ON messages (plant_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_sessions_user ON sessions (user_id)`);\n\n console.log(\"Database migrations completed successfully\");\n}",[],[146,221,223],"8d5a5492-3fa5-11f0-ad57-76b3cceeab13",["D",1748864072204],[163,164],[146,221],["D",1748864072204],[162,165],[146],["D",1748863791639],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":273,"_274":275,"_276":277,"_278":24,"_279":24,"_280":24,"_281":57,"_282":-5,"_283":-7,"_284":-7,"_285":61,"_286":24,"_287":24,"_288":-5,"_289":24,"_290":24,"_291":24,"_292":-5},"ENV",{"_244":245,"_246":247,"_248":85,"_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","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 · v7