-- Update spulna to '0' for colors that only come as refills
UPDATE filaments 
SET spulna = '0' 
WHERE boja IN (
  'Beige',
  'Light Gray',
  'Yellow',
  'Orange',
  'Gold',
  'Bright Green',
  'Pink',
  'Magenta',
  'Maroon Red',
  'Purple',
  'Turquoise',
  'Cobalt Blue',
  'Brown',
  'Bronze',
  'Silver',
  'Blue Grey',
  'Dark Gray'
);

-- Also update their quantity to be based only on refill count
UPDATE filaments 
SET kolicina = CASE 
  WHEN refill ~ '^\d+$' THEN CAST(refill AS INTEGER)
  ELSE 0
END
WHERE boja IN (
  'Beige',
  'Light Gray',
  'Yellow',
  'Orange',
  'Gold',
  'Bright Green',
  'Pink',
  'Magenta',
  'Maroon Red',
  'Purple',
  'Turquoise',
  'Cobalt Blue',
  'Brown',
  'Bronze',
  'Silver',
  'Blue Grey',
  'Dark Gray'
);