ó i4Vdc@sddlZddlZddlmZddlmZddlmZddlm Z m Z m Z m Z ddl mZmZddlmZmZmZmZmZmZddlmZdd lmZmZdd lmZdd lmZdd l m!Z!dd l"m#Z#de$fd„ƒYZ%de%fd„ƒYZ&de%fd„ƒYZ'de%fd„ƒYZ(de%fd„ƒYZ)d„Z*dS(iÿÿÿÿN(tchain(t FieldError(t LOOKUP_SEP(tOrderBytRandomtRawSQLtRef(t QueryWrappertselect_related_descend(tCURSORtGET_ITERATOR_CHUNK_SIZEtMULTIt NO_RESULTSt ORDER_DIRtSINGLE(tEmptyResultSet(tQueryt get_order_dir(tTransactionManagementError(t DatabaseError(tRemovedInDjango110Warning(tzipt SQLCompilercBs%eZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Z e d „Z ee e d „Zd „Zdddd „Zd„Zdddd„Zd„Zd„Zdddddd„Zd„Zd„Zd„Zdd„Zd„Zed„Zd„ZRS(cCse||_||_||_idd6|_d|_d|_d|_tj dƒ|_ t |_ dS(Nt*s(.*)\s(ASC|DESC)(.*)( tqueryt connectiontusingt quote_cachetNonetselecttannotation_col_mapt klass_infotretcompiletordering_partstFalsetsubquery(tselfRRR((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyt__init__s      csft‡fd†ˆjjDƒƒr2ˆjjƒnˆjƒ\ˆ_ˆ_ˆ_tˆjƒˆ_ dS(Nc3s%|]}ˆjj|dkVqdS(iN(Rtalias_refcount(t.0ta(R%(sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys %s( tallRttablestget_initial_aliast get_selectRRRtlent col_count(R%((R%sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyt setup_query$s"cCso|jƒ|jƒ}|jjjƒ\|_|_|j||jƒ}|j|j||ƒ}|||fS(sâ Does any necessary class setup immediately prior to producing SQL. This is for things that can't necessarily be done in __init__ because we might not have all the pieces in place at that time. ( R0t get_order_byRtwheret split_havingthavingtget_extra_selectRt get_group_by(R%torder_byt extra_selecttgroup_by((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyt pre_sql_setup*s   cCsà|jjdkrgSg}|jjtk r€xO|jjD]>}t|dƒsl|j|jj|ƒƒq;|j|ƒq;WnxA|D]9\}}}|jƒ}x|D]}|j|ƒq©Wq‡WxK|D]C\}\}} } |jrïqËn| rûqËn|j |j ƒƒqËW|j r*|j jƒnd} x| D]}|j|ƒq7Wg} t ƒ} |j || ƒ}xj|D]b}|j|ƒ\}} |t| ƒf| krv| j|| fƒ| j|t| ƒfƒqvqvW| S(sî Returns a list of 2-tuples of form (sql, params). The logic of what exactly the GROUP BY clause contains is hard to describe in other words than "if it passes the test suite, then it is correct". tas_sqlN((RR9RtTruethasattrtappendt resolve_reftget_group_by_colstcontains_aggregatetextendtget_source_expressionsR4tsettcollapse_group_byR!ttupletadd(R%RR7t expressionstexprt_tcolstcoltsqltparamstis_refthaving_group_bytresulttseen((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR67s<%       cCs!|jjjr®d}x^|D]V}t|ddƒ|jjjjkrt|ddƒ|jj dkr|}PqqW|r|gg|D]}||kr‰|^q‰}qno|jjj rd„|Dƒ}d„|Dƒ}g|D]0}||kst|ddƒ|krä|^qä}n|S(NttargettaliasicSs1h|]'}t|dƒr|jjr|’qS(RS(R=RSt primary_key(R(RI((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys  s cSsh|]}|j’qS((RT(R(RI((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys ¡s ( Rtfeaturestallows_group_by_pkRtgetattrRtmodelt_metatpkR+tallows_group_by_selected_pks(R%RHR4R[RItpkstaliases((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRE‡s $"2@csg}d}i}d}xV|jjjƒD]B\}\}}|||<|jt||ƒ|fƒ|d7}q+W|jjo†|jj st‚|jjrg}x>|j ƒD]0} |j|ƒ|j| dfƒ|d7}q¯Wi|jj d6|d6}nx1|jjD]#} |j| dfƒ|d7}q WxG|jj jƒD]3\}} |||<|j| |fƒ|d7}qGW|jj r¿|j |ƒ} | |d<‡fd†‰ˆ|ƒng} x9|D]1\} }| j| |j| dtƒ|fƒqÌW| ||fS( sŸ Returns three values: - a list of 3-tuples of (expression, (sql, params), alias) - a klass_info structure, - a dictionary of annotations The (sql, params) is what the expression will produce, and alias is the "AS alias" for the column (possibly None). The klass_info structure contains the following information: - Which model to instantiate - Which columns for that model are present in the query (by position of the select clause). - related_klass_infos: [f, klass_info] to descent into The annotations is a dictionary of {'attname': column position} values. iiRYt select_fieldstrelated_klass_infoscsFx?|dD]3}|dr4|d|d|dRRt default_colstAssertionErrortget_default_columnsRYtannotation_selecttselect_relatedtget_related_selectionsR!R<(R%RRt annotationst select_idxRTRMRNt select_listtcRLt annotationR`tret((Rcsk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR-§sD%         )cCsç|jjr|jj}n?|jjs6|jj}n$|jjpW|jjƒjpWg}|jjrytd\}}ntd\}}g}xŠt|ƒD]|\}}t |dƒrt |t ƒsÕ|j ƒ}n|jjsî|j ƒn|j|tfƒqœn|dkr5|jt tƒƒtfƒqœnt||ƒ\}}|dkr\tnt} ||jjkr¬|jt t||jj|ƒd| ƒtfƒqœn||jjkrí|jt |jj|d| ƒtfƒqœnd|krR|jddƒ\} }|jt td|j| ƒ|fgƒd| ƒtfƒqœn|jj sq||jjkrœ|j|j||jjƒd |ƒƒqœ||jjkrà|jt t|jj|Œd| ƒtfƒqœ|jt t|t|jj|Œƒd| ƒtfƒqœWg} tƒ} xµ|D]­\} }| j|jd td d ƒ}|j!|ƒ\}}|j"j#|ƒj$dƒ}|t%|ƒf| krªq2n| j&|t%|ƒfƒ| j||||ffƒq2W| S( s, Returns a list of 2-tuples of form (expr, (sql, params, is_ref)) for the ORDER BY clause. The order_by clause can alter the select clause (for example it can add aliases to clauses that do not yet have one, or it can add totally new select clauses). tASCtDESCtresolve_expressiont?t descendingt.is%s.%st default_ordert allow_joinstreuseN('Rtextra_order_bytdefault_orderingR7tget_metatorderingtstandard_orderingR t enumerateR=t isinstanceRtasctreverse_orderingR>R#RRR<RiRRltsplitRtquote_name_unless_aliast_extraRBtfind_ordering_nameR8textraRDRtRR!R"tsearchtgroupRFRG(R%R~R‚tdescR7tpostfieldRLtorderRvttableRQRRRIROtresolvedRMRNtwithout_ordering((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR1çs|  $    "   "   (  c Cs¶g}g|D]}|d^q }|jjr²|jj r²xs|D]h\}\}}} |jj|ƒjdƒ} | rC| |f|krC|j|| |fdfƒqCqCWn|S(Ni(Rtdistincttdistinct_fieldsR"R‰RŠR>R( R%R7RR8ttt select_sqlRIRMRNROR‘((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR5Cs&cCs#tjdtddƒ|j|ƒS(s‘ Backwards-compatibility shim so that calling a SQLCompiler is equivalent to calling its quote_name_unless_alias method. s\Calling a SQLCompiler directly is deprecated. Call compiler.quote_name_unless_alias instead.t stackleveli(twarningstwarnRR…(R%tname((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyt__call__Ms cCs«||jkr|j|S||jjkr>||jjkst||jjkst||jjkr…||jjkr…||j|<|S|jjj|ƒ}||j|<|S(sÛ A wrapper around connection.ops.quote_name that doesn't quote aliases for table names. This avoids problems with some SQL dialects that treat quoted strings specially (e.g. PostgreSQL). ( RRt alias_mapt table_mapR8texternal_aliasesRtopst quote_name(R%R™tr((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR…Xs $$  cCsˆt|d|jjdƒ}|r=|||jƒ\}}n|j||jƒ\}}|r~|j r~|jj|||ƒS||fS(Ntas_(RXRtvendorRR;R$t output_fieldRd(R%tnodeRdt vendor_implRMRN((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR!iscCsi||_|jjjƒ}z6|jƒ\}}}|jƒ}|jƒ\} } |jdk rr|j |jƒn dgf\} } |j dk r¥|j |j ƒn dgf\} }g}dg}|jj rñ|j |j jj|ƒƒng}d}x|j|D]~\}\}}}|rHd||j jj|ƒf}n'|rod|d|f}|d7}n|j|ƒ|j |ƒq W|j dj|ƒƒ|j dƒ|j| ƒ|j| ƒ| rñ|j d| ƒ|j| ƒng}x.|D]&\}}|j |ƒ|j|ƒqþW|r{|rCtd ƒ‚n|s^|j jjƒ}n|j d dj|ƒƒn| r¢|j d | ƒ|j|ƒn|rg}x7|D]/\}\}}}|j |ƒ|j|ƒqµW|j d dj|ƒƒn|r«|jjdk rA|j d |jj|jjƒn|jjr«|jjdkrŽ|j jjƒ}|rŽ|j d |ƒqŽn|j d|jjƒq«n|jjr7|j jjr7|j jƒrätdƒ‚n|jj}|r|j jj rt dƒ‚n|j |j jj!d|ƒƒndj|ƒt"|ƒfSWd|jj#|ƒXdS(sÏ Creates the SQL for this query. Returns the SQL string and list of parameters. If 'with_limits' is False, any limit/offset information is not included in the query. ttSELECTis%s AS %ssCol%ds, tFROMsWHERE %ss1annotate() + distinct(fields) is not implemented.s GROUP BY %ss HAVING %ss ORDER BY %ssLIMIT %ds OFFSET %ds:select_for_update cannot be used outside of a transaction.s1NOWAIT is not supported on this database backend.tnowaitt N($R$RR'tcopyR:t get_distincttget_from_clauseR2RR!R4R’R>RRžt distinct_sqlRRŸRBtjointNotImplementedErrortforce_no_orderingt high_marktlow_marktno_limit_valuetselect_for_updateRVthas_select_for_updatetget_autocommitRtselect_for_update_nowaitthas_select_for_update_nowaitRtfor_update_sqlRFtreset_refcounts(R%t with_limitstwith_col_aliasesR$trefcounts_beforeR8R7R9R“tfrom_tf_paramsR2tw_paramsR4th_paramsRNRQtout_colstcol_idxRJts_sqlts_paramsRTtgroupingtg_sqltg_paramsR~to_sqlto_paramstvalR©((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR;ssˆ  33  #"        $   "cCsŠ|jjƒ}|jdkrJ|jdkrJ|jj rJ|jtƒn|jd|j ƒj dtƒ}|ddfkr†t ‚n|S(sV Perform the same functionality as the as_sql() method, returning an SQL string and parameters. However, the alias prefixes are bumped beforehand (in a copy -- the current query isn't changed), and any ordering is removed if the query is unsliced. Used when nesting this query inside another. iRR$R¦N(( RtcloneR³R²RR“tclear_orderingR<t get_compilerRR;R(R%tobjt nested_sql((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyt as_nested_sqlÖs +! c Cs)g}|dkr$|jjƒ}n|jƒ}|sH|jjƒ}ni|d6}xÍ|jD]Â}|jjj}||jkrŒd}n|r¿|dk r¿t |jj|jjƒr¿q_n|j|krê|j ||jkrêq_n|jj ||||ƒ} |j | ƒ} |j | ƒq_W|S(sW Computes the default columns for selecting every field in the base model. Will sometimes be called to pull in related models (e.g. via select_related), in which case "opts" and "start_alias" will be given to provide a starting point for the traversal. Returns a list of strings, quoted appropriately for use in SQL directly, as well as a set of aliases used in the select statement (if 'as_pairs' is True, returns a list of (alias, col_name) pairs instead of strings as the first component and None as the second component). N(RRR}tdeferred_to_columnsR,tconcrete_fieldsRYRZtconcrete_modelt issubclasstattnametjoin_parent_modeltget_colR>( R%t start_aliastoptsRaRQt only_loadt seen_modelsRRYRTtcolumn((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRhès*     % c Csø|j}|jjj}g}|jjƒ}xÄ|jjD]¶}|jtƒ}|j ||dƒ\}}} } } }|jj || | ƒ\}} }xV|D]N} ||jj krÆ|j |ƒqž|j d|| ƒ|| jƒfƒqžWq:W|S(sÙ Returns a quoted list of fields to use in DISTINCT ON part of the query. Note that this method can alter the tables in the query, and thus it must be called before get_from_clause(). s%s.%sN(R…RRžRŸRR}R“R„Rt _setup_joinsRt trim_joinsRiR>RÞ( R%tqntqn2RQRÛR™tpartsRJttargetsRTtjoinstpathRS((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR¬s '! .Rrcsvt||ƒ\}}|dkr'tnt}|jtƒ}ˆj|||ƒ\} } }} } }| jr#|jr#t| ddƒ|kr#|sŸt ƒ}nt ‡fd†| Dƒƒ} | |krÖt dƒ‚n|j | ƒg}x3|jD](}|jˆj|||||ƒƒqóW|Sˆjj| | | ƒ\} }}g| D]'}t|j|ƒd|ƒtf^qKS(sã Returns the table alias (the name might be ambiguous, the alias will not be) and column name for ordering by the given 'name' parameter. The 'name' is of the form 'field1__field2__...__fieldN'. RsR×c3s+|]!}tˆjj|ddƒVqdS(t join_colsN(RXRR›R(R(tj(R%(sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys ?ss!Infinite loop caused by ordering.RvN(RR<R#R„RRßt is_relationR~RXRRDRFRRGRBR‡RRàRRÙ(R%R™RÛRTRxt already_seenRŽRvtpiecesRRäRåRæt join_tupletresultstitemRJR”((R%sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR‡,s$'*   !cCs_|s|jjƒ}n|jj|||ƒ\}}}}}|d}||||||fS(s$ A helper method for get_order_by and get_distinct. Note that get_ordering and get_distinct must produce same target columns on same input, as the prefixes of get_ordering and get_distinct must match. Executing SQL where this is not true is an error. iÿÿÿÿ(RR,t setup_joins(R%RëRÛRTRRäRåRæ((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRßLs   c Csg}g}x„|jjD]v}|jj|s5qny|jj|}Wntk r_qnX|j|ƒ\}}|j|ƒ|j|ƒqWxq|jjD]c}|jj |ƒ\}}||jjksæ|jj|dkr |jd|j |ƒƒq q W||fS(sÔ Returns a list of strings that are joined together to go after the "FROM" part of the query, as well as a list any extra parameters that need to be included. Sub-classes, can override this to create a from-clause via a "select". This should only be called after any SQL construction methods that might change the tables we need. This means the select columns, ordering and distinct must be done first. is, %s( RR+R'R›tKeyErrorR!R>RBt extra_tablest table_aliasR…( R%RQRNRTt from_clauset clause_sqlt clause_paramsR”RJ((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR­[s"   (!icsÛ‡fd†}g}| r>|jjr>||jjkr>|Sˆse|jjƒ‰|jjƒ}n|jjƒ} tƒ} |dkr¼t|jjt ƒr³|jj}t }q¼t }nd„} x߈j D]Ô} | j jj} | j| jƒ|rm|j| jiƒ}| jss|s9|dkrj| j|krjtd| jdj|ƒƒpZdfƒ‚qjqsnt }t| ||| j| ƒƒs—qÏni| jj d6| d6t d 6t d 6}|j|ƒg}|jj| jgˆ|ƒ\}}}}}|d }|jd |d | jj jƒ}x4|D],}|jt|ƒƒ|j|dfƒq1W||d<|j|| jj j||d||ƒ}| ||ƒqÏW|r×gˆjD].}|jjr·|j r·|j|j!f^q·}x|D]y\} }t| ||| j|ƒd t ƒs(qòn| j"ƒ}| j|ƒ|jj|gˆ|ƒ\}}}}}|d }t#|ˆj ƒ}i|d6| d6t d 6|d 6}|j|ƒg}|jd |d |jd ˆj ƒ}x4|D],}|jt|ƒƒ|j|dfƒqçW||d<|j| j"ƒiƒ}|j||j||d||ƒ}| ||ƒqòWt|j$ƒƒj%| ƒ}|r×d„|Dƒ}tddj|ƒdj|ƒƒpÇdfƒ‚q×n|S(s Fill in the information needed for a select_related query. The current depth is measured as the number of connections away from the root model (for example, cur_depth=1 means we are looking at models with direct connections to the root model). cs3d„ˆjDƒ}d„ˆjDƒ}t||ƒS(Ncss!|]}|jr|jVqdS(N(RéR™(R(tf((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys †scss*|] }|jjr|jjƒVqdS(N(Rtuniquetrelated_query_name(R(Rö((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys ˆs(tfieldstrelated_objectsR(tdirect_choicestreverse_choices(RÛ(sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyt_get_field_choices…s cSs||dõssBInvalid field name(s) given in select_related: %s. Choices are: %sN(&Rt max_depthR}R,tget_loaded_field_namesRDRRRjtdictR<R#RùRYRZRÕRGR™tgetRéRR¯Rt remote_fieldR>RïRhR.RkRúRR÷t many_to_manyt related_modelRøRÖtkeyst difference(R%RRÛt root_aliast cur_deptht requestedt restrictedRýR`RÜt fields_foundRþRöt field_modeltnextRR_RJRåRTtcolumnsRLtnext_klass_infostotrelated_fieldsRYtrelated_field_nameRatfields_not_foundtinvalid_fields((RÛsk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRk}s®%       !(     $ !  % .   *        %cCs#i}|jj||jjƒ|S(sµ Converts the self.deferred_loading data structure to mapping of table names to sets of column names which are to be loaded. Returns the dictionary. (Rtdeferred_to_datatget_loaded_field_names_cb(R%R((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRÓÿscCszi}xmt|ƒD]_\}}|r|jjj|ƒ}|j|jƒ}|sX|rr|||f||ÜsN(R(R(R#(RùR%(sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys Üscss|]}t|ŒVqdS(N(R(R(R#((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys âs(R( R%Rùt value_rowstrows_of_fields_as_sqltsql_and_param_pair_rowstplaceholder_rowst param_rowsR#tpstp((RùR%sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pytassemble_as_sqlÊs   9c sž|jjj‰|jjƒ}dˆ|jƒg}t|jjƒ}|rX|jjn |jg}|j ddj ‡fd†|Dƒƒƒ|rág|jj D]7}g|D]$}|j ||j ||ƒƒ^q®^q¡}n7g|jj D]}|jjjƒg^qî}dg}|j o.|jjj} |j||ƒ\} } |jr|jjjr| d} dˆ|jƒˆ|jjƒf} |j ddj | dƒƒ|jjjƒ\}}|rê|j || ƒ| |7} ndj |ƒt| ƒfgS| rQ|j |jjj|| ƒƒdj |ƒtd „| DƒƒfgSgt| | ƒD]5\}}dj |ddj |ƒgƒ|f^qaSdS( NsINSERT INTO %ss(%s)s, c3s|]}ˆ|jƒVqdS(N(RÞ(R(Rö(Rá(sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys ösis%s.%ss VALUES (%s)Rªcss"|]}|D] }|Vq qdS(N((R(RYRZ((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys s(RRžRŸRR}tdb_tableR-RùR[R>R¯tobjsRORRtpk_default_valueRRDRVthas_bulk_insertR[tcan_return_id_from_insertRÞtreturn_insert_idRFtbulk_insert_sqlR(R%RÛRQt has_fieldsRùRÐRRTRJtcan_bulkRWRXRNRLtr_fmttr_paramsRZtvals((Rásk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR;ís6*J.  % &cCsÝ|ot|jjƒdk s%t‚||_|jjƒš}x*|jƒD]\}}|j||ƒqMW|ov|s}dS|jj j rŸ|jj j |ƒS|jj j ||jjƒj|jjƒjjƒSWdQXdS(Ni(R.RR]RgRDRR0R;R1RVR`Ržtfetch_returned_insert_idtlast_insert_idR}R\R[RÞ(R%RDR0RMRN((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR(s%  ( RARBR&RJRORRR[R;R#R((((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRC†s   # 2tSQLDeleteCompilercBseZd„ZRS(cCsÁtg|jjD]"}|jj|dkr|^qƒdksMtdƒ‚|j}d||jjdƒg}|j|jjƒ\}}|r¨|jd|ƒndj |ƒt |ƒfS(sh Creates the SQL for this query. Returns the SQL string and list of parameters. iis)Can only delete from one table at a time.sDELETE FROM %ssWHERE %sRª( R.RR+R'RgR…R!R2R>R¯RF(R%R”RáRQR2RN((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR;.sD  (RARBR;(((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRj-stSQLUpdateCompilercBs#eZd„Zd„Zd„ZRS(cCs–|jƒ|jjs ddfS|jjd}|j}d||ƒg}|jdƒgg}}xµ|jjD]§\}}}t|dƒrÊ|j|jdtdt ƒ}|j r@t dƒ‚q@nvt|d ƒr(|j r|j |j|ƒd |jƒ}q@td |||jjfƒ‚n|j |d |jƒ}t|d ƒrj|j|||jƒ} nd } |j} t|dƒrÊ|j|ƒ\} } |jd|| ƒ| fƒ|j| ƒqs|dk r|jd|| ƒ| fƒ|j|ƒqs|jd|| ƒƒqsW|s.ddfS|jdj|ƒƒ|j|jjƒ\} } | ry|jd| ƒndj|ƒt|| ƒfS(sh Creates the SQL for this query. Returns the SQL string and list of parameters. R¦is UPDATE %stSETRtRyRKs1Aggregate functions are not allowed in this querytprepare_database_saveRsSTried to update field %s with a model instance, %r. Use a value compatible with %s.RHs%sR;s%s = %ss %s = NULLs, sWHERE %sRª(N((R:RtvaluesR+R…R>R=RtR#R<RARRRNRmRt TypeErrort __class__RARHRÞR!RBRR¯R2RF(R%RRáRQRnt update_paramsRRYRÌt placeholderR™RMRNR2((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR;>sR           cCs¨tt|ƒj|ƒ}z%|r*|jnd}|dk}Wd|rS|jƒnXxM|jjƒD]<}|j|j ƒj|ƒ}|rd|rd|}t }qdqdW|S(s Execute the specified update. Returns the number of rows affected by the primary update query. The "primary update query" is the first non-empty query that is executed. Row counts for any subsequent, related queries are not available. iN( RERkR(trowcountRR3Rtget_related_updatesRÏRR#(R%R8R0R)tis_emptyRtaux_rows((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR(vs  cCsŒ|jjjƒ}|jjƒ|jjƒ}|jj rK|dkrKdS|jjdtƒ}t|_ |j t ƒi|_ g|_ |j|jƒjjgƒtt|ƒjƒ|dkoÐ|jjj }|jjƒ|j_|jjsú|rbg}x:|j|jƒjtƒD]}|jd„|DƒƒqW|jjd|fƒ||j_ n|jjd|fƒ|jj!|ƒdS(sœ If the update depends on results from other tables, we need to do some munging of the "where" conditions to match the format required for (portable) SQL updates. That is done here. Further, if we are going to be running multiple updates, we pull out the id values to update at this point so that they don't change as a result of the progressive updates. iNtklasscss|]}|dVqdS(iN((R(R ((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pys ®stpk__in("RR'R«R,tcount_active_tablestrelated_updatesRÍRR#RjRÎR<R†Rt add_fieldsR}R[R™RERkR:RRVtupdate_can_self_selectt where_classR2RÏRR(R RBt add_filtert related_idsR»(R%R¾tcountRtmust_pre_selecttidentsR)((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR:‹s,      "(RARBR;R(R:(((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRk=s 8 tSQLAggregateCompilercBseZd„ZRS(cCsÔ|jjst‚ngg}}xO|jjjƒD];}|j|dtƒ\}}|j|ƒ|j|ƒq5Wt |jjƒ|_ dj |ƒ}t |ƒ}d||jjf}||jj }||fS(sh Creates the SQL for this query. Returns the SQL string and list of parameters. Rds, sSELECT %s FROM (%s) subquery(RR$RRiRnR!R<R>RBR.R/R¯RFt sub_params(R%RMRNRptann_sqlt ann_params((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR;¸s     (RARBR;(((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyRƒ·sc#sXzFx?t‡fd†|ƒD]%}g|D]}|d|!^q)VqWWdˆjƒXdS(s] Yields blocks of rows from a cursor and ensures the cursor is closed when done. cs ˆjtƒS(N(t fetchmanyR ((R0(sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pytÖR¦iN(R/R3(R0tsentinelR/R)R ((R0sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyR5Ðs  '(+R R—t itertoolsRtdjango.core.exceptionsRtdjango.db.models.constantsRtdjango.db.models.expressionsRRRRtdjango.db.models.query_utilsRRtdjango.db.models.sql.constantsR R R R R Rt#django.db.models.sql.datastructuresRtdjango.db.models.sql.queryRRtdjango.db.transactionRtdjango.db.utilsRtdjango.utils.deprecationRtdjango.utils.six.movesRtobjectRRCRjRkRƒR5(((sk/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/models/sql/compiler.pyts,  ".ÿÿÿu§z