\n \n\n",[],[239,241],"4db53d0c-3fb4-11f0-bc33-76b3cceeab13","SubmissionsList.tsx","4db53dac-3fb4-11f0-bc33-76b3cceeab13","9d891580-8e12-402f-a15f-698a84486ef5",11,["D",1748870407877],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Submission } from \"../../shared/types.ts\";\n\ninterface SubmissionsListProps {\n submissions: Submission[];\n loading: boolean;\n}\n\nexport default function SubmissionsList({ submissions, loading }: SubmissionsListProps) {\n if (loading) {\n return (\n

\n Recent Submissions\n

Loading submissions...

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

\n Recent Submissions\n

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

No submissions yet. Be the first to share your skill!

\n ) : (\n

\n {submissions.map((submission) => (\n \n

\n \n {submission.userName}\n \n \n {submission.type === 'offer' ? '💡 Offering' : '🙋 Requesting'}\n \n

\n {submission.skill}\n

\n {submission.createdAt && (\n

\n {new Date(submission.createdAt).toLocaleDateString()}\n

\n )}\n

\n ))}\n

\n )}\n \n );\n}",[],[239,257,249],"components","45c095ba-3fb4-11f0-8e1d-76b3cceeab13","SubmissionForm.tsx","45c09682-3fb4-11f0-8e1d-76b3cceeab13",10,["D",1748870394533],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Submission, CreateSubmissionRequest } from \"../../shared/types.ts\";\n\ninterface SubmissionFormProps {\n onSubmissionCreated: (submission: Submission) => void;\n}\n\nexport default function SubmissionForm({ onSubmissionCreated }: SubmissionFormProps) {\n const [formData, setFormData] = useState({\n userName: \"\",\n skill: \"\",\n type: \"offer\"\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n setIsSubmitting(true);\n\n try {\n const response = await fetch(\"/api/submissions\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n if (response.ok) {\n const newSubmission = await response.json();\n onSubmissionCreated(newSubmission);\n setFormData({ userName: \"\", skill: \"\", type: \"offer\" });\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to submit\");\n }\n } catch (error) {\n setError(\"Network error occurred\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n };\n\n return (\n

\n Add Your Skill\n

\n \n

\n );\n}",[],[239,257,259],"733b706c-3fb6-11f0-a9a0-76b3cceeab13","SkillForm.tsx","733b7120-3fb6-11f0-a9a0-76b3cceeab13",19,["D",1748871329827],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Skill, CreateSkillRequest } from \"../../shared/types.ts\";\n\ninterface SkillFormProps {\n userName: string;\n onSkillAdded: (skill: Skill) => void;\n}\n\nconst SKILL_CATEGORIES = [\n \"Home & Garden\",\n \"Technology\",\n \"Cooking & Food\",\n \"Transportation\",\n \"Childcare\",\n \"Pet Care\",\n \"Tutoring & Education\",\n \"Arts & Crafts\",\n \"Music & Entertainment\",\n \"Health & Fitness\",\n \"Business & Professional\",\n \"Other\"\n];\n\nexport default function SkillForm({ userName, onSkillAdded }: SkillFormProps) {\n const [formData, setFormData] = useState({\n userName,\n skillName: \"\",\n description: \"\",\n category: \"\",\n type: \"offer\",\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n setError(\"\");\n\n try {\n const response = await fetch(\"/api/skills\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n if (response.ok) {\n const skill = await response.json();\n onSkillAdded(skill);\n \n // Reset form\n setFormData({\n userName,\n skillName: \"\",\n description: \"\",\n category: \"\",\n type: \"offer\",\n });\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to add skill\");\n }\n } catch (err) {\n setError(\"Network error occurred\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: value,\n }));\n };\n\n return (\n

Add New Skill

\n \n {error && (\n

\n {error}\n

\n )}\n\n

\n );\n}",[],[239,257,267],"8696893a-3fb6-11f0-9c02-76b3cceeab13","ProfilesList.tsx","869689ee-3fb6-11f0-9c02-76b3cceeab13",20,["D",1748871362299],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { UserProfile, Skill } from \"../../shared/types.ts\";\n\ninterface ProfilesListProps {\n refreshTrigger?: number;\n}\n\ninterface ProfileWithSkills extends UserProfile {\n skills: (Skill & { userName: string })[];\n}\n\nexport default function ProfilesList({ refreshTrigger }: ProfilesListProps) {\n const [profiles, setProfiles] = useState([]);\n const [loading, setLoading] = useState(true);\n const [filter, setFilter] = useState<'all' | 'offer' | 'request'>('all');\n\n const fetchProfilesAndSkills = async () => {\n try {\n setLoading(true);\n \n // Fetch all profiles and skills in parallel\n const [profilesResponse, skillsResponse] = await Promise.all([\n fetch(\"/api/profiles\"),\n fetch(\"/api/skills\")\n ]);\n\n if (profilesResponse.ok && skillsResponse.ok) {\n const profilesData = await profilesResponse.json();\n const skillsData = await skillsResponse.json();\n\n // Group skills by user\n const skillsByUser = skillsData.reduce((acc: Record, skill: Skill & { userName: string }) => {\n if (!acc[skill.userName]) {\n acc[skill.userName] = [];\n }\n acc[skill.userName].push(skill);\n return acc;\n }, {});\n\n // Combine profiles with their skills\n const profilesWithSkills = profilesData.map((profile: UserProfile) => ({\n ...profile,\n skills: skillsByUser[profile.userName] || []\n }));\n\n setProfiles(profilesWithSkills);\n }\n } catch (error) {\n console.error(\"Error fetching profiles and skills:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchProfilesAndSkills();\n }, [refreshTrigger]);\n\n const filteredProfiles = profiles.filter(profile => {\n if (filter === 'all') return profile.skills.length > 0;\n return profile.skills.some(skill => skill.type === filter);\n });\n\n if (loading) {\n return (\n

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

\n Neighbor Profiles ({filteredProfiles.length})\n

\n \n

\n setFilter('all')}\n className={`px-3 py-1 rounded-full text-sm font-medium ${\n filter === 'all' \n ? 'bg-gray-800 text-white' \n : 'bg-gray-200 text-gray-700 hover:bg-gray-300'\n }`}\n >\n All\n \n setFilter('offer')}\n className={`px-3 py-1 rounded-full text-sm font-medium ${\n filter === 'offer' \n ? 'bg-green-600 text-white' \n : 'bg-green-100 text-green-700 hover:bg-green-200'\n }`}\n >\n 🤝 Offers\n \n setFilter('request')}\n className={`px-3 py-1 rounded-full text-sm font-medium ${\n filter === 'request' \n ? 'bg-blue-600 text-white' \n : 'bg-blue-100 text-blue-700 hover:bg-blue-200'\n }`}\n >\n 🙋 Requests\n \n

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

No profiles found

Be the first to create a profile and add your skills!

\n ) : (\n

\n {filteredProfiles.map((profile) => (\n

\n {profile.userName}\n

\n {profile.location && (\n

📍 {profile.location}

\n )}\n

\n {profile.email && (\n \n ✉️ Contact\n \n )}\n

\n\n {profile.bio && (\n

{profile.bio}

\n )}\n\n

\n {profile.skills\n .filter(skill => filter === 'all' || skill.type === filter)\n .map((skill) => (\n \n \n {skill.type === 'offer' ? '🤝' : '🙋'} {skill.skillName}\n \n {skill.category && (\n \n ({skill.category})\n \n )}\n {skill.description && (\n

\n {skill.description}\n

\n )}\n

\n ))}\n

\n\n

\n Member since {new Date(profile.createdAt!).toLocaleDateString()}\n

\n ))}\n

\n )}\n \n );\n}",[],[239,257,275],"9b0ae71c-3fb6-11f0-861e-76b3cceeab13","ProfileManager.tsx","9b0ae7ee-3fb6-11f0-861e-76b3cceeab13",21,["D",1748871396620],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport ProfileForm from \"./ProfileForm.tsx\";\nimport SkillForm from \"./SkillForm.tsx\";\nimport type { UserProfile, Skill } from \"../../shared/types.ts\";\n\ninterface ProfileManagerProps {\n onProfileUpdate: () => void;\n}\n\nexport default function ProfileManager({ onProfileUpdate }: ProfileManagerProps) {\n const [currentUser, setCurrentUser] = useState(\"\");\n const [userProfile, setUserProfile] = useState(null);\n const [userSkills, setUserSkills] = useState([]);\n const [showProfileForm, setShowProfileForm] = useState(false);\n const [loading, setLoading] = useState(false);\n\n const fetchUserData = async (userName: string) => {\n if (!userName.trim()) return;\n \n setLoading(true);\n try {\n // Fetch profile and skills in parallel\n const [profileResponse, skillsResponse] = await Promise.all([\n fetch(`/api/profiles/${userName}`),\n fetch(`/api/profiles/${userName}/skills`)\n ]);\n\n if (profileResponse.ok) {\n const profile = await profileResponse.json();\n setUserProfile(profile);\n } else {\n setUserProfile(null);\n }\n\n if (skillsResponse.ok) {\n const skills = await skillsResponse.json();\n setUserSkills(skills);\n } else {\n setUserSkills([]);\n }\n } catch (error) {\n console.error(\"Error fetching user data:\", error);\n setUserProfile(null);\n setUserSkills([]);\n } finally {\n setLoading(false);\n }\n };\n\n const handleUserNameSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (currentUser.trim()) {\n fetchUserData(currentUser.trim());\n }\n };\n\n const handleProfileCreated = (profile: UserProfile) => {\n setUserProfile(profile);\n setShowProfileForm(false);\n onProfileUpdate();\n };\n\n const handleSkillAdded = (skill: Skill) => {\n setUserSkills(prev => [skill, ...prev]);\n onProfileUpdate();\n };\n\n const toggleSkillStatus = async (skillId: number, isActive: boolean) => {\n try {\n const response = await fetch(`/api/skills/${skillId}/toggle`, {\n method: \"PATCH\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ isActive }),\n });\n\n if (response.ok) {\n setUserSkills(prev => \n prev.map(skill => \n skill.id === skillId ? { ...skill, isActive } : skill\n )\n );\n onProfileUpdate();\n }\n } catch (error) {\n console.error(\"Error toggling skill status:\", error);\n }\n };\n\n return (\n

\n {/* User Selection */}\n

Manage Your Profile

\n \n

\n\n {/* Profile Management */}\n {currentUser && (\n <>\n {/* Profile Section */}\n

Profile Information

\n setShowProfileForm(!showProfileForm)}\n className=\"bg-gray-600 text-white px-4 py-2 rounded-md hover:bg-gray-700 text-sm\"\n >\n {userProfile ? \"Edit Profile\" : \"Create Profile\"}\n \n

\n\n {userProfile && !showProfileForm ? (\n

Username: {userProfile.userName}

\n {userProfile.email &&

Email: {userProfile.email}

}\n {userProfile.location &&

Location: {userProfile.location}

}\n {userProfile.bio &&

Bio: {userProfile.bio}

}\n

\n Created: {new Date(userProfile.createdAt!).toLocaleDateString()}\n

\n ) : showProfileForm ? (\n \n ) : (\n

No profile found. Create one to get started!

\n )}\n

\n\n {/* Skills Management */}\n {userProfile && (\n <>\n \n\n {/* User's Skills List */}\n

\n Your Skills ({userSkills.length})\n

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

No skills added yet. Add your first skill above!

\n ) : (\n

\n {userSkills.map((skill) => (\n \n

\n \n {skill.type === 'offer' ? '🤝 Offering' : '🙋 Requesting'}\n \n {skill.category && (\n \n {skill.category}\n \n )}\n

{skill.skillName}

\n {skill.description && (\n

{skill.description}

\n )}\n

\n Added: {new Date(skill.createdAt!).toLocaleDateString()}\n

\n \n toggleSkillStatus(skill.id!, !skill.isActive)}\n className={`ml-4 px-3 py-1 rounded text-sm font-medium ${\n skill.isActive\n ? 'bg-red-100 text-red-700 hover:bg-red-200'\n : 'bg-green-100 text-green-700 hover:bg-green-200'\n }`}\n >\n {skill.isActive ? 'Deactivate' : 'Activate'}\n \n

\n ))}\n

\n )}\n

\n \n )}\n \n )}\n \n );\n}",[],[239,257,283],"65caf394-3fb6-11f0-a44c-76b3cceeab13","ProfileForm.tsx","65caf45c-3fb6-11f0-a44c-76b3cceeab13",18,["D",1748871307281],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { UserProfile, CreateProfileRequest } from \"../../shared/types.ts\";\n\ninterface ProfileFormProps {\n onProfileCreated: (profile: UserProfile) => void;\n existingProfile?: UserProfile | null;\n}\n\nexport default function ProfileForm({ onProfileCreated, existingProfile }: ProfileFormProps) {\n const [formData, setFormData] = useState({\n userName: existingProfile?.userName || \"\",\n email: existingProfile?.email || \"\",\n bio: existingProfile?.bio || \"\",\n location: existingProfile?.location || \"\",\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n setError(\"\");\n\n try {\n const response = await fetch(\"/api/profiles\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n if (response.ok) {\n const profile = await response.json();\n onProfileCreated(profile);\n \n // Only reset form if creating new profile\n if (!existingProfile) {\n setFormData({\n userName: \"\",\n email: \"\",\n bio: \"\",\n location: \"\",\n });\n }\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to save profile\");\n }\n } catch (err) {\n setError(\"Network error occurred\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: value,\n }));\n };\n\n return (\n

\n {existingProfile ? \"Update Profile\" : \"Create Profile\"}\n

\n \n {error && (\n

\n {error}\n

\n )}\n\n

\n );\n}",[],[239,257,291],"a8bd1272-3fb6-11f0-8b22-76b3cceeab13","App.tsx","3bafcf1e-3fb4-11f0-b34a-76b3cceeab13",22,["D",1748871419596],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport SubmissionForm from \"./SubmissionForm.tsx\";\nimport SubmissionsList from \"./SubmissionsList.tsx\";\nimport ProfileManager from \"./ProfileManager.tsx\";\nimport ProfilesList from \"./ProfilesList.tsx\";\nimport type { Submission } from \"../../shared/types.ts\";\n\nexport default function App() {\n const [submissions, setSubmissions] = useState([]);\n const [loading, setLoading] = useState(true);\n const [activeTab, setActiveTab] = useState<'profiles' | 'legacy'>('profiles');\n const [refreshTrigger, setRefreshTrigger] = useState(0);\n\n const fetchSubmissions = async () => {\n try {\n const response = await fetch(\"/api/submissions\");\n if (response.ok) {\n const data = await response.json();\n setSubmissions(data);\n }\n } catch (error) {\n console.error(\"Error fetching submissions:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchSubmissions();\n }, []);\n\n const handleSubmissionCreated = (newSubmission: Submission) => {\n setSubmissions(prev => [newSubmission, ...prev]);\n };\n\n const handleProfileUpdate = () => {\n setRefreshTrigger(prev => prev + 1);\n };\n\n return (\n

\n 🏘️ Neighborhood Skill Exchange\n

\n Connect with neighbors to share skills and help each other\n

\n\n {/* Tab Navigation */}\n

\n setActiveTab('profiles')}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n activeTab === 'profiles'\n ? 'bg-white text-blue-600 shadow-sm'\n : 'text-gray-600 hover:text-gray-800'\n }`}\n >\n 👥 User Profiles\n \n setActiveTab('legacy')}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n activeTab === 'legacy'\n ? 'bg-white text-blue-600 shadow-sm'\n : 'text-gray-600 hover:text-gray-800'\n }`}\n >\n 📝 Quick Submit\n \n

\n\n {activeTab === 'profiles' ? (\n

\n \n

\n ) : (\n

\n \n

\n )}\n

\n );\n}",[],[239,257,299],"3bafd5e0-3fb4-11f0-b34a-76b3cceeab13",9,["D",1748870377639],[195,196,197,198,199,200,201],[239,257],"336f2084-3fb4-11f0-9502-76b3cceeab13",["D",1748870363795],[194,202,203],[239],"5938a162-3fb6-11f0-9427-76b3cceeab13","index.ts",17,["D",1748871286183],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createTables } from \"./database/migrations.ts\";\nimport submissionsRouter from \"./routes/submissions.ts\";\nimport profilesRouter from \"./routes/profiles.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database\nawait createTables();\n\n// API routes\napp.route(\"/api/submissions\", submissionsRouter);\napp.route(\"/api\", profilesRouter);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\nexport default app.fetch;",[],[162,316],["D",1748870351480],[],[162,83,65],["D",1748871271774],[],[162,83,81],["D",1748870351480],[190,191],[162,83],"470079c0-3fb6-11f0-8f9c-76b3cceeab13","queries.ts","27536d14-3fb4-11f0-899e-76b3cceeab13","eb87c3dd-108a-4423-8f53-b6674d5c7dc4",15,["D",1748871255620],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, SKILLS_TABLE, LEGACY_TABLE } from \"./migrations.ts\";\nimport type { \n UserProfile, \n Skill, \n CreateProfileRequest, \n CreateSkillRequest,\n Submission, \n CreateSubmissionRequest \n} from \"../../shared/types.ts\";\n\n// User Profile Functions\nexport async function createOrUpdateProfile(data: CreateProfileRequest): Promise {\n // Try to update existing profile first\n const existingUser = await getUserProfile(data.userName);\n \n if (existingUser) {\n const result = await sqlite.execute(\n `UPDATE ${USERS_TABLE} \n SET email = ?, bio = ?, location = ?, updatedAt = CURRENT_TIMESTAMP \n WHERE userName = ? \n RETURNING *`,\n [data.email || null, data.bio || null, data.location || null, data.userName]\n );\n return result.rows[0] as UserProfile;\n } else {\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (userName, email, bio, location) \n VALUES (?, ?, ?, ?) \n RETURNING *`,\n [data.userName, data.email || null, data.bio || null, data.location || null]\n );\n return result.rows[0] as UserProfile;\n }\n}\n\nexport async function getUserProfile(userName: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE userName = ?`,\n [userName]\n );\n \n return result.rows.length > 0 ? result.rows[0] as UserProfile : null;\n}\n\nexport async function getAllProfiles(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} ORDER BY createdAt DESC`\n );\n \n return result.rows as UserProfile[];\n}\n\n// Skill Functions\nexport async function addSkillToProfile(data: CreateSkillRequest): Promise {\n // Get or create user profile\n let user = await getUserProfile(data.userName);\n if (!user) {\n user = await createOrUpdateProfile({ userName: data.userName });\n }\n\n const result = await sqlite.execute(\n `INSERT INTO ${SKILLS_TABLE} (userId, skillName, description, category, type) \n VALUES (?, ?, ?, ?, ?) \n RETURNING *`,\n [user.id, data.skillName, data.description || null, data.category || null, data.type]\n );\n \n return result.rows[0] as Skill;\n}\n\nexport async function getUserSkills(userName: string): Promise {\n const result = await sqlite.execute(\n `SELECT s.* FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE u.userName = ? AND s.isActive = 1 \n ORDER BY s.createdAt DESC`,\n [userName]\n );\n \n return result.rows as Skill[];\n}\n\nexport async function getAllSkills(): Promise<(Skill & { userName: string })[]> {\n const result = await sqlite.execute(\n `SELECT s.*, u.userName FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE s.isActive = 1 \n ORDER BY s.createdAt DESC`\n );\n \n return result.rows as (Skill & { userName: string })[];\n}\n\nexport async function getSkillsByType(type: 'offer' | 'request'): Promise<(Skill & { userName: string })[]> {\n const result = await sqlite.execute(\n `SELECT s.*, u.userName FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE s.type = ? AND s.isActive = 1 \n ORDER BY s.createdAt DESC`,\n [type]\n );\n \n return result.rows as (Skill & { userName: string })[];\n}\n\nexport async function toggleSkillStatus(skillId: number, isActive: boolean): Promise {\n await sqlite.execute(\n `UPDATE ${SKILLS_TABLE} SET isActive = ? WHERE id = ?`,\n [isActive ? 1 : 0, skillId]\n );\n}\n\n// Legacy Functions (for backward compatibility)\nexport async function createSubmission(data: CreateSubmissionRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${LEGACY_TABLE} (userName, skill, type) VALUES (?, ?, ?) RETURNING *`,\n [data.userName, data.skill, data.type]\n );\n \n return result.rows[0] as Submission;\n}\n\nexport async function getAllSubmissions(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${LEGACY_TABLE} ORDER BY createdAt DESC`\n );\n \n return result.rows as Submission[];\n}",[],[162,341,333],"database","398595fa-3fb6-11f0-8a23-76b3cceeab13","migrations.ts","2424fbda-3fb4-11f0-8c9f-76b3cceeab13",14,["D",1748871233001],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst USERS_TABLE = 'user_profiles';\nconst SKILLS_TABLE = 'user_skills';\nconst LEGACY_TABLE = 'skill_submissions';\n\nexport async function createTables() {\n // Create user profiles table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userName TEXT UNIQUE NOT NULL,\n email TEXT,\n bio TEXT,\n location TEXT,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP,\n updatedAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create user skills table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SKILLS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userId INTEGER NOT NULL,\n skillName TEXT NOT NULL,\n description TEXT,\n category TEXT,\n type TEXT NOT NULL CHECK (type IN ('offer', 'request')),\n isActive BOOLEAN DEFAULT 1,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (userId) REFERENCES ${USERS_TABLE}(id) ON DELETE CASCADE\n )`);\n\n // Keep legacy table for backward compatibility\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${LEGACY_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userName TEXT NOT NULL,\n skill TEXT NOT NULL,\n type TEXT NOT NULL CHECK (type IN ('offer', 'request')),\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_user ON ${SKILLS_TABLE}(userId)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_type ON ${SKILLS_TABLE}(type)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_active ON ${SKILLS_TABLE}(isActive)`);\n}\n\nexport { USERS_TABLE, SKILLS_TABLE, LEGACY_TABLE };",[],[162,341,343],"242504ae-3fb4-11f0-8c9f-76b3cceeab13",3,["D",1748870338148],[187,188],[162,341],"24250224-3fb4-11f0-8c9f-76b3cceeab13",["D",1748870338148],[186,189,192],[162],["D",1748870290080],{"_11":12,"_133":71},{"_11":12,"_129":-5,"_70":71,"_31":69,"_130":131,"_132":30},{"_40":120,"_13":16,"_34":37,"_121":86,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":14,"_128":12},"ctx",{"_53":-5,"_152":396,"_397":398,"_399":400,"_401":30,"_402":30,"_403":30,"_404":24,"_405":-5,"_406":-7,"_407":-7,"_408":26,"_409":30,"_410":30,"_411":-5,"_412":30,"_413":30,"_414":30,"_415":-5},"ENV",{"_367":368,"_369":370,"_371":16,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395},"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 · routes