o bp@sdZddlmZddlmZddlmZmZmZddl m Z gdZ Gddde Z Gd d d e Z Gd d d e ZGd dde ZdS)zR Query subclasses which provide extra functionality beyond simple data retrieval. ) FieldError)Q)CURSORGET_ITERATOR_CHUNK_SIZE NO_RESULTS)Query) DeleteQuery UpdateQuery InsertQueryAggregateQueryc@s$eZdZdZdZddZddZdS)rzA DELETE SQL query.ZSQLDeleteCompilercCsX||j|i|_||_||t}|r*| |jWdS1s%wYdS)Nr)Z alias_mapwhere get_compiler execute_sqlrZrowcount)selftabler usingcursorr^/var/www/secure340b-portal/env/lib/python3.10/site-packages/django/db/models/sql/subqueries.pydo_querys zDeleteQuery.do_queryc Csxd}|j}tdt|tD]*}||_|tdi|j d|||ti||j |j |j|d7}q|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. rZ__in)rNr) get_metapkrangelenr where_classr add_qrZattnamerZdb_table)rpk_listrZ num_deletedfieldoffsetrrr delete_batchs   zDeleteQuery.delete_batchN)__name__ __module__ __qualname____doc__compilerrrrrrrrs  rcs`eZdZdZdZfddZddZfddZd d Zd d Z d dZ ddZ ddZ Z S)r zAn UPDATE SQL query.ZSQLUpdateCompilercstj|i||dSN)super__init__ _setup_query)rargskwargs __class__rrr'4s zUpdateQuery.__init__cCsg|_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)rrrrr(8s zUpdateQuery._setup_querycst}|j|_|Sr%)r&cloner/copy)robjr+rrr0As  zUpdateQuery.clonecCsZ||tdt|tD]}||_|t|||td|| t q dS)Nr)pk__in) add_update_valuesrrrrr rrr rr)rrr-rrrrr update_batchFs  zUpdateQuery.update_batchcCsg}|D]A\}}||}|jo|j p|j }|jjj}|r*|jr0|j r0t d|||jur?| |||q| |||fq| |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. zMCannot update model field %r (only non-relations and foreign keys permitted).)itemsr get_fieldZ auto_createdZconcretemodel_metaZconcrete_modelZ is_relationZ many_to_manyradd_related_updateappendadd_update_fields)rr- values_seqnamevalrdirectr8rrrr4Ms   zUpdateQuery.add_update_valuescCs@|D]\}}}t|dr|j|ddd}|j|||fqdS)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)Z allow_joinsZfor_saveN)hasattrrAr-r;)rr=rr8r?rrrr<cs  zUpdateQuery.add_update_fieldscCs|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/ setdefaultr;)rr8rvaluerrrr:oszUpdateQuery.add_related_updatecCsX|jsgSg}|jD]\}}t|}||_|jdur$|d|jf||q |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. Nr3)r/r6r r-r. add_filterr;)rresultr8r-queryrrrget_related_updatesws  zUpdateQuery.get_related_updates)r r!r"r#r$r'r(r0r5r4r<r:rH __classcell__rrr+rr /s   r cs0eZdZdZddfdd ZdddZZS) r ZSQLInsertCompilerF)ignore_conflictscs(tj|i|g|_g|_||_dSr%)r&r'fieldsobjsrJ)rrJr)r*r+rrr's zInsertQuery.__init__cCs||_||_||_dSr%)rKrLraw)rrKrLrMrrr insert_valuess zInsertQuery.insert_values)F)r r!r"r$r'rNrIrrr+rr sr cs$eZdZdZdZfddZZS)r zu Take another query as a parameter to the FROM clause and only select the elements in the provided list. ZSQLAggregateCompilercs||_t|dSr%) inner_queryr&r')rr8rOr+rrr'szAggregateQuery.__init__)r r!r"r#r$r'rIrrr+rr sr N)r#Zdjango.core.exceptionsrZdjango.db.models.query_utilsrZdjango.db.models.sql.constantsrrrZdjango.db.models.sql.queryr__all__rr r r rrrrs    Z