Application Error

Failed to load the application. Please try again later.

${error.message}

\n \n \n `, 500);\n }\n});\n\n// Health check endpoint\napp.get(\"/health\", async (c) => {\n try {\n await initializeDatabase();\n const blocks = await getAllVineyardBlocks();\n \n return c.json({\n status: \"healthy\",\n timestamp: new Date().toISOString(),\n database: \"connected\",\n vineyardBlocks: blocks.length\n });\n } catch (error) {\n return c.json({\n status: \"unhealthy\",\n timestamp: new Date().toISOString(),\n error: error.message\n }, 500);\n }\n});\n\n// API documentation endpoint\napp.get(\"/api\", (c) => {\n const apiDocs = {\n name: \"Terroir Harmony AI Blend Designer API\",\n version: \"1.0.0\",\n endpoints: {\n \"GET /\": \"Main application interface\",\n \"GET /health\": \"Health check\",\n \"GET /api\": \"This documentation\",\n \"POST /api/blends/generate\": \"Generate new wine blend\",\n \"GET /api/blends\": \"List all wine blends\",\n \"GET /api/blends/:id\": \"Get specific wine blend\",\n \"PUT /api/blends/:id/results\": \"Update blend with actual results\",\n \"GET /api/data/vineyard-blocks\": \"Get all vineyard blocks\",\n \"POST /api/data/vineyard-blocks\": \"Create new vineyard block\",\n \"GET /api/data/vineyard-blocks/:id/analyses\": \"Get chemical analyses for block\",\n \"POST /api/data/upload\": \"Upload data files\",\n \"GET /api/data/uploads\": \"Get upload history\",\n \"GET /api/data/sample\": \"Get sample data for testing\"\n }\n };\n \n return c.json(apiDocs);\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[152,230],[152],{"_103":240,"_95":241,"_153":242,"_155":-5,"_156":138,"_157":243,"_159":160,"_105":244,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":245,"_98":255},"799cf40c-6df2-11f0-89f1-0224a6c84d84","data","bce86373-7a58-4de7-889b-bab4db9b4a0b",16,["D",1753954863822],[246],{"_103":247,"_95":248,"_153":249,"_155":242,"_156":138,"_157":243,"_159":160,"_105":250,"_100":32,"_162":251,"_164":252,"_165":22,"_166":-5,"_167":253,"_98":254},"799ce7a0-6df2-11f0-89f1-0224a6c84d84","sample_data.json","799ce89a-6df2-11f0-89f1-0224a6c84d84",["D",1753954863822],"file","{\n \"vineyard_blocks\": [\n {\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, concentrated fruit\"\n },\n {\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, elegant structure\"\n }\n ],\n \"chemical_analyses\": [\n {\n \"block_id\": \"block-001\",\n \"analysis_date\": \"2023-10-15\",\n \"alcohol\": 14.2,\n \"ph\": 3.6,\n \"total_acidity\": 6.2,\n \"volatile_acidity\": 0.4,\n \"tannins\": 8.5,\n \"residual_sugar\": 0.8,\n \"sulfites\": 45,\n \"color_intensity\": 12.5,\n \"phenolic_compounds\": 2800\n }\n ],\n \"sensory_evaluations\": [\n {\n \"wine_id\": \"blend-001\",\n \"taster_id\": \"winemaker-1\",\n \"aroma_notes\": [\"blackcurrant\", \"cedar\", \"vanilla\", \"tobacco\"],\n \"taste_notes\": [\"dark fruit\", \"structured tannins\", \"balanced acidity\"],\n \"mouthfeel\": [\"full-bodied\", \"smooth\", \"lingering\"],\n \"overall_score\": 8.5,\n \"notes\": \"Excellent balance, ready for aging\"\n }\n ],\n \"market_data\": [\n {\n \"wine_style\": \"Bordeaux-style Red Blend\",\n \"average_price\": 45.00,\n \"consumer_rating\": 4.2,\n \"critic_score\": 88,\n \"market_segment\": \"Premium\",\n \"target_demographic\": \"Wine enthusiasts, 35-55 years\"\n }\n ]\n}",[],[241,248],[241],{"_103":257,"_95":99,"_153":258,"_155":-5,"_156":138,"_157":259,"_159":160,"_105":260,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":261,"_98":331},"f59220ce-6df1-11f0-801c-0224a6c84d84","63dc78db-ffaa-4183-ae81-6745d55ed542",9,["D",1753954642288],[262,314,322],{"_103":263,"_95":264,"_153":265,"_155":258,"_156":138,"_157":266,"_159":160,"_105":267,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":268,"_98":313},"064dad48-6df2-11f0-8a19-0224a6c84d84","components","e1c4b4bb-13f1-4c80-9c55-b350d57d1038",11,["D",1753954670364],[269,277,286,295,304],{"_103":270,"_95":271,"_153":272,"_155":265,"_156":138,"_157":266,"_159":160,"_105":273,"_100":32,"_162":180,"_164":274,"_165":22,"_166":-5,"_167":275,"_98":276},"064d9c7c-6df2-11f0-8a19-0224a6c84d84","App.tsx","064d9d3a-6df2-11f0-8a19-0224a6c84d84",["D",1753954670364],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { VineyardBlock, WineBlend } from \"../../shared/types.ts\";\nimport BlendGenerator from \"./BlendGenerator.tsx\";\nimport BlendHistory from \"./BlendHistory.tsx\";\nimport DataUpload from \"./DataUpload.tsx\";\nimport VineyardBlocks from \"./VineyardBlocks.tsx\";\n\ninterface AppProps {\n initialData: {\n vineyardBlocks: VineyardBlock[];\n appName: string;\n version: string;\n };\n}\n\ntype TabType = 'generator' | 'history' | 'data' | 'blocks';\n\nexport default function App({ initialData }: AppProps) {\n const [activeTab, setActiveTab] = useState('generator');\n const [vineyardBlocks, setVineyardBlocks] = useState(initialData.vineyardBlocks || []);\n const [blends, setBlends] = useState([]);\n const [loading, setLoading] = useState(false);\n\n // Load blends on component mount\n useEffect(() => {\n loadBlends();\n }, []);\n\n const loadBlends = async () => {\n try {\n const response = await fetch('/api/blends');\n if (response.ok) {\n const blendsData = await response.json();\n setBlends(blendsData);\n }\n } catch (error) {\n console.error('Error loading blends:', error);\n }\n };\n\n const loadVineyardBlocks = async () => {\n try {\n const response = await fetch('/api/data/vineyard-blocks');\n if (response.ok) {\n const blocksData = await response.json();\n setVineyardBlocks(blocksData);\n }\n } catch (error) {\n console.error('Error loading vineyard blocks:', error);\n }\n };\n\n const handleNewBlend = (newBlend: WineBlend) => {\n setBlends(prev => [newBlend, ...prev]);\n };\n\n const handleDataUploaded = () => {\n loadVineyardBlocks();\n };\n\n const tabs = [\n { id: 'generator' as TabType, name: 'Blend Generator', icon: '🍷' },\n { id: 'history' as TabType, name: 'Blend History', icon: '📚' },\n { id: 'blocks' as TabType, name: 'Vineyard Blocks', icon: '🍇' },\n { id: 'data' as TabType, name: 'Data Management', icon: '📊' }\n ];\n\n return (\n

\n {/* Header */}\n

🍷 Terroir Harmony AI

Blend Designer v{initialData.version}

\n {vineyardBlocks.length} Vineyard Blocks • {blends.length} Blends\n

\n\n {/* Navigation Tabs */}\n

\n {tabs.map((tab) => (\n setActiveTab(tab.id)}\n className={`py-4 px-1 border-b-2 font-medium text-sm transition-colors ${\n activeTab === tab.id\n ? 'border-red-800 text-red-800'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n {tab.icon}\n {tab.name}\n \n ))}\n

\n\n {/* Main Content */}\n

\n {loading && (\n

\n Processing...\n

\n )}\n\n {activeTab === 'generator' && (\n \n )}\n\n {activeTab === 'history' && (\n \n )}\n\n {activeTab === 'blocks' && (\n \n )}\n\n {activeTab === 'data' && (\n \n )}\n

\n\n {/* Footer */}\n \n

\n );\n}",[],[99,264,271],{"_103":278,"_95":279,"_153":280,"_155":265,"_156":138,"_157":281,"_159":160,"_105":282,"_100":32,"_162":180,"_164":283,"_165":22,"_166":-5,"_167":284,"_98":285},"22ec0e04-6df2-11f0-9191-0224a6c84d84","BlendGenerator.tsx","22ec0eb8-6df2-11f0-9191-0224a6c84d84",12,["D",1753954718381],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { VineyardBlock, WineBlend, BlendGenerationRequest } from \"../../shared/types.ts\";\n\ninterface BlendGeneratorProps {\n vineyardBlocks: VineyardBlock[];\n onNewBlend: (blend: WineBlend) => void;\n setLoading: (loading: boolean) => void;\n}\n\nexport default function BlendGenerator({ vineyardBlocks, onNewBlend, setLoading }: BlendGeneratorProps) {\n const [targetStyle, setTargetStyle] = useState('');\n const [selectedBlocks, setSelectedBlocks] = useState([]);\n const [preferences, setPreferences] = useState({\n maxComponents: 4,\n targetAlcohol: 14.0,\n styleNotes: ''\n });\n const [generatedBlend, setGeneratedBlend] = useState(null);\n const [reasoning, setReasoning] = useState('');\n const [error, setError] = useState('');\n\n const wineStyles = [\n 'Bordeaux-style Red Blend',\n 'Rhône-style Red Blend',\n 'Super Tuscan Style',\n 'Fruit-forward Early Drinking',\n 'Age-worthy Complex Blend',\n 'Light and Elegant',\n 'Bold and Structured',\n 'Smooth and Approachable',\n 'Premium Reserve Style',\n 'Everyday Drinking Wine'\n ];\n\n const handleBlockSelection = (blockId: string) => {\n setSelectedBlocks(prev => \n prev.includes(blockId) \n ? prev.filter(id => id !== blockId)\n : [...prev, blockId]\n );\n };\n\n const generateBlend = async () => {\n if (!targetStyle || selectedBlocks.length === 0) {\n setError('Please select a target style and at least one vineyard block');\n return;\n }\n\n setError('');\n setLoading(true);\n\n try {\n const request: BlendGenerationRequest = {\n target_style: targetStyle,\n available_blocks: selectedBlocks,\n preferences: {\n max_components: preferences.maxComponents,\n target_alcohol: preferences.targetAlcohol,\n style_notes: preferences.styleNotes\n }\n };\n\n const response = await fetch('/api/blends/generate', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(request)\n });\n\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n\n const result = await response.json();\n setGeneratedBlend(result.blend);\n setReasoning(result.reasoning);\n onNewBlend(result.blend);\n } catch (error) {\n console.error('Error generating blend:', error);\n setError('Failed to generate blend. Please try again.');\n } finally {\n setLoading(false);\n }\n };\n\n const resetForm = () => {\n setTargetStyle('');\n setSelectedBlocks([]);\n setPreferences({\n maxComponents: 4,\n targetAlcohol: 14.0,\n styleNotes: ''\n });\n setGeneratedBlend(null);\n setReasoning('');\n setError('');\n };\n\n return (\n

🎯 Generate New Wine Blend

\n \n {error && (\n

{error}

\n )}\n\n

\n {/* Left Column - Input Form */}\n

\n {/* Target Style */}\n

\n \n Target Wine Style *\n \n setTargetStyle(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n >\n \n {wineStyles.map(style => (\n \n ))}\n \n

\n\n {/* Available Vineyard Blocks */}\n

\n \n Available Vineyard Blocks * ({selectedBlocks.length} selected)\n \n

\n {vineyardBlocks.map(block => (\n \n handleBlockSelection(block.id)}\n className=\"mt-1 h-4 w-4 text-red-600 focus:ring-red-500 border-gray-300 rounded\"\n />\n

\n {block.name} ({block.varietal})\n

\n {block.vintage} • {block.alcohol}% ABV • pH {block.ph} • Tannins {block.tannins}/10\n

\n {block.notes && (\n

{block.notes}

\n )}\n

\n \n ))}\n

\n\n {/* Preferences */}\n

Blending Preferences

\n \n

\n \n Max Components\n \n setPreferences(prev => ({\n ...prev,\n maxComponents: parseInt(e.target.value) || 4\n }))}\n className=\"w-full px-2 py-1 text-sm border border-gray-300 rounded focus:outline-none focus:ring-1 focus:ring-red-500\"\n />\n

\n \n

\n \n Target Alcohol %\n \n setPreferences(prev => ({\n ...prev,\n targetAlcohol: parseFloat(e.target.value) || 14.0\n }))}\n className=\"w-full px-2 py-1 text-sm border border-gray-300 rounded focus:outline-none focus:ring-1 focus:ring-red-500\"\n />\n

\n \n

\n \n Additional Style Notes\n \n setPreferences(prev => ({\n ...prev,\n styleNotes: e.target.value\n }))}\n placeholder=\"e.g., emphasize fruit character, minimize oak influence...\"\n className=\"w-full px-2 py-1 text-sm border border-gray-300 rounded focus:outline-none focus:ring-1 focus:ring-red-500\"\n rows={2}\n />\n

\n\n {/* Action Buttons */}\n

\n \n 🧪 Generate Blend\n \n \n Reset\n \n

\n\n {/* Right Column - Generated Blend */}\n

\n {generatedBlend ? (\n

\n 🍷 {generatedBlend.name}\n

\n\n {/* Blend Components */}\n

Blend Composition

\n {generatedBlend.components.map((component, index) => (\n

\n \n {component.block_name} ({component.varietal})\n \n \n {component.percentage}%\n \n

\n ))}\n

\n\n {/* Predicted Sensory Profile */}\n

Predicted Sensory Profile

\n Aroma: {generatedBlend.predicted_sensory.aroma.join(', ')}\n

\n Taste: {generatedBlend.predicted_sensory.taste.join(', ')}\n

\n Mouthfeel: {generatedBlend.predicted_sensory.mouthfeel.join(', ')}\n

\n Finish: {generatedBlend.predicted_sensory.finish}\n

\n Overall: {generatedBlend.predicted_sensory.overall_notes}\n

\n\n {/* Market Analysis */}\n

Market Analysis

\n Appeal Score:\n \n {generatedBlend.market_analysis.appeal_score}/10\n \n

\n Price Point: {generatedBlend.market_analysis.price_point}\n

\n Target Market: {generatedBlend.market_analysis.target_market}\n

\n Positioning: {generatedBlend.market_analysis.market_positioning}\n

\n ) : (\n

🍷

Configure your blend parameters and click \"Generate Blend\" to see AI recommendations

\n )}\n

\n\n {/* AI Reasoning */}\n {reasoning && (\n

🤖 AI Reasoning

\n {reasoning}\n

\n )}\n

\n );\n}",[],[99,264,279],{"_103":287,"_95":288,"_153":289,"_155":265,"_156":138,"_157":290,"_159":160,"_105":291,"_100":32,"_162":180,"_164":292,"_165":22,"_166":-5,"_167":293,"_98":294},"3b5d37d8-6df2-11f0-b071-0224a6c84d84","BlendHistory.tsx","3b5d3878-6df2-11f0-b071-0224a6c84d84",13,["D",1753954759387],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { WineBlend } from \"../../shared/types.ts\";\n\ninterface BlendHistoryProps {\n blends: WineBlend[];\n onBlendsUpdate: () => void;\n}\n\nexport default function BlendHistory({ blends, onBlendsUpdate }: BlendHistoryProps) {\n const [selectedBlend, setSelectedBlend] = useState(null);\n const [showFeedbackModal, setShowFeedbackModal] = useState(false);\n const [feedback, setFeedback] = useState({\n sensory_feedback: '',\n market_performance: 5,\n would_make_again: true\n });\n\n const openFeedbackModal = (blend: WineBlend) => {\n setSelectedBlend(blend);\n setFeedback({\n sensory_feedback: blend.actual_results?.sensory_feedback || '',\n market_performance: blend.actual_results?.market_performance || 5,\n would_make_again: blend.actual_results?.would_make_again ?? true\n });\n setShowFeedbackModal(true);\n };\n\n const submitFeedback = async () => {\n if (!selectedBlend) return;\n\n try {\n const response = await fetch(`/api/blends/${selectedBlend.id}/results`, {\n method: 'PUT',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(feedback)\n });\n\n if (response.ok) {\n setShowFeedbackModal(false);\n setSelectedBlend(null);\n onBlendsUpdate();\n }\n } catch (error) {\n console.error('Error submitting feedback:', error);\n }\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n const getAppealScoreColor = (score: number) => {\n if (score >= 8) return 'text-green-600';\n if (score >= 6) return 'text-yellow-600';\n return 'text-red-600';\n };\n\n return (\n

📚 Blend History

\n {blends.length} blend{blends.length !== 1 ? 's' : ''} created\n

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

🍷

No blends created yet. Start by generating your first blend!

\n ) : (\n

\n {blends.map((blend) => (\n

{blend.name}

\n \n {blend.market_analysis.appeal_score}/10\n \n

\n\n

Target Style:

{blend.target_style}

\n\n

Components:

\n {blend.components.map((component, index) => (\n

\n {component.varietal}\n {component.percentage}%\n

\n ))}\n

\n\n

Predicted Profile:

\n {blend.predicted_sensory.aroma.slice(0, 3).join(', ')}\n {blend.predicted_sensory.aroma.length > 3 && '...'}\n

\n\n

Market Position:

\n \n {blend.market_analysis.price_point}\n \n

\n\n {blend.actual_results && (\n

Actual Results:

\n Performance: {blend.actual_results.market_performance}/10\n \n {blend.actual_results.would_make_again ? '✓ Would make again' : '✗ Would not repeat'}\n \n

\n )}\n\n

\n Created: {formatDate(blend.created_at)}\n

\n\n

\n setSelectedBlend(selectedBlend?.id === blend.id ? null : blend)}\n className=\"flex-1 text-xs bg-white border border-gray-300 text-gray-700 px-3 py-1 rounded hover:bg-gray-50 transition-colors\"\n >\n {selectedBlend?.id === blend.id ? 'Hide Details' : 'View Details'}\n \n openFeedbackModal(blend)}\n className=\"text-xs bg-red-800 text-white px-3 py-1 rounded hover:bg-red-900 transition-colors\"\n >\n {blend.actual_results ? 'Update' : 'Add'} Feedback\n \n

\n\n {/* Expanded Details */}\n {selectedBlend?.id === blend.id && (\n

\n Detailed Sensory Profile:\n

Aroma: {blend.predicted_sensory.aroma.join(', ')}

Taste: {blend.predicted_sensory.taste.join(', ')}

Mouthfeel: {blend.predicted_sensory.mouthfeel.join(', ')}

Finish: {blend.predicted_sensory.finish}

Overall: {blend.predicted_sensory.overall_notes}

\n \n

\n Market Analysis:\n

Target: {blend.market_analysis.target_market}

Consumer: {blend.market_analysis.consumer_profile}

Positioning: {blend.market_analysis.market_positioning}

\n\n {blend.winemaker_notes && (\n

\n Winemaker Notes:\n

\n {blend.winemaker_notes}\n

\n )}\n

\n ))}\n

\n )}\n

\n\n {/* Feedback Modal */}\n {showFeedbackModal && selectedBlend && (\n

\n Feedback for {selectedBlend.name}\n

\n\n

\n \n Sensory Feedback\n \n setFeedback(prev => ({ ...prev, sensory_feedback: e.target.value }))}\n placeholder=\"How did the actual wine compare to predictions? Describe the aroma, taste, and overall impression...\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n rows={4}\n />\n

\n\n

\n \n Market Performance (1-10)\n \n setFeedback(prev => ({ ...prev, market_performance: parseInt(e.target.value) }))}\n className=\"w-full\"\n />\n

\n Poor (1)\n {feedback.market_performance}\n Excellent (10)\n

\n\n

\n \n setFeedback(prev => ({ ...prev, would_make_again: e.target.checked }))}\n className=\"h-4 w-4 text-red-600 focus:ring-red-500 border-gray-300 rounded\"\n />\n \n Would make this blend again\n \n \n

\n\n

\n \n Save Feedback\n \n setShowFeedbackModal(false)}\n className=\"px-4 py-2 border border-gray-300 text-gray-700 rounded-md hover:bg-gray-50 transition-colors\"\n >\n Cancel\n \n

\n )}\n

\n );\n}",[],[99,264,288],{"_103":296,"_95":297,"_153":298,"_155":265,"_156":138,"_157":299,"_159":160,"_105":300,"_100":32,"_162":180,"_164":301,"_165":22,"_166":-5,"_167":302,"_98":303},"70c05d74-6df2-11f0-8df5-0224a6c84d84","DataUpload.tsx","70c05e0a-6df2-11f0-8df5-0224a6c84d84",15,["D",1753954848958],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { UploadedData } from \"../../shared/types.ts\";\n\ninterface DataUploadProps {\n onDataUploaded: () => void;\n}\n\nexport default function DataUpload({ onDataUploaded }: DataUploadProps) {\n const [uploads, setUploads] = useState([]);\n const [uploading, setUploading] = useState(false);\n const [error, setError] = useState('');\n const [sampleData, setSampleData] = useState(null);\n\n useEffect(() => {\n loadUploads();\n loadSampleData();\n }, []);\n\n const loadUploads = async () => {\n try {\n const response = await fetch('/api/data/uploads');\n if (response.ok) {\n const uploadsData = await response.json();\n setUploads(uploadsData);\n }\n } catch (error) {\n console.error('Error loading uploads:', error);\n }\n };\n\n const loadSampleData = async () => {\n try {\n const response = await fetch('/api/data/sample');\n if (response.ok) {\n const data = await response.json();\n setSampleData(data);\n }\n } catch (error) {\n console.error('Error loading sample data:', error);\n }\n };\n\n const handleFileUpload = async (event: React.ChangeEvent, dataType: string) => {\n const file = event.target.files?.[0];\n if (!file) return;\n\n setUploading(true);\n setError('');\n\n try {\n const formData = new FormData();\n formData.append('file', file);\n formData.append('type', dataType);\n\n const response = await fetch('/api/data/upload', {\n method: 'POST',\n body: formData\n });\n\n if (response.ok) {\n const result = await response.json();\n await loadUploads();\n onDataUploaded();\n \n // Reset file input\n event.target.value = '';\n } else {\n const errorData = await response.json();\n setError(errorData.error || 'Upload failed');\n }\n } catch (error) {\n console.error('Error uploading file:', error);\n setError('Upload failed. Please try again.');\n } finally {\n setUploading(false);\n }\n };\n\n const downloadSampleCSV = (csvData: string, filename: string) => {\n const blob = new Blob([csvData], { type: 'text/csv' });\n const url = window.URL.createObjectURL(blob);\n const a = document.createElement('a');\n a.href = url;\n a.download = filename;\n document.body.appendChild(a);\n a.click();\n document.body.removeChild(a);\n window.URL.revokeObjectURL(url);\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n const getTypeIcon = (type: string) => {\n switch (type) {\n case 'chemical_analysis': return '🧪';\n case 'sensory_evaluation': return '👃';\n case 'market_data': return '📈';\n default: return '📄';\n }\n };\n\n const getTypeColor = (type: string) => {\n switch (type) {\n case 'chemical_analysis': return 'bg-blue-100 text-blue-800';\n case 'sensory_evaluation': return 'bg-green-100 text-green-800';\n case 'market_data': return 'bg-purple-100 text-purple-800';\n default: return 'bg-gray-100 text-gray-800';\n }\n };\n\n return (\n

\n {/* Upload Section */}\n

📊 Data Management

\n \n {error && (\n

{error}

\n )}\n\n

\n {/* Chemical Analysis Upload */}\n

🧪

Chemical Analysis

\n Upload CSV files with chemical analysis data for vineyard blocks\n

\n \n handleFileUpload(e, 'chemical_analysis')}\n className=\"hidden\"\n disabled={uploading}\n />\n \n {uploading ? 'Uploading...' : 'Choose File'}\n \n \n

\n\n {/* Sensory Evaluation Upload */}\n

👃

Sensory Evaluation

\n Upload tasting notes and sensory evaluation data\n

\n \n handleFileUpload(e, 'sensory_evaluation')}\n className=\"hidden\"\n disabled={uploading}\n />\n \n {uploading ? 'Uploading...' : 'Choose File'}\n \n \n

\n\n {/* Market Data Upload */}\n

📈

Market Data

\n Upload consumer reviews, sales data, and market analysis\n

\n \n handleFileUpload(e, 'market_data')}\n className=\"hidden\"\n disabled={uploading}\n />\n \n {uploading ? 'Uploading...' : 'Choose File'}\n \n \n

\n\n {/* Sample Data Section */}\n {sampleData && (\n

📋 Sample Data Templates

\n Download these sample templates to understand the expected data format for uploads.\n

\n \n

Chemical Analysis CSV

\n Sample format for chemical analysis data with all required columns.\n

\n downloadSampleCSV(sampleData.chemical_analysis_csv, 'chemical_analysis_sample.csv')}\n className=\"bg-blue-600 text-white px-3 py-1 rounded text-sm hover:bg-blue-700 transition-colors\"\n >\n Download Sample CSV\n \n

\n \n

Sample Vineyard Block

\n Example vineyard block data structure for reference.\n

\n {JSON.stringify(sampleData.vineyard_blocks[0], null, 2).substring(0, 100)}...\n

\n )}\n\n {/* Upload History */}\n

📁 Upload History

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

📄

No files uploaded yet. Start by uploading your first dataset!

\n ) : (\n

\n {uploads.map((upload) => (\n

\n {getTypeIcon(upload.type)}\n

{upload.filename}

\n Uploaded: {formatDate(upload.uploaded_at)}\n {upload.records_count && (\n • {upload.records_count} records processed\n )}\n

\n \n

\n \n {upload.type.replace('_', ' ')}\n \n \n {upload.processed ? '✓ Processed' : '⏳ Processing'}\n \n

\n ))}\n

\n )}\n

\n\n {/* Data Format Guidelines */}\n

📖 Data Format Guidelines

\n \n

🧪 Chemical Analysis Files

Required columns: block_id, analysis_date, alcohol, ph, total_acidity, tannins, residual_sugar

Optional columns: volatile_acidity, sulfites, color_intensity, phenolic_compounds

Format: CSV with headers in the first row

\n \n

👃 Sensory Evaluation Files

Supported formats: CSV, JSON

Should include: wine_id, taster_id, aroma_notes, taste_notes, overall_score

Notes: Structured tasting notes help improve AI predictions

\n \n

📈 Market Data Files

Can include: consumer_reviews, critic_scores, sales_data, price_points

Supported formats: CSV, JSON, Excel

Purpose: Helps AI understand market preferences and positioning

\n );\n}",[],[99,264,297],{"_103":305,"_95":306,"_153":307,"_155":265,"_156":138,"_157":308,"_159":160,"_105":309,"_100":32,"_162":180,"_164":310,"_165":22,"_166":-5,"_167":311,"_98":312},"55e69aa4-6df2-11f0-9de5-0224a6c84d84","VineyardBlocks.tsx","55e69b6c-6df2-11f0-9de5-0224a6c84d84",14,["D",1753954803910],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { VineyardBlock } from \"../../shared/types.ts\";\n\ninterface VineyardBlocksProps {\n vineyardBlocks: VineyardBlock[];\n onBlocksUpdate: () => void;\n}\n\nexport default function VineyardBlocks({ vineyardBlocks, onBlocksUpdate }: VineyardBlocksProps) {\n const [showAddModal, setShowAddModal] = useState(false);\n const [newBlock, setNewBlock] = useState({\n name: '',\n varietal: '',\n vintage: new Date().getFullYear(),\n alcohol: 14.0,\n ph: 3.6,\n acidity: 6.0,\n tannins: 7.0,\n sugar: 1.0,\n notes: ''\n });\n const [error, setError] = useState('');\n\n const varietals = [\n 'Cabernet Sauvignon',\n 'Merlot',\n 'Cabernet Franc',\n 'Petit Verdot',\n 'Malbec',\n 'Syrah',\n 'Grenache',\n 'Mourvèdre',\n 'Sangiovese',\n 'Nebbiolo',\n 'Pinot Noir',\n 'Chardonnay',\n 'Sauvignon Blanc',\n 'Other'\n ];\n\n const handleAddBlock = async () => {\n if (!newBlock.name || !newBlock.varietal) {\n setError('Name and varietal are required');\n return;\n }\n\n setError('');\n\n try {\n const response = await fetch('/api/data/vineyard-blocks', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(newBlock)\n });\n\n if (response.ok) {\n setShowAddModal(false);\n setNewBlock({\n name: '',\n varietal: '',\n vintage: new Date().getFullYear(),\n alcohol: 14.0,\n ph: 3.6,\n acidity: 6.0,\n tannins: 7.0,\n sugar: 1.0,\n notes: ''\n });\n onBlocksUpdate();\n } else {\n setError('Failed to create vineyard block');\n }\n } catch (error) {\n console.error('Error creating block:', error);\n setError('Failed to create vineyard block');\n }\n };\n\n const getTanninLevel = (tannins: number) => {\n if (tannins >= 8) return { label: 'High', color: 'text-red-600' };\n if (tannins >= 6) return { label: 'Medium', color: 'text-yellow-600' };\n return { label: 'Low', color: 'text-green-600' };\n };\n\n const getAcidityLevel = (acidity: number) => {\n if (acidity >= 7) return { label: 'High', color: 'text-blue-600' };\n if (acidity >= 5.5) return { label: 'Medium', color: 'text-yellow-600' };\n return { label: 'Low', color: 'text-green-600' };\n };\n\n return (\n

🍇 Vineyard Blocks

\n setShowAddModal(true)}\n className=\"bg-red-800 text-white px-4 py-2 rounded-md hover:bg-red-900 transition-colors\"\n >\n + Add Block\n \n

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

🍇

No vineyard blocks defined yet.

\n setShowAddModal(true)}\n className=\"bg-red-800 text-white px-4 py-2 rounded-md hover:bg-red-900 transition-colors\"\n >\n Add Your First Block\n \n

\n ) : (\n

\n {vineyardBlocks.map((block) => (\n

{block.name}

\n \n {block.vintage}\n \n

\n\n

\n {block.varietal}\n

\n\n

Alcohol

{block.alcohol}%

{block.ph}

Acidity

\n {block.acidity} g/L\n \n ({getAcidityLevel(block.acidity).label})\n \n

Tannins

\n {block.tannins}/10\n \n ({getTanninLevel(block.tannins).label})\n \n

\n\n

Residual Sugar

{block.sugar} g/L

\n\n {block.notes && (\n

Notes

{block.notes}

\n )}\n\n

\n Added: {new Date(block.created_at).toLocaleDateString()}\n

\n ))}\n

\n )}\n

\n\n {/* Add Block Modal */}\n {showAddModal && (\n

\n Add New Vineyard Block\n

\n\n {error && (\n

{error}

\n )}\n\n

\n \n Block Name *\n \n setNewBlock(prev => ({ ...prev, name: e.target.value }))}\n placeholder=\"e.g., Block F - North Hill\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n />\n

\n\n

\n \n Varietal *\n \n setNewBlock(prev => ({ ...prev, varietal: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n >\n \n {varietals.map(varietal => (\n \n ))}\n \n

\n\n

\n \n Vintage\n \n setNewBlock(prev => ({ ...prev, vintage: parseInt(e.target.value) || new Date().getFullYear() }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n />\n

\n\n

\n \n Alcohol %\n \n setNewBlock(prev => ({ ...prev, alcohol: parseFloat(e.target.value) || 14.0 }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n />\n

\n\n

\n \n pH\n \n setNewBlock(prev => ({ ...prev, ph: parseFloat(e.target.value) || 3.6 }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n />\n

\n\n

\n \n Acidity (g/L)\n \n setNewBlock(prev => ({ ...prev, acidity: parseFloat(e.target.value) || 6.0 }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n />\n

\n\n

\n \n Tannins (1-10)\n \n setNewBlock(prev => ({ ...prev, tannins: parseFloat(e.target.value) || 7.0 }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n />\n

\n\n

\n \n Sugar (g/L)\n \n setNewBlock(prev => ({ ...prev, sugar: parseFloat(e.target.value) || 1.0 }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n />\n

\n\n

\n \n Notes\n \n setNewBlock(prev => ({ ...prev, notes: e.target.value }))}\n placeholder=\"Terroir characteristics, harvest notes, special conditions...\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-red-500\"\n rows={3}\n />\n

\n\n

\n \n Add Block\n \n {\n setShowAddModal(false);\n setError('');\n }}\n className=\"px-4 py-2 border border-gray-300 text-gray-700 rounded-md hover:bg-gray-50 transition-colors\"\n >\n Cancel\n \n

\n )}\n

\n );\n}",[],[99,264,306],[99,264],{"_103":315,"_95":316,"_153":317,"_155":258,"_156":138,"_157":259,"_159":160,"_105":318,"_100":32,"_162":251,"_164":319,"_165":22,"_166":-5,"_167":320,"_98":321},"f59213e0-6df1-11f0-801c-0224a6c84d84","index.html","f59214bc-6df1-11f0-801c-0224a6c84d84",["D",1753954642288],"\n\n\n \n \n Terroir Harmony AI Blend Designer\n \n \n \n\n\n

\n \n \n \n \n \n \n\n",[],[99,316],{"_103":323,"_95":324,"_153":325,"_155":258,"_156":138,"_157":326,"_159":160,"_105":327,"_100":32,"_162":180,"_164":328,"_165":22,"_166":-5,"_167":329,"_98":330},"f89f23a2-6df1-11f0-a9ed-0224a6c84d84","index.tsx","f89f2442-6df1-11f0-a9ed-0224a6c84d84",10,["D",1753954647412],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } 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\nconst initialData = (window as any).__INITIAL_DATA__ || {};\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[99,324],[99],{"_103":333,"_95":334,"_153":335,"_155":-5,"_156":138,"_157":336,"_159":160,"_105":337,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":338,"_98":347},"9884d912-6df1-11f0-b74a-0224a6c84d84","shared","22eeb98e-9cf2-4bb1-a48a-7d7ff6a1de2c",2,["D",1753954486175],[339],{"_103":340,"_95":341,"_153":342,"_155":335,"_156":138,"_157":336,"_159":160,"_105":343,"_100":32,"_162":180,"_164":344,"_165":22,"_166":-5,"_167":345,"_98":346},"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}",[],[334,341],[334],{"_103":349,"_95":350,"_153":351,"_155":-5,"_156":138,"_157":352,"_159":160,"_105":353,"_100":158,"_162":251,"_164":354,"_165":22,"_166":-5,"_167":355,"_98":356},"a4e067a2-6df2-11f0-842a-0224a6c84d84","README.md","90d5b3f8-6df1-11f0-8fff-0224a6c84d84",20,["D",1753954936405],"# 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\n🚀 **Live Application**: The Terroir Harmony AI Blend Designer is now running at:\n**https://spooky--ed5633146df111f09a7d0224a6c84d84.web.val.run**\n\n### Quick Start Guide\n\n1. **Explore Vineyard Blocks**: View the pre-loaded sample vineyard blocks (4 blocks with different varietals)\n2. **Generate Your First Blend**: \n - Go to the \"Blend Generator\" tab\n - Select a target wine style (e.g., \"Bordeaux-style Red Blend\")\n - Choose 2-3 vineyard blocks\n - Click \"Generate Blend\" to get AI recommendations\n3. **Review Blend History**: See all generated blends and add feedback on actual results\n4. **Manage Data**: Upload your own chemical analysis data or add new vineyard blocks\n\n### Sample Data Included\n\nThe application comes pre-loaded with:\n- 4 sample vineyard blocks (Cabernet Sauvignon, Merlot, Cabernet Franc, Petit Verdot)\n- Chemical analysis data for each block\n- Ready-to-use blend generation capabilities\n\n## Implementation Status ✅\n\nThis Val Town implementation successfully delivers:\n\n✅ **Complete Backend API** - Fully functional REST API with all endpoints \n✅ **AI Blend Generation** - GPT-4 powered wine blend recommendations \n✅ **Database Integration** - SQLite with comprehensive wine data schema \n✅ **React Frontend** - Modern, responsive user interface \n✅ **Data Management** - File upload and processing capabilities \n✅ **Sample Data** - Pre-loaded vineyard blocks for immediate testing \n✅ **Blend History** - Track and evaluate blend performance \n✅ **Market Analysis** - AI-powered market positioning insights \n\n### Live Demo Features\n\n🍷 **Generate Wine Blends**: Select vineyard blocks and get AI-optimized blend ratios \n📊 **View Sensory Predictions**: Detailed aroma, taste, and mouthfeel forecasts \n💰 **Market Intelligence**: Consumer appeal scores and pricing recommendations \n📈 **Performance Tracking**: Record actual results vs. predictions \n🍇 **Vineyard Management**: Add and manage vineyard block data \n📁 **Data Upload**: Process chemical analysis files \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## Features Demonstration\n\n### 🧪 AI-Powered Blend Generation\n- **Input**: Target wine style + available vineyard blocks + preferences\n- **Output**: Optimized blend ratios + predicted sensory profile + market analysis\n- **AI Model**: GPT-4 with specialized wine knowledge prompts\n\n### 📊 Comprehensive Data Management\n- **Vineyard Blocks**: Store chemical analysis data for each vineyard block\n- **Upload System**: Process CSV files with chemical analysis data\n- **Sample Data**: Pre-loaded with realistic vineyard data for immediate testing\n\n### 📚 Blend History & Feedback Loop\n- **Track Results**: Record actual tasting results vs. AI predictions\n- **Performance Metrics**: Rate market performance and sensory accuracy\n- **Continuous Learning**: Feedback helps improve future recommendations\n\n### 🎯 Market Intelligence\n- **Target Market Analysis**: AI predicts consumer appeal and positioning\n- **Price Point Recommendations**: Suggests appropriate pricing strategy\n- **Consumer Profiling**: Identifies ideal customer segments\n\n## Technology Stack\n\n- **Backend:** Hono.js, SQLite, OpenAI GPT-4\n- **Frontend:** React, TailwindCSS\n- **Platform:** Val Town serverless environment\n- **Database:** SQLite with comprehensive wine data schema\n- **AI Integration:** OpenAI API for blend generation and sensory prediction",[],[350],{"_103":358,"_95":359,"_153":360,"_155":-5,"_156":138,"_157":137,"_159":160,"_105":361,"_100":158,"_162":234,"_164":362,"_165":22,"_166":-5,"_167":363,"_98":364},"bc5808e0-6df2-11f0-9c2a-0224a6c84d84","test_app.ts","b0e6ae94-6df2-11f0-a998-0224a6c84d84",["D",1753954975775],"// Simple test script to verify the Terroir Harmony AI Blend Designer is working\n\nasync function testApplication() {\n const baseUrl = 'https://spooky--ed5633146df111f09a7d0224a6c84d84.web.val.run';\n \n console.log('🧪 Testing Terroir Harmony AI Blend Designer...\\n');\n \n try {\n // Test 1: Health check\n console.log('1. Testing health endpoint...');\n const healthResponse = await fetch(`${baseUrl}/health`);\n const healthData = await healthResponse.json();\n console.log(`✅ Health check: ${healthData.status} - ${healthData.vineyardBlocks} vineyard blocks\\n`);\n \n // Test 2: Get vineyard blocks\n console.log('2. Testing vineyard blocks endpoint...');\n const blocksResponse = await fetch(`${baseUrl}/api/data/vineyard-blocks`);\n const blocks = await blocksResponse.json();\n console.log(`✅ Vineyard blocks: ${blocks.length} blocks loaded`);\n blocks.forEach((block: any) => {\n console.log(` - ${block.name} (${block.varietal}) - ${block.alcohol}% ABV`);\n });\n console.log('');\n \n // Test 3: Generate a blend\n console.log('3. Testing blend generation...');\n const blendRequest = {\n target_style: \"Premium Reserve Style\",\n available_blocks: blocks.slice(0, 3).map((b: any) => b.id),\n preferences: {\n max_components: 3,\n target_alcohol: 14.5,\n style_notes: \"Complex and age-worthy\"\n }\n };\n \n const blendResponse = await fetch(`${baseUrl}/api/blends/generate`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(blendRequest)\n });\n \n const blendResult = await blendResponse.json();\n console.log(`✅ Blend generated: \"${blendResult.blend.name}\"`);\n console.log(` Components:`);\n blendResult.blend.components.forEach((comp: any) => {\n console.log(` - ${comp.varietal}: ${comp.percentage}%`);\n });\n console.log(` Appeal Score: ${blendResult.blend.market_analysis.appeal_score}/10`);\n console.log(` Price Point: ${blendResult.blend.market_analysis.price_point}\\n`);\n \n // Test 4: Get blend history\n console.log('4. Testing blend history...');\n const historyResponse = await fetch(`${baseUrl}/api/blends`);\n const history = await historyResponse.json();\n console.log(`✅ Blend history: ${history.length} blends in database\\n`);\n \n console.log('🎉 All tests passed! The Terroir Harmony AI Blend Designer is fully functional.');\n console.log(`🌐 Visit the application at: ${baseUrl}`);\n \n } catch (error) {\n console.error('❌ Test failed:', error);\n }\n}\n\n// Export as HTTP handler for testing\nexport default async function(req: Request) {\n const results: string[] = [];\n const log = (message: string) => {\n console.log(message);\n results.push(message);\n };\n \n const baseUrl = 'https://spooky--ed5633146df111f09a7d0224a6c84d84.web.val.run';\n \n log('🧪 Testing Terroir Harmony AI Blend Designer...\\n');\n \n try {\n // Test 1: Health check\n log('1. Testing health endpoint...');\n const healthResponse = await fetch(`${baseUrl}/health`);\n const healthData = await healthResponse.json();\n log(`✅ Health check: ${healthData.status} - ${healthData.vineyardBlocks} vineyard blocks\\n`);\n \n // Test 2: Get vineyard blocks\n log('2. Testing vineyard blocks endpoint...');\n const blocksResponse = await fetch(`${baseUrl}/api/data/vineyard-blocks`);\n const blocks = await blocksResponse.json();\n log(`✅ Vineyard blocks: ${blocks.length} blocks loaded`);\n blocks.forEach((block: any) => {\n log(` - ${block.name} (${block.varietal}) - ${block.alcohol}% ABV`);\n });\n log('');\n \n // Test 3: Generate a blend\n log('3. Testing blend generation...');\n const blendRequest = {\n target_style: \"Premium Reserve Style\",\n available_blocks: blocks.slice(0, 3).map((b: any) => b.id),\n preferences: {\n max_components: 3,\n target_alcohol: 14.5,\n style_notes: \"Complex and age-worthy\"\n }\n };\n \n const blendResponse = await fetch(`${baseUrl}/api/blends/generate`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(blendRequest)\n });\n \n const blendResult = await blendResponse.json();\n log(`✅ Blend generated: \"${blendResult.blend.name}\"`);\n log(` Components:`);\n blendResult.blend.components.forEach((comp: any) => {\n log(` - ${comp.varietal}: ${comp.percentage}%`);\n });\n log(` Appeal Score: ${blendResult.blend.market_analysis.appeal_score}/10`);\n log(` Price Point: ${blendResult.blend.market_analysis.price_point}\\n`);\n \n // Test 4: Get blend history\n log('4. Testing blend history...');\n const historyResponse = await fetch(`${baseUrl}/api/blends`);\n const history = await historyResponse.json();\n log(`✅ Blend history: ${history.length} blends in database\\n`);\n \n log('🎉 All tests passed! The Terroir Harmony AI Blend Designer is fully functional.');\n log(`🌐 Visit the application at: ${baseUrl}`);\n \n return new Response(results.join('\\n'), {\n headers: { 'Content-Type': 'text/plain' }\n });\n \n } catch (error) {\n log(`❌ Test failed: ${error}`);\n return new Response(results.join('\\n'), {\n status: 500,\n headers: { 'Content-Type': 'text/plain' }\n });\n }\n}",[],[359],"files",[150,169,175,184,194,201,209,218,228,239,246,256,262,269,277,286,295,304,314,322,332,339,348,357],"counts",{"_369":32,"_370":118,"_371":32,"_372":373},"pulls","branches","forks","envVars",{"_374":32,"_375":32},"count","emptyCount","contents",[378,381,384],{"_103":263,"_95":264,"_153":265,"_155":258,"_156":138,"_157":266,"_159":160,"_105":379,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_98":380},["D",1753954670364],[99,264],{"_103":315,"_95":316,"_153":317,"_155":258,"_156":138,"_157":259,"_159":160,"_105":382,"_100":32,"_162":251,"_164":319,"_165":22,"_166":-5,"_98":383},["D",1753954642288],[99,316],{"_103":323,"_95":324,"_153":325,"_155":258,"_156":138,"_157":326,"_159":160,"_105":385,"_100":32,"_162":180,"_164":328,"_165":22,"_166":-5,"_98":386},["D",1753954647412],[99,324],{"_103":257,"_156":138,"_153":258,"_95":99,"_164":-5,"_162":163,"_100":32,"_155":-5,"_105":388,"_157":259,"_166":-5,"_98":389},["D",1753954642288],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":398,"_148":403,"_365":476,"_251":477,"_376":480,"_487":-5,"_488":22,"_489":-5,"_490":-5,"_491":-5,"_492":493},{"_103":104,"_95":96,"_105":399,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":118,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":400,"_132":401,"_135":402,"_147":22},["D",1753954375629],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":43,"_103":138,"_139":104,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},[404,431,437,464,470,473],{"_103":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":160,"_105":161,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":405,"_98":430},[406,415,427],{"_103":170,"_95":171,"_153":172,"_155":154,"_156":138,"_157":158,"_159":160,"_105":173,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":407,"_98":414},[408,411],{"_103":176,"_95":177,"_153":178,"_155":172,"_156":138,"_157":158,"_159":160,"_105":179,"_100":32,"_162":180,"_164":181,"_165":22,"_166":-5,"_167":409,"_98":410},[],[152,171,177],{"_103":185,"_95":186,"_153":187,"_155":172,"_156":138,"_157":188,"_159":160,"_105":189,"_100":32,"_162":180,"_164":190,"_165":22,"_166":-5,"_167":412,"_98":413},[],[152,171,186],[152,171],{"_103":195,"_95":196,"_153":197,"_155":154,"_156":138,"_157":198,"_159":160,"_105":199,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":416,"_98":426},[417,420,423],{"_103":202,"_95":203,"_153":204,"_155":197,"_156":138,"_157":198,"_159":160,"_105":205,"_100":32,"_162":180,"_164":206,"_165":22,"_166":-5,"_167":418,"_98":419},[],[152,196,203],{"_103":210,"_95":211,"_153":212,"_155":197,"_156":138,"_157":213,"_159":160,"_105":214,"_100":32,"_162":180,"_164":215,"_165":22,"_166":-5,"_167":421,"_98":422},[],[152,196,211],{"_103":219,"_95":220,"_153":221,"_155":197,"_156":138,"_157":222,"_159":160,"_105":223,"_100":32,"_162":180,"_164":224,"_165":22,"_166":-5,"_167":424,"_98":425},[],[152,196,220],[152,196],{"_103":229,"_95":230,"_153":231,"_155":154,"_156":138,"_157":232,"_159":160,"_105":233,"_100":118,"_162":234,"_164":235,"_165":22,"_166":-5,"_167":428,"_98":429},[],[152,230],[152],{"_103":240,"_95":241,"_153":242,"_155":-5,"_156":138,"_157":243,"_159":160,"_105":244,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":432,"_98":436},[433],{"_103":247,"_95":248,"_153":249,"_155":242,"_156":138,"_157":243,"_159":160,"_105":250,"_100":32,"_162":251,"_164":252,"_165":22,"_166":-5,"_167":434,"_98":435},[],[241,248],[241],{"_103":257,"_95":99,"_153":258,"_155":-5,"_156":138,"_157":259,"_159":160,"_105":260,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":438,"_98":463},[439,457,460],{"_103":263,"_95":264,"_153":265,"_155":258,"_156":138,"_157":266,"_159":160,"_105":267,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":440,"_98":456},[441,444,447,450,453],{"_103":270,"_95":271,"_153":272,"_155":265,"_156":138,"_157":266,"_159":160,"_105":273,"_100":32,"_162":180,"_164":274,"_165":22,"_166":-5,"_167":442,"_98":443},[],[99,264,271],{"_103":278,"_95":279,"_153":280,"_155":265,"_156":138,"_157":281,"_159":160,"_105":282,"_100":32,"_162":180,"_164":283,"_165":22,"_166":-5,"_167":445,"_98":446},[],[99,264,279],{"_103":287,"_95":288,"_153":289,"_155":265,"_156":138,"_157":290,"_159":160,"_105":291,"_100":32,"_162":180,"_164":292,"_165":22,"_166":-5,"_167":448,"_98":449},[],[99,264,288],{"_103":296,"_95":297,"_153":298,"_155":265,"_156":138,"_157":299,"_159":160,"_105":300,"_100":32,"_162":180,"_164":301,"_165":22,"_166":-5,"_167":451,"_98":452},[],[99,264,297],{"_103":305,"_95":306,"_153":307,"_155":265,"_156":138,"_157":308,"_159":160,"_105":309,"_100":32,"_162":180,"_164":310,"_165":22,"_166":-5,"_167":454,"_98":455},[],[99,264,306],[99,264],{"_103":315,"_95":316,"_153":317,"_155":258,"_156":138,"_157":259,"_159":160,"_105":318,"_100":32,"_162":251,"_164":319,"_165":22,"_166":-5,"_167":458,"_98":459},[],[99,316],{"_103":323,"_95":324,"_153":325,"_155":258,"_156":138,"_157":326,"_159":160,"_105":327,"_100":32,"_162":180,"_164":328,"_165":22,"_166":-5,"_167":461,"_98":462},[],[99,324],[99],{"_103":333,"_95":334,"_153":335,"_155":-5,"_156":138,"_157":336,"_159":160,"_105":337,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":465,"_98":469},[466],{"_103":340,"_95":341,"_153":342,"_155":335,"_156":138,"_157":336,"_159":160,"_105":343,"_100":32,"_162":180,"_164":344,"_165":22,"_166":-5,"_167":467,"_98":468},[],[334,341],[334],{"_103":349,"_95":350,"_153":351,"_155":-5,"_156":138,"_157":352,"_159":160,"_105":353,"_100":158,"_162":251,"_164":354,"_165":22,"_166":-5,"_167":471,"_98":472},[],[350],{"_103":358,"_95":359,"_153":360,"_155":-5,"_156":138,"_157":137,"_159":160,"_105":361,"_100":158,"_162":234,"_164":362,"_165":22,"_166":-5,"_167":474,"_98":475},[],[359],[404,406,408,411,415,417,420,423,427,431,433,437,439,441,444,447,450,453,457,460,464,466,470,473],{"_103":257,"_156":138,"_153":258,"_95":99,"_164":-5,"_162":163,"_100":32,"_155":-5,"_105":478,"_157":259,"_166":-5,"_98":479},["D",1753954642288],[99],[481,483,485],{"_103":263,"_95":264,"_153":265,"_155":258,"_156":138,"_157":266,"_159":160,"_105":379,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_98":482},[99,264],{"_103":315,"_95":316,"_153":317,"_155":258,"_156":138,"_157":259,"_159":160,"_105":382,"_100":32,"_162":251,"_164":319,"_165":22,"_166":-5,"_98":484},[99,316],{"_103":323,"_95":324,"_153":325,"_155":258,"_156":138,"_157":326,"_159":160,"_105":385,"_100":32,"_162":180,"_164":328,"_165":22,"_166":-5,"_98":486},[99,324],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]

spooky

winn