[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_328":329,"_330":331},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_38":-7,"_119":-5,"_19":120,"_121":122,"_123":124,"_125":126,"_127":128,"_21":129,"_130":-5,"_131":-5,"_132":24,"_133":134,"_135":82,"_136":-5,"_137":-5,"_138":139},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","heybunny","name","prompthero","branchName","main","path","frontend/index.html","project",{"_32":70,"_13":14,"_36":71,"_72":-5,"_73":24,"_74":75,"_76":75,"_77":-5,"_78":-5,"_30":66,"_79":80,"_81":82,"_83":82,"_84":-5,"_85":26,"_40":41,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":91,"_92":91,"_93":94,"_95":94,"_96":94,"_97":91,"_98":91,"_51":99,"_100":101,"_102":103,"_104":24},"file",{"_61":62,"_13":63,"_64":21,"_65":24,"_69":-5},"isDirectory",false,"page",0,"history",[31],"hasNext","userId",{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_21":53,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":59},"id","3ec72512-3622-11f0-9c3d-9e149126039e","branchId","ea2e4fd0-3621-11f0-8199-9e149126039e","createdAt",["D",1747818115837],"version",8,"orgId","bb1cf631-e7f7-4437-af7c-3a9e70eace24","parentId","37a94788-3622-11f0-b0d2-9e149126039e","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_32":66,"_40":41,"_11":12,"_67":68},{"_61":62,"_13":63,"_64":21,"_65":24},"pull","merge","revert","multiple","commits",[60],{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_21":53,"_54":-5,"_55":-5,"_56":-5},"fileId","3ec5dacc-3622-11f0-9c3d-9e149126039e","index.html","fileType","deleted","5d684f12-ce21-4331-a69d-3fc32ac8bcbe","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJwUzFTUTJKNzg0Z1VFN0NadVo4UGswaUxUVyJ9","deletedAtVersion","ea2e18da-3621-11f0-8199-9e149126039e",["D",1747817973918],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","pinnedFileId","0f62de88-3622-11f0-8d34-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_118":68},"org",{"_11":12,"_114":-5,"_67":68,"_30":66,"_115":116,"_117":24},"branch",{"_38":105,"_13":16,"_32":35,"_106":70,"_107":-5,"_108":-5,"_109":-5,"_110":-5,"_111":-5,"_112":14,"_113":12},"isOwned",16,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_32":70,"_13":14,"_36":324,"_72":-5,"_73":24,"_74":75,"_76":75,"_77":-5,"_78":-5,"_30":66,"_79":80,"_81":82,"_83":82,"_84":-5,"_85":26,"_40":41,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":91,"_92":91,"_93":94,"_95":94,"_96":94,"_97":91,"_98":91,"_51":325,"_100":326,"_102":327,"_104":24},"tree",[161,169,178,180],"files",[161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180],"counts",{"_150":26,"_151":152,"_153":26,"_154":155,"_156":157},"contents",[],{"_32":140,"_13":63,"_61":62,"_42":141,"_34":35,"_142":39,"_143":82,"_36":144,"_38":26,"_64":21,"_145":146,"_65":24,"_147":-5,"_17":148},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"3ec5d9fa-3622-11f0-9c3d-9e149126039e","af9e04b3-cf61-4cfe-864f-c1b17a837aad","branchVersion","latest",["D",1747818115837],"content","\n\n\n \n \n PromptCraft - GPT-Powered Prompt Creation & Optimization\n \n \n \n \n \n \n \n \n \n ✨\">\n \n \n\n\n

\n \n \n \n \n \n

\n View Source\n

\n\n","label",[149,63],"frontend","pulls","branches",1,"forks","envVars",{"_158":26,"_160":26},"connections",{"_158":26,"_159":26},"count","unfilledCount","emptyCount",{"_32":320,"_13":275,"_61":268,"_42":-5,"_34":35,"_142":270,"_143":82,"_36":321,"_38":26,"_64":202,"_145":-5,"_65":24,"_147":-5,"_186":322,"_17":323},{"_32":316,"_13":307,"_61":301,"_42":268,"_34":35,"_142":311,"_143":82,"_36":317,"_38":26,"_64":202,"_145":-5,"_65":24,"_147":-5,"_186":318,"_17":319},{"_32":308,"_13":309,"_61":310,"_42":301,"_34":35,"_142":311,"_143":82,"_36":312,"_38":26,"_64":195,"_145":313,"_65":24,"_147":-5,"_186":314,"_17":315},{"_32":298,"_13":299,"_61":300,"_42":301,"_34":35,"_142":302,"_143":82,"_36":303,"_38":26,"_64":195,"_145":304,"_65":24,"_147":-5,"_186":305,"_17":306},{"_32":294,"_13":285,"_61":279,"_42":268,"_34":35,"_142":280,"_143":82,"_36":295,"_38":26,"_64":202,"_145":-5,"_65":24,"_147":-5,"_186":296,"_17":297},{"_32":286,"_13":287,"_61":288,"_42":279,"_34":35,"_142":289,"_143":82,"_36":290,"_38":26,"_64":195,"_145":291,"_65":24,"_147":-5,"_186":292,"_17":293},{"_32":276,"_13":277,"_61":278,"_42":279,"_34":35,"_142":280,"_143":82,"_36":281,"_38":26,"_64":195,"_145":282,"_65":24,"_147":-5,"_186":283,"_17":284},{"_32":266,"_13":267,"_61":80,"_42":268,"_34":35,"_142":105,"_143":82,"_36":269,"_38":270,"_64":271,"_145":272,"_65":24,"_147":-5,"_186":273,"_17":274},{"_32":262,"_13":149,"_61":141,"_42":-5,"_34":35,"_142":39,"_143":82,"_36":263,"_38":26,"_64":202,"_145":-5,"_65":24,"_147":-5,"_186":264,"_17":265},{"_32":258,"_13":225,"_61":219,"_42":141,"_34":35,"_142":253,"_143":82,"_36":259,"_38":26,"_64":202,"_145":-5,"_65":24,"_147":-5,"_186":260,"_17":261},{"_32":250,"_13":251,"_61":252,"_42":219,"_34":35,"_142":253,"_143":82,"_36":254,"_38":26,"_64":195,"_145":255,"_65":24,"_147":-5,"_186":256,"_17":257},{"_32":242,"_13":243,"_61":244,"_42":219,"_34":35,"_142":245,"_143":82,"_36":246,"_38":26,"_64":195,"_145":247,"_65":24,"_147":-5,"_186":248,"_17":249},{"_32":234,"_13":235,"_61":236,"_42":219,"_34":35,"_142":237,"_143":82,"_36":238,"_38":26,"_64":195,"_145":239,"_65":24,"_147":-5,"_186":240,"_17":241},{"_32":226,"_13":227,"_61":228,"_42":219,"_34":35,"_142":229,"_143":82,"_36":230,"_38":26,"_64":195,"_145":231,"_65":24,"_147":-5,"_186":232,"_17":233},{"_32":216,"_13":217,"_61":218,"_42":219,"_34":35,"_142":220,"_143":82,"_36":221,"_38":26,"_64":195,"_145":222,"_65":24,"_147":-5,"_186":223,"_17":224},{"_32":140,"_13":63,"_61":62,"_42":141,"_34":35,"_142":39,"_143":82,"_36":213,"_38":26,"_64":21,"_145":146,"_65":24,"_147":-5,"_186":214,"_17":215},{"_32":205,"_13":206,"_61":207,"_42":141,"_34":35,"_142":208,"_143":82,"_36":209,"_38":26,"_64":195,"_145":210,"_65":24,"_147":-5,"_186":211,"_17":212},{"_32":200,"_13":199,"_61":192,"_42":-5,"_34":35,"_142":193,"_143":82,"_36":201,"_38":26,"_64":202,"_145":-5,"_65":24,"_147":-5,"_186":203,"_17":204},{"_32":189,"_13":190,"_61":191,"_42":192,"_34":35,"_142":193,"_143":82,"_36":194,"_38":26,"_64":195,"_145":196,"_65":24,"_147":-5,"_186":197,"_17":198},{"_32":181,"_13":182,"_61":183,"_42":-5,"_34":35,"_142":152,"_143":82,"_36":184,"_38":26,"_64":21,"_145":185,"_65":24,"_147":-5,"_186":187,"_17":188},"095e8c1c-3622-11f0-b1e3-9e149126039e","README.md","095e8cee-3622-11f0-b1e3-9e149126039e",["D",1747818026240],"# PromptCraft - GPT-Powered Prompt Creation & Optimization\n\nPromptCraft is a full-stack application that helps you create, test, and optimize prompts for GPT models. With a modern, responsive UI and powerful backend, you can iterate on your prompts to achieve the best results.\n\n## Features\n\n- 🧠 **AI-Powered Suggestions**: Get intelligent suggestions to improve your prompts\n- 🔄 **A/B Testing**: Compare different prompt versions to see which performs better\n- 📊 **Performance Analytics**: Track how your prompts perform over time\n- 💾 **Prompt Library**: Save and organize your prompts for future use\n- 🚀 **Optimization Recommendations**: Receive specific recommendations to enhance prompt effectiveness\n\n## Tech Stack\n\n- **Frontend**: React with Tailwind CSS\n- **Backend**: Hono.js API framework\n- **Database**: SQLite for storing prompts and history\n- **AI**: OpenAI GPT models\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts\n│ │ └── queries.ts\n│ ├── routes/\n│ │ ├── prompts.ts\n│ │ ├── optimize.ts\n│ │ └── static.ts\n│ └── index.ts\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ ├── PromptEditor.tsx\n│ │ ├── OptimizationPanel.tsx\n│ │ ├── ResultsViewer.tsx\n│ │ └── Navigation.tsx\n│ ├── index.html\n│ └── index.tsx\n└── shared/\n └── types.ts\n```\n\n## Getting Started\n\n1. Visit the app at its Val Town URL\n2. Create your first prompt in the editor\n3. Use the optimization tools to refine your prompt\n4. Save your best prompts to your library\n\n## How It Works\n\n1. **Create**: Write your initial prompt in the editor\n2. **Test**: See how the prompt performs with the GPT model\n3. **Optimize**: Get AI-powered suggestions to improve your prompt\n4. **Compare**: A/B test different versions to find the best one\n5. **Save**: Store your optimized prompts for future use","children",[],[182],"37a7e302-3622-11f0-b0d2-9e149126039e","types.ts","37a7e3b6-3622-11f0-b0d2-9e149126039e","4514f91e-5ee7-4ea6-b1e5-4f530db3192f",7,["D",1747818103897],"script","// Prompt types\nexport interface Prompt {\n id: number;\n title: string;\n description: string | null;\n created_at: number;\n updated_at: number;\n}\n\nexport interface PromptVersion {\n id: number;\n prompt_id: number;\n content: string;\n version_number: number;\n is_current: boolean;\n created_at: number;\n}\n\nexport interface PromptResult {\n id: number;\n version_id: number;\n response: string;\n rating: number | null;\n feedback: string | null;\n created_at: number;\n}\n\nexport interface PromptWithVersions extends Prompt {\n versions: PromptVersion[];\n}\n\nexport interface VersionWithResults extends PromptVersion {\n results: PromptResult[];\n}\n\n// API response types\nexport interface ApiResponse {\n success: boolean;\n error?: string;\n data?: T;\n}\n\nexport interface TestResponse {\n response: string;\n usage: {\n prompt_tokens: number;\n completion_tokens: number;\n total_tokens: number;\n };\n}\n\nexport interface SuggestionsResponse {\n suggestions: string;\n usage: {\n prompt_tokens: number;\n completion_tokens: number;\n total_tokens: number;\n };\n}\n\nexport interface ComparisonResponse {\n comparison: string;\n usage: {\n prompt_tokens: number;\n completion_tokens: number;\n total_tokens: number;\n };\n}",[],[199,190],"shared","37a7e9a6-3622-11f0-b0d2-9e149126039e",["D",1747818103897],"directory",[179],[199],"4206da7e-3622-11f0-a8d0-9e149126039e","index.tsx","4206db6e-3622-11f0-a8d0-9e149126039e",9,["D",1747818121298],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from 'https://esm.sh/react@18.2.0';\nimport ReactDOM from 'https://esm.sh/react-dom@18.2.0/client';\nimport App from './components/App.tsx';\n\n// Get initial data injected by the server\ndeclare global {\n interface Window {\n __INITIAL_DATA__: {\n appName: string;\n version: string;\n };\n }\n}\n\nconst initialData = window.__INITIAL_DATA__ || {\n appName: 'PromptCraft',\n version: '1.0.0'\n};\n\n// Create root and render app\nconst rootElement = document.getElementById('root');\nif (rootElement) {\n const root = ReactDOM.createRoot(rootElement);\n root.render(\n \n \n \n );\n}",[],[149,206],["D",1747818115837],[],[149,63],"a5429c68-3622-11f0-8c9a-9e149126039e","ResultsViewer.tsx","a5429d3a-3622-11f0-8c9a-9e149126039e","3e53a33b-bd9e-45a7-980d-4db0e3f61c60",14,["D",1747818287784],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport { PromptWithVersions, VersionWithResults } from '../../shared/types.ts';\n\ninterface ResultsViewerProps {\n prompt: PromptWithVersions;\n}\n\nconst ResultsViewer: React.FC = ({ prompt }) => {\n const [selectedVersionId, setSelectedVersionId] = useState(null);\n const [versionDetails, setVersionDetails] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n const [feedback, setFeedback] = useState('');\n const [rating, setRating] = useState(null);\n const [selectedResultId, setSelectedResultId] = useState(null);\n\n // Set selected version when prompt changes\n useEffect(() => {\n if (prompt && prompt.versions.length > 0) {\n const currentVersion = prompt.versions.find(v => v.is_current) || prompt.versions[0];\n setSelectedVersionId(currentVersion.id);\n fetchVersionDetails(currentVersion.id);\n }\n }, [prompt]);\n\n const fetchVersionDetails = async (versionId: number) => {\n setIsLoading(true);\n \n try {\n const response = await fetch(`/api/prompts/versions/${versionId}`);\n const data = await response.json();\n \n if (data.success) {\n setVersionDetails(data.version);\n } else {\n console.error('Error fetching version details:', data.error);\n }\n } catch (error) {\n console.error('Error fetching version details:', error);\n } finally {\n setIsLoading(false);\n }\n };\n\n const handleVersionSelect = (versionId: number) => {\n setSelectedVersionId(versionId);\n fetchVersionDetails(versionId);\n };\n\n const handleSaveFeedback = async () => {\n if (!selectedResultId) return;\n \n try {\n setIsLoading(true);\n \n const response = await fetch(`/api/prompts/versions/${selectedVersionId}/results`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({\n response: versionDetails?.results.find(r => r.id === selectedResultId)?.response || '',\n rating,\n feedback\n }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n // Refresh version details\n fetchVersionDetails(selectedVersionId!);\n // Reset form\n setFeedback('');\n setRating(null);\n setSelectedResultId(null);\n }\n } catch (error) {\n console.error('Error saving feedback:', error);\n } finally {\n setIsLoading(false);\n }\n };\n\n const formatDate = (timestamp: number) => {\n return new Date(timestamp).toLocaleDateString('en-US', {\n month: 'short',\n day: 'numeric',\n year: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n return (\n

Results & Analytics

\n View and analyze results from your prompt versions\n

\n\n {/* Version selector */}\n

\n \n Select Version\n \n

\n {prompt.versions.map(version => (\n handleVersionSelect(version.id)}\n className={`px-3 py-1 text-sm rounded-full ${\n selectedVersionId === version.id\n ? 'bg-indigo-100 text-indigo-700 border border-indigo-300'\n : 'bg-gray-100 text-gray-700 border border-gray-200 hover:bg-gray-200'\n }`}\n >\n v{version.version_number}\n {version.is_current && ' (current)'}\n \n ))}\n

\n\n {isLoading ? (\n

\n ) : (\n <>\n {/* Version content */}\n {versionDetails && (\n

\n \n Prompt Content\n \n

\n {versionDetails.content}\n

\n )}\n\n {/* Results */}\n

\n Results ({versionDetails?.results.length || 0})\n

\n \n {versionDetails?.results.length === 0 ? (\n

\n No results yet. Test your prompt to see responses here.\n

\n ) : (\n

\n {versionDetails?.results.map(result => (\n

\n {formatDate(result.created_at)}\n

\n {result.rating && (\n

\n {[...Array(5)].map((_, i) => (\n \n ))}\n

\n )}\n setSelectedResultId(selectedResultId === result.id ? null : result.id)}\n className=\"text-xs text-indigo-600 hover:text-indigo-800\"\n >\n {selectedResultId === result.id ? 'Cancel' : 'Add Feedback'}\n \n

\n {result.response}\n

\n {result.feedback && (\n

Feedback:

{result.feedback}

\n )}\n \n {/* Feedback form */}\n {selectedResultId === result.id && (\n

\n \n Rating\n \n

\n {[1, 2, 3, 4, 5].map(star => (\n setRating(star)}\n className=\"focus:outline-none\"\n >\n \n \n ))}\n

\n \n Feedback\n \n setFeedback(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 text-sm\"\n placeholder=\"What worked well or could be improved?\"\n rows={3}\n >\n

\n \n Save Feedback\n \n

\n )}\n

\n ))}\n

\n )}\n

\n \n )}\n

\n );\n};\n\nexport default ResultsViewer;",[],[149,225,217],"components","751cb686-3622-11f0-9f16-9e149126039e","PromptEditor.tsx","751cb712-3622-11f0-9f16-9e149126039e",12,["D",1747818207005],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport { PromptWithVersions } from '../../shared/types.ts';\n\ninterface PromptEditorProps {\n prompt: PromptWithVersions | null;\n onSaveVersion: (promptId: number, content: string) => void;\n onCreatePrompt: (title: string, description: string, content: string) => void;\n}\n\nconst PromptEditor: React.FC = ({ \n prompt, \n onSaveVersion,\n onCreatePrompt\n}) => {\n const [content, setContent] = useState('');\n const [selectedVersionId, setSelectedVersionId] = useState(null);\n const [testResponse, setTestResponse] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n const [tokenCount, setTokenCount] = useState(null);\n\n // Update content when prompt or selected version changes\n useEffect(() => {\n if (prompt && prompt.versions.length > 0) {\n // Find current version\n const currentVersion = prompt.versions.find(v => v.is_current) || prompt.versions[0];\n setContent(currentVersion.content);\n setSelectedVersionId(currentVersion.id);\n } else {\n setContent('');\n setSelectedVersionId(null);\n }\n }, [prompt]);\n\n const handleVersionSelect = (versionId: number) => {\n if (!prompt) return;\n \n const version = prompt.versions.find(v => v.id === versionId);\n if (version) {\n setContent(version.content);\n setSelectedVersionId(version.id);\n }\n };\n\n const handleSaveVersion = () => {\n if (!prompt || !content.trim()) return;\n onSaveVersion(prompt.id, content);\n };\n\n const handleTestPrompt = async () => {\n if (!content.trim()) return;\n \n setIsLoading(true);\n setTestResponse(null);\n \n try {\n const response = await fetch('/api/optimize/test', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ prompt: content }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n setTestResponse(data.response);\n setTokenCount(data.usage.total_tokens);\n \n // Save the result if we have a selected version\n if (prompt && selectedVersionId) {\n await fetch(`/api/prompts/versions/${selectedVersionId}/results`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ response: data.response }),\n });\n }\n } else {\n setTestResponse(`Error: ${data.error}`);\n }\n } catch (error) {\n console.error('Error testing prompt:', error);\n setTestResponse('Error: Failed to test prompt');\n } finally {\n setIsLoading(false);\n }\n };\n\n const formatDate = (timestamp: number) => {\n return new Date(timestamp).toLocaleDateString('en-US', {\n month: 'short',\n day: 'numeric',\n year: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n if (!prompt) {\n return (\n

\n \n

No Prompt Selected

\n Create a new prompt using the button in the sidebar or select an existing prompt to get started.\n

\n );\n }\n\n return (\n

\n {/* Prompt header */}\n

{prompt.title}

\n {prompt.description && (\n

{prompt.description}

\n )}\n

\n\n {/* Version selector */}\n {prompt.versions.length > 1 && (\n

\n \n Version\n \n

\n )}\n\n {/* Editor */}\n

\n \n Prompt Content\n \n setContent(e.target.value)}\n className=\"flex-1 w-full px-4 py-3 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500 font-mono text-sm\"\n placeholder=\"Enter your prompt here...\"\n >\n

\n\n {/* Actions */}\n

\n \n Save as New Version\n \n

\n \n {isLoading ? (\n <>\n \n Testing...\n \n ) : (\n 'Test Prompt'\n )}\n \n

\n\n {/* Test response */}\n {testResponse && (\n

Response

\n {tokenCount && (\n \n {tokenCount} tokens\n \n )}\n

\n {testResponse}\n

\n )}\n

\n );\n};\n\nexport default PromptEditor;",[],[149,225,227],"8c623adc-3622-11f0-a6ec-9e149126039e","OptimizationPanel.tsx","8c623b9a-3622-11f0-a6ec-9e149126039e",13,["D",1747818246046],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport { PromptWithVersions } from '../../shared/types.ts';\n\ninterface OptimizationPanelProps {\n prompt: PromptWithVersions;\n onSaveVersion: (promptId: number, content: string) => void;\n}\n\nconst OptimizationPanel: React.FC = ({ \n prompt, \n onSaveVersion \n}) => {\n const [currentContent, setCurrentContent] = useState('');\n const [goal, setGoal] = useState('');\n const [suggestions, setSuggestions] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n const [compareMode, setCompareMode] = useState(false);\n const [promptA, setPromptA] = useState('');\n const [promptB, setPromptB] = useState('');\n const [comparison, setComparison] = useState(null);\n const [criteria, setCriteria] = useState('');\n\n // Set current content when prompt changes\n useEffect(() => {\n if (prompt && prompt.versions.length > 0) {\n const currentVersion = prompt.versions.find(v => v.is_current) || prompt.versions[0];\n setCurrentContent(currentVersion.content);\n setPromptA(currentVersion.content);\n }\n }, [prompt]);\n\n const handleGetSuggestions = async () => {\n setIsLoading(true);\n setSuggestions(null);\n \n try {\n const response = await fetch('/api/optimize/suggestions', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ \n prompt: currentContent,\n goal: goal || undefined\n }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n setSuggestions(data.suggestions);\n } else {\n setSuggestions(`Error: ${data.error}`);\n }\n } catch (error) {\n console.error('Error getting suggestions:', error);\n setSuggestions('Error: Failed to get suggestions');\n } finally {\n setIsLoading(false);\n }\n };\n\n const handleComparePrompts = async () => {\n if (!promptA.trim() || !promptB.trim()) return;\n \n setIsLoading(true);\n setComparison(null);\n \n try {\n const response = await fetch('/api/optimize/compare', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ \n promptA,\n promptB,\n criteria: criteria || undefined\n }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n setComparison(data.comparison);\n } else {\n setComparison(`Error: ${data.error}`);\n }\n } catch (error) {\n console.error('Error comparing prompts:', error);\n setComparison('Error: Failed to compare prompts');\n } finally {\n setIsLoading(false);\n }\n };\n\n const handleSaveVersion = (content: string) => {\n if (!content.trim()) return;\n onSaveVersion(prompt.id, content);\n };\n\n return (\n

\n {compareMode ? 'Compare Prompts' : 'Optimize Prompt'}\n

\n setCompareMode(!compareMode)}\n className=\"text-indigo-600 hover:text-indigo-800 text-sm font-medium\"\n >\n Switch to {compareMode ? 'Optimization' : 'Comparison'} Mode\n \n

\n\n {!compareMode ? (\n // Optimization Mode\n <>\n

\n \n Optimization Goal (optional)\n \n setGoal(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500\"\n placeholder=\"e.g., 'Make the prompt more concise' or 'Improve clarity'\"\n />\n

\n\n

\n \n Current Prompt\n \n setCurrentContent(e.target.value)}\n className=\"w-full h-48 px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 font-mono text-sm\"\n placeholder=\"Enter your prompt here...\"\n >\n

\n\n

\n \n {isLoading ? (\n <>\n \n Generating Suggestions...\n \n ) : (\n 'Get Optimization Suggestions'\n )}\n \n

\n\n {suggestions && (\n

Suggestions

\n {suggestions}\n

\n \n

\n handleSaveVersion(currentContent)}\n className=\"bg-green-600 hover:bg-green-700 text-white px-4 py-2 rounded-md text-sm font-medium\"\n >\n Save Current Version\n \n

\n )}\n \n ) : (\n // Comparison Mode\n <>\n

\n \n Comparison Criteria (optional)\n \n setCriteria(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500\"\n placeholder=\"e.g., 'Clarity, specificity, and conciseness'\"\n />\n

\n\n

\n \n Prompt A\n \n setPromptA(e.target.value)}\n className=\"w-full h-48 px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 font-mono text-sm\"\n placeholder=\"Enter first prompt here...\"\n >\n

\n \n Prompt B\n \n setPromptB(e.target.value)}\n className=\"w-full h-48 px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 font-mono text-sm\"\n placeholder=\"Enter second prompt here...\"\n >\n

\n\n

\n \n {isLoading ? (\n <>\n \n Comparing Prompts...\n \n ) : (\n 'Compare Prompts'\n )}\n \n

\n\n {comparison && (\n

Comparison Results

\n {comparison}\n

\n \n

\n handleSaveVersion(promptA)}\n className=\"bg-blue-600 hover:bg-blue-700 text-white px-4 py-2 rounded-md text-sm font-medium\"\n >\n Save Prompt A\n \n handleSaveVersion(promptB)}\n className=\"bg-green-600 hover:bg-green-700 text-white px-4 py-2 rounded-md text-sm font-medium\"\n >\n Save Prompt B\n \n

\n )}\n \n )}\n

\n );\n};\n\nexport default OptimizationPanel;",[],[149,225,235],"61645d4c-3622-11f0-888e-9e149126039e","Navigation.tsx","61645e14-3622-11f0-888e-9e149126039e",11,["D",1747818173921],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from 'https://esm.sh/react@18.2.0';\nimport { Prompt } from '../../shared/types.ts';\n\ninterface NavigationProps {\n prompts: Prompt[];\n currentPromptId?: number;\n onSelectPrompt: (promptId: number) => void;\n onCreatePrompt: (title: string, description: string, content: string) => void;\n}\n\nconst Navigation: React.FC = ({ \n prompts, \n currentPromptId, \n onSelectPrompt,\n onCreatePrompt\n}) => {\n const [isCreateModalOpen, setIsCreateModalOpen] = useState(false);\n const [newPromptTitle, setNewPromptTitle] = useState('');\n const [newPromptDescription, setNewPromptDescription] = useState('');\n const [newPromptContent, setNewPromptContent] = useState('');\n\n const handleCreatePrompt = () => {\n if (newPromptTitle.trim() && newPromptContent.trim()) {\n onCreatePrompt(newPromptTitle, newPromptDescription, newPromptContent);\n setNewPromptTitle('');\n setNewPromptDescription('');\n setNewPromptContent('');\n setIsCreateModalOpen(false);\n }\n };\n\n const formatDate = (timestamp: number) => {\n return new Date(timestamp).toLocaleDateString('en-US', {\n month: 'short',\n day: 'numeric',\n year: 'numeric'\n });\n };\n\n return (\n

\n setIsCreateModalOpen(true)}\n className=\"w-full bg-indigo-600 hover:bg-indigo-700 text-white font-medium py-2 px-4 rounded-md flex items-center justify-center\"\n >\n \n New Prompt\n \n

\n\n

\n Your Prompts\n

\n\n

\n {prompts.length === 0 ? (\n

\n No prompts yet. Create your first one!\n

\n ) : (\n prompts.map(prompt => (\n onSelectPrompt(prompt.id)}\n className={`w-full text-left px-3 py-2 rounded-md text-sm font-medium ${\n currentPromptId === prompt.id\n ? 'bg-indigo-100 text-indigo-700'\n : 'text-gray-700 hover:bg-gray-100'\n }`}\n >\n

{prompt.title}

\n {formatDate(prompt.updated_at)}\n

\n \n ))\n )}\n

\n\n {/* Create Prompt Modal */}\n {isCreateModalOpen && (\n

Create New Prompt

\n \n

\n \n Title *\n \n setNewPromptTitle(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500\"\n placeholder=\"Enter a title for your prompt\"\n />\n

\n \n

\n \n Description\n \n setNewPromptDescription(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500\"\n placeholder=\"Optional description\"\n />\n

\n \n

\n \n Prompt Content *\n \n setNewPromptContent(e.target.value)}\n rows={6}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500\"\n placeholder=\"Enter your prompt content here...\"\n >\n

\n \n

\n setIsCreateModalOpen(false)}\n className=\"px-4 py-2 border border-gray-300 rounded-md text-sm font-medium text-gray-700 hover:bg-gray-50\"\n >\n Cancel\n \n \n Create Prompt\n \n

\n )}\n

\n );\n};\n\nexport default Navigation;",[],[149,225,243],"5331e76c-3622-11f0-87d1-9e149126039e","App.tsx","5331e802-3622-11f0-87d1-9e149126039e",10,["D",1747818150101],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport Navigation from './Navigation.tsx';\nimport PromptEditor from './PromptEditor.tsx';\nimport OptimizationPanel from './OptimizationPanel.tsx';\nimport ResultsViewer from './ResultsViewer.tsx';\nimport { PromptWithVersions } from '../../shared/types.ts';\n\ninterface AppProps {\n initialData: {\n appName: string;\n version: string;\n };\n}\n\nconst App: React.FC = ({ initialData }) => {\n const [prompts, setPrompts] = useState([]);\n const [currentPrompt, setCurrentPrompt] = useState(null);\n const [loading, setLoading] = useState(true);\n const [view, setView] = useState<'editor' | 'optimize' | 'results'>('editor');\n const [notification, setNotification] = useState<{ message: string; type: 'success' | 'error' } | null>(null);\n\n // Fetch prompts on initial load\n useEffect(() => {\n fetchPrompts();\n }, []);\n\n const fetchPrompts = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/prompts');\n const data = await response.json();\n \n if (data.success) {\n setPrompts(data.prompts);\n if (data.prompts.length > 0) {\n await fetchPromptDetails(data.prompts[0].id);\n } else {\n setCurrentPrompt(null);\n }\n } else {\n showNotification(data.error || 'Failed to fetch prompts', 'error');\n }\n } catch (error) {\n console.error('Error fetching prompts:', error);\n showNotification('Failed to fetch prompts', 'error');\n } finally {\n setLoading(false);\n }\n };\n\n const fetchPromptDetails = async (promptId: number) => {\n try {\n setLoading(true);\n const response = await fetch(`/api/prompts/${promptId}`);\n const data = await response.json();\n \n if (data.success) {\n setCurrentPrompt(data.prompt);\n } else {\n showNotification(data.error || 'Failed to fetch prompt details', 'error');\n }\n } catch (error) {\n console.error('Error fetching prompt details:', error);\n showNotification('Failed to fetch prompt details', 'error');\n } finally {\n setLoading(false);\n }\n };\n\n const createPrompt = async (title: string, description: string, content: string) => {\n try {\n setLoading(true);\n const response = await fetch('/api/prompts', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ title, description, content }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n showNotification('Prompt created successfully', 'success');\n await fetchPrompts();\n await fetchPromptDetails(data.promptId);\n } else {\n showNotification(data.error || 'Failed to create prompt', 'error');\n }\n } catch (error) {\n console.error('Error creating prompt:', error);\n showNotification('Failed to create prompt', 'error');\n } finally {\n setLoading(false);\n }\n };\n\n const createVersion = async (promptId: number, content: string) => {\n try {\n setLoading(true);\n const response = await fetch(`/api/prompts/${promptId}/versions`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ content }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n showNotification('New version created successfully', 'success');\n await fetchPromptDetails(promptId);\n } else {\n showNotification(data.error || 'Failed to create version', 'error');\n }\n } catch (error) {\n console.error('Error creating version:', error);\n showNotification('Failed to create version', 'error');\n } finally {\n setLoading(false);\n }\n };\n\n const showNotification = (message: string, type: 'success' | 'error') => {\n setNotification({ message, type });\n setTimeout(() => setNotification(null), 5000);\n };\n\n return (\n

\n {/* Header */}\n

\n ✨ {initialData.appName}\n v{initialData.version}\n

\n \n \n \n

\n\n {/* Main content */}\n

\n {/* Sidebar */}\n \n\n {/* Main content area */}\n

\n {loading ? (\n

\n ) : (\n <>\n {view === 'editor' && (\n \n )}\n \n {view === 'optimize' && currentPrompt && (\n \n )}\n \n {view === 'results' && currentPrompt && (\n \n )}\n \n )}\n

\n\n {/* Notification */}\n {notification && (\n

\n {notification.message}\n

\n )}\n

\n );\n};\n\nexport default App;",[],[149,225,251],"53322754-3622-11f0-87d1-9e149126039e",["D",1747818150101],[171,172,173,174,175],[149,225],"3ec5e378-3622-11f0-9c3d-9e149126039e",["D",1747818115837],[170,176,177],[149],"aedab7a6-3622-11f0-9d44-9e149126039e","index.ts","ae8a7b4b-7259-4be0-95ca-45345cbf1bc3",["D",1747818303879],2,"http","import { Hono } from 'https://esm.sh/hono@3.11.7';\nimport { cors } from 'https://esm.sh/@hono/cors@0.0.6';\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport promptsRouter from './routes/prompts.ts';\nimport optimizeRouter from './routes/optimize.ts';\n\n// Initialize the Hono app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(err);\n throw err;\n});\n\n// Apply CORS middleware\napp.use('/*', cors());\n\n// API routes\napp.route('/api/prompts', promptsRouter);\napp.route('/api/optimize', optimizeRouter);\n\n// Serve static files\napp.get('/frontend/*', c => serveFile(c.req.path, import.meta.url));\napp.get('/shared/*', c => serveFile(c.req.path, import.meta.url));\n\n// Serve index.html with initial data\napp.get('/', async c => {\n let html = await readFile('/frontend/index.html', import.meta.url);\n \n // Inject initial data to avoid extra round-trips\n const initialData = {\n appName: 'PromptCraft',\n version: '1.0.0'\n };\n \n const dataScript = ``;\n \n html = html.replace('', `${dataScript}`);\n return c.html(html);\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[275,267],"backend","2935a30e-3622-11f0-8c2f-9e149126039e","prompts.ts","2935a3fe-3622-11f0-8c2f-9e149126039e","23389318-8552-463a-a2f3-3b8b51e97c2c",5,["D",1747818079660],"import { Hono } from 'https://esm.sh/hono@3.11.7';\nimport { \n createPrompt, \n getPrompts, \n getPromptWithVersions, \n createNewVersion, \n saveResult, \n getVersionWithResults \n} from '../database/queries.ts';\n\nconst app = new Hono();\n\n// Get all prompts\napp.get('/', async (c) => {\n try {\n const prompts = await getPrompts();\n return c.json({ success: true, prompts });\n } catch (error) {\n console.error('Error fetching prompts:', error);\n return c.json({ success: false, error: 'Failed to fetch prompts' }, 500);\n }\n});\n\n// Get a specific prompt with all its versions\napp.get('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid prompt ID' }, 400);\n }\n \n const prompt = await getPromptWithVersions(id);\n if (!prompt) {\n return c.json({ success: false, error: 'Prompt not found' }, 404);\n }\n \n return c.json({ success: true, prompt });\n } catch (error) {\n console.error('Error fetching prompt:', error);\n return c.json({ success: false, error: 'Failed to fetch prompt' }, 500);\n }\n});\n\n// Create a new prompt\napp.post('/', async (c) => {\n try {\n const body = await c.req.json();\n const { title, description, content } = body;\n \n if (!title || !content) {\n return c.json({ success: false, error: 'Title and content are required' }, 400);\n }\n \n const promptId = await createPrompt(title, description || null, content);\n return c.json({ success: true, promptId }, 201);\n } catch (error) {\n console.error('Error creating prompt:', error);\n return c.json({ success: false, error: 'Failed to create prompt' }, 500);\n }\n});\n\n// Create a new version for an existing prompt\napp.post('/:id/versions', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid prompt ID' }, 400);\n }\n \n const body = await c.req.json();\n const { content } = body;\n \n if (!content) {\n return c.json({ success: false, error: 'Content is required' }, 400);\n }\n \n const versionId = await createNewVersion(id, content);\n return c.json({ success: true, versionId }, 201);\n } catch (error) {\n console.error('Error creating version:', error);\n return c.json({ success: false, error: 'Failed to create version' }, 500);\n }\n});\n\n// Get a specific version with its results\napp.get('/versions/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid version ID' }, 400);\n }\n \n const version = await getVersionWithResults(id);\n if (!version) {\n return c.json({ success: false, error: 'Version not found' }, 404);\n }\n \n return c.json({ success: true, version });\n } catch (error) {\n console.error('Error fetching version:', error);\n return c.json({ success: false, error: 'Failed to fetch version' }, 500);\n }\n});\n\n// Save a result for a version\napp.post('/versions/:id/results', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid version ID' }, 400);\n }\n \n const body = await c.req.json();\n const { response, rating, feedback } = body;\n \n if (!response) {\n return c.json({ success: false, error: 'Response is required' }, 400);\n }\n \n const resultId = await saveResult(id, response, rating, feedback);\n return c.json({ success: true, resultId }, 201);\n } catch (error) {\n console.error('Error saving result:', error);\n return c.json({ success: false, error: 'Failed to save result' }, 500);\n }\n});\n\nexport default app;",[],[275,285,277],"routes","3385d96e-3622-11f0-9724-9e149126039e","optimize.ts","3385d9f0-3622-11f0-9724-9e149126039e",6,["D",1747818096964],"import { Hono } from 'https://esm.sh/hono@3.11.7';\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\n\nconst app = new Hono();\n\n// Initialize OpenAI client\nconst openai = new OpenAI();\n\n// Test a prompt with GPT\napp.post('/test', async (c) => {\n try {\n const body = await c.req.json();\n const { prompt, model = 'gpt-4o-mini' } = body;\n \n if (!prompt) {\n return c.json({ success: false, error: 'Prompt is required' }, 400);\n }\n \n const completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: prompt }\n ],\n model,\n max_tokens: 500,\n });\n \n return c.json({ \n success: true, \n response: completion.choices[0].message.content,\n usage: completion.usage\n });\n } catch (error) {\n console.error('Error testing prompt:', error);\n return c.json({ success: false, error: 'Failed to test prompt' }, 500);\n }\n});\n\n// Get optimization suggestions for a prompt\napp.post('/suggestions', async (c) => {\n try {\n const body = await c.req.json();\n const { prompt, goal, model = 'gpt-4o-mini' } = body;\n \n if (!prompt) {\n return c.json({ success: false, error: 'Prompt is required' }, 400);\n }\n \n const systemPrompt = `You are an expert at optimizing prompts for AI language models. \nYour task is to analyze the given prompt and suggest improvements to make it more effective.\n\n${goal ? `The user's goal for this prompt is: ${goal}` : 'Analyze the prompt and determine the likely goal.'}\n\nProvide the following:\n1. An analysis of the current prompt's strengths and weaknesses\n2. 3 specific suggestions for improvement\n3. 2-3 alternative versions of the prompt that implement your suggestions\n4. A brief explanation of why each alternative might perform better`;\n\n const completion = await openai.chat.completions.create({\n messages: [\n { role: \"system\", content: systemPrompt },\n { role: \"user\", content: `Here is the prompt to optimize:\\n\\n\"${prompt}\"` }\n ],\n model,\n max_tokens: 1000,\n });\n \n return c.json({ \n success: true, \n suggestions: completion.choices[0].message.content,\n usage: completion.usage\n });\n } catch (error) {\n console.error('Error getting suggestions:', error);\n return c.json({ success: false, error: 'Failed to get suggestions' }, 500);\n }\n});\n\n// Compare two prompts\napp.post('/compare', async (c) => {\n try {\n const body = await c.req.json();\n const { promptA, promptB, criteria, model = 'gpt-4o-mini' } = body;\n \n if (!promptA || !promptB) {\n return c.json({ success: false, error: 'Both prompts are required' }, 400);\n }\n \n const systemPrompt = `You are an expert at evaluating prompts for AI language models.\nYour task is to compare two prompts and determine which one is likely to be more effective.\n\n${criteria ? `The evaluation criteria are: ${criteria}` : 'Use standard criteria like clarity, specificity, and goal alignment.'}\n\nProvide the following:\n1. A side-by-side comparison of the two prompts\n2. The strengths and weaknesses of each prompt\n3. Your recommendation on which prompt is better and why\n4. A percentage score (0-100%) for each prompt based on the criteria`;\n\n const completion = await openai.chat.completions.create({\n messages: [\n { role: \"system\", content: systemPrompt },\n { role: \"user\", content: `Compare these two prompts:\n\nPrompt A: \"${promptA}\"\n\nPrompt B: \"${promptB}\"` }\n ],\n model,\n max_tokens: 1000,\n });\n \n return c.json({ \n success: true, \n comparison: completion.choices[0].message.content,\n usage: completion.usage\n });\n } catch (error) {\n console.error('Error comparing prompts:', error);\n return c.json({ success: false, error: 'Failed to compare prompts' }, 500);\n }\n});\n\nexport default app;",[],[275,285,287],"2935e602-3622-11f0-8c2f-9e149126039e",["D",1747818079660],[166,167],[275,285],"1fd21144-3622-11f0-8d59-9e149126039e","queries.ts","1fd211da-3622-11f0-8d59-9e149126039e","9627b79f-0627-4938-b547-331eda903f55",4,["D",1747818063910],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { PROMPTS_TABLE, VERSIONS_TABLE, RESULTS_TABLE } from './migrations.ts';\n\n// Types\nexport interface Prompt {\n id: number;\n title: string;\n description: string | null;\n created_at: number;\n updated_at: number;\n}\n\nexport interface PromptVersion {\n id: number;\n prompt_id: number;\n content: string;\n version_number: number;\n is_current: boolean;\n created_at: number;\n}\n\nexport interface PromptResult {\n id: number;\n version_id: number;\n response: string;\n rating: number | null;\n feedback: string | null;\n created_at: number;\n}\n\nexport interface PromptWithVersions extends Prompt {\n versions: PromptVersion[];\n}\n\nexport interface VersionWithResults extends PromptVersion {\n results: PromptResult[];\n}\n\n// Prompt CRUD operations\nexport async function createPrompt(title: string, description: string | null, initialContent: string): Promise {\n const now = Date.now();\n \n // Create the prompt\n const promptResult = await sqlite.execute(\n `INSERT INTO ${PROMPTS_TABLE} (title, description, created_at, updated_at) \n VALUES (?, ?, ?, ?)\n RETURNING id`,\n [title, description, now, now]\n );\n \n const promptId = promptResult.rows[0].id;\n \n // Create the initial version\n await sqlite.execute(\n `INSERT INTO ${VERSIONS_TABLE} (prompt_id, content, version_number, is_current, created_at)\n VALUES (?, ?, ?, ?, ?)`,\n [promptId, initialContent, 1, true, now]\n );\n \n return promptId;\n}\n\nexport async function getPrompts(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${PROMPTS_TABLE} ORDER BY updated_at DESC`);\n return result.rows as Prompt[];\n}\n\nexport async function getPromptWithVersions(promptId: number): Promise {\n // Get the prompt\n const promptResult = await sqlite.execute(\n `SELECT * FROM ${PROMPTS_TABLE} WHERE id = ?`,\n [promptId]\n );\n \n if (promptResult.rows.length === 0) {\n return null;\n }\n \n const prompt = promptResult.rows[0] as Prompt;\n \n // Get all versions\n const versionsResult = await sqlite.execute(\n `SELECT * FROM ${VERSIONS_TABLE} WHERE prompt_id = ? ORDER BY version_number DESC`,\n [promptId]\n );\n \n const versions = versionsResult.rows as PromptVersion[];\n \n return {\n ...prompt,\n versions\n };\n}\n\nexport async function createNewVersion(promptId: number, content: string): Promise {\n // Get the current highest version number\n const versionResult = await sqlite.execute(\n `SELECT MAX(version_number) as max_version FROM ${VERSIONS_TABLE} WHERE prompt_id = ?`,\n [promptId]\n );\n \n const maxVersion = versionResult.rows[0].max_version || 0;\n const newVersionNumber = maxVersion + 1;\n \n // Set all versions to not current\n await sqlite.execute(\n `UPDATE ${VERSIONS_TABLE} SET is_current = 0 WHERE prompt_id = ?`,\n [promptId]\n );\n \n // Create the new version\n const result = await sqlite.execute(\n `INSERT INTO ${VERSIONS_TABLE} (prompt_id, content, version_number, is_current, created_at)\n VALUES (?, ?, ?, ?, ?)\n RETURNING id`,\n [promptId, content, newVersionNumber, true, Date.now()]\n );\n \n // Update the prompt's updated_at timestamp\n await sqlite.execute(\n `UPDATE ${PROMPTS_TABLE} SET updated_at = ? WHERE id = ?`,\n [Date.now(), promptId]\n );\n \n return result.rows[0].id;\n}\n\nexport async function saveResult(versionId: number, response: string, rating?: number, feedback?: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${RESULTS_TABLE} (version_id, response, rating, feedback, created_at)\n VALUES (?, ?, ?, ?, ?)\n RETURNING id`,\n [versionId, response, rating || null, feedback || null, Date.now()]\n );\n \n return result.rows[0].id;\n}\n\nexport async function getVersionWithResults(versionId: number): Promise {\n // Get the version\n const versionResult = await sqlite.execute(\n `SELECT * FROM ${VERSIONS_TABLE} WHERE id = ?`,\n [versionId]\n );\n \n if (versionResult.rows.length === 0) {\n return null;\n }\n \n const version = versionResult.rows[0] as PromptVersion;\n \n // Get all results\n const resultsResult = await sqlite.execute(\n `SELECT * FROM ${RESULTS_TABLE} WHERE version_id = ? ORDER BY created_at DESC`,\n [versionId]\n );\n \n const results = resultsResult.rows as PromptResult[];\n \n return {\n ...version,\n results\n };\n}",[],[275,307,299],"database","1515b38c-3622-11f0-a002-9e149126039e","migrations.ts","1515b47c-3622-11f0-a002-9e149126039e",3,["D",1747818045893],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning for schema changes\nexport const PROMPTS_TABLE = 'prompt_craft_prompts_v1';\nexport const VERSIONS_TABLE = 'prompt_craft_versions_v1';\nexport const RESULTS_TABLE = 'prompt_craft_results_v1';\n\n/**\n * Run all migrations to set up the database schema\n */\nexport async function runMigrations() {\n // Create prompts table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${PROMPTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL\n )\n `);\n\n // Create prompt versions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${VERSIONS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n prompt_id INTEGER NOT NULL,\n content TEXT NOT NULL,\n version_number INTEGER NOT NULL,\n is_current BOOLEAN NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL,\n FOREIGN KEY (prompt_id) REFERENCES ${PROMPTS_TABLE}(id)\n )\n `);\n\n // Create results table for tracking performance\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RESULTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n version_id INTEGER NOT NULL,\n response TEXT NOT NULL,\n rating INTEGER,\n feedback TEXT,\n created_at INTEGER NOT NULL,\n FOREIGN KEY (version_id) REFERENCES ${VERSIONS_TABLE}(id)\n )\n `);\n}\n\n// Run migrations on module import\nrunMigrations().catch(err => {\n console.error('Failed to run migrations:', err);\n});",[],[275,307,309],"1515db3c-3622-11f0-a002-9e149126039e",["D",1747818045893],[163,164],[275,307],"0f62e414-3622-11f0-8d34-9e149126039e",["D",1747818036335],[162,165,168],[275],["D",1747817973918],{"_11":12,"_118":68},{"_11":12,"_114":-5,"_67":68,"_30":66,"_115":116,"_117":24},{"_38":105,"_13":16,"_32":35,"_106":70,"_107":-5,"_108":-5,"_109":-5,"_110":-5,"_111":-5,"_112":14,"_113":12},"ctx",{"_51":-5,"_137":361,"_362":363,"_364":365,"_366":24,"_367":24,"_368":24,"_369":82,"_370":-5,"_371":-7,"_372":-7,"_373":26,"_374":24,"_375":24,"_376":-5,"_377":24,"_378":24,"_379":24,"_380":-5},"ENV",{"_332":333,"_334":335,"_336":16,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

History · index.html