Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1apvUk-0006Ha-Vf for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Apr 2016 10:24:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1apvUk-0000An-Dr for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Apr 2016 10:24:30 +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 1apvUW-0008NT-Ly for pgadmin-hackers@postgresql.org; Tue, 12 Apr 2016 10:24:16 +0000 Received: from mail-oi0-x22e.google.com ([2607:f8b0:4003:c06::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1apvUS-0006gP-Ok for pgadmin-hackers@postgresql.org; Tue, 12 Apr 2016 10:24:16 +0000 Received: by mail-oi0-x22e.google.com with SMTP id w85so16623830oiw.0 for ; Tue, 12 Apr 2016 03:24:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:date:message-id:subject:from:to; bh=lA/ZuyhoeyC/7+ksikfAgouyEhiR9pQVu95lRVJXtJo=; b=ht74ZO+DAGGQDD4083YtB4Fa8brOJnw7ckHTwmwG3c1xJ19n1h+QxrJQmEVKWYqV2E Sb7XiCSKKuhv4AMmv+noKW7CP1ebXbGsyeyAPP03gucmCNQk2z25FVkh6KpVsXTn9oSW 03sCJ/JsBfBO2rr43bElnzaahDzqH7K6UVgM5yIIKx5tm4cngCptxsRzvvMDfgEmldKr twkTdktS/m2aM2KUXui6HJbgN9hCMlqTu1TY08gHkzYGsP4tY52JIr93iw8x5UzB/RFC H27I0NFPfHliRVC06q7Re2ucJLLe4ccxnSWJNw3lZ/R3hy/cEr54eLyMmWdRGo7+9tYA /XgA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to; bh=lA/ZuyhoeyC/7+ksikfAgouyEhiR9pQVu95lRVJXtJo=; b=lqdY+8xDg/KVVPJJ1Nn2jm2I41xHnxTSJquFroXZt4+JVaGrxiPO/o6iXbIyPFD/Yk F0/N1nEsvuFJ9I/LEzqnoOFmb6PipNnO9kS0SCGjX7TOpNpBecaSwUB83tyQbmdugLmP mzuXBcDgD/qPYsOn7VB+7GWoiDAz1XGk+yf/oxuOuBJNE3KKe1v3iP5O7+/dLog8V7DM XXnSFiV/0EUVyXMv2Ke6BAs6EJMMYtLRwJtcChd0kdmUEsIn07IgqCIIoHFIdroUhn/1 RUrBEWxA4kDvtoG0+6/+Kja8OUPTdbMIqwElC+Bnaw3GEyKgADWTzs4uYk73O2+DFN7I re3w== X-Gm-Message-State: AOPr4FWuGGhZ/Q9Pizb2AoBeB7cHaYw3TuNQC99CqQC6RrmYAO5Labsvxo2ay3Ce929Q99PjHG3WH9axl7jkMKw7 MIME-Version: 1.0 X-Received: by 10.157.0.37 with SMTP id 34mr973593ota.161.1460456650482; Tue, 12 Apr 2016 03:24:10 -0700 (PDT) Received: by 10.202.49.194 with HTTP; Tue, 12 Apr 2016 03:24:10 -0700 (PDT) Date: Tue, 12 Apr 2016 15:54:10 +0530 Message-ID: Subject: [pgAdmin4][Patch] Add affected row count support in psycopg2 From: Akshay Joshi To: pgadmin-hackers Content-Type: multipart/mixed; boundary=94eb2c032edadd87fb0530470fcd X-Pg-Spam-Score: -1.0 (-) 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 --94eb2c032edadd87fb0530470fcd Content-Type: multipart/alternative; boundary=94eb2c032edadd87f60530470fcb --94eb2c032edadd87f60530470fcb Content-Type: text/plain; charset=UTF-8 Hi All While implementing Query Tool, we need the affected row count for the queries (DELETE, SELECT, UPDATE etc..) executed on the database server. I have implemented the same. Attached is the patch file, please review it and let me know the review comments if any. -- *Akshay Joshi* *Principal Software Engineer * *Phone: +91 20-3058-9517Mobile: +91 976-788-8246* --94eb2c032edadd87f60530470fcb Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi All

While implementing Query Tool, we need the affected row count for the quer= ies=C2=A0(DELETE, SELECT, UPDATE et= c..)=C2=A0executed on the database server. I have implemented the same. Att= ached is the patch file, please review it and let me know the review=C2=A0c= omments=C2=A0if any.=C2=A0


--
Akshay Joshi
Principal Software Engineer=C2=A0

<= img src=3D"http://www.enterprisedb.com/sites/default/files/EDB-logo-4c.png"= width=3D"96" height=3D"54">

Phone: +91 20-3058-9517
= Mobile: +91 976-788-8246
--94eb2c032edadd87f60530470fcb-- --94eb2c032edadd87fb0530470fcd Content-Type: application/octet-stream; name="Psycopg2_rows_affected.patch" Content-Disposition: attachment; filename="Psycopg2_rows_affected.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_imxa5k0w0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3V0aWxzL2RyaXZlci9hYnN0cmFj dC5weSBiL3dlYi9wZ2FkbWluL3V0aWxzL2RyaXZlci9hYnN0cmFjdC5weQpp bmRleCBlMDY4Y2E0Li4yZGRjN2RkIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1p bi91dGlscy9kcml2ZXIvYWJzdHJhY3QucHkKKysrIGIvd2ViL3BnYWRtaW4v dXRpbHMvZHJpdmVyL2Fic3RyYWN0LnB5CkBAIC0xNDEsNiArMTQxLDEwIEBA IGNsYXNzIEJhc2VDb25uZWN0aW9uKG9iamVjdCk6CiAgICAgKiBtZXNzYWdl cygpCiAgICAgICAtIEltcGxlbWVudCB0aGlzIG1ldGhvZCB0byByZXR1cm4g dGhlIGxpc3Qgb2YgdGhlIG1lc3NhZ2VzL25vdGljZXMgZnJvbQogICAgICAg ICB0aGUgZGF0YWJhc2Ugc2VydmVyLgorCisgICAgKiByb3dzX2FmZmVjdGVk KCkKKyAgICAgIC0gSW1wbGVtZW50IHRoaXMgbWV0aG9kIHRvIGdldCB0aGUg cm93cyBhZmZlY3RlZCBieSB0aGUgbGFzdCBjb21tYW5kCisgICAgICAgIGV4 ZWN1dGVkIG9uIHRoZSBzZXJ2ZXIuCiAgICAgIiIiCiAKICAgICBBU1lOQ19P SyA9IDEKQEAgLTIxMCw1ICsyMTQsOSBAQCBjbGFzcyBCYXNlQ29ubmVjdGlv bihvYmplY3QpOgogICAgICAgICBwYXNzCiAKICAgICBAYWJzdHJhY3RtZXRo b2QKKyAgICBkZWYgcm93c19hZmZlY3RlZChzZWxmKToKKyAgICAgICAgcGFz cworCisgICAgQGFic3RyYWN0bWV0aG9kCiAgICAgZGVmIGNhbmNlbF90cmFu c2FjdGlvbihzZWxmLCBjb25uX2lkLCBkaWQ9Tm9uZSk6CiAgICAgICAgIHBh c3MKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3V0aWxzL2RyaXZlci9wc3lj b3BnMi9fX2luaXRfXy5weSBiL3dlYi9wZ2FkbWluL3V0aWxzL2RyaXZlci9w c3ljb3BnMi9fX2luaXRfXy5weQppbmRleCA4NDk2Mzc5Li42Mzg2OWUzIDEw MDY0NAotLS0gYS93ZWIvcGdhZG1pbi91dGlscy9kcml2ZXIvcHN5Y29wZzIv X19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4vdXRpbHMvZHJpdmVyL3Bz eWNvcGcyL19faW5pdF9fLnB5CkBAIC05OCw2ICs5OCw5IEBAIGNsYXNzIENv bm5lY3Rpb24oQmFzZUNvbm5lY3Rpb24pOgogICAgICogc3RhdHVzX21lc3Nh Z2UoKQogICAgICAgLSBSZXR1cm5zIHRoZSBzdGF0dXMgbWVzc2FnZSByZXR1 cm5lZCBieSB0aGUgbGFzdCBjb21tYW5kIGV4ZWN1dGVkIG9uIHRoZSBzZXJ2 ZXIuCiAKKyAgICAqIHJvd3NfYWZmZWN0ZWQoKQorICAgICAgLSBSZXR1cm5z IHRoZSBubyBvZiByb3dzIGFmZmVjdGVkIGJ5IHRoZSBsYXN0IGNvbW1hbmQg ZXhlY3V0ZWQgb24gdGhlIHNlcnZlci4KKwogICAgICogY2FuY2VsX3RyYW5z YWN0aW9uKGNvbm5faWQsIGRpZD1Ob25lKQogICAgICAgLSBUaGlzIG1ldGhv ZCBpcyB1c2VkIHRvIGNhbmNlbCB0aGUgdHJhbnNhY3Rpb24gZm9yIHRoZQog ICAgICAgICBzcGVjaWZpZWQgY29ubmVjdGlvbiBpZCBhbmQgZGF0YWJhc2Ug aWQuCkBAIC0xMjYsNiArMTI5LDcgQEAgY2xhc3MgQ29ubmVjdGlvbihCYXNl Q29ubmVjdGlvbik6CiAgICAgICAgIHNlbGYuX19hc3luY19xdWVyeV9pZCA9 IE5vbmUKICAgICAgICAgc2VsZi5fX2JhY2tlbmRfcGlkID0gTm9uZQogICAg ICAgICBzZWxmLmV4ZWN1dGlvbl9hYm9ydGVkID0gRmFsc2UKKyAgICAgICAg c2VsZi5yb3dfY291bnQgPSAwCiAKICAgICAgICAgc3VwZXIoQ29ubmVjdGlv biwgc2VsZikuX19pbml0X18oKQogCkBAIC00MjIsNiArNDI2LDcgQEAgQXR0 ZW1wdCB0byByZWNvbm5lY3QgaXQgZmFpbGVkIHdpdGggdGhlIGJlbG93IGVy cm9yOgogCiAgICAgZGVmIGV4ZWN1dGVfc2NhbGFyKHNlbGYsIHF1ZXJ5LCBw YXJhbXM9Tm9uZSwgZm9ybWF0dGVkX2V4Y2VwdGlvbl9tc2c9RmFsc2UpOgog ICAgICAgICBzdGF0dXMsIGN1ciA9IHNlbGYuX19jdXJzb3IoKQorICAgICAg ICBzZWxmLnJvd19jb3VudCA9IDAKIAogICAgICAgICBpZiBub3Qgc3RhdHVz OgogICAgICAgICAgICAgcmV0dXJuIEZhbHNlLCBzdHIoY3VyKQpAQCAtNDUx LDYgKzQ1Niw3IEBAIEF0dGVtcHQgdG8gcmVjb25uZWN0IGl0IGZhaWxlZCB3 aXRoIHRoZSBiZWxvdyBlcnJvcjoKICAgICAgICAgICAgICAgICAgICAgKQog ICAgICAgICAgICAgcmV0dXJuIEZhbHNlLCBlcnJtc2cKIAorICAgICAgICBz ZWxmLnJvd19jb3VudCA9IGN1ci5yb3djb3VudAogICAgICAgICBpZiBjdXIu cm93Y291bnQgPiAwOgogICAgICAgICAgICAgcmVzID0gY3VyLmZldGNob25l KCkKICAgICAgICAgICAgIGlmIGxlbihyZXMpID4gMDoKQEAgLTUxOCw2ICs1 MjQsNyBAQCBGYWlsZWQgdG8gZXhlY3V0ZSBxdWVyeSAoZXhlY3V0ZV9hc3lu YykgZm9yIHRoZSBzZXJ2ZXIgI3tzZXJ2ZXJfaWR9IC0ge2Nvbm5faWR9CiAg ICAgICAgICAgICBmb3JtYXR0ZWRfZXhjZXB0aW9uX21zZzogaWYgVHJ1ZSB0 aGVuIGZ1bmN0aW9uIHJldHVybiB0aGUgZm9ybWF0dGVkIGV4Y2VwdGlvbiBt ZXNzYWdlCiAgICAgICAgICIiIgogICAgICAgICBzdGF0dXMsIGN1ciA9IHNl bGYuX19jdXJzb3IoKQorICAgICAgICBzZWxmLnJvd19jb3VudCA9IDAKIAog ICAgICAgICBpZiBub3Qgc3RhdHVzOgogICAgICAgICAgICAgcmV0dXJuIEZh bHNlLCBzdHIoY3VyKQpAQCAtNTUxLDEwICs1NTgsMTMgQEAgRmFpbGVkIHRv IGV4ZWN1dGUgcXVlcnkgKGV4ZWN1dGVfdm9pZCkgZm9yIHRoZSBzZXJ2ZXIg I3tzZXJ2ZXJfaWR9IC0ge2Nvbm5faWR9CiAgICAgICAgICAgICApCiAgICAg ICAgICAgICByZXR1cm4gRmFsc2UsIGVycm1zZwogCisgICAgICAgIHNlbGYu cm93X2NvdW50ID0gY3VyLnJvd2NvdW50CisKICAgICAgICAgcmV0dXJuIFRy dWUsIE5vbmUKIAogICAgIGRlZiBleGVjdXRlXzJkYXJyYXkoc2VsZiwgcXVl cnksIHBhcmFtcz1Ob25lLCBmb3JtYXR0ZWRfZXhjZXB0aW9uX21zZz1GYWxz ZSk6CiAgICAgICAgIHN0YXR1cywgY3VyID0gc2VsZi5fX2N1cnNvcigpCisg ICAgICAgIHNlbGYucm93X2NvdW50ID0gMAogCiAgICAgICAgIGlmIG5vdCBz dGF0dXM6CiAgICAgICAgICAgICByZXR1cm4gRmFsc2UsIHN0cihjdXIpCkBA IC01OTEsNiArNjAxLDcgQEAgRmFpbGVkIHRvIGV4ZWN1dGUgcXVlcnkgKGV4 ZWN1dGVfdm9pZCkgZm9yIHRoZSBzZXJ2ZXIgI3tzZXJ2ZXJfaWR9IC0ge2Nv bm5faWR9CiAgICAgICAgICAgICAgICAgXSBvciBbXQogCiAgICAgICAgIHJv d3MgPSBbXQorICAgICAgICBzZWxmLnJvd19jb3VudCA9IGN1ci5yb3djb3Vu dAogICAgICAgICBpZiBjdXIucm93Y291bnQgPiAwOgogICAgICAgICAgICAg Zm9yIHJvdyBpbiBjdXI6CiAgICAgICAgICAgICAgICAgcm93cy5hcHBlbmQo cm93KQpAQCAtNTk5LDYgKzYxMCw3IEBAIEZhaWxlZCB0byBleGVjdXRlIHF1 ZXJ5IChleGVjdXRlX3ZvaWQpIGZvciB0aGUgc2VydmVyICN7c2VydmVyX2lk fSAtIHtjb25uX2lkfQogCiAgICAgZGVmIGV4ZWN1dGVfZGljdChzZWxmLCBx dWVyeSwgcGFyYW1zPU5vbmUsIGZvcm1hdHRlZF9leGNlcHRpb25fbXNnPUZh bHNlKToKICAgICAgICAgc3RhdHVzLCBjdXIgPSBzZWxmLl9fY3Vyc29yKCkK KyAgICAgICAgc2VsZi5yb3dfY291bnQgPSAwCiAKICAgICAgICAgaWYgbm90 IHN0YXR1czoKICAgICAgICAgICAgIHJldHVybiBGYWxzZSwgc3RyKGN1cikK QEAgLTYzMyw2ICs2NDUsNyBAQCBGYWlsZWQgdG8gZXhlY3V0ZSBxdWVyeSAo ZXhlY3V0ZV92b2lkKSBmb3IgdGhlIHNlcnZlciAje3NlcnZlcl9pZH0gLSB7 Y29ubl9pZH0KICAgICAgICAgICAgICAgICBdIG9yIFtdCiAKICAgICAgICAg cm93cyA9IFtdCisgICAgICAgIHNlbGYucm93X2NvdW50ID0gY3VyLnJvd2Nv dW50CiAgICAgICAgIGlmIGN1ci5yb3djb3VudCA+IDA6CiAgICAgICAgICAg ICBmb3Igcm93IGluIGN1cjoKICAgICAgICAgICAgICAgICByb3dzLmFwcGVu ZChkaWN0KHJvdykpCkBAIC03ODksNiArODAyLDcgQEAgRmFpbGVkIHRvIHJl c2V0IHRoZSBjb25uZWN0aW9uIG9mIHRoZSBzZXJ2ZXIgZHVlIHRvIGZvbGxv d2luZyBlcnJvcjoKIAogICAgICAgICBjb2xpbmZvID0gTm9uZQogICAgICAg ICByZXN1bHQgPSBOb25lCisgICAgICAgIHNlbGYucm93X2NvdW50ID0gMAog ICAgICAgICBpZiBzdGF0dXMgPT0gc2VsZi5BU1lOQ19PSzoKIAogICAgICAg ICAgICAgIyBpZiB1c2VyIGhhcyBjYW5jZWxsZWQgdGhlIHRyYW5zYWN0aW9u IHRoZW4gY2hhbmdlZCB0aGUgc3RhdHVzCkBAIC04MDEsNiArODE1LDcgQEAg RmFpbGVkIHRvIHJlc2V0IHRoZSBjb25uZWN0aW9uIG9mIHRoZSBzZXJ2ZXIg ZHVlIHRvIGZvbGxvd2luZyBlcnJvcjoKICAgICAgICAgICAgIGlmIGN1ci5k ZXNjcmlwdGlvbiBpcyBub3QgTm9uZToKICAgICAgICAgICAgICAgICBjb2xp bmZvID0gW2Rlc2MgZm9yIGRlc2MgaW4gY3VyLmRlc2NyaXB0aW9uXQogCisg ICAgICAgICAgICBzZWxmLnJvd19jb3VudCA9IGN1ci5yb3djb3VudAogICAg ICAgICAgICAgaWYgY3VyLnJvd2NvdW50ID4gMDoKICAgICAgICAgICAgICAg ICByZXN1bHQgPSBbXQogCkBAIC04MzQsNiArODQ5LDE0IEBAIEZhaWxlZCB0 byByZXNldCB0aGUgY29ubmVjdGlvbiBvZiB0aGUgc2VydmVyIGR1ZSB0byBm b2xsb3dpbmcgZXJyb3I6CiAKICAgICAgICAgcmV0dXJuIGN1ci5zdGF0dXNt ZXNzYWdlCiAKKyAgICBkZWYgcm93c19hZmZlY3RlZChzZWxmKToKKyAgICAg ICAgIiIiCisgICAgICAgIFRoaXMgZnVuY3Rpb24gd2lsbCByZXR1cm4gdGhl IG5vIG9mIHJvd3MgYWZmZWN0ZWQgYnkgdGhlIGxhc3QgY29tbWFuZAorICAg ICAgICBleGVjdXRlZCBvbiB0aGUgc2VydmVyLgorICAgICAgICAiIiIKKwor ICAgICAgICByZXR1cm4gc2VsZi5yb3dfY291bnQKKwogICAgIGRlZiBjYW5j ZWxfdHJhbnNhY3Rpb24oc2VsZiwgY29ubl9pZCwgZGlkPU5vbmUpOgogICAg ICAgICAiIiIKICAgICAgICAgVGhpcyBmdW5jdGlvbiBpcyB1c2VkIHRvIGNh bmNlbCB0aGUgcnVubmluZyB0cmFuc2FjdGlvbgo= --94eb2c032edadd87fb0530470fcd 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 --94eb2c032edadd87fb0530470fcd--