Medication Images Upload Process

{MedicationName}-{Dosage}.png

# In your .env file
VITE_SUPABASE_URL=your_supabase_url
SUPABASE_SERVICE_ROLE_KEY=your_service_role_key

npm install sharp @supabase/supabase-js

/Users/cameronhouston/Downloads/_Medication Library/

npm run upload-medication-images

🚀 Starting medication image upload process...
📁 Found 58 PNG files to process

🔄 Processing Affenid-XL-18.png...
📏 Original: 344064 bytes, WebP: 28476 bytes
✅ Uploaded: Affenid-XL-18.webp
🔍 Looking for medication: Affenid XL 18
✅ Updated medication: Methylphenidate (Concerta) with image URL

📊 Summary:
   📸 Images converted and uploaded: 58/58
   💊 Medication records updated: 45/58

✅ Process completed!

ALTER TABLE medications 
ADD COLUMN image_url TEXT;

❌ Missing environment variables. Make sure VITE_SUPABASE_URL and SUPABASE_SERVICE_ROLE_KEY are set.

❌ Images directory not found: /Users/cameronhouston/Downloads/_Medication Library

⚠️  No medication found for: SomeMedicationName

❌ Upload failed for filename.png: Storage error

-- Check uploaded images
SELECT name, image_url 
FROM medications 
WHERE image_url IS NOT NULL;

-- Verify storage bucket
SELECT name, metadata 
FROM storage.objects 
WHERE bucket_id = 'medication-images';

<img src={medication.image_url} alt={medication.name} />