[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_242":243,"_244":245},"routes/_app.x.$handle.$name",{"_101":100,"_32":50,"_109":91,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_21":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":25,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_36":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":-5,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",7,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","shared","latestPath","fileId","4514f91e-5ee7-4ea6-b1e5-4f530db3192f","name","fileType","directory","content","createdAt",["D",1747818103897],"branchVersion","branchId","ea2e4fd0-3621-11f0-8199-9e149126039e",{"_30":43,"_32":44,"_33":45,"_35":46,"_36":47,"_38":14,"_39":40,"_24":25},"shared/types.ts","37a7e3b6-3622-11f0-b0d2-9e149126039e","types.ts","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}",["D",1747818103897],"id","ea2e18da-3621-11f0-8199-9e149126039e","prompthero",["D",1747817973918],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","5d684f12-ce21-4331-a69d-3fc32ac8bcbe","pinnedFileId","0f62de88-3622-11f0-8d34-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","bb1cf631-e7f7-4437-af7c-3a9e70eace24","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},"branch",{"_13":90,"_32":91,"_48":40,"_92":49,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":50,"_99":100},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","heybunny","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJwUzFTUTJKNzg0Z1VFN0NadVo4UGswaUxUVyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_36":238,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":-5,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":239,"_85":240,"_87":241,"_89":25},"tree",[163,171,173],"files",[163,164,165,166,167,168,169,170,171,172,173],"counts",{"_153":67,"_154":138,"_155":67,"_156":157,"_158":159},"contents",[131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":147,"_32":148,"_30":149,"_137":-5,"_39":40,"_38":150,"_139":63,"_36":151,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":152},{"_48":144,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":63,"_36":145,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":146},{"_48":134,"_32":135,"_30":136,"_137":-5,"_39":40,"_38":138,"_139":63,"_36":140,"_13":67,"_33":21,"_35":141,"_24":25,"_142":-5,"_27":143},"095e8c1c-3622-11f0-b1e3-9e149126039e","README.md","095e8cee-3622-11f0-b1e3-9e149126039e","parentId",1,"latest",["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","label",[135],"37a7e9a6-3622-11f0-b0d2-9e149126039e",["D",1747818103897],[28],"0f62e414-3622-11f0-8d34-9e149126039e","backend","ae8a7b4b-7259-4be0-95ca-45345cbf1bc3",2,["D",1747818036335],[148],"pulls","branches","forks","envVars",{"_160":67,"_162":67},"connections",{"_160":67,"_161":67},"count","unfilledCount","emptyCount",{"_48":147,"_32":148,"_30":149,"_137":-5,"_39":40,"_38":150,"_139":63,"_36":235,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_175":236,"_27":237},{"_48":231,"_32":222,"_30":216,"_137":149,"_39":40,"_38":226,"_139":63,"_36":232,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_175":233,"_27":234},{"_48":223,"_32":224,"_30":225,"_137":216,"_39":40,"_38":226,"_139":63,"_36":227,"_13":67,"_33":45,"_35":228,"_24":25,"_142":-5,"_175":229,"_27":230},{"_48":213,"_32":214,"_30":215,"_137":216,"_39":40,"_38":217,"_139":63,"_36":218,"_13":67,"_33":45,"_35":219,"_24":25,"_142":-5,"_175":220,"_27":221},{"_48":209,"_32":200,"_30":194,"_137":149,"_39":40,"_38":195,"_139":63,"_36":210,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_175":211,"_27":212},{"_48":201,"_32":202,"_30":203,"_137":194,"_39":40,"_38":204,"_139":63,"_36":205,"_13":67,"_33":45,"_35":206,"_24":25,"_142":-5,"_175":207,"_27":208},{"_48":191,"_32":192,"_30":193,"_137":194,"_39":40,"_38":195,"_139":63,"_36":196,"_13":67,"_33":45,"_35":197,"_24":25,"_142":-5,"_175":198,"_27":199},{"_48":185,"_32":186,"_30":61,"_137":149,"_39":40,"_38":150,"_139":25,"_36":187,"_13":67,"_33":45,"_35":188,"_24":25,"_142":-5,"_175":189,"_27":190},{"_48":144,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":63,"_36":182,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_175":183,"_27":184},{"_48":178,"_32":44,"_30":43,"_137":31,"_39":40,"_38":14,"_139":63,"_36":179,"_13":67,"_33":45,"_35":46,"_24":25,"_142":-5,"_175":180,"_27":181},{"_48":134,"_32":135,"_30":136,"_137":-5,"_39":40,"_38":138,"_139":63,"_36":174,"_13":67,"_33":21,"_35":141,"_24":25,"_142":-5,"_175":176,"_27":177},["D",1747818026240],"children",[],[135],"37a7e302-3622-11f0-b0d2-9e149126039e",["D",1747818103897],[],[28,44],["D",1747818103897],[172],[28],"0f62ddd4-3622-11f0-8d34-9e149126039e","index.ts",["D",1747818036335],"import { Hono } from 'https://esm.sh/hono@3.11.7';\nimport { cors } from 'https://esm.sh/hono@3.11.7/middleware';\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;",[],[148,186],"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;",[],[148,200,192],"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;",[],[148,200,202],"2935e602-3622-11f0-8c2f-9e149126039e",["D",1747818079660],[168,169],[148,200],"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}",[],[148,222,214],"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});",[],[148,222,224],"1515db3c-3622-11f0-a002-9e149126039e",["D",1747818045893],[165,166],[148,222],["D",1747818036335],[164,167,170],[148],["D",1747817973918],{"_101":100,"_108":104},{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},{"_13":90,"_32":91,"_48":40,"_92":49,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":50,"_99":100},"ctx",{"_83":-5,"_128":275,"_276":277,"_278":279,"_280":25,"_281":25,"_282":25,"_283":63,"_284":-5,"_285":-7,"_286":-7,"_287":67,"_288":25,"_289":25,"_290":-5,"_291":25,"_292":25,"_293":25,"_294":-5},"ENV",{"_246":247,"_248":249,"_250":91,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274},"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"]

Diff · v7