D6i~(dZddlmZGddZy)a QueryChain is a wrapper for sequence of queries. Features: * Easy iteration for sequence of queries * Limit, offset and count which are applied to all queries in the chain * Smart __getitem__ support Initialization ^^^^^^^^^^^^^^ QueryChain takes iterable of queries as first argument. Additionally limit and offset parameters can be given :: chain = QueryChain([session.query(User), session.query(Article)]) chain = QueryChain( [session.query(User), session.query(Article)], limit=4 ) Simple iteration ^^^^^^^^^^^^^^^^ :: chain = QueryChain([session.query(User), session.query(Article)]) for obj in chain: print obj Limit and offset ^^^^^^^^^^^^^^^^ Lets say you have 5 blog posts, 5 articles and 5 news items in your database. :: chain = QueryChain( [ session.query(BlogPost), session.query(Article), session.query(NewsItem) ], limit=5 ) list(chain) # all blog posts but not articles and news items chain = chain.offset(4) list(chain) # last blog post, and first four articles Just like with original query object the limit and offset can be chained to return a new QueryChain. :: chain = chain.limit(5).offset(7) Chain slicing ^^^^^^^^^^^^^ :: chain = QueryChain( [ session.query(BlogPost), session.query(Article), session.query(NewsItem) ] ) chain[3:6] # New QueryChain with offset=3 and limit=6 Count ^^^^^ Let's assume that there are five blog posts, five articles and five news items in the database, and you have the following query chain:: chain = QueryChain( [ session.query(BlogPost), session.query(Article), session.query(NewsItem) ] ) You can then get the total number rows returned by the query chain with :meth:`~QueryChain.count`:: >>> chain.count() 15 )copyc<eZdZdZd dZdZdZdZdZdZ d Z y) QueryChaina QueryChain can be used as a wrapper for sequence of queries. :param queries: A sequence of SQLAlchemy Query objects :param limit: Similar to normal query limit this parameter can be used for limiting the number of results for the whole query chain. :param offset: Similar to normal query offset this parameter can be used for offsetting the query chain as a whole. .. versionadded: 0.26.0 Nc.||_||_||_yN)queries_limit_offset)selfrlimitoffsets _/home/azureuser/techstart-app/venv/lib/python3.12/site-packages/sqlalchemy_utils/query_chain.py__init__zQueryChain.__init__}s   c#XKd}d}|jD]}t|}|jr|j|j|z }|jr|j |j|z }d}|D]}|dz }|dz }||s||j z }||z }yw)Nr)rrr r r r count)r consumedskippedquery query_copy obj_countobjs r__iter__zQueryChain.__iter__s\\ %EeJ{{ DKK($:;|| T\\G%;<I A Q    :++--9$! %sB(B*c |d|Srr values rr zQueryChain.limitsFU|rc ||dSrrrs rr zQueryChain.offsetsEF|rc:td|jDS)zY Return the total number of rows this QueryChain's queries would return. c3<K|]}|jywr)r).0qs r z#QueryChain.count..s317793s)sumrr s rrzQueryChain.counts3dll333rc t|trg|j|j|j |jn |j |j |j S|jS||dD]}|cSy)N)rr r r) isinstanceslice __class__rstopr startr )r keyrs r __getitem__zQueryChain.__getitem__s c5 !>> "%(("6chhDKK$'II$9syy" @D||"  C{   rcdt|zS)Nz)idr&s r__repr__zQueryChain.__repr__s%400r)NN) __name__ __module__ __qualname____doc__rrr r rr.r1rrrrrps*  %*4 1rrN)r5rrrrrr6sjX?1?1r