[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_232":233,"_234":235},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"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",13,"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","ig.ts","latestPath","fileId","df2a161a-8d40-11f1-a4a7-1607ee4eb77e","name","fileType","script","content","// 인스타그램 그래프 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","import { currentToken, currentUserId } from \"./auth.ts\";\n\n// 인스타그램 콘텐츠 발행 API.\n//\n// 호스트가 graph.instagram.com 인 것이 핵심입니다. 이게 \"인스타그램 로그인\"\n// 방식이고, 페이스북 페이지를 연결하지 않아도 됩니다.\n// (graph.facebook.com 은 페이스북 로그인 방식이라 페이지가 필요합니다.)\n//\n// 캐러셀 발행은 3단계입니다.\n// 1) 이미지마다 자식 컨테이너를 만든다 (is_carousel_item=true)\n// 2) 자식들을 묶어 캐러셀 컨테이너를 만든다 (캡션은 여기 붙는다)\n// 3) 컨테이너가 FINISHED 가 되면 media_publish 한다\n// 컨테이너는 24시간 유효하므로 만들어 두고 다음 크론에서 이어받아도 됩니다.\n\nconst GRAPH = \"https://graph.instagram.com\";\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: await currentToken() }),\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: await currentToken() });\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 const igId = await currentUserId();\n\n const children: string[] = [];\n for (const image_url of imageUrls) {\n const child = await post(`${igId}/media`, {\n image_url,\n media_type: \"IMAGE\",\n is_carousel_item: \"true\",\n });\n children.push(child.id);\n }\n\n const carousel = await post(`${igId}/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(`${await currentUserId()}/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\n/** 24시간 안에 몇 건이나 더 올릴 수 있는지. 상한은 계정당 하루 50건입니다. */\nexport async function publishingQuota(): Promise<{ used: number; cap: number } | null> {\n try {\n const r = await get(`${await currentUserId()}/content_publishing_limit`, {\n fields: \"config,quota_usage\",\n });\n const row = r.data?.[0];\n return { used: row?.quota_usage ?? 0, cap: row?.config?.quota_total ?? 50 };\n } catch {\n return null;\n }\n}\n","createdAt",["D",1785547007023],"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",{"_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",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",{"_43":44,"_32":45,"_38":227,"_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":228,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":229,"_84":230,"_86":231,"_88":25},"tree",[198,199,200,201,202,203,204],"files",[198,199,200,201,202,203,204],"counts",{"_188":63,"_189":152,"_190":63,"_191":192,"_193":194},"contents",[131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":182,"_32":183,"_30":184,"_141":-5,"_41":42,"_40":152,"_143":59,"_38":185,"_13":63,"_33":20,"_35":186,"_24":25,"_146":-5,"_27":187},{"_43":175,"_32":176,"_30":177,"_141":-5,"_41":42,"_40":178,"_143":59,"_38":179,"_13":63,"_33":34,"_35":180,"_24":25,"_146":-5,"_27":181},{"_43":167,"_32":168,"_30":169,"_141":-5,"_41":42,"_40":170,"_143":25,"_38":171,"_13":63,"_33":172,"_35":173,"_24":25,"_146":-5,"_27":174},{"_43":159,"_32":160,"_30":161,"_141":-5,"_41":42,"_40":162,"_143":59,"_38":163,"_13":164,"_33":34,"_35":165,"_24":25,"_146":-5,"_27":166},{"_43":156,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":59,"_38":157,"_13":152,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":158},{"_43":148,"_32":149,"_30":57,"_141":-5,"_41":42,"_40":150,"_143":25,"_38":151,"_13":152,"_33":153,"_35":154,"_24":25,"_146":-5,"_27":155},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":59,"_38":144,"_13":63,"_33":34,"_35":145,"_24":25,"_146":-5,"_27":147},"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",[139],"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",[149],"4b944380-d3ba-40af-b33c-44afb8fad3ea",["D",1785547007023],[28],"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",[160],"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",[168],"55aa15e2-0846-4d68-815b-1c25f1069a86","auth.ts","9e6b9148-8d46-11f1-a61f-1607ee4eb77e",12,["D",1785546987014],"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",[176],"7592e5a7-27e6-4483-b5b8-81ec2bb6afdb","README.md","caf7d826-8d40-11f1-8cb0-1607ee4eb77e",["D",1785544484767],"# pf-carousel\n\ncard-maker 가 구운 카드 이미지를 받아 인스타그램 캐러셀로 예약 발행합니다.\n\n비밀값은 전부 환경변수에 있습니다. 이 저장소 코드는 공개입니다.\n",[183],"pulls","branches","forks","envVars",{"_195":152,"_197":63},"connections",{"_195":63,"_196":63},"count","unfilledCount","emptyCount",{"_43":182,"_32":183,"_30":184,"_141":-5,"_41":42,"_40":152,"_143":59,"_38":224,"_13":63,"_33":20,"_35":186,"_24":25,"_146":-5,"_206":225,"_27":226},{"_43":175,"_32":176,"_30":177,"_141":-5,"_41":42,"_40":178,"_143":59,"_38":221,"_13":63,"_33":34,"_35":180,"_24":25,"_146":-5,"_206":222,"_27":223},{"_43":167,"_32":168,"_30":169,"_141":-5,"_41":42,"_40":170,"_143":25,"_38":218,"_13":63,"_33":172,"_35":173,"_24":25,"_146":-5,"_206":219,"_27":220},{"_43":159,"_32":160,"_30":161,"_141":-5,"_41":42,"_40":162,"_143":59,"_38":215,"_13":164,"_33":34,"_35":165,"_24":25,"_146":-5,"_206":216,"_27":217},{"_43":156,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":59,"_38":212,"_13":152,"_33":34,"_35":37,"_24":25,"_146":-5,"_206":213,"_27":214},{"_43":148,"_32":149,"_30":57,"_141":-5,"_41":42,"_40":150,"_143":25,"_38":209,"_13":152,"_33":153,"_35":154,"_24":25,"_146":-5,"_206":210,"_27":211},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":59,"_38":205,"_13":63,"_33":34,"_35":145,"_24":25,"_146":-5,"_206":207,"_27":208},["D",1785544589932],"children",[],[139],["D",1785544619406],[],[149],["D",1785547007023],[],[28],["D",1785546961352],[],[160],["D",1785544611004],[],[168],["D",1785546987014],[],[176],["D",1785544484767],[],[183],["D",1785544484752],["D",1789561254403],{"_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,"_128":265,"_266":267,"_268":269,"_270":25,"_271":25,"_272":25,"_273":59,"_274":-5,"_275":-7,"_276":-7,"_277":63,"_278":25,"_279":25,"_280":-5,"_281":25,"_282":25,"_283":25,"_284":-5},"ENV",{"_236":237,"_238":239,"_240":90,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v13