From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?UTF-8?Q?G=C3=A1bor_Boskovits?= Subject: Re: GSoC: Adding a web interface similar to the Hydra web interface Date: Sun, 8 Jul 2018 23:19:59 +0200 Message-ID: References: <87tvqxy4i9.fsf@elephly.net> <87in78hxo2.fsf@elephly.net> <878t7xb58o.fsf@elephly.net> <874lijbqvf.fsf@elephly.net> <20180606200210.7a9c4dd6@scratchpost.org> <20180612183504.2621cefa@scratchpost.org> <8736xrd64y.fsf@elephly.net> <8736x8ype9.fsf@gnu.org> <20180705102753.6bc57971@scratchpost.org> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="00000000000041938c05708376ec" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:35671) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fcH6K-0002UH-V2 for guix-devel@gnu.org; Sun, 08 Jul 2018 17:20:14 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fcH6J-0006zH-OY for guix-devel@gnu.org; Sun, 08 Jul 2018 17:20:12 -0400 Received: from mail-it0-x22f.google.com ([2607:f8b0:4001:c0b::22f]:38987) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fcH6J-0006y4-GC for guix-devel@gnu.org; Sun, 08 Jul 2018 17:20:11 -0400 Received: by mail-it0-x22f.google.com with SMTP id p185-v6so23843005itp.4 for ; Sun, 08 Jul 2018 14:20:11 -0700 (PDT) In-Reply-To: List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org Sender: "Guix-devel" To: Tatiana Sholokhova Cc: Guix-devel --00000000000041938c05708376ec Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Tatiana Sholokhova ezt =C3=ADrta (id=C5=91pont: 201= 8. j=C3=BAl. 8., V, 21:48): > Hello all! > > Thank you for your helpful comments and ideas! > > I've committed an improved version of the pagination. As you advised I > chose and implemented (2) variant. I alter sorting order in SQL query > depending on the type of the current page border. So, now all > operators (gotofirst, gotolast, next and previous) are working. > > Also, I added pagination for builds page ("eval" query). Here I face a > problem that Denny mentioned before. > >> The tuple of data cells should uniquely identify one row in the result. >> (If it >> didn't, you'd skip the other same-value rows when going to the next page= ) > > I order builds by stoptime and there are some builds with identical > stoptime timestamps. I am not sure what is the best way to support > pagination filtering by multiple columns. Do you have ideas on how to > implement tuple comparison and other routines in SQL and guile in a > convenient and flexible way? > > Please have a look at this. https://www.sqlite.org/rowvalue.html. I did not check the sqlite version. > Could you please review the last 3 commits and maybe find some more issue= s > besides that? > > Best regards, > Tatiana > > --00000000000041938c05708376ec Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Tatiana Sholok= hova <tanja201396@gmail.com= > ezt =C3=ADrta (id=C5=91pont: 2018. j=C3=BAl. 8., V, 21:48):
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">
=C2=A0Hel= lo all!

Thank you for your helpful comments and ideas!

I've committed an improved=C2=A0version of the = pagination. As you advised I chose and implemented (2) variant. I alter=C2= =A0sorting order in SQL query depending on the type of the current page bor= der. So, now all operators=C2=A0(gotofirst, gotolast, next and previous)=C2= =A0are working.

Also, I added pagination for build= s page ("eval" query). Here I face=C2=A0a problem that Denny ment= ioned before.=C2=A0
= The tuple of data cells should uniquely identify one row in the result.=C2= =A0 (If it
didn't, you'd skip the other same-value rows when goi= ng to the next page)
I order builds by=C2=A0stoptime=C2=A0= and there are some builds with identical stoptime=C2=A0timestamps.=C2=A0I a= m not sure what is the best way to support pagination filtering by multiple= columns. Do you have ideas on how to implement tuple comparison and other = routines in SQL and guile in a convenient and flexible way?=C2=A0 =C2=A0


Please have a look= at this.=C2=A0https://www= .sqlite.org/rowvalue.html. I did not check the sqlite version.
=C2=A0
Could you please review the last 3 commits and maybe = find some more issues besides that?

Best regards,<= /div>
Tatiana

--00000000000041938c05708376ec--