[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_226":227,"_228":229},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",5,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","backend/routes/blends.ts","latestPath","fileId","cda3ab5a-6df1-11f0-9a58-0224a6c84d84","name","blends.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport type { \n BlendGenerationRequest, \n BlendGenerationResponse, \n WineBlend, \n SensoryProfile, \n MarketAnalysis,\n BlendComponent\n} from \"../../shared/types.ts\";\nimport { \n getAllWineBlends, \n createWineBlend, \n getWineBlendById,\n updateWineBlendResults,\n getVineyardBlocksByIds \n} from \"../database/queries.ts\";\n\nconst app = new Hono();\nconst openai = new OpenAI();\n\n// Generate a new wine blend using AI\napp.post(\"/generate\", async (c) => {\n try {\n const request: BlendGenerationRequest = await c.req.json();\n \n // Get available vineyard blocks\n const availableBlocks = await getVineyardBlocksByIds(request.available_blocks);\n \n if (availableBlocks.length === 0) {\n return c.json({ error: \"No available vineyard blocks found\" }, 400);\n }\n\n // Create AI prompt for blend generation\n const prompt = createBlendGenerationPrompt(request, availableBlocks);\n \n const completion = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"system\",\n content: \"You are a master winemaker and AI assistant specializing in wine blending. You have deep knowledge of viticulture, enology, and wine chemistry. Provide detailed, scientifically-informed recommendations for wine blends.\"\n },\n {\n role: \"user\",\n content: prompt\n }\n ],\n max_tokens: 2000,\n temperature: 0.7\n });\n\n const aiResponse = completion.choices[0]?.message?.content;\n if (!aiResponse) {\n throw new Error(\"No response from AI\");\n }\n\n // Parse AI response and create blend object\n const blend = parseAIBlendResponse(aiResponse, request, availableBlocks);\n \n // Save the blend to database\n await createWineBlend(blend);\n\n const response: BlendGenerationResponse = {\n blend,\n reasoning: aiResponse,\n alternatives: [] // Could generate multiple options in the future\n };\n\n return c.json(response);\n } catch (error) {\n console.error(\"Error generating blend:\", error);\n return c.json({ error: \"Failed to generate blend\" }, 500);\n }\n});\n\n// Get all wine blends\napp.get(\"/\", async (c) => {\n try {\n const blends = await getAllWineBlends();\n return c.json(blends);\n } catch (error) {\n console.error(\"Error fetching blends:\", error);\n return c.json({ error: \"Failed to fetch blends\" }, 500);\n }\n});\n\n// Get specific wine blend\napp.get(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const blend = await getWineBlendById(id);\n \n if (!blend) {\n return c.json({ error: \"Blend not found\" }, 404);\n }\n \n return c.json(blend);\n } catch (error) {\n console.error(\"Error fetching blend:\", error);\n return c.json({ error: \"Failed to fetch blend\" }, 500);\n }\n});\n\n// Update blend with actual results\napp.put(\"/:id/results\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const results = await c.req.json();\n \n await updateWineBlendResults(id, results);\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error updating blend results:\", error);\n return c.json({ error: \"Failed to update blend results\" }, 500);\n }\n});\n\nfunction createBlendGenerationPrompt(request: BlendGenerationRequest, availableBlocks: any[]): string {\n const blocksInfo = availableBlocks.map(block => \n `- ${block.name} (${block.varietal}): ${block.vintage} vintage, ${block.alcohol}% ABV, pH ${block.ph}, Acidity ${block.acidity}g/L, Tannins ${block.tannins}/10, Sugar ${block.sugar}g/L. Notes: ${block.notes || 'None'}`\n ).join('\\n');\n\n return `\nCreate a wine blend recommendation based on the following parameters:\n\nTARGET STYLE: ${request.target_style}\n\nAVAILABLE VINEYARD BLOCKS:\n${blocksInfo}\n\nPREFERENCES:\n- Max components: ${request.preferences?.max_components || 'No limit'}\n- Preferred varietals: ${request.preferences?.preferred_varietals?.join(', ') || 'None specified'}\n- Target alcohol: ${request.preferences?.target_alcohol || 'Not specified'}%\n- Style notes: ${request.preferences?.style_notes || 'None'}\n\nPlease provide a detailed response in the following JSON format:\n{\n \"blend_name\": \"Creative name for the blend\",\n \"components\": [\n {\n \"block_id\": \"block-xxx\",\n \"percentage\": 45.0\n }\n ],\n \"predicted_sensory\": {\n \"aroma\": [\"descriptor1\", \"descriptor2\", \"descriptor3\"],\n \"taste\": [\"descriptor1\", \"descriptor2\", \"descriptor3\"],\n \"mouthfeel\": [\"descriptor1\", \"descriptor2\"],\n \"finish\": \"Description of the finish\",\n \"overall_notes\": \"Overall tasting impression\"\n },\n \"market_analysis\": {\n \"target_market\": \"Target consumer segment\",\n \"appeal_score\": 8.5,\n \"price_point\": \"Premium/Mid-range/Entry-level\",\n \"consumer_profile\": \"Description of ideal consumer\",\n \"market_positioning\": \"How to position this wine\"\n },\n \"reasoning\": \"Detailed explanation of why this blend works\"\n}\n\nEnsure percentages add up to 100% and consider the chemical properties of each block to create a harmonious blend.\n`;\n}\n\nfunction parseAIBlendResponse(aiResponse: string, request: BlendGenerationRequest, availableBlocks: any[]): WineBlend {\n try {\n // Extract JSON from AI response\n const jsonMatch = aiResponse.match(/\\{[\\s\\S]*\\}/);\n if (!jsonMatch) {\n throw new Error(\"No JSON found in AI response\");\n }\n \n const parsed = JSON.parse(jsonMatch[0]);\n \n // Create blend components with full block info\n const components: BlendComponent[] = parsed.components.map((comp: any) => {\n const block = availableBlocks.find(b => b.id === comp.block_id);\n if (!block) {\n throw new Error(`Block ${comp.block_id} not found`);\n }\n \n return {\n block_id: comp.block_id,\n block_name: block.name,\n varietal: block.varietal,\n percentage: comp.percentage\n };\n });\n\n // Generate unique ID\n const blendId = `blend-${Date.now()}-${Math.random().toString(36).substr(2, 9)}`;\n\n const blend: WineBlend = {\n id: blendId,\n name: parsed.blend_name || `${request.target_style} Blend`,\n components,\n target_style: request.target_style,\n predicted_sensory: parsed.predicted_sensory as SensoryProfile,\n market_analysis: parsed.market_analysis as MarketAnalysis,\n created_at: new Date().toISOString()\n };\n\n return blend;\n } catch (error) {\n console.error(\"Error parsing AI response:\", error);\n \n // Fallback: create a simple blend if AI parsing fails\n const fallbackBlend: WineBlend = {\n id: `blend-${Date.now()}-fallback`,\n name: `${request.target_style} Blend`,\n components: availableBlocks.slice(0, 2).map((block, index) => ({\n block_id: block.id,\n block_name: block.name,\n varietal: block.varietal,\n percentage: index === 0 ? 60 : 40\n })),\n target_style: request.target_style,\n predicted_sensory: {\n aroma: [\"complex\", \"balanced\"],\n taste: [\"harmonious\", \"well-structured\"],\n mouthfeel: [\"smooth\", \"medium-bodied\"],\n finish: \"Pleasant and lingering\",\n overall_notes: \"A well-balanced blend showcasing the terroir\"\n },\n market_analysis: {\n target_market: \"Wine enthusiasts\",\n appeal_score: 7.5,\n price_point: \"Mid-range\",\n consumer_profile: \"Discerning wine drinkers\",\n market_positioning: \"Artisanal quality wine\"\n },\n created_at: new Date().toISOString()\n };\n\n return fallbackBlend;\n }\n}\n\nexport default app;","createdAt",["D",1753954575287],"branchVersion","branchId","569ff86a-6df1-11f0-900f-0224a6c84d84",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"backend/routes","a0b7e284-a274-428b-acd8-51d267a08ece","routes","directory",["D",1753954575287],"id","569f9fb4-6df1-11f0-900f-0224a6c84d84","winn",["D",1753954375629],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","d9951e10-16dc-11f0-9d61-bf534f47ce53","pinnedFileId","ed563314-6df1-11f0-9a7d-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","a87ae3da-e311-4bfb-919e-aa8beb34d11f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",24,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","spooky","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydmFPZkZqOVNkRDN1cTJPUEZJZGtDUHpkNGYifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_38":222,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":223,"_86":224,"_88":225,"_90":25},"tree",[167,173,175],"files",[167,168,169,170,171,172,173,174,175],"counts",{"_157":141,"_158":68,"_159":141,"_160":161,"_162":163},"contents",[132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":151,"_32":152,"_30":153,"_138":-5,"_41":42,"_40":154,"_139":64,"_38":155,"_13":141,"_34":47,"_36":-5,"_24":25,"_143":-5,"_27":156},{"_49":145,"_32":146,"_30":147,"_138":-5,"_41":42,"_40":148,"_139":64,"_38":149,"_13":141,"_34":47,"_36":-5,"_24":25,"_143":-5,"_27":150},{"_49":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":68,"_139":25,"_38":140,"_13":141,"_34":21,"_36":142,"_24":25,"_143":-5,"_27":144},"90d5b34e-6df1-11f0-8fff-0224a6c84d84","README.md","90d5b3f8-6df1-11f0-8fff-0224a6c84d84","parentId","latest",["D",1753954473287],0,"# Terroir Harmony AI Blend Designer\n\n## Unleash the Art of Blending with Data-Driven Precision\n\nA simplified implementation of an AI-powered wine blending assistant built on Val Town.\n\n---\n\n## Introduction\n\nThe **Terroir Harmony AI Blend Designer** is a custom AI application designed for boutique winemakers. It leverages AI to propose wine blend compositions, predict sensory profiles, and assess market suitability.\n\n## Features\n\n* **Blend Composition Generator:** Input desired wine characteristics and get AI-generated blend ratios\n* **Sensory Profile Prediction:** Receive detailed tasting notes and aroma descriptors for proposed blends\n* **Market Suitability Scoring:** Get predicted consumer appeal scores\n* **Chemical Analysis Integration:** Store and analyze vineyard block data\n* **Historical Blend Tracking:** Maintain records of successful blends\n\n## Architecture\n\nThis Val Town implementation uses:\n- **Backend:** Hono.js API framework\n- **Database:** SQLite for data persistence\n- **AI:** OpenAI GPT-4 for blend generation and sensory prediction\n- **Frontend:** React with TailwindCSS\n- **Storage:** Val Town Blob storage for file uploads\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main API entry point\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── routes/\n│ ├── blends.ts # Blend generation endpoints\n│ ├── data.ts # Data management endpoints\n│ └── static.ts # Static file serving\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React app entry point\n│ └── components/\n│ ├── App.tsx # Main app component\n│ ├── BlendGenerator.tsx\n│ ├── DataUpload.tsx\n│ └── BlendHistory.tsx\n├── shared/\n│ └── types.ts # Shared TypeScript types\n└── data/\n └── sample_data.json # Sample wine data\n```\n\n## Getting Started\n\n1. The main application runs at the root HTTP endpoint\n2. Upload chemical analysis data via the data management interface\n3. Use the blend generator to create new wine blends\n4. Review historical blends and their performance\n\n## API Endpoints\n\n- `GET /` - Main application interface\n- `POST /api/blends/generate` - Generate new blend compositions\n- `GET /api/blends` - List historical blends\n- `POST /api/data/upload` - Upload chemical analysis data\n- `GET /api/data/vineyard-blocks` - Get vineyard block data\n\n## Technology Stack\n\n- **Backend:** Hono.js, SQLite, OpenAI API\n- **Frontend:** React, TailwindCSS\n- **Platform:** Val Town serverless environment","label",[136],"9884d912-6df1-11f0-b74a-0224a6c84d84","shared","22eeb98e-9cf2-4bb1-a48a-7d7ff6a1de2c",2,["D",1753954486175],[146],"a53857c4-6df1-11f0-9f5b-0224a6c84d84","backend","041705cc-b6e5-4952-be1a-3973f02edf74",3,["D",1753954507477],[152],"pulls","branches","forks","envVars",{"_164":141,"_166":141},"connections",{"_164":141,"_165":141},"count","unfilledCount","emptyCount",{"_49":151,"_32":152,"_30":153,"_138":-5,"_41":42,"_40":154,"_139":64,"_38":219,"_13":141,"_34":47,"_36":-5,"_24":25,"_143":-5,"_177":220,"_27":221},{"_49":215,"_32":207,"_30":201,"_138":153,"_41":42,"_40":154,"_139":64,"_38":216,"_13":141,"_34":47,"_36":-5,"_24":25,"_143":-5,"_177":217,"_27":218},{"_49":208,"_32":209,"_30":210,"_138":201,"_41":42,"_40":154,"_139":64,"_38":211,"_13":141,"_34":35,"_36":212,"_24":25,"_143":-5,"_177":213,"_27":214},{"_49":198,"_32":199,"_30":200,"_138":201,"_41":42,"_40":202,"_139":64,"_38":203,"_13":141,"_34":35,"_36":204,"_24":25,"_143":-5,"_177":205,"_27":206},{"_49":194,"_32":46,"_30":45,"_138":153,"_41":42,"_40":14,"_139":64,"_38":195,"_13":141,"_34":47,"_36":-5,"_24":25,"_143":-5,"_177":196,"_27":197},{"_49":190,"_32":33,"_30":31,"_138":45,"_41":42,"_40":14,"_139":64,"_38":191,"_13":141,"_34":35,"_36":37,"_24":25,"_143":-5,"_177":192,"_27":193},{"_49":145,"_32":146,"_30":147,"_138":-5,"_41":42,"_40":148,"_139":64,"_38":187,"_13":141,"_34":47,"_36":-5,"_24":25,"_143":-5,"_177":188,"_27":189},{"_49":180,"_32":181,"_30":182,"_138":147,"_41":42,"_40":148,"_139":64,"_38":183,"_13":141,"_34":35,"_36":184,"_24":25,"_143":-5,"_177":185,"_27":186},{"_49":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":68,"_139":25,"_38":176,"_13":141,"_34":21,"_36":142,"_24":25,"_143":-5,"_177":178,"_27":179},["D",1753954473287],"children",[],[136],"9884ce90-6df1-11f0-b74a-0224a6c84d84","types.ts","9884cf44-6df1-11f0-b74a-0224a6c84d84",["D",1753954486175],"// Shared TypeScript types for the Terroir Harmony AI Blend Designer\n\nexport interface VineyardBlock {\n id: string;\n name: string;\n varietal: string;\n vintage: number;\n alcohol: number;\n ph: number;\n acidity: number;\n tannins: number;\n sugar: number;\n notes?: string;\n created_at: string;\n}\n\nexport interface BlendComponent {\n block_id: string;\n block_name: string;\n varietal: string;\n percentage: number;\n}\n\nexport interface SensoryProfile {\n aroma: string[];\n taste: string[];\n mouthfeel: string[];\n finish: string;\n overall_notes: string;\n}\n\nexport interface MarketAnalysis {\n target_market: string;\n appeal_score: number; // 1-10\n price_point: string;\n consumer_profile: string;\n market_positioning: string;\n}\n\nexport interface WineBlend {\n id: string;\n name: string;\n components: BlendComponent[];\n target_style: string;\n predicted_sensory: SensoryProfile;\n market_analysis: MarketAnalysis;\n created_at: string;\n winemaker_notes?: string;\n actual_results?: {\n sensory_feedback: string;\n market_performance: number;\n would_make_again: boolean;\n };\n}\n\nexport interface BlendGenerationRequest {\n target_style: string;\n available_blocks: string[];\n preferences?: {\n max_components?: number;\n preferred_varietals?: string[];\n target_alcohol?: number;\n style_notes?: string;\n };\n}\n\nexport interface BlendGenerationResponse {\n blend: WineBlend;\n reasoning: string;\n alternatives?: WineBlend[];\n}\n\nexport interface ChemicalAnalysis {\n block_id: string;\n analysis_date: string;\n alcohol: number;\n ph: number;\n total_acidity: number;\n volatile_acidity: number;\n tannins: number;\n residual_sugar: number;\n sulfites: number;\n color_intensity?: number;\n phenolic_compounds?: number;\n}\n\nexport interface UploadedData {\n id: string;\n filename: string;\n type: 'chemical_analysis' | 'sensory_evaluation' | 'market_data';\n uploaded_at: string;\n processed: boolean;\n records_count?: number;\n}",[],[146,181],["D",1753954486175],[174],[146],"cda3aaa6-6df1-11f0-9a58-0224a6c84d84",["D",1753954575287],[],[152,46,33],"cda3c07c-6df1-11f0-9a58-0224a6c84d84",["D",1753954575287],[172],[152,46],"b2dbb9e8-6df1-11f0-8579-0224a6c84d84","queries.ts","b2dbbac4-6df1-11f0-8579-0224a6c84d84","da990314-77d9-4b09-965b-98a4b476cd25",4,["D",1753954530371],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { VineyardBlock, WineBlend, BlendComponent, ChemicalAnalysis, UploadedData } from \"../../shared/types.ts\";\n\n// Vineyard Block Queries\nexport async function getAllVineyardBlocks(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM vineyard_blocks ORDER BY name\");\n return result.rows as VineyardBlock[];\n}\n\nexport async function getVineyardBlockById(id: string): Promise {\n const result = await sqlite.execute(\"SELECT * FROM vineyard_blocks WHERE id = ?\", [id]);\n return result.rows[0] as VineyardBlock || null;\n}\n\nexport async function getVineyardBlocksByIds(ids: string[]): Promise {\n if (ids.length === 0) return [];\n const placeholders = ids.map(() => '?').join(',');\n const result = await sqlite.execute(\n `SELECT * FROM vineyard_blocks WHERE id IN (${placeholders})`,\n ids\n );\n return result.rows as VineyardBlock[];\n}\n\nexport async function createVineyardBlock(block: Omit): Promise {\n await sqlite.execute(`\n INSERT INTO vineyard_blocks \n (id, name, varietal, vintage, alcohol, ph, acidity, tannins, sugar, notes, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, datetime('now'))\n `, [\n block.id, block.name, block.varietal, block.vintage,\n block.alcohol, block.ph, block.acidity, block.tannins,\n block.sugar, block.notes || null\n ]);\n}\n\n// Wine Blend Queries\nexport async function getAllWineBlends(): Promise {\n const blendsResult = await sqlite.execute(`\n SELECT * FROM wine_blends ORDER BY created_at DESC\n `);\n \n const blends: WineBlend[] = [];\n \n for (const row of blendsResult.rows) {\n const componentsResult = await sqlite.execute(`\n SELECT * FROM blend_components WHERE blend_id = ?\n `, [row.id]);\n \n const blend: WineBlend = {\n id: row.id,\n name: row.name,\n target_style: row.target_style,\n predicted_sensory: JSON.parse(row.predicted_sensory),\n market_analysis: JSON.parse(row.market_analysis),\n created_at: row.created_at,\n winemaker_notes: row.winemaker_notes,\n actual_results: row.actual_results ? JSON.parse(row.actual_results) : undefined,\n components: componentsResult.rows as BlendComponent[]\n };\n \n blends.push(blend);\n }\n \n return blends;\n}\n\nexport async function getWineBlendById(id: string): Promise {\n const blendResult = await sqlite.execute(\"SELECT * FROM wine_blends WHERE id = ?\", [id]);\n if (blendResult.rows.length === 0) return null;\n \n const row = blendResult.rows[0];\n const componentsResult = await sqlite.execute(`\n SELECT * FROM blend_components WHERE blend_id = ?\n `, [id]);\n \n return {\n id: row.id,\n name: row.name,\n target_style: row.target_style,\n predicted_sensory: JSON.parse(row.predicted_sensory),\n market_analysis: JSON.parse(row.market_analysis),\n created_at: row.created_at,\n winemaker_notes: row.winemaker_notes,\n actual_results: row.actual_results ? JSON.parse(row.actual_results) : undefined,\n components: componentsResult.rows as BlendComponent[]\n };\n}\n\nexport async function createWineBlend(blend: Omit): Promise {\n // Insert the main blend record\n await sqlite.execute(`\n INSERT INTO wine_blends \n (id, name, target_style, predicted_sensory, market_analysis, created_at, winemaker_notes, actual_results)\n VALUES (?, ?, ?, ?, ?, datetime('now'), ?, ?)\n `, [\n blend.id,\n blend.name,\n blend.target_style,\n JSON.stringify(blend.predicted_sensory),\n JSON.stringify(blend.market_analysis),\n blend.winemaker_notes || null,\n blend.actual_results ? JSON.stringify(blend.actual_results) : null\n ]);\n \n // Insert blend components\n for (const component of blend.components) {\n await sqlite.execute(`\n INSERT INTO blend_components (blend_id, block_id, block_name, varietal, percentage)\n VALUES (?, ?, ?, ?, ?)\n `, [blend.id, component.block_id, component.block_name, component.varietal, component.percentage]);\n }\n}\n\nexport async function updateWineBlendResults(\n id: string, \n results: { sensory_feedback: string; market_performance: number; would_make_again: boolean }\n): Promise {\n await sqlite.execute(`\n UPDATE wine_blends \n SET actual_results = ?\n WHERE id = ?\n `, [JSON.stringify(results), id]);\n}\n\n// Chemical Analysis Queries\nexport async function getChemicalAnalysesByBlockId(blockId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM chemical_analyses WHERE block_id = ? ORDER BY analysis_date DESC\n `, [blockId]);\n return result.rows as ChemicalAnalysis[];\n}\n\nexport async function createChemicalAnalysis(analysis: Omit): Promise {\n await sqlite.execute(`\n INSERT INTO chemical_analyses \n (block_id, analysis_date, alcohol, ph, total_acidity, volatile_acidity, \n tannins, residual_sugar, sulfites, color_intensity, phenolic_compounds, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, datetime('now'))\n `, [\n analysis.block_id, analysis.analysis_date, analysis.alcohol, analysis.ph,\n analysis.total_acidity, analysis.volatile_acidity, analysis.tannins,\n analysis.residual_sugar, analysis.sulfites, analysis.color_intensity || null,\n analysis.phenolic_compounds || null\n ]);\n}\n\n// Uploaded Data Queries\nexport async function getAllUploadedData(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM uploaded_data ORDER BY uploaded_at DESC\");\n return result.rows as UploadedData[];\n}\n\nexport async function createUploadedDataRecord(data: Omit): Promise {\n await sqlite.execute(`\n INSERT INTO uploaded_data (id, filename, type, uploaded_at, processed, records_count)\n VALUES (?, ?, ?, datetime('now'), ?, ?)\n `, [data.id, data.filename, data.type, data.processed, data.records_count || null]);\n}\n\nexport async function markDataAsProcessed(id: string, recordsCount: number): Promise {\n await sqlite.execute(`\n UPDATE uploaded_data \n SET processed = TRUE, records_count = ?\n WHERE id = ?\n `, [recordsCount, id]);\n}",[],[152,207,199],"database","a5384978-6df1-11f0-9f5b-0224a6c84d84","migrations.ts","a5384a36-6df1-11f0-9f5b-0224a6c84d84",["D",1753954507477],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database schema for Terroir Harmony AI Blend Designer\nexport async function runMigrations() {\n console.log(\"Running database migrations...\");\n\n // Vineyard blocks table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS vineyard_blocks (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n varietal TEXT NOT NULL,\n vintage INTEGER NOT NULL,\n alcohol REAL NOT NULL,\n ph REAL NOT NULL,\n acidity REAL NOT NULL,\n tannins REAL NOT NULL,\n sugar REAL NOT NULL,\n notes TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Wine blends table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS wine_blends (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n target_style TEXT NOT NULL,\n predicted_sensory TEXT NOT NULL, -- JSON\n market_analysis TEXT NOT NULL, -- JSON\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n winemaker_notes TEXT,\n actual_results TEXT -- JSON\n )\n `);\n\n // Blend components table (many-to-many relationship)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS blend_components (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n blend_id TEXT NOT NULL,\n block_id TEXT NOT NULL,\n block_name TEXT NOT NULL,\n varietal TEXT NOT NULL,\n percentage REAL NOT NULL,\n FOREIGN KEY (blend_id) REFERENCES wine_blends(id),\n FOREIGN KEY (block_id) REFERENCES vineyard_blocks(id)\n )\n `);\n\n // Chemical analyses table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS chemical_analyses (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n block_id TEXT NOT NULL,\n analysis_date TEXT NOT NULL,\n alcohol REAL NOT NULL,\n ph REAL NOT NULL,\n total_acidity REAL NOT NULL,\n volatile_acidity REAL NOT NULL,\n tannins REAL NOT NULL,\n residual_sugar REAL NOT NULL,\n sulfites REAL NOT NULL,\n color_intensity REAL,\n phenolic_compounds REAL,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (block_id) REFERENCES vineyard_blocks(id)\n )\n `);\n\n // Uploaded data tracking table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS uploaded_data (\n id TEXT PRIMARY KEY,\n filename TEXT NOT NULL,\n type TEXT NOT NULL,\n uploaded_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n processed BOOLEAN DEFAULT FALSE,\n records_count INTEGER\n )\n `);\n\n console.log(\"Database migrations completed successfully\");\n}\n\n// Sample data insertion\nexport async function insertSampleData() {\n console.log(\"Inserting sample data...\");\n\n // Sample vineyard blocks\n const sampleBlocks = [\n {\n id: \"block-001\",\n name: \"Block A - Hillside\",\n varietal: \"Cabernet Sauvignon\",\n vintage: 2023,\n alcohol: 14.2,\n ph: 3.6,\n acidity: 6.2,\n tannins: 8.5,\n sugar: 0.8,\n notes: \"South-facing slope, excellent drainage\"\n },\n {\n id: \"block-002\", \n name: \"Block B - Valley Floor\",\n varietal: \"Merlot\",\n vintage: 2023,\n alcohol: 13.8,\n ph: 3.7,\n acidity: 5.8,\n tannins: 6.2,\n sugar: 1.2,\n notes: \"Rich alluvial soil, moderate sun exposure\"\n },\n {\n id: \"block-003\",\n name: \"Block C - Ridge\",\n varietal: \"Cabernet Franc\",\n vintage: 2023,\n alcohol: 13.5,\n ph: 3.5,\n acidity: 6.8,\n tannins: 7.1,\n sugar: 0.5,\n notes: \"High elevation, intense sun, rocky soil\"\n },\n {\n id: \"block-004\",\n name: \"Block D - East Slope\",\n varietal: \"Petit Verdot\",\n vintage: 2023,\n alcohol: 15.1,\n ph: 3.4,\n acidity: 7.2,\n tannins: 9.8,\n sugar: 0.3,\n notes: \"Morning sun, afternoon shade, concentrated fruit\"\n }\n ];\n\n for (const block of sampleBlocks) {\n await sqlite.execute(`\n INSERT OR REPLACE INTO vineyard_blocks \n (id, name, varietal, vintage, alcohol, ph, acidity, tannins, sugar, notes, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, datetime('now'))\n `, [\n block.id, block.name, block.varietal, block.vintage,\n block.alcohol, block.ph, block.acidity, block.tannins, \n block.sugar, block.notes\n ]);\n }\n\n console.log(\"Sample data inserted successfully\");\n}",[],[152,207,209],"a53859b8-6df1-11f0-9f5b-0224a6c84d84",["D",1753954507477],[169,170],[152,207],["D",1753954507477],[168,171],[152],["D",1753954375629],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":259,"_260":261,"_262":263,"_264":25,"_265":25,"_266":25,"_267":64,"_268":-5,"_269":-7,"_270":-7,"_271":141,"_272":25,"_273":25,"_274":-5,"_275":25,"_276":25,"_277":25,"_278":-5},"ENV",{"_230":231,"_232":233,"_234":92,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","81405aa0531e90dfbb71a5bf473aaa0cf4c8702f","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 · v5