Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kDmyJ-0004Qb-8C for pgadmin-hackers@arkaria.postgresql.org; Thu, 03 Sep 2020 11:00:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kDmyI-0004oj-6u for pgadmin-hackers@arkaria.postgresql.org; Thu, 03 Sep 2020 11:00:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kDmyH-0004oN-Rk for pgadmin-hackers@lists.postgresql.org; Thu, 03 Sep 2020 11:00:02 +0000 Received: from mail-pg1-x52b.google.com ([2607:f8b0:4864:20::52b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kDmyE-0005pt-N6 for pgadmin-hackers@postgresql.org; Thu, 03 Sep 2020 11:00:01 +0000 Received: by mail-pg1-x52b.google.com with SMTP id d19so1821646pgl.10 for ; Thu, 03 Sep 2020 03:59:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=pvem1idOaRiH0jP2IJ3fxPbstT6yK9Z8m9sANkL4/nc=; b=O/kTUbhtn0c0lMLS6rB5+jCrGGzZKz7DJRYma+sko+linrwJScQAUIqzIFxINsM8fk 72Jrxbhb0j4jcNgS9n9ELVgTP8HUXqOYcYsV78nVnwLqgNydkftNIG4TCTucx84x7+Ia WltfkJjn3zHtX0cTZ7JvomorYAPzzFtKO6eI+a6SKv8BVfdivT5NbUukcG5tO9n7MtF3 3BZKrdOh5/wD2TFFYBWYxWdnpbYZHpQ1OzDFNZsIEvrxwsMrQ7O7aom9jen37pcuG96d ES7nCkcl9yuhSnDTfIz8DzhGTDoLRixLrLhtdyVNEiTlEn5OgdYbQ3vU/d7ZJs4IdoH/ Pb2A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=pvem1idOaRiH0jP2IJ3fxPbstT6yK9Z8m9sANkL4/nc=; b=dJTEBmAaRId9CFQbKBDrlsQ+niX/C3/MktVnxylMh2A13dzNgqjJPhDHaXir9G9C4U l5/beZHMELNn+KwzcCGMf94cwLR3sRGgPz+wmjVWlfR+0fN97cAZZ1QPphenAMGWtauj Fdt5M9BHwYw9SIp1iP6r1zHKJhrwPrkPuYzuXJDR2O/K+taU9+mzKSwxoLi2Eot+1GvQ luL5HuMFBGqeMxhaxYvpndlVlmrYiiqxcamuLH7hy/ReGvgbkkpX9obJS4+9NmBa8H2G CzwNHoZSRDavchzrh1IjIK6eC3iJxNFAbThaTV6eXRD+HXdh5x9zpH6wbyZyN5jpJjJO 2Kfw== X-Gm-Message-State: AOAM532QkIqsqVKks6onnVPPKhUUxZ0O8jZJafPTGePpKICy3j6duadp Pq7vQ9BGQyQXsj4pKNMYgL1pX8FrSfHWxZlmFDKbjFsSCuQ0t2ePCG7AG7An+rDnighGuhlGkJ3 r4TM+43uZ4L3WiH8s9bXaRMhQkzP8tlZ8MnrXZTdweK/f49G/+k26/ihC6TyUPAoslMtS+pK9N1 ALpmO89DQOntrQecaynAtPDzajHEaEiQI13btw+dmJUSiXX94KTm24FbqljXTNi9DjwUBr X-Google-Smtp-Source: ABdhPJzsHrBXbgCEbZIvyEO4F5O5x2WGBpDbBpJKWpc4muEYD98ti5TmjApcWXfreZaIohp6ZE5lpTNHErvn020TjA4= X-Received: by 2002:a63:1704:: with SMTP id x4mr2418345pgl.186.1599130795793; Thu, 03 Sep 2020 03:59:55 -0700 (PDT) MIME-Version: 1.0 From: Pradip Parkale Date: Thu, 3 Sep 2020 16:29:44 +0530 Message-ID: Subject: [pgAdmin][SonarQube] : Remove duplicates string literals. To: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000000899e405ae66a7ff" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000000899e405ae66a7ff Content-Type: multipart/alternative; boundary="0000000000000899e105ae66a7fd" --0000000000000899e105ae66a7fd Content-Type: text/plain; charset="UTF-8" Hi Hackers, Attached is a patch for removing duplicates string literals. /server_groups/servers/roles/__init__.py - 8 places -- Thanks & Regards, Pradip Parkale Software Engineer | EnterpriseDB Corporation --0000000000000899e105ae66a7fd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Attached i= s a patch for removing duplicates string literals.
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 /server_groups/servers/roles/__init__.py =C2=A0- 8 pla= ces



--
=
Thanks & Regards,
Pradip Parkale
Software Engineer | EnterpriseDB Corporation
--0000000000000899e105ae66a7fd-- --0000000000000899e405ae66a7ff Content-Type: application/octet-stream; name="sonar_Qube_v1.patch" Content-Disposition: attachment; filename="sonar_Qube_v1.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kemp5av90 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL3Jv bGVzL19faW5pdF9fLnB5IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZl cnMvcm9sZXMvX19pbml0X18ucHkKaW5kZXggNWM3OGMwOWVlLi45MjcxMDFiODEgMTAwNjQ0Ci0t LSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL3JvbGVzL19faW5p dF9fLnB5CisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL3Jv bGVzL19faW5pdF9fLnB5CkBAIC0yMCw2ICsyMCw4IEBAIGZyb20gcGdhZG1pbi51dGlscy5hamF4 IGltcG9ydCBtYWtlX2pzb25fcmVzcG9uc2UsIFwKICAgICBtYWtlX3Jlc3BvbnNlIGFzIGFqYXhf cmVzcG9uc2UsIHByZWNvbmRpdGlvbl9yZXF1aXJlZCwgXAogICAgIGludGVybmFsX3NlcnZlcl9l cnJvciwgZm9yYmlkZGVuLCBzdWNjZXNzX3JldHVybiwgZ29uZQogZnJvbSBwZ2FkbWluLnV0aWxz LmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZlcgorZnJvbSBwZ2FkbWluLnV0aWxzLmNvbnN0YW50cyBp bXBvcnQgUk9MRV9OT1RfRk9VTkQsIFwKKyAgICBFUlJPUl9GRVRDSElOR19ST0xFX0lORk9STUFU SU9OCiAKIGZyb20gY29uZmlnIGltcG9ydCBQR19ERUZBVUxUX0RSSVZFUgogCkBAIC02NDEsMTAg KzY0Myw3IEBAIHJvbG1lbWJlcnNoaXA6ewogICAgICAgICBpZiBub3Qgc3RhdHVzOgogICAgICAg ICAgICAgcmV0dXJuIGludGVybmFsX3NlcnZlcl9lcnJvcigKICAgICAgICAgICAgICAgICBfKAot ICAgICAgICAgICAgICAgICAgICAiRXJyb3IgZmV0Y2hpbmcgcm9sZSBpbmZvcm1hdGlvbiBmcm9t IHRoZSBkYXRhYmFzZSAiCi0gICAgICAgICAgICAgICAgICAgICJzZXJ2ZXIuXG57MH0iCi0gICAg ICAgICAgICAgICAgKS5mb3JtYXQocnNldCkKLSAgICAgICAgICAgICkKKyAgICAgICAgICAgICAg ICAgICAgRVJST1JfRkVUQ0hJTkdfUk9MRV9JTkZPUk1BVElPTiArICJcbnswfSIpLmZvcm1hdChy c2V0KSkKIAogICAgICAgICByZXMgPSBbXQogICAgICAgICBmb3Igcm93IGluIHJzZXRbJ3Jvd3Mn XToKQEAgLTY3NiwxMCArNjc1LDcgQEAgcm9sbWVtYmVyc2hpcDp7CiAgICAgICAgIGlmIG5vdCBz dGF0dXM6CiAgICAgICAgICAgICByZXR1cm4gaW50ZXJuYWxfc2VydmVyX2Vycm9yKAogICAgICAg ICAgICAgICAgIF8oCi0gICAgICAgICAgICAgICAgICAgICJFcnJvciBmZXRjaGluZyByb2xlIGlu Zm9ybWF0aW9uIGZyb20gdGhlIGRhdGFiYXNlICIKLSAgICAgICAgICAgICAgICAgICAgInNlcnZl ci5cbnswfSIKLSAgICAgICAgICAgICAgICApLmZvcm1hdChyc2V0KQotICAgICAgICAgICAgKQor ICAgICAgICAgICAgICAgICAgICBFUlJPUl9GRVRDSElOR19ST0xFX0lORk9STUFUSU9OICsgIlxu ezB9IikuZm9ybWF0KHJzZXQpKQogCiAgICAgICAgIGZvciByb3cgaW4gcnNldFsncm93cyddOgog ICAgICAgICAgICAgcmV0dXJuIG1ha2VfanNvbl9yZXNwb25zZSgKQEAgLTY5Myw3ICs2ODksNyBA QCByb2xtZW1iZXJzaGlwOnsKICAgICAgICAgICAgICAgICBzdGF0dXM9MjAwCiAgICAgICAgICAg ICApCiAKLSAgICAgICAgcmV0dXJuIGdvbmUoXygiQ291bGQgbm90IGZpbmQgdGhlIHJvbGUgaW5m b3JtYXRpb24uIikpCisgICAgICAgIHJldHVybiBnb25lKF8oUk9MRV9OT1RfRk9VTkQpKQogCiAg ICAgZGVmIHRyYW5zZm9ybShzZWxmLCByc2V0KToKICAgICAgICAgZm9yIHJvdyBpbiByc2V0Wydy b3dzJ106CkBAIC03MzYsNyArNzMyLDcgQEAgcm9sbWVtYmVyc2hpcDp7CiAKICAgICAgICAgc2Vs Zi50cmFuc2Zvcm0ocmVzKQogICAgICAgICBpZiBsZW4ocmVzWydyb3dzJ10pID09IDA6Ci0gICAg ICAgICAgICByZXR1cm4gZ29uZShfKCJDb3VsZCBub3QgZmluZCB0aGUgcm9sZSBpbmZvcm1hdGlv bi4iKSkKKyAgICAgICAgICAgIHJldHVybiBnb25lKF8oUk9MRV9OT1RfRk9VTkQpKQogCiAgICAg ICAgIHJlc1sncm93cyddWzBdWydpc19zeXNfb2JqJ10gPSAoCiAgICAgICAgICAgICByZXNbJ3Jv d3MnXVswXVsnb2lkJ10gPD0gc2VsZi5kYXRsYXN0c3lzb2lkKQpAQCAtODUzLDEwICs4NDksNyBA QCByb2xtZW1iZXJzaGlwOnsKICAgICAgICAgaWYgbm90IHN0YXR1czoKICAgICAgICAgICAgIHJl dHVybiBpbnRlcm5hbF9zZXJ2ZXJfZXJyb3IoCiAgICAgICAgICAgICAgICAgXygKLSAgICAgICAg ICAgICAgICAgICAgIkVycm9yIGZldGNoaW5nIHJvbGUgaW5mb3JtYXRpb24gZnJvbSB0aGUgZGF0 YWJhc2UgIgotICAgICAgICAgICAgICAgICAgICAic2VydmVyLlxuezB9IgotICAgICAgICAgICAg ICAgICkuZm9ybWF0KHJzZXQpCi0gICAgICAgICAgICApCisgICAgICAgICAgICAgICAgICAgIEVS Uk9SX0ZFVENISU5HX1JPTEVfSU5GT1JNQVRJT04gKyAiXG57MH0iKS5mb3JtYXQocnNldCkpCiAg ICAgICAgIGZvciByb3cgaW4gcnNldFsncm93cyddOgogICAgICAgICAgICAgcmV0dXJuIGpzb25p ZnkoCiAgICAgICAgICAgICAgICAgbm9kZT1zZWxmLmJsdWVwcmludC5nZW5lcmF0ZV9icm93c2Vy X25vZGUoCkBAIC04NjcsNyArODYwLDcgQEAgcm9sbWVtYmVyc2hpcDp7CiAgICAgICAgICAgICAg ICAgKQogICAgICAgICAgICAgKQogCi0gICAgICAgIHJldHVybiBnb25lKF8oIkNvdWxkIG5vdCBm aW5kIHRoZSByb2xlIGluZm9ybWF0aW9uLiIpKQorICAgICAgICByZXR1cm4gZ29uZShfKFJPTEVf Tk9UX0ZPVU5EKSkKIAogICAgIEBjaGVja19wcmVjb25kaXRpb24oYWN0aW9uPSd1cGRhdGUnKQog ICAgIEB2YWxpZGF0ZV9yZXF1ZXN0CkBAIC05MDEsMTAgKzg5NCw3IEBAIHJvbG1lbWJlcnNoaXA6 ewogICAgICAgICBpZiBub3Qgc3RhdHVzOgogICAgICAgICAgICAgcmV0dXJuIGludGVybmFsX3Nl cnZlcl9lcnJvcigKICAgICAgICAgICAgICAgICBfKAotICAgICAgICAgICAgICAgICAgICAiRXJy b3IgZmV0Y2hpbmcgcm9sZSBpbmZvcm1hdGlvbiBmcm9tIHRoZSBkYXRhYmFzZSAiCi0gICAgICAg ICAgICAgICAgICAgICJzZXJ2ZXIuXG57MH0iCi0gICAgICAgICAgICAgICAgKS5mb3JtYXQocnNl dCkKLSAgICAgICAgICAgICkKKyAgICAgICAgICAgICAgICAgICAgRVJST1JfRkVUQ0hJTkdfUk9M RV9JTkZPUk1BVElPTiArICJcbnswfSIpLmZvcm1hdChyc2V0KSkKIAogICAgICAgICBmb3Igcm93 IGluIHJzZXRbJ3Jvd3MnXToKICAgICAgICAgICAgIHJldHVybiBqc29uaWZ5KApAQCAtOTE3LDcg KzkwNyw3IEBAIHJvbG1lbWJlcnNoaXA6ewogICAgICAgICAgICAgICAgICkKICAgICAgICAgICAg ICkKIAotICAgICAgICByZXR1cm4gZ29uZShfKCJDb3VsZCBub3QgZmluZCB0aGUgcm9sZSBpbmZv cm1hdGlvbi4iKSkKKyAgICAgICAgcmV0dXJuIGdvbmUoXyhST0xFX05PVF9GT1VORCkpCiAKICAg ICBAY2hlY2tfcHJlY29uZGl0aW9uKGFjdGlvbj0nbXNxbCcpCiAgICAgQHZhbGlkYXRlX3JlcXVl c3QKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJz L3N0YXRpYy9qcy9zZXJ2ZXIuanMgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMv c2VydmVycy9zdGF0aWMvanMvc2VydmVyLmpzCmluZGV4IDkxNzBlMGQ0NC4uZTQ4NTI0OTI0IDEw MDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9zdGF0 aWMvanMvc2VydmVyLmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9z ZXJ2ZXJzL3N0YXRpYy9qcy9zZXJ2ZXIuanMKQEAgLTc0NCw3ICs3NDQsNiBAQCBkZWZpbmUoJ3Bn YWRtaW4ubm9kZS5zZXJ2ZXInLCBbCiAgICAgICAgIC8vIERlZmF1bHQgdmFsdWVzIQogICAgICAg ICBpbml0aWFsaXplOiBmdW5jdGlvbihhdHRycywgYXJncykgewogICAgICAgICAgIHZhciBpc05l dyA9IChfLnNpemUoYXR0cnMpID09PSAwKTsKLSAgICAgICAgICBjb25zb2xlLndhcm4oJ3dhcm4n KTsKIAogICAgICAgICAgIGlmIChpc05ldykgewogICAgICAgICAgICAgdGhpcy5zZXQoeydnaWQn OiBhcmdzLm5vZGVfaW5mb1snc2VydmVyX2dyb3VwJ10uX2lkfSk7CmRpZmYgLS1naXQgYS93ZWIv cGdhZG1pbi91dGlscy9jb25zdGFudHMucHkgYi93ZWIvcGdhZG1pbi91dGlscy9jb25zdGFudHMu cHkKaW5kZXggODhhZTUwZGUyLi43NmEzOTI3ODkgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3V0 aWxzL2NvbnN0YW50cy5weQorKysgYi93ZWIvcGdhZG1pbi91dGlscy9jb25zdGFudHMucHkKQEAg LTI5LDMgKzI5LDggQEAgUEdBRE1JTl9OT0RFID0gJ3BnYWRtaW4ubm9kZS4lcycKIFVOQVVUSF9S RVEgPSAiVW5hdXRob3JpemVkIHJlcXVlc3QuIgogU0VSVkVSX0NPTk5FQ1RJT05fQ0xPU0VEID0g Z2V0dGV4dCgKICAgICAnTm90IGNvbm5lY3RlZCB0byBzZXJ2ZXIgb3IgY29ubmVjdGlvbiB3aXRo IHRoZSBzZXJ2ZXIgaGFzIGJlZW4gY2xvc2VkLicpCisKKyMgUm9sZSBtb2R1bGUgY29uc3RhbnQK K1JPTEVfTk9UX0ZPVU5EID0gZ2V0dGV4dCgiQ291bGQgbm90IGZpbmQgdGhlIHJvbGUgaW5mb3Jt YXRpb24uIikKK0VSUk9SX0ZFVENISU5HX1JPTEVfSU5GT1JNQVRJT04gPSBnZXR0ZXh0KAorICAg ICJFcnJvciBmZXRjaGluZyByb2xlIGluZm9ybWF0aW9uIGZyb20gdGhlIGRhdGFiYXNlIHNlcnZl ci4iKQpkaWZmIC0tZ2l0IGEvd2ViL3JlZ3Jlc3Npb24vcHl0aG9uX3Rlc3RfdXRpbHMvdGVzdF91 dGlscy5weSBiL3dlYi9yZWdyZXNzaW9uL3B5dGhvbl90ZXN0X3V0aWxzL3Rlc3RfdXRpbHMucHkK aW5kZXggMDIyODU2YzBjLi40M2JlNzM4MjAgMTAwNjQ0Ci0tLSBhL3dlYi9yZWdyZXNzaW9uL3B5 dGhvbl90ZXN0X3V0aWxzL3Rlc3RfdXRpbHMucHkKKysrIGIvd2ViL3JlZ3Jlc3Npb24vcHl0aG9u X3Rlc3RfdXRpbHMvdGVzdF91dGlscy5weQpAQCAtMTY4MSw4ICsxNjgxLDcgQEAgZGVmIGdldF90 ZXN0X3VzZXIoc2VsZiwgdXNlcl9kZXRhaWxzLAogCiBkZWYgY3JlYXRlX3VzZXJfd2lzZV90ZXN0 X2NsaWVudCh1c2VyKToKICAgICAiIiIKLSAgICBUaGlzIGZ1bmN0aW9uIGNyZWF0ZXMgbmV3IHRl c3QgY2xpZW50IGFuZCBwZW0gZGF0YWJhc2UgY29ubmVjdGlvbiBhcyBwZXIKLSAgICBwcm92aWRl ZCB1c2VyIGFuZCBleGVjdXRlIHRoZSB0ZXN0IGNhc2VzLgorICAgIFRoaXMgZnVuY3Rpb24gY3Jl YXRlcyBuZXcgdGVzdCBjbGllbnQgYW5kIGV4ZWN1dGUgdGhlIHRlc3QgY2FzZXMuCiAgICAgOnJl dHVybjogTm9uZQogICAgICIiIgogCg== --0000000000000899e405ae66a7ff--