\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();",[],[260,252],"frontend","36b3c9cc-3fb2-11f0-a4ed-76b3cceeab13","index.html","36b3ca94-3fb2-11f0-a4ed-76b3cceeab13",10,["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",[],[260,262],"36b3e164-3fb2-11f0-a4ed-76b3cceeab13",["D",1748869510155],[223,224],[260],["D",1748869598831],[],[18,94],"199b4d7e-3fb2-11f0-b26a-76b3cceeab13","static.ts","199b4e14-3fb2-11f0-b26a-76b3cceeab13",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;",[],[18,84,277],"12fe95fc-3fb2-11f0-b01e-76b3cceeab13","artists.ts","12fe96c4-3fb2-11f0-b01e-76b3cceeab13",["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;",[],[18,84,285],["D",1748869450380],[219,220],[18,84],"06c37474-3fb2-11f0-8af1-76b3cceeab13","queries.ts","06c3751e-3fb2-11f0-8af1-76b3cceeab13",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}",[],[18,68,295],"f2ca643c-3fb1-11f0-a27e-76b3cceeab13","migrations.ts","f2ca6522-3fb1-11f0-a27e-76b3cceeab13",["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};",[],[18,68,303],["D",1748869396340],[216,217],[18,68],["D",1748869396340],[215,218,221],[18],["D",1748868975217],{"_11":12,"_160":74},{"_11":12,"_156":-5,"_73":74,"_31":72,"_157":158,"_159":30},{"_43":107,"_13":16,"_37":40,"_148":115,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":14,"_155":12},"ctx",{"_56":-5,"_179":352,"_353":354,"_355":356,"_357":30,"_358":30,"_359":30,"_360":24,"_361":-5,"_362":-7,"_363":-7,"_364":26,"_365":30,"_366":30,"_367":-5,"_368":30,"_369":30,"_370":30,"_371":-5},"ENV",{"_323":324,"_325":326,"_327":16,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351},"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 · backend