[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_230":231,"_232":233},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_107":88,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":57,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","auth.ts","latestPath","fileId","9e6b9148-8d46-11f1-a61f-1607ee4eb77e","name","fileType","script","content","import { getSetting, setSetting } from \"./db.ts\";\n\n// 인스타그램 로그인 방식 OAuth.\n// 페이스북 페이지를 연결하지 않아도 되는 경로입니다. 인증은 instagram.com 에서\n// 일어나고 enable_fb_login=false 로 페이스북 로그인 선택지 자체를 숨깁니다.\n//\n// 토큰은 60일짜리입니다. 크론이 만료 전에 스스로 갱신하므로 사람이 다시\n// 발급할 일은 없습니다. 단 갱신은 발급 후 24시간이 지나야 됩니다.\n\nconst AUTHORIZE = \"https://www.instagram.com/oauth/authorize\";\nconst TOKEN = \"https://api.instagram.com/oauth/access_token\";\nconst GRAPH = \"https://graph.instagram.com\";\n\nconst SCOPES = [\"instagram_business_basic\", \"instagram_business_content_publish\"];\n\nexport const LONG_LIVED_DAYS = 60;\nconst REFRESH_WHEN_DAYS_LEFT = 10;\n\nfunction env(key: string): string {\n const v = Deno.env.get(key);\n if (!v) throw new Error(`환경변수 ${key} 가 없습니다`);\n return v;\n}\n\nexport const redirectUri = (origin: string) => `${origin}/connect/callback`;\n\nexport function authorizeUrl(origin: string, state: string): string {\n const qs = new URLSearchParams({\n client_id: env(\"IG_APP_ID\"),\n redirect_uri: redirectUri(origin),\n response_type: \"code\",\n scope: SCOPES.join(\",\"),\n state,\n enable_fb_login: \"false\",\n });\n return `${AUTHORIZE}?${qs}`;\n}\n\nasync function readJson(res: Response, what: string) {\n const json = await res.json().catch(() => ({}));\n if (!res.ok || json.error || json.error_message) {\n const msg = json.error?.message ?? json.error_message ?? JSON.stringify(json).slice(0, 200);\n throw new Error(`${what} 실패 (${res.status}): ${msg}`);\n }\n return json;\n}\n\n/** 인가 코드를 60일짜리 토큰으로 바꾸고 계정 정보까지 채워 저장합니다. */\nexport async function completeConnect(code: string, origin: string) {\n const shortRes = await fetch(TOKEN, {\n method: \"POST\",\n headers: { \"content-type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n client_id: env(\"IG_APP_ID\"),\n client_secret: env(\"IG_APP_SECRET\"),\n grant_type: \"authorization_code\",\n redirect_uri: redirectUri(origin),\n code,\n }),\n });\n const short = await readJson(shortRes, \"인가 코드 교환\");\n\n const longRes = await fetch(\n `${GRAPH}/access_token?` +\n new URLSearchParams({\n grant_type: \"ig_exchange_token\",\n client_secret: env(\"IG_APP_SECRET\"),\n access_token: short.access_token,\n }),\n );\n const long = await readJson(longRes, \"장기 토큰 교환\");\n\n const meRes = await fetch(\n `${GRAPH}/me?` + new URLSearchParams({ fields: \"user_id,username\", access_token: long.access_token }),\n );\n const me = await readJson(meRes, \"계정 조회\");\n\n await saveToken(long.access_token, long.expires_in);\n await setSetting(\"ig_user_id\", String(me.user_id));\n await setSetting(\"ig_username\", String(me.username ?? \"\"));\n\n return { username: me.username as string, userId: String(me.user_id) };\n}\n\nasync function saveToken(token: string, expiresInSeconds: number) {\n const now = Date.now();\n await setSetting(\"access_token\", token);\n await setSetting(\"token_obtained_at\", new Date(now).toISOString());\n await setSetting(\n \"token_expires_at\",\n new Date(now + (expiresInSeconds ?? LONG_LIVED_DAYS * 86400) * 1000).toISOString(),\n );\n}\n\nexport async function currentToken(): Promise {\n const t = await getSetting(\"access_token\");\n if (!t) throw new Error(\"인스타 계정이 아직 연결되지 않았습니다. /connect 로 연결하세요.\");\n return t;\n}\n\nexport async function currentUserId(): Promise {\n const id = await getSetting(\"ig_user_id\");\n if (!id) throw new Error(\"인스타 계정이 아직 연결되지 않았습니다. /connect 로 연결하세요.\");\n return id;\n}\n\nexport async function tokenState() {\n const [token, expiresAt, obtainedAt, username] = await Promise.all([\n getSetting(\"access_token\"),\n getSetting(\"token_expires_at\"),\n getSetting(\"token_obtained_at\"),\n getSetting(\"ig_username\"),\n ]);\n if (!token) return { connected: false as const };\n\n const expires = expiresAt ? new Date(expiresAt) : null;\n const daysLeft = expires ? Math.floor((expires.getTime() - Date.now()) / 86400000) : null;\n return {\n connected: true as const,\n username,\n expiresAt,\n daysLeft,\n ageHours: obtainedAt ? (Date.now() - new Date(obtainedAt).getTime()) / 3600000 : 0,\n };\n}\n\n/**\n * 만료가 가까우면 토큰을 갱신합니다. 크론이 매번 부릅니다.\n * 갱신할 필요가 없으면 아무것도 하지 않습니다.\n */\nexport async function refreshIfNeeded(): Promise {\n const state = await tokenState();\n if (!state.connected) return null;\n if (state.daysLeft === null || state.daysLeft > REFRESH_WHEN_DAYS_LEFT) return null;\n // 메타는 발급 후 24시간이 지나야 갱신을 받아줍니다.\n if (state.ageHours < 25) return null;\n\n const res = await fetch(\n `${GRAPH}/refresh_access_token?` +\n new URLSearchParams({ grant_type: \"ig_refresh_token\", access_token: await currentToken() }),\n );\n const json = await readJson(res, \"토큰 갱신\");\n await saveToken(json.access_token, json.expires_in);\n return `토큰을 갱신했습니다. 만료 ${LONG_LIVED_DAYS}일 연장.`;\n}\n","createdAt",["D",1785546987014],"branchVersion","branchId","86b9f70c-6232-4b2a-a112-1132efb31251","id","46f8995f-4aa9-4a71-8e5e-8a47aa88f535","pf-carousel",["D",1785544484752],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","페이션트 퍼널 인스타 캐러셀 예약 발행기","imageUrl","327de45b-0876-4bd5-8012-2f1671ef410f","pinnedFileId","02a66788-8d41-11f1-94e8-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f4255-a8ff-705e-bb61-39b146921d1d","tursoName","46f8995f4aa94a718e5e8a47aa88f535","tursoHostname","46f8995f4aa94a718e5e8a47aa88f535-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789561254403],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",19,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","sodanstjrwns","handle","displayName","문석준","avatar","https://lh3.googleusercontent.com/a/ACg8ocIfQPzKQY0_SJnQYYyx_DNUHjsra9E3y7hhpdn24To9_PeV6g=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":225,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":226,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":227,"_82":228,"_84":229,"_86":24},"tree",[196,197,198,199,200,201,202],"files",[196,197,198,199,200,201,202],"counts",{"_186":61,"_187":150,"_188":61,"_189":190,"_191":192},"contents",[129,130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":180,"_31":181,"_29":182,"_139":-5,"_39":40,"_38":150,"_141":57,"_36":183,"_13":61,"_32":20,"_34":184,"_23":24,"_144":-5,"_26":185},{"_41":177,"_31":27,"_29":30,"_139":-5,"_39":40,"_38":14,"_141":57,"_36":178,"_13":61,"_32":33,"_34":35,"_23":24,"_144":-5,"_26":179},{"_41":169,"_31":170,"_29":171,"_139":-5,"_39":40,"_38":172,"_141":24,"_36":173,"_13":61,"_32":174,"_34":175,"_23":24,"_144":-5,"_26":176},{"_41":161,"_31":162,"_29":163,"_139":-5,"_39":40,"_38":164,"_141":57,"_36":165,"_13":166,"_32":33,"_34":167,"_23":24,"_144":-5,"_26":168},{"_41":154,"_31":155,"_29":156,"_139":-5,"_39":40,"_38":157,"_141":24,"_36":158,"_13":61,"_32":33,"_34":159,"_23":24,"_144":-5,"_26":160},{"_41":146,"_31":147,"_29":55,"_139":-5,"_39":40,"_38":148,"_141":24,"_36":149,"_13":150,"_32":151,"_34":152,"_23":24,"_144":-5,"_26":153},{"_41":136,"_31":137,"_29":138,"_139":-5,"_39":40,"_38":140,"_141":57,"_36":142,"_13":61,"_32":33,"_34":143,"_23":24,"_144":-5,"_26":145},"61345f52-69b9-494a-89b1-2f2cbaa649a4","storage.ts","09a801d6-8d41-11f1-a3fe-1607ee4eb77e","parentId",8,"latest",["D",1785544589932],"import { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\n// 무료 티어 블롭 용량은 계정 전체 10MB 입니다. 카드 한 벌이 대략 1MB 이므로\n// 발행이 끝나면 반드시 지워야 다음 덱을 올릴 자리가 생깁니다.\nexport const imageKey = (jobId: string, seq: number) => `card/${jobId}/${String(seq).padStart(2, \"0\")}`;\n\nexport const imageUrl = (baseUrl: string, jobId: string, seq: number) =>\n `${baseUrl}/i/${jobId}/${String(seq).padStart(2, \"0\")}.jpg`;\n\nexport function imageUrls(baseUrl: string, jobId: string, count: number): string[] {\n return Array.from({ length: count }, (_, i) => imageUrl(baseUrl, jobId, i + 1));\n}\n\nexport async function deleteImages(jobId: string) {\n for (const { key } of await blob.list(`card/${jobId}/`)) {\n await blob.delete(key);\n }\n}\n","label",[137],"3707ed66-4d74-44da-be7d-5589f26cf93d","main.ts",10,["D",1785544619406],1,"http","import { Hono } from \"npm:hono\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { createJob, getJob, recentJobs, updateJob } from \"./db.ts\";\nimport { imageKey } from \"./storage.ts\";\n\n// 이 val 은 공개입니다. 쓰기 요청은 전부 CM_TOKEN 으로 막습니다.\n// 이미지 GET 만 열려 있습니다 — 메타 서버가 직접 받아가야 하기 때문입니다.\nfunction requireToken(req: Request) {\n const expected = Deno.env.get(\"CM_TOKEN\");\n if (!expected) throw new Error(\"환경변수 CM_TOKEN 이 설정되지 않았습니다\");\n const header = req.headers.get(\"authorization\") ?? \"\";\n const given = header.replace(/^Bearer\\s+/i, \"\") || new URL(req.url).searchParams.get(\"t\") || \"\";\n if (given !== expected) {\n throw Object.assign(new Error(\"인증 실패\"), { status: 401 });\n }\n}\n\nconst app = new Hono();\n\napp.onError((err) => {\n const status = (err as { status?: number }).status ?? 500;\n return Promise.resolve(Response.json({ error: err.message }, { status }));\n});\n\n/** 1단계 — 발행 작업을 만듭니다. 아직 이미지는 없습니다. */\napp.post(\"/api/jobs\", async (c) => {\n requireToken(c.req.raw);\n const body = await c.req.json();\n\n for (const key of [\"slug\", \"caption\", \"publish_at\", \"image_count\"]) {\n if (body[key] === undefined) throw new Error(`${key} 가 없습니다`);\n }\n const at = new Date(body.publish_at);\n if (Number.isNaN(at.getTime())) throw new Error(`publish_at 을 읽을 수 없습니다: ${body.publish_at}`);\n if (body.image_count < 2 || body.image_count > 10) {\n throw new Error(`캐러셀은 2~10장이어야 합니다 (요청 ${body.image_count}장)`);\n }\n\n const id = crypto.randomUUID();\n await createJob({\n id,\n slug: String(body.slug),\n caption: String(body.caption),\n publish_at: at.toISOString(),\n image_count: Number(body.image_count),\n base_url: new URL(c.req.url).origin,\n });\n return c.json({ id, publish_at: at.toISOString() });\n});\n\n/** 2단계 — 카드 이미지를 한 장씩 올립니다. 본문은 JPEG 원본 그대로입니다. */\napp.put(\"/api/jobs/:id/images/:seq\", async (c) => {\n requireToken(c.req.raw);\n const { id, seq } = c.req.param();\n const job = await getJob(id);\n if (!job) throw Object.assign(new Error(\"작업을 찾을 수 없습니다\"), { status: 404 });\n\n const n = Number(seq);\n if (!Number.isInteger(n) || n < 1 || n > job.image_count) {\n throw new Error(`이미지 번호가 범위를 벗어났습니다: ${seq}`);\n }\n\n const bytes = await c.req.arrayBuffer();\n if (!bytes.byteLength) throw new Error(\"이미지 본문이 비어 있습니다\");\n await blob.set(imageKey(id, n), bytes);\n return c.json({ ok: true, seq: n, bytes: bytes.byteLength });\n});\n\n/** 3단계 — 이미지가 다 올라왔는지 확인하고 예약을 확정합니다. */\napp.post(\"/api/jobs/:id/queue\", async (c) => {\n requireToken(c.req.raw);\n const id = c.req.param(\"id\");\n const job = await getJob(id);\n if (!job) throw Object.assign(new Error(\"작업을 찾을 수 없습니다\"), { status: 404 });\n\n const stored = await blob.list(`card/${id}/`);\n if (stored.length !== job.image_count) {\n throw new Error(`이미지가 ${stored.length}/${job.image_count}장만 올라왔습니다`);\n }\n\n await updateJob(id, { status: \"queued\", error: null });\n return c.json({ ok: true, id, status: \"queued\", publish_at: job.publish_at });\n});\n\napp.delete(\"/api/jobs/:id\", async (c) => {\n requireToken(c.req.raw);\n const id = c.req.param(\"id\");\n const job = await getJob(id);\n if (!job) throw Object.assign(new Error(\"작업을 찾을 수 없습니다\"), { status: 404 });\n if (job.status === \"published\") throw new Error(\"이미 발행된 글은 취소할 수 없습니다\");\n\n for (const { key } of await blob.list(`card/${id}/`)) await blob.delete(key);\n await updateJob(id, { status: \"failed\", error: \"사람이 취소함\" });\n return c.json({ ok: true });\n});\n\napp.get(\"/api/jobs/:id\", async (c) => {\n requireToken(c.req.raw);\n const job = await getJob(c.req.param(\"id\"));\n if (!job) throw Object.assign(new Error(\"작업을 찾을 수 없습니다\"), { status: 404 });\n return c.json(job);\n});\n\n/**\n * 메타 서버가 카드를 받아가는 곳. 여기만 토큰 없이 열려 있습니다.\n * 경로에 uuid 가 들어가 있어 추측으로는 찾을 수 없고, 발행이 끝나면 지웁니다.\n */\napp.get(\"/i/:id/:file\", async (c) => {\n const { id, file } = c.req.param();\n const n = Number(file.replace(/\\.jpg$/, \"\"));\n if (!Number.isInteger(n)) return c.notFound();\n try {\n const res = await blob.get(imageKey(id, n));\n return new Response(res.body, {\n headers: {\n \"content-type\": \"image/jpeg\",\n \"cache-control\": \"public, max-age=3600\",\n },\n });\n } catch {\n return c.notFound();\n }\n});\n\nconst esc = (s: unknown) =>\n String(s ?? \"\").replace(/[&<>\"]/g, (ch) => ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" })[ch]!);\n\napp.get(\"/\", async (c) => {\n requireToken(c.req.raw);\n const jobs = await recentJobs();\n const rows = jobs\n .map(\n (j) => `\n ${esc(j.publish_at.replace(\"T\", \" \").slice(0, 16))}\n ${esc(j.slug)}\n ${j.image_count}장\n ${esc(j.status)}\n ${esc(j.ig_media_id ?? j.error ?? \"\")}\n `,\n )\n .join(\"\");\n\n return c.html(`\npf-carousel\n\n

예약 발행 현황

시각은 UTC입니다. 한국 시간은 여기에 9시간을 더하세요.

\n\n \n ${rows || ''}\n

발행 예정	덱	장수	상태	결과
예약된 글이 없습니다.

`);\n});\n\nexport default app.fetch;\n",[147],"00b76991-cfd0-459d-9711-13b5a8311b57","ig.ts","df2a161a-8d40-11f1-a4a7-1607ee4eb77e",3,["D",1785544518661],"// 인스타그램 그래프 API 래퍼.\n// 캐러셀 발행은 3단계입니다.\n// 1) 이미지마다 자식 컨테이너를 만든다 (is_carousel_item=true)\n// 2) 자식들을 묶어 캐러셀 컨테이너를 만든다 (캡션은 여기 붙는다)\n// 3) 컨테이너가 FINISHED 가 되면 media_publish 한다\n// 컨테이너는 24시간 뒤 만료되므로, 만들어 두고 다음 크론에서 이어받아도 됩니다.\n\nconst VERSION = Deno.env.get(\"IG_API_VERSION\") ?? \"v21.0\";\nconst GRAPH = `https://graph.facebook.com/${VERSION}`;\n\nfunction env(key: string): string {\n const v = Deno.env.get(key);\n if (!v) throw new Error(`환경변수 ${key} 가 없습니다`);\n return v;\n}\n\nexport const igUserId = () => env(\"IG_USER_ID\");\nexport const igToken = () => env(\"IG_ACCESS_TOKEN\");\n\nasync function post(path: string, params: Record) {\n const res = await fetch(`${GRAPH}/${path}`, {\n method: \"POST\",\n headers: { \"content-type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({ ...params, access_token: igToken() }),\n });\n const json = await res.json().catch(() => ({}));\n if (!res.ok || json.error) {\n const e = json.error ?? {};\n throw new Error(\n `그래프 API ${res.status}: ${e.message ?? \"알 수 없는 오류\"}` +\n (e.error_user_msg ? ` — ${e.error_user_msg}` : \"\") +\n ` [${path}]`,\n );\n }\n return json;\n}\n\nasync function get(path: string, params: Record) {\n const qs = new URLSearchParams({ ...params, access_token: igToken() });\n const res = await fetch(`${GRAPH}/${path}?${qs}`);\n const json = await res.json().catch(() => ({}));\n if (!res.ok || json.error) {\n throw new Error(`그래프 API ${res.status}: ${json.error?.message ?? \"알 수 없는 오류\"} [${path}]`);\n }\n return json;\n}\n\n/** 자식 컨테이너들 + 캐러셀 컨테이너를 만들고 캐러셀 컨테이너 ID를 돌려줍니다. */\nexport async function createCarousel(imageUrls: string[], caption: string): Promise {\n if (imageUrls.length < 2 || imageUrls.length > 10) {\n throw new Error(`캐러셀은 2~10장이어야 합니다 (현재 ${imageUrls.length}장)`);\n }\n\n const children: string[] = [];\n for (const image_url of imageUrls) {\n const child = await post(`${igUserId()}/media`, { image_url, is_carousel_item: \"true\" });\n children.push(child.id);\n }\n\n const carousel = await post(`${igUserId()}/media`, {\n media_type: \"CAROUSEL\",\n children: children.join(\",\"),\n caption,\n });\n return carousel.id;\n}\n\nexport type ContainerStatus = \"FINISHED\" | \"IN_PROGRESS\" | \"ERROR\" | \"EXPIRED\" | \"PUBLISHED\";\n\nexport async function containerStatus(\n containerId: string,\n): Promise<{ status: ContainerStatus; detail?: string }> {\n const r = await get(containerId, { fields: \"status_code,status\" });\n return { status: r.status_code as ContainerStatus, detail: r.status };\n}\n\n/** 컨테이너를 실제 게시물로 만듭니다. 돌려주는 값이 게시물 ID입니다. */\nexport async function publishContainer(containerId: string): Promise {\n const r = await post(`${igUserId()}/media_publish`, { creation_id: containerId });\n return r.id;\n}\n\n/** 게시된 글의 퍼머링크. 실패해도 발행 자체는 성공이므로 조용히 넘깁니다. */\nexport async function permalink(mediaId: string): Promise {\n try {\n const r = await get(mediaId, { fields: \"permalink\" });\n return r.permalink ?? null;\n } catch {\n return null;\n }\n}\n",[155],"0e95d939-78d5-45e9-ab8a-e010620c41fe","db.ts","d3531904-8d40-11f1-9301-1607ee4eb77e",11,["D",1785546961352],4,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type JobStatus =\n | \"draft\" // 이미지 업로드를 기다리는 중\n | \"queued\" // 예약 완료. 발행 시각을 기다리는 중\n | \"publishing\" // 인스타에 컨테이너를 만들고 처리를 기다리는 중\n | \"published\"\n | \"failed\";\n\nexport interface Job {\n id: string;\n slug: string;\n caption: string;\n publish_at: string; // ISO UTC\n status: JobStatus;\n image_count: number;\n base_url: string; // 크론이 이미지 공개 주소를 만들 때 씁니다\n container_id: string | null;\n ig_media_id: string | null;\n error: string | null;\n attempts: number;\n created_at: string;\n published_at: string | null;\n}\n\nexport async function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS jobs (\n id TEXT PRIMARY KEY,\n slug TEXT NOT NULL,\n caption TEXT NOT NULL,\n publish_at TEXT NOT NULL,\n status TEXT NOT NULL,\n image_count INTEGER NOT NULL DEFAULT 0,\n base_url TEXT NOT NULL DEFAULT '',\n container_id TEXT,\n ig_media_id TEXT,\n error TEXT,\n attempts INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL,\n published_at TEXT\n )`);\n}\n\n/**\n * 액세스 토큰처럼 런타임에 바뀌는 값을 담아 둡니다.\n * 환경변수는 코드가 못 고치는데 토큰은 60일마다 갱신해야 해서 여기 둡니다.\n */\nexport async function initSettings() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS settings (key TEXT PRIMARY KEY, value TEXT NOT NULL)`,\n );\n}\n\nexport async function getSetting(key: string): Promise {\n await initSettings();\n const r = await sqlite.execute({ sql: \"SELECT value FROM settings WHERE key = ?\", args: [key] });\n return (r.rows[0]?.value as string) ?? null;\n}\n\nexport async function setSetting(key: string, value: string) {\n await initSettings();\n await sqlite.execute({\n sql: `INSERT INTO settings (key, value) VALUES (?, ?)\n ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n args: [key, value],\n });\n}\n\nexport async function createJob(job: {\n id: string;\n slug: string;\n caption: string;\n publish_at: string;\n image_count: number;\n base_url: string;\n}) {\n await initDb();\n await sqlite.execute({\n sql: `INSERT INTO jobs (id, slug, caption, publish_at, status, image_count, base_url, created_at)\n VALUES (?, ?, ?, ?, 'draft', ?, ?, ?)`,\n args: [\n job.id,\n job.slug,\n job.caption,\n job.publish_at,\n job.image_count,\n job.base_url,\n new Date().toISOString(),\n ],\n });\n}\n\nexport async function getJob(id: string): Promise {\n await initDb();\n const r = await sqlite.execute({ sql: \"SELECT * FROM jobs WHERE id = ?\", args: [id] });\n return (r.rows[0] as unknown as Job) ?? null;\n}\n\nexport async function updateJob(id: string, patch: Partial) {\n const keys = Object.keys(patch);\n if (!keys.length) return;\n await sqlite.execute({\n sql: `UPDATE jobs SET ${keys.map((k) => `${k} = ?`).join(\", \")} WHERE id = ?`,\n args: [...keys.map((k) => (patch as Record)[k] ?? null), id],\n });\n}\n\n/** 발행할 때가 된 작업. 처리 중이던 것도 함께 집어 재시도합니다. */\nexport async function dueJobs(now = new Date()): Promise {\n await initDb();\n const r = await sqlite.execute({\n sql: `SELECT * FROM jobs\n WHERE status IN ('queued', 'publishing')\n AND publish_at <= ?\n AND attempts < 10\n ORDER BY publish_at ASC`,\n args: [now.toISOString()],\n });\n return r.rows as unknown as Job[];\n}\n\nexport async function recentJobs(limit = 40): Promise {\n await initDb();\n const r = await sqlite.execute({\n sql: \"SELECT * FROM jobs ORDER BY publish_at DESC LIMIT ?\",\n args: [limit],\n });\n return r.rows as unknown as Job[];\n}\n",[162],"f6d544fd-9841-405d-889b-89b60458c316","cron.ts","16349c70-8d41-11f1-a824-1607ee4eb77e",9,["D",1785544611004],"interval","import { dueJobs, updateJob } from \"./db.ts\";\nimport { containerStatus, createCarousel, permalink, publishContainer } from \"./ig.ts\";\nimport { deleteImages, imageUrls } from \"./storage.ts\";\n\nconst MAX_ATTEMPTS = 10;\n\n// 15분마다 돌면서 발행할 때가 된 작업을 처리합니다.\n// 한 번에 끝내려 하지 않습니다. 컨테이너가 아직 처리 중이면 그대로 두고\n// 다음 회차에서 이어받습니다. 컨테이너는 24시간 유효하므로 넉넉합니다.\nexport default async function () {\n const jobs = await dueJobs();\n if (!jobs.length) return;\n\n console.log(`발행 대기 ${jobs.length}건`);\n\n for (const job of jobs) {\n const attempts = job.attempts + 1;\n await updateJob(job.id, { attempts });\n\n try {\n let containerId = job.container_id;\n\n if (!containerId) {\n const urls = imageUrls(job.base_url, job.id, job.image_count);\n containerId = await createCarousel(urls, job.caption);\n await updateJob(job.id, { container_id: containerId, status: \"publishing\" });\n console.log(`${job.slug}: 캐러셀 컨테이너 생성 ${containerId}`);\n }\n\n const { status, detail } = await containerStatus(containerId);\n\n if (status === \"IN_PROGRESS\") {\n console.log(`${job.slug}: 메타가 아직 이미지를 처리 중입니다. 다음 회차에 다시 봅니다.`);\n continue;\n }\n if (status !== \"FINISHED\" && status !== \"PUBLISHED\") {\n throw new Error(`컨테이너 상태 ${status}${detail ? ` — ${detail}` : \"\"}`);\n }\n\n const mediaId = await publishContainer(containerId);\n const link = await permalink(mediaId);\n\n await updateJob(job.id, {\n status: \"published\",\n ig_media_id: mediaId,\n published_at: new Date().toISOString(),\n error: null,\n });\n // 무료 티어 블롭이 10MB뿐이라 발행 직후 비워 줍니다.\n await deleteImages(job.id);\n\n console.log(`${job.slug}: 발행 완료 ${link ?? mediaId}`);\n } catch (err) {\n const message = err instanceof Error ? err.message : String(err);\n const exhausted = attempts >= MAX_ATTEMPTS;\n await updateJob(job.id, {\n error: message,\n ...(exhausted ? { status: \"failed\" as const } : {}),\n });\n console.error(`${job.slug}: ${message}${exhausted ? \" (재시도 한도 초과 — 중단)\" : \"\"}`);\n }\n }\n}\n",[170],"55aa15e2-0846-4d68-815b-1c25f1069a86",["D",1785546987014],[27],"7592e5a7-27e6-4483-b5b8-81ec2bb6afdb","README.md","caf7d826-8d40-11f1-8cb0-1607ee4eb77e",["D",1785544484767],"# pf-carousel\n\ncard-maker 가 구운 카드 이미지를 받아 인스타그램 캐러셀로 예약 발행합니다.\n\n비밀값은 전부 환경변수에 있습니다. 이 저장소 코드는 공개입니다.\n",[181],"pulls","branches","forks","envVars",{"_193":150,"_195":61},"connections",{"_193":61,"_194":61},"count","unfilledCount","emptyCount",{"_41":180,"_31":181,"_29":182,"_139":-5,"_39":40,"_38":150,"_141":57,"_36":222,"_13":61,"_32":20,"_34":184,"_23":24,"_144":-5,"_204":223,"_26":224},{"_41":177,"_31":27,"_29":30,"_139":-5,"_39":40,"_38":14,"_141":57,"_36":219,"_13":61,"_32":33,"_34":35,"_23":24,"_144":-5,"_204":220,"_26":221},{"_41":169,"_31":170,"_29":171,"_139":-5,"_39":40,"_38":172,"_141":24,"_36":216,"_13":61,"_32":174,"_34":175,"_23":24,"_144":-5,"_204":217,"_26":218},{"_41":161,"_31":162,"_29":163,"_139":-5,"_39":40,"_38":164,"_141":57,"_36":213,"_13":166,"_32":33,"_34":167,"_23":24,"_144":-5,"_204":214,"_26":215},{"_41":154,"_31":155,"_29":156,"_139":-5,"_39":40,"_38":157,"_141":24,"_36":210,"_13":61,"_32":33,"_34":159,"_23":24,"_144":-5,"_204":211,"_26":212},{"_41":146,"_31":147,"_29":55,"_139":-5,"_39":40,"_38":148,"_141":24,"_36":207,"_13":150,"_32":151,"_34":152,"_23":24,"_144":-5,"_204":208,"_26":209},{"_41":136,"_31":137,"_29":138,"_139":-5,"_39":40,"_38":140,"_141":57,"_36":203,"_13":61,"_32":33,"_34":143,"_23":24,"_144":-5,"_204":205,"_26":206},["D",1785544589932],"children",[],[137],["D",1785544619406],[],[147],["D",1785544518661],[],[155],["D",1785546961352],[],[162],["D",1785544611004],[],[170],["D",1785546987014],[],[27],["D",1785544484767],[],[181],["D",1785544484752],["D",1789561254403],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_126":263,"_264":265,"_266":267,"_268":24,"_269":24,"_270":24,"_271":57,"_272":-5,"_273":-7,"_274":-7,"_275":61,"_276":24,"_277":24,"_278":-5,"_279":24,"_280":24,"_281":24,"_282":-5},"ENV",{"_234":235,"_236":237,"_238":88,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262},"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 · v12