-- Seed script: Mark existing brands as verified
-- Run after importing existing CMS data into the new schema.
--
-- This updates all pre-existing brands (imported from brands-full.json)
-- to verified=true, hidden=false, enrichment_status='complete'.

UPDATE funeral_brand
SET verified = TRUE,
    hidden = FALSE,
    enrichment_status = 'complete',
    listing_tier = 'verified',
    updated_at = NOW()
WHERE id IN (
    -- IDs from the existing 12 brands in brands-full.json
    -- These will be populated during the initial CMS data import.
    -- Update this list to match actual imported IDs.
    SELECT id FROM funeral_brand WHERE source_key IS NULL
);

-- Alternatively, if importing with known codes:
-- UPDATE funeral_brand SET verified = TRUE, hidden = FALSE, enrichment_status = 'complete'
-- WHERE code IN ('hparsons', 'parsons-ladies', 'rankins', 'killick', 'botanical',
--                'easy', 'wollongong-city', 'kenneallys', 'lady-anne',
--                'mackay', 'mannings', 'guardian');