[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_274":275,"_276":277},"routes/_app.x.$handle.$name",{"_100":99,"_32":49,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_36":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",10,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","frontend","latestPath","fileId","d5eb29f1-28d1-4fd9-8fde-0d642bccbb01","name","fileType","directory","content","createdAt",["D",1748869510155],"branchVersion","branchId","f7c6152c-3fb0-11f0-a22a-76b3cceeab13",{"_30":43,"_32":44,"_33":21,"_35":45,"_36":46,"_38":14,"_39":40,"_24":25},"frontend/index.html","36b3ca94-3fb2-11f0-a4ed-76b3cceeab13","index.html","\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",["D",1748869510155],"id","f7c5c22a-3fb0-11f0-a22a-76b3cceeab13","untitled-5977",["D",1748868975217],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","65401d60-3fb0-11f0-ad5b-814c56c8abb0","pinnedFileId","1cfd3a2c-3fb2-11f0-9962-76b3cceeab13","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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"isOwned",14,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Renee","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4eDhMYmJWTjVKZFRHUWxhQlBmaVFmQmpFZiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_36":270,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":271,"_84":272,"_86":273,"_88":25},"tree",[179,187,189,191,192],"files",[179,180,181,182,183,184,185,186,187,188,189,190,191,192],"counts",{"_169":66,"_170":142,"_171":66,"_172":173,"_174":175},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":163,"_32":164,"_30":165,"_138":-5,"_39":40,"_38":166,"_140":62,"_36":167,"_13":66,"_33":34,"_35":-5,"_24":25,"_145":-5,"_27":168},{"_47":160,"_32":28,"_30":31,"_138":-5,"_39":40,"_38":14,"_140":62,"_36":161,"_13":66,"_33":34,"_35":-5,"_24":25,"_145":-5,"_27":162},{"_47":154,"_32":155,"_30":156,"_138":-5,"_39":40,"_38":157,"_140":62,"_36":158,"_13":66,"_33":34,"_35":-5,"_24":25,"_145":-5,"_27":159},{"_47":147,"_32":148,"_30":149,"_138":-5,"_39":40,"_38":150,"_140":62,"_36":151,"_13":66,"_33":21,"_35":152,"_24":25,"_145":-5,"_27":153},{"_47":135,"_32":136,"_30":137,"_138":-5,"_39":40,"_38":139,"_140":25,"_36":141,"_13":142,"_33":143,"_35":144,"_24":25,"_145":-5,"_27":146},"4c869a0a-3fb1-11f0-9b18-76b3cceeab13","main.tsx","f7c8588c-3fb0-11f0-a22a-76b3cceeab13","parentId",2,"latest",["D",1748869117403],1,"script","create an app that allows users to post job openings and have a public chat room to talk about opportunities","label",[136],"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",[148],"e9e9653e-3fb1-11f0-8c94-76b3cceeab13","shared","f13bab89-a4f3-4121-afb2-ce3c11ba10a3",4,["D",1748869381455],[155],"36b3e164-3fb2-11f0-a4ed-76b3cceeab13",["D",1748869510155],[28],"f2ca6ee6-3fb1-11f0-a27e-76b3cceeab13","backend","435588e4-ceb0-40c3-ae7c-fe7395ea06cf",5,["D",1748869396340],[164],"pulls","branches","forks","envVars",{"_176":66,"_178":66},"connections",{"_176":66,"_177":66},"count","unfilledCount","emptyCount",{"_47":163,"_32":164,"_30":165,"_138":-5,"_39":40,"_38":166,"_140":62,"_36":267,"_13":66,"_33":34,"_35":-5,"_24":25,"_145":-5,"_194":268,"_27":269},{"_47":263,"_32":255,"_30":249,"_138":165,"_39":40,"_38":166,"_140":62,"_36":264,"_13":66,"_33":34,"_35":-5,"_24":25,"_145":-5,"_194":265,"_27":266},{"_47":256,"_32":257,"_30":258,"_138":249,"_39":40,"_38":166,"_140":62,"_36":259,"_13":66,"_33":143,"_35":260,"_24":25,"_145":-5,"_194":261,"_27":262},{"_47":246,"_32":247,"_30":248,"_138":249,"_39":40,"_38":250,"_140":62,"_36":251,"_13":66,"_33":143,"_35":252,"_24":25,"_145":-5,"_194":253,"_27":254},{"_47":242,"_32":233,"_30":227,"_138":165,"_39":40,"_38":237,"_140":62,"_36":243,"_13":66,"_33":34,"_35":-5,"_24":25,"_145":-5,"_194":244,"_27":245},{"_47":234,"_32":235,"_30":236,"_138":227,"_39":40,"_38":237,"_140":62,"_36":238,"_13":66,"_33":143,"_35":239,"_24":25,"_145":-5,"_194":240,"_27":241},{"_47":224,"_32":225,"_30":226,"_138":227,"_39":40,"_38":228,"_140":62,"_36":229,"_13":66,"_33":143,"_35":230,"_24":25,"_145":-5,"_194":231,"_27":232},{"_47":217,"_32":218,"_30":60,"_138":165,"_39":40,"_38":219,"_140":25,"_36":220,"_13":66,"_33":143,"_35":221,"_24":25,"_145":-5,"_194":222,"_27":223},{"_47":160,"_32":28,"_30":31,"_138":-5,"_39":40,"_38":14,"_140":62,"_36":214,"_13":66,"_33":34,"_35":-5,"_24":25,"_145":-5,"_194":215,"_27":216},{"_47":210,"_32":44,"_30":43,"_138":31,"_39":40,"_38":14,"_140":62,"_36":211,"_13":66,"_33":21,"_35":45,"_24":25,"_145":-5,"_194":212,"_27":213},{"_47":154,"_32":155,"_30":156,"_138":-5,"_39":40,"_38":157,"_140":62,"_36":207,"_13":66,"_33":34,"_35":-5,"_24":25,"_145":-5,"_194":208,"_27":209},{"_47":200,"_32":201,"_30":202,"_138":156,"_39":40,"_38":157,"_140":62,"_36":203,"_13":66,"_33":143,"_35":204,"_24":25,"_145":-5,"_194":205,"_27":206},{"_47":147,"_32":148,"_30":149,"_138":-5,"_39":40,"_38":150,"_140":62,"_36":197,"_13":66,"_33":21,"_35":152,"_24":25,"_145":-5,"_194":198,"_27":199},{"_47":135,"_32":136,"_30":137,"_138":-5,"_39":40,"_38":139,"_140":25,"_36":193,"_13":142,"_33":143,"_35":144,"_24":25,"_145":-5,"_194":195,"_27":196},["D",1748869117403],"children",[],[136],["D",1748869362650],[],[148],"e9e95dc8-3fb1-11f0-8c94-76b3cceeab13","types.ts","e9e95e90-3fb1-11f0-8c94-76b3cceeab13",["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];",[],[155,201],["D",1748869381455],[190],[155],"36b3c9cc-3fb2-11f0-a4ed-76b3cceeab13",["D",1748869510155],[],[28,44],["D",1748869510155],[188],[28],"1cfd395a-3fb2-11f0-9962-76b3cceeab13","index.ts",9,["D",1748869467151],"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;",[],[164,218],"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;",[],[164,233,225],"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;",[],[164,233,235],"12fea3b2-3fb2-11f0-b01e-76b3cceeab13",["D",1748869450380],[184,185],[164,233],"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}",[],[164,255,247],"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};",[],[164,255,257],"f2ca70ee-3fb1-11f0-a27e-76b3cceeab13",["D",1748869396340],[181,182],[164,255],["D",1748869396340],[180,183,186],[164],["D",1748868975217],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_127":307,"_308":309,"_310":311,"_312":25,"_313":25,"_314":25,"_315":62,"_316":-5,"_317":-7,"_318":-7,"_319":66,"_320":25,"_321":25,"_322":-5,"_323":25,"_324":25,"_325":25,"_326":-5},"ENV",{"_278":279,"_280":281,"_282":90,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306},"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"]

🔍 Find Artists

No artists found

Add Your Artist Profile

Social Media (Optional)

Diff · v10