Hi all,

I just committed the code I wrote trying to improve pagination. I screwed up a bit with the new pagination. 
The problem I encountered is following. If we want to maintain a link to the previous page we have to filter the database table entries with to types of filters: one with lower bound on the id, and the other with the upper bound. As we do so simultaneously with limiting the query output to the maximal page size, we need to change the ordering type depending on the type of the filter. At the moment I am not sure, what it the best way to implement database query with such properties. Could you please take a look on the commit and share your ideas on that?

The current implementation of pagination works correctly but it does not support link to the previous page (first, and next only).

I have been trying to improve pagination for a while, and I now am thinking about starting the parallel work on the implementation of the features we listed before. What do you think about it?

Best regards,
Tatiana

ср, 27 июн. 2018 г. в 21:56, Ludovic Courtès <ludo@gnu.org>:
Hi Tatiana,

Tatiana Sholokhova <tanja201396@gmail.com> skribis:

> On the last week, I had fallen out of the process. I had been having exams
> at the university since the beginning of June. The last exam was
> rescheduled and that has affected my plans. I am sorry for that. Now the
> semester is finished and I am having much more time to focus on our
> project. I am very happy to pass the first evaluation. It is a pleasure for
> me to work with such a great team!

Thank you, and thanks for letting us know.

> In a few days, I am going to implement the whitelist for the static files
> and improve pagination tool performance as we discussed before. Also, I
> intend to make the pagination tool universal and add it to the page which
> displays all builds of a selected evaluation.

Sounds cool!  I haven’t followed your work as closely as I was hoping
for, but it seems like we could merge it quickly, notably because
everyone wants these enhancements.  :-)

> Do you think it would be okay if I add auxiliary pagination filters to
> the request which retrieves builds from the database?

Why not.  Depending on the filter, We may need to add indexes to the
database (see the bottom of ‘schema.sql’) so that requests aren’t too
slow.

Thank you for the update!

Ludo’.