[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_182":183,"_184":185},"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":25,"_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",6,"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","db.ts","latestPath","fileId","d3531904-8d40-11f1-9301-1607ee4eb77e","name","fileType","script","content","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\nexport async function createJob(job: {\n id: string;\n slug: string;\n caption: string;\n publish_at: string;\n image_count: number;\n}) {\n await initDb();\n await sqlite.execute({\n sql: `INSERT INTO jobs (id, slug, caption, publish_at, status, image_count, created_at)\n VALUES (?, ?, ?, ?, 'draft', ?, ?)`,\n args: [job.id, job.slug, job.caption, job.publish_at, job.image_count, new Date().toISOString()],\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","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\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","createdAt",["D",1785544547260],"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":177,"_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":178,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":179,"_84":180,"_86":181,"_88":25},"tree",[164,165,166],"files",[164,165,166],"counts",{"_154":63,"_155":150,"_156":63,"_157":158,"_159":160},"contents",[131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":147,"_32":148,"_30":149,"_137":-5,"_41":42,"_40":150,"_139":59,"_38":151,"_13":63,"_33":20,"_35":152,"_24":25,"_142":-5,"_27":153},{"_43":144,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":145,"_13":138,"_33":34,"_35":37,"_24":25,"_142":-5,"_27":146},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":25,"_38":140,"_13":63,"_33":34,"_35":141,"_24":25,"_142":-5,"_27":143},"00b76991-cfd0-459d-9711-13b5a8311b57","ig.ts","df2a161a-8d40-11f1-a4a7-1607ee4eb77e","parentId",3,"latest",["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","label",[135],"2d3ed109-bc9a-40f4-8741-8c8671f18e36",["D",1785544547260],[28],"7592e5a7-27e6-4483-b5b8-81ec2bb6afdb","README.md","caf7d826-8d40-11f1-8cb0-1607ee4eb77e",1,["D",1785544484767],"# pf-carousel\n\ncard-maker 가 구운 카드 이미지를 받아 인스타그램 캐러셀로 예약 발행합니다.\n\n비밀값은 전부 환경변수에 있습니다. 이 저장소 코드는 공개입니다.\n",[148],"pulls","branches","forks","envVars",{"_161":150,"_163":63},"connections",{"_161":63,"_162":63},"count","unfilledCount","emptyCount",{"_43":147,"_32":148,"_30":149,"_137":-5,"_41":42,"_40":150,"_139":59,"_38":174,"_13":63,"_33":20,"_35":152,"_24":25,"_142":-5,"_168":175,"_27":176},{"_43":144,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":171,"_13":138,"_33":34,"_35":37,"_24":25,"_142":-5,"_168":172,"_27":173},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":25,"_38":167,"_13":63,"_33":34,"_35":141,"_24":25,"_142":-5,"_168":169,"_27":170},["D",1785544518661],"children",[],[135],["D",1785544547260],[],[28],["D",1785544484767],[],[148],["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":215,"_216":217,"_218":219,"_220":25,"_221":25,"_222":25,"_223":59,"_224":-5,"_225":-7,"_226":-7,"_227":63,"_228":25,"_229":25,"_230":-5,"_231":25,"_232":25,"_233":25,"_234":-5},"ENV",{"_186":187,"_188":189,"_190":90,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214},"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 · v6