[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_224":225,"_226":227},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":53,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_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",57,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","export-version.ts","latestPath","fileId","bbf79d10-78dd-11f1-8632-1607ee4eb77e","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\n// 매월 20일 실행: 아래 국가별 버전 테이블의 버전정보를 국가별 json으로 만들어\n// Supabase Storage에 업로드하고 다운로드 링크를 생성합니다.\n//\n// 대상 국가: KR, US, GB, CA, CH, AT, JP (국가별 개별 파일)\n\nconst COUNTRIES = [\n { code: \"KR\", name: \"대한민국\" },\n { code: \"US\", name: \"미국\" },\n { code: \"GB\", name: \"영국\" },\n { code: \"CA\", name: \"캐나다\" },\n { code: \"CH\", name: \"스위스\" },\n { code: \"AT\", name: \"오스트리아\" },\n { code: \"JP\", name: \"일본\" },\n];\n\nconst COUNTRY_VERSIONS: Record = {\n KR: { countryName: \"대한민국\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n US: { countryName: \"미국\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n GB: { countryName: \"영국\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n CA: { countryName: \"캐나다\", version: \"1.0.2\", updatedAt: \"2026-07-28\" },\n CH: { countryName: \"스위스\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n AT: { countryName: \"오스트리아\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n JP: { countryName: \"일본\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n};\n\nconst SUPABASE_BUCKET = \"holidays\";\n\nasync function exportToSupabase() {\n // 2. Supabase 클라이언트 초기화\n const supabaseUrl = Deno.env.get(\"SUPABASE_URL\");\n const supabaseKey = Deno.env.get(\"SUPABASE_KEY\");\n\n if (!supabaseUrl || !supabaseKey) {\n throw new Error(\n \"supabaseURL, supabaseKey 환경변수가 설정되어 있지 않습니다.\",\n );\n }\n\n const supabase = createClient(supabaseUrl, supabaseKey);\n\n // 3. 국가별로 데이터 조회 → JSON 생성 → Supabase 업로드\n const results: Array<{\n countryCode: string;\n countryName: string;\n version: number;\n updatedAt: string;\n }> = [];\n\n for (const { code, name } of COUNTRIES) {\n // SQLite에서 해당 국가의 4개년 공휴일 조회\n\n const info = COUNTRY_VERSIONS[code];\n\n // JSON 데이터 구성\n const jsonData = {\n countryCode: code,\n countryName: name,\n version: info.version,\n updatedAt: info.updatedAt,\n exportedAt: new Date().toISOString(),\n };\n\n const jsonStr = JSON.stringify(jsonData, null, 2);\n\n const fileName = `version_${code}.json`;\n\n // Supabase Storage에 업로드 (upsert: 기존 파일 덮어쓰기)\n const { error: uploadError } = await supabase.storage\n .from(SUPABASE_BUCKET)\n .upload(fileName, jsonStr, {\n contentType: \"application/json\",\n upsert: true,\n });\n\n if (uploadError) {\n console.error(`❌ ${name}(${code}) 업로드 실패:`, uploadError.message);\n continue;\n }\n\n // 공개 다운로드 URL 생성\n const { data: urlData } = supabase.storage\n .from(SUPABASE_BUCKET)\n .getPublicUrl(fileName);\n\n results.push({\n country: code,\n countryName: name,\n version: info.version,\n downloadUrl: urlData.publicUrl,\n });\n }\n\n // 4. 결과 요약 출력\n console.log(\"\\n📦 Supabase 업로드 완료!\");\n\n console.log(\" 다운로드 링크:\");\n for (const r of results) {\n console.log(` - ${r.countryName}(${r.country}): `);\n console.log(` ${r.downloadUrl}`);\n }\n\n return results;\n}\n\nexport default async function (interval: Interval) {\n console.log(\n `🔄 공휴일 데이터 Supabase 내보내기 시작 - ${new Date().toISOString()}`,\n );\n if (interval?.lastRunAt) {\n console.log(` 이전 실행: ${interval.lastRunAt.toISOString()}`);\n }\n await exportToSupabase();\n console.log(\"✅ 모든 작업 완료!\");\n}","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\n// 매월 20일 실행: 아래 국가별 버전 테이블의 버전정보를 국가별 json으로 만들어\n// Supabase Storage에 업로드하고 다운로드 링크를 생성합니다.\n//\n// 대상 국가: KR, US, GB, CA, CH, AT, JP (국가별 개별 파일)\n\nconst COUNTRIES = [\n { code: \"KR\", name: \"대한민국\" },\n { code: \"US\", name: \"미국\" },\n { code: \"GB\", name: \"영국\" },\n { code: \"CA\", name: \"캐나다\" },\n { code: \"CH\", name: \"스위스\" },\n { code: \"AT\", name: \"오스트리아\" },\n { code: \"JP\", name: \"일본\" },\n];\n\nconst COUNTRY_VERSIONS: Record = {\n KR: { countryName: \"대한민국\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n US: { countryName: \"미국\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n GB: { countryName: \"영국\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n CA: { countryName: \"캐나다\", version: \"1.0.3\", updatedAt: \"2026-07-28\" },\n CH: { countryName: \"스위스\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n AT: { countryName: \"오스트리아\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n JP: { countryName: \"일본\", version: \"1.0.0\", updatedAt: \"2026-07-28\" },\n};\n\nconst SUPABASE_BUCKET = \"holidays\";\n\nasync function exportToSupabase() {\n // 2. Supabase 클라이언트 초기화\n const supabaseUrl = Deno.env.get(\"SUPABASE_URL\");\n const supabaseKey = Deno.env.get(\"SUPABASE_KEY\");\n\n if (!supabaseUrl || !supabaseKey) {\n throw new Error(\n \"supabaseURL, supabaseKey 환경변수가 설정되어 있지 않습니다.\",\n );\n }\n\n const supabase = createClient(supabaseUrl, supabaseKey);\n\n // 3. 국가별로 데이터 조회 → JSON 생성 → Supabase 업로드\n const results: Array<{\n countryCode: string;\n countryName: string;\n version: number;\n updatedAt: string;\n }> = [];\n\n for (const { code, name } of COUNTRIES) {\n // SQLite에서 해당 국가의 4개년 공휴일 조회\n\n const info = COUNTRY_VERSIONS[code];\n\n // JSON 데이터 구성\n const jsonData = {\n countryCode: code,\n countryName: name,\n version: info.version,\n updatedAt: info.updatedAt,\n exportedAt: new Date().toISOString(),\n };\n\n const jsonStr = JSON.stringify(jsonData, null, 2);\n\n const fileName = `version_${code}.json`;\n\n // Supabase Storage에 업로드 (upsert: 기존 파일 덮어쓰기)\n const { error: uploadError } = await supabase.storage\n .from(SUPABASE_BUCKET)\n .upload(fileName, jsonStr, {\n contentType: \"application/json\",\n upsert: true,\n });\n\n if (uploadError) {\n console.error(`❌ ${name}(${code}) 업로드 실패:`, uploadError.message);\n continue;\n }\n\n // 공개 다운로드 URL 생성\n const { data: urlData } = supabase.storage\n .from(SUPABASE_BUCKET)\n .getPublicUrl(fileName);\n\n results.push({\n country: code,\n countryName: name,\n version: info.version,\n downloadUrl: urlData.publicUrl,\n });\n }\n\n // 4. 결과 요약 출력\n console.log(\"\\n📦 Supabase 업로드 완료!\");\n\n console.log(\" 다운로드 링크:\");\n for (const r of results) {\n console.log(` - ${r.countryName}(${r.country}): `);\n console.log(` ${r.downloadUrl}`);\n }\n\n return results;\n}\n\nexport default async function (interval: Interval) {\n console.log(\n `🔄 공휴일 데이터 Supabase 내보내기 시작 - ${new Date().toISOString()}`,\n );\n if (interval?.lastRunAt) {\n console.log(` 이전 실행: ${interval.lastRunAt.toISOString()}`);\n }\n await exportToSupabase();\n console.log(\"✅ 모든 작업 완료!\");\n}","createdAt",["D",1785300828523],"branchVersion","branchId","3440afd6-c159-4ffe-a10a-0b6cc6c62d37","id","349e1f53-a4d5-44d0-9a56-11dba194bad9","holidayinfo",["D",1783289740989],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","287338bb-33db-4607-aeb0-8dcefdff97bc","pinnedFileId","a5e9b408-78c0-11f1-917b-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f32cb-a507-726b-b43f-7a9b59fc62e5","tursoName","349e1f53a4d544d09a5611dba194bad9","tursoHostname","349e1f53a4d544d09a5611dba194bad9-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789524079207],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",87,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jaewookhan","handle","displayName","Jaewook Han","avatar","https://lh3.googleusercontent.com/a/ACg8ocKXsli8FKkVPe4KleIbyUZd87HoWPiWBUA-GpUyF0nmXj12Yrs=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":219,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":220,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":221,"_84":222,"_86":223,"_88":25},"tree",[194,195,196,197,198,199],"files",[194,195,196,197,198,199],"counts",{"_183":63,"_184":185,"_186":63,"_187":188,"_189":190},"contents",[130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":176,"_32":177,"_30":178,"_138":-5,"_41":42,"_40":179,"_140":59,"_38":180,"_13":152,"_33":34,"_35":181,"_24":25,"_144":-5,"_27":182},{"_43":172,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":173,"_13":174,"_33":34,"_35":37,"_24":25,"_144":-5,"_27":175},{"_43":164,"_32":165,"_30":166,"_138":-5,"_41":42,"_40":167,"_140":59,"_38":168,"_13":169,"_33":34,"_35":170,"_24":25,"_144":-5,"_27":171},{"_43":155,"_32":156,"_30":157,"_138":-5,"_41":42,"_40":158,"_140":59,"_38":159,"_13":160,"_33":161,"_35":162,"_24":25,"_144":-5,"_27":163},{"_43":147,"_32":148,"_30":149,"_138":-5,"_41":42,"_40":150,"_140":59,"_38":151,"_13":152,"_33":142,"_35":153,"_24":25,"_144":45,"_27":154},{"_43":136,"_32":137,"_30":57,"_138":-5,"_41":42,"_40":139,"_140":59,"_38":141,"_13":63,"_33":142,"_35":143,"_24":25,"_144":145,"_27":146},"f893c856-a774-44d0-abd1-4da063f72383","version.ts","parentId",5,"latest",["D",1783290423770],"http","// 국가별 공휴일 데이터 버전 정보 API\n// 파라미터:\n// country (필수) - ISO 2자리 국가 코드 (KR, US, GB, CA, CH, AT, JP)\n//\n// 사용 예:\n// GET /?country=KR\n//\n// 버전 번호는 공휴일 데이터가 변경될 때 수동으로 업데이트합니다.\n\nconst COUNTRY_VERSIONS: Record = {\n KR: { countryName: \"대한민국\", version: \"1.0.0\", updatedAt: \"2025-07-05\" },\n US: { countryName: \"미국\", version: \"1.0.0\", updatedAt: \"2025-07-05\" },\n GB: { countryName: \"영국\", version: \"1.0.0\", updatedAt: \"2025-07-05\" },\n CA: { countryName: \"캐나다\", version: \"1.0.0\", updatedAt: \"2025-07-05\" },\n CH: { countryName: \"스위스\", version: \"1.0.0\", updatedAt: \"2025-07-05\" },\n AT: { countryName: \"오스트리아\", version: \"1.0.0\", updatedAt: \"2025-07-05\" },\n JP: { countryName: \"일본\", version: \"1.0.0\", updatedAt: \"2025-07-05\" },\n};\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const country = url.searchParams.get(\"country\")?.toUpperCase();\n\n // country 파라미터가 없으면 전체 국가 버전 목록 반환\n if (!country) {\n return Response.json({\n count: Object.keys(COUNTRY_VERSIONS).length,\n versions: COUNTRY_VERSIONS,\n });\n }\n\n const info = COUNTRY_VERSIONS[country];\n if (!info) {\n return Response.json(\n {\n error: `지원하지 않는 국가 코드입니다: ${country}`,\n supported: Object.keys(COUNTRY_VERSIONS),\n },\n { status: 400 },\n );\n }\n\n return Response.json({\n countryCode: country,\n countryName: info.countryName,\n version: info.version,\n updatedAt: info.updatedAt,\n });\n}\n","label","holidayversion",[137],"a7c21019-821b-43af-a67c-decf60714bb4","main.ts","0ef466f2-78bf-11f1-979c-1607ee4eb77e",4,["D",1783289962647],2,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// 공휴일 정보 API 엔드포인트\n// 파라미터:\n// country (선택) - ISO 2자리 국가 코드 (KR, US, GB, CA, CH, AT, JP)\n// year (선택) - 연도 (2025 ~ 2028)\n//\n// 사용 예:\n// GET /?country=KR&year=2025\n// GET /?country=US\n// GET /?year=2025\n// GET /\n\nconst SUPPORTED_COUNTRIES: Record = {\n KR: \"대한민국\",\n US: \"미국\",\n GB: \"영국\",\n CA: \"캐나다\",\n CH: \"스위스\",\n AT: \"오스트리아\",\n JP: \"일본\",\n};\n\nconst SUPPORTED_YEARS = [2025, 2026, 2027, 2028];\n\ninterface HolidayRow {\n id: number;\n date: string;\n local_name: string;\n name: string;\n country_code: string;\n fixed: number;\n global: number;\n counties: string | null;\n launch_year: number | null;\n types: string;\n year: number;\n}\n\ninterface HolidayResponse {\n date: string;\n localName: string;\n name: string;\n countryCode: string;\n fixed: boolean;\n global: boolean;\n counties: string[] | null;\n launchYear: number | null;\n types: string[];\n year: number;\n}\n\nfunction rowToHoliday(row: HolidayRow): HolidayResponse {\n return {\n date: row.date,\n localName: row.local_name,\n name: row.name,\n countryCode: row.country_code,\n fixed: row.fixed === 1,\n global: row.global === 1,\n counties: row.counties ? JSON.parse(row.counties) : null,\n launchYear: row.launch_year,\n types: JSON.parse(row.types),\n year: row.year,\n };\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const country = url.searchParams.get(\"country\")?.toUpperCase();\n const yearParam = url.searchParams.get(\"year\");\n\n // 파라미터 검증\n if (country && !SUPPORTED_COUNTRIES[country]) {\n return Response.json(\n {\n error: `지원하지 않는 국가 코드입니다: ${country}`,\n supported: Object.keys(SUPPORTED_COUNTRIES),\n },\n { status: 400 },\n );\n }\n\n let year: number | null = null;\n if (yearParam) {\n year = parseInt(yearParam, 10);\n if (isNaN(year)) {\n return Response.json(\n { error: `잘못된 연도 형식입니다: ${yearParam}` },\n { status: 400 },\n );\n }\n if (!SUPPORTED_YEARS.includes(year)) {\n return Response.json(\n {\n error: `지원하지 않는 연도입니다: ${year}`,\n supported: SUPPORTED_YEARS,\n },\n { status: 400 },\n );\n }\n }\n\n // 쿼리 빌드\n let sql = \"SELECT * FROM holidays WHERE 1=1\";\n const args: (string | number)[] = [];\n\n if (country) {\n sql += \" AND country_code = ?\";\n args.push(country);\n }\n\n if (year !== null) {\n sql += \" AND year = ?\";\n args.push(year);\n }\n\n sql += \" ORDER BY date ASC\";\n\n const result = await sqlite.execute({ sql, args });\n const holidays = (result.rows as HolidayRow[]).map(rowToHoliday);\n\n return Response.json({\n count: holidays.length,\n country: country ?? \"all\",\n year: year ?? \"all\",\n holidays,\n });\n}\n",[148],"f5081bc8-95dc-4ea6-b274-7f1cf3024229","fetch-holidays.ts","8ce4aff4-78bf-11f1-bc86-1607ee4eb77e",28,["D",1783305645557],3,"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Nager.Date API에서 공휴일 데이터를 가져와 SQLite에 저장하는 스크립트\n// 대상 국가: KR, US, GB, CA, CH, AT, JP\n// 대상 연도: 아래 YEARS에 입력\n// 대상 연도의 국가별 공휴일 정보를 Neter.Date에서 가져온다. \n//해당 연도의 기존 데이타를 모두 삭제한다. \n//가져온 데이터를 DB에 입력\n\nconst COUNTRIES = [\n { code: \"KR\", name: \"대한민국\" },\n { code: \"US\", name: \"미국\" },\n { code: \"GB\", name: \"영국\" },\n { code: \"CA\", name: \"캐나다\" },\n { code: \"CH\", name: \"스위스\" },\n { code: \"AT\", name: \"오스트리아\" },\n { code: \"JP\", name: \"일본\" },\n];\n\nconst YEARS = [2029];\n\nconst NAGER_API = \"https://date.nager.at/api/v3/PublicHolidays\";\n\ninterface NagerHoliday {\n date: string;\n localName: string;\n name: string;\n countryCode: string;\n fixed: boolean;\n global: boolean;\n counties: string[] | null;\n launchYear: number | null;\n types: string[];\n}\n\nasync function fetchHolidays(\n year: number,\n countryCode: string,\n): Promise {\n const url = `${NAGER_API}/${year}/${countryCode}`;\n const res = await fetch(url);\n if (!res.ok) {\n throw new Error(`API 호출 실패: ${url} - ${res.status}`);\n }\n return await res.json();\n}\n\nasync function createTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS holidays (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n local_name TEXT NOT NULL,\n name TEXT NOT NULL,\n country_code TEXT NOT NULL,\n fixed INTEGER NOT NULL,\n global INTEGER NOT NULL,\n counties TEXT,\n launch_year INTEGER,\n types TEXT,\n year INTEGER NOT NULL,\n UNIQUE(date, local_name, country_code, year)\n )\n `);\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_holidays_country_year\n ON holidays(country_code, year)\n `);\n console.log(\"✅ 테이블 생성 완료\");\n}\n\nasync function fetchAndStoreAll() {\n await createTable();\n\n // YEARS에 지정된 연도의 기존 데이터만 삭제 후 새로 저장\n const placeholders = YEARS.map(() => \"?\").join(\", \");\n await sqlite.execute({\n sql: `DELETE FROM holidays WHERE year IN (${placeholders})`,\n args: YEARS,\n });\n console.log(`🧹 ${YEARS.join(\", \")}년 기존 데이터 삭제 완료`);\n\n let total = 0;\n\n for (const { code, name } of COUNTRIES) {\n for (const year of YEARS) {\n try {\n const holidays = await fetchHolidays(year, code);\n const statements = holidays.map((h) => ({\n sql: `INSERT OR IGNORE INTO holidays\n (date, local_name, name, country_code, fixed, global, counties, launch_year, types, year)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n h.date,\n h.localName,\n h.name,\n h.countryCode,\n h.fixed ? 1 : 0,\n h.global ? 1 : 0,\n h.counties ? JSON.stringify(h.counties) : null,\n h.launchYear,\n JSON.stringify(h.types),\n year,\n ],\n }));\n\n if (statements.length > 0) {\n await sqlite.batch(statements);\n }\n\n total += holidays.length;\n console.log(\n `📅 ${name}(${code}) ${year}년: ${holidays.length}개 저장 완료`,\n );\n } catch (err) {\n console.error(\n `❌ ${name}(${code}) ${year}년 데이터 수집 실패:`,\n err.message,\n );\n }\n }\n }\n\n console.log(`\\n🎉 총 ${total}개의 공휴일 데이터 저장 완료!`);\n\n // 저장 결과 확인\n const result = await sqlite.execute(\n \"SELECT country_code, year, COUNT(*) as count FROM holidays GROUP BY country_code, year ORDER BY country_code, year\",\n );\n console.log(\"\\n📊 저장 결과 요약:\");\n for (const row of result.rows) {\n console.log(` ${row.country_code} ${row.year}년: ${row.count}개`);\n }\n}\n\n// 실행\nawait fetchAndStoreAll();",[156],"8dfd01a8-e017-482c-b6aa-ad7296add8bf","fetch-holidays-auto.ts","d24dfa5e-80f4-11f1-af40-1607ee4eb77e",45,["D",1784194269286],6,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// 매년 12월 15일에 올해+3년 공휴일 데이터를 Neger.Date에서 가져와 SQLite에 저장\n// 대상 국가: KR, US, GB, CA, CH, AT, JP\n// 대상 연도의 국가별 공휴일 정보를 Neter.Date에서 가져온다.\n//해당 연도의 기존 데이타를 모두 삭제한다.\n//가져온 데이터를 DB에 입력\n\nconst COUNTRIES = [\n { code: \"KR\", name: \"대한민국\" },\n { code: \"US\", name: \"미국\" },\n { code: \"GB\", name: \"영국\" },\n { code: \"CA\", name: \"캐나다\" },\n { code: \"CH\", name: \"스위스\" },\n { code: \"AT\", name: \"오스트리아\" },\n { code: \"JP\", name: \"일본\" },\n];\nconst currentYear = new Date().getFullYear();\nconst YEARS = [currentYear + 3];\n\nconst NAGER_API = \"https://date.nager.at/api/v3/PublicHolidays\";\n\ninterface NagerHoliday {\n date: string;\n localName: string;\n name: string;\n countryCode: string;\n fixed: boolean;\n global: boolean;\n counties: string[] | null;\n launchYear: number | null;\n types: string[];\n}\n\nasync function fetchHolidays(\n year: number,\n countryCode: string,\n): Promise {\n const url = `${NAGER_API}/${year}/${countryCode}`;\n const res = await fetch(url);\n if (!res.ok) {\n throw new Error(`API 호출 실패: ${url} - ${res.status}`);\n }\n return await res.json();\n}\n\nasync function createTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS holidays (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n local_name TEXT NOT NULL,\n name TEXT NOT NULL,\n country_code TEXT NOT NULL,\n fixed INTEGER NOT NULL,\n global INTEGER NOT NULL,\n counties TEXT,\n launch_year INTEGER,\n types TEXT,\n year INTEGER NOT NULL,\n UNIQUE(date, local_name, country_code, year)\n )\n `);\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_holidays_country_year\n ON holidays(country_code, year)\n `);\n console.log(\"✅ 테이블 생성 완료\");\n}\n\nasync function fetchAndStoreAll() {\n await createTable();\n\n // YEARS에 지정된 연도의 기존 데이터만 삭제 후 새로 저장\n const placeholders = YEARS.map(() => \"?\").join(\", \");\n await sqlite.execute({\n sql: `DELETE FROM holidays WHERE year IN (${placeholders})`,\n args: YEARS,\n });\n console.log(`🧹 ${YEARS.join(\", \")}년 기존 데이터 삭제 완료`);\n\n let total = 0;\n\n for (const { code, name } of COUNTRIES) {\n for (const year of YEARS) {\n try {\n const holidays = await fetchHolidays(year, code);\n const statements = holidays.map((h) => ({\n sql: `INSERT OR IGNORE INTO holidays\n (date, local_name, name, country_code, fixed, global, counties, launch_year, types, year)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n h.date,\n h.localName,\n h.name,\n h.countryCode,\n h.fixed ? 1 : 0,\n h.global ? 1 : 0,\n h.counties ? JSON.stringify(h.counties) : null,\n h.launchYear,\n JSON.stringify(h.types),\n year,\n ],\n }));\n\n if (statements.length > 0) {\n await sqlite.batch(statements);\n }\n\n total += holidays.length;\n console.log(\n `📅 ${name}(${code}) ${year}년: ${holidays.length}개 저장 완료`,\n );\n } catch (err) {\n console.error(\n `❌ ${name}(${code}) ${year}년 데이터 수집 실패:`,\n err.message,\n );\n }\n }\n }\n\n console.log(`\\n🎉 총 ${total}개의 공휴일 데이터 저장 완료!`);\n\n // 저장 결과 확인\n const result = await sqlite.execute(\n \"SELECT country_code, year, COUNT(*) as count FROM holidays GROUP BY country_code, year ORDER BY country_code, year\",\n );\n console.log(\"\\n📊 저장 결과 요약:\");\n for (const row of result.rows) {\n console.log(` ${row.country_code} ${row.year}년: ${row.count}개`);\n }\n}\n\n// 실행\nawait fetchAndStoreAll();",[165],"8ab45b96-55dd-4774-be13-f4ac4610f5ff",["D",1785300828523],38,[28],"48467d4d-965c-4a57-bada-6b3a2f44e785","export-to-supabase.ts","c71b919e-78d6-11f1-b926-1607ee4eb77e",37,["D",1784192021788],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\n// 매월 20일 실행: SQLite에서 공휴일 데이터를 국가별 JSON으로 만들어\n// Supabase Storage에 업로드하고 다운로드 링크를 생성합니다.\n//\n// 대상 연도: 작년, 현재년, 내년, 내후년 (4개년)\n// 대상 국가: KR, US, GB, CA, CH, AT, JP (국가별 개별 파일)\n\nconst COUNTRIES = [\n { code: \"KR\", name: \"대한민국\" },\n { code: \"US\", name: \"미국\" },\n { code: \"GB\", name: \"영국\" },\n { code: \"CA\", name: \"캐나다\" },\n { code: \"CH\", name: \"스위스\" },\n { code: \"AT\", name: \"오스트리아\" },\n { code: \"JP\", name: \"일본\" },\n];\n\nconst SUPABASE_BUCKET = \"holidays\";\n\ninterface HolidayRow {\n id: number;\n date: string;\n local_name: string;\n name: string;\n country_code: string;\n fixed: number;\n global: number;\n counties: string | null;\n launch_year: number | null;\n types: string;\n year: number;\n}\n\ninterface HolidayJson {\n date: string;\n localName: string;\n name: string;\n countryCode: string;\n fixed: boolean;\n global: boolean;\n counties: string[] | null;\n launchYear: number | null;\n types: string[];\n year: number;\n}\n\nfunction rowToJson(row: HolidayRow): HolidayJson {\n return {\n date: row.date,\n localName: row.local_name,\n name: row.name,\n countryCode: row.country_code,\n fixed: row.fixed === 1,\n global: row.global === 1,\n counties: row.counties ? JSON.parse(row.counties) : null,\n launchYear: row.launch_year,\n types: JSON.parse(row.types),\n year: row.year,\n };\n}\n\nasync function exportToSupabase() {\n // 1. 대상 연도 계산: 작년, 현재년, 내년, 내후년\n const currentYear = new Date().getFullYear();\n const targetYears = [\n currentYear - 1,\n currentYear,\n currentYear + 1,\n currentYear + 2,\n ];\n console.log(`📅 대상 연도: ${targetYears.join(\", \")}`);\n\n // 2. Supabase 클라이언트 초기화\n const supabaseUrl = Deno.env.get(\"SUPABASE_URL\");\n const supabaseKey = Deno.env.get(\"SUPABASE_KEY\");\n\n if (!supabaseUrl || !supabaseKey) {\n throw new Error(\n \"supabaseURL, supabaseKey 환경변수가 설정되어 있지 않습니다.\",\n );\n }\n\n const supabase = createClient(supabaseUrl, supabaseKey);\n\n // 3. 국가별로 데이터 조회 → JSON 생성 → Supabase 업로드\n const results: Array<{\n country: string;\n countryName: string;\n count: number;\n downloadUrl: string;\n years: number[];\n }> = [];\n\n for (const { code, name } of COUNTRIES) {\n // SQLite에서 해당 국가의 4개년 공휴일 조회\n const placeholders = targetYears.map(() => \"?\").join(\", \");\n const result = await sqlite.execute({\n sql: `SELECT * FROM holidays\n WHERE country_code = ? AND year IN (${placeholders})\n ORDER BY date ASC`,\n args: [code, ...targetYears],\n });\n\n const holidays = (result.rows as HolidayRow[]).map(rowToJson);\n\n // JSON 데이터 구성\n const jsonData = {\n countryCode: code,\n countryName: name,\n years: targetYears,\n count: holidays.length,\n exportedAt: new Date().toISOString(),\n holidays,\n };\n\n const jsonStr = JSON.stringify(jsonData, null, 2);\n const fileName = `holidays_${code}.json`;\n\n // Supabase Storage에 업로드 (upsert: 기존 파일 덮어쓰기)\n const { error: uploadError } = await supabase.storage\n .from(SUPABASE_BUCKET)\n .upload(fileName, jsonStr, {\n contentType: \"application/json\",\n upsert: true,\n });\n\n if (uploadError) {\n console.error(`❌ ${name}(${code}) 업로드 실패:`, uploadError.message);\n continue;\n }\n\n // 공개 다운로드 URL 생성\n const { data: urlData } = supabase.storage\n .from(SUPABASE_BUCKET)\n .getPublicUrl(fileName);\n\n results.push({\n country: code,\n countryName: name,\n count: holidays.length,\n downloadUrl: urlData.publicUrl,\n years: targetYears,\n });\n\n console.log(\n `✅ ${name}(${code}): ${holidays.length}개 공휴일 → ${fileName} 업로드 완료`,\n );\n }\n\n // 4. 결과 요약 출력\n console.log(\"\\n📦 Supabase 업로드 완료!\");\n console.log(` 대상 연도: ${targetYears.join(\", \")}`);\n console.log(\" 다운로드 링크:\");\n for (const r of results) {\n console.log(` - ${r.countryName}(${r.country}): ${r.count}개`);\n console.log(` ${r.downloadUrl}`);\n }\n\n return results;\n}\n\nexport default async function (interval: Interval) {\n console.log(\n `🔄 공휴일 데이터 Supabase 내보내기 시작 - ${new Date().toISOString()}`,\n );\n if (interval?.lastRunAt) {\n console.log(` 이전 실행: ${interval.lastRunAt.toISOString()}`);\n }\n await exportToSupabase();\n console.log(\"✅ 모든 작업 완료!\");\n}",[177],"pulls","branches",1,"forks","envVars",{"_191":152,"_193":63},"connections",{"_191":63,"_192":63},"count","unfilledCount","emptyCount",{"_43":176,"_32":177,"_30":178,"_138":-5,"_41":42,"_40":179,"_140":59,"_38":216,"_13":152,"_33":34,"_35":181,"_24":25,"_144":-5,"_201":217,"_27":218},{"_43":172,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":213,"_13":174,"_33":34,"_35":37,"_24":25,"_144":-5,"_201":214,"_27":215},{"_43":164,"_32":165,"_30":166,"_138":-5,"_41":42,"_40":167,"_140":59,"_38":210,"_13":169,"_33":34,"_35":170,"_24":25,"_144":-5,"_201":211,"_27":212},{"_43":155,"_32":156,"_30":157,"_138":-5,"_41":42,"_40":158,"_140":59,"_38":207,"_13":160,"_33":161,"_35":162,"_24":25,"_144":-5,"_201":208,"_27":209},{"_43":147,"_32":148,"_30":149,"_138":-5,"_41":42,"_40":150,"_140":59,"_38":204,"_13":152,"_33":142,"_35":153,"_24":25,"_144":45,"_201":205,"_27":206},{"_43":136,"_32":137,"_30":57,"_138":-5,"_41":42,"_40":139,"_140":59,"_38":200,"_13":63,"_33":142,"_35":143,"_24":25,"_144":145,"_201":202,"_27":203},["D",1783290423770],"children",[],[137],["D",1783289962647],[],[148],["D",1783305645557],[],[156],["D",1784194269286],[],[165],["D",1785300828523],[],[28],["D",1784192021788],[],[177],["D",1783289740989],["D",1789524079207],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_127":257,"_258":259,"_260":261,"_262":25,"_263":25,"_264":25,"_265":59,"_266":-5,"_267":-7,"_268":-7,"_269":63,"_270":25,"_271":25,"_272":-5,"_273":25,"_274":25,"_275":25,"_276":-5},"ENV",{"_228":229,"_230":231,"_232":90,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v57