Val Town Code SearchReturn to Val Town

109          }
110          
111          if (uploadedFile.type.startsWith('image/')) {
112            endpoint = '/api/parse/image';
113            requestData = { type: 'image', content: parseInput };
114          } else if (uploadedFile.type === 'application/pdf') {
115            endpoint = '/api/parse/pdf';
150
151    // Validate file type
152    const isImage = file.type.startsWith('image/');
153    const isPDF = file.type === 'application/pdf';
154    
155    if (!isImage && !isPDF) {
156      setError('Please select an image file (JPG, PNG, etc.) or a PDF file');
157      return;
158    }
274              ref={fileInputRef}
275              type="file"
276              accept="image/*,.pdf"
277              onChange={handleFileUpload}
278              className="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500"
279            />
280            <div className="mt-2 text-sm text-gray-600">
281              📷 Images (JPG, PNG, etc.) or 📄 PDF files supported
282            </div>
283          </div>
286              <span className="mr-2">✅</span>
287              <span>
288                {uploadedFile.type.startsWith('image/') ? '📷' : '📄'} 
289                {uploadedFile.name} uploaded and ready to parse
290              </span>

19  const recipeResult = await sqlite.execute(`
20    INSERT INTO ${RECIPES_TABLE} 
21    (title, description, servings, prep_time, cook_time, difficulty, tags, source, image_url, steps)
22    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
23  `, [
30    tags ? JSON.stringify(tags) : null,
31    recipeData.source || null,
32    recipeData.imageUrl || null,
33    JSON.stringify(steps)
34  ]);
108    tags: recipeRow.tags ? JSON.parse(recipeRow.tags as string) : undefined,
109    source: recipeRow.source as string || undefined,
110    imageUrl: recipeRow.image_url as string || undefined,
111    createdAt: recipeRow.created_at as string,
112    updatedAt: recipeRow.updated_at as string
168      const dbKey = key === 'prepTime' ? 'prep_time' : 
169                   key === 'cookTime' ? 'cook_time' : 
170                   key === 'imageUrl' ? 'image_url' : key;
171      setParts.push(`${dbKey} = ?`);
172      params.push(value);