[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_247":248,"_249":250},"routes/_app.x.$handle.$name",{"_94":93,"_31":43,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":56,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","fu8f19q492288f47qtqt2tvs53455s57v9.ts","latestPath","fileId","25b6f16a-c6e6-11f0-a03b-42dde27851f2","name","fileType","http","content","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}","createdAt",["D",1763735222577],"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",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"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",{"_41":42,"_31":43,"_36":243,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":244,"_78":245,"_80":246,"_82":24},"tree",[206,207,208,209,210,211,212,213,214],"files",[206,207,208,209,210,211,212,213,214],"counts",{"_195":60,"_196":197,"_198":60,"_199":200,"_201":202},"contents",[124,125,126,127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":189,"_31":190,"_29":54,"_136":-5,"_39":40,"_38":191,"_138":56,"_36":192,"_13":60,"_32":33,"_34":193,"_23":24,"_142":-5,"_26":194},{"_41":182,"_31":183,"_29":184,"_136":-5,"_39":40,"_38":185,"_138":56,"_36":186,"_13":60,"_32":33,"_34":187,"_23":24,"_142":-5,"_26":188},{"_41":175,"_31":176,"_29":177,"_136":-5,"_39":40,"_38":178,"_138":56,"_36":179,"_13":60,"_32":33,"_34":180,"_23":24,"_142":-5,"_26":181},{"_41":168,"_31":169,"_29":170,"_136":-5,"_39":40,"_38":171,"_138":24,"_36":172,"_13":60,"_32":33,"_34":173,"_23":24,"_142":-5,"_26":174},{"_41":165,"_31":27,"_29":30,"_136":-5,"_39":40,"_38":14,"_138":56,"_36":166,"_13":60,"_32":33,"_34":35,"_23":24,"_142":-5,"_26":167},{"_41":158,"_31":159,"_29":160,"_136":-5,"_39":40,"_38":161,"_138":56,"_36":162,"_13":60,"_32":33,"_34":163,"_23":24,"_142":-5,"_26":164},{"_41":151,"_31":152,"_29":153,"_136":-5,"_39":40,"_38":154,"_138":56,"_36":155,"_13":60,"_32":33,"_34":156,"_23":24,"_142":-5,"_26":157},{"_41":144,"_31":145,"_29":146,"_136":-5,"_39":40,"_38":147,"_138":56,"_36":148,"_13":60,"_32":33,"_34":149,"_23":24,"_142":-5,"_26":150},{"_41":133,"_31":134,"_29":135,"_136":-5,"_39":40,"_38":137,"_138":56,"_36":139,"_13":140,"_32":33,"_34":141,"_23":24,"_142":-5,"_26":143},"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",[134],"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}",[145],"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}",[152],"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}",[159],"25b6f0a2-c6e6-11f0-a03b-42dde27851f2",["D",1763735222577],[27],"154a2856-c6e6-11f0-9988-42dde27851f2","fu8625q8645q7f4sf0993q196f03ts1312.ts","154a291e-c6e6-11f0-9988-42dde27851f2",9,["D",1763735195037],"import { connect } from \"npm:@tursodatabase/serverless\";\n\n// OpenAI DALL-E 3 API呼び出し関数\nasync function generateImageWithOpenAI(prompt, apiKey) {\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 error = await response.text();\n throw new Error(`OpenAI API error: ${error}`);\n }\n\n const data = await response.json();\n return data.data[0];\n}\n\n// ウォーターマーク適用関数\nasync function applyWatermark(imageUrl, watermarkText = \"Brain Rod AI\") {\n const response = await fetch(`${imageUrl}?width=800&watermark=${encodeURIComponent(watermarkText)}`);\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 const { title, subject, customPrompt, styleTemplate, quality = \"standard\", watermark = true } = await req.json();\n \n const apiKey = __secrets['OPENAI_API_KEY'];\n if (!apiKey) {\n return Response.json({ error: \"OpenAI API key not configured\" }, { status: 500 });\n }\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 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`;\n }\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)\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() })\n ]);\n\n // OpenAIで画像生成\n const imageData = await generateImageWithOpenAI(finalPrompt, apiKey);\n console.log(\"Image generated successfully:\", imageData);\n\n // 生成された画像情報でレコードを更新\n const updateStmt = conn.prepare(`\n UPDATE generated_images \n SET image_url = ?, thumbnail_url = ?, status = 'completed', metadata = ?\n WHERE id = ?\n `);\n \n const metadata = JSON.stringify({\n generationStarted: Date.now(),\n completed: true,\n originalPrompt: finalPrompt,\n openaiData: imageData\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 imageId\n ]);\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 });\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 = ?\n WHERE id = ?\n `);\n \n // imageIDがリクエストに含まれている場合\n const body = await req.json();\n if (body.imageId) {\n await errorUpdateStmt.run([error.message, body.imageId]);\n }\n } catch (dbError) {\n console.error(\"Failed to update error status:\", dbError);\n }\n\n return Response.json(\n { error: error.message || \"Failed to generate image\" },\n { status: 500 }\n );\n }\n}",[169],"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}",[176],"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}",[183],"38ded3f2-c3d0-11f0-90d2-42dde27851f2","fu04300sqe238t4e4t9tt008770v2ve6qf.ts",3,["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}",[190],"pulls","branches",1,"forks","envVars",{"_203":60,"_205":60},"connections",{"_203":60,"_204":60},"count","unfilledCount","emptyCount",{"_41":189,"_31":190,"_29":54,"_136":-5,"_39":40,"_38":191,"_138":56,"_36":240,"_13":60,"_32":33,"_34":193,"_23":24,"_142":-5,"_216":241,"_26":242},{"_41":182,"_31":183,"_29":184,"_136":-5,"_39":40,"_38":185,"_138":56,"_36":237,"_13":60,"_32":33,"_34":187,"_23":24,"_142":-5,"_216":238,"_26":239},{"_41":175,"_31":176,"_29":177,"_136":-5,"_39":40,"_38":178,"_138":56,"_36":234,"_13":60,"_32":33,"_34":180,"_23":24,"_142":-5,"_216":235,"_26":236},{"_41":168,"_31":169,"_29":170,"_136":-5,"_39":40,"_38":171,"_138":24,"_36":231,"_13":60,"_32":33,"_34":173,"_23":24,"_142":-5,"_216":232,"_26":233},{"_41":165,"_31":27,"_29":30,"_136":-5,"_39":40,"_38":14,"_138":56,"_36":228,"_13":60,"_32":33,"_34":35,"_23":24,"_142":-5,"_216":229,"_26":230},{"_41":158,"_31":159,"_29":160,"_136":-5,"_39":40,"_38":161,"_138":56,"_36":225,"_13":60,"_32":33,"_34":163,"_23":24,"_142":-5,"_216":226,"_26":227},{"_41":151,"_31":152,"_29":153,"_136":-5,"_39":40,"_38":154,"_138":56,"_36":222,"_13":60,"_32":33,"_34":156,"_23":24,"_142":-5,"_216":223,"_26":224},{"_41":144,"_31":145,"_29":146,"_136":-5,"_39":40,"_38":147,"_138":56,"_36":219,"_13":60,"_32":33,"_34":149,"_23":24,"_142":-5,"_216":220,"_26":221},{"_41":133,"_31":134,"_29":135,"_136":-5,"_39":40,"_38":137,"_138":56,"_36":215,"_13":140,"_32":33,"_34":141,"_23":24,"_142":-5,"_216":217,"_26":218},["D",1763396701080],"children",[],[134],["D",1763398394491],[],[145],["D",1763735207419],[],[152],["D",1763395919399],[],[159],["D",1763735222577],[],[27],["D",1763735195037],[],[169],["D",1763735215100],[],[176],["D",1763735220300],[],[183],["D",1763395952316],[],[190],["D",1763395904717],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"ctx",{"_76":-5,"_121":280,"_281":282,"_283":284,"_285":24,"_286":24,"_287":24,"_288":56,"_289":-5,"_290":-7,"_291":-7,"_292":60,"_293":24,"_294":24,"_295":-5,"_296":24,"_297":24,"_298":24,"_299":-5},"ENV",{"_251":252,"_253":254,"_255":84,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279},"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 · v13