From mboxrd@z Thu Jan 1 00:00:00 1970 From: Tatiana Sholokhova Subject: Re: GSoC: Adding a web interface similar to the Hydra web interface Date: Sun, 8 Jul 2018 21:48:32 +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="0000000000003990830570822f84" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:50736) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fcFfp-0006Uv-W6 for guix-devel@gnu.org; Sun, 08 Jul 2018 15:48:47 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fcFfp-00055Q-4Y for guix-devel@gnu.org; Sun, 08 Jul 2018 15:48:46 -0400 Received: from mail-oi0-x229.google.com ([2607:f8b0:4003:c06::229]:41871) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fcFfo-00054k-V2 for guix-devel@gnu.org; Sun, 08 Jul 2018 15:48:45 -0400 Received: by mail-oi0-x229.google.com with SMTP id k12-v6so32136971oiw.8 for ; Sun, 08 Jul 2018 12:48:44 -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: =?UTF-8?Q?G=C3=A1bor_Boskovits?= Cc: guix-devel --0000000000003990830570822f84 Content-Type: text/plain; charset="UTF-8" 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? Could you please review the last 3 commits and maybe find some more issues besides that? Best regards, Tatiana --0000000000003990830570822f84 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
=C2=A0Hello all!

Thank you for your hel= pful comments and ideas!

I've committed an imp= roved=C2=A0version of the pagination. As you advised I chose and implemente= d (2) variant. I alter=C2=A0sorting order in SQL query depending on the typ= e of the current page border. So, now all operators=C2=A0(gotofirst, gotola= st, next and previous)=C2=A0are working.

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

Could you please review th= e last 3 commits and maybe find some more issues besides that?
Best regards,
Tatiana

--0000000000003990830570822f84--