\n \n\n",[],[211,213],"4c2df18a-3fa6-11f0-8959-76b3cceeab13","Profile.tsx","4c2df266-3fa6-11f0-8959-76b3cceeab13","580c0c67-9ff9-4f12-938b-ba72c144f834",15,["D",1748864392362],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { User, ApiResponse } from \"../../shared/types.ts\";\n\ninterface ProfileProps {\n user: User;\n onUpdate: (user: User) => void;\n}\n\nexport default function Profile({ user, onUpdate }: ProfileProps) {\n const [editing, setEditing] = useState(false);\n const [formData, setFormData] = useState({\n full_name: user.full_name,\n email: user.email,\n location: user.location || '',\n bio: user.bio || ''\n });\n const [saving, setSaving] = useState(false);\n const [error, setError] = useState('');\n const [success, setSuccess] = useState('');\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!formData.full_name.trim() || !formData.email.trim()) {\n setError('Name and email are required');\n return;\n }\n \n setSaving(true);\n setError('');\n setSuccess('');\n \n try {\n const response = await fetch(`/api/auth/profile`, {\n method: 'PUT',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n full_name: formData.full_name.trim(),\n email: formData.email.trim(),\n location: formData.location.trim() || null,\n bio: formData.bio.trim() || null\n })\n });\n \n const result: ApiResponse = await response.json();\n \n if (result.success && result.data?.user) {\n onUpdate(result.data.user);\n setEditing(false);\n setSuccess('Profile updated successfully!');\n setTimeout(() => setSuccess(''), 3000);\n } else {\n setError(result.error || 'Failed to update profile');\n }\n } catch (error) {\n console.error('Profile update error:', error);\n setError('Failed to update profile');\n } finally {\n setSaving(false);\n }\n };\n\n const handleCancel = () => {\n setFormData({\n full_name: user.full_name,\n email: user.email,\n location: user.location || '',\n bio: user.bio || ''\n });\n setEditing(false);\n setError('');\n };\n\n return (\n

\n {success && (\n

\n {success}\n

\n )}\n\n {error && (\n

\n {error}\n

\n )}\n\n {editing ? (\n

Edit Profile

\n\n {/* Username (read-only) */}\n

\n \n Username\n \n \n

Username cannot be changed

\n\n {/* Full Name */}\n

\n \n Full Name *\n \n \n

\n\n {/* Email */}\n

\n \n Email *\n \n \n

\n\n {/* Location */}\n

\n \n Location\n \n \n

\n\n {/* Bio */}\n

\n \n Bio\n \n \n

\n\n {/* Action Buttons */}\n

\n \n Cancel\n \n \n {saving ? (\n \n

\n Saving...\n \n ) : (\n 'Save Changes'\n )}\n \n

\n ) : (\n

Profile Information

\n setEditing(true)}\n className=\"px-4 py-2 text-sm font-medium text-green-600 border border-green-600 rounded-md hover:bg-green-50\"\n >\n Edit Profile\n \n

\n\n

\n {/* Profile Header */}\n

\n 👤\n

{user.full_name}

@{user.username}

\n {user.location && (\n

\n 📍\n {user.location}\n

\n )}\n

\n\n {/* Contact Information */}\n

Contact Information

\n Email:\n {user.email}\n

\n Location:\n {user.location || 'Not specified'}\n

\n\n {/* Bio */}\n

About

\n {user.bio || (\n \n No bio provided. Click \"Edit Profile\" to add information about your gardening interests.\n \n )}\n

\n\n {/* Account Details */}\n

Account Details

\n Joined:\n \n {new Date(user.created_at).toLocaleDateString()}\n \n

\n Username:\n @{user.username}\n

\n )}\n

\n );\n}",[],[211,229,221],"components","369aeeb8-3fa6-11f0-a780-76b3cceeab13","PlantForm.tsx","369aef8a-3fa6-11f0-a780-76b3cceeab13",14,["D",1748864356166],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ApiResponse } from \"../../shared/types.ts\";\n\ninterface PlantFormProps {\n onSuccess: () => void;\n onCancel: () => void;\n}\n\nexport default function PlantForm({ onSuccess, onCancel }: PlantFormProps) {\n const [formData, setFormData] = useState({\n title: '',\n description: '',\n category: 'cutting' as 'cutting' | 'potted' | 'tree',\n location: ''\n });\n const [imageFile, setImageFile] = useState(null);\n const [imagePreview, setImagePreview] = useState('');\n const [submitting, setSubmitting] = useState(false);\n const [error, setError] = useState('');\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n };\n\n const handleImageChange = (e: React.ChangeEvent) => {\n const file = e.target.files?.[0];\n if (file) {\n // Check file size (limit to 5MB)\n if (file.size > 5 * 1024 * 1024) {\n setError('Image file must be smaller than 5MB');\n return;\n }\n \n // Check file type\n if (!file.type.startsWith('image/')) {\n setError('Please select an image file');\n return;\n }\n \n setImageFile(file);\n setError('');\n \n // Create preview\n const reader = new FileReader();\n reader.onload = (e) => {\n setImagePreview(e.target?.result as string);\n };\n reader.readAsDataURL(file);\n }\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!formData.title.trim() || !formData.description.trim()) {\n setError('Please fill in all required fields');\n return;\n }\n \n setSubmitting(true);\n setError('');\n \n try {\n const submitData = new FormData();\n submitData.append('title', formData.title.trim());\n submitData.append('description', formData.description.trim());\n submitData.append('category', formData.category);\n if (formData.location.trim()) {\n submitData.append('location', formData.location.trim());\n }\n if (imageFile) {\n submitData.append('image', imageFile);\n }\n \n const response = await fetch('/api/plants', {\n method: 'POST',\n body: submitData\n });\n \n const result: ApiResponse = await response.json();\n \n if (result.success) {\n onSuccess();\n } else {\n setError(result.error || 'Failed to create plant listing');\n }\n } catch (error) {\n console.error('Submit error:', error);\n setError('Failed to create plant listing');\n } finally {\n setSubmitting(false);\n }\n };\n\n const getCategoryIcon = (category: string) => {\n switch (category) {\n case 'cutting': return '🌱';\n case 'potted': return '🪴';\n case 'tree': return '🌳';\n default: return '🌿';\n }\n };\n\n return (\n

\n {error && (\n

\n {error}\n

\n )}\n\n {/* Title */}\n

\n \n Plant Title *\n \n \n

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

\n \n Category *\n \n \n \n \n \n \n

\n Choose the type of plant you're offering\n

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

\n \n Description *\n \n \n

\n\n {/* Location */}\n

\n \n Plant Location\n \n \n

\n Where is the plant currently located? (optional)\n

\n\n {/* Image Upload */}\n

\n \n Plant Photo\n \n

\n {imagePreview ? (\n

\n \n {\n setImageFile(null);\n setImagePreview('');\n }}\n className=\"mt-2 text-sm text-red-600 hover:text-red-700\"\n >\n Remove image\n \n

\n ) : (\n

📷

\n )}\n \n

\n \n {imagePreview ? 'Change photo' : 'Upload a photo'}\n \n \n {!imagePreview &&

or drag and drop

}\n

\n {!imagePreview && (\n

PNG, JPG, GIF up to 5MB

\n )}\n

\n\n {/* Action Buttons */}\n

\n \n Cancel\n \n \n {submitting ? (\n \n

\n Creating...\n \n ) : (\n 'Create Plant Listing'\n )}\n \n

\n );\n}",[],[211,229,231],"1f9adee4-3fa6-11f0-913f-76b3cceeab13","PlantCard.tsx","1f9adfa2-3fa6-11f0-913f-76b3cceeab13",13,["D",1748864317578],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Plant, User, ApiResponse } from \"../../shared/types.ts\";\n\ninterface PlantCardProps {\n plant: Plant;\n currentUser: User | null;\n showOwnerActions?: boolean;\n onContactOwner?: (plant: Plant) => void;\n onUpdate?: () => void;\n}\n\nexport default function PlantCard({ \n plant, \n currentUser, \n showOwnerActions = false, \n onContactOwner,\n onUpdate \n}: PlantCardProps) {\n const [showDetails, setShowDetails] = useState(false);\n const [updating, setUpdating] = useState(false);\n\n const getCategoryIcon = (category: string) => {\n switch (category) {\n case 'cutting': return '🌱';\n case 'potted': return '🪴';\n case 'tree': return '🌳';\n default: return '🌿';\n }\n };\n\n const getAvailabilityColor = (availability: string) => {\n switch (availability) {\n case 'available': return 'bg-green-100 text-green-800';\n case 'pending': return 'bg-yellow-100 text-yellow-800';\n case 'exchanged': return 'bg-gray-100 text-gray-800';\n default: return 'bg-gray-100 text-gray-800';\n }\n };\n\n const handleStatusUpdate = async (newStatus: string) => {\n if (!currentUser || !showOwnerActions) return;\n \n setUpdating(true);\n try {\n const response = await fetch(`/api/plants/${plant.id}`, {\n method: 'PUT',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ availability: newStatus })\n });\n \n const result: ApiResponse = await response.json();\n \n if (result.success && onUpdate) {\n onUpdate();\n }\n } catch (error) {\n console.error('Failed to update plant status:', error);\n } finally {\n setUpdating(false);\n }\n };\n\n const handleDelete = async () => {\n if (!currentUser || !showOwnerActions) return;\n \n if (!confirm('Are you sure you want to delete this plant listing?')) {\n return;\n }\n \n setUpdating(true);\n try {\n const response = await fetch(`/api/plants/${plant.id}`, {\n method: 'DELETE'\n });\n \n const result: ApiResponse = await response.json();\n \n if (result.success && onUpdate) {\n onUpdate();\n }\n } catch (error) {\n console.error('Failed to delete plant:', error);\n } finally {\n setUpdating(false);\n }\n };\n\n return (\n

\n {/* Plant Image */}\n

\n {plant.image_url ? (\n \n ) : (\n

{getCategoryIcon(plant.category)}

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

\n \n {getCategoryIcon(plant.category)} {plant.category}\n \n

\n \n {/* Availability Badge */}\n

\n \n {plant.availability}\n \n

\n\n {/* Plant Info */}\n

{plant.title}

\n \n

\n {plant.description}\n

\n \n {/* Owner Info */}\n {plant.user && (\n

\n 👤\n {plant.user.full_name}\n {plant.user.location && (\n <>\n •\n 📍\n {plant.user.location}\n \n )}\n

\n )}\n \n {plant.location && (\n

\n 📍\n {plant.location}\n

\n )}\n\n {/* Action Buttons */}\n

\n {showOwnerActions ? (\n <>\n {/* Owner Actions */}\n

\n handleStatusUpdate(e.target.value)}\n disabled={updating}\n className=\"w-full px-3 py-1 text-sm border border-gray-300 rounded focus:outline-none focus:ring-2 focus:ring-green-500\"\n >\n \n \n \n \n

\n setShowDetails(!showDetails)}\n className=\"px-3 py-1 text-sm text-gray-600 border border-gray-300 rounded hover:bg-gray-50\"\n >\n {showDetails ? 'Less' : 'More'}\n \n \n {updating ? '...' : 'Delete'}\n \n \n ) : (\n <>\n {/* Visitor Actions */}\n setShowDetails(!showDetails)}\n className=\"flex-1 px-3 py-2 text-sm text-gray-600 border border-gray-300 rounded hover:bg-gray-50\"\n >\n {showDetails ? 'Less Info' : 'More Info'}\n \n {currentUser && plant.availability === 'available' && onContactOwner && (\n onContactOwner(plant)}\n className=\"flex-1 px-3 py-2 text-sm bg-green-600 text-white rounded hover:bg-green-700\"\n >\n Contact Owner\n \n )}\n \n )}\n

\n\n {/* Expanded Details */}\n {showDetails && (\n

\n Full Description:\n

{plant.description}

\n \n

\n Category: {plant.category}\n

\n \n

\n Status: {plant.availability}\n

\n \n {plant.location && (\n

\n Plant Location: {plant.location}\n

\n )}\n \n

\n Listed: {new Date(plant.created_at).toLocaleDateString()}\n

\n \n {plant.updated_at !== plant.created_at && (\n

\n Updated: {new Date(plant.updated_at).toLocaleDateString()}\n

\n )}\n

\n );\n}",[],[211,229,239],"64f25058-3fa6-11f0-9b94-76b3cceeab13","Messages.tsx","64f2510c-3fa6-11f0-9b94-76b3cceeab13",16,["D",1748864433914],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Message, Conversation, ApiResponse } from \"../../shared/types.ts\";\n\ninterface MessagesProps {\n currentUser: User;\n}\n\nexport default function Messages({ currentUser }: MessagesProps) {\n const [conversations, setConversations] = useState([]);\n const [selectedConversation, setSelectedConversation] = useState(null);\n const [messages, setMessages] = useState([]);\n const [newMessage, setNewMessage] = useState('');\n const [loading, setLoading] = useState(true);\n const [sending, setSending] = useState(false);\n const messagesEndRef = useRef(null);\n\n useEffect(() => {\n loadConversations();\n }, []);\n\n useEffect(() => {\n if (selectedConversation) {\n loadMessages(selectedConversation.other_user.id);\n }\n }, [selectedConversation]);\n\n useEffect(() => {\n scrollToBottom();\n }, [messages]);\n\n const scrollToBottom = () => {\n messagesEndRef.current?.scrollIntoView({ behavior: \"smooth\" });\n };\n\n const loadConversations = async () => {\n try {\n const response = await fetch('/api/messages/conversations');\n const result: ApiResponse = await response.json();\n \n if (result.success) {\n setConversations(result.data.conversations || []);\n }\n } catch (error) {\n console.error('Failed to load conversations:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const loadMessages = async (otherUserId: number) => {\n try {\n const response = await fetch(`/api/messages/with/${otherUserId}`);\n const result: ApiResponse = await response.json();\n \n if (result.success) {\n setMessages(result.data.messages || []);\n // Mark messages as read\n await fetch(`/api/messages/mark-read/${otherUserId}`, { method: 'POST' });\n // Refresh conversations to update unread counts\n loadConversations();\n }\n } catch (error) {\n console.error('Failed to load messages:', error);\n }\n };\n\n const sendMessage = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!newMessage.trim() || !selectedConversation || sending) {\n return;\n }\n \n setSending(true);\n \n try {\n const response = await fetch('/api/messages', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n recipient_id: selectedConversation.other_user.id,\n content: newMessage.trim()\n })\n });\n \n const result: ApiResponse = await response.json();\n \n if (result.success) {\n setNewMessage('');\n // Reload messages to show the new one\n loadMessages(selectedConversation.other_user.id);\n // Refresh conversations\n loadConversations();\n }\n } catch (error) {\n console.error('Failed to send message:', error);\n } finally {\n setSending(false);\n }\n };\n\n const formatMessageTime = (dateString: string) => {\n const date = new Date(dateString);\n const now = new Date();\n const diffInHours = (now.getTime() - date.getTime()) / (1000 * 60 * 60);\n \n if (diffInHours < 24) {\n return date.toLocaleTimeString([], { hour: '2-digit', minute: '2-digit' });\n } else if (diffInHours < 24 * 7) {\n return date.toLocaleDateString([], { weekday: 'short', hour: '2-digit', minute: '2-digit' });\n } else {\n return date.toLocaleDateString([], { month: 'short', day: 'numeric', hour: '2-digit', minute: '2-digit' });\n }\n };\n\n if (loading) {\n return (\n

\n Loading conversations...\n

\n );\n }\n\n return (\n

\n {/* Conversations List */}\n

Conversations

\n \n

\n {conversations.length === 0 ? (\n

💬

No conversations yet

Start by contacting plant owners!

\n ) : (\n

\n {conversations.map((conversation) => (\n setSelectedConversation(conversation)}\n className={`w-full p-4 text-left hover:bg-gray-50 transition-colors ${\n selectedConversation?.other_user.id === conversation.other_user.id \n ? 'bg-green-50 border-r-2 border-green-500' \n : ''\n }`}\n >\n

\n {conversation.other_user.full_name}\n

\n {conversation.unread_count > 0 && (\n \n {conversation.unread_count}\n \n )}\n

\n @{conversation.other_user.username}\n

\n {conversation.other_user.location && (\n

\n 📍 {conversation.other_user.location}\n

\n )}\n

\n \n {conversation.last_message && (\n

\n {conversation.last_message.content}\n

\n {formatMessageTime(conversation.last_message.created_at)}\n

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

\n )}\n

\n\n {/* Messages Area */}\n

\n {selectedConversation ? (\n <>\n {/* Chat Header */}\n

\n {selectedConversation.other_user.full_name}\n

\n @{selectedConversation.other_user.username}\n {selectedConversation.other_user.location && (\n 📍 {selectedConversation.other_user.location}\n )}\n

\n\n {/* Messages */}\n

\n {messages.length === 0 ? (\n

👋

Start the conversation!

\n ) : (\n messages.map((message) => (\n \n \n

{message.content}

\n {formatMessageTime(message.created_at)}\n

\n ))\n )}\n

\n\n {/* Message Input */}\n

\n \n ) : (\n

💬

Select a conversation

Choose a conversation from the left to start messaging

\n )}\n

\n \n );\n}",[],[211,229,247],"0b2fff3e-3fa6-11f0-bc73-76b3cceeab13","App.tsx","0b300010-3fa6-11f0-bc73-76b3cceeab13",12,["D",1748864283321],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Plant, ApiResponse } from \"../../shared/types.ts\";\nimport PlantCard from \"./PlantCard.tsx\";\nimport PlantForm from \"./PlantForm.tsx\";\nimport Profile from \"./Profile.tsx\";\nimport Messages from \"./Messages.tsx\";\n\ntype View = 'browse' | 'my-plants' | 'add-plant' | 'profile' | 'messages' | 'login' | 'register';\n\nexport default function App() {\n const [currentView, setCurrentView] = useState('browse');\n const [user, setUser] = useState(null);\n const [plants, setPlants] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(\"\");\n const [selectedCategory, setSelectedCategory] = useState(\"\");\n\n // Check authentication on load\n useEffect(() => {\n checkAuth();\n loadPlants();\n }, []);\n\n const checkAuth = async () => {\n try {\n const response = await fetch(\"/api/auth/me\");\n const result: ApiResponse = await response.json();\n \n if (result.success && result.data?.user) {\n setUser(result.data.user);\n }\n } catch (error) {\n console.error(\"Auth check failed:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n const loadPlants = async (category?: string) => {\n try {\n const params = new URLSearchParams();\n if (category) params.append(\"category\", category);\n \n const response = await fetch(`/api/plants?${params}`);\n const result: ApiResponse = await response.json();\n \n if (result.success) {\n setPlants(result.data.plants || []);\n }\n } catch (error) {\n console.error(\"Failed to load plants:\", error);\n }\n };\n\n const handleLogin = async (username: string) => {\n try {\n setError(\"\");\n const response = await fetch(\"/api/auth/login\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ username })\n });\n \n const result: ApiResponse = await response.json();\n \n if (result.success && result.data?.user) {\n setUser(result.data.user);\n setCurrentView('browse');\n } else {\n setError(result.error || \"Login failed\");\n }\n } catch (error) {\n setError(\"Login failed\");\n }\n };\n\n const handleRegister = async (userData: any) => {\n try {\n setError(\"\");\n const response = await fetch(\"/api/auth/register\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(userData)\n });\n \n const result: ApiResponse = await response.json();\n \n if (result.success && result.data?.user) {\n setUser(result.data.user);\n setCurrentView('browse');\n } else {\n setError(result.error || \"Registration failed\");\n }\n } catch (error) {\n setError(\"Registration failed\");\n }\n };\n\n const handleLogout = async () => {\n try {\n await fetch(\"/api/auth/logout\", { method: \"POST\" });\n setUser(null);\n setCurrentView('browse');\n } catch (error) {\n console.error(\"Logout failed:\", error);\n }\n };\n\n const handleCategoryFilter = (category: string) => {\n setSelectedCategory(category);\n loadPlants(category || undefined);\n };\n\n const getCategoryIcon = (category: string) => {\n switch (category) {\n case 'cutting': return '🌱';\n case 'potted': return '🪴';\n case 'tree': return '🌳';\n default: return '🌿';\n }\n };\n\n if (loading) {\n return (\n

\n Loading...\n

\n );\n }\n\n return (\n

\n {/* Header */}\n

setCurrentView('browse')}\n >\n 🌱 Plant Exchange\n

\n \n

\n setCurrentView('browse')}\n className={`px-3 py-2 rounded-md text-sm font-medium ${\n currentView === 'browse' \n ? 'bg-green-100 text-green-700' \n : 'text-gray-500 hover:text-gray-700'\n }`}\n >\n Browse Plants\n \n \n {user ? (\n <>\n setCurrentView('my-plants')}\n className={`px-3 py-2 rounded-md text-sm font-medium ${\n currentView === 'my-plants' \n ? 'bg-green-100 text-green-700' \n : 'text-gray-500 hover:text-gray-700'\n }`}\n >\n My Plants\n \n setCurrentView('add-plant')}\n className={`px-3 py-2 rounded-md text-sm font-medium ${\n currentView === 'add-plant' \n ? 'bg-green-100 text-green-700' \n : 'text-gray-500 hover:text-gray-700'\n }`}\n >\n Add Plant\n \n setCurrentView('messages')}\n className={`px-3 py-2 rounded-md text-sm font-medium ${\n currentView === 'messages' \n ? 'bg-green-100 text-green-700' \n : 'text-gray-500 hover:text-gray-700'\n }`}\n >\n Messages\n \n setCurrentView('profile')}\n className={`px-3 py-2 rounded-md text-sm font-medium ${\n currentView === 'profile' \n ? 'bg-green-100 text-green-700' \n : 'text-gray-500 hover:text-gray-700'\n }`}\n >\n Profile\n \n \n Logout\n \n \n ) : (\n <>\n setCurrentView('login')}\n className={`px-3 py-2 rounded-md text-sm font-medium ${\n currentView === 'login' \n ? 'bg-green-100 text-green-700' \n : 'text-gray-500 hover:text-gray-700'\n }`}\n >\n Login\n \n setCurrentView('register')}\n className={`px-4 py-2 rounded-md text-sm font-medium bg-green-600 text-white hover:bg-green-700 ${\n currentView === 'register' ? 'bg-green-700' : ''\n }`}\n >\n Sign Up\n \n \n )}\n

\n\n {/* Main Content */}\n

\n {error && (\n

\n {error}\n

\n )}\n\n {/* Login Form */}\n {currentView === 'login' && (\n

Login

\n )}\n\n {/* Register Form */}\n {currentView === 'register' && (\n

Create Account

{\n e.preventDefault();\n const formData = new FormData(e.target as HTMLFormElement);\n handleRegister({\n username: formData.get('username'),\n email: formData.get('email'),\n full_name: formData.get('full_name'),\n location: formData.get('location'),\n bio: formData.get('bio')\n });\n }}>\n

\n \n Username *\n \n \n

\n \n Email *\n \n \n

\n \n Full Name *\n \n \n

\n \n Location\n \n \n

\n \n Bio\n \n \n

\n \n Create Account\n \n \n

\n Already have an account?{' '}\n setCurrentView('login')}\n className=\"text-green-600 hover:text-green-700\"\n >\n Login\n \n

\n )}\n\n {/* Browse Plants */}\n {currentView === 'browse' && (\n

Available Plants

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

\n handleCategoryFilter(\"\")}\n className={`px-4 py-2 rounded-full text-sm font-medium ${\n selectedCategory === \"\" \n ? 'bg-green-600 text-white' \n : 'bg-gray-200 text-gray-700 hover:bg-gray-300'\n }`}\n >\n All Plants\n \n {['cutting', 'potted', 'tree'].map(category => (\n handleCategoryFilter(category)}\n className={`px-4 py-2 rounded-full text-sm font-medium category-badge ${\n selectedCategory === category \n ? 'bg-green-600 text-white' \n : 'bg-gray-200 text-gray-700 hover:bg-gray-300'\n }`}\n >\n {getCategoryIcon(category)} {category.charAt(0).toUpperCase() + category.slice(1)}\n \n ))}\n

\n \n {plants.length === 0 ? (\n

🌱

No plants available

Be the first to share a plant with the community!

\n {user && (\n setCurrentView('add-plant')}\n className=\"mt-4 bg-green-600 text-white px-6 py-2 rounded-md hover:bg-green-700\"\n >\n Add Your First Plant\n \n )}\n

\n ) : (\n

\n {plants.map(plant => (\n {\n if (user) {\n setCurrentView('messages');\n // TODO: Open conversation with plant owner\n } else {\n setCurrentView('login');\n }\n }}\n />\n ))}\n

\n )}\n

\n )}\n\n {/* My Plants */}\n {currentView === 'my-plants' && user && (\n

My Plants

\n setCurrentView('add-plant')}\n className=\"bg-green-600 text-white px-4 py-2 rounded-md hover:bg-green-700\"\n >\n Add New Plant\n \n

\n \n

\n )}\n\n {/* Add Plant */}\n {currentView === 'add-plant' && user && (\n

Add New Plant

\n {\n setCurrentView('my-plants');\n loadPlants(); // Refresh the plants list\n }}\n onCancel={() => setCurrentView('my-plants')}\n />\n

\n )}\n\n {/* Profile */}\n {currentView === 'profile' && user && (\n

Profile

\n \n

\n )}\n\n {/* Messages */}\n {currentView === 'messages' && user && (\n

Messages

\n \n

\n )}\n

\n );\n}\n\n// Component for displaying user's plants\nfunction MyPlantsView({ userId }: { userId: number }) {\n const [plants, setPlants] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n loadUserPlants();\n }, [userId]);\n\n const loadUserPlants = async () => {\n try {\n const response = await fetch(`/api/plants/user/${userId}`);\n const result: ApiResponse = await response.json();\n \n if (result.success) {\n setPlants(result.data.plants || []);\n }\n } catch (error) {\n console.error(\"Failed to load user plants:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n if (loading) {\n return (\n

\n );\n }\n\n if (plants.length === 0) {\n return (\n

🪴

No plants yet

Start sharing your plants with the community!

\n );\n }\n\n return (\n

\n {plants.map(plant => (\n \n ))}\n

\n );\n}",[],[211,229,255],"0b303152-3fa6-11f0-bc73-76b3cceeab13",["D",1748864283321],[178,179,180,181,182],[211,229],"def8862a-3fa5-11f0-a15f-76b3cceeab13",["D",1748864209138],[177,183,184],[211],"7215a69a-3fa6-11f0-9fea-76b3cceeab13","index.ts","9769a4e8-f653-49e9-88ac-f861b8cee418",19,["D",1748864455953],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport auth from \"./routes/auth.ts\";\nimport plants from \"./routes/plants.ts\";\nimport messages from \"./routes/messages.ts\";\nimport staticRoutes from \"./routes/static.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 on startup\nawait runMigrations();\n\n// API routes\napp.route(\"/api/auth\", auth);\napp.route(\"/api/plants\", plants);\napp.route(\"/api/messages\", messages);\napp.route(\"/api\", staticRoutes);\n\n// Serve frontend files\napp.get(\"/frontend/*\", (c) => staticRoutes.fetch(c.req.raw));\napp.get(\"/shared/*\", (c) => staticRoutes.fetch(c.req.raw));\n\n// Serve main application\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Basic SEO and meta tags\n const metaTags = `\n \n \n \n \n \n `;\n \n html = html.replace(\"\", `${metaTags}`);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Serve index error:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\n// Catch-all route for SPA routing\napp.get(\"*\", async (c) => {\n try {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n } catch (error) {\n console.error(\"Serve SPA route error:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\nexport default app;",[],[279,271],"backend","cf324cf8-3fa5-11f0-bc73-76b3cceeab13","static.ts","cf324dc0-3fa5-11f0-bc73-76b3cceeab13","a4ebf7be-3104-47f3-9fd7-8f7f22e2b8b5",8,["D",1748864182673],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve uploaded images from blob storage\nstaticRoutes.get(\"/images/:key\", async (c) => {\n try {\n const key = c.req.param(\"key\");\n const imageData = await blob.getJSON(key);\n \n if (!imageData) {\n return c.notFound();\n }\n \n // Convert base64 back to binary\n const binaryString = atob(imageData.data);\n const bytes = new Uint8Array(binaryString.length);\n for (let i = 0; i < binaryString.length; i++) {\n bytes[i] = binaryString.charCodeAt(i);\n }\n \n return new Response(bytes, {\n headers: {\n \"Content-Type\": imageData.contentType || \"image/jpeg\",\n \"Cache-Control\": \"public, max-age=31536000\" // Cache for 1 year\n }\n });\n } catch (error) {\n console.error(\"Serve image error:\", error);\n return c.notFound();\n }\n});\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\nstaticRoutes.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\nexport default staticRoutes;",[],[279,289,281],"routes","beb371ae-3fa5-11f0-8ffd-76b3cceeab13","plants.ts","beb37280-3fa5-11f0-8ffd-76b3cceeab13",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;",[],[279,289,291],"c8806854-3fa5-11f0-8bef-76b3cceeab13","messages.ts","c8806912-3fa5-11f0-8bef-76b3cceeab13",7,["D",1748864171443],"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;",[],[279,289,299],"6fa6aa26-3fa6-11f0-87aa-76b3cceeab13","auth.ts","ae169006-3fa5-11f0-8ffd-76b3cceeab13",18,["D",1748864451867],"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 updateUser \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\n// Update user profile\nauth.put(\"/profile\", 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 const updates = await c.req.json();\n const updatedUser = await updateUser(user.id, updates);\n \n if (!updatedUser) {\n return c.json({\n success: false,\n error: \"Failed to update profile\"\n }, 500);\n }\n \n return c.json({\n success: true,\n data: { user: updatedUser }\n });\n } catch (error) {\n console.error(\"Profile update error:\", error);\n return c.json({\n success: false,\n error: \"Failed to update profile\"\n }, 500);\n }\n});\n\nexport default auth;",[],[279,289,307],"ae169bd2-3fa5-11f0-8ffd-76b3cceeab13",5,["D",1748864127123],[171,172,173,174],[279,289],"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}",[],[279,328,320],"database","8d5a44e8-3fa5-11f0-ad57-76b3cceeab13","migrations.ts","8d5a4600-3fa5-11f0-ad57-76b3cceeab13",3,["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}",[],[279,328,330],"8d5a5492-3fa5-11f0-ad57-76b3cceeab13",["D",1748864072204],[168,169],[279,328],"8d5a52a8-3fa5-11f0-ad57-76b3cceeab13",["D",1748864072204],[167,170,175],[279],["D",1748863791639],{"_11":12,"_121":70},{"_11":12,"_117":-5,"_69":70,"_31":68,"_118":119,"_120":30},{"_39":108,"_13":16,"_33":36,"_109":74,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":14,"_116":12},"ctx",{"_52":-5,"_140":382,"_383":384,"_385":386,"_387":30,"_388":30,"_389":30,"_390":24,"_391":-5,"_392":-7,"_393":-7,"_394":26,"_395":30,"_396":30,"_397":-5,"_398":30,"_399":30,"_400":30,"_401":-5},"ENV",{"_353":354,"_355":356,"_357":16,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381},"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"]

History · shared