create_fake_osPatches.sql

DO
$do$
DECLARE n data_patchdata%rowtype;
BEGIN

  FOR n IN SELECT * from data_patchdata LOOP

    insert into data_patchdata_content
    (stateset_id, description, identifier, name, severity, status, type)
    VALUES
    (n.id, 'Leo A Patch that fixes everything', '89e4b261-0f87-4bb7-8562-026d73a109c4', 'Leo A Patch', 'IMPORTANT', 'MANUAL', 'REGULAR_UPDATES');

    insert into data_patchdata_content
    (stateset_id, description, identifier, name, severity, status, type)
    VALUES
    (n.id, 'Leo B Patch that fixes everything', 'f65e5908-56e8-40f0-a4c7-6b73623d8ac5', 'Leo B Patch', 'IMPORTANT', 'MANUAL', 'REGULAR_UPDATES');

    insert into data_patchdata_content
    (stateset_id, description, identifier, name, severity, status, type)
    VALUES
    (n.id, 'Leo C Patch that fixes everything', '5dbe26d2-3ae4-41bf-97f9-90da7e836532', 'Leo C Patch', 'IMPORTANT', 'MANUAL', 'REGULAR_UPDATES');

    insert into data_patchdata_content
    (stateset_id, description, identifier, name, severity, status, type)
    VALUES
    (n.id, 'Leo D Patch that fixes everything', '4d0e764b-8f42-459e-8ece-80fc19b209cf', 'Leo A Patch', 'IMPORTANT', 'MANUAL', 'REGULAR_UPDATES');

    insert into data_patchdata_content
    (stateset_id, description, identifier, name, severity, status, type)
    VALUES
    (n.id, 'Leo E Patch that fixes everything', 'ca6d5aa7-6830-4fe9-b828-91fe233dda79', 'Leo B Patch', 'IMPORTANT', 'MANUAL', 'REGULAR_UPDATES');

    insert into data_patchdata_content
    (stateset_id, description, identifier, name, severity, status, type)
    VALUES
    (n.id, 'Leo F Patch that fixes everything', '26d2c4e5-aedc-4c13-9c60-9460cb42d05c', 'Leo C Patch', 'IMPORTANT', 'MANUAL', 'REGULAR_UPDATES');

    UPDATE data_patchdata set pendingapprovalcount = 6 where id = n.id;

  END LOOP;
END
$do$;