]VMc@sdZddklZddklZlZlZlZddkl Z ddk l Z ddk l Z lZlZlZddklZddklZlZdd klZd ZeZd ZeiZd efd YZdefdYZdefdYZdefdYZ defdYZ!dde"de"e#dZ$defdYZ%e#e#e"dZ&dS(sM The main QuerySet implementation. This provides the public API for the ORM. i(tizip(t connectionstroutert transactiontIntegrityError(t Aggregate(t DateField(tQtselect_related_descendtdeferred_class_factoryt InvalidQuery(t Collector(tsignalstsql(tdeepcopyiditQuerySetcBsBeZdZd6d6d6dZdZdZdZdZdZ dZ dZ d Z d Z d Zd Zd ZdZdZdZdZdZd6dZdZdZee_dZee_dZee_dZdZdZddZ dZ!dZ"dZ#d Z$d!Z%d"Z&d#Z'd$Z(d%Z)d&Z*ed'Z+d6d6d6d6d6d6d(Z,d)Z-d*Z.d+Z/d,Z0d-Z1e2e1Z1e2d.Z3d6e4d/Z5d6d0Z6d1Z7d2Z8d3Z9d4Z:d5Z;eZ<RS(7sA Represents a lazy database lookup for a set of objects. cCsV||_||_|pti|i|_d|_d|_t|_ t|_ dS(N( tmodelt_dbR tQuerytquerytNonet _result_cachet_itertFalset_sticky_filtert _for_write(tselfRRtusing((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyt__init__s     cCsd|i}xQ|iiD]@\}}|djod|i| Deletes the records in the current QuerySet. s+Cannot use 'limit' or 'offset' with delete.RN(RRRGRHR:RRR_RR RptcollecttdeleteRR(Rt del_queryt collector((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs      cKs|iip tdt|_|iiti}|i|t i d|i pt i d|i t}nt }zP|i|i id}|ot id|i nt id|i Wd|ot id|i nXd|_|S(s Updates all elements in the current QuerySet, setting all the given fields to the appropriate values. s2Cannot update a query once a slice has been taken.RN(RRRGR:RRR t UpdateQuerytadd_update_valuesRt is_managedRptenter_transaction_managementRRqt execute_sqlRtcommittcommit_unless_managedtleave_transaction_managementR(RRRtforced_managedtrows((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs$    cCs^|iip td|iiti}|i|d|_|i |i i dS(s  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). s2Cannot update a query once a slice has been taken.N( RRRGRR Rtadd_update_fieldsRRRqRpR(RtvaluesR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyt_updates   cCs4|idjo|iid|iSt|iS(NR(RRRt has_resultsRpR8(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytexistsscGs|idtdtd|S(Ntklasstsetupt_fields(RHtValuesQuerySetR:(RRf((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRsc Os|idt}|otd|ifn|o#t|djotdn|idtdtd|d|S(Ntflats/Unexpected keyword arguments to values_list: %sisH'flat' is not valid when values_list is called with more than one field.RRR(RRRDRbR%RHtValuesListQuerySetR:(RRfRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyt values_liststASCc CsV|d jp td|djp td|idtd td |d |d |S(s Returns a list of datetime objects representing all available dates for the given field_name, scoped to 'kind'. tmonthtyeartdays/'kind' must be one of 'year', 'month' or 'day'.RtDESCs''order' must be either 'ASC' or 'DESC'.RRt _field_namet_kindt_order(RRR(RR(RGRHt DateQuerySetR:(RRtkindtorder((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytdatess cCs|idtS(s, Returns an empty QuerySet. R(RHRS(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytnonescCs |iS(s 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. (RH(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytallscOs|it||S(sb Returns a new QuerySet instance with the args ANDed to the existing set. (t_filter_or_excludeR(RRMR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR!scOs|it||S(sd Returns a new QuerySet instance with NOT (args) ANDed to the existing set. (RR:(RRMR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytexclude(scOsz|p|o|iip tdn|i}|o|iit||n|iit|||S(Ns2Cannot filter a query once a slice has been taken.(RRRGRHtadd_qR(RtnegateRMRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR/s  cCsUt|tpt|do!|i}|ii||S|id|SdS(so 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. t add_to_queryN(R@RthasattrRHRRRR(Rt filter_objR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytcomplex_filter;s  cOs|idd}|otd|ifn|i}|o+|otdn|ii|n t|i_|o||i_n|S(s 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. tdepthis2Unexpected keyword arguments to select_related: %ss7Cannot pass both "depth" and fields to select_related()( RRDRbRHRtadd_select_relatedR:R_R[(RRfRRR!((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR_Ls  cCs|ii|i_dS(sp Copies the related selection status from the QuerySet 'other' to the current QuerySet. N(RR_(RRV((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytdup_select_relatedbsc OsxB|D]:}|i|jotd|in|||i|i}|djo|iin|ii||S(sU 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). N(N(RHRRtclear_deferred_loadingtadd_deferred_loading(RRfR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytdefers   cGs=|djotdn|i}|ii||S(s 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. s*Cannot pass None as an argument to only().N(N(RRDRHRtadd_immediate_loading(RRfR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytonlys   cCs|i}||_|S(sZ Selects which database this QuerySet should excecute it's query against. (RHR(RRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs  cCsL|iip |iiotS|iio|iiiiotStSdS(s Returns True if the QuerySet is ordered -- i.e. has an order_by() clause or a default ordering on the model. N( Rtextra_order_byRR:tdefault_orderingRRetorderingR(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pytordereds  cCs?|io|ipti|iS|ipti|iS(sCReturn the database that will be used if this query is executed now(RRRt db_for_writeRt db_for_read(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRps cKs|djo |i}n|ii}|io t|_n|d|id|d|i}|i |_ |i i ||ot |do|i n|S(NRRRt _setup_query(RRRRRR:tfilter_is_stickyRRRRRRR(RRRRRtc((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRHs    ! cCsl|io^y;x4t|ptD]}|ii|iiq!WWqhtj od|_qhXndS(sv Fills the result cache with 'num' more entries (or until the results iterator is exhausted). N(RtrangetITER_CHUNK_SIZERRkR9R4R(RR<R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR5s !cCs t|_|S(s 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. (R:R(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyt_next_is_stickys cCsdS(s Checks that we are merging two comparable QuerySet classes. By default this does nothing, but see the ValuesQuerySet for an example of where it's useful. N((RRV((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRRscCsn|ii}|iidjoKg}|iD]}||iq-~}|ii|t|ii ndS(s_ Prepare the query for computing a result that contains aggregate annotations. N( RReRtgroup_byRRfRot add_fieldsRt set_group_by(Rt aggregatestoptsRRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs  'cCs|S(N((R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyt_prepare(scCs]|id}|idjp|t|ijo|iid|iStddS(sO Returns the internal query's SQL and parameters (as a tuple). Rit connections2Can't do subqueries with queries on different DBs.N(RRRRRRqt as_nested_sqlR(RRR!((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyt_as_sql+s$N(=t__name__t __module__t__doc__RRR$R(R-R0R3R1R;R?RQRXRZR.RRRRRRRRR:t alters_dataRRRRRRRRRRRRR_RRRRRRRRRRtpropertyRpRRHR5R RRRRRtvalue_annotation(((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRsv   .  Z                            RcBsVeZdZdZdZdedZdZdZ dZ dZ RS( cOs)tt|i||t|i_dS(N(tsuperRRRRR_(RRMR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR9sccsy|iii}|i}|iii}|||}x7|ii|iiD]}tt ||VqWWdS(N( RRaRbRRcRqRpRrR`Rt(Rt extra_namesRtaggregate_namesRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR.As cCs|ii|ii|iog|_g|_|ii o$|ii ot|i|_ q5t |i_ g|_ x|iD]d}||iijo|ii |q||ii jo|ii |q|i i |qWnCd|_g}|iiiD]}||iq~|_ d|_g|i_|idj o|ii|in|ii|i t|idj o|ii|indS(s Constructs the field_names list that the values query will be retrieving. Called by the _clone() method after initializing the rest of the instance. N(RRtclear_select_fieldsRRRRRR)RRt default_colsRkRcRRReRfRoRtset_extra_maskRR:tset_aggregate_mask(RRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRLs2         0  cKstt|i||}t|dp|i|_n|i|_|i|_|i|_|ot|do|in|S(sH Cloning a ValuesQuerySet preserves the current fields. RR( RRRHRRRRRR(RRRRR ((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRHxs   cCstt|i|t|it|ijp2t|it|ijp|i|ijotd|ii ndS(Ns?Merging '%s' classes must involve the same values in each case.( RRRRRmRRRRDRR(RRV((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRRs cCs^|ii|idj o'|ii||ii|intt|i|dS(s_ Prepare the query for computing a result that contains aggregate annotations. N( RRRRR/R#RRR(RR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs  cCs|iot|idjp'|i o6t|iiidjotd|iin|i}|i djp|t |i jo|i i d|iStddS(s^ For ValueQuerySet (and subclasses like ValuesListQuerySet), they can only be used as nested queries if they're already set up to select only a single field (in which case, that is the field column that is returned). This differs from QuerySet.as_sql(), where the column to select is set up by Django. is.Cannot use a multi-field %s as a filter value.Rs2Can't do subqueries with queries on different DBs.N(RR%RReRfRDRRRHRRRRRqRR(RRR!((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs ' $cCse|iot|idjp'|i o6t|iiidjotd|iin|S(s Validates that we aren't trying to do a query like value__in=qs.values('value1', 'value2'), which isn't valid. is.Cannot use a multi-field %s as a filter value.(RR%RReRfRDRR(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs  'N( RRRR.RRRRHRRRRR(((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR8s  ,  RcBseZdZdZRS(c #sioItidjo3xZiiiiD]}|dVq<Wn+ii oCii o5x iiiiD]}t |VqWniii }i }iii }|||}io)t it fd|}n|}xbiiiiD]E}tt||}t g}|D]} ||| q]~Vq4WdS(Niics |ijS((R(R(R(s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyts(RR%RRRqRpRrRaRcRRbRR)RR`Rt( RRRRRRRfR,RR((Rs@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR.s&   )cOs?tt|i||}t|dp|i|_n|S(NR(RRRHRR(RRMRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRHs(RRR.RH(((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs RcBs)eZdZdZdedZRS(cCs|ii|iiS(N(RRqRpRr(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR.scCs]|ii|iidtidt|_g|i_|ii|i|i |i dS(s Sets up any special features of the query attribute. Called by the _clone() method after initializing the rest of the instance. RRN( RRRR t DateQueryR:Rtadd_date_selectRRR(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs ! cKs_tt|i|t|}|i|_|i|_|ot|do|in|S(NR(RRRHRRRRR(RRRRR ((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRHs   N(RRR.RRRRH(((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs  RScBseZddddZdZdZdZdZdedZ dZ dZ dZ d Z d Zd Zd Zd ZedZdddddddZdZdZdZdZeZRS(cCs)tt|i|||g|_dS(N(RRSRR(RRRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRscCs |iS(N(RH(RRV((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRXscCs |iS(N(RH(RRV((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRZscCsdS(Ni((R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRscCsdS(N((R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRscKs.tt|i|d||}g|_|S(NR(RRSRHR(RRRRR ((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRHs! ccstgiVdS(N(R2R9(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR. scCs|S(s/ Always returns EmptyQuerySet. ((R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRscOs|S(s/ Always returns EmptyQuerySet. ((RRMR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRscOs|S(s/ Always returns EmptyQuerySet. ((RRMR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRscCs|S(s/ Always returns EmptyQuerySet. ((RR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR$scOs|S(s/ Always returns EmptyQuerySet. ((RRfR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR_*scOs|S(s/ Always returns EmptyQuerySet. ((RRMR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR0scGs|S(s/ Always returns EmptyQuerySet. ((RR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR6scCs|S(s/ Always returns EmptyQuerySet. ((RR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR<scCs|iip td|S(s/ Always returns EmptyQuerySet. s1Cannot change a query once a slice has been taken(RRRG(RRRRRRR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRBscCs|S(s/ Always returns EmptyQuerySet. ((R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRKscGs|S(s/ Always returns EmptyQuerySet. ((RRf((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRQscGs|S(s/ Always returns EmptyQuerySet. ((RRf((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRWscKsdS(s( Don't update anything. i((RR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR]sN(RRRRRXRZRRRRHR.RRRRR_RRR:RRRRRRR(((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRSs,                  ic "CsC|o|djo||jodS|dj } |oT|i|} xH|iiD]-} |i| } | o| i| qXqXWnd} | ot}g}xl|iiD][\}}|i| jo|i|iq| o|dj oqq|i |i qWt |}||||!} | d|jo d}qG|o.t ||}|t t|| }qG|| }n| o.g}|iiD]}||i q~}n+g}|iiD]}||i q~}t |}||||!} | d|jo d}n|t t|| }|o||i_t|i_n|||}x|iiD]}t|| |pqn| o||i}nd}t|ii|||||d|d|}|ok|\}}|dj ot||i|n|io*|dj ot||ii|qcqqW| og}|iiD]*}|iio||i|ifqq~}x|D]u\}}t|| |dt pqn||i!}t||||||d|d|dt }|o|\}}|dj ot||ii|n|dj ot||i|x|iiD]\}} | dj ovt||i t"||i |ioIy/t"||i}!t||i|!Wq!t#j oq!Xq%qqWq1qqWn||fS(s Helper function that recursively returns an object with the specified related attributes already populated. This method may be called recursively to populate deep select_related() clauses. Arguments: * klass - the class to retrieve (and instantiate) * row - the row of data returned by the database cursor * index_start - the index of the row at which data for this object is known to start * using - the database alias on which the query is being executed. * max_depth - the maximum depth to which a select_related() relationship should be explored. * cur_depth - the current depth in the select_related() tree. Used in recursive calls to determin if we should dig deeper. * requested - A dictionary describing the select_related() tree that is to be retrieved. keys are field names; values are dictionaries describing the keys on that related object that are themselves to be select_related(). * offset - the number of additional fields that are known to exist in `row` for `klass`. This usually means the number of annotated results on `klass`. * only_load - if the query has had only() or defer() applied, this is the list of field names that will be returned. If None, the full field list for `klass` can be assumed. * local_only - Only populate local fields. This is used when building following reverse select-related relations iR^Rt local_onlyN(N(N($RRRetget_parent_listRRmRhRjRnRkRoR%R R`Rtt local_fieldsRfRuRpRRvRRstrelttoRxtget_cache_nametuniquetrelatedtget_all_related_objectsR~RR:trelated_query_nameRtAttributeError("RRR{RR[t cur_depthR\R]R^R't restrictedR}tparentRfRRR~Rt field_countR!RRRt_[2]t index_endR9t cached_rowtrel_objt_[3]totrelated_fieldst rel_fieldt rel_modelt cached_obj((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRshs !     .*      %-       !t RawQuerySetcBsweZdZd d d d d dZdZdZdZedZ dZ edZ edZ RS( sp Provides an iterator which converts the results of raw SQL queries into annotated model instances. cCsj||_||_||_|ptid|d|id||_|pd|_|ph|_dS(NR RR(( t raw_queryRRR tRawQueryRpRRt translations(RRARRRRCR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRs    +ccsh}g}|i}t|iid|it||}t|d}t|i}xXt|iD]G\}}||i jo|||i |i |i } g} x+|i iiD]} | i || i qcW|o7g} |iD]}| |i i|dq~ }nx|D]}|o|i||}n| oAh}x(|iD]\}}||||(RAR(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyR-_scCst||S(N(R)(RR"((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRQbscCs|ipti|iS(sCReturn the database that will be used if this query is executed now(RRRR(R((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRpesc CsCt|id|id|iid|d|id|id|S(s^ Selects which database this Raw QuerySet should excecute it's query against. RRRRRC(R@RARRRRRC(RR((s@/usr/local/lib/python2.6/dist-packages/django/db/models/query.pyRjscCst|dpo|ii|_xZ|iiD]E\}}y#|ii|}||i|s0""  %q