U
    [h                     @  s   d Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ	 dd	l
mZ dd
l
mZ ddl
mZ ddlmZ ddlmZ ddlmZ G dd dZG dd deZG dd deZG dd deZG dd deZeeeeeeiZdS )zRelationship dependencies.    )annotations   )
attributes)exc)sync)
unitofwork)util)
MANYTOMANY)	MANYTOONE)	ONETOMANY   )sqlc                   @  s   e Zd Zdd Zedd Zdd Zdd Zd	d
 Zdd Z	dd Z
dd Zdd Zdd Zdd Zdd Zdd Zdd Zd%ddZd d! Zd"d# Zd$S )&DependencyProcessorc                 C  s   || _ |j| _|j| _|j| _|j| _|j| _|j| _|j| _|j| _|j	| _	| jr^t
j| _nt
j| _| jrvt
j| _nt
j| _d| jj|jf | _|j| _| j jstd| j  d S )Nz%s_%sz|Can't build a DependencyProcessor for relationship %s. No target attributes to populate between parent and child are present)propcascademapperparent	secondary	directionpost_updatepassive_deletespassive_updatesenable_typechecksr   PASSIVE_NO_INITIALIZE_passive_delete_flagPASSIVE_OFF_passive_update_flagZ	_sort_keykeyZsort_keysynchronize_pairssa_excArgumentError)selfr    r"   ?./venv/lib/python3.8/site-packages/sqlalchemy/orm/dependency.py__init__   s0    

zDependencyProcessor.__init__c                 C  s   t |j |S N)_direction_to_processorr   )clsr   r"   r"   r#   from_relationship9   s    z%DependencyProcessor.from_relationshipc                 C  s   | j j| j|S )zreturn True if the given object instance has a parent,
        according to the ``InstrumentedAttribute`` handled by this
        ``DependencyProcessor``.

        )r   Zclass_managerget_implr   	hasparentr!   stater"   r"   r#   r*   =   s    zDependencyProcessor.hasparentc                 C  s   | | d dS )zestablish actions and dependencies related to a flush.

        These actions will operate on all relevant states in
        the aggregate.

        TN)register_preprocessorr!   uowr"   r"   r#   per_property_preprocessorsE   s    z.DependencyProcessor.per_property_preprocessorsc              	   C  sz   t || dd}t || dd}t || jj}t || jj}t || jj}t || jj}| ||||||| d S NFT)r   
ProcessAllSaveUpdateAllr   primary_base_mapperr   	DeleteAllper_property_dependencies)r!   r/   
after_savebefore_deleteparent_saveschild_savesparent_deleteschild_deletesr"   r"   r#   per_property_flush_actionsN   s6        z.DependencyProcessor.per_property_flush_actionsc                 C  s  | j j}t||}t||}|r<t|| dd}d|_nt|| dd}d|_||jkr||jksjt|df|dfg}	d}
nd}
|st|| j	j
}d }}||jkrd}n&t|| j	j
}d }}||jkrd}|D ]}|j| j j||j|r| jntj}|sq|r8t|| d|}|rZt||}n"t|| d|}|rZt||}|
rg }	|D ]\\}}||jkrd}n6|j| \}}|rt||df}nt||df}|	| qh|	D ]"\}}| |||||||| qqdS )zestablish actions and dependencies related to a flush.

        These actions will operate on all relevant states
        individually.    This occurs only if there are cycles
        in the 'aggregated' version of events.

        TFN)NN)r   r4   r   r3   r5   r2   ZdisabledZcyclesAssertionErrorr   base_mapperZmanagerr   implZget_all_pendingdictr   r   r   ZProcessStateZDeleteStateZSaveUpdateStatestatesappendper_state_dependencies)r!   r/   rB   isdeleteZchild_base_mapperr:   r<   r8   r7   Zchild_actionsZchild_in_cyclesr9   r;   Zparent_in_cyclesr,   Zsum_Zchild_statechildchild_actiondeletedZlistonlychildisdeleter"   r"   r#   per_state_flush_actionsj   s    	
 





z+DependencyProcessor.per_state_flush_actionsc                 C  s   dS NFr"   r!   	uowcommitrB   r"   r"   r#   presort_deletes   s    z#DependencyProcessor.presort_deletesc                 C  s   dS rK   r"   rL   r"   r"   r#   presort_saves   s    z!DependencyProcessor.presort_savesc                 C  s   d S r%   r"   rL   r"   r"   r#   process_deletes   s    z#DependencyProcessor.process_deletesc                 C  s   d S r%   r"   rL   r"   r"   r#   process_saves   s    z!DependencyProcessor.process_savesc                 C  s|   |r
| j rtjtjB }n| jtkr*tj}ntjtjB }|D ]&}||| j	|}|r:|
 s: dS q:|oz| jj oz| j|jkS )NT)r   r   r   INCLUDE_PENDING_MUTATIONSr   r
   ZPASSIVE_NO_FETCH_RELATEDr   get_attribute_historyr   emptyr   Z_is_self_referentialr   Zmappers)r!   rM   rB   rE   passiveshistoryr"   r"   r#   prop_has_changes   s$    



z$DependencyProcessor.prop_has_changesc                 C  s   | j jr$|d kr$td| j f nn|d k	r| jj|| j ds| jj|ddrttd|j| j | jj| jd ntd|j| j | jjd d S )Nz-Can't flush None value found in collection %s)Zallow_subtypesTaE  Attempting to flush an item of type %(x)s as a member of collection "%(y)s". Expected an object of type %(z)s or a polymorphic subclass of this type. If %(x)s is a subclass of %(z)s, configure mapper "%(zm)s" to load this subtype polymorphically, or set enable_typechecks=False to allow any subtype to be accepted for flush. )xyzZzmzAttempting to flush an item of type %(x)s as a member of collection "%(y)s". Expected an object of type %(z)s or a polymorphic subclass of this type.)rY   rZ   r[   )r   uselistr   Z
FlushErrorr   Z_canloadr   class_r+   r"   r"   r#   _verify_canload  s8     
z#DependencyProcessor._verify_canloadc                 C  s
   t  d S r%   NotImplementedError)r!   r,   rF   associationrow	clearkeysrM   r"   r"   r#   _synchronize1  s    z DependencyProcessor._synchronizec                 C  s>   | j jsd S tt| jgdd | j jD  }|d|ftS )Nc                 S  s   g | ]
}|j qS r"   )r   ).0pr"   r"   r#   
<listcomp>9  s     zCDependencyProcessor._get_reversed_processed_set.<locals>.<listcomp>Zreverse_key)r   _reverse_propertytuplesortedr   memoset)r!   r/   Zprocess_keyr"   r"   r#   _get_reversed_processed_set4  s    z/DependencyProcessor._get_reversed_processed_setFc                 C  s8   |D ].}|r|d k	r| |dd | jjD   q4qd S )Nc                 S  s   g | ]\}}|qS r"   r"   )rd   lrr"   r"   r#   rf   A  s     z4DependencyProcessor._post_update.<locals>.<listcomp>)Zregister_post_updater   r   )r!   r,   rM   relatedis_m2o_deleterY   r"   r"   r#   _post_update=  s     z DependencyProcessor._post_updatec                 C  s
   t  d S r%   r_   r!   rM   r,   r"   r"   r#   _pks_changedE  s    z DependencyProcessor._pks_changedc                 C  s   d| j j| jf S )Nz%s(%s))	__class____name__r   )r!   r"   r"   r#   __repr__H  s    zDependencyProcessor.__repr__N)F)ru   
__module____qualname__r$   classmethodr(   r*   r0   r=   rJ   rN   rO   rP   rQ   rX   r^   rc   rl   rq   rs   rv   r"   r"   r"   r#   r      s$   
	r )	
r   c                   @  sL   e Zd Zdd Zdd Zdd Zdd Zd	d
 Zdd Zdd Z	dd Z
dS )OneToManyDPc           
   
   C  s   | j r\t|| jjd}t|| jjd}	|j||f||f||f||	f|	|f|	|fg n6|j||f||f||f||f||f||f||fg d S r1   r   r   PostUpdateAllr   r4   dependenciesupdate)
r!   r/   r9   r:   r;   r<   r7   r8   child_post_updateschild_pre_updatesr"   r"   r#   r6   M  s<    
    z%OneToManyDP.per_property_dependenciesc	                 C  s   | j rt|| jjd}	t|| jjd}
|sl|rL|j||f||	fg q|j||f||f||	fg q|r|j||
f|
|fg q|j||
f|
|fg n<|s|j||f||f||fg n|j||f||fg d S r1   r{   )r!   r/   save_parentdelete_parentrG   r7   r8   rE   rI   r   r   r"   r"   r#   rD   v  sZ        z"OneToManyDP.per_state_dependenciesc                 C  s   | j j o| jdk }|D ]}||| j| j}|r|jD ]<}|d k	r:| |dkr:| j jrl|j	|dd q:|	| q:|r|j
D ]}|d k	r|j	|d| jd qqd S )NallFTrE   delete	operationr   )r   r   r   rS   r   r   rH   r*   delete_orphanregister_object	unchangedr   r!   rM   rB   should_null_fksr,   rW   rF   r"   r"   r#   rN     s,      

  zOneToManyDP.presort_deletesc              	   C  sd  | d| ft}| jj o$| jdk }|D ]2}| ||}|rF| jrTtjtj	B }ntj
tj	B }||| j|}|r&|jD ] }	|	d k	r||j|	dd| jd q|||j |jD ]t}	| jjs|r|j|	dd| jd q| |	dkr|j|	dd| jd | jd|	D ]\}
}}}|j|dd	 qq|r*|r*|jD ](}	|	d k	r4|j|	d| jd
| jd q4q*d S )Nchildren_addedr   Tadd)Zcancel_deleter   r   Fr   rE   r   r   r   z	pk changer   )rj   rk   r   r   r   rs   r   r   r   rR   r   rS   r   addedr   r   r~   rH   r*   r   cascade_iteratorr   )r!   rM   rB   r   r   r,   pks_changedrU   rW   rF   cmst_dct_r"   r"   r#   rO     st    





 

zOneToManyDP.presort_savesc              
   C  s   | j s| jdks|d| ft}|D ]}||| j| j}|r$|jD ]H}|d k	rD| |dkrD| 	||d d|d | j rD|rD| 
|||g qD| j s| jjs$t|j|D ]:}|d k	r| 	||d d|d | j r|r| 
|||g qq$d S )Nr   r   FT)r   r   rj   rk   rS   r   r   rH   r*   rc   rq   r   r   r   
difference)r!   rM   rB   r   r,   rW   rF   r"   r"   r#   rP     sV      
     

     
  zOneToManyDP.process_deletesc              
   C  s   | j j o| jdk }|D ]}||| jtj}|r|jD ]6}| ||d d|d |d k	r:| j	r:| 
|||g q:|jD ].}|rx| j jsx| |sx| ||d d|d qx| ||r|jD ]}| ||d d|d qqd S )Nr   FT)r   r   r   rS   r   r   r   r   rc   r   rq   rH   r*   rs   r   r   r"   r"   r#   rQ   B  s\    

  
     
     
     zOneToManyDP.process_savesc           	   	   C  sp   |}|}|  | |d ks*| js.||r.d S |rHt|| j| jj n$t|| j	|| j| jj|| j
oh| d S r%   )r^   r   
is_deletedr   clearr   r   r   populater   r   )	r!   r,   rF   ra   rb   rM   r   sourcedestr"   r"   r#   rc   d  s(    
zOneToManyDP._synchronizec                 C  s   t ||| j| jjS r%   r   source_modifiedr   r   r   rr   r"   r"   r#   rs   {  s       zOneToManyDP._pks_changedN)ru   rw   rx   r6   rD   rN   rO   rP   rQ   rc   rs   r"   r"   r"   r#   rz   L  s   )AD,"rz   c                   @  sN   e Zd Zdd Zdd Zdd Zdd Zd	d
 Zdd Zdd Z	dddZ
dS )ManyToOneDPc                 C  s.   t | | | jjD ]}|jt| qd S r%   )r   r$   r   Zself_and_descendantsZ_dependency_processorsrC   DetectKeySwitch)r!   r   r   r"   r"   r#   r$     s    zManyToOneDP.__init__c           
   
   C  s   | j rbt|| jjd}t|| jjd}	|j||f||f||f||	f||	f|	|f|	|fg n$|j||f||f||f||fg d S r1   r   r   r|   r   r4   r}   r~   )
r!   r/   r9   r:   r;   r<   r7   r8   parent_post_updatesparent_pre_updatesr"   r"   r#   r6     s8    
    z%ManyToOneDP.per_property_dependenciesc	                 C  s   | j r|sZt|| jjd}	|r:|j||	f|	|fg q|j||f||f||	fg qt|| jjd}
|j||
f|
|f|
|fg nL|s|s|j||f||fg q|j||fg n|r|j||fg d S r1   r   )r!   r/   r   r   rG   r7   r8   rE   rI   r   r   r"   r"   r#   rD     sL        z"ManyToOneDP.per_state_dependenciesc                 C  s   | j js| j jr|D ]}||| j| j}|r| j jr@| }n| }|D ]P}|d krZqL|j|dd| j	d | j
d|}|D ]\}}	}
}|j|
dd qqLqd S )NTr   r   r   )r   r   r   rS   r   r   sumZnon_deletedr   r   r   r   )r!   rM   rB   r,   rW   ZtodeleterF   tr   r   r   r   r"   r"   r#   rN     s.      
zManyToOneDP.presort_deletesc                 C  s   |D ]}|j |d| jd | jjr||| j| j}|r|jD ]T}| |dkr>|j |dd| jd | j	
d|}|D ]\}}}	}
|j |	dd qvq>qd S )Nr   r   FTr   r   r   )r   r   r   r   rS   r   r   rH   r*   r   r   )r!   rM   rB   r,   rW   rF   r   r   r   r   r   r"   r"   r#   rO     s(      
zManyToOneDP.presort_savesc                 C  sn   | j rj| jjsj| jdksj|D ]L}| |d d d| |r| j r||| j| j}|r| j|||	 dd qd S )Nr   T)rp   )
r   r   r   r   rc   rS   r   r   rq   r   )r!   rM   rB   r,   rW   r"   r"   r#   rP     s*    
     zManyToOneDP.process_deletesc              
   C  s~   |D ]t}| || jtj}|r|jrF|jD ]}| ||d d|d q*n|jr`| |d d d|d | jr| |||	  qd S )NFr   Tr   )
rS   r   r   r   r   rc   rH   r   rq   r   )r!   rM   rB   r,   rW   rF   r"   r"   r#   rQ   '  s8      
          zManyToOneDP.process_savesNc              	   C  s   |d ks| j s||rd S |d k	rX|d k	rX|j|sXtdt||| jf  d S |sd|d krzt	
|| j| jj n(| | t	|| j|| j| jj|d d S )NGObject of type %s not in session, %s operation along '%s' won't proceedF)r   r   session_contains_stater   warn
mapperutilstate_class_strr   r   r   r   r   r^   r   r   r!   r,   rF   ra   rb   rM   r   r"   r"   r#   rc   9  s<    	

zManyToOneDP._synchronize)N)ru   rw   rx   r$   r6   rD   rN   rO   rP   rQ   rc   r"   r"   r"   r#   r     s   '8 r   c                   @  sh   e Zd ZdZdd Zdd Zdd Zdd	 Zd
d Zdd Z	dd Z
dd Zdd Zdd Zdd ZdS )r   a  For many-to-one relationships with no one-to-many backref,
    searches for parents through the unit of work when a primary
    key has changed and updates them.

    Theoretically, this approach could be expanded to support transparent
    deletion of objects referenced via many-to-one as well, although
    the current attribute system doesn't do enough bookkeeping for this
    to be efficient.

    c                 C  s<   | j jr,| jrd S ddd | j jD kr,d S || d d S )NFc                 s  s   | ]}|j V  qd S r%   )r   )rd   r   r"   r"   r#   	<genexpr>s  s   z=DetectKeySwitch.per_property_preprocessors.<locals>.<genexpr>)r   rg   r   r-   r.   r"   r"   r#   r0   n  s    z*DetectKeySwitch.per_property_preprocessorsc                 C  s6   t || jj}t || dd}|j||fg d S rK   )r   r3   r   r?   r2   r}   r~   )r!   r/   r9   r7   r"   r"   r#   r=   {  s    z*DetectKeySwitch.per_property_flush_actionsc                 C  s   d S r%   r"   )r!   r/   rB   rE   r"   r"   r#   rJ     s    z'DetectKeySwitch.per_state_flush_actionsc                 C  s   d S r%   r"   rL   r"   r"   r#   rN     s    zDetectKeySwitch.presort_deletesc                 C  s   | j s| || d S r%   )r   _process_key_switches)r!   r/   rB   r"   r"   r#   rO     s    zDetectKeySwitch.presort_savesc                 C  s"   |s| j r| ||}t|S dS rK   )r   _key_switchersbool)r!   r/   rB   rE   dr"   r"   r#   rX     s    
z DetectKeySwitch.prop_has_changesc                 C  s   dst d S rK   )r>   rL   r"   r"   r#   rP     s    zDetectKeySwitch.process_deletesc                 C  s   | j s
t| || d S r%   )r   r>   r   rL   r"   r"   r#   rQ     s    
zDetectKeySwitch.process_savesc                 C  sZ   | d| fdd \}}||}|D ].}||kr&| ||rJ|| q&|| q&|S )NZpk_switchersc                   S  s   t  t  fS r%   )rk   r"   r"   r"   r#   <lambda>      z0DetectKeySwitch._key_switchers.<locals>.<lambda>)rj   unionrs   r   )r!   r/   rB   ZswitchedZnotswitchedZ	allstatesrV   r"   r"   r#   r     s     
zDetectKeySwitch._key_switchersc           	   
   C  s   |  ||}|r|jj D ]}t|j| jjs2q|j}|| j	j
||| jd}|tjk	r|d k	r| jjr||srq|d }n|}t|}||kr||d| j t|| j|| j| jj|| j qd S )N)rU   r   F)r   r   Zidentity_mapZ
all_states
issubclassr]   r   rA   r)   r   getr   r   ZPASSIVE_NO_RESULTr   r\   Zinstance_stater   r   r   r   r   r   )	r!   ZdeplistrM   Z	switchersr,   Zdict_ro   Zrelated_objZrelated_stater"   r"   r#   r     sH      

  z%DetectKeySwitch._process_key_switchesc                 C  s    t |jot||| j| jjS r%   )r   r   r   r   r   r   r   rr   r"   r"   r#   rs     s       zDetectKeySwitch._pks_changedN)ru   rw   rx   __doc__r0   r=   rJ   rN   rO   rX   rP   rQ   r   r   rs   r"   r"   r"   r#   r   b  s   %r   c                   @  sT   e Zd Zdd Zdd Zdd Zdd Zd	d
 Zdd Zdd Z	dd Z
dd ZdS )ManyToManyDPc              
   C  s:   |j ||f||f||f||f||f||f||fg d S r%   r}   r~   )r!   r/   r9   r:   r;   r<   r7   r8   r"   r"   r#   r6     s    
z&ManyToManyDP.per_property_dependenciesc	           	      C  sX   |s<|r"|j ||f||fg qT|j ||f||fg n|j ||f||fg d S r%   r   )	r!   r/   r   r   rG   r7   r8   rE   rI   r"   r"   r#   rD     s    z#ManyToManyDP.per_state_dependenciesc                 C  s&   | j s"|D ]}||| j| j q
d S r%   )r   rS   r   r   )r!   rM   rB   r,   r"   r"   r#   rN     s      zManyToManyDP.presort_deletesc           
      C  s   | j s.|D ]"}| ||r
||| jtj q
| jjs:d S |D ]r}||| jtj}|r>|j	D ]P}| 
|dkr^|j|dd| jd | jd|D ]\}}}}	|j|dd qq^q>d S )NFTr   r   r   )r   rs   rS   r   r   r   r   r   r   rH   r*   r   r   r   r   )
r!   rM   rB   r,   rW   rF   r   r   r   r   r"   r"   r#   rO     s<        
 zManyToManyDP.presort_savesc              
     s   g }g }g }|  |}t }|D ] | | j| j}|r | D ]F}	|	d ksB|d k	rd |	f|krdqBi }
|  |	|
d|ds~qB||
 qB| fdd| D  q |d k	r|| | 	|||| d S )NFr   c                 3  s   | ]}| fV  qd S r%   r"   rd   r   r,   r"   r#   r   Y  s     z/ManyToManyDP.process_deletes.<locals>.<genexpr>)
rl   rk   rS   r   r   Z	non_addedrc   rC   r~   	_run_crud)r!   rM   rB   secondary_deletesecondary_insertsecondary_update	processedtmprW   rF   ra   r"   r   r#   rP   :  sN    
  

   zManyToManyDP.process_deletesc              
     s  g }g }g }|  |}t }|D ]F | j o8| | }|rLtjtjB }	ntjtjB }	| | j	|	}
|
r |
j
D ]>}|d k	r |f|krqri }|  ||d|dsqr|| qr|
jD ]>}|d k	r҈ |f|krqi }|  ||d|dsq|| q| fdd|
j
|
j D  |r |
jD ]D}i }t | j|d| jj t|| j|d| jj || q"q |d k	r~|| | |||| d S )NFr   r   c                 3  s   | ]}| fV  qd S r%   r"   r   r   r"   r#   r     s     z-ManyToManyDP.process_saves.<locals>.<genexpr>old_)rl   rk   r   rs   r   r   rR   r   rS   r   r   rc   rC   rH   r~   r   r   r   r   r   r   secondary_synchronize_pairsr   )r!   rM   rB   r   r   r   r   r   Zneed_cascade_pksrU   rW   rF   ra   r"   r   r#   rQ   b  s    

 
     
 


   zManyToManyDP.process_savesc                   s  |j | j}|r|d  | j tj fdd| jjD  }|	||}|
 r|jt|krtd| jjt||jf |r|d  | j tj fdd| jjD  }|	||}|
 r|jt|krtd| jjt||jf |r| j }|	|| d S )Nr   c                   s,   g | ]$}|j  kr|tj|j |jd kqS )Ztype_r   r   Z	bindparamtyper   ra   r"   r#   rf     s   
z*ManyToManyDP._run_crud.<locals>.<listcomp>zRDELETE statement on table '%s' expected to delete %d row(s); Only %d were matched.c                   s0   g | ](}|j  kr|tjd |j  |jdkqS )r   r   r   r   r   r"   r#   rf     s   
zRUPDATE statement on table '%s' expected to update %d row(s); Only %d were matched.)Ztransaction
connectionr   r   r   wherer   and_r   ZexecuteZsupports_sane_multi_rowcountZrowcountlenr   ZStaleDataErrordescriptionr~   insert)r!   rM   r   r   r   r   Z	statementresultr"   r   r#   r     s`    

	


	

zManyToManyDP._run_crudc                 C  s   |  | |d krdS |d k	rP|j|sP|jsLtdt||| jf  dS t	
|| j|| jj t	
|| j|| jj dS )NFr   T)r^   r   r   rH   r   r   r   r   r   r   Zpopulate_dictr   r   r   r   r   r"   r"   r#   rc     s0    
   zManyToManyDP._synchronizec                 C  s   t ||| j| jjS r%   r   rr   r"   r"   r#   rs     s       zManyToManyDP._pks_changedN)ru   rw   rx   r6   rD   rN   rO   rP   rQ   r   rc   rs   r"   r"   r"   r#   r     s   "(M= r   N)r   Z
__future__r    r   r   r   r   r   r   Z
interfacesr	   r
   r   r   r   r   rz   r   r   r   r&   r"   r"   r"   r#   <module>
   s>     3  7 bu  >   