[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_249":250,"_251":252},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"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":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",16,"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","fu8625q8645q7f4sf0993q196f03ts1312.ts","latestPath","fileId","154a291e-c6e6-11f0-9988-42dde27851f2","name","fileType","http","content","import { connect } from \"npm:@tursodatabase/serverless\";\n\n// OpenAI DALL-E 3 API呼び出し関数\nasync function generateImageWithOpenAI(prompt, apiKey) {\n console.log(\"Calling OpenAI API with prompt:\", prompt.substring(0, 100) + \"...\");\n \n const response = await fetch(\"https://api.openai.com/v1/images/generations\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${apiKey}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n model: \"dall-e-3\",\n prompt: prompt,\n n: 1,\n size: \"1024x1024\",\n style: \"vivid\",\n quality: \"hd\",\n }),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error(\"OpenAI API error:\", response.status, errorText);\n throw new Error(`OpenAI API error (${response.status}): ${errorText}`);\n }\n\n const data = await response.json();\n console.log(\"OpenAI API success:\", data);\n return data.data[0];\n}\n\n// ウォーターマーク適用関数\nasync function applyWatermark(imageUrl, watermarkText = \"Brain Rod AI\") {\n return { url: imageUrl + `?watermark=${encodeURIComponent(watermarkText)}` };\n}\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n console.log(\"Image generation request received\");\n \n const { title, subject, customPrompt, styleTemplate, quality = \"hd\", watermark = true } = await req.json();\n \n // APIキーの確認 - ここで管理者が設定したAPIキーを取得\n const apiKey = __secrets['OPENAI_API_KEY'];\n if (!apiKey) {\n console.error(\"OpenAI API key not found in environment\");\n return Response.json({ \n error: \"OpenAI API key not configured by administrator\",\n debug: \"OPENAI_API_KEY environment variable missing\"\n }, { status: 500 });\n }\n\n console.log(\"API key found, proceeding with image generation\");\n\n // ユーザーUUIDの取得\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n console.error(\"No user UUID found in headers\");\n return Response.json({ error: \"Authentication required\" }, { status: 401 });\n }\n\n // データベース接続\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\"),\n });\n\n // プロンプトテンプレートの取得\n let finalPrompt = customPrompt;\n if (styleTemplate && !customPrompt) {\n const templateStmt = conn.prepare(\"SELECT * FROM prompt_templates WHERE id = ?\");\n const template = await templateStmt.get([styleTemplate]);\n \n if (template) {\n finalPrompt = template.template_prompt.replace('{subject}', subject || 'brain rod');\n }\n }\n\n if (!customPrompt && !styleTemplate && !subject) {\n return Response.json({ error: \"Subject or prompt is required\" }, { status: 400 });\n }\n\n // デフォルトプロンプト\n if (!finalPrompt) {\n finalPrompt = `${subject} in brain rod style, surreal biological form, detailed neural patterns, organic texture, artistic interpretation, high detail, professional quality`;\n }\n\n console.log(\"Final prompt generated:\", finalPrompt.substring(0, 100) + \"...\");\n\n // 画像生成レコードの作成\n const imageId = crypto.randomUUID();\n const insertStmt = conn.prepare(`\n INSERT INTO generated_images (id, title, prompt, style_params, image_url, thumbnail_url, status, metadata, _created_by, _created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `);\n \n const params = JSON.stringify({ quality, watermark, style: styleTemplate || 'custom' });\n await insertStmt.run([\n imageId,\n title || `${subject} - Generated Image`,\n finalPrompt,\n params,\n '', // 仮のURL\n '', // 仮のサムネイルURL\n 'generating',\n JSON.stringify({ generationStarted: Date.now(), userUuid }),\n userUuid,\n Math.floor(Date.now() / 1000)\n ]);\n\n console.log(\"Database record created, calling OpenAI API\");\n\n // OpenAIで画像生成\n const imageData = await generateImageWithOpenAI(finalPrompt, apiKey);\n console.log(\"Image generated successfully:\", imageData.url);\n\n // 生成された画像情報でレコードを更新\n const updateStmt = conn.prepare(`\n UPDATE generated_images \n SET image_url = ?, thumbnail_url = ?, status = 'completed', metadata = ?, _updated_at = ?\n WHERE id = ? AND _created_by = ?\n `);\n \n const metadata = JSON.stringify({\n generationStarted: Date.now(),\n completed: true,\n originalPrompt: finalPrompt,\n openaiData: {\n url: imageData.url,\n revised_prompt: imageData.revised_prompt\n }\n });\n\n let finalImageUrl = imageData.url;\n let thumbnailUrl = imageData.url + \"?width=300\";\n\n // ウォーターマーク適用（必要な場合）\n if (watermark) {\n const watermarkResult = await applyWatermark(finalImageUrl, \"Brain Rod AI\");\n finalImageUrl = watermarkResult.url;\n }\n\n await updateStmt.run([\n finalImageUrl,\n thumbnailUrl,\n metadata,\n Math.floor(Date.now() / 1000),\n imageId,\n userUuid\n ]);\n\n console.log(\"Database record updated successfully\");\n\n return Response.json({\n success: true,\n imageId,\n imageUrl: finalImageUrl,\n thumbnailUrl,\n title: title || `${subject} - Generated Image`,\n prompt: finalPrompt,\n revisedPrompt: imageData.revised_prompt\n });\n\n } catch (error) {\n console.error(\"Error generating image:\", error);\n \n // エラー状態をデータベースに保存\n try {\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\"),\n });\n \n const errorUpdateStmt = conn.prepare(`\n UPDATE generated_images \n SET status = 'failed', error_message = ?, _updated_at = ?\n WHERE id = ? AND _created_by = ?\n `);\n \n // 特定のエラーメッセージをユーザーに返す\n let userMessage = \"画像生成に失敗しました\";\n if (error.message.includes(\"invalid_api_key\")) {\n userMessage = \"管理者がAPIキーを設定する必要があります\";\n } else if (error.message.includes(\"insufficient_quota\")) {\n userMessage = \"APIクォータが不足しています\";\n }\n\n if (body?.imageId) {\n await errorUpdateStmt.run([\n error.message, \n Math.floor(Date.now() / 1000),\n body.imageId, \n req.headers.get(\"x-user-uuid\")\n ]);\n }\n\n return Response.json(\n { error: userMessage, technical: error.message },\n { status: 500 }\n );\n } catch (dbError) {\n console.error(\"Failed to update error status:\", dbError);\n }\n\n return Response.json(\n { error: \"画像生成に失敗しました\", technical: error.message },\n { status: 500 }\n );\n }\n}","import { connect } from \"npm:@tursodatabase/serverless\";\n\n// 🔒 イベントログ記録関数\nasync function logSecurityEvent(conn, userUuid, event, details) {\n try {\n const logStmt = conn.prepare(`\n INSERT INTO security_logs (id, user_uuid, event_type, event_details, ip_address, user_agent, _created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `);\n \n await logStmt.run([\n crypto.randomUUID(),\n userUuid,\n event,\n JSON.stringify(details),\n \"unknown\", // 将来的にIP取得\n \"Brain Rod AI Client\",\n Math.floor(Date.now() / 1000)\n ]);\n } catch (error) {\n console.error(\"Failed to log security event:\", error);\n }\n}\n\n// OpenAI DALL-E 3 API呼び出し関数\nasync function generateImageWithOpenAI(prompt, apiKey) {\n console.log(\"🔄 Calling OpenAI API with prompt:\", prompt.substring(0, 100) + \"...\");\n \n const response = await fetch(\"https://api.openai.com/v1/images/generations\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${apiKey}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n model: \"dall-e-3\",\n prompt: prompt,\n n: 1,\n size: \"1024x1024\",\n style: \"vivid\",\n quality: \"hd\",\n }),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error(\"❌ OpenAI API error:\", response.status, errorText);\n throw new Error(`OpenAI API error (${response.status}): ${errorText}`);\n }\n\n const data = await response.json();\n console.log(\"✅ OpenAI API success:\", data);\n return data.data[0];\n}\n\n// ウォーターマーク適用関数\nasync function applyWatermark(imageUrl, watermarkText = \"Brain Rod AI\") {\n return { url: imageUrl + `?watermark=${encodeURIComponent(watermarkText)}` };\n}\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const startTime = Date.now();\n let userUuid = null;\n let dbConnection = null;\n \n try {\n console.log(\"🔒 Image generation request received with security validation\");\n \n // 🔒 厳密な認証チェック\n userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n console.error(\"❌ No user UUID found in headers - unauthorized access attempt\");\n return Response.json({ \n error: \"Authentication required\",\n security: \"Missing user identification\"\n }, { status: 401 });\n }\n\n const body = await req.json();\n const { title, subject, customPrompt, styleTemplate, quality = \"hd\", watermark = true } = body;\n\n // 🔒 データベース接続とセキュリティログ記録\n dbConnection = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\"),\n });\n\n // セキュリティイベントログ\n await logSecurityEvent(dbConnection, userUuid, \"image_generation_request\", {\n title,\n subject,\n hasCustomPrompt: !!customPrompt,\n styleTemplate,\n timestamp: startTime\n });\n\n // 🔒 APIキーの確認\n const apiKey = __secrets['OPENAI_API_KEY'];\n if (!apiKey) {\n console.error(\"❌ OpenAI API key not found in environment\");\n await logSecurityEvent(dbConnection, userUuid, \"api_key_missing\", { reason: \"Environment variable missing\" });\n \n return Response.json({ \n error: \"OpenAI API key not configured by administrator\",\n security: \"API configuration error\"\n }, { status: 500 });\n }\n\n console.log(\"✅ API key validation passed\");\n\n // 🔒 入力パラメータのセキュリティチェック\n if (!title || title.trim().length === 0) {\n return Response.json({ \n error: \"Title is required\",\n security: \"Missing required parameter\"\n }, { status: 400 });\n }\n\n if (title.length > 200) {\n return Response.json({ \n error: \"Title too long (max 200 characters)\",\n security: \"Input validation failed\"\n }, { status: 400 });\n }\n\n // 🔒 プロンプトの長さと内容チェック\n if (customPrompt && customPrompt.length > 1000) {\n return Response.json({ \n error: \"Custom prompt too long (max 1000 characters)\",\n security: \"Input validation failed\"\n }, { status: 400 });\n }\n\n // 🔒 有害なプロンプトのチェック（簡易版）\n const blockedwords = ['illegal', 'hack', 'exploit', 'vulnerability'];\n const promptText = customPrompt || subject || '';\n const hasBlockedContent = blockedwords.some(word => \n promptText.toLowerCase().includes(word)\n );\n \n if (hasBlockedContent) {\n console.error(\"❌ Blocked content detected in prompt\");\n await logSecurityEvent(dbConnection, userUuid, \"blocked_content_detected\", { prompt: promptText.substring(0, 200) });\n \n return Response.json({ \n error: \"Prompt contains restricted content\",\n security: \"Content policy violation\"\n }, { status: 400 });\n }\n\n // プロンプトテンプレートの取得\n let finalPrompt = customPrompt;\n if (styleTemplate && !customPrompt) {\n const templateStmt = dbConnection.prepare(\"SELECT * FROM prompt_templates WHERE id = ? AND is_active = 1\");\n const template = await templateStmt.get([styleTemplate]);\n \n if (template) {\n finalPrompt = template.template_prompt.replace('{subject}', subject || 'brain rod');\n console.log(\"✅ Applied template:\", template.name);\n } else {\n console.error(\"❌ Template not found or inactive:\", styleTemplate);\n return Response.json({ error: \"Invalid template\" }, { status: 400 });\n }\n }\n\n if (!customPrompt && !styleTemplate && !subject) {\n return Response.json({ \n error: \"Subject or prompt is required\",\n security: \"Missing content parameter\"\n }, { status: 400 });\n }\n\n // デフォルトプロンプト\n if (!finalPrompt) {\n finalPrompt = `${subject} in brain rod style, surreal biological form, detailed neural patterns, organic texture, artistic interpretation, high detail, professional quality`;\n }\n\n console.log(\"✅ Final prompt generated:\", finalPrompt.substring(0, 100) + \"...\");\n\n // 🔒 レート制限チェック（過去1時間の生成回数）\n const rateLimitStmt = dbConnection.prepare(`\n SELECT COUNT(*) as count FROM generated_images \n WHERE _created_by = ? AND _created_at > ?\n `);\n const oneHourAgo = Math.floor((Date.now() - 60 * 60 * 1000) / 1000);\n const rateCheck = await rateLimitStmt.get([userUuid, oneHourAgo]);\n \n if (rateCheck.count > 20) { // 1時間20回まで\n console.error(\"❌ Rate limit exceeded for user:\", userUuid);\n await logSecurityEvent(dbConnection, userUuid, \"rate_limit_exceeded\", { count: rateCheck.count });\n \n return Response.json({ \n error: \"Rate limit exceeded. Please try again later.\",\n security: \"Usage limit enforcement\"\n }, { status: 429 });\n }\n\n // 🔒 画像生成レコードの作成\n const imageId = crypto.randomUUID();\n const insertStmt = dbConnection.prepare(`\n INSERT INTO generated_images (id, title, prompt, style_params, image_url, thumbnail_url, status, metadata, _created_by, _created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `);\n \n const params = JSON.stringify({ quality, watermark, style: styleTemplate || 'custom' });\n await insertStmt.run([\n imageId,\n title || `${subject} - Generated Image`,\n finalPrompt,\n params,\n '', // 仮のURL\n '', // 仮のサムネイルURL\n 'generating',\n JSON.stringify({ \n generationStarted: Date.now(), \n userUuid,\n securityValidated: true,\n rateLimitChecked: true\n }),\n userUuid,\n Math.floor(Date.now() / 1000)\n ]);\n\n console.log(\"✅ Database record created, calling OpenAI API\");\n\n // OpenAIで画像生成\n const imageData = await generateImageWithOpenAI(finalPrompt, apiKey);\n console.log(\"✅ Image generated successfully:\", imageData.url);\n\n // 🔒 成功イベントの記録\n await logSecurityEvent(dbConnection, userUuid, \"image_generation_success\", {\n imageId,\n generationTime: Date.now() - startTime\n });\n\n // 生成された画像情報でレコードを更新\n const updateStmt = dbConnection.prepare(`\n UPDATE generated_images \n SET image_url = ?, thumbnail_url = ?, status = 'completed', metadata = ?, _updated_at = ?\n WHERE id = ? AND _created_by = ?\n `);\n \n const metadata = JSON.stringify({\n generationStarted: Date.now(),\n completed: true,\n originalPrompt: finalPrompt,\n openaiData: {\n url: imageData.url,\n revised_prompt: imageData.revised_prompt\n },\n security: {\n validated: true,\n rateLimited: false,\n blockedContent: false\n }\n });\n\n let finalImageUrl = imageData.url;\n let thumbnailUrl = imageData.url + \"?width=300\";\n\n // ウォーターマーク適用（必要な場合）\n if (watermark) {\n const watermarkResult = await applyWatermark(finalImageUrl, \"Brain Rod AI\");\n finalImageUrl = watermarkResult.url;\n }\n\n await updateStmt.run([\n finalImageUrl,\n thumbnailUrl,\n metadata,\n Math.floor(Date.now() / 1000),\n imageId,\n userUuid\n ]);\n\n console.log(\"✅ Database record updated successfully\");\n\n return Response.json({\n success: true,\n imageId,\n imageUrl: finalImageUrl,\n thumbnailUrl,\n title: title || `${subject} - Generated Image`,\n prompt: finalPrompt,\n revisedPrompt: imageData.revised_prompt,\n security: {\n validated: true,\n rateLimitPassed: true\n }\n });\n\n } catch (error) {\n console.error(\"❌ Error generating image:\", error);\n const duration = Date.now() - startTime;\n \n // 🔒 エラー状態をデータベースに保存\n try {\n if (!dbConnection && req.headers.get(\"x-database-url\")) {\n dbConnection = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\"),\n });\n }\n \n if (dbConnection) {\n await logSecurityEvent(dbConnection, userUuid, \"image_generation_error\", {\n error: error.message,\n duration\n });\n\n const errorUpdateStmt = dbConnection.prepare(`\n UPDATE generated_images \n SET status = 'failed', error_message = ?, _updated_at = ?\n WHERE id = ? AND _created_by = ?\n `);\n \n // imageIDがリクエストに含まれている場合\n const body = req.body ? await req.json() : {};\n if (body.imageId) {\n await errorUpdateStmt.run([\n error.message, \n Math.floor(Date.now() / 1000),\n body.imageId, \n userUuid\n ]);\n }\n }\n } catch (dbError) {\n console.error(\"Failed to update error status:\", dbError);\n }\n\n // 🔒 セキュリティ関連のエラーメッセージ\n let userMessage = \"画像生成に失敗しました\";\n let statusCode = 500;\n \n if (error.message.includes(\"invalid_api_key\")) {\n userMessage = \"管理者がAPIキーを設定する必要があります\";\n statusCode = 503;\n } else if (error.message.includes(\"insufficient_quota\")) {\n userMessage = \"APIクォータが不足しています\";\n statusCode = 503;\n } else if (error.message.includes(\"rate limit\")) {\n userMessage = \"利用制限を超えました。時間を置いてお試しください\";\n statusCode = 429;\n } else if (error.message.includes(\"Authentication\")) {\n userMessage = \"認証エラーが発生しました\";\n statusCode = 401;\n }\n\n return Response.json(\n { \n error: userMessage, \n technical: error.message,\n security: {\n errorLogged: true,\n duration: duration,\n requiresReauth: statusCode === 401\n }\n },\n { status: statusCode }\n );\n }\n}","createdAt",["D",1763735710064],"branchVersion","branchId","1c7f743c-c3d0-11f0-a332-42dde27851f2","id","1c7f3698-c3d0-11f0-a332-42dde27851f2","teq36e95ft57974994sq2043q942f9fve8",["D",1763395904717],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","0199d9f9-8fb9-705d-a1be-150ee5ea0145","pinnedFileId","38ded55a-c3d0-11f0-90d2-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","0199d9f9-8fb9-705d-a1be-18ed6d1d02d7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kliv","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":245,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":246,"_80":247,"_82":248,"_84":25},"tree",[208,209,210,211,212,213,214,215,216],"files",[208,209,210,211,212,213,214,215,216],"counts",{"_197":62,"_198":199,"_200":62,"_201":202,"_203":204},"contents",[126,127,128,129,130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":192,"_32":193,"_30":56,"_138":-5,"_41":42,"_40":176,"_140":58,"_38":194,"_13":62,"_33":34,"_35":195,"_24":25,"_144":-5,"_27":196},{"_43":185,"_32":186,"_30":187,"_138":-5,"_41":42,"_40":188,"_140":58,"_38":189,"_13":62,"_33":34,"_35":190,"_24":25,"_144":-5,"_27":191},{"_43":178,"_32":179,"_30":180,"_138":-5,"_41":42,"_40":181,"_140":58,"_38":182,"_13":62,"_33":34,"_35":183,"_24":25,"_144":-5,"_27":184},{"_43":174,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":175,"_13":176,"_33":34,"_35":37,"_24":25,"_144":-5,"_27":177},{"_43":167,"_32":168,"_30":169,"_138":-5,"_41":42,"_40":170,"_140":58,"_38":171,"_13":62,"_33":34,"_35":172,"_24":25,"_144":-5,"_27":173},{"_43":160,"_32":161,"_30":162,"_138":-5,"_41":42,"_40":163,"_140":58,"_38":164,"_13":62,"_33":34,"_35":165,"_24":25,"_144":-5,"_27":166},{"_43":153,"_32":154,"_30":155,"_138":-5,"_41":42,"_40":156,"_140":58,"_38":157,"_13":62,"_33":34,"_35":158,"_24":25,"_144":-5,"_27":159},{"_43":146,"_32":147,"_30":148,"_138":-5,"_41":42,"_40":149,"_140":58,"_38":150,"_13":62,"_33":34,"_35":151,"_24":25,"_144":-5,"_27":152},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":58,"_38":141,"_13":142,"_33":34,"_35":143,"_24":25,"_144":-5,"_27":145},"f72f6d7a-c3d1-11f0-8b7e-42dde27851f2","fuv9816v4623964e76qq060s286evse1e2.ts","1c8c6d36-c3d0-11f0-ae20-42dde27851f2","parentId",7,"latest",["D",1763396701080],4,"export default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n // CORS preflight handling\n if (req.method === \"OPTIONS\") {\n return Response.json({}, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type, Authorization, X-User-UUID, X-Platform-Token\",\n \"Access-Control-Max-Age\": \"86400\"\n }\n });\n }\n\n try {\n // 開発モード認証チェック（緩和版）\n const userUuid = req.headers.get(\"x-user-uuid\");\n const isDevelopment = req.headers.get(\"x-development-mode\") === \"true\";\n \n if (!userUuid && !isDevelopment) {\n console.log(\"アクセス拒否: ユーザーUUIDなし\");\n return Response.json({\n success: false,\n error: \"アクセスが拒否されました。ログインしてください。\",\n error_code: \"MISSING_USER_UUID\"\n }, { \n status: 403,\n headers: getHeaders()\n });\n }\n\n // 開発モードの場合は匿名ユーザーを許可\n const effectiveUserUuid = userUuid || \"development-anonymous\";\n\n const clientInfo = {\n userUuid: effectiveUserUuid,\n clientIP: req.headers.get(\"x-forwarded-for\") || req.headers.get(\"remote-addr\") || \"unknown\",\n userAgent: req.headers.get(\"user-agent\") || \"unknown\",\n timestamp: new Date().toISOString(),\n isDevelopment\n };\n\n console.log(`画像生成リクエスト: ${JSON.stringify(clientInfo)}`);\n\n const body = await req.json();\n const { prompt, style = \"realistic\", model = \"enhanced-v2\", quality = \"ultra_hd\", enhance_prompt = true } = body;\n\n if (!prompt || !prompt.trim()) {\n return Response.json({\n success: false,\n error: \"プロンプトは必須です\",\n error_code: \"MISSING_PROMPT\"\n }, { \n status: 400,\n headers: getHeaders()\n });\n }\n\n console.log(\"プロンプト検証通過:\", prompt.substring(0, 50) + \"...\");\n\n // 開発モード用の高速画像生成\n const generateImage = async () => {\n const seed = Date.now() + Math.floor(Math.random() * 1000);\n const width = 512;\n const height = 512;\n \n // 開発用画像プロバイダー\n const imageUrl = `https://picsum.photos/seed/ai-${seed}-dev/${width}/${height}?random=${seed}`;\n \n // 擬似メタデータ\n const metadata = {\n original_prompt: prompt,\n enhanced_prompt: enhance_prompt ? `${prompt}, ${style} style, high quality` : prompt,\n style,\n model,\n quality,\n generation_time_ms: 1500,\n tokens_used: 30,\n optimized_seed: seed,\n genre_analysis: detectGenre(prompt),\n image_quality: calculateQuality(prompt, style),\n user_uuid: effectiveUserUuid,\n generated_at: new Date().toISOString()\n };\n\n return {\n url: imageUrl,\n metadata\n };\n };\n\n // 画像生成処理\n const result = await generateImage();\n\n const response = {\n success: true,\n image_url: result.url,\n metadata: result.metadata,\n timestamp: new Date().toISOString()\n };\n \n console.log(`画像生成成功: User=${effectiveUserUuid}`);\n \n return Response.json(response, {\n headers: getHeaders()\n });\n\n } catch (error) {\n console.error('画像生成エラー:', error);\n \n return Response.json({\n success: false,\n error: \"画像生成に失敗しました\",\n error_type: \"GENERATION_ERROR\",\n timestamp: new Date().toISOString()\n }, { \n status: 500,\n headers: getHeaders()\n });\n }\n}\n\n// 共通ヘッダーを返すヘルパー関数\nfunction getHeaders(): HeadersInit {\n return {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type, Authorization, X-User-UUID, X-Platform-Token\",\n \"Content-Type\": \"application/json\"\n };\n}\n\n// ジャンル検出\nfunction detectGenre(prompt: string): string {\n const lower = prompt.toLowerCase();\n if (lower.includes('富士山') || lower.includes('山') || lower.includes('自然') || lower.includes('景色')) {\n return 'nature_landscape';\n }\n if (lower.includes('女の子') || lower.includes('人') || lower.includes('人物')) {\n return 'portrait';\n }\n if (lower.includes('都會') || lower.includes('建物') || lower.includes('都市')) {\n return 'urban_architecture';\n }\n if (lower.includes('料理') || lower.includes('食べ物')) {\n return 'food';\n }\n return 'general';\n}\n\n// 品質スコア計算\nfunction calculateQuality(prompt: string, style?: string): number {\n let score = 75;\n if (prompt.length > 20) score += 5;\n if (style === 'photorealistic' || style === 'realistic') score += 8;\n return Math.min(score, 99);\n}","label",[136],"e884f44e-c3d5-11f0-8d73-42dde27851f2","fut7761qs6t87s4568q8t8e1f489v0s16v.ts","e884f502-c3d5-11f0-8d73-42dde27851f2",8,["D",1763398394491],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const body = await req.json();\n const { \n nationName, \n geographyType, \n politicalSystem, \n timePeriod, \n cultureType,\n basicInfo,\n apiKey,\n language = \"ja\" \n } = body;\n\n // 入力検証\n if (!nationName || !geographyType || !politicalSystem || !timePeriod) {\n return Response.json({ error: \"必須パラメータが不足しています\" }, { status: 400 });\n }\n\n if (!apiKey) {\n return Response.json({ error: \"OpenAI APIキーが必要です\" }, { status: 400 });\n }\n\n // OpenAI APIにプロンプトを作成\n const prompt = createPrompt(nationName, geographyType, politicalSystem, timePeriod, cultureType, basicInfo, language);\n\n // OpenAI API呼び出し\n const aiResponse = await callOpenAI(prompt, apiKey);\n\n // 生成結果を解析\n const generatedContent = parseAIResponse(aiResponse);\n\n // データベースに保存（オプション）\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (userUuid && basicInfo?.saveToDatabase) {\n await saveToDatabase(userUuid, { nationName, geographyType, politicalSystem, timePeriod, cultureType }, generatedContent);\n }\n\n return Response.json({\n success: true,\n nation: {\n name: nationName,\n basicInfo: {\n geographyType,\n politicalSystem,\n timePeriod,\n cultureType\n },\n ...generatedContent\n }\n }, { status: 200 });\n\n } catch (error) {\n console.error(\"Nation generation error:\", error);\n return Response.json({ \n error: error.message || \"国家生成中にエラーが発生しました\",\n success: false \n }, { status: 500 });\n }\n}\n\nfunction createPrompt(nationName, geographyType, politicalSystem, timePeriod, cultureType, basicInfo, language) {\n const regionText = geographyType === \"山地\" ? \"山間部の\" : \n geographyType === \"海洋\" ? \"海に面した\" :\n geographyType === \"砂漠\" ? \"砂漠地域の\" :\n geographyType === \"平原\" ? \"平野部の\" : \"様々な地形の\";\n\n const systemText = politicalSystem === \"君主制\" ? \"皇帝または王を中心とする\" :\n politicalSystem === \"共和制\" ? \"貴族や市民が政治を担う\" :\n politicalSystem === \"民主制\" ? \"民衆の意思が反映される\" :\n politicalSystem === \"神政制\" ? \"宗教的指導者が統治する\" : \"独特な政治体制の\";\n\n const periodText = timePeriod === \"古代\" ? \"古代ローマや中国のような\" :\n timePeriod === \"中世\" ? \"中世ヨーロッパや日本のような\" :\n timePeriod === \"近世\" ? \"ルネサンス期や江戸時代のような\" :\n timePeriod === \"近代\" ? \"産業革命期の\" : \"特定の時代背景の\";\n\n const cultureDesc = cultureType === \"武士文化\" ? \"武道や忠義を重んじる\" :\n cultureType === \"商人文化\" ? \"貿易や商業を重視する\" :\n cultureType === \"宗教文化\" ? \"宗教的価値観が中心の\" :\n cultureType === \"学術文化\" ? \"学問や芸術を重視する\" :\n\n if (language === \"ja\") {\n return `\nあなたは歴史学者であり、創作家です。以下の条件で完全に新しい架空の歴史国家を創造してください。\n\n国家名: ${nationName}\n地理特徴: ${regionText}${geographyType}地域\n政治体制: ${systemText}${politicalSystem}\n時代背景: ${periodText}${timePeriod}\n文化特徴: ${cultureDesc}文化${cultureType ? '' : ''}\n${basicInfo?.additionalNotes ? `追加情報: ${basicInfo.additionalNotes}` : ''}\n\n以下の形式で、詳細で一貫性のある国家設定を段落形式で記述してください。各段落は長文で詳細に記載し、歴史的リアリティのある内容を生成してください。\n\n生成形式：\n{\n \"overview\": \"国家概要 - 地理的位置、基本的特徴、歴史的背景などを詳細に段落形式で説明\",\n \"history\": [\n {\n \"era\": \"建国期\",\n \"content\": \"建国の経緯、建国者、初期の政治体制などを詳細な段落で説明\"\n },\n {\n \"era\": \"発展期\", \n \"content\": \"国家の発展過程、重要な出来事、勢力拡大などを段落形式で詳細説明\"\n },\n {\n \"era\": \"黄金期\",\n \"content\": \"文化・経済・軍事の最盛期、重要な人物や出来事などを段落形式で詳細説明\"\n }\n ],\n \"geography\": [\n {\n \"region\": \"首都圏\",\n \"description\": \"首都の地理的特徴、位置的重要性、都市構造などを段落形式で詳細説明\"\n },\n {\n \"region\": \"沿岸部/山岳部 etc\",\n \"description\": \"地域の自然的特徴、資源、戦略的重要性などを段落形式で詳細説明\"\n }\n ],\n \"culture\": [\n {\n \"aspect\": \"宗教・信仰\",\n \"content\": \"国民の信仰体系、宗教的儀式、社会的影響などを段落形式で詳細説明\"\n },\n {\n \"aspect\": \"言語・文字\",\n \"content\": \"使用言語、文字体系、文学の特徴などを段落形式で詳細説明\"\n },\n {\n \"aspect\": \"芸術・美術\",\n \"content\": \"建築様式、絵画、彫刻、工芸品などの特徴を段落形式で詳細説明\"\n },\n {\n \"aspect\": \"技術・科学\",\n \"content\": \"特筆すべき技術革新、科学的発見、工業水準などを段落形式で詳細説明\"\n }\n ],\n \"characters\": [\n {\n \"name\": \"建国者の名前\",\n \"role\": \"建国者/皇帝/etc\",\n \"biography\": \"人物の生涯、功績、個性などを段落形式で詳細説明\"\n },\n {\n \"name\": \"重要人物の名前\", \n \"role\": \"将軍/学者/商人/etc\",\n \"biography\": \"人物の国家への貢献、影響力などを段落形式で詳細説明\"\n }\n ],\n \"economy\": \"経済構造 - 主要産業、貿易、貨幣システム、経済的特徴などを段落形式で詳細説明\",\n \"military\": \"軍事組織 - 戦術、武器、編制、軍事的特徴などを段落形式で詳細説明\",\n \"governance\": \"統治構造 - 行政組織、法律制度、社会階級、統治の特徴などを段落形式で詳細説明\"\n}\n\n注意点：\n- 各内容は段落形式で複数の文から構成すること\n- 歴史的合理性と一貫性を保つこと\n- 可能な限り詳細で具体的な記述をすること\n- 人名、地名、年号などを作成して世界観に深みを加えること\n- 自然な日本語で学術的で、物語性のある文章スタイルを維持すること\n`;\n } else {\n return `Create a detailed historical nation...`; // 英語版も実装可能\n }\n}\n\nasync function callOpenAI(prompt, apiKey) {\n const response = await fetch(\"https://api.openai.com/v1/chat/completions\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${apiKey}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n model: \"gpt-4\",\n messages: [\n {\n role: \"system\",\n content: \"You are a historian and creative writer specializing in historical worldbuilding. Generate detailed, realistic historical nations with proper paragraph structure and historical consistency.\"\n },\n {\n role: \"user\", \n content: prompt\n }\n ],\n temperature: 0.7,\n max_tokens: 4000\n })\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`OpenAI API error: ${response.status} - ${error}`);\n }\n\n const data = await response.json();\n return data.choices[0].message.content;\n}\n\nfunction parseAIResponse(aiResponse) {\n try {\n // JSONを抽出しようと試みる\n const jsonMatch = aiResponse.match(/\\{[\\s\\S]*\\}/);\n if (jsonMatch) {\n return JSON.parse(jsonMatch[0]);\n }\n \n // JSONが見つからない場合は、テキストとして解析\n return {\n overview: aiResponse.substring(0, 1000),\n history: [],\n geography: [],\n culture: [],\n characters: [],\n economy: \"\",\n military: \"\",\n governance: \"\"\n };\n } catch (error) {\n console.warn(\"Failed to parse AI response as JSON:\", error);\n return {\n overview: aiResponse,\n history: [],\n geography: [],\n culture: [],\n characters: [],\n economy: \"\",\n military: \"\",\n governance: \"\"\n };\n }\n}\n\nasync function saveToDatabase(userUuid, basicInfo, content) {\n try {\n const conn = connect({\n url: __secrets['DATABASE_URL'] || 'file:./development.db',\n authToken: __secrets['DATABASE_TOKEN']\n });\n\n // 国家基本情報を保存\n const nationStmt = conn.prepare(`\n INSERT INTO nations (name, political_system, geography_type, time_period, culture_type, basic_info)\n VALUES (?, ?, ?, ?, ?, ?)\n `);\n \n const result = await nationStmt.run([\n basicInfo.nationName,\n basicInfo.politicalSystem, \n basicInfo.geographyType,\n basicInfo.timePeriod,\n basicInfo.cultureType,\n JSON.stringify(basicInfo)\n ]);\n\n const nationId = result.lastInsertRowid;\n\n // 履歴情報を保存\n if (content.history && content.history.length > 0) {\n for (const history of content.history) {\n const historyStmt = conn.prepare(`\n INSERT INTO nation_history (nation_id, title, content, era, category)\n VALUES (?, ?, ?, ?, ?)\n `);\n await historyStmt.run([nationId, history.era, history.content, history.era, 'general']);\n }\n }\n\n // 地理情報を保存\n if (content.geography && content.geography.length > 0) {\n for (const geography of content.geography) {\n const geoStmt = conn.prepare(`\n INSERT INTO nation_geography (nation_id, region_name, description)\n VALUES (?, ?, ?)\n `);\n await geoStmt.run([nationId, geography.region, geography.description]);\n }\n }\n\n await conn.close();\n \n } catch (error) {\n console.error(\"Failed to save to database:\", error);\n // データベース保存に失敗しても、生成結果は返す\n }\n}",[147],"1cab4224-c6e6-11f0-a2af-42dde27851f2","fut19942s06696441v829024704s61q924.ts","1cab42f6-c6e6-11f0-a2af-42dde27851f2",10,["D",1763735207419],"import { connect } from \"npm:@tursodatabase/serverless\";\nimport auth from \"npm:@klivinc/kliv-auth-js\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n // クエリパラメータの取得\n const url = new URL(req.url);\n const limit = parseInt(url.searchParams.get('limit') || '20');\n const offset = parseInt(url.searchParams.get('offset') || '0');\n const status = url.searchParams.get('status');\n const shared = url.searchParams.get('shared') === 'true';\n\n // ユーザーUUIDの取得\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n }\n\n // データベース接続\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\"),\n });\n\n let query = `\n SELECT gi.*, \n COUNT(DISTINCT ish.id) as shared_count\n FROM generated_images gi\n LEFT JOIN image_shares ish ON gi.id = ish.image_id\n WHERE 1=1\n `;\n const params = [];\n\n // 所有者フィルタ（非共有の場合）\n if (shared && shared === 'true') {\n // 共有された画像（自分が共有されているもの）\n query += ` AND gi.id IN (\n SELECT image_id FROM image_shares \n WHERE shared_with_user = ?\n )`;\n params.push(userUuid);\n } else {\n // 自分の画像\n query += ` AND gi._created_by = ?`;\n params.push(userUuid);\n }\n\n // ステータスフィルタ\n if (status) {\n query += ` AND gi.status = ?`;\n params.push(status);\n }\n\n query += ` \n GROUP BY gi.id \n ORDER BY gi._created_at DESC \n LIMIT ? OFFSET ?\n `;\n params.push(limit, offset);\n\n const stmt = conn.prepare(query);\n const images = await stmt.all(params);\n\n // 合計数の取得\n let countQuery = `SELECT COUNT(DISTINCT gi.id) as total FROM generated_images gi `;\n \n if (shared && shared === 'true') {\n countQuery += ` INNER JOIN image_shares ish ON gi.id = ish.image_id WHERE ish.shared_with_user = ?`;\n } else {\n countQuery += ` WHERE gi._created_by = ?`;\n }\n \n if (status) {\n countQuery += ` AND gi.status = ?`;\n }\n \n const countParams = shared ? [userUuid] : [userUuid];\n if (status) countParams.push(status);\n\n const countStmt = conn.prepare(countQuery);\n const countResult = await countStmt.get(countParams);\n\n return Response.json({\n success: true,\n images: images.rows || images,\n total: countResult?.total || 0,\n limit,\n offset,\n hasMore: (countResult?.total || 0) > offset + limit,\n });\n\n } catch (error) {\n console.error(\"Error getting images:\", error);\n return Response.json(\n { error: error.message || \"Failed to get images\" },\n { status: 500 }\n );\n }\n}",[154],"2541e410-c3d0-11f0-afc8-42dde27851f2","fuf45v145v36t44e2vsft5861v6t30293q.ts","2541e49c-c3d0-11f0-afc8-42dde27851f2",2,["D",1763395919399],"import { z } from \"npm:zod@3\";\n\nconst schema = z.object({\n image_url: z.string().url(\"有効な画像URLが必要です\"),\n watermark_text: z.string().min(1, \"ウォーターマークテキストは必須です\"),\n position: z.enum(['top-left', 'top-right', 'bottom-left', 'bottom-right', 'center']).default('bottom-right'),\n opacity: z.number().min(0).max(100).default(50),\n font_size: z.number().min(12).max(64).default(16)\n});\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const { image_url, watermark_text, position, opacity, font_size } = schema.parse(await req.json());\n\n // Canvas APIを使用してウォーターマークを適用\n const watermarkedImage = await applyWatermarkToImage({\n imageUrl: image_url,\n text: watermark_text,\n position,\n opacity,\n fontSize: font_size\n });\n\n return Response.json({\n success: true,\n watermarked_image_url: watermarkedImage.url,\n metadata: {\n original_image_url: image_url,\n watermark_text,\n position,\n opacity,\n font_size,\n processed_at: new Date().toISOString()\n }\n });\n\n } catch (error) {\n console.error('ウォーターマーク適用エラー:', error);\n return Response.json({\n success: false,\n error: error instanceof Error ? error.message : 'ウォーターマークの適用に失敗しました'\n }, { status: 400 });\n }\n}\n\nasync function applyWatermarkToImage(params: {\n imageUrl: string;\n text: string;\n position: string;\n opacity: number;\n fontSize: number;\n}) {\n // エッジ環境での画像処理は制限があるため、クライアントサイド処理を推奨\n // ここではダミーフィルターを適用した画像URLを返す\n \n const seed = Math.abs(params.text.split('').reduce((a, b) => {\n a = ((a << 5) - a) + b.charCodeAt(0);\n return a & a;\n }, 0));\n \n // 実際のプロジェクトでは、Canvas APIを使用してウォーターマークを適応\n // ここではスタイルに基づいた画像を返す\n const themedImages = [\n `https://picsum.photos/seed/watermark-${seed}/512/512?grayscale`,\n `https://picsum.photos/seed/art-${seed}/512/512?blur=1`,\n `https://picsum.photos/seed/style-${seed}/512/512`\n ];\n \n return {\n url: themedImages[seed % themedImages.length],\n seed: seed,\n processed: true\n };\n}",[161],"25b6f0a2-c6e6-11f0-a03b-42dde27851f2","fu8f19q492288f47qtqt2tvs53455s57v9.ts","25b6f16a-c6e6-11f0-a03b-42dde27851f2",13,["D",1763735222577],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const { imageId } = await req.json();\n \n // ユーザーUUIDの取得\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n }\n\n // データベース接続\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\"),\n });\n\n // 画像の所有権を確認\n const imageStmt = conn.prepare(`\n SELECT _row_id FROM generated_images \n WHERE id = ? AND _created_by = ?\n `);\n const image = await imageStmt.get([imageId, userUuid]);\n \n if (!image) {\n return Response.json({ error: \"Image not found or access denied\" }, { status: 404 });\n }\n\n // 画像を削除（共有設定もCASCADEで削除される）\n const deleteStmt = conn.prepare(`\n DELETE FROM generated_images \n WHERE id = ? AND _created_by = ?\n `);\n \n await deleteStmt.run([imageId, userUuid]);\n\n return Response.json({\n success: true,\n message: \"Image deleted successfully\"\n });\n\n } catch (error) {\n console.error(\"Error deleting image:\", error);\n return Response.json(\n { error: error.message || \"Failed to delete image\" },\n { status: 500 }\n );\n }\n}",[168],"4845c764-c6e7-11f0-b5c5-42dde27851f2",["D",1763735710064],3,[28],"2141a814-c6e6-11f0-8058-42dde27851f2","fu43956918eqvf41tss727qsqv1q09e44v.ts","2141a8d2-c6e6-11f0-8058-42dde27851f2",11,["D",1763735215100],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const { imageId, shareWithUserEmail, permission = 'view' } = await req.json();\n \n // ユーザーUUIDの取得\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n }\n\n // データベース接続\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\"),\n });\n\n // 画像の所有権を確認\n const imageOwnerStmt = conn.prepare(`\n SELECT _created_by FROM generated_images \n WHERE id = ? AND _created_by = ?\n `);\n const imageOwner = await imageOwnerStmt.get([imageId, userUuid]);\n \n if (!imageOwner) {\n return Response.json({ error: \"Image not found or access denied\" }, { status: 404 });\n }\n\n // 共有先ユーザーのUUIDを取得（email→UUID）\n let sharedWithUserUuid = shareWithUserEmail;\n \n // メールアドレスでユーザーを検索する場合\n if (shareWithUserEmail && shareWithUserEmail.includes('@')) {\n const userStmt = conn.prepare(`\n SELECT _row_id FROM users \n WHERE email = ?\n `);\n const user = await userStmt.get([shareWithUserEmail]);\n \n if (!user) {\n return Response.json({ error: \"User not found\" }, { status: 404 });\n }\n sharedWithUserUuid = user._row_id.toString();\n }\n\n // 既存の共有設定をチェック\n const existingShareStmt = conn.prepare(`\n SELECT id FROM image_shares \n WHERE image_id = ? AND shared_with_user = ?\n `);\n const existingShare = await existingShareStmt.get([imageId, sharedWithUserUuid]);\n \n if (existingShare) {\n return Response.json({ error: \"Image already shared with this user\" }, { status: 409 });\n }\n\n // 共有設定を作成\n const shareId = crypto.randomUUID();\n const insertShareStmt = conn.prepare(`\n INSERT INTO image_shares (id, image_id, shared_with_user, permission)\n VALUES (?, ?, ?, ?)\n `);\n \n await insertShareStmt.run([shareId, imageId, sharedWithUserUuid, permission]);\n\n // 共有情報を返す\n const shareInfoStmt = conn.prepare(`\n SELECT ish.*, gi.title, ui.email as shared_with_email\n FROM image_shares ish\n JOIN generated_images gi ON ish.image_id = gi.id\n LEFT JOIN users ui ON ish.shared_with_user = ui._row_id\n WHERE ish.id = ?\n `);\n const shareInfo = await shareInfoStmt.get([shareId]);\n\n return Response.json({\n success: true,\n share: shareInfo,\n message: \"Image shared successfully\"\n });\n\n } catch (error) {\n console.error(\"Error sharing image:\", error);\n return Response.json(\n { error: error.message || \"Failed to share image\" },\n { status: 500 }\n );\n }\n}",[179],"2458c7da-c6e6-11f0-a097-42dde27851f2","fu40t18t4se4sq41f78vfq98s555684s7t.ts","2458c8e8-c6e6-11f0-a097-42dde27851f2",12,["D",1763735220300],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const url = new URL(req.url);\n const category = url.searchParams.get('category') || 'brain_rod';\n const activeOnly = url.searchParams.get('active_only') !== 'false';\n\n // データベース接続\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\"),\n });\n\n let query = `SELECT * FROM prompt_templates WHERE category = ?`;\n const params = [category];\n\n if (activeOnly) {\n query += ` AND is_active = true`;\n }\n\n query += ` ORDER BY name ASC`;\n\n const stmt = conn.prepare(query);\n const templates = await stmt.all(params);\n\n return Response.json({\n success: true,\n templates: templates.rows || templates,\n });\n\n } catch (error) {\n console.error(\"Error getting templates:\", error);\n return Response.json(\n { error: error.message || \"Failed to get templates\" },\n { status: 500 }\n );\n }\n}",[186],"38ded3f2-c3d0-11f0-90d2-42dde27851f2","fu04300sqe238t4e4t9tt008770v2ve6qf.ts",["D",1763395952316],"import { z } from \"npm:zod@3\";\nimport { connect } from \"npm:@tursodatabase/serverless\";\n\nconst schema = z.object({\n title: z.string().optional(),\n prompt: z.string().min(1),\n style: z.string().min(1),\n original_image_url: z.string().url(),\n watermarked_image_url: z.string().url().optional(),\n watermark_text: z.string().optional(),\n watermark_position: z.string().optional(),\n watermark_opacity: z.number().optional(),\n font_size: z.number().optional(),\n share_title: z.string().optional(),\n share_description: z.string().optional(),\n is_public: z.boolean().default(false),\n metadata: z.string().optional()\n});\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({\n success: false,\n error: \"認証が必要です\"\n }, { status: 403 });\n }\n\n const {\n title,\n prompt,\n style,\n original_image_url,\n watermarked_image_url,\n watermark_text,\n watermark_position,\n watermark_opacity,\n font_size,\n share_title,\n share_description,\n is_public,\n metadata\n } = schema.parse(await req.json());\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n const insertStmt = conn.prepare(`\n INSERT INTO generated_images (\n title, prompt, style, original_image_url, watermarked_image_url,\n watermark_text, watermark_position, watermark_opacity, font_size,\n share_title, share_description, is_public, metadata\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `);\n\n const result = await insertStmt.run([\n title || null,\n prompt,\n style,\n original_image_url,\n watermarked_image_url || null,\n watermark_text || null,\n watermark_position || null,\n watermark_opacity || null,\n font_size || null,\n share_title || null,\n share_description || null,\n is_public ? 1 : 0,\n metadata || null\n ]);\n\n if (result.lastInsertRowid) {\n return Response.json({\n success: true,\n image_id: result.lastInsertRowid,\n message: \"画像が正常に保存されました\"\n });\n } else {\n throw new Error(\"画像の保存に失敗しました\");\n }\n\n } catch (error) {\n console.error('画像保存エラー:', error);\n return Response.json({\n success: false,\n error: error instanceof Error ? error.message : '画像の保存に失敗しました'\n }, { status: 400 });\n }\n}",[193],"pulls","branches",1,"forks","envVars",{"_205":62,"_207":62},"connections",{"_205":62,"_206":62},"count","unfilledCount","emptyCount",{"_43":192,"_32":193,"_30":56,"_138":-5,"_41":42,"_40":176,"_140":58,"_38":242,"_13":62,"_33":34,"_35":195,"_24":25,"_144":-5,"_218":243,"_27":244},{"_43":185,"_32":186,"_30":187,"_138":-5,"_41":42,"_40":188,"_140":58,"_38":239,"_13":62,"_33":34,"_35":190,"_24":25,"_144":-5,"_218":240,"_27":241},{"_43":178,"_32":179,"_30":180,"_138":-5,"_41":42,"_40":181,"_140":58,"_38":236,"_13":62,"_33":34,"_35":183,"_24":25,"_144":-5,"_218":237,"_27":238},{"_43":174,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":233,"_13":176,"_33":34,"_35":37,"_24":25,"_144":-5,"_218":234,"_27":235},{"_43":167,"_32":168,"_30":169,"_138":-5,"_41":42,"_40":170,"_140":58,"_38":230,"_13":62,"_33":34,"_35":172,"_24":25,"_144":-5,"_218":231,"_27":232},{"_43":160,"_32":161,"_30":162,"_138":-5,"_41":42,"_40":163,"_140":58,"_38":227,"_13":62,"_33":34,"_35":165,"_24":25,"_144":-5,"_218":228,"_27":229},{"_43":153,"_32":154,"_30":155,"_138":-5,"_41":42,"_40":156,"_140":58,"_38":224,"_13":62,"_33":34,"_35":158,"_24":25,"_144":-5,"_218":225,"_27":226},{"_43":146,"_32":147,"_30":148,"_138":-5,"_41":42,"_40":149,"_140":58,"_38":221,"_13":62,"_33":34,"_35":151,"_24":25,"_144":-5,"_218":222,"_27":223},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":58,"_38":217,"_13":142,"_33":34,"_35":143,"_24":25,"_144":-5,"_218":219,"_27":220},["D",1763396701080],"children",[],[136],["D",1763398394491],[],[147],["D",1763735207419],[],[154],["D",1763395919399],[],[161],["D",1763735222577],[],[168],["D",1763735710064],[],[28],["D",1763735215100],[],[179],["D",1763735220300],[],[186],["D",1763395952316],[],[193],["D",1763395904717],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":282,"_283":284,"_285":286,"_287":25,"_288":25,"_289":25,"_290":58,"_291":-5,"_292":-7,"_293":-7,"_294":62,"_295":25,"_296":25,"_297":-5,"_298":25,"_299":25,"_300":25,"_301":-5},"ENV",{"_253":254,"_255":256,"_257":86,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v16