\n \n \n \n \n \n \n\n",[],[122,140],"064dad48-6df2-11f0-8a19-0224a6c84d84","components","e1c4b4bb-13f1-4c80-9c55-b350d57d1038",11,["D",1753954670364],[153,154,155,156,157],[122,147],{"_36":190,"_13":191,"_39":192,"_41":148,"_43":44,"_45":149,"_47":48,"_49":193,"_17":51,"_52":53,"_54":194,"_56":57,"_58":-5,"_95":195,"_18":196},{"_36":182,"_13":183,"_39":184,"_41":148,"_43":44,"_45":185,"_47":48,"_49":186,"_17":51,"_52":53,"_54":187,"_56":57,"_58":-5,"_95":188,"_18":189},{"_36":174,"_13":175,"_39":176,"_41":148,"_43":44,"_45":177,"_47":48,"_49":178,"_17":51,"_52":53,"_54":179,"_56":57,"_58":-5,"_95":180,"_18":181},{"_36":166,"_13":167,"_39":168,"_41":148,"_43":44,"_45":169,"_47":48,"_49":170,"_17":51,"_52":53,"_54":171,"_56":57,"_58":-5,"_95":172,"_18":173},{"_36":158,"_13":159,"_39":160,"_41":148,"_43":44,"_45":161,"_47":48,"_49":162,"_17":51,"_52":53,"_54":163,"_56":57,"_58":-5,"_95":164,"_18":165},"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}",[],[122,147,159],"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}",[],[122,147,167],"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}",[],[122,147,175],"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}",[],[122,147,183],"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}",[],[122,147,191],"799cf40c-6df2-11f0-89f1-0224a6c84d84","data","bce86373-7a58-4de7-889b-bab4db9b4a0b",16,["D",1753954863822],[204],[198],{"_36":205,"_13":206,"_39":207,"_41":199,"_43":44,"_45":200,"_47":48,"_49":208,"_17":51,"_52":24,"_54":209,"_56":57,"_58":-5,"_95":210,"_18":211},"799ce7a0-6df2-11f0-89f1-0224a6c84d84","sample_data.json","799ce89a-6df2-11f0-89f1-0224a6c84d84",["D",1753954863822],"{\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}",[],[198,206],"a53857c4-6df1-11f0-9f5b-0224a6c84d84",["D",1753954507477],[216,217,218],[60],{"_36":243,"_13":244,"_39":245,"_41":77,"_43":44,"_45":92,"_47":48,"_49":246,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":247,"_18":248},{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":228,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":229,"_18":230},{"_36":219,"_13":220,"_39":221,"_41":77,"_43":44,"_45":222,"_47":48,"_49":223,"_17":224,"_52":93,"_54":225,"_56":57,"_58":-5,"_95":226,"_18":227},"7bffc0d0-6df2-11f0-9c08-0224a6c84d84","index.ts","ed563314-6df1-11f0-9a7d-0224a6c84d84",17,["D",1753954867824],1,"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations, insertSampleData } from \"./database/migrations.ts\";\nimport { getAllVineyardBlocks } from \"./database/queries.ts\";\n\nimport blendsRouter from \"./routes/blends.ts\";\nimport dataRouter from \"./routes/data.ts\";\nimport staticRouter from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Initialize database on startup\nlet dbInitialized = false;\nasync function initializeDatabase() {\n if (!dbInitialized) {\n await runMigrations();\n \n // Check if we have sample data, if not, insert it\n const blocks = await getAllVineyardBlocks();\n if (blocks.length === 0) {\n await insertSampleData();\n }\n \n dbInitialized = true;\n console.log(\"Database initialized successfully\");\n }\n}\n\n// API Routes\napp.route(\"/api/blends\", blendsRouter);\napp.route(\"/api/data\", dataRouter);\n\n// Static file serving\napp.route(\"/\", staticRouter);\n\n// Main application route\napp.get(\"/\", async (c) => {\n try {\n // Initialize database if needed\n await initializeDatabase();\n \n // Read the main HTML file\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 vineyardBlocks: await getAllVineyardBlocks(),\n appName: \"Terroir Harmony AI Blend Designer\",\n version: \"1.0.0\"\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.html(`\n \n Error\n \n

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;",[],[60,220],["D",1753954575287],[231,232,233],[60,61],{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":240,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_95":241,"_18":242},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":237,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_95":238,"_18":239},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":234,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_95":235,"_18":236},["D",1753954607808],[],[60,61,38],["D",1753954602232],[],[60,61,63],["D",1753954575287],[],[60,61,70],"a53859b8-6df1-11f0-9f5b-0224a6c84d84","database","da990314-77d9-4b09-965b-98a4b476cd25",["D",1753954507477],[249,250],[60,244],{"_36":259,"_13":260,"_39":261,"_41":245,"_43":44,"_45":92,"_47":48,"_49":262,"_17":51,"_52":53,"_54":263,"_56":57,"_58":-5,"_95":264,"_18":265},{"_36":251,"_13":252,"_39":253,"_41":245,"_43":44,"_45":254,"_47":48,"_49":255,"_17":51,"_52":53,"_54":256,"_56":57,"_58":-5,"_95":257,"_18":258},"b2dbb9e8-6df1-11f0-8579-0224a6c84d84","queries.ts","b2dbbac4-6df1-11f0-8579-0224a6c84d84",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}",[],[60,244,252],"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}",[],[60,244,260],"569f9fb4-6df1-11f0-900f-0224a6c84d84",["D",1753954375629],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","d9951e10-16dc-11f0-9d61-bf534f47ce53","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","a87ae3da-e311-4bfb-919e-aa8beb34d11f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_318":314},"org",{"_11":12,"_312":-5,"_313":314,"_275":276,"_315":316,"_317":57},"branch",{"_17":90,"_13":16,"_36":44,"_304":266,"_305":-5,"_306":-5,"_307":-5,"_308":-5,"_309":-5,"_310":14,"_311":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydmFPZkZqOVNkRDN1cTJPUEZJZGtDUHpkNGYifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":266,"_13":14,"_49":426,"_268":-5,"_269":57,"_270":271,"_272":271,"_273":-5,"_274":-5,"_275":276,"_277":221,"_278":48,"_279":48,"_280":-5,"_281":224,"_282":283,"_284":-5,"_285":-5,"_286":-5,"_287":-5,"_288":289,"_290":289,"_291":292,"_293":292,"_294":292,"_295":289,"_296":289,"_297":427,"_299":428,"_301":429,"_303":57},[354,363,365,374,376,377],"files",[354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377],"counts",{"_345":51,"_346":224,"_347":51,"_32":348,"_349":350},[339,340,341],{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":78,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_18":338},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[60,61],{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":73,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_18":344},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":66,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_18":343},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":342},[60,61,38],[60,61,63],[60,61,70],"pulls","branches","forks",{"_351":51,"_353":51},"connections",{"_351":51,"_352":51},"count","unfilledCount","emptyCount",{"_36":212,"_13":60,"_39":77,"_41":-5,"_43":44,"_45":92,"_47":48,"_49":213,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":424,"_18":425},{"_36":243,"_13":244,"_39":245,"_41":77,"_43":44,"_45":92,"_47":48,"_49":246,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":422,"_18":423},{"_36":259,"_13":260,"_39":261,"_41":245,"_43":44,"_45":92,"_47":48,"_49":262,"_17":51,"_52":53,"_54":263,"_56":57,"_58":-5,"_95":420,"_18":421},{"_36":251,"_13":252,"_39":253,"_41":245,"_43":44,"_45":254,"_47":48,"_49":255,"_17":51,"_52":53,"_54":256,"_56":57,"_58":-5,"_95":418,"_18":419},{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":228,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":416,"_18":417},{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":240,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_95":414,"_18":415},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":237,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_95":412,"_18":413},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":234,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_95":410,"_18":411},{"_36":219,"_13":220,"_39":221,"_41":77,"_43":44,"_45":222,"_47":48,"_49":223,"_17":224,"_52":93,"_54":225,"_56":57,"_58":-5,"_95":408,"_18":409},{"_36":197,"_13":198,"_39":199,"_41":-5,"_43":44,"_45":200,"_47":48,"_49":201,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":406,"_18":407},{"_36":205,"_13":206,"_39":207,"_41":199,"_43":44,"_45":200,"_47":48,"_49":208,"_17":51,"_52":24,"_54":209,"_56":57,"_58":-5,"_95":404,"_18":405},{"_36":121,"_13":122,"_39":123,"_41":-5,"_43":44,"_45":124,"_47":48,"_49":125,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":402,"_18":403},{"_36":146,"_13":147,"_39":148,"_41":123,"_43":44,"_45":149,"_47":48,"_49":150,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":400,"_18":401},{"_36":190,"_13":191,"_39":192,"_41":148,"_43":44,"_45":149,"_47":48,"_49":193,"_17":51,"_52":53,"_54":194,"_56":57,"_58":-5,"_95":398,"_18":399},{"_36":182,"_13":183,"_39":184,"_41":148,"_43":44,"_45":185,"_47":48,"_49":186,"_17":51,"_52":53,"_54":187,"_56":57,"_58":-5,"_95":396,"_18":397},{"_36":174,"_13":175,"_39":176,"_41":148,"_43":44,"_45":177,"_47":48,"_49":178,"_17":51,"_52":53,"_54":179,"_56":57,"_58":-5,"_95":394,"_18":395},{"_36":166,"_13":167,"_39":168,"_41":148,"_43":44,"_45":169,"_47":48,"_49":170,"_17":51,"_52":53,"_54":171,"_56":57,"_58":-5,"_95":392,"_18":393},{"_36":158,"_13":159,"_39":160,"_41":148,"_43":44,"_45":161,"_47":48,"_49":162,"_17":51,"_52":53,"_54":163,"_56":57,"_58":-5,"_95":390,"_18":391},{"_36":139,"_13":140,"_39":141,"_41":123,"_43":44,"_45":124,"_47":48,"_49":142,"_17":51,"_52":24,"_54":143,"_56":57,"_58":-5,"_95":388,"_18":389},{"_36":131,"_13":132,"_39":133,"_41":123,"_43":44,"_45":134,"_47":48,"_49":135,"_17":51,"_52":53,"_54":136,"_56":57,"_58":-5,"_95":386,"_18":387},{"_36":106,"_13":107,"_39":108,"_41":-5,"_43":44,"_45":109,"_47":48,"_49":110,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_95":384,"_18":385},{"_36":114,"_13":115,"_39":116,"_41":108,"_43":44,"_45":109,"_47":48,"_49":117,"_17":51,"_52":53,"_54":118,"_56":57,"_58":-5,"_95":382,"_18":383},{"_36":98,"_13":99,"_39":100,"_41":-5,"_43":44,"_45":101,"_47":48,"_49":102,"_17":92,"_52":24,"_54":103,"_56":57,"_58":-5,"_95":380,"_18":381},{"_36":87,"_13":88,"_39":89,"_41":-5,"_43":44,"_45":90,"_47":48,"_49":91,"_17":92,"_52":93,"_54":94,"_56":57,"_58":-5,"_95":378,"_18":379},[],[88],[],[99],[],[107,115],[375],[107],[],[122,132],[],[122,140],[],[122,147,159],[],[122,147,167],[],[122,147,175],[],[122,147,183],[],[122,147,191],[367,368,369,370,371],[122,147],[366,372,373],[122],[],[198,206],[364],[198],[],[60,220],[],[60,61,38],[],[60,61,63],[],[60,61,70],[359,360,361],[60,61],[],[60,244,252],[],[60,244,260],[356,357],[60,244],[355,358,362],[60],["D",1753954375629],{"_11":12,"_318":314},{"_11":12,"_312":-5,"_313":314,"_275":276,"_315":316,"_317":57},{"_17":90,"_13":16,"_36":44,"_304":266,"_305":-5,"_306":-5,"_307":-5,"_308":-5,"_309":-5,"_310":14,"_311":12},"ctx",{"_297":-5,"_335":463,"_464":465,"_466":467,"_468":57,"_469":57,"_470":57,"_471":48,"_472":-5,"_473":-7,"_474":-7,"_475":51,"_476":57,"_477":57,"_478":-5,"_479":57,"_480":57,"_481":57,"_482":-5},"ENV",{"_434":435,"_436":437,"_438":16,"_439":440,"_441":442,"_443":444,"_445":446,"_447":448,"_449":450,"_451":452,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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"]