[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_37":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",7,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":-5,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","backend/routes","latestPath","fileId","80106b0e-26e5-4eae-8aba-4ae76f62e8ef","name","routes","fileType","directory","content","createdAt",["D",1748869450380],"branchVersion","branchId","f7c6152c-3fb0-11f0-a22a-76b3cceeab13",{"_30":44,"_32":45,"_34":46,"_36":47,"_37":48,"_39":14,"_40":41,"_24":25},"backend/routes/artists.ts","12fe96c4-3fb2-11f0-b01e-76b3cceeab13","artists.ts","script","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;",["D",1748869450380],"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",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":41,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"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",{"_49":50,"_32":51,"_37":235,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":236,"_86":237,"_88":238,"_90":25},"tree",[176,182,184,185],"files",[176,177,178,179,180,181,182,183,184,185],"counts",{"_166":68,"_167":143,"_168":68,"_169":170,"_171":172},"contents",[132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":160,"_32":161,"_30":162,"_139":-5,"_40":41,"_39":163,"_141":64,"_37":164,"_13":68,"_34":35,"_36":-5,"_24":25,"_145":-5,"_27":165},{"_49":154,"_32":155,"_30":156,"_139":-5,"_40":41,"_39":157,"_141":64,"_37":158,"_13":68,"_34":35,"_36":-5,"_24":25,"_145":-5,"_27":159},{"_49":147,"_32":148,"_30":149,"_139":-5,"_40":41,"_39":150,"_141":64,"_37":151,"_13":68,"_34":21,"_36":152,"_24":25,"_145":-5,"_27":153},{"_49":136,"_32":137,"_30":138,"_139":-5,"_40":41,"_39":140,"_141":25,"_37":142,"_13":143,"_34":46,"_36":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,"create an app that allows users to post job openings and have a public chat room to talk about opportunities","label",[137],"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],"f2ca6ee6-3fb1-11f0-a27e-76b3cceeab13","backend","435588e4-ceb0-40c3-ae7c-fe7395ea06cf",5,["D",1748869396340],[161],"pulls","branches","forks","envVars",{"_173":68,"_175":68},"connections",{"_173":68,"_174":68},"count","unfilledCount","emptyCount",{"_49":160,"_32":161,"_30":162,"_139":-5,"_40":41,"_39":163,"_141":64,"_37":232,"_13":68,"_34":35,"_36":-5,"_24":25,"_145":-5,"_187":233,"_27":234},{"_49":228,"_32":220,"_30":214,"_139":162,"_40":41,"_39":163,"_141":64,"_37":229,"_13":68,"_34":35,"_36":-5,"_24":25,"_145":-5,"_187":230,"_27":231},{"_49":221,"_32":222,"_30":223,"_139":214,"_40":41,"_39":163,"_141":64,"_37":224,"_13":68,"_34":46,"_36":225,"_24":25,"_145":-5,"_187":226,"_27":227},{"_49":211,"_32":212,"_30":213,"_139":214,"_40":41,"_39":215,"_141":64,"_37":216,"_13":68,"_34":46,"_36":217,"_24":25,"_145":-5,"_187":218,"_27":219},{"_49":207,"_32":33,"_30":31,"_139":162,"_40":41,"_39":14,"_141":64,"_37":208,"_13":68,"_34":35,"_36":-5,"_24":25,"_145":-5,"_187":209,"_27":210},{"_49":203,"_32":45,"_30":44,"_139":31,"_40":41,"_39":14,"_141":64,"_37":204,"_13":68,"_34":46,"_36":47,"_24":25,"_145":-5,"_187":205,"_27":206},{"_49":154,"_32":155,"_30":156,"_139":-5,"_40":41,"_39":157,"_141":64,"_37":200,"_13":68,"_34":35,"_36":-5,"_24":25,"_145":-5,"_187":201,"_27":202},{"_49":193,"_32":194,"_30":195,"_139":156,"_40":41,"_39":157,"_141":64,"_37":196,"_13":68,"_34":46,"_36":197,"_24":25,"_145":-5,"_187":198,"_27":199},{"_49":147,"_32":148,"_30":149,"_139":-5,"_40":41,"_39":150,"_141":64,"_37":190,"_13":68,"_34":21,"_36":152,"_24":25,"_145":-5,"_187":191,"_27":192},{"_49":136,"_32":137,"_30":138,"_139":-5,"_40":41,"_39":140,"_141":25,"_37":186,"_13":143,"_34":46,"_36":144,"_24":25,"_145":-5,"_187":188,"_27":189},["D",1748869117403],"children",[],[137],["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,194],["D",1748869381455],[183],[155],"12fe95fc-3fb2-11f0-b01e-76b3cceeab13",["D",1748869450380],[],[161,33,45],"12fea3b2-3fb2-11f0-b01e-76b3cceeab13",["D",1748869450380],[181],[161,33],"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}",[],[161,220,212],"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};",[],[161,220,222],"f2ca70ee-3fb1-11f0-a27e-76b3cceeab13",["D",1748869396340],[178,179],[161,220],["D",1748869396340],[177,180],[161],["D",1748868975217],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":41,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":272,"_273":274,"_275":276,"_277":25,"_278":25,"_279":25,"_280":64,"_281":-5,"_282":-7,"_283":-7,"_284":68,"_285":25,"_286":25,"_287":-5,"_288":25,"_289":25,"_290":25,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":92,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"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"]

Diff · v7