\n {[1, 2, 3, 4, 5].map((star) => (\n onRate(star)}\n style={{ cursor: 'pointer', color: star <= rating ? 'gold' : 'gray' }}\n >\n \n \n ))}\n

\n );\n}\n\nfunction DetailView({ item, type, onClose }) {\n const [comments, setComments] = useState([]);\n const [newComment, setNewComment] = useState('');\n const [rating, setRating] = useState(0);\n\n useEffect(() => {\n fetchComments();\n fetchRating();\n }, []);\n\n const fetchComments = async () => {\n const response = await fetch(`/${type}/${item.id}/comments`);\n if (response.ok) {\n const data = await response.json();\n setComments(data);\n }\n };\n\n const fetchRating = async () => {\n const response = await fetch(`/${type}/${item.id}/rating`);\n if (response.ok) {\n const data = await response.json();\n setRating(data.rating);\n }\n };\n\n const addComment = async () => {\n const response = await fetch(`/${type}/${item.id}/comments`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ comment: newComment }),\n });\n if (response.ok) {\n setNewComment('');\n fetchComments();\n }\n };\n\n const addRating = async (newRating) => {\n const response = await fetch(`/${type}/${item.id}/rating`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ rating: newRating }),\n });\n if (response.ok) {\n setRating(newRating);\n }\n };\n\n return (\n

\n \n

{item.name}

\n {item.image && {item.name}

}\n {item.address &&

주소: {item.address}

}\n {item.phone &&

전화번호: {item.phone}

}\n {item.description &&

설명: {item.description}

}\n

평점

\n \n

\n {comments.map((comment, index) => (\n

{comment}

\n ))}\n setNewComment(e.target.value)}\n placeholder=\"댓글 작성\"\n />\n \n

\n );\n}\n\nfunction App() {\n const [page, setPage] = useState(\"clinics\");\n const [search, setSearch] = useState(\"\");\n const [clinics, setClinics] = useState([]);\n const [pharmacies, setPharmacies] = useState([]);\n const [diseases, setDiseases] = useState([]);\n const [lostPets, setLostPets] = useState([]);\n const [favorites, setFavorites] = useState({\n clinics: [],\n pharmacies: [],\n diseases: []\n });\n const [selectedItem, setSelectedItem] = useState(null);\n\n useEffect(() => {\n fetchInitialData();\n fetchFavorites();\n }, [page]);\n\n const fetchInitialData = async () => {\n const response = await fetch(`/search?type=${page}&query=`);\n if (response.ok) {\n const data = await response.json();\n if (page === \"clinics\") setClinics(data);\n else if (page === \"pharmacies\") setPharmacies(data);\n else if (page === \"diseases\") setDiseases(data);\n else if (page === \"lostPets\") setLostPets(data);\n }\n };\n\n const fetchFavorites = async () => {\n const response = await fetch(\"/favorites\");\n if (response.ok) {\n const data = await response.json();\n setFavorites(data);\n }\n };\n\n const handleSearch = async (e) => {\n if (e.key === \"Enter\" || e.type === \"click\") {\n const response = await fetch(`/search?type=${page}&query=${encodeURIComponent(search)}`);\n if (response.ok) {\n const data = await response.json();\n if (page === \"clinics\") setClinics(data);\n else if (page === \"pharmacies\") setPharmacies(data);\n else if (page === \"diseases\") setDiseases(data);\n else if (page === \"lostPets\") setLostPets(data);\n }\n }\n };\n\n const toggleFavorite = async (item, type) => {\n const method = favorites[type].some(fav => fav.id === item.id) ? 'DELETE' : 'POST';\n const response = await fetch(`/favorites/${type}`, {\n method,\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(item),\n });\n if (response.ok) {\n fetchFavorites();\n }\n };\n\n const addLostPet = async (petData) => {\n const response = await fetch(\"/lostPets\", {\n method: \"POST\",\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(petData),\n });\n if (response.ok) {\n fetchInitialData();\n }\n };\n\n const renderSearchResults = () => {\n let items = [];\n let type = \"\";\n\n if (page === \"clinics\") {\n items = clinics;\n type = \"clinics\";\n } else if (page === \"pharmacies\") {\n items = pharmacies;\n type = \"pharmacies\";\n } else if (page === \"diseases\") {\n items = diseases;\n type = \"diseases\";\n } else if (page === \"lostPets\") {\n items = lostPets;\n type = \"lostPets\";\n }\n\n return (\n

검색 결과

\n {items.map((item) => (\n

setSelectedItem({ item, type })} style={{ cursor: 'pointer' }}>{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description.substring(0, 100)}...

}\n {item.image && {item.name}

}\n {type !== \"lostPets\" && (\n \n )}\n

\n ))}\n

\n );\n };\n\n const renderFavorites = () => {\n return (\n

저장된 항목

\n {Object.entries(favorites).map(([type, items]) => (\n

\n {items.map((item) => (\n

setSelectedItem({ item, type })} style={{ cursor: 'pointer' }}>{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description.substring(0, 100)}...

}\n \n

\n ))}\n

\n );\n };\n\n const renderLostPetForm = () => {\n return (\n

잃어버린 동물 등록

\n \n

\n );\n };\n\n return (\n

\n \n

\n {page === \"clinics\" && \"대한민국 동물병원 검색\"}\n {page === \"pharmacies\" && \"대한민국 동물약국 검색\"}\n {page === \"diseases\" && \"동물 질병 및 케어 정보 검색\"}\n {page === \"lostPets\" && \"실종 동물 게시판\"}\n

\n setSearch(e.target.value)}\n onKeyPress={handleSearch}\n placeholder={`${page === \"clinics\" ? \"동물병원\" : page === \"pharmacies\" ? \"동물약국\" : page === \"diseases\" ? \"질병\" : \"실종 동물\"} 이름 또는 지역 입력`}\n />\n \n

\n {page === \"lostPets\" && renderLostPetForm()}\n {renderSearchResults()}\n {renderFavorites()}\n {selectedItem && (\n setSelectedItem(null)}\n />\n )}\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 4\n const KEY = \"animalInfoIngpracticalBlushAlbatross\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_favorites_clinics_${SCHEMA_VERSION} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n address TEXT NOT NULL,\n phone TEXT NOT NULL,\n image TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_favorites_pharmacies_${SCHEMA_VERSION} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n address TEXT NOT NULL,\n phone TEXT NOT NULL,\n image TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_favorites_diseases_${SCHEMA_VERSION} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n image TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_lost_pets_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n image TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_comments_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n item_id TEXT NOT NULL,\n item_type TEXT NOT NULL,\n comment TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_ratings_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n item_id TEXT NOT NULL,\n item_type TEXT NOT NULL,\n rating INTEGER NOT NULL\n )\n `);\n\n const url = new URL(request.url);\n const path = url.pathname;\n\n if (path === \"/search\") {\n const query = url.searchParams.get(\"query\") || \"\";\n const type = url.searchParams.get(\"type\") || \"clinics\";\n \n let dummyData = [];\n if (type === \"clinics\") {\n dummyData = [\n { id: \"1\", name: \"행복 동물병원\", address: \"서울시 강남구\", phone: \"02-1234-5678\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"2\", name: \"사랑 동물병원\", address: \"서울시 서초구\", phone: \"02-2345-6789\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"3\", name: \"건강 동물병원\", address: \"서울시 송파구\", phone: \"02-3456-7890\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"4\", name: \"미소 동물병원\", address: \"서울시 강동구\", phone: \"02-4567-8901\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"5\", name: \"희망 동물병원\", address: \"서울시 성동구\", phone: \"02-5678-9012\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"6\", name: \"푸른 동물병원\", address: \"서울시 마포구\", phone: \"02-6789-0123\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"7\", name: \"따뜻한 동물병원\", address: \"서울시 용산구\", phone: \"02-7890-1234\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"8\", name: \"친절한 동물병원\", address: \"서울시 중구\", phone: \"02-8901-2345\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"9\", name: \"믿음 동물병원\", address: \"서울시 종로구\", phone: \"02-9012-3456\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"10\", name: \"안심 동물병원\", address: \"서울시 동대문구\", phone: \"02-0123-4567\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n ];\n } else if (type === \"pharmacies\") {\n dummyData = [\n { id: \"1\", name: \"행복 동물약국\", address: \"서울시 강남구\", phone: \"02-1111-2222\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"2\", name: \"사랑 동물약국\", address: \"서울시 서초구\", phone: \"02-2222-3333\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"3\", name: \"건강 동물약국\", address: \"서울시 송파구\", phone: \"02-3333-4444\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"4\", name: \"미소 동물약국\", address: \"서울시 강동구\", phone: \"02-4444-5555\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"5\", name: \"희망 동물약국\", address: \"서울시 성동구\", phone: \"02-5555-6666\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"6\", name: \"푸른 동물약국\", address: \"서울시 마포구\", phone: \"02-6666-7777\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"7\", name: \"따뜻한 동물약국\", address: \"서울시 용산구\", phone: \"02-7777-8888\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"8\", name: \"친절한 동물약국\", address: \"서울시 중구\", phone: \"02-8888-9999\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"9\", name: \"믿음 동물약국\", address: \"서울시 종로구\", phone: \"02-9999-0000\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"10\", name: \"안심 동물약국\", address: \"서울시 동대문구\", phone: \"02-0000-1111\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n ];\n } else if (type === \"diseases\") {\n dummyData = [\n { id: \"1\", name: \"개 파보바이러스\", description: \"심각한 장염을 일으키는 바이러스성 질병\", image: \"https://media.cleanshot.cloud/media/50163/TlXJWkqsRXs2SsYULHIgLcKxYNDqVJr1CJOoxc9z.png?Expires=1731055857&Signature=p3HHs~rVAekbL0ZAlEYScwtrLaxfcLnOA-XpuRuAudZpQbK7PEtuuhkTZS7SU4coM-NlF06g-FwhIIin~htwo1L0t1w~JWHZRdArioQwIsq9xtU1LYWrgWI3Liz0oLZvykAhvSH~krjcGee~wke2O2qMxqkpxLwK39bafnuy5gnlrtRZ11jDC1Uo4WqAGY~lpgmE-1~~ny5a83VRIpdh1urAd~TQb0Zu00CjUU6RppqE6SCIAoqYNapj6bcBUPuxYcgg9Um1zX-Lh~1eq-df6NLRi2d3O5tFNq22eCsFyskbOLSCOa50mE4CUFJagRJ2MVcWME-XdTKUcSHCnIFjoQ__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"2\", name: \"고양이 백혈병\", description: \"면역체계를 약화시키는 바이러스성 질병\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"3\", name: \"개 디스템퍼\", description: \"호흡기, 소화기, 신경계에 영향을 미치는 바이러스성 질병\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"4\", name: \"고양이 전염성 복막염\", description: \"복막에 염증을 일으키는 바이러스성 질병\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"5\", name: \"개 케넬코프\", description: \"전염성이 강한 호흡기 질환\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"6\", name: \"고양이 상부 호흡기 감염\", description: \"코감기와 유사한 증상을 보이는 질병\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"7\", name: \"개 심장사상충\", description: \"모기를 통해 전염되는 기생충 질병\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"8\", name: \"고양이 당뇨병\", description: \"인슐린 분비나 기능에 문제가 생기는 대사성 질환\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"9\", name: \"개 관절염\", description: \"관절에 염증이 생기는 만성 질환\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n { id: \"10\", name: \"고양이 신부전\", description: \"신장 기능이 저하되는 만성 질환\", image: \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\" },\n ];\n } else if (type === \"lostPets\") {\n const pets = await sqlite.execute(`SELECT * FROM ${KEY}_lost_pets_${SCHEMA_VERSION}`);\n dummyData = pets.rows.map(pet => ({\n ...pet,\n image: pet.name.toLowerCase().includes(\"고양이\") ? \"https://media.cleanshot.cloud/media/50163/Uf42elMIgjYkHwQoIXpFiM5QHit6VIatDasVXD8u.png?Expires=1731055828&Signature=ZyiRo1PknzHbyjAWXbBSnKyaD3zX-iBA52Iv~sx5M6jeyVCjLZUtsrAsYq6LhT1MmS3NUP7qXQYDLC725suJ-8UuoMgieHwGFOV~0l-cD8JSf0SrU6hmmSzKjXZB6lkMgdW7FiR91hpAp9z8uNwrcChpkW79784YGPeUGVbXr6YoJy0AbKbV~U-5YQpztAwVdUp4vZ2DV201Q2UXfzk1mhru8YMZcN8bcyhKa0~Za3xHD8hM8k~KqWtc5UO-uRTqmUUCsii-cmvwAwKyjuDPEL4IdLHBVH5YTLGF1tI8lsZQTtldR7qbD3kOH8Mvl92MswehlO-qmWZl5V9q6kEncw__&Key-Pair-Id=K269JMAT9ZF4GZ\" : \"https://media.cleanshot.cloud/media/50163/Uf42elMIgjYkHwQoIXpFiM5QHit6VIatDasVXD8u.png?Expires=1731055828&Signature=ZyiRo1PknzHbyjAWXbBSnKyaD3zX-iBA52Iv~sx5M6jeyVCjLZUtsrAsYq6LhT1MmS3NUP7qXQYDLC725suJ-8UuoMgieHwGFOV~0l-cD8JSf0SrU6hmmSzKjXZB6lkMgdW7FiR91hpAp9z8uNwrcChpkW79784YGPeUGVbXr6YoJy0AbKbV~U-5YQpztAwVdUp4vZ2DV201Q2UXfzk1mhru8YMZcN8bcyhKa0~Za3xHD8hM8k~KqWtc5UO-uRTqmUUCsii-cmvwAwKyjuDPEL4IdLHBVH5YTLGF1tI8lsZQTtldR7qbD3kOH8Mvl92MswehlO-qmWZl5V9q6kEncw__&Key-Pair-Id=K269JMAT9ZF4GZ\"\n }));\n }\n \n const filteredData = dummyData.filter(item => \n item.name.includes(query) || \n (item.address && item.address.includes(query)) || \n (item.description && item.description.includes(query))\n );\n \n return new Response(JSON.stringify(filteredData), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (path.startsWith(\"/favorites\")) {\n const type = path.split(\"/\")[2];\n if (request.method === \"GET\") {\n const clinics = await sqlite.execute(`SELECT * FROM ${KEY}_favorites_clinics_${SCHEMA_VERSION}`);\n const pharmacies = await sqlite.execute(`SELECT * FROM ${KEY}_favorites_pharmacies_${SCHEMA_VERSION}`);\n const diseases = await sqlite.execute(`SELECT * FROM ${KEY}_favorites_diseases_${SCHEMA_VERSION}`);\n return new Response(JSON.stringify({\n clinics: clinics.rows,\n pharmacies: pharmacies.rows,\n diseases: diseases.rows\n }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } else if (request.method === \"POST\") {\n const item = await request.json();\n if (type === \"clinics\" || type === \"pharmacies\") {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${KEY}_favorites_${type}_${SCHEMA_VERSION} (id, name, address, phone, image) VALUES (?, ?, ?, ?, ?)`,\n [item.id, item.name, item.address, item.phone, \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\"]\n );\n } else if (type === \"diseases\") {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${KEY}_favorites_diseases_${SCHEMA_VERSION} (id, name, description, image) VALUES (?, ?, ?, ?)`,\n [item.id, item.name, item.description, \"https://media.cleanshot.cloud/media/50163/YdnK2ZuKbqaWg1UfFxiITQrftJJlB3McZyWKwVxX.png?Expires=1731055936&Signature=V26jchUjky6B0OD25sGIgKiLrB8cgSdCuywfLSOn1X5x8o69bJw9g-lI6WCf1TuJD9RSXbxk2D~lHP3ZNP4uWKjEGKACOYWOaOgoPHl065gx2-zxL~lImTyPRk4dlu3wvTYkTxZSm9VwQ5diQxaoSmMRbJC3iEaK~irBaYrVHeye~TR9OQhFXU~Nt6bmhrGbDS7RE1yivLetKGOzL~TKSjuzIbfaZvR1XU-J98cMo-N7bGWJURcwmv9cWF~p8d3rM8XgKd5H0-2Uil8ZWx09OICzcjeNVCYWi4JVWixbV2KkvmImKgix10VLZrSkwRykYSJC-JmRcnySLl02~KTvWg__&Key-Pair-Id=K269JMAT9ZF4GZ\"]\n );\n }\n return new Response(null, { status: 200 });\n } else if (request.method === \"DELETE\") {\n const item = await request.json();\n await sqlite.execute(`DELETE FROM ${KEY}_favorites_${type}_${SCHEMA_VERSION} WHERE id = ?`, [item.id]);\n return new Response(null, { status: 200 });\n }\n }\n\n if (path === \"/lostPets\") {\n if (request.method === \"POST\") {\n const { name, description, image } = await request.json();\n const petImage = name.toLowerCase().includes(\"고양이\") ? \"https://share.cleanshot.com/VBt56pwJ\" : \"https://share.cleanshot.com/Qf6k3H7t\";\n await sqlite.execute(\n `INSERT INTO ${KEY}_lost_pets_${SCHEMA_VERSION} (name, description, image) VALUES (?, ?, ?)`,\n [name, description, petImage]\n );\n return new Response(null, { status: 200 });\n }\n }\n\n if (path.match(/\\/(clinics|pharmacies|diseases|lostPets)\\/\\d+\\/comments/)) {\n const [, type, id] = path.split(\"/\");\n if (request.method === \"GET\") {\n const comments = await sqlite.execute(\n `SELECT comment FROM ${KEY}_comments_${SCHEMA_VERSION} WHERE item_id = ? AND item_type = ?`,\n [id, type]\n );\n return new Response(JSON.stringify(comments.rows.map(row => row.comment)), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } else if (request.method === \"POST\") {\n const { comment } = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_comments_${SCHEMA_VERSION} (item_id, item_type, comment) VALUES (?, ?, ?)`,\n [id, type, comment]\n );\n return new Response(null, { status: 200 });\n }\n }\n\n if (path.match(/\\/(clinics|pharmacies|diseases|lostPets)\\/\\d+\\/rating/)) {\n const [, type, id] = path.split(\"/\");\n if (request.method === \"GET\") {\n const rating = await sqlite.execute(\n `SELECT AVG(rating) as avg_rating FROM ${KEY}_ratings_${SCHEMA_VERSION} WHERE item_id = ? AND item_type = ?`,\n [id, type]\n );\n return new Response(JSON.stringify({ rating: rating.rows[0].avg_rating || 0 }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } else if (request.method === \"POST\") {\n const { rating } = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_ratings_${SCHEMA_VERSION} (item_id, item_type, rating) VALUES (?, ?, ?)`,\n [id, type, rating]\n );\n return new Response(null, { status: 200 });\n }\n }\n\n return new Response(`\n \n \n 대한민국 동물 의료 정보\n \n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html;charset=UTF-8\",\n },\n });\n}\n\nconst css = `\nbody {\n font-family: 'Nanum Gothic', sans-serif;\n margin: 0;\n padding: 0;\n background-color: #f0f0f0;\n}\n.container {\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n}\nh1, h2, h3, h4 {\n color: #333;\n}\nnav {\n margin-bottom: 20px;\n}\nnav button {\n margin-right: 10px;\n padding: 10px 15px;\n font-size: 16px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n}\nnav button:hover {\n background-color: #45a049;\n}\n.search-container {\n display: flex;\n margin-bottom: 20px;\n}\ninput, textarea {\n flex-grow: 1;\n padding: 10px;\n font-size: 16px;\n border: 1px solid #ddd;\n border-radius: 4px;\n margin-bottom: 10px;\n}\nbutton {\n padding: 10px 20px;\n font-size: 16px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n}\nbutton:hover {\n background-color: #45a049;\n}\n.item {\n background-color: white;\n border: 1px solid #ddd;\n border-radius: 4px;\n padding: 15px;\n margin-bottom: 10px;\n}\n.item h3, .item h4 {\n margin-top: 0;\n}\n.item button {\n margin-top: 10px;\n border-radius: 4px;\n}\n.pet-image, .detail-image {\n max-width: 100%;\n height: auto;\n margin-bottom: 10px;\n}\n.lost-pet-form {\n background-color: white;\n border: 1px solid #ddd;\n border-radius: 4px;\n padding: 15px;\n margin-bottom: 20px;\n}\n.lost-pet-form form {\n display: flex;\n flex-direction: column;\n}\n.detail-view {\n position: fixed;\n top: 0;\n left: 0;\n right: 0;\n bottom: 0;\n background-color: rgba(0, 0, 0, 0.8);\n display: flex;\n justify-content: center;\n align-items: center;\n}\n.detail-view > div {\n background-color: white;\n padding: 20px;\n border-radius: 8px;\n max-width: 80%;\n max-height: 80%;\n overflow-y: auto;\n}\n`;","deleted","label","children",[],[99],"files",[151],"counts",{"_173":32,"_174":175,"_176":32,"_177":32},"pulls","branches",1,"forks","envVars","contents",[],"file",{"_103":152,"_155":139,"_153":116,"_95":99,"_162":163,"_160":161,"_100":159,"_154":-5,"_105":182,"_156":138,"_165":-5,"_98":183},["D",1731034564623],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":192,"_180":197,"_200":201,"_231":232,"_241":-7,"_242":32,"_243":22},{"_103":104,"_95":96,"_105":193,"_107":-5,"_108":109,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":116,"_117":109,"_118":-5,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":194,"_133":195,"_136":196,"_148":22},["D",1746194407299],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_100":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},{"_103":152,"_95":99,"_153":116,"_154":-5,"_155":139,"_156":138,"_157":109,"_105":198,"_100":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":199},["D",1731034564623],[99],"history",[202,204,208,213,218,223,227],{"_103":152,"_155":139,"_153":116,"_95":99,"_162":163,"_160":161,"_100":159,"_154":-5,"_105":203,"_156":138,"_165":-5},["D",1731034564623],{"_103":205,"_155":139,"_153":116,"_95":99,"_162":163,"_160":161,"_100":206,"_154":-5,"_105":207,"_156":159,"_165":-5},"c14b08a6-275d-11f0-86ff-569c3dd06744",5,["D",1731034564163],{"_103":209,"_155":139,"_153":116,"_95":99,"_162":210,"_160":161,"_100":211,"_154":-5,"_105":212,"_156":206,"_165":-5},"c13dae5e-275d-11f0-86ff-569c3dd06744","/** @jsxImportSource https://esm.sh/react */\nimport React, { useState, useEffect } from \"https://esm.sh/react\";\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\n\nfunction StarRating({ rating, onRate }) {\n return (\n

\n {[1, 2, 3, 4, 5].map((star) => (\n onRate(star)}\n style={{ cursor: 'pointer', color: star <= rating ? 'gold' : 'gray' }}\n >\n ★\n \n ))}\n

\n \n

{item.name}

\n {item.image && {item.name}

}\n {item.address &&

주소: {item.address}

}\n {item.phone &&

전화번호: {item.phone}

}\n {item.description &&

설명: {item.description}

}\n

평점

\n \n

\n {comments.map((comment, index) => (\n

{comment}

\n ))}\n setNewComment(e.target.value)}\n placeholder=\"댓글 작성\"\n />\n \n

검색 결과

\n {items.map((item) => (\n

setSelectedItem({ item, type })} style={{ cursor: 'pointer' }}>{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description.substring(0, 100)}...

}\n {item.image && {item.name}

}\n {type !== \"lostPets\" && (\n \n )}\n

\n ))}\n

\n );\n };\n\n const renderFavorites = () => {\n return (\n

저장된 항목

\n {Object.entries(favorites).map(([type, items]) => (\n

\n {items.map((item) => (\n

setSelectedItem({ item, type })} style={{ cursor: 'pointer' }}>{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description.substring(0, 100)}...

}\n \n

\n ))}\n

\n );\n };\n\n const renderLostPetForm = () => {\n return (\n

잃어버린 동물 등록

\n \n

\n );\n };\n\n return (\n

\n \n

\n {page === \"clinics\" && \"대한민국 동물병원 검색\"}\n {page === \"pharmacies\" && \"대한민국 동물약국 검색\"}\n {page === \"diseases\" && \"동물 질병 및 케어 정보 검색\"}\n {page === \"lostPets\" && \"실종 동물 게시판\"}\n

\n {page === \"lostPets\" && renderLostPetForm()}\n {renderSearchResults()}\n {renderFavorites()}\n {selectedItem && (\n setSelectedItem(null)}\n />\n )}\n

\n {[1, 2, 3, 4, 5].map((star) => (\n onRate(star)}\n style={{ cursor: 'pointer', color: star <= rating ? 'gold' : 'gray' }}\n >\n ★\n \n ))}\n

\n \n

{item.name}

\n {item.image && {item.name}

}\n {item.address &&

주소: {item.address}

}\n {item.phone &&

전화번호: {item.phone}

}\n {item.description &&

설명: {item.description}

}\n

평점

\n \n

\n {comments.map((comment, index) => (\n

{comment}

\n ))}\n setNewComment(e.target.value)}\n placeholder=\"댓글 작성\"\n />\n \n

검색 결과

\n {items.map((item) => (\n

setSelectedItem({ item, type })} style={{ cursor: 'pointer' }}>{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description.substring(0, 100)}...

}\n {item.image && {item.name}

}\n {type !== \"lostPets\" && (\n \n )}\n

\n ))}\n

\n );\n };\n\n const renderFavorites = () => {\n return (\n

저장된 항목

\n {Object.entries(favorites).map(([type, items]) => (\n

\n {items.map((item) => (\n

setSelectedItem({ item, type })} style={{ cursor: 'pointer' }}>{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description.substring(0, 100)}...

}\n \n

\n ))}\n

\n );\n };\n\n const renderLostPetForm = () => {\n return (\n

잃어버린 동물 등록

\n \n

\n );\n };\n\n return (\n

\n \n

\n {page === \"clinics\" && \"대한민국 동물병원 검색\"}\n {page === \"pharmacies\" && \"대한민국 동물약국 검색\"}\n {page === \"diseases\" && \"동물 질병 및 케어 정보 검색\"}\n {page === \"lostPets\" && \"실종 동물 게시판\"}\n

\n {page === \"lostPets\" && renderLostPetForm()}\n {renderSearchResults()}\n {renderFavorites()}\n {selectedItem && (\n setSelectedItem(null)}\n />\n )}\n

\n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html;charset=UTF-8\",\n },\n });\n}\n\nconst css = `\nbody {\n font-family: 'Nanum Gothic', sans-serif;\n margin: 0;\n padding: 0;\n background-color: #f0f0f0;\n}\n.container {\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n}\nh1, h2, h3, h4 {\n color: #333;\n}\nnav {\n margin-bottom: 20px;\n}\nnav button {\n margin-right: 10px;\n padding: 10px 15px;\n font-size: 16px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n}\nnav button:hover {\n background-color: #45a049;\n}\n.search-container {\n display: flex;\n margin-bottom: 20px;\n}\ninput, textarea {\n flex-grow: 1;\n padding: 10px;\n font-size: 16px;\n border: 1px solid #ddd;\n border-radius: 4px;\n margin-bottom: 10px;\n}\nbutton {\n padding: 10px 20px;\n font-size: 16px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n}\nbutton:hover {\n background-color: #45a049;\n}\n.item {\n background-color: white;\n border: 1px solid #ddd;\n border-radius: 4px;\n padding: 15px;\n margin-bottom: 10px;\n}\n.item h3, .item h4 {\n margin-top: 0;\n}\n.item button {\n margin-top: 10px;\n border-radius: 4px;\n}\n.pet-image, .detail-image {\n max-width: 100%;\n height: auto;\n margin-bottom: 10px;\n}\n.lost-pet-form {\n background-color: white;\n border: 1px solid #ddd;\n border-radius: 4px;\n padding: 15px;\n margin-bottom: 20px;\n}\n.lost-pet-form form {\n display: flex;\n flex-direction: column;\n}\n.detail-view {\n position: fixed;\n top: 0;\n left: 0;\n right: 0;\n bottom: 0;\n background-color: rgba(0, 0, 0, 0.8);\n display: flex;\n justify-content: center;\n align-items: center;\n}\n.detail-view > div {\n background-color: white;\n padding: 20px;\n border-radius: 8px;\n max-width: 80%;\n max-height: 80%;\n overflow-y: auto;\n}\n`;",3,["D",1731031472689],{"_103":219,"_155":139,"_153":116,"_95":99,"_162":220,"_160":161,"_100":221,"_154":-5,"_105":222,"_156":216,"_165":-5},"c12b53c6-275d-11f0-86ff-569c3dd06744","/** @jsxImportSource https://esm.sh/react */\nimport React, { useState, useEffect } from \"https://esm.sh/react\";\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\n\nfunction App() {\n const [page, setPage] = useState(\"clinics\");\n const [search, setSearch] = useState(\"\");\n const [clinics, setClinics] = useState([]);\n const [pharmacies, setPharmacies] = useState([]);\n const [diseases, setDiseases] = useState([]);\n const [lostPets, setLostPets] = useState([]);\n const [favorites, setFavorites] = useState({\n clinics: [],\n pharmacies: [],\n diseases: []\n });\n\n useEffect(() => {\n fetchInitialData();\n fetchFavorites();\n }, [page]);\n\n const fetchInitialData = async () => {\n const response = await fetch(`/search?type=${page}&query=`);\n if (response.ok) {\n const data = await response.json();\n if (page === \"clinics\") setClinics(data);\n else if (page === \"pharmacies\") setPharmacies(data);\n else if (page === \"diseases\") setDiseases(data);\n else if (page === \"lostPets\") setLostPets(data);\n }\n };\n\n const fetchFavorites = async () => {\n const response = await fetch(\"/favorites\");\n if (response.ok) {\n const data = await response.json();\n setFavorites(data);\n }\n };\n\n const handleSearch = async (e) => {\n if (e.key === \"Enter\" || e.type === \"click\") {\n const response = await fetch(`/search?type=${page}&query=${encodeURIComponent(search)}`);\n if (response.ok) {\n const data = await response.json();\n if (page === \"clinics\") setClinics(data);\n else if (page === \"pharmacies\") setPharmacies(data);\n else if (page === \"diseases\") setDiseases(data);\n else if (page === \"lostPets\") setLostPets(data);\n }\n }\n };\n\n const toggleFavorite = async (item, type) => {\n const method = favorites[type].some(fav => fav.id === item.id) ? 'DELETE' : 'POST';\n const response = await fetch(`/favorites/${type}`, {\n method,\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(item),\n });\n if (response.ok) {\n fetchFavorites();\n }\n };\n\n const addLostPet = async (petData) => {\n const response = await fetch(\"/lostPets\", {\n method: \"POST\",\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(petData),\n });\n if (response.ok) {\n fetchInitialData();\n }\n };\n\n const addComment = async (petId, comment) => {\n const response = await fetch(`/lostPets/${petId}/comments`, {\n method: \"POST\",\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ comment }),\n });\n if (response.ok) {\n fetchInitialData();\n }\n };\n\n const renderSearchResults = () => {\n let items = [];\n let type = \"\";\n\n if (page === \"clinics\") {\n items = clinics;\n type = \"clinics\";\n } else if (page === \"pharmacies\") {\n items = pharmacies;\n type = \"pharmacies\";\n } else if (page === \"diseases\") {\n items = diseases;\n type = \"diseases\";\n } else if (page === \"lostPets\") {\n items = lostPets;\n type = \"lostPets\";\n }\n\n return (\n

검색 결과

\n {items.map((item) => (\n

{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description}

}\n {item.image && {item.name}

}\n {type !== \"lostPets\" && (\n \n )}\n {type === \"lostPets\" && (\n

\n {item.comments && item.comments.map((comment, index) => (\n

{comment}

\n ))}\n {\n if (e.key === \"Enter\") {\n addComment(item.id, e.target.value);\n e.target.value = \"\";\n }\n }}\n />\n

\n )}\n

\n ))}\n

\n );\n };\n\n const renderFavorites = () => {\n return (\n

저장된 항목

\n {Object.entries(favorites).map(([type, items]) => (\n

\n {items.map((item) => (\n

{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description}

}\n \n

\n ))}\n

\n );\n };\n\n const renderLostPetForm = () => {\n return (\n

잃어버린 동물 등록

\n \n

\n );\n };\n\n return (\n

\n \n

\n {page === \"clinics\" && \"대한민국 동물병원 검색\"}\n {page === \"pharmacies\" && \"대한민국 동물약국 검색\"}\n {page === \"diseases\" && \"동물 질병 및 케어 정보 검색\"}\n {page === \"lostPets\" && \"실종 동물 게시판\"}\n

\n {page === \"lostPets\" && renderLostPetForm()}\n {renderSearchResults()}\n {renderFavorites()}\n

검색 결과

\n {items.map((item) => (\n

{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description}

}\n \n

\n ))}\n

\n );\n };\n\n const renderFavorites = () => {\n return (\n

저장된 항목

\n {Object.entries(favorites).map(([type, items]) => (\n

{type === \"clinics\" ? \"동물병원\" : type === \"pharmacies\" ? \"동물약국\" : \"질병 정보\"}

\n {items.map((item) => (\n

{item.name}

\n {item.address &&

{item.address}

}\n {item.phone &&

{item.phone}

}\n {item.description &&

{item.description}

}\n \n

\n ))}\n

\n );\n };\n\n return (\n

\n \n

\n {page === \"clinics\" && \"대한민국 동물병원 검색\"}\n {page === \"pharmacies\" && \"대한민국 동물약국 검색\"}\n {page === \"diseases\" && \"동물 질병 및 케어 정보 검색\"}\n

\n setSearch(e.target.value)}\n placeholder={`${page === \"clinics\" ? \"동물병원\" : page === \"pharmacies\" ? \"동물약국\" : \"질병\"} 이름 또는 지역 입력`}\n />\n \n

\n {renderSearchResults()}\n {renderFavorites()}\n

대한민국 동물병원 검색

\n setSearch(e.target.value)}\n placeholder=\"동물병원 이름 또는 지역 입력\"\n />\n \n

검색 결과

\n {clinics.map((clinic) => (\n

{clinic.name}

{clinic.address}

{clinic.phone}

\n \n

\n ))}\n

저장된 동물병원

\n {favorites.map((clinic) => (\n

{clinic.name}

{clinic.address}

{clinic.phone}

\n \n

\n ))}\n

History for main.tsx