Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aikx6-0001kX-1I for pgadmin-hackers@arkaria.postgresql.org; Wed, 23 Mar 2016 15:44:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1aikx5-0002nV-KD for pgadmin-hackers@arkaria.postgresql.org; Wed, 23 Mar 2016 15:44:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1aikx4-0002nI-EU for pgadmin-hackers@postgresql.org; Wed, 23 Mar 2016 15:44:06 +0000 Received: from mail-wm0-x231.google.com ([2a00:1450:400c:c09::231]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1aikx1-0003zg-9S for pgadmin-hackers@postgresql.org; Wed, 23 Mar 2016 15:44:05 +0000 Received: by mail-wm0-x231.google.com with SMTP id l68so201728258wml.0 for ; Wed, 23 Mar 2016 08:44:02 -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=Jah1xCkSExnjZQwW9CahjCE4qFU+EQQJi2ToIdqczf4=; b=mH5d6vUT8dFq9LvVaRdTQhWOSwR0AQBBeT7pp0mtzRMtCCqNa5snP3dJHCsEyfRYR6 NRzFtosxL9Ao5QYkk6wTy6iBaxRTvhe2N08GheJ2Md2VCdgZGGUc9/ohBWRR+KDH0FAu qT4pV2wgm/TdYII/2MLY6oXSU2voW/S86M5rWIAyVwAQe8c4HB3Uor8fO624h0sNYpfO y3y8NKzqGgVsI0K48+ZLHJFP4YPhOme63C31V2sTz60tdPcVBYZYe/jaxUzCSX2Exp1x mOBn/a+TaRqz0N/ElVURo8ULHhhInsOG/P53BUjIOPgp9MPZJC0t7kQ8ClBO6J1AZSa3 T+Qg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=Jah1xCkSExnjZQwW9CahjCE4qFU+EQQJi2ToIdqczf4=; b=Pj+XMwzD1qc2n6tzWPH0QZQtKJV2s+6cIuX/dr4d9SnzyANqlIT8VnFD9vImZYyyrk Qdq5U7Yfq5A6v32BmTq3spDPm/4AZyMhn7fmZMfrVAsl+bdFMMZqE/A6cN344MVewt0B 93DuQLIvQkL8hwpVlhprkeVPHL+2Dfqz4nZ+0yw4ytFhVyT3isgXbF0EPNeOrI5Jn7ZA i6VM1X6VXfdhopJQ2whSHeAzVsNlq2jXek0rj9s5ww5GwCnssU2dXBO7nO3Ltq/NFgdw LK2vKJEfrVwG6A6tKHw+wajFsSZYFaDMrQ3UGgjbSY08C4y3GWHgu2gVxLIZIIPwNFd1 Z3YQ== X-Gm-Message-State: AD7BkJLxJeDNL8kxKpwMhjJc54orgu90sF2kXumMDRX+vIPShx6IslixllP2YGtMlzBhjSqfxSGdXFmGReqFQEG6 X-Received: by 10.194.78.83 with SMTP id z19mr4117771wjw.5.1458747842180; Wed, 23 Mar 2016 08:44:02 -0700 (PDT) MIME-Version: 1.0 Received: by 10.28.55.74 with HTTP; Wed, 23 Mar 2016 08:43:32 -0700 (PDT) From: Surinder Kumar Date: Wed, 23 Mar 2016 21:13:32 +0530 Message-ID: Subject: [pgAdmin4] PATCH: Added Utility functions for triggers node and rules node To: pgadmin-hackers Content-Type: multipart/mixed; boundary=047d7bf0c29af37135052eb93234 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --047d7bf0c29af37135052eb93234 Content-Type: multipart/alternative; boundary=047d7bf0c29af37130052eb93232 --047d7bf0c29af37130052eb93232 Content-Type: text/plain; charset=UTF-8 Hi, Trigger and Rules nodes have functions which are also used by view node. View node use them while generating reverse engineering SQL for respective nodes. so they are moved into schema/utils.py Please review the patch. Thanks, Surinder Kumar --047d7bf0c29af37130052eb93232 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Trigger and Rules nodes have functi= ons which are also used by view node.
View node use them while ge= nerating reverse engineering SQL for respective nodes.
so they ar= e moved into schema/utils.py


Please= review the patch.


Thanks,
Surinder Kumar

--047d7bf0c29af37130052eb93232-- --047d7bf0c29af37135052eb93234 Content-Type: application/octet-stream; name="utility_functions_for_trigger_and_rule_node.patch" Content-Disposition: attachment; filename="utility_functions_for_trigger_and_rule_node.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_im4zujk30 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3V0aWxzLnB5IGIvd2ViL3Bn YWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2Vz L3NjaGVtYXMvdXRpbHMucHkKaW5kZXggOTQ5N2U1OC4uMDUxM2U2ZSAxMDA2 NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3Nl cnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdXRpbHMucHkKKysrIGIvd2ViL3Bn YWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2Vz L3NjaGVtYXMvdXRpbHMucHkKQEAgLTEyLDYgKzEyLDcgQEAKIGZyb20gcGdh ZG1pbi5icm93c2VyLmNvbGxlY3Rpb24gaW1wb3J0IENvbGxlY3Rpb25Ob2Rl TW9kdWxlCiBmcm9tIHBnYWRtaW4uYnJvd3Nlci51dGlscyBpbXBvcnQgUEdD aGlsZE5vZGVWaWV3CiBmcm9tIGZsYXNrIGltcG9ydCByZW5kZXJfdGVtcGxh dGUKK2Zyb20gcGdhZG1pbi51dGlscy5hamF4IGltcG9ydCBpbnRlcm5hbF9z ZXJ2ZXJfZXJyb3IKIAogY2xhc3MgU2NoZW1hQ2hpbGRNb2R1bGUoQ29sbGVj dGlvbk5vZGVNb2R1bGUpOgogICAgICIiIgpAQCAtMTM5LDMgKzE0MCwxMTAg QEAgY2xhc3MgRGF0YVR5cGVSZWFkZXI6CiAgICAgICAgICAgICByZXR1cm4g RmFsc2UsIHN0cihlKQogCiAgICAgICAgIHJldHVybiBUcnVlLCByZXMKKwor CitkZWYgdHJpZ2dlcl9kZWZpbml0aW9uKGRhdGEpOgorICAgICIiIgorICAg IFRoaXMgZnVuY3Rpb25hbCB3aWxsIHNldCB0aGUgdHJpZ2dlciBkZWZpbml0 aW9uCisKKyAgICBBcmdzOgorICAgICAgICBkYXRhOiBQcm9wZXJ0aWVzIGRh dGEKKworICAgIFJldHVybnM6CisgICAgICAgIFVwZGF0ZWQgcHJvcGVydGll cyBkYXRhIHdpdGggdHJpZ2dlciBkZWZpbml0aW9uCisgICAgIiIiCisKKyAg ICAjIEhlcmUgd2UgYXJlIHN0b3JpbmcgdHJpZ2dlciBkZWZpbml0aW9uCisg ICAgIyBXZSB3aWxsIHVzZSBpdCB0byBjaGVjayB0cmlnZ2VyIHR5cGUgZGVm aW5pdGlvbgorICAgIHRyaWdnZXJfZGVmaW5pdGlvbiA9IHsKKyAgICAgICAg J1RSSUdHRVJfVFlQRV9ST1cnOiAgICAgICAgICgxIDw8IDApLAorICAgICAg ICAnVFJJR0dFUl9UWVBFX0JFRk9SRSc6ICAgICAgKDEgPDwgMSksCisgICAg ICAgICdUUklHR0VSX1RZUEVfSU5TRVJUJzogICAgICAoMSA8PCAyKSwKKyAg ICAgICAgJ1RSSUdHRVJfVFlQRV9ERUxFVEUnOiAgICAgICgxIDw8IDMpLAor ICAgICAgICAnVFJJR0dFUl9UWVBFX1VQREFURSc6ICAgICAgKDEgPDwgNCks CisgICAgICAgICdUUklHR0VSX1RZUEVfVFJVTkNBVEUnOiAgICAoMSA8PCA1 KSwKKyAgICAgICAgJ1RSSUdHRVJfVFlQRV9JTlNURUFEJzogICAgICgxIDw8 IDYpCisgICAgfQorCisgICAgIyBGaXJlcyBldmVudCBkZWZpbml0aW9uCisg ICAgaWYgZGF0YVsndGd0eXBlJ10gJiB0cmlnZ2VyX2RlZmluaXRpb25bJ1RS SUdHRVJfVFlQRV9CRUZPUkUnXToKKyAgICAgICAgZGF0YVsnZmlyZXMnXSA9 ICdCRUZPUkUnCisgICAgZWxpZiBkYXRhWyd0Z3R5cGUnXSAmIHRyaWdnZXJf ZGVmaW5pdGlvblsnVFJJR0dFUl9UWVBFX0lOU1RFQUQnXToKKyAgICAgICAg ZGF0YVsnZmlyZXMnXSA9ICdJTlNURUFEIE9GJworICAgIGVsc2U6CisgICAg ICAgIGRhdGFbJ2ZpcmVzJ10gPSAnQUZURVInCisKKyAgICAjIFRyaWdnZXIg b2YgdHlwZSBkZWZpbml0aW9uCisgICAgaWYgZGF0YVsndGd0eXBlJ10gJiB0 cmlnZ2VyX2RlZmluaXRpb25bJ1RSSUdHRVJfVFlQRV9ST1cnXToKKyAgICAg ICAgZGF0YVsnaXNfcm93X3RyaWdnZXInXSA9IFRydWUKKyAgICBlbHNlOgor ICAgICAgICBkYXRhWydpc19yb3dfdHJpZ2dlciddID0gRmFsc2UKKworICAg ICMgRXZlbnQgZGVmaW5pdGlvbgorICAgIGlmIGRhdGFbJ3RndHlwZSddICYg dHJpZ2dlcl9kZWZpbml0aW9uWydUUklHR0VSX1RZUEVfSU5TRVJUJ106Cisg ICAgICAgIGRhdGFbJ2V2bnRfaW5zZXJ0J10gPSBUcnVlCisgICAgZWxzZToK KyAgICAgICAgZGF0YVsnZXZudF9pbnNlcnQnXSA9IEZhbHNlCisKKyAgICBp ZiBkYXRhWyd0Z3R5cGUnXSAmIHRyaWdnZXJfZGVmaW5pdGlvblsnVFJJR0dF Ul9UWVBFX0RFTEVURSddOgorICAgICAgICBkYXRhWydldm50X2RlbGV0ZSdd ID0gVHJ1ZQorICAgIGVsc2U6CisgICAgICAgIGRhdGFbJ2V2bnRfZGVsZXRl J10gPSBGYWxzZQorCisgICAgaWYgZGF0YVsndGd0eXBlJ10gJiB0cmlnZ2Vy X2RlZmluaXRpb25bJ1RSSUdHRVJfVFlQRV9VUERBVEUnXToKKyAgICAgICAg ZGF0YVsnZXZudF91cGRhdGUnXSA9IFRydWUKKyAgICBlbHNlOgorICAgICAg ICBkYXRhWydldm50X3VwZGF0ZSddID0gRmFsc2UKKworICAgIGlmIGRhdGFb J3RndHlwZSddICYgdHJpZ2dlcl9kZWZpbml0aW9uWydUUklHR0VSX1RZUEVf VFJVTkNBVEUnXToKKyAgICAgICAgZGF0YVsnZXZudF90dXJuY2F0ZSddID0g VHJ1ZQorICAgIGVsc2U6CisgICAgICAgIGRhdGFbJ2V2bnRfdHVybmNhdGUn XSA9IEZhbHNlCisKKyAgICByZXR1cm4gZGF0YQorCisKK2RlZiBwYXJzZV9y dWxlX2RlZmluaXRpb24ocmVzKToKKyAgICAiIiIKKyAgICBUaGlzIGZ1bmN0 aW9uIGV4dHJhY3RzOgorICAgIC0gZXZlbnRzCisgICAgLSBkb19pbnN0ZWFk CisgICAgLSBzdGF0ZW1lbnRzCisgICAgLSBjb25kaXRpb24KKyAgICBmcm9t IHRoZSBkZWZpbnRpb24gcm93LCBmb3JtcyBhbiBhcnJheSB3aXRoIGZpZWxk cyBhbmQgcmV0dXJucyBpdC4KKyAgICAiIiIKKyAgICByZXNfZGF0YSA9IFtd CisgICAgdHJ5OgorICAgICAgICByZXNfZGF0YSA9IHJlc1sncm93cyddWzBd CisgICAgICAgIGRhdGFfZGVmID0gcmVzX2RhdGFbJ2RlZmluaXRpb24nXQor ICAgICAgICBpbXBvcnQgcmUKKyAgICAgICAgIyBQYXJzZSBkYXRhIGZvciBl dmVudAorICAgICAgICBlX21hdGNoID0gcmUuc2VhcmNoKHIiT05ccysoLiop XHMrVE8iLCBkYXRhX2RlZikKKyAgICAgICAgZXZlbnRfZGF0YSA9IGVfbWF0 Y2guZ3JvdXAoMSkgaWYgZV9tYXRjaCBpcyBub3QgTm9uZSBlbHNlIE5vbmUK KyAgICAgICAgZXZlbnQgPSBldmVudF9kYXRhIGlmIGV2ZW50X2RhdGEgaXMg bm90IE5vbmUgZWxzZSAnJworCisgICAgICAgICMgUGFyc2UgZGF0YSBmb3Ig ZG8gaW5zdGVhZAorICAgICAgICBpbnN0X21hdGNoID0gcmUuc2VhcmNoKHIi XHMrKElOU1RFQUQpXHMrIiwgZGF0YV9kZWYpCisgICAgICAgIGluc3RlYWRf ZGF0YSA9IGluc3RfbWF0Y2guZ3JvdXAoMSkgaWYgaW5zdF9tYXRjaCBpcyBu b3QgTm9uZSBlbHNlIE5vbmUKKyAgICAgICAgaW5zdGVhZCA9IFRydWUgaWYg aW5zdGVhZF9kYXRhIGlzIG5vdCBOb25lIGVsc2UgRmFsc2UKKworICAgICAg ICAjIFBhcnNlIGRhdGEgZm9yIGNvbmRpdGlvbgorICAgICAgICBjb25kaXRp b25fbWF0Y2ggPSByZS5zZWFyY2gociIoPzpXSEVSRSlccysoLiopXHMrKD86 RE8pIiwgZGF0YV9kZWYpCisgICAgICAgIGNvbmRpdGlvbl9kYXRhID0gY29u ZGl0aW9uX21hdGNoLmdyb3VwKDEpIFwKKyAgICAgICAgICAgIGlmIGNvbmRp dGlvbl9tYXRjaCBpcyBub3QgTm9uZSBlbHNlIE5vbmUKKyAgICAgICAgY29u ZGl0aW9uID0gY29uZGl0aW9uX2RhdGEgaWYgY29uZGl0aW9uX2RhdGEgaXMg bm90IE5vbmUgZWxzZSAnJworCisgICAgICAgICMgUGFyc2UgZGF0YSBmb3Ig c3RhdGVtZW50cworICAgICAgICBzdGF0ZW1lbnRfbWF0Y2ggPSByZS5zZWFy Y2goCisgICAgICAgICAgICByIig/OkRPXHMrKSg/OklOU1RFQURccyspPygo LnxcbikqKSIsIGRhdGFfZGVmKQorICAgICAgICBzdGF0ZW1lbnRfZGF0YSA9 IHN0YXRlbWVudF9tYXRjaC5ncm91cCgxKSBpZiBzdGF0ZW1lbnRfbWF0Y2gg ZWxzZSBOb25lCisgICAgICAgIHN0YXRlbWVudCA9IHN0YXRlbWVudF9kYXRh IGlmIHN0YXRlbWVudF9kYXRhIGlzIG5vdCBOb25lIGVsc2UgJycKKworICAg ICAgICAjIHNldCBjb2x1bW5zIHBhcnNlIGRhdGEKKyAgICAgICAgcmVzX2Rh dGFbJ2V2ZW50J10gPSBldmVudC5sb3dlcigpLmNhcGl0YWxpemUoKQorICAg ICAgICByZXNfZGF0YVsnZG9faW5zdGVhZCddID0gaW5zdGVhZAorICAgICAg ICByZXNfZGF0YVsnc3RhdGVtZW50cyddID0gc3RhdGVtZW50CisgICAgICAg IHJlc19kYXRhWydjb25kaXRpb24nXSA9IGNvbmRpdGlvbgorICAgIGV4Y2Vw dCBFeGNlcHRpb24gYXMgZToKKyAgICAgICAgcmV0dXJuIGludGVybmFsX3Nl cnZlcl9lcnJvcihlcnJvcm1zZz1zdHIoZSkpCisgICAgcmV0dXJuIHJlc19k YXRhCg== --047d7bf0c29af37135052eb93234 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers --047d7bf0c29af37135052eb93234--