Filamenteka/database/migrations/006_add_basic_refill_filaments.sql

-- Add 1 refill filament for each color as user owns all basic colors
-- This creates PLA Basic filaments with 1 refill for each color in the database

-- First, let's insert filaments for all existing colors
INSERT INTO filaments (tip, finish, boja, boja_hex, refill, spulna, kolicina, cena)
SELECT 
    'PLA' as tip,
    'Basic' as finish,
    c.name as boja,
    c.hex as boja_hex,
    1 as refill,
    0 as spulna,
    1 as kolicina,
    '3999' as cena
FROM colors c
WHERE NOT EXISTS (
    -- Only insert if this exact combination doesn't already exist
    SELECT 1 FROM filaments f 
    WHERE f.tip = 'PLA' 
    AND f.finish = 'Basic' 
    AND f.boja = c.name
);

-- Update any existing PLA Basic filaments to have at least 1 refill
UPDATE filaments
SET refill = '1'
WHERE tip = 'PLA' 
AND finish = 'Basic'
AND (refill IS NULL OR refill = '0' OR refill = '');