[io+ddlmZddlZddlmZddlZddlm Z ddl m Z ddl m Z GddZGdd eZGd d eZy) ) annotationsN)ceil)abort)requestcXeZdZdZ d ddZeddddd ddZeddZddZ dd Z edd Z edd Z edd Z edd Zed dZddd!dZeddZed dZddd!dZddddd d"dZd#dZy)$ PaginationaUApply an offset and limit to the query based on the current page and number of items per page. Don't create pagination objects manually. They are created by :meth:`.SQLAlchemy.paginate` and :meth:`.Query.paginate`. This is a base class, a subclass must implement :meth:`_query_items` and :meth:`_query_count`. Those methods will use arguments passed as ``kwargs`` to perform the queries. :param page: The current page, used to calculate the offset. Defaults to the ``page`` query arg during a request, or 1 otherwise. :param per_page: The maximum number of items on a page, used to calculate the offset and limit. Defaults to the ``per_page`` query arg during a request, or 20 otherwise. :param max_per_page: The maximum allowed value for ``per_page``, to limit a user-provided value. Use ``None`` for no limit. Defaults to 100. :param error_out: Abort with a ``404 Not Found`` error if no items are returned and ``page`` is not 1, or if ``page`` or ``per_page`` is less than 1, or if either are not ints. :param count: Calculate the total number of values by issuing an extra count query. For very complex queries this may be inaccurate or slow, so it can be disabled and set manually if necessary. :param kwargs: Information about the query to paginate. Different subclasses will require different arguments. .. versionchanged:: 3.0 Iterating over a pagination object iterates over its items. .. versionchanged:: 3.0 Creating instances manually is not a public API. NTc ||_|j||||\}}||_ ||_ ||_ |j }|s|dk7r |r t d||_ |r|j}||_ yd}||_ y)Npageper_page max_per_page error_out) _query_args_prepare_page_argsr r r _query_itemsritems _query_counttotal) selfr r r rcountkwargsrrs S/var/www/timesheet/venv/lib/python3.12/site-packages/flask_sqlalchemy/pagination.py__init__zPagination.__init__.s"00% 1 h % 4(49!!#y #J"'   %%'E"' 9E!& 9r ctrY|* ttjjdd}|3 ttjjdd}n|d}|d}| t||}|dkr|r t dnd}|dkr|rt d||fSd}||fS#tt f$r|r t dd}YwxYw#tt f$r|r t dd}YwxYw)Nr rrr )rintargsget TypeError ValueErrorrminr s rrzPagination._prepare_page_argsZs  |w||//:;D""7<<#3#3J#CDH|  #8\2H !8c  a<c X~X~I":. c D ":." c !H "s")B')C 'CC C,+C,c:|jdz |jzS)z}The index of the first item to query, passed to ``offset()``. :meta private: .. versionadded:: 3.0 r)r r rs r _query_offsetzPagination._query_offsets A ..rct)zExecute the query to get the items on the current page. Uses init arguments stored in :attr:`_query_args`. :meta private: .. versionadded:: 3.0 NotImplementedErrorr&s rrzPagination._query_items "!rct)zExecute the query to get the total number of items. Uses init arguments stored in :attr:`_query_args`. :meta private: .. versionadded:: 3.0 r)r&s rrzPagination._query_countr+rcrt|jdk(ry|jdz |jzdzS)zThe number of the first item on the page, starting from 1, or 0 if there are no items. .. versionadded:: 3.0 rr)lenrr r r&s rfirstzPagination.firsts3 tzz?a  A .22rcd|j}t||t|jzdz S)zThe number of the last item on the page, starting from 1, inclusive, or 0 if there are no items. .. versionadded:: 3.0 r)r/maxr.r)rr/s rlastzPagination.lasts, 5%#djj/1A566rc~|jdk(s |jyt|j|jz S)zThe total number of pages.r)rrr r&s rpageszPagination.pagess3 ::?djj0DJJ.//rc |jdkDS)z'``True`` if this is not the first page.r)r r&s rhas_prevzPagination.has_prevsyy1}rc:|jsy|jdz S)z@The previous page number, or ``None`` if this is the first page.Nr)r6r r&s rprev_numzPagination.prev_num}}yy1}rF)rct|d|jdz |j|dd|j}|j|_|S)aQuery the :class:`Pagination` object for the previous page. :param error_out: Abort with a ``404 Not Found`` error if no items are returned and ``page`` is not 1, or if ``page`` or ``per_page`` is less than 1, or if either are not ints. rF)r r rr)typer r rrrrps rprevzPagination.prevsS DJ Q]]    **rc4|j|jkS)z&``True`` if this is not the last page.)r r4r&s rhas_nextzPagination.has_nextsyy4::%%rc:|jsy|jdzS)z;The next page number, or ``None`` if this is the last page.Nr)rAr r&s rnext_numzPagination.next_numr9rc t|d|jdz|j|j|dd|j}|j |_|S)aQuery the :class:`Pagination` object for the next page. :param error_out: Abort with a ``404 Not Found`` error if no items are returned and ``page`` is not 1, or if ``page`` or ``per_page`` is less than 1, or if either are not ints. rF)r r r rrr;)r<r r r rrr=s rnextzPagination.nexts\ DJ Q]]**    **r) left_edge left_current right_current right_edgec#K|jdz}|dk(rytd|z|}td|Ed{||k(ryt||j|z }t|j|zdz|}||z dkDrdt||Ed{||k(ryt|||z } | |z dkDrdt| |Ed{y77<7 w)aYield page numbers for a pagination widget. Skipped pages between the edges and middle are represented by a ``None``. For example, if there are 20 pages and the current page is 7, the following values are yielded. .. code-block:: python 1, 2, None, 5, 6, 7, 8, 9, 10, 11, None, 19, 20 :param left_edge: How many pages to show from the first page. :param left_current: How many pages to show left of the current page. :param right_current: How many pages to show right of the current page. :param right_edge: How many pages to show from the last page. .. versionchanged:: 3.0 Improved efficiency of calculating what to yield. .. versionchanged:: 3.0 ``right_current`` boundary is inclusive. .. versionchanged:: 3.0 All parameters are keyword-only. rNr)r4r$ranger1r ) rrHrIrJrK pages_endleft_end mid_startmid_end right_starts r iter_pageszPagination.iter_pagess@JJN > q9}i0H%%% y $))l":; dii-/!3Y? x ! #JG,,, i  '9z#9:  1 $Ji000+ & - 1s44CC ACC4CCCCCc#8K|jEd{y7w)N)rr&s r__iter__zPagination.__iter__Ds::s )NNdTT)r int | Noner rWr rWrboolrrXrzt.AnyreturnNone) r rWr rWr rWrrXrYztuple[int, int]rYrrYz list[t.Any])rYrX)rYrW)rrXrYr) rHrrIrrJrrKrrYzt.Iterator[int | None])rYzt.Iterator[t.Any])__name__ __module__ __qualname____doc__r staticmethodrpropertyr'rrr/r2r4r6r8r?rArCrErSrUr;rrrr sF ##& *:*:*:! *:  *:  *:*: *:X ##' ///! /  /  //b// " " 3 37700)."&&).* ;1;1 ;1  ;1  ;1 ;1zrrc eZdZdZddZddZy)SelectPaginationzReturned by :meth:`.SQLAlchemy.paginate`. Takes ``select`` and ``session`` arguments in addition to the :class:`Pagination` arguments. .. versionadded:: 3.0 c|jd}|j|jj|j}|jd}t |j |jjS)Nselectsession) rlimitr offsetr'listexecuteuniquescalars)rrfrgs rrzSelectPagination._query_itemsOsk!!(+dmm,33D4F4FG""9-GOOF+224<<>??rc~|jd}|jtjdj dj }|jd}|j tjtjjj|j}|S)Nrf*rg) roptionssa_ormlazyloadorder_bysubqueryrksarffuncr select_fromscalar)rrfsubrgouts rrzSelectPagination._query_countUs!!(+nnV__S12;;DAJJL""9-oobii 8DDSIJQQS rNr\r[r]r^r_r`rrr;rrrdrdHs @ rrdc eZdZdZddZddZy)QueryPaginationzReturned by :meth:`.Query.paginate`. Takes a ``query`` argument in addition to the :class:`Pagination` arguments. .. versionadded:: 3.0 c|jd}|j|jj|jj }|SNquery)rrhr rir'all)rrrzs rrzQueryPagination._query_itemsdsC  )kk$--(//0B0BCGGI rc^|jdjdj}|Sr)rrsr)rrzs rrzQueryPagination._query_countis+w'006<<> rNr\r[r{r;rrr}r}]s  rr}) __future__rtypingtmathr sqlalchemyrusqlalchemy.ormormrqflaskrrrrdr}r;rrrs?"yyx z*jr