[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_271":272,"_273":274},"routes/_app.x.$handle.$name",{"_95":94,"_32":46,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":58,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",14,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/index.ts","latestPath","fileId","1cfd3a2c-3fb2-11f0-9962-76b3cceeab13","name","index.ts","fileType","http","content","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\nexport default app;","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;","createdAt",["D",1748869598831],"branchVersion","branchId","f7c6152c-3fb0-11f0-a22a-76b3cceeab13","id","f7c5c22a-3fb0-11f0-a22a-76b3cceeab13","untitled-5977",["D",1748868975217],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","65401d60-3fb0-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","ccd39c3e-b477-4cb0-8d72-260995a45dea","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":14,"_32":85,"_44":43,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":46,"_93":94},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Renee","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4eDhMYmJWTjVKZFRHUWxhQlBmaVFmQmpFZiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":267,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":268,"_80":269,"_82":270,"_84":25},"tree",[169,177,180,182],"files",[169,170,171,172,173,174,175,176,177,178,179,180,181,182],"counts",{"_158":62,"_159":160,"_161":62,"_162":163,"_164":165},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":152,"_32":153,"_30":154,"_132":-5,"_42":43,"_41":155,"_134":58,"_39":156,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_27":157},{"_44":146,"_32":147,"_30":148,"_132":-5,"_42":43,"_41":149,"_134":58,"_39":150,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_27":151},{"_44":139,"_32":140,"_30":141,"_132":-5,"_42":43,"_41":142,"_134":58,"_39":143,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_27":145},{"_44":129,"_32":130,"_30":131,"_132":-5,"_42":43,"_41":133,"_134":58,"_39":135,"_13":62,"_34":20,"_36":136,"_24":25,"_137":-5,"_27":138},"deb411f0-3fb1-11f0-b6ec-76b3cceeab13","README.md","deb412f4-3fb1-11f0-b6ec-76b3cceeab13","parentId",3,"latest",["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","label",[130],"e9e9653e-3fb1-11f0-8c94-76b3cceeab13","shared","f13bab89-a4f3-4121-afb2-ce3c11ba10a3",4,["D",1748869381455],"directory",[140],"36b3e164-3fb2-11f0-a4ed-76b3cceeab13","frontend","d5eb29f1-28d1-4fd9-8fde-0d642bccbb01",10,["D",1748869510155],[147],"f2ca6ee6-3fb1-11f0-a27e-76b3cceeab13","backend","435588e4-ceb0-40c3-ae7c-fe7395ea06cf",5,["D",1748869396340],[153],"pulls","branches",1,"forks","envVars",{"_166":62,"_168":62},"connections",{"_166":62,"_167":62},"count","unfilledCount","emptyCount",{"_44":152,"_32":153,"_30":154,"_132":-5,"_42":43,"_41":155,"_134":58,"_39":264,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_184":265,"_27":266},{"_44":260,"_32":252,"_30":246,"_132":154,"_42":43,"_41":155,"_134":58,"_39":261,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_184":262,"_27":263},{"_44":253,"_32":254,"_30":255,"_132":246,"_42":43,"_41":155,"_134":58,"_39":256,"_13":62,"_34":191,"_36":257,"_24":25,"_137":-5,"_184":258,"_27":259},{"_44":243,"_32":244,"_30":245,"_132":246,"_42":43,"_41":247,"_134":58,"_39":248,"_13":62,"_34":191,"_36":249,"_24":25,"_137":-5,"_184":250,"_27":251},{"_44":239,"_32":230,"_30":224,"_132":154,"_42":43,"_41":234,"_134":58,"_39":240,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_184":241,"_27":242},{"_44":231,"_32":232,"_30":233,"_132":224,"_42":43,"_41":234,"_134":58,"_39":235,"_13":62,"_34":191,"_36":236,"_24":25,"_137":-5,"_184":237,"_27":238},{"_44":221,"_32":222,"_30":223,"_132":224,"_42":43,"_41":225,"_134":58,"_39":226,"_13":62,"_34":191,"_36":227,"_24":25,"_137":-5,"_184":228,"_27":229},{"_44":216,"_32":33,"_30":31,"_132":154,"_42":43,"_41":14,"_134":58,"_39":217,"_13":218,"_34":35,"_36":38,"_24":25,"_137":-5,"_184":219,"_27":220},{"_44":146,"_32":147,"_30":148,"_132":-5,"_42":43,"_41":149,"_134":58,"_39":213,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_184":214,"_27":215},{"_44":206,"_32":207,"_30":208,"_132":148,"_42":43,"_41":149,"_134":58,"_39":209,"_13":62,"_34":20,"_36":210,"_24":25,"_137":-5,"_184":211,"_27":212},{"_44":198,"_32":199,"_30":200,"_132":148,"_42":43,"_41":201,"_134":58,"_39":202,"_13":62,"_34":191,"_36":203,"_24":25,"_137":-5,"_184":204,"_27":205},{"_44":139,"_32":140,"_30":141,"_132":-5,"_42":43,"_41":142,"_134":58,"_39":195,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_184":196,"_27":197},{"_44":187,"_32":188,"_30":189,"_132":141,"_42":43,"_41":142,"_134":58,"_39":190,"_13":62,"_34":191,"_36":192,"_24":25,"_137":-5,"_184":193,"_27":194},{"_44":129,"_32":130,"_30":131,"_132":-5,"_42":43,"_41":133,"_134":58,"_39":183,"_13":62,"_34":20,"_36":136,"_24":25,"_137":-5,"_184":185,"_27":186},["D",1748869362650],"children",[],[130],"e9e95dc8-3fb1-11f0-8c94-76b3cceeab13","types.ts","e9e95e90-3fb1-11f0-8c94-76b3cceeab13",["D",1748869381455],"script","// 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];",[],[140,188],["D",1748869381455],[181],[140],"5e87b4fe-3fb2-11f0-b7c8-76b3cceeab13","index.tsx","5e87b5a8-3fb2-11f0-b7c8-76b3cceeab13",11,["D",1748869577089],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport type { Artist, DanceStyle, Specialty, CreateArtistRequest } from \"../shared/types.ts\";\n\n// Get initial data from window\ndeclare global {\n interface Window {\n __INITIAL_DATA__: {\n artists: Artist[];\n danceStyles: DanceStyle[];\n specialties: Specialty[];\n };\n }\n}\n\ninterface AppState {\n artists: Artist[];\n filteredArtists: Artist[];\n danceStyles: DanceStyle[];\n specialties: Specialty[];\n loading: boolean;\n showModal: boolean;\n editingArtist: Artist | null;\n filters: {\n search: string;\n danceStyle: string;\n specialty: string;\n location: string;\n };\n}\n\nfunction App() {\n const [state, setState] = React.useState(() => {\n const initialData = window.__INITIAL_DATA__ || { artists: [], danceStyles: [], specialties: [] };\n return {\n artists: initialData.artists,\n filteredArtists: initialData.artists,\n danceStyles: initialData.danceStyles,\n specialties: initialData.specialties,\n loading: false,\n showModal: false,\n editingArtist: null,\n filters: {\n search: '',\n danceStyle: '',\n specialty: '',\n location: ''\n }\n };\n });\n\n // Filter artists based on current filters\n React.useEffect(() => {\n let filtered = state.artists;\n\n if (state.filters.search) {\n const searchLower = state.filters.search.toLowerCase();\n filtered = filtered.filter(artist => \n artist.name.toLowerCase().includes(searchLower) ||\n artist.bio.toLowerCase().includes(searchLower)\n );\n }\n\n if (state.filters.danceStyle) {\n filtered = filtered.filter(artist =>\n artist.danceStyles.some(style => style.name === state.filters.danceStyle)\n );\n }\n\n if (state.filters.specialty) {\n filtered = filtered.filter(artist =>\n artist.specialties.some(specialty => specialty.name === state.filters.specialty)\n );\n }\n\n if (state.filters.location) {\n const locationLower = state.filters.location.toLowerCase();\n filtered = filtered.filter(artist =>\n artist.location.toLowerCase().includes(locationLower)\n );\n }\n\n setState(prev => ({ ...prev, filteredArtists: filtered }));\n }, [state.artists, state.filters]);\n\n const updateFilter = (key: keyof typeof state.filters, value: string) => {\n setState(prev => ({\n ...prev,\n filters: { ...prev.filters, [key]: value }\n }));\n };\n\n const clearFilters = () => {\n setState(prev => ({\n ...prev,\n filters: { search: '', danceStyle: '', specialty: '', location: '' }\n }));\n \n // Clear form inputs\n (document.getElementById('search-input') as HTMLInputElement).value = '';\n (document.getElementById('dance-style-filter') as HTMLSelectElement).value = '';\n (document.getElementById('specialty-filter') as HTMLSelectElement).value = '';\n (document.getElementById('location-filter') as HTMLInputElement).value = '';\n };\n\n const openModal = (artist?: Artist) => {\n setState(prev => ({\n ...prev,\n showModal: true,\n editingArtist: artist || null\n }));\n };\n\n const closeModal = () => {\n setState(prev => ({\n ...prev,\n showModal: false,\n editingArtist: null\n }));\n };\n\n const handleSubmitArtist = async (artistData: CreateArtistRequest) => {\n setState(prev => ({ ...prev, loading: true }));\n \n try {\n const url = state.editingArtist \n ? `/api/artists/${state.editingArtist.id}`\n : '/api/artists';\n \n const method = state.editingArtist ? 'PUT' : 'POST';\n \n const response = await fetch(url, {\n method,\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(artistData)\n });\n\n if (!response.ok) {\n const error = await response.json();\n throw new Error(error.error || 'Failed to save artist');\n }\n\n const savedArtist = await response.json();\n\n setState(prev => ({\n ...prev,\n artists: state.editingArtist\n ? prev.artists.map(a => a.id === savedArtist.id ? savedArtist : a)\n : [...prev.artists, savedArtist],\n loading: false,\n showModal: false,\n editingArtist: null\n }));\n\n } catch (error) {\n console.error('Error saving artist:', error);\n alert(error.message || 'Failed to save artist');\n setState(prev => ({ ...prev, loading: false }));\n }\n };\n\n return (\n

\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();",[],[147,199],"36b3c9cc-3fb2-11f0-a4ed-76b3cceeab13","index.html","36b3ca94-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",[],[147,207],["D",1748869510155],[178,179],[147],"6b7ab86e-3fb2-11f0-bc8d-76b3cceeab13",["D",1748869598831],2,[],[153,33],"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;",[],[153,230,222],"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;",[],[153,230,232],"12fea3b2-3fb2-11f0-b01e-76b3cceeab13",["D",1748869450380],[174,175],[153,230],"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}",[],[153,252,244],"database","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};",[],[153,252,254],"f2ca70ee-3fb1-11f0-a27e-76b3cceeab13",["D",1748869396340],[171,172],[153,252],["D",1748869396340],[170,173,176],[153],["D",1748868975217],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":14,"_32":85,"_44":43,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":46,"_93":94},"ctx",{"_78":-5,"_122":304,"_305":306,"_307":308,"_309":25,"_310":25,"_311":25,"_312":58,"_313":-5,"_314":-7,"_315":-7,"_316":62,"_317":25,"_318":25,"_319":-5,"_320":25,"_321":25,"_322":25,"_323":-5},"ENV",{"_275":276,"_277":278,"_279":85,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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)

Diff · v14