[trafficcontrol] branch master updated: Ignore existing permission in seeds.sql if it already exists (#6906)

[zrhoffman]

This is an automated email from the ASF dual-hosted git repository.

zrhoffman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/trafficcontrol.git


The following commit(s) were added to refs/heads/master by this push:
     new ceb0fe199c Ignore existing permission in seeds.sql if it already 
exists (#6906)
ceb0fe199c is described below

commit ceb0fe199cdd0db23491046a948cd99faa460b24
Author: Rawlin Peters <raw...@apache.org>
AuthorDate: Thu Jun 16 16:03:04 2022 -0600

    Ignore existing permission in seeds.sql if it already exists (#6906)
---
 traffic_ops/app/db/seeds.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/traffic_ops/app/db/seeds.sql b/traffic_ops/app/db/seeds.sql
index 9f35ed7340..ed7254a308 100644
--- a/traffic_ops/app/db/seeds.sql
+++ b/traffic_ops/app/db/seeds.sql
@@ -94,7 +94,8 @@ ON CONFLICT DO NOTHING;
 INSERT INTO public.role_capability
 SELECT id, 'DELIVERY-SERVICE-SAFE:UPDATE'
 FROM public.role
-WHERE "name" in ('operations', 'read-only', 'portal', 'federation', 
'steering');
+WHERE "name" in ('operations', 'read-only', 'portal', 'federation', 'steering')
+ON CONFLICT DO NOTHING;
 
 -- Using role 'read-only'
 INSERT INTO public.role_capability