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 1kKKOl-0002M5-0c for pgadmin-hackers@arkaria.postgresql.org; Mon, 21 Sep 2020 11:54:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kKKOk-0004s7-0C for pgadmin-hackers@arkaria.postgresql.org; Mon, 21 Sep 2020 11:54:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kKKOj-0004rw-It for pgadmin-hackers@lists.postgresql.org; Mon, 21 Sep 2020 11:54:21 +0000 Received: from mail-il1-x141.google.com ([2607:f8b0:4864:20::141]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kKKOg-0007oJ-M9 for pgadmin-hackers@postgresql.org; Mon, 21 Sep 2020 11:54:20 +0000 Received: by mail-il1-x141.google.com with SMTP id s88so13374001ilb.6 for ; Mon, 21 Sep 2020 04:54:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=KPxM5ai2v93BdUt+3migrtaHJ2mNs0tSz0SDmOVKsxM=; b=Dh6oHpy5PFdH29xXIBGg18BEjUot5s8vWXGwW3Jqf2NPtxCejYa19Pffkx5MS1RKcU wu1Pu3EfLkO2EzKNa27zlztbPqHEam+X15BZRPztjkue1qmBEx102fLuhpxfm1qQ4cOa a8F53VdxooAWAWz9O/xq+Wmczno3tYBf1hWXheYq2As8QwMXfpQvkRZPClU6SdpcIVfZ jXmc5OpGfj8LbVo1+KVNzLos5qtBTbRBj27TBs21PbE1zrWwjd7+15o2cewLw45s6QLF IUWinEjn1U8vD2sOCTaGgzVyK6nMrqw0gLQrcUiX8LWm+Wv2FP+wY2xEzoLa8yxyF3ny 34Xw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=KPxM5ai2v93BdUt+3migrtaHJ2mNs0tSz0SDmOVKsxM=; b=OwIR953nLGLwcY7KAe+HRv++jlu534Jk1Kan2JbEDIvsXexaxe/UVFoAOMWi2GHNsj uZ//DVHY456KtIxURmJIr4Rhs/RvoBrYKynWpAvpi8Msg5EooJ6Pt1NeUkTYU2SevVTf +guAuryYQuxybwUDQhNUc0lZ8SjMZRBEhS5AdspPk9V1s/+Ik5qK9ot2AU6+3e8ok9tK mMDwNPCJVJHQSf5qk1Cq4pzEvkDeb/VJz9O8kjD3LbhvEo/4dGdJUg4ifQSE7FL2r7Yp Kua4e7k6H58orCveqJKrZJVjBoouKLUNGPcAq4E/PdKSUXbvqU/KUR1bLfz2IGYNUYif ambQ== X-Gm-Message-State: AOAM5312neOuLVoW0qDuMKTNILsZeS8Af6TK2xydzlVO5So2rNx697nF Ak3IyWciS84JoMePHxyhcTGsgugmETO78w+v8J3pOOqLacDBXJHxyC2byHEsqyfrAte9a3hY7mT vaHknZyn8Ck3Pc//7nCEA1HYhEchLxh848uFO41s5d+1VJd8D+DSP97Gfy3mz1eqsFxlZh+AuL/ NEa1v91tY7nyaCqxpH++dJMtuSMilXXmmg7rcl9n8B6R0+j4YHjuKl6x82Tg== X-Google-Smtp-Source: ABdhPJxjlg+N4tK0oV0FW4J8Jn48RGd79+mgacgKU/Nsem4Sf2vptwa8CE9F5X+AQVcKEYmGJ+pd53JAdJX0ViJCIDA= X-Received: by 2002:a92:7711:: with SMTP id s17mr31411031ilc.236.1600689256889; Mon, 21 Sep 2020 04:54:16 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Mon, 21 Sep 2020 17:24:06 +0530 Message-ID: Subject: Re: [pgAdmin][RM3794]:Allow User to Change Database Connection from an Open Query Tool Tab To: Nikhil Mohite Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000008d981b05afd18255" 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 --0000000000008d981b05afd18255 Content-Type: text/plain; charset="UTF-8" Hi Nikhil Following are the initial review comments: - Open View/Edit data on any table and click on the same database connection and then click on the Execute button. Got "get_primary_keys() takes 1 positional argument but 2 were given" error. - In my opinion, we should hide the option to change the database connection for View/Edit Data. - If the user clicks on the same database connection multiple times then no need to change the backend connection and transaction id. Add validation at the backend, no action required in this case. - The role option is missing from the "connect to server" dialog. - The Password field should not be there on the "connect to server" dialog. Sometimes we saved the password so asking a password every time is not correct. Check the pgAdmin 3 behavior. Code review still remains. On Thu, Sep 17, 2020 at 4:15 PM Nikhil Mohite < nikhil.mohite@enterprisedb.com> wrote: > Hi Team, > > Regarding RM-3794 allow > the user to change the database connection from an open query tool: > I have implemented the feature and also added documentation for it. > > PFA patch. > > -- > *Thanks & Regards,* > *Nikhil Mohite* > *Software Engineer.* > *EDB Postgres* > *Mob.No: +91-7798364578.* > -- *Thanks & Regards* *Akshay Joshi* *pgAdmin Hacker | Sr. Software Architect* *EDB Postgres * *Mobile: +91 976-788-8246* --0000000000008d981b05afd18255 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Nikhil

Following are the initia= l review comments:
  • Open View/Edit data on any table and click o= n the same database connection and then click on the Execute button. Got &q= uot;get_primary_keys() takes 1 positional argument but 2 were given" e= rror.
  • In my opinion, we should hide the option to change the databa= se connection for View/Edit Data.
  • If the user clicks on the same da= tabase connection multiple times then no need to change the backend connect= ion and transaction id. Add validation at the backend, no action required i= n this case.
  • The role option is missing from the "connect to s= erver" dialog.
  • The Password field should not be there on the &= quot;connect to server" dialog. Sometimes we saved the password so ask= ing a password every time is not correct. Check the pgAdmin 3 behavior.
Code review still remains.

On Thu, Sep 17, 2020 at 4:15 PM= Nikhil Mohite <nikhil= .mohite@enterprisedb.com> wrote:
Hi Team,

Regard= ing RM-3794 allow the=C2=A0user to change the database connection from an= open query tool:
I have implemented the feature and also added d= ocumentation for it.

PFA patch.

=
--
Thanks & Regards,
Nikhil Mohite
Software Engineer.
Mob.= No: +91-7798364578.


--
Thanks & Regards
Akshay Joshi
pgAdmi= n Hacker | Sr. Software Architect
EDB Postgres
Mobile: +91 976-788-8246
=
--0000000000008d981b05afd18255--