X@sdZddlZddlZddlZddlmZmZddlmZddl m Z ddl m Z m Z mZmZmZddlmZmZmZddlmZdd lmZdd lmZdd lmZdd lmZdd lm Z m!Z!m"Z"ddl#m$Z$ddl%m&Z&m'Z'ddl(m)Z)ddl*m+Z+m,Z,ddl-m.Z.dZ/ej0Z0Gddde1Z2Gddde2Z3Gddde2Z4Gddde2Z5Gddde2Z6Gddde1Z7Gd d!d!e8Z9Gd"d#d#e&j:e9Z;Gd$d%d%e1Z<Gd&d'd'e1Z=dd(d)Z>d*d+Z?d,d-Z@d.d/ZAGd0d1d1e1ZBd2d3ZCdS)4zM The main QuerySet implementation. This provides the public API for the ORM. N) OrderedDictdeque)settings) exceptions)DJANGO_VERSION_PICKLE_KEYIntegrityError connectionsrouter transaction) DateField DateTimeFieldsql) LOOKUP_SEP) Collector)F) AutoField)Trunc) InvalidQueryQcheck_rel_lookup_compatibility)CURSOR)sixtimezone)RemovedInDjango20Warning)cached_property partition) get_versionc@seZdZddZdS) BaseIterablecCs ||_dS)N)queryset)selfrr!D/home/ubuntu/projects/ifolica/build/django/django/db/models/query.py__init__'szBaseIterable.__init__N)__name__ __module__ __qualname__r#r!r!r!r"r&s rc@s"eZdZdZddZdS) ModelIterablez= Iterable that yields a model instance for each row. ccs|j}|j}|jjd|}|j}|j|j|j}}}|dkr`dS|d}|d} | d| dd} } dd|| | D} t|||} x1|j |D] }|j || || | }| rx!| D]}|j ||qWn|rUx1|j D] \}}t ||||q.Wn|jrx|jj D]r\}}t||jrqnnt||j}y||}Wntk rYqnXt ||j|qnWn|VqWdS) Nusingmodel select_fieldsrcSs g|]}|djjqS)r)targetattname).0fr!r!r" >s z*ModelIterable.__iter__..)rdbquery get_compiler execute_sqlselect klass_infoannotation_col_mapget_related_populators results_iterfrom_dbpopulateitemssetattr_known_related_objectshasattrget_cache_namegetattrZ get_attnameKeyErrorname)r rr2compilerresultsr6r7r8 model_clsr*Zmodel_fields_startZmodel_fields_end init_listrelated_populatorsrowobjZ rel_populator attr_nameZcol_posfieldZrel_objspkrel_objr!r!r"__iter__0sB           zModelIterable.__iter__N)r$r%r&__doc__rPr!r!r!r"r'+s r'c@s"eZdZdZddZdS)ValuesIterablezU Iterable returned by QuerySet.values() that yields a dict for each row. c cs|j}|j}|j|j}t|j}t|j}t|j}|||}x(|jD]}t t ||VqlWdS)N) rr3r4r2list values_select extra_selectannotation_selectr:dictzip) r rr3rE field_names extra_namesannotation_namesnamesrJr!r!r"rPas  zValuesIterable.__iter__N)r$r%r&rQrPr!r!r!r"rR[s rRc@s"eZdZdZddZdS)ValuesListIterableze Iterable returned by QuerySet.values_list(flat=False) that yields a tuple for each row. c #s|jj}|jj}|j r]|j r]x|jD]}t|VqEWnt|j }t|j}t|j}|||}j rtj fdd|D}n|}xG|jD]9}t t ||tfdd|DVqWdS)Ncs%g|]}|jkr|qSr!)_fields)r.r/)rr!r"r0s z/ValuesListIterable.__iter__..c3s|]}|VqdS)Nr!)r.r/)datar!r" sz.ValuesListIterable.__iter__..) rr3r4r2rUrVr:tuplerSrTr^rWrX) r r3rErJrYrZr[r\fieldsr!)r_rr"rPws    )zValuesListIterable.__iter__N)r$r%r&rQrPr!r!r!r"r]qs r]c@s"eZdZdZddZdS)FlatValuesListIterablez] Iterable returned by QuerySet.values_list(flat=True) that yields single values. ccsB|j}|jj|j}x|jD]}|dVq+WdS)Nr)rr3r4r2r:)r rrErJr!r!r"rPs zFlatValuesListIterable.__iter__N)r$r%r&rQrPr!r!r!r"rcs rcc@sTeZdZdZddddddZddZde_eeZdd Zd d Z d d Z ddZ ddZ ddZ ddZddZddZddZddZddZd d!Zd"d#Zd$d%Zd&d'Zd(d)Zdd*d+Zdd,d-Zdd.d/Zd0d1Zd2d3Zdd4d5d6Zdd7d8Zdd9d:Z d;d<Z!d=d>Z"dd?d@Z#dAdBZ$de$_%de$_dCdDZ&de&_%dEdFZ'de'_%dGdHZ(de(_%dIe(_dJdKZ)dLdMZ*ddddNdOZ+dPdQZ,dRdSZ-dTdUZ.dVdWdXZ/dVddYdZZ0d[d\Z1d]d^Z2d_d`Z3dadbZ4dcddZ5dedfZ6dIdgdhZ7didjZ8dkdlZ9dmdnZ:dodpZ;dqdrZ<dddddddsdtZ=dudvZ>dwdxZ?dydzZ@d{d|ZAd}d~ZBeCeBZBeCddZDdIdIdddZEdeE_%dIeE_ddZFddZGddZHddZIddZJddZKddZLddZMdZNddZOddZPddZQdeQ_dS)QuerySetzA Represents a lazy database lookup for a set of objects. NcCs||_||_|pi|_|p6tj|j|_d|_d|_d|_g|_ d|_ i|_ t |_ d|_dS)NF)r)_db_hintsr ZQueryr3 _result_cache_sticky_filter _for_write_prefetch_related_lookups_prefetch_doner?r'_iterable_classr^)r r)r3r(hintsr!r!r"r#s         zQuerySet.__init__cCs/ddlm}|j|}d|_|S)Nr)ManagerT)Zdjango.db.models.managerrnZ from_querysetZ_built_with_as_manager)clsrnmanagerr!r!r" as_managers zQuerySet.as_managerTcCse|j}xR|jjD]A\}}|dkrDd|j|r1)rSREPR_OUTPUT_SIZElen)r r_r!r!r"__repr__s zQuerySet.__repr__cCs|jt|jS)N)rzrrg)r r!r!r"__len__s zQuerySet.__len__cCs|jt|jS)a The queryset iterator protocol uses three nested iterators in the default case: 1. sql.compiler:execute_sql() - Returns 100 rows at time (constants.GET_ITERATOR_CHUNK_SIZE) using cursor.fetchmany(). This part is responsible for doing some column masking, and returning the rows in chunks. 2. sql/compiler.results_iter() - Returns one row at time. At this point the rows are still just tuples. In some cases the return values are converted to Python values at this location. 3. self.iterator() - Responsible for turning the rows into model objects. )rziterrg)r r!r!r"rPs zQuerySet.__iter__cCs|jt|jS)N)rzboolrg)r r!r!r"__bool__s zQuerySet.__bool__cCst|j|S)N)typer)r r!r!r" __nonzero__szQuerySet.__nonzero__cCst|tftjs"tnt|t r>|dkst|tr|jdksk|jdkr|jdks|jdkstd|jdk r|j|St|trR|j }|jdk rt |j}nd}|jdk rt |j}nd}|j j |||j rNt|dd|j S|S|j }|j j ||dt|dS)zE Retrieves an item or slice from the set of results. rNz#Negative indexing is not supported.r+) isinstanceslicer integer_types TypeErrorstartstopAssertionErrorrg_cloneintr3 set_limitssteprS)r rwqsrrr!r!r" __getitem__ s* -!   ' zQuerySet.__getitem__cCsi|j|t|tr |St|tr3|S|j}|j||jj|jtj|S)N) _merge_sanity_checkr EmptyQuerySetr_merge_known_related_objectsr3combiner ZAND)r othercombinedr!r!r"__and__)s   zQuerySet.__and__cCsi|j|t|tr |St|tr3|S|j}|j||jj|jtj|S)N) rrrrrr3rr ZOR)r rrr!r!r"__or__4s   zQuerySet.__or__cCst|j|S)zc An iterator over the results from applying this QuerySet to the database. )rrl)r r!r!r"iteratorCszQuerySet.iteratorc Os|jjrtdnxM|D]E}y |jWn$ttfk rYtdYnX|||jsz&QuerySet.bulk_create..cSs%g|]}t|ts|qSr!)rr)r.r/r!r!r"r0s z(QuerySet.bulk_create..)rr)rZget_parent_listZconcrete_model ValueErrorrirr2concrete_fieldsrSrr atomicfeaturesZ6can_combine_inserts_with_and_without_auto_increment_pkZhas_auto_field_batched_insertrcan_return_ids_from_bulk_insertrrXrN_stateZadding) r r batch_sizeparent connectionrbZ objs_with_pkZobjs_without_pkidsZobj_without_pkrNr!r!r" bulk_creates8      !  zQuerySet.bulk_createc Ksg|j||\}}d|_y|j|dfSWn(|jjk rb|j||SYnXdS)z Looks up an object with the given kwargs, creating one if necessary. Returns a tuple of (object, created), where created is a boolean specifying whether an object was created. TFN)_extract_model_paramsrir~r)r_create_object_from_params)r defaultsrlookupparamsr!r!r" get_or_creates  zQuerySet.get_or_createc Ks|p i}|j||\}}d|_y|j|}Wn@|jjk r|j||\}}|r~||fSYnXx-tj|D]\}}t|||qW|j d|j |dfS)a Looks up an object with the given kwargs, updating one with defaults if it exists, otherwise creates a new one. Returns a tuple (object, created), where created is a boolean specifying whether an object was created. Tr(F) rrir~r)rrr iteritemsr>rr2) r rrrrrKcreatedrwrxr!r!r"update_or_creates  zQuerySet.update_or_createcCsy9tjd|j|j|}WdQX|dfSWn]tk rtj}y|j|dfSWn|jj k rYnXt j |YnXdS)zs Tries to create an object using passed params. Used by get_or_create and update_or_create r(NTF) r rr2rrsysexc_infor~r)rrreraise)r rrrKrr!r!r"rs  z#QuerySet._create_object_from_paramscKs|p i}|j}xB|jjjD]1}|j|kr(|j|j||js z2QuerySet._extract_model_params..) rtr)rrbr-poprDr=r)r rrrr/rr!r!r"rs    zQuerySet._extract_model_params-cCs|pt|jjd}t|s3td|jjsNtd|j}|jjdd|jj dd|jj d||f|j S) z Returns the latest object, according to the model's 'get_latest_by' option or optional given field_name. Z get_latest_byz]earliest() and latest() require either a field_name parameter or 'get_latest_by' in the modelz2Cannot change a query once a slice has been taken.highr+ force_emptyTz%s%s) rBr)rrrr3rrrclear_ordering add_orderingr~)r field_name directionrrKr!r!r"_earliest_or_latests  zQuerySet._earliest_or_latestcCs|jd|ddS)Nrr)r)r rr!r!r"earliest"szQuerySet.earliestcCs|jd|ddS)Nrrr)r)r rr!r!r"latest%szQuerySet.latestcCs@t|jr|n |jddd}|r<|dSdS)zY Returns the first object of a query, returns None if no match is found. rNNr+r)rSorderedr)r objectsr!r!r"first(s.zQuerySet.firstcCsFt|jr|jn |jddd}|rB|dSdS)zX Returns the last object of a query, returns None if no match is found. z-pkNr+r)rSrreverser)r rr!r!r"last1s4z QuerySet.lastcCsi|jjstd|dk rL|s1iS|jd|j}n |j}dd|DS)z Returns a dictionary mapping each of the given IDs to the object with that ID. If `id_list` isn't provided, the entire QuerySet is evaluated. z+Cannot use 'limit' or 'offset' with in_bulkNZpk__incSsi|]}||jqSr!)Z _get_pk_val)r.rKr!r!r"rGs z$QuerySet.in_bulk..)r3rrrrr)r Zid_listrr!r!r"in_bulk:s   zQuerySet.in_bulkcCs|jjstd|jdk r9tdn|j}d|_d|j_d|j_|jj ddt d|j }|j ||j \}}d|_||fS)z> Deletes the records in the current QuerySet. z+Cannot use 'limit' or 'offset' with delete.Nz6Cannot call delete() after .values() or .values_list()TFrr()r3rrr^rrriselect_for_updateselect_relatedrrr2Zcollectdeleterg)r Z del_queryZ collectorZdeletedZ _rows_countr!r!r"rIs       zQuerySet.deletecCstj|jj||S)z Deletes objects found from the given queryset in single direct SQL query. No signals are sent, and there is no protection for cascades. )r Z DeleteQueryr)Z delete_qs)r r(r!r!r" _raw_deletejszQuerySet._raw_deletec Ks|jjstdd|_|jjtj}|j|tj d|j dd |j |j j t }WdQXd|_|S)z Updates all elements in the current QuerySet, setting all the given fields to the appropriate values. z2Cannot update a query once a slice has been taken.Tr(rFN)r3rrrirr UpdateQueryZadd_update_valuesr rr2r4r5rrg)r rr3rowsr!r!r"rrs   ! zQuerySet.updatecCs_|jjstd|jjtj}|j|d|_|j|j j t S)a  A version of update that accepts field objects instead of field names. Used primarily for model saving and not intended for use by general code (it requires too much poking around at model internals to be useful at that level). z2Cannot update a query once a slice has been taken.N) r3rrrr rZadd_update_fieldsrgr4r2r5r)r valuesr3r!r!r"_updates    zQuerySet._updateFcCs2|jdkr%|jjd|jSt|jS)Nr()rgr3Z has_resultsr2r)r r!r!r"existsszQuerySet.existscCs t|j|jd|_dS)NT)prefetch_related_objectsrgrjrk)r r!r!r"_prefetch_related_objectssz"QuerySet._prefetch_related_objectsc Cs=|dkr|j}nt|d|jd|d|d|S)Nr)r translationsr()r2 RawQuerySetr))r raw_queryrrr(r!r!r"raws  z QuerySet.rawcGs}|j}||_|j}d|_|j|j|jdkr|jdd|jj j Dd|j |jn|rDg}g}g}|j r|j rt|}ned|_xY|D]Q}||jkr|j|q||jkr|j|q|j|qW|j||j|ndd|jj j D}||_|j|d|S)NFTcss|]}|jVqdS)N)r-)r.r/r!r!r"r`sz#QuerySet._values..cSsg|]}|jqSr!)r-)r.r/r!r!r"r0s z$QuerySet._values..)rr^r3rclear_deferred_loadingZclear_select_fieldsgroup_byZ add_fieldsr)rr set_group_byZ_extraZ _annotationsrSZ default_colsrUappendrVZset_extra_maskZset_annotation_maskrT)r rbrr3rYrZr[r/r!r!r"_valuess:      &      zQuerySet._valuescGs|j|}t|_|S)N)rrRrl)r rbrr!r!r"rs zQuerySet.valuescOs|jdd}|r4tdt|fn|r[t|dkr[tdn|j|}|rvtnt|_|S)NflatFz/Unexpected keyword arguments to values_list: %sr+zH'flat' is not valid when values_list is called with more than one field.)rrrSrrrcr]rl)r rbrrrr!r!r" values_listszQuerySet.values_listASCcCs|dkstd|dks0td|jdt||d td t|jdd d jjd dj|dkrdnddS)z Returns a list of date objects representing all available dates for the given field_name, scoped to 'kind'. yearmonthdayz/'kind' must be one of 'year', 'month' or 'day'.rDESCz''order' must be either 'ASC' or 'DESC'.Z datefield output_field plain_fieldrTplain_field__isnullFrr)zyearzmonthzday)rr) rannotaterr rrdistinctrr)r rkindorderr!r!r"datess   zQuerySet.datesc Cs|dkstd|dks0td tjrW|d kr]tj}q]nd }|jd t||d td|dt|j d ddj j ddj |d krdndd S)z Returns a list of datetime objects representing all available datetimes for the given field_name, scoped to 'kind'. rrrhourminutesecondzK'kind' must be one of 'year', 'month', 'day', 'hour', 'minute' or 'second'.rrz''order' must be either 'ASC' or 'DESC'.NZ datetimefieldr tzinfor rTr Frr)zyearzmonthzdayzhourzminutezsecond)zASCzDESC) rrZUSE_TZrZget_current_timezoner rr rrr rr)r rrrrr!r!r" datetimess     zQuerySet.datetimescCs|j}|jj|S)z, Returns an empty QuerySet. )rr3Z set_empty)r rr!r!r"nones  z QuerySet.nonecCs |jS)z Returns a new QuerySet that is a copy of the current one. This allows a QuerySet to proxy for a model manager in some cases. )r)r r!r!r"allsz QuerySet.allcOs|jd||S)zb Returns a new QuerySet instance with the args ANDed to the existing set. F)_filter_or_exclude)r rrr!r!r"rszQuerySet.filtercOs|jd||S)zd Returns a new QuerySet instance with NOT (args) ANDed to the existing set. T)r)r rrr!r!r"excludeszQuerySet.excludecOsv|s |r*|jjs*tdn|j}|rY|jjt||n|jjt|||S)Nz2Cannot filter a query once a slice has been taken.)r3rrradd_qr)r negaterrrr!r!r"r%s   zQuerySet._filter_or_excludecCsRt|tst|dr>|j}|jj||S|jd|SdS)ao Returns a new QuerySet instance with filter_obj added to the filters. filter_obj can be a Q object (or anything with an add_to_query() method) or a dictionary of keyword lookup arguments. This exists to support framework features such as 'limit_choices_to', and usually it will be more natural to use other methods. Z add_to_queryN)rrr@rr3rr)r Z filter_objrr!r!r"complex_filter1s  zQuerySet.complex_filtercCs1|j}d|_d|j_||j_|S)zj Returns a new QuerySet instance that will select objects with a FOR UPDATE lock. T)rrir3rZselect_for_update_nowait)r ZnowaitrKr!r!r"rBs     zQuerySet.select_for_updatecGsn|jdk rtdn|j}|dkrEd|j_n%|r^|jj|n d|j_|S)a Returns a new QuerySet instance that will select related objects. If fields are specified, they must be ForeignKey fields and only those related objects are included in the selection. If select_related(None) is called, the list is cleared. Nz>Cannot call select_related() after .values() or .values_list()FT)N)r^rrr3rZadd_select_related)r rbrKr!r!r"rMs    zQuerySet.select_relatedcGs8|j}|dkr$g|_n|jj||S)ad Returns a new QuerySet instance that will prefetch the specified Many-To-One and Many-To-Many related objects when the QuerySet is evaluated. When prefetch_related() is called more than once, the list of lookups to prefetch is appended to. If prefetch_related(None) is called, the list is cleared. N)N)rrjextend)r lookupsrr!r!r"prefetch_relatedcs   zQuerySet.prefetch_relatedc Ost}xk|D]c}y)|j|kr>td|jnWn$ttfk retdYnX|||js z$QuerySet.annotate..z8The annotation '%s' conflicts with a field on the model.rFT)rrrrrrrr^r)rZ get_fieldsr=r3rrrrr) r rrrrrr\rZ annotationr!r!r"r ts4      "   zQuerySet.annotatecGsN|jjstd|j}|jjdd|jj||S)zL Returns a new QuerySet instance with the ordering changed. z3Cannot reorder a query once a slice has been taken.rF)r3rrrrr)r rYrKr!r!r"rs   zQuerySet.order_bycGs;|jjstd|j}|jj||S)zY Returns a new QuerySet instance that will select only distinct results. z:Cannot create distinct fields once a slice has been taken.)r3rrrZadd_distinct_fields)r rYrKr!r!r"r s   zQuerySet.distinctcCsJ|jjstd|j}|jj|||||||S)z8 Adds extra SQL fragments to the query. z1Cannot change a query once a slice has been taken)r3rrrZ add_extra)r r6whererZtablesrZ select_paramsrr!r!r"extras   zQuerySet.extracCs#|j}|jj |j_|S)z8 Reverses the ordering of the QuerySet. )rr3Zstandard_ordering)r rr!r!r"rs zQuerySet.reversecGsZ|jdk rtdn|j}|dkrF|jjn|jj||S)aU Defers the loading of data for certain fields until they are accessed. The set of fields to defer is added to any existing set of deferred fields. The only exception to this is if None is passed in as the only parameter, in which case all deferrals are removed (None acts as a reset option). Nz5Cannot call defer() after .values() or .values_list())N)r^rrr3rZadd_deferred_loading)r rbrr!r!r"defers  zQuerySet.defercGsY|jdk rtdn|dkr9tdn|j}|jj||S)z Essentially, the opposite of defer. Only the fields passed into this method and that are not already specified as deferred are loaded immediately when the queryset is evaluated. Nz4Cannot call only() after .values() or .values_list()z*Cannot pass None as an argument to only().)N)r^rrr3Zadd_immediate_loading)r rbrr!r!r"onlys  z QuerySet.onlycCs|j}||_|S)zX Selects which database this QuerySet should execute its query against. )rre)r rrr!r!r"r(s  zQuerySet.usingcCsF|jjs|jjrdS|jjr>|jjjr>dSdSdS)z Returns True if the QuerySet is ordered -- i.e. has an order_by() clause or a default ordering on the model. TFN)r3Zextra_order_byrZdefault_orderingZget_metaZordering)r r!r!r"rs zQuerySet.orderedcCsG|jr(|jp'tj|j|jS|jpFtj|j|jS)zCReturn the database that will be used if this query is executed now)rirer Z db_for_writer)rf db_for_read)r r!r!r"r2s z QuerySet.dbcCsbd|_|dkr!|j}ntj|j}|j||d||jd|j|S)z Inserts a new record for the given model. This provides an interface to the InsertQuery class and is how Model.save() is implemented. TNrr()rir2r Z InsertQueryr)Z insert_valuesr4r5)r rrb return_idrr(r3r!r!r"_insert s    zQuerySet._insertc ss dSt|jj}p8t|j|dg}xfddtdtDD]}t|jjjr|j |d|d|jdd }tdkr|j |ntdkr|j |qqp|j |d|d|jqpW|S) z A little helper method for bulk_insert to insert the bulk one batch at a time. Inserts recursively a batch from the front of the bulk and then _batched_insert() the remaining objects again. Nr+cs$g|]}||qSr!r!)r.i)rrr!r"r0$s z,QuerySet._batched_insert..rrbr(r&T) rr2opsmaxZbulk_batch_sizerangerrrr'rr)r rrbrr)Z inserted_idsitemZ inserted_idr!)rrr"rs!5$ zQuerySet._batched_insertc Ks|jj}|jr$d|_n|jd|jd|d|jd|j}|j|_|j dd|_ |j |_ |j |_ |j |_ |j j||S)NTr)r3r(rm)r3rrhZfilter_is_stickyrrr)rerfrirjr?rlr^rsr)r rr3rr!r!r"r/s  -    zQuerySet._clonecCsK|jdkr't|j|_n|jrG|j rG|jndS)N)rgrSrrjrkr)r r!r!r"rz=szQuerySet._fetch_allcCs d|_|S)a Indicates that the next filter call and the one following that should be treated as a single filter. This is only important when it comes to determining when to reuse tables for many-to-many filters. Required so that we can filter naturally on the results of related managers. This doesn't return a clone of the current QuerySet (it returns "self"). The method is only used internally and should be immediately followed by a filter() that does create a clone. T)rh)r r!r!r"_next_is_stickyCs zQuerySet._next_is_stickycCs|jdk rt|jjt|jjks{t|jjt|jjks{t|jjt|jjkrtd|jjndS)zM Checks that we are merging two comparable QuerySet classes. Nz?Merging '%s' classes must involve the same values in each case.) r^setr3rTrUrVrrrr$)r rr!r!r"rQs$$$zQuerySet._merge_sanity_checkcCs@x9|jjD](\}}|jj|ij|qWdS)zX Keep track of all known related objects from either QuerySet instance. N)r?r= setdefaultr)r rrMrr!r!r"r^sz%QuerySet._merge_known_related_objectscCs|jdk rEt|jp'|jjjdkrtdqn[|j|jkrt|df}t|dkr|dj r|j|dj Sn|S)Nr+z0Cannot use multi-field values as a filter value.Zforeign_related_fieldsr) r^rr)rrrrBZ primary_keyrrD)r rMZforeign_fieldsr!r!r"_preparees$ zQuerySet._preparecCs|jdk rQt|jp'|jjjdkrBtdn|j}n|jd}|jdks|t |jkr|j j d|j St ddS)zO Returns the internal query's SQL and parameters (as a tuple). Nr+z0Cannot use multi-field values as a filter value.rNrz2Can't do subqueries with queries on different DBs.)r^rr)rrrrrrerr3r4Z as_nested_sqlr)r rrr!r!r"_as_sqlss$"zQuerySet._as_sqlcKs|jj|dS)zE Update hinting information for later use by Routers N)rfr)r rmr!r!r" _add_hintsszQuerySet._add_hintscCs |jjS)z Checks if this QuerySet has any filtering going on. Note that this isn't equivalent for checking if all objects are present in results, for example qs[1:]._has_filters() -> False. )r3Z has_filters)r r!r!r" _has_filtersszQuerySet._has_filterscCs&|jdk rdSt|j||S)a Check that using this queryset as the rhs value for a lookup is allowed. The opts are the options of the relation's target we are querying against. For example in .filter(author__in=Author.objects.all()) the opts would be Author's (from the author field) and self.model would be Author.objects.all() queryset's .model (Author also). The field is the related field on the lhs side. NT)r^rr))r optsrMr!r!r"is_compatible_query_object_types z(QuerySet.is_compatible_query_object_type)Rr$r%r&rQr#rqZ queryset_only classmethodryr{rrrrPrrrrrrrrr~rrrrrrrrrrrrrrZ alters_datarrrrrrrrrrrrrrrrrrrrr rr r"rr#r$r(rpropertyr2r'rrrzr-rrr0r1Zvalue_annotationr2r3r5r!r!r!r"rds                7               )         *                  rdc@seZdZddZdS)InstanceCheckMetacCst|to|jjS)N)rrdr3Zis_empty)r instancer!r!r"__instancecheck__sz#InstanceCheckMeta.__instancecheck__N)r$r%r&r:r!r!r!r"r8s r8c@s"eZdZdZddZdS)rz Marker class usable for checking if a queryset is empty by .none(): isinstance(qs.none(), EmptyQuerySet) -> True cOstddS)Nz#EmptyQuerySet can't be instantiated)r)r rrr!r!r"r#szEmptyQuerySet.__init__N)r$r%r&rQr#r!r!r!r"rs rc@seZdZdZddddddddZddZddZd d Zd d Ze d dZ ddZ e ddZ e ddZ dS)rzp Provides an iterator which converts the results of raw SQL queries into annotated model instances. NcCsv||_||_||_|p$i|_|pNtjd|d|jd||_|p]f|_|pli|_ dS)Nr r(r) rr)rerfr ZRawQueryr2r3rr)r rr)r3rrr(rmr!r!r"r#s   *zRawQuerySet.__init__cs}fddjjjD}fddtjD}fdd|D}dd|D}|||fS)zB Resolve the init field names and value positions cs(g|]}|jjkr|qSr!)columncolumns)r.r/)r r!r"r0s z8RawQuerySet.resolve_model_init_order..cs1g|]'\}}|jkr||fqSr!) model_fields)r.posr;)r r!r"r0s cs%g|]}jj|jqSr!)r<indexr;)r.r/)r r!r"r0s cSsg|]}|jqSr!)r-)r.r/r!r!r"r0s )r)rrb enumerater<)r Zmodel_init_fieldsannotation_fieldsZmodel_init_ordermodel_init_namesr!)r r"resolve_model_init_orders ""z$RawQuerySet.resolve_model_init_orderc #sj}t|jjdjt||}tj}zbj\}}}t}x9jj j D](}|j |krr|j |j qrqrW|rjj j j |krtdqnj} fddjD} |jdd| D} x|D]| r7|j| nfdd|D} | j||| } |rx+|D] \}}t| ||qrWn| VqWWdtjdrjjrjjjnXdS)NZ SQLCompilerz&Raw query must include the primary keycs"g|]}jj|qSr!)r=r~)r.c)r r!r"r0s z(RawQuerySet.__iter__..cSs4g|]*}|r*|j|jjjndqS)N)Zget_colr)rZdb_table)r.r/r!r!r"r0s csg|]}|qSr!r!)r.r>)rr!r"r0s cursor)r2rr)rEr3rrCr.r)rrbr-addrNrr<Zget_convertersZapply_convertersr;r>r@rEclose)r r2rEr3rBZmodel_init_posrAskiprMrGrbZ convertersZmodel_init_valuesr9r;r>r!)r rr"rPs8     zRawQuerySet.__iter__cCs d|jS)Nz)r3)r r!r!r"rszRawQuerySet.__repr__cCst||S)N)rS)r rwr!r!r"rszRawQuerySet.__getitem__cCs|jptj|j|jS)zCReturn the database that will be used if this query is executed now)rer r%r)rf)r r!r!r"r2szRawQuerySet.dbc CsCt|jd|jd|jjd|d|jd|jd|S)z\ Selects which database this Raw QuerySet should execute its query against. r)r3r(rr)rrr)r3rrr)r rr!r!r"r(s zRawQuerySet.usingc Cst|ds||jj|_xX|jjD]D\}}y#|jj|}||j|.rjrz2to_attr={} conflicts with a field on the {} model.r+NzThe `%s.%s` class must implement a `_apply_rel_filters()` method that accepts a `QuerySet` as its single argument and returns an appropriately filtered version of it.T)!rjrZrBrjrSr/rrYrrr get_fieldrZFieldDoesNotExistrformatr$rrMrPrr~r>rZ_apply_rel_filtersrrrr%rZ get_querysetrgrkr`)Z instancesrfrrTZrel_qsZ rel_obj_attrZ instance_attrZsingle cache_nameriZall_related_objectsZ rel_obj_cacherOZ rel_attr_valrQrXr)rZleafrKZinstance_attr_valvalsvalrpZapply_rel_filterrr!r!r"rcsZ*       "       rcc@s.eZdZdZddZddZdS)RelatedPopulatora RelatedPopulator is used for select_related() object instantiation. The idea is that each select_related() model will be populated by a different RelatedPopulator instance. The RelatedPopulator instances get klass_info and select (computed in SQLCompiler) plus the used db as input for initialization. That data is used to compute which columns to use, how to instantiate the model, and how to populate the links between the objects. The actual creation of the objects is done in populate() method. This method gets row and from_obj as input and populates the select_related() model instance. c s||_|d}|d}|ss|d|_|dd|_dd||j|jD|_d|_ndd|djjD}g}xJ|D]B}||dj} |j| j } |j | | j |fqW|j d d|D|_d d|Dfd d } | |_|d|_ |jj|j jj j |_t|||j|_|d } |d} d|_| r| jj|_| j|_n-| j|_| jr| jj|_ndS)Nr* from_parentrr+cSs g|]}|djjqS)r)r,r-)r.r/r!r!r"r0s z-RelatedPopulator.__init__..cSsg|]}|jqSr!)r-)r.r/r!r!r"r0s r)cSsg|]}|dqS)r+r!)r.rxr!r!r"r0s cSsg|]\}}}|qSr!r!)r._row_posr!r!r"r0s csfddDS)Ncsg|]}|qSr!r!)r.rs)rJr!r"r0s zGRelatedPopulator.__init__..reorder_for_init..r!)rJ)pos_list)rJr"reorder_for_initsz3RelatedPopulator.__init__..reorder_for_initrMrr1)r2 cols_startcols_endrHrurrr,r?r-rsortrGrNpk_idxr9rIreverse_cache_nameZ remote_fieldrArmunique) r r7r6r2r*rqZmodel_init_attnamesZ reorder_mapidxrMZinit_posrurr!)rtr"r#s>    &     !    zRelatedPopulator.__init__cCs|jr|j|}n||j|j}||jdkrMd}n|jj|j|j|}|r|jrx$|jD]}|j ||qWnt ||j ||r|j rt ||j |ndS)N) rurvrwryrGr;r2rHrIr<r>rmrz)r rJZfrom_objZobj_datarKZrel_iterr!r!r"r<s  zRelatedPopulator.populateN)r$r%r&rQr#r<r!r!r!r"rp{s  ArpcCsLg}|jdg}x-|D]%}t|||}|j|qW|S)Nrelated_klass_infos)r~rpr)r7r6r2 iteratorsr}Zrel_klass_infoZrel_clsr!r!r"r9s  r9)DrQrtrr collectionsrrZ django.confrZ django.corerZ django.dbrrrr r Zdjango.db.modelsr r r Zdjango.db.models.constantsrZdjango.db.models.deletionrZdjango.db.models.expressionsrZdjango.db.models.fieldsrZdjango.db.models.functionsrZdjango.db.models.query_utilsrrrZdjango.db.models.sql.constantsrZ django.utilsrrZdjango.utils.deprecationrZdjango.utils.functionalrrZdjango.utils.versionrrZEmptyResultSetobjectrr'rRr]rcrdrr8with_metaclassrrrLr_rrbrcrpr9r!r!r!r"sR   ( 0!   z, { / fa