Skip to content

Instantly share code, notes, and snippets.

@leojh

leojh/create_fake_osPatches.sql

Created December 16, 2016 17:12
Show Gist options
  • Save leojh/622a791b36b1b49798a4268ccff62f96 to your computer and use it in GitHub Desktop.
Save leojh/622a791b36b1b49798a4268ccff62f96 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment