\n {/* Search and Filters Component */}\n \n\n {/* Artists Grid */}\n \n\n {/* Modal */}\n {state.showModal && (\n \n )}\n\n {/* Event Listeners Setup */}\n \n

\n );\n}\n\nfunction SearchFilters({ danceStyles, specialties, onFilterChange, onClearFilters }: {\n danceStyles: DanceStyle[];\n specialties: Specialty[];\n onFilterChange: (key: string, value: string) => void;\n onClearFilters: () => void;\n}) {\n React.useEffect(() => {\n // Populate filter dropdowns\n const danceStyleSelect = document.getElementById('dance-style-filter') as HTMLSelectElement;\n const specialtySelect = document.getElementById('specialty-filter') as HTMLSelectElement;\n\n // Clear existing options (except first)\n danceStyleSelect.innerHTML = '';\n specialtySelect.innerHTML = '';\n\n // Add dance styles\n danceStyles.forEach(style => {\n const option = document.createElement('option');\n option.value = style.name;\n option.textContent = style.name;\n danceStyleSelect.appendChild(option);\n });\n\n // Add specialties\n specialties.forEach(specialty => {\n const option = document.createElement('option');\n option.value = specialty.name;\n option.textContent = specialty.name;\n specialtySelect.appendChild(option);\n });\n\n // Add event listeners\n const searchInput = document.getElementById('search-input') as HTMLInputElement;\n const locationInput = document.getElementById('location-filter') as HTMLInputElement;\n const clearButton = document.getElementById('clear-filters') as HTMLButtonElement;\n\n const handleSearchChange = () => onFilterChange('search', searchInput.value);\n const handleDanceStyleChange = () => onFilterChange('danceStyle', danceStyleSelect.value);\n const handleSpecialtyChange = () => onFilterChange('specialty', specialtySelect.value);\n const handleLocationChange = () => onFilterChange('location', locationInput.value);\n\n searchInput.addEventListener('input', handleSearchChange);\n danceStyleSelect.addEventListener('change', handleDanceStyleChange);\n specialtySelect.addEventListener('change', handleSpecialtyChange);\n locationInput.addEventListener('input', handleLocationChange);\n clearButton.addEventListener('click', onClearFilters);\n\n return () => {\n searchInput.removeEventListener('input', handleSearchChange);\n danceStyleSelect.removeEventListener('change', handleDanceStyleChange);\n specialtySelect.removeEventListener('change', handleSpecialtyChange);\n locationInput.removeEventListener('input', handleLocationChange);\n clearButton.removeEventListener('click', onClearFilters);\n };\n }, [danceStyles, specialties, onFilterChange, onClearFilters]);\n\n return null;\n}\n\nfunction ArtistsGrid({ artists, loading, onEditArtist }: {\n artists: Artist[];\n loading: boolean;\n onEditArtist: (artist: Artist) => void;\n}) {\n React.useEffect(() => {\n const grid = document.getElementById('artists-grid');\n const loadingEl = document.getElementById('loading');\n const emptyState = document.getElementById('empty-state');\n\n if (!grid || !loadingEl || !emptyState) return;\n\n if (loading) {\n loadingEl.classList.remove('hidden');\n emptyState.classList.add('hidden');\n grid.innerHTML = '';\n return;\n }\n\n loadingEl.classList.add('hidden');\n\n if (artists.length === 0) {\n emptyState.classList.remove('hidden');\n grid.innerHTML = '';\n return;\n }\n\n emptyState.classList.add('hidden');\n\n // Render artist cards\n grid.innerHTML = artists.map(artist => `\n

${artist.name}

📍 ${artist.location}

🎯 ${artist.experience}

\n \n

${artist.bio}

\n \n

🕺 Dance Styles

\n ${artist.danceStyles.map(style => `\n ${style.name}\n `).join('')}\n

\n \n

⭐ Specialties

\n ${artist.specialties.map(specialty => `\n ${specialty.name}\n `).join('')}\n

\n \n ${artist.socialMedia && Object.values(artist.socialMedia).some(v => v) ? `\n

\n ${artist.socialMedia.instagram ? `📷` : ''}\n ${artist.socialMedia.youtube ? `📺` : ''}\n ${artist.socialMedia.tiktok ? `🎵` : ''}\n ${artist.socialMedia.website ? `🌐` : ''}\n

\n ` : ''}\n

\n `).join('');\n\n // Add click handlers for edit buttons\n grid.querySelectorAll('.edit-artist-btn').forEach(btn => {\n btn.addEventListener('click', (e) => {\n const artistId = parseInt((e.target as HTMLElement).dataset.artistId!);\n const artist = artists.find(a => a.id === artistId);\n if (artist) onEditArtist(artist);\n });\n });\n\n }, [artists, loading, onEditArtist]);\n\n return null;\n}\n\nfunction ArtistModal({ artist, danceStyles, specialties, onSubmit, onClose }: {\n artist: Artist | null;\n danceStyles: DanceStyle[];\n specialties: Specialty[];\n onSubmit: (data: CreateArtistRequest) => void;\n onClose: () => void;\n}) {\n React.useEffect(() => {\n const modal = document.getElementById('artist-modal');\n const form = document.getElementById('artist-form') as HTMLFormElement;\n const closeBtn = document.getElementById('close-modal');\n const cancelBtn = document.getElementById('cancel-btn');\n const modalTitle = document.getElementById('modal-title');\n\n if (!modal || !form) return;\n\n // Show modal\n modal.classList.remove('hidden');\n \n // Set title\n if (modalTitle) {\n modalTitle.textContent = artist ? 'Edit Artist Profile' : 'Add Your Artist Profile';\n }\n\n // Populate form if editing\n if (artist) {\n (document.getElementById('artist-name') as HTMLInputElement).value = artist.name;\n (document.getElementById('artist-email') as HTMLInputElement).value = artist.email;\n (document.getElementById('artist-bio') as HTMLTextAreaElement).value = artist.bio;\n (document.getElementById('artist-location') as HTMLInputElement).value = artist.location;\n (document.getElementById('artist-experience') as HTMLSelectElement).value = artist.experience;\n \n if (artist.socialMedia) {\n (document.getElementById('artist-instagram') as HTMLInputElement).value = artist.socialMedia.instagram || '';\n (document.getElementById('artist-youtube') as HTMLInputElement).value = artist.socialMedia.youtube || '';\n (document.getElementById('artist-tiktok') as HTMLInputElement).value = artist.socialMedia.tiktok || '';\n (document.getElementById('artist-website') as HTMLInputElement).value = artist.socialMedia.website || '';\n }\n }\n\n // Populate checkboxes\n const danceStylesContainer = document.getElementById('dance-styles-checkboxes');\n const specialtiesContainer = document.getElementById('specialties-checkboxes');\n\n if (danceStylesContainer) {\n danceStylesContainer.innerHTML = danceStyles.map(style => `\n \n s.id === style.id) ? 'checked' : ''} \n class=\"dance-style-checkbox rounded border-gray-300 text-purple-600 focus:ring-purple-500\">\n ${style.name}\n \n `).join('');\n }\n\n if (specialtiesContainer) {\n specialtiesContainer.innerHTML = specialties.map(specialty => `\n \n s.id === specialty.id) ? 'checked' : ''}\n class=\"specialty-checkbox rounded border-gray-300 text-purple-600 focus:ring-purple-500\">\n ${specialty.name}\n \n `).join('');\n }\n\n // Event handlers\n const handleClose = () => {\n modal.classList.add('hidden');\n form.reset();\n onClose();\n };\n\n const handleSubmit = (e: Event) => {\n e.preventDefault();\n \n const formData = new FormData(form);\n const selectedDanceStyles = Array.from(document.querySelectorAll('.dance-style-checkbox:checked'))\n .map(cb => parseInt((cb as HTMLInputElement).value));\n const selectedSpecialties = Array.from(document.querySelectorAll('.specialty-checkbox:checked'))\n .map(cb => parseInt((cb as HTMLInputElement).value));\n\n if (selectedDanceStyles.length === 0) {\n alert('Please select at least one dance style');\n return;\n }\n\n if (selectedSpecialties.length === 0) {\n alert('Please select at least one specialty');\n return;\n }\n\n const artistData: CreateArtistRequest = {\n name: (document.getElementById('artist-name') as HTMLInputElement).value,\n email: (document.getElementById('artist-email') as HTMLInputElement).value,\n bio: (document.getElementById('artist-bio') as HTMLTextAreaElement).value,\n location: (document.getElementById('artist-location') as HTMLInputElement).value,\n experience: (document.getElementById('artist-experience') as HTMLSelectElement).value,\n danceStyleIds: selectedDanceStyles,\n specialtyIds: selectedSpecialties,\n socialMedia: {\n instagram: (document.getElementById('artist-instagram') as HTMLInputElement).value || undefined,\n youtube: (document.getElementById('artist-youtube') as HTMLInputElement).value || undefined,\n tiktok: (document.getElementById('artist-tiktok') as HTMLInputElement).value || undefined,\n website: (document.getElementById('artist-website') as HTMLInputElement).value || undefined,\n }\n };\n\n onSubmit(artistData);\n };\n\n closeBtn?.addEventListener('click', handleClose);\n cancelBtn?.addEventListener('click', handleClose);\n form.addEventListener('submit', handleSubmit);\n\n // Close on backdrop click\n const handleBackdropClick = (e: Event) => {\n if (e.target === modal) handleClose();\n };\n modal.addEventListener('click', handleBackdropClick);\n\n return () => {\n closeBtn?.removeEventListener('click', handleClose);\n cancelBtn?.removeEventListener('click', handleClose);\n form.removeEventListener('submit', handleSubmit);\n modal.removeEventListener('click', handleBackdropClick);\n };\n }, [artist, danceStyles, specialties, onSubmit, onClose]);\n\n return null;\n}\n\nfunction EventListeners({ onOpenModal }: { onOpenModal: (artist?: Artist) => void }) {\n React.useEffect(() => {\n const addArtistBtn = document.getElementById('add-artist-btn');\n const addFirstArtistBtn = document.getElementById('add-first-artist');\n\n const handleAddArtist = () => onOpenModal();\n\n addArtistBtn?.addEventListener('click', handleAddArtist);\n addFirstArtistBtn?.addEventListener('click', handleAddArtist);\n\n return () => {\n addArtistBtn?.removeEventListener('click', handleAddArtist);\n addFirstArtistBtn?.removeEventListener('click', handleAddArtist);\n };\n }, [onOpenModal]);\n\n return null;\n}\n\n// Mount the app\nconst container = document.createElement('div');\ncontainer.id = 'react-root';\ndocument.body.appendChild(container);\n\nconst root = createRoot(container);\nroot.render();",[18,79],"36b3c9cc-3fb2-11f0-a4ed-76b3cceeab13",["D",1748869510155],"\n\n\n \n \n Afrolatin Dance Artists Directory\n \n \n \n\n\n \n

🕺💃 Afrolatin Dance Artists

Discover and connect with talented dancers in our community

\n \n

\n\n \n

🔍 Find Artists

\n Search\n \n

\n Dance Style\n \n

\n Specialty\n \n

\n Location\n \n

\n \n

\n\n \n

\n \n

\n \n \n

Loading artists...

\n \n \n

🕺

No artists found

Try adjusting your search filters or be the first to add your profile!

\n \n

\n\n \n \n\n \n\n",[18,65],"pulls","branches",1,"forks","envVars",{"_178":26,"_180":26},"connections",{"_178":26,"_179":26},"count","unfilledCount","emptyCount",{"_34":281,"_13":236,"_63":229,"_44":-5,"_36":37,"_154":272,"_155":24,"_38":282,"_40":26,"_66":82,"_157":-5,"_67":30,"_158":-5,"_201":283,"_17":284},{"_34":277,"_13":268,"_63":262,"_44":229,"_36":37,"_154":272,"_155":24,"_38":278,"_40":26,"_66":82,"_157":-5,"_67":30,"_158":-5,"_201":279,"_17":280},{"_34":269,"_13":270,"_63":271,"_44":262,"_36":37,"_154":272,"_155":24,"_38":273,"_40":26,"_66":80,"_157":274,"_67":30,"_158":-5,"_201":275,"_17":276},{"_34":259,"_13":260,"_63":261,"_44":262,"_36":37,"_154":263,"_155":24,"_38":264,"_40":26,"_66":80,"_157":265,"_67":30,"_158":-5,"_201":266,"_17":267},{"_34":255,"_13":246,"_63":240,"_44":229,"_36":37,"_154":250,"_155":24,"_38":256,"_40":26,"_66":82,"_157":-5,"_67":30,"_158":-5,"_201":257,"_17":258},{"_34":247,"_13":248,"_63":249,"_44":240,"_36":37,"_154":250,"_155":24,"_38":251,"_40":26,"_66":80,"_157":252,"_67":30,"_158":-5,"_201":253,"_17":254},{"_34":237,"_13":238,"_63":239,"_44":240,"_36":37,"_154":241,"_155":24,"_38":242,"_40":26,"_66":80,"_157":243,"_67":30,"_158":-5,"_201":244,"_17":245},{"_34":227,"_13":228,"_63":94,"_44":229,"_36":37,"_154":118,"_155":24,"_38":230,"_40":231,"_66":232,"_157":233,"_67":30,"_158":-5,"_201":234,"_17":235},{"_34":153,"_13":18,"_63":81,"_44":-5,"_36":37,"_154":41,"_155":24,"_38":224,"_40":26,"_66":82,"_157":-5,"_67":30,"_158":-5,"_201":225,"_17":226},{"_34":166,"_13":65,"_63":64,"_44":81,"_36":37,"_154":41,"_155":24,"_38":221,"_40":26,"_66":21,"_157":168,"_67":30,"_158":-5,"_201":222,"_17":223},{"_34":162,"_13":79,"_63":78,"_44":81,"_36":37,"_154":73,"_155":24,"_38":218,"_40":26,"_66":80,"_157":164,"_67":30,"_158":-5,"_201":219,"_17":220},{"_34":214,"_13":213,"_63":207,"_44":-5,"_36":37,"_154":208,"_155":24,"_38":215,"_40":26,"_66":82,"_157":-5,"_67":30,"_158":-5,"_201":216,"_17":217},{"_34":204,"_13":205,"_63":206,"_44":207,"_36":37,"_154":208,"_155":24,"_38":209,"_40":26,"_66":80,"_157":210,"_67":30,"_158":-5,"_201":211,"_17":212},{"_34":195,"_13":196,"_63":197,"_44":-5,"_36":37,"_154":198,"_155":24,"_38":199,"_40":26,"_66":21,"_157":200,"_67":30,"_158":-5,"_201":202,"_17":203},"deb411f0-3fb1-11f0-b6ec-76b3cceeab13","README.md","deb412f4-3fb1-11f0-b6ec-76b3cceeab13",3,["D",1748869362650],"# Afrolatin Dance Artists Directory\n\nA platform for Afrolatin dancers to showcase their artistic specialties and connect with the community.\n\n## Features\n\n- **Artist Profiles**: Dancers can create profiles showcasing their specialties\n- **Dance Styles**: Support for various Afrolatin dance styles (Salsa, Bachata, Kizomba, Zouk, etc.)\n- **Specialties**: Artists can highlight what they're known for (teaching, performing, choreography, etc.)\n- **Community Directory**: Browse and discover other artists in the community\n- **Search & Filter**: Find artists by dance style, specialty, or location\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── artists.ts # Artist CRUD operations\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── ArtistCard.tsx # Artist profile card\n│ │ ├── ArtistForm.tsx # Add/edit artist form\n│ │ └── ArtistList.tsx # Artists directory\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Dance Styles Supported\n\n- Salsa (Cuban, LA, NY styles)\n- Bachata (Traditional, Moderna, Sensual)\n- Kizomba\n- Brazilian Zouk\n- Merengue\n- Reggaeton\n- Afrobeats\n- And more...\n\n## Artist Specialties\n\n- Performance\n- Teaching/Instruction\n- Choreography\n- Social Dancing\n- Competition\n- Workshops\n- Cultural Education","children",[],[196],"e9e95dc8-3fb1-11f0-8c94-76b3cceeab13","types.ts","e9e95e90-3fb1-11f0-8c94-76b3cceeab13","f13bab89-a4f3-4121-afb2-ce3c11ba10a3",4,["D",1748869381455],"// Shared types for the Afrolatin Dance Artists app\n\nexport interface Artist {\n id: number;\n name: string;\n email: string;\n bio: string;\n location: string;\n profileImage?: string;\n danceStyles: DanceStyle[];\n specialties: Specialty[];\n experience: string; // e.g., \"5 years\", \"Professional\", \"Beginner\"\n socialMedia?: {\n instagram?: string;\n youtube?: string;\n tiktok?: string;\n website?: string;\n };\n createdAt: string;\n updatedAt: string;\n}\n\nexport interface DanceStyle {\n id: number;\n name: string;\n category: DanceCategory;\n description?: string;\n}\n\nexport interface Specialty {\n id: number;\n name: string;\n description?: string;\n}\n\nexport type DanceCategory = \n | 'Salsa'\n | 'Bachata' \n | 'Kizomba'\n | 'Brazilian Zouk'\n | 'Merengue'\n | 'Reggaeton'\n | 'Afrobeats'\n | 'Other';\n\nexport interface CreateArtistRequest {\n name: string;\n email: string;\n bio: string;\n location: string;\n danceStyleIds: number[];\n specialtyIds: number[];\n experience: string;\n socialMedia?: {\n instagram?: string;\n youtube?: string;\n tiktok?: string;\n website?: string;\n };\n}\n\nexport interface UpdateArtistRequest extends Partial {\n id: number;\n}\n\nexport interface SearchFilters {\n danceStyle?: string;\n specialty?: string;\n location?: string;\n experience?: string;\n search?: string;\n}\n\n// Predefined dance styles\nexport const DANCE_STYLES: Omit[] = [\n { name: 'Cuban Salsa', category: 'Salsa', description: 'Traditional Cuban style salsa' },\n { name: 'LA Salsa', category: 'Salsa', description: 'Los Angeles style salsa' },\n { name: 'NY Salsa', category: 'Salsa', description: 'New York style salsa' },\n { name: 'Traditional Bachata', category: 'Bachata', description: 'Classic Dominican bachata' },\n { name: 'Bachata Moderna', category: 'Bachata', description: 'Modern bachata with contemporary elements' },\n { name: 'Bachata Sensual', category: 'Bachata', description: 'Sensual style bachata' },\n { name: 'Kizomba', category: 'Kizomba', description: 'Angolan partner dance' },\n { name: 'Urban Kiz', category: 'Kizomba', description: 'Urban style kizomba' },\n { name: 'Brazilian Zouk', category: 'Brazilian Zouk', description: 'Brazilian partner dance' },\n { name: 'Merengue', category: 'Merengue', description: 'Dominican Republic national dance' },\n { name: 'Reggaeton', category: 'Reggaeton', description: 'Urban Latin dance style' },\n { name: 'Afrobeats', category: 'Afrobeats', description: 'West African influenced dance' },\n];\n\n// Predefined specialties\nexport const SPECIALTIES: Omit[] = [\n { name: 'Performance', description: 'Stage and show performances' },\n { name: 'Teaching/Instruction', description: 'Dance instruction and classes' },\n { name: 'Choreography', description: 'Creating dance routines and choreography' },\n { name: 'Social Dancing', description: 'Social dance events and parties' },\n { name: 'Competition', description: 'Competitive dancing and contests' },\n { name: 'Workshops', description: 'Intensive dance workshops and masterclasses' },\n { name: 'Cultural Education', description: 'Teaching cultural history and context' },\n { name: 'Fitness/Conditioning', description: 'Dance fitness and conditioning' },\n { name: 'Event Organization', description: 'Organizing dance events and socials' },\n { name: 'Music & Rhythm', description: 'Musicality and rhythm training' },\n];",[],[213,205],"shared","e9e9653e-3fb1-11f0-8c94-76b3cceeab13",["D",1748869381455],[193],[213],["D",1748869577089],[],[18,79],["D",1748869510155],[],[18,65],["D",1748869510155],[190,191],[18],"6b7ab86e-3fb2-11f0-bc8d-76b3cceeab13","index.ts","435588e4-ceb0-40c3-ae7c-fe7395ea06cf",["D",1748869598831],2,"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport artistsRoutes from \"./routes/artists.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// Run database migrations on startup\nawait runMigrations();\n\n// API routes\napp.route(\"/api/artists\", artistsRoutes);\n\n// Static file serving and main page\napp.route(\"/\", staticRoutes);\n\n// Health check\napp.get(\"/health\", (c) => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[236,228],"backend","199b4d7e-3fb2-11f0-b26a-76b3cceeab13","static.ts","199b4e14-3fb2-11f0-b26a-76b3cceeab13","80106b0e-26e5-4eae-8aba-4ae76f62e8ef",8,["D",1748869461476],"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 { getArtists, getAllDanceStyles, getAllSpecialties } from \"../database/queries.ts\";\n\nconst staticRoutes = new Hono();\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\n// Serve main page with initial data\nstaticRoutes.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Fetch initial data to avoid extra round-trips\n const [artists, danceStyles, specialties] = await Promise.all([\n getArtists(),\n getAllDanceStyles(),\n getAllSpecialties()\n ]);\n\n const initialData = {\n artists,\n danceStyles,\n specialties\n };\n\n // Inject initial data into the HTML\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.text(\"Error loading page\", 500);\n }\n});\n\nexport default staticRoutes;",[],[236,246,238],"routes","12fe95fc-3fb2-11f0-b01e-76b3cceeab13","artists.ts","12fe96c4-3fb2-11f0-b01e-76b3cceeab13",7,["D",1748869450380],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createArtist, \n getArtists, \n getArtistById, \n updateArtist, \n deleteArtist,\n getAllDanceStyles,\n getAllSpecialties\n} from \"../database/queries.ts\";\nimport type { CreateArtistRequest, UpdateArtistRequest, SearchFilters } from \"../../shared/types.ts\";\n\nconst artists = new Hono();\n\n// Get all dance styles\nartists.get(\"/dance-styles\", async (c) => {\n try {\n const danceStyles = await getAllDanceStyles();\n return c.json(danceStyles);\n } catch (error) {\n console.error(\"Error fetching dance styles:\", error);\n return c.json({ error: \"Failed to fetch dance styles\" }, 500);\n }\n});\n\n// Get all specialties\nartists.get(\"/specialties\", async (c) => {\n try {\n const specialties = await getAllSpecialties();\n return c.json(specialties);\n } catch (error) {\n console.error(\"Error fetching specialties:\", error);\n return c.json({ error: \"Failed to fetch specialties\" }, 500);\n }\n});\n\n// Get all artists with optional filters\nartists.get(\"/\", async (c) => {\n try {\n const filters: SearchFilters = {\n danceStyle: c.req.query(\"danceStyle\"),\n specialty: c.req.query(\"specialty\"),\n location: c.req.query(\"location\"),\n experience: c.req.query(\"experience\"),\n search: c.req.query(\"search\"),\n };\n\n // Remove undefined values\n Object.keys(filters).forEach(key => {\n if (filters[key as keyof SearchFilters] === undefined) {\n delete filters[key as keyof SearchFilters];\n }\n });\n\n const artistsList = await getArtists(filters);\n return c.json(artistsList);\n } catch (error) {\n console.error(\"Error fetching artists:\", error);\n return c.json({ error: \"Failed to fetch artists\" }, 500);\n }\n});\n\n// Get artist by ID\nartists.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid artist ID\" }, 400);\n }\n\n const artist = await getArtistById(id);\n return c.json(artist);\n } catch (error) {\n console.error(\"Error fetching artist:\", error);\n if (error.message === \"Artist not found\") {\n return c.json({ error: \"Artist not found\" }, 404);\n }\n return c.json({ error: \"Failed to fetch artist\" }, 500);\n }\n});\n\n// Create new artist\nartists.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as CreateArtistRequest;\n \n // Basic validation\n if (!body.name || !body.email || !body.bio || !body.location || !body.experience) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n if (!body.danceStyleIds || body.danceStyleIds.length === 0) {\n return c.json({ error: \"At least one dance style is required\" }, 400);\n }\n\n if (!body.specialtyIds || body.specialtyIds.length === 0) {\n return c.json({ error: \"At least one specialty is required\" }, 400);\n }\n\n const artist = await createArtist(body);\n return c.json(artist, 201);\n } catch (error) {\n console.error(\"Error creating artist:\", error);\n if (error.message?.includes(\"UNIQUE constraint failed\")) {\n return c.json({ error: \"Email already exists\" }, 409);\n }\n return c.json({ error: \"Failed to create artist\" }, 500);\n }\n});\n\n// Update artist\nartists.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid artist ID\" }, 400);\n }\n\n const body = await c.req.json() as Partial;\n const updateData: UpdateArtistRequest = { ...body, id };\n\n const artist = await updateArtist(updateData);\n return c.json(artist);\n } catch (error) {\n console.error(\"Error updating artist:\", error);\n if (error.message === \"Artist not found\") {\n return c.json({ error: \"Artist not found\" }, 404);\n }\n if (error.message?.includes(\"UNIQUE constraint failed\")) {\n return c.json({ error: \"Email already exists\" }, 409);\n }\n return c.json({ error: \"Failed to update artist\" }, 500);\n }\n});\n\n// Delete artist\nartists.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid artist ID\" }, 400);\n }\n\n await deleteArtist(id);\n return c.json({ message: \"Artist deleted successfully\" });\n } catch (error) {\n console.error(\"Error deleting artist:\", error);\n return c.json({ error: \"Failed to delete artist\" }, 500);\n }\n});\n\nexport default artists;",[],[236,246,248],"12fea3b2-3fb2-11f0-b01e-76b3cceeab13",["D",1748869450380],[186,187],[236,246],"06c37474-3fb2-11f0-8af1-76b3cceeab13","queries.ts","06c3751e-3fb2-11f0-8af1-76b3cceeab13","f4dae3cd-a027-4c8b-a3f6-5764d0bdfc17",6,["D",1748869429860],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAMES } from \"./migrations.ts\";\nimport type { Artist, DanceStyle, Specialty, CreateArtistRequest, UpdateArtistRequest, SearchFilters } from \"../../shared/types.ts\";\n\n// Get all dance styles\nexport async function getAllDanceStyles(): Promise {\n const result = await sqlite.execute(`\n SELECT id, name, category, description \n FROM ${TABLE_NAMES.DANCE_STYLES} \n ORDER BY category, name\n `);\n return result.rows as DanceStyle[];\n}\n\n// Get all specialties\nexport async function getAllSpecialties(): Promise {\n const result = await sqlite.execute(`\n SELECT id, name, description \n FROM ${TABLE_NAMES.SPECIALTIES} \n ORDER BY name\n `);\n return result.rows as Specialty[];\n}\n\n// Create a new artist\nexport async function createArtist(artistData: CreateArtistRequest): Promise {\n const { name, email, bio, location, experience, socialMedia, danceStyleIds, specialtyIds } = artistData;\n \n // Insert artist\n const artistResult = await sqlite.execute(`\n INSERT INTO ${TABLE_NAMES.ARTISTS} \n (name, email, bio, location, experience, instagram, youtube, tiktok, website)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n name, email, bio, location, experience,\n socialMedia?.instagram || null,\n socialMedia?.youtube || null,\n socialMedia?.tiktok || null,\n socialMedia?.website || null\n ]);\n\n const artistId = artistResult.lastInsertRowid as number;\n\n // Insert dance style associations\n for (const styleId of danceStyleIds) {\n await sqlite.execute(`\n INSERT INTO ${TABLE_NAMES.ARTIST_DANCE_STYLES} (artist_id, dance_style_id)\n VALUES (?, ?)\n `, [artistId, styleId]);\n }\n\n // Insert specialty associations\n for (const specialtyId of specialtyIds) {\n await sqlite.execute(`\n INSERT INTO ${TABLE_NAMES.ARTIST_SPECIALTIES} (artist_id, specialty_id)\n VALUES (?, ?)\n `, [artistId, specialtyId]);\n }\n\n return getArtistById(artistId);\n}\n\n// Get artist by ID with all related data\nexport async function getArtistById(id: number): Promise {\n // Get artist basic info\n const artistResult = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAMES.ARTISTS} WHERE id = ?\n `, [id]);\n\n if (artistResult.rows.length === 0) {\n throw new Error('Artist not found');\n }\n\n const artistRow = artistResult.rows[0] as any;\n\n // Get dance styles\n const stylesResult = await sqlite.execute(`\n SELECT ds.id, ds.name, ds.category, ds.description\n FROM ${TABLE_NAMES.DANCE_STYLES} ds\n JOIN ${TABLE_NAMES.ARTIST_DANCE_STYLES} ads ON ds.id = ads.dance_style_id\n WHERE ads.artist_id = ?\n `, [id]);\n\n // Get specialties\n const specialtiesResult = await sqlite.execute(`\n SELECT s.id, s.name, s.description\n FROM ${TABLE_NAMES.SPECIALTIES} s\n JOIN ${TABLE_NAMES.ARTIST_SPECIALTIES} as_ ON s.id = as_.specialty_id\n WHERE as_.artist_id = ?\n `, [id]);\n\n return {\n id: artistRow.id,\n name: artistRow.name,\n email: artistRow.email,\n bio: artistRow.bio,\n location: artistRow.location,\n profileImage: artistRow.profile_image,\n experience: artistRow.experience,\n danceStyles: stylesResult.rows as DanceStyle[],\n specialties: specialtiesResult.rows as Specialty[],\n socialMedia: {\n instagram: artistRow.instagram,\n youtube: artistRow.youtube,\n tiktok: artistRow.tiktok,\n website: artistRow.website,\n },\n createdAt: artistRow.created_at,\n updatedAt: artistRow.updated_at,\n };\n}\n\n// Get all artists with filters\nexport async function getArtists(filters: SearchFilters = {}): Promise {\n let query = `\n SELECT DISTINCT a.id\n FROM ${TABLE_NAMES.ARTISTS} a\n `;\n \n const conditions: string[] = [];\n const params: any[] = [];\n\n // Join tables if filtering by dance style or specialty\n if (filters.danceStyle) {\n query += ` JOIN ${TABLE_NAMES.ARTIST_DANCE_STYLES} ads ON a.id = ads.artist_id\n JOIN ${TABLE_NAMES.DANCE_STYLES} ds ON ads.dance_style_id = ds.id`;\n conditions.push('ds.name = ?');\n params.push(filters.danceStyle);\n }\n\n if (filters.specialty) {\n query += ` JOIN ${TABLE_NAMES.ARTIST_SPECIALTIES} as_ ON a.id = as_.artist_id\n JOIN ${TABLE_NAMES.SPECIALTIES} s ON as_.specialty_id = s.id`;\n conditions.push('s.name = ?');\n params.push(filters.specialty);\n }\n\n // Add WHERE clause if there are conditions\n if (conditions.length > 0 || filters.location || filters.experience || filters.search) {\n query += ' WHERE ';\n \n if (filters.location) {\n conditions.push('a.location LIKE ?');\n params.push(`%${filters.location}%`);\n }\n \n if (filters.experience) {\n conditions.push('a.experience = ?');\n params.push(filters.experience);\n }\n \n if (filters.search) {\n conditions.push('(a.name LIKE ? OR a.bio LIKE ?)');\n params.push(`%${filters.search}%`, `%${filters.search}%`);\n }\n \n query += conditions.join(' AND ');\n }\n\n query += ' ORDER BY a.created_at DESC';\n\n const result = await sqlite.execute(query, params);\n const artistIds = result.rows.map((row: any) => row.id);\n\n // Get full artist data for each ID\n const artists: Artist[] = [];\n for (const id of artistIds) {\n try {\n const artist = await getArtistById(id);\n artists.push(artist);\n } catch (error) {\n console.error(`Error fetching artist ${id}:`, error);\n }\n }\n\n return artists;\n}\n\n// Update artist\nexport async function updateArtist(artistData: UpdateArtistRequest): Promise {\n const { id, name, email, bio, location, experience, socialMedia, danceStyleIds, specialtyIds } = artistData;\n\n // Update basic artist info\n const updateFields: string[] = [];\n const updateParams: any[] = [];\n\n if (name !== undefined) {\n updateFields.push('name = ?');\n updateParams.push(name);\n }\n if (email !== undefined) {\n updateFields.push('email = ?');\n updateParams.push(email);\n }\n if (bio !== undefined) {\n updateFields.push('bio = ?');\n updateParams.push(bio);\n }\n if (location !== undefined) {\n updateFields.push('location = ?');\n updateParams.push(location);\n }\n if (experience !== undefined) {\n updateFields.push('experience = ?');\n updateParams.push(experience);\n }\n if (socialMedia?.instagram !== undefined) {\n updateFields.push('instagram = ?');\n updateParams.push(socialMedia.instagram);\n }\n if (socialMedia?.youtube !== undefined) {\n updateFields.push('youtube = ?');\n updateParams.push(socialMedia.youtube);\n }\n if (socialMedia?.tiktok !== undefined) {\n updateFields.push('tiktok = ?');\n updateParams.push(socialMedia.tiktok);\n }\n if (socialMedia?.website !== undefined) {\n updateFields.push('website = ?');\n updateParams.push(socialMedia.website);\n }\n\n if (updateFields.length > 0) {\n updateFields.push('updated_at = CURRENT_TIMESTAMP');\n updateParams.push(id);\n \n await sqlite.execute(`\n UPDATE ${TABLE_NAMES.ARTISTS} \n SET ${updateFields.join(', ')}\n WHERE id = ?\n `, updateParams);\n }\n\n // Update dance styles if provided\n if (danceStyleIds !== undefined) {\n await sqlite.execute(`DELETE FROM ${TABLE_NAMES.ARTIST_DANCE_STYLES} WHERE artist_id = ?`, [id]);\n for (const styleId of danceStyleIds) {\n await sqlite.execute(`\n INSERT INTO ${TABLE_NAMES.ARTIST_DANCE_STYLES} (artist_id, dance_style_id)\n VALUES (?, ?)\n `, [id, styleId]);\n }\n }\n\n // Update specialties if provided\n if (specialtyIds !== undefined) {\n await sqlite.execute(`DELETE FROM ${TABLE_NAMES.ARTIST_SPECIALTIES} WHERE artist_id = ?`, [id]);\n for (const specialtyId of specialtyIds) {\n await sqlite.execute(`\n INSERT INTO ${TABLE_NAMES.ARTIST_SPECIALTIES} (artist_id, specialty_id)\n VALUES (?, ?)\n `, [id, specialtyId]);\n }\n }\n\n return getArtistById(id);\n}\n\n// Delete artist\nexport async function deleteArtist(id: number): Promise {\n await sqlite.execute(`DELETE FROM ${TABLE_NAMES.ARTISTS} WHERE id = ?`, [id]);\n}",[],[236,268,260],"database","f2ca643c-3fb1-11f0-a27e-76b3cceeab13","migrations.ts","f2ca6522-3fb1-11f0-a27e-76b3cceeab13",5,["D",1748869396340],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { DANCE_STYLES, SPECIALTIES } from \"../../shared/types.ts\";\n\n// Table names - increment version when changing schema\nconst ARTISTS_TABLE = 'afrolatin_artists_v1';\nconst DANCE_STYLES_TABLE = 'dance_styles_v1';\nconst SPECIALTIES_TABLE = 'specialties_v1';\nconst ARTIST_DANCE_STYLES_TABLE = 'artist_dance_styles_v1';\nconst ARTIST_SPECIALTIES_TABLE = 'artist_specialties_v1';\n\nexport async function runMigrations() {\n console.log('Running database migrations...');\n\n // Create dance_styles table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${DANCE_STYLES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n category TEXT NOT NULL,\n description TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create specialties table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SPECIALTIES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n description TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create artists table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ARTISTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n bio TEXT NOT NULL,\n location TEXT NOT NULL,\n profile_image TEXT,\n experience TEXT NOT NULL,\n instagram TEXT,\n youtube TEXT,\n tiktok TEXT,\n website TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create junction table for artist dance styles (many-to-many)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ARTIST_DANCE_STYLES_TABLE} (\n artist_id INTEGER,\n dance_style_id INTEGER,\n PRIMARY KEY (artist_id, dance_style_id),\n FOREIGN KEY (artist_id) REFERENCES ${ARTISTS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (dance_style_id) REFERENCES ${DANCE_STYLES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n // Create junction table for artist specialties (many-to-many)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ARTIST_SPECIALTIES_TABLE} (\n artist_id INTEGER,\n specialty_id INTEGER,\n PRIMARY KEY (artist_id, specialty_id),\n FOREIGN KEY (artist_id) REFERENCES ${ARTISTS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (specialty_id) REFERENCES ${SPECIALTIES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n // Seed dance styles\n for (const style of DANCE_STYLES) {\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${DANCE_STYLES_TABLE} (name, category, description)\n VALUES (?, ?, ?)\n `, [style.name, style.category, style.description]);\n }\n\n // Seed specialties\n for (const specialty of SPECIALTIES) {\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${SPECIALTIES_TABLE} (name, description)\n VALUES (?, ?)\n `, [specialty.name, specialty.description]);\n }\n\n console.log('Database migrations completed successfully');\n}\n\nexport const TABLE_NAMES = {\n ARTISTS: ARTISTS_TABLE,\n DANCE_STYLES: DANCE_STYLES_TABLE,\n SPECIALTIES: SPECIALTIES_TABLE,\n ARTIST_DANCE_STYLES: ARTIST_DANCE_STYLES_TABLE,\n ARTIST_SPECIALTIES: ARTIST_SPECIALTIES_TABLE,\n};",[],[236,268,270],"f2ca70ee-3fb1-11f0-a27e-76b3cceeab13",["D",1748869396340],[183,184],[236,268],"f2ca6ee6-3fb1-11f0-a27e-76b3cceeab13",["D",1748869396340],[182,185,188],[236],["D",1748868975217],{"_11":12,"_131":70},{"_11":12,"_127":-5,"_69":70,"_31":68,"_128":129,"_130":30},{"_40":118,"_13":16,"_34":37,"_119":84,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":-5,"_125":14,"_126":12},"ctx",{"_53":-5,"_150":322,"_323":324,"_325":326,"_327":30,"_328":30,"_329":30,"_330":24,"_331":-5,"_332":-7,"_333":-7,"_334":26,"_335":30,"_336":30,"_337":-5,"_338":30,"_339":30,"_340":30,"_341":-5},"ENV",{"_293":294,"_295":296,"_297":16,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321},"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"]

${artist.name}

🕺 Dance Styles

⭐ Specialties

🔍 Find Artists

No artists found

Add Your Artist Profile

Social Media (Optional)

History · frontend