jdZddlmZddlmZmZmZddlmZgdZ GddeZ Gdd eZ Gd d eZ Gd d eZ dS)zR Query subclasses which provide extra functionality beyond simple data retrieval. ) FieldError)GET_ITERATOR_CHUNK_SIZE NO_RESULTS ROW_COUNT)Query) DeleteQuery UpdateQuery InsertQueryAggregateQueryc"eZdZdZdZdZdZdS)rzA DELETE SQL query.SQLDeleteCompilerc||j|i|_||_||tSN) alias_mapwhere get_compiler execute_sqlr)selftablerusings l/var/www/finuniver-perm.ru/html/student/venv/lib/python3.11/site-packages/django/db/models/sql/subqueries.pydo_queryzDeleteQuery.do_querys>!67   ''33I>>>czd}|j}tdt|tD]{}|||jd|||tz|||j |j |z }||S)z Set up and execute delete queries for all the objects in pk_list. More than one physical query may be executed if there are a lot of values in pk_list. r__in)r) get_metapkrangelenr clear_where add_filterattnamerdb_tabler)rpk_listr num_deletedfieldoffsets r delete_batchzDeleteQuery.delete_batchs  "As7||-DEE  F       OO=&&&*A!AAB    4== ($*E) KKrN)__name__ __module__ __qualname____doc__compilerrr(rrrrs="H??? rrcTeZdZdZdZfdZdZfdZdZdZ dZ d Z d Z xZ S) r zAn UPDATE SQL query.SQLUpdateCompilercbtj|i||dSr)super__init__ _setup_query)rargskwargs __class__s rr3zUpdateQuery.__init__5s7$)&))) rc0g|_d|_i|_dS)z Run on initialization and at the end of chaining. Any attributes that would normally be set in __init__() should go here instead. N)values related_idsrelated_updates)rs rr4zUpdateQuery._setup_query9s!  !rct}|j|_|Sr)r2cloner;copy)robjr7s rr=zUpdateQuery.cloneBs0ggmmoo"27799 rcJ||tdt|tD]i}||d|||tz||tjdS)Nrpk__in) add_update_valuesrrrr r!rrr)rr$r9rr's r update_batchzUpdateQuery.update_batchGs v&&&As7||-DEE = =F       OO'&64K+K"KL      e $ $ 0 0 < < < <  = =rc*g}|D]\}}||}|jo|j p|j }|jjj}|jdkr|jj rtd|r|j r|j rtd|z||jur| |||||||f||S)z Convert a dictionary of field name to value mappings into an update query. This is the entry point for the public update() method on querysets. rz:Composite primary key fields must be updated individually.zMCannot update model field %r (only non-relations and foreign keys permitted).)itemsr get_field auto_createdconcretemodel_metaconcrete_modelnameis_composite_pkr is_relation many_to_manyadd_related_updateappendadd_update_fields)rr9 values_seqrLvalr&directrIs rrBzUpdateQuery.add_update_valuesPs>   3 3ID#MMOO--d33E'>,>?Uu~CU K%4EzT!!ek&A! P e/ E4F  /167DMMOO:::''uc:::   ueS1 2 2 2 2%%j111rc|D]S\}}}|jrt|dr||dd}|j|||fTdS)z Append a sequence of (field, model, value) triples to the internal list that will be used to generate the UPDATE query. Might be more usefully called add_update_targets() to hint at the extra information here. resolve_expressionFT) allow_joinsfor_saveN) generatedhasattrrWr9rQ)rrSr&rIrTs rrRzUpdateQuery.add_update_fieldsls ", 4 4 E5# s011 U,,Tut,TT K  uc2 3 3 3 3 4 4rch|j|g|d|fdS)z Add (name, value) to an update query for an ancestor model. Update are coalesced so that only one update query per ancestor is run. N)r; setdefaultrQ)rrIr&values rrPzUpdateQuery.add_related_update{s8 ''r22995$:NOOOOOrc|jsgSg}|jD]X\}}t|}||_|j!|d|j|||Y|S)z Return a list of query objects: one for each update required to an ancestor model. Each query will have the same filtering conditions as the current query but will only update a single table. NrA)r;rEr r9r:r!rQ)rresultrIr9querys rget_related_updateszUpdateQuery.get_related_updatess # I!17799 ! !ME6&&E!EL+  4+;E+BCCC MM%  r)r)r*r+r,r-r3r4r=rCrBrRrPrb __classcell__r7s@rr r 0s"H""" ===2228 4 4 4PPPrr c4eZdZdZddddfd ZddZxZS)r SQLInsertCompilerN) on_conflict update_fields unique_fieldsctj|i|g|_g|_||_|pg|_|pg|_dSr)r2r3fieldsobjsrgrhri)rrgrhrir5r6r7s rr3zInsertQuery.__init__sW $)&)))  &*0b*0brFc0||_||_||_dSr)rkrlraw)rrkrlrns r insert_valueszInsertQuery.insert_valuess  r)F)r)r*r+r-r3rorcrds@rr r sd"H"&T1111111rr c&eZdZdZdZfdZxZS)r zu Take another query as a parameter to the FROM clause and only select the elements in the provided list. SQLAggregateCompilercX||_t|dSr) inner_queryr2r3)rrIrsr7s rr3zAggregateQuery.__init__s)& r)r)r*r+r,r-r3rcrds@rr r sI &H         rr N)r,django.core.exceptionsrdjango.db.models.sql.constantsrrrdjango.db.models.sql.queryr__all__rr r r r.rrrxs0.----- -,,,,, I I I%@bbbbb%bbbJ%&      U      r