Thanks, patch applied (test time now down to 209s :-) ). On Mon, Aug 28, 2017 at 11:04 AM, Harshal Dhumal < harshal.dhu...@enterprisedb.com> wrote:
> Hi, > > Please find attached updated patch > > On Fri, Aug 25, 2017 at 2:32 PM, Dave Page <dp...@pgadmin.org> wrote: > >> Hi >> >> On Thu, Aug 24, 2017 at 11:51 AM, Harshal Dhumal < >> harshal.dhu...@enterprisedb.com> wrote: >> >>> Hi, >>> >>> Last week Sarah, Matt and I had call regarding some issues with feature >>> test cases. >>> For example in auto commit disable test scenario from query tool test >>> cases by removing code line >>> *self.page.find_by_id("btn-auto-commit").click() *the test case >>> scenario was not falling. >>> This issue was due to previously on going database transaction. This >>> issue was also with test scenarios like >>> auto commit enable and auto rollback enabled. The attached patch fixes >>> this issue. >>> >>> @Sarah and Matt can you please give this patch a try to check if issues >>> we discussed last week are fixed. >>> >> >> I don't think Matt and Sarah are working on pgAdmin any more :-( >> >> I just tried this patch, and whilst the tests all passed, it spent quite >> some time typing "select * from hats" into random places in the query tool, >> such that it ended up running queries like >> >> select * select * select * from hats from hats from hats >> >> I don't remember it doing that before; I think it was a) clearing >> codemirror each time and b) entering the text much more quickly (in fact I >> just tried it, and it enters the text and executes the query so fast the >> screen basically strobes). >> > Fixed. > > >> Performance-wise, I got 266 seconds with the patch, and 378 without, so >> there's definitely some good improvement here, just a little funkyness with >> the query tool journey test. >> > > Recently Wenlin Zhang has fixed this in this commit > <https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=commitdiff;h=5dd375dd2081c126b7b3b9f0dba21976d2a45a1f>. > Here is link > <https://www.postgresql.org/message-id/flat/CAEawo3JKQFuVeSK-xw9wU4fUSY57KXU5GeXKcdCusQeHkjTykA%40mail.gmail.com#caeawo3jkqfuvesk-xw9wu4fusy57kxu5gexkcdcusqehkjt...@mail.gmail.com> > to email thread. > > >> Thanks. >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company