o
    E6d                     @  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r;t
j| _nt
j| _d| jj|jf | _|j| _| j jsYt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_flag	_sort_keykeysort_keysynchronize_pairssa_excArgumentError)selfr    r$   pC:\Users\jesus\OneDrive\Desktop\erpjis_fastapi\backend\jisbackend\Lib\site-packages\sqlalchemy/orm/dependency.py__init__   s2   

zDependencyProcessor.__init__c                 C  s   t |j |S N)_direction_to_processorr   )clsr   r$   r$   r%   from_relationship;   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_preprocessorsG   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#   r1   
after_savebefore_deleteparent_saveschild_savesparent_deleteschild_deletesr$   r$   r%   per_property_flush_actionsP   s.   z.DependencyProcessor.per_property_flush_actionsc                 C  s  | j j}t||}t||}|rt|| dd}d|_nt|| dd}d|_||jvr@||jvs5J |df|dfg}	d}
nd}
|sXt|| jj	}d }}||jv rWd}nt|| jj	}d }}||jv rkd}|D ]}|j
| j j||j|r~| jntj}|sqm|rt|| d|}|rt||}nt|| d|}|rt||}|
rg }	|D ]+\}}||jvrd}n|j| \}}|rt||df}nt||df}|	| q|	D ]\}}| |||||||| qqmd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   r6   r   r5   r7   r4   disabledZcyclesr   base_mappermanagerr   implZget_all_pendingdictr   r   r   ZProcessStateZDeleteStateZSaveUpdateStatestatesappendper_state_dependencies)r#   r1   rE   isdeleteZchild_base_mapperr<   r>   r:   r9   Zchild_actionsZchild_in_cyclesr;   r=   Zparent_in_cyclesr.   Zsum_Zchild_statechildchild_actiondeletedZlistonlychildisdeleter$   r$   r%   per_state_flush_actionsl   s   	





z+DependencyProcessor.per_state_flush_actionsc                 C     dS NFr$   r#   	uowcommitrE   r$   r$   r%   presort_deletes      z#DependencyProcessor.presort_deletesc                 C  rN   rO   r$   rP   r$   r$   r%   presort_saves   rS   z!DependencyProcessor.presort_savesc                 C     d S r'   r$   rP   r$   r$   r%   process_deletes   rS   z#DependencyProcessor.process_deletesc                 C  rU   r'   r$   rP   r$   r$   r%   process_saves   rS   z!DependencyProcessor.process_savesc                 C  s|   |r| j rtjtjB }n| jtu rtj}ntjtjB }|D ]}||| j	|}|r0|
 s0 dS q|o=| jj o=| j|jv 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#   rQ   rE   rH   passiveshistoryr$   r$   r%   prop_has_changes   s&   



z$DependencyProcessor.prop_has_changesc                 C  s   | j jr|d u rtd| j f |d urG| jj|| j dsI| jj|ddr8td|j| j | jj| jd td|j| j | jjd d S 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.)r_   r`   ra   )r   uselistr   Z
FlushErrorr   Z_canloadr   class_r-   r$   r$   r%   _verify_canload  s8   
z#DependencyProcessor._verify_canloadc                 C     t  r'   NotImplementedError)r#   r.   rI   associationrow	clearkeysrQ   r$   r$   r%   _synchronize1     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#   r1   Zprocess_keyr$   r$   r%   _get_reversed_processed_set4  s   z/DependencyProcessor._get_reversed_processed_setFc                 C  s:   |D ]}|r
|d ur| |dd | jjD   d S qd S )Nc                 S  s   g | ]\}}|qS r$   r$   )rl   lrr$   r$   r%   rn   A  s    z4DependencyProcessor._post_update.<locals>.<listcomp>)Zregister_post_updater   r    )r#   r.   rQ   relatedis_m2o_deleter_   r$   r$   r%   _post_update=  s   z DependencyProcessor._post_updatec                 C  re   r'   rf   r#   rQ   r.   r$   r$   r%   _pks_changedE  rk   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)r}   
__module____qualname__r&   classmethodr*   r,   r2   r?   rM   rR   rT   rV   rW   r^   rd   rj   rt   ry   r{   r~   r$   r$   r$   r%   r      s&    
	p )
	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 d S |j||f||f||f||f||f||f||fg d S r3   r   r   PostUpdateAllr   r6   dependenciesupdate)
r#   r1   r;   r<   r=   r>   r9   r:   child_post_updateschild_pre_updatesr$   r$   r%   r8   M  s4   


z%OneToManyDP.per_property_dependenciesc	                 C  s   | j rVt|| jjd}	t|| jjd}
|s8|r'|j||f||	fg d S |j||f||f||	fg d S |rH|j||
f|
|fg d S |j||
f|
|fg d S |si|j||f||f||fg d S |j||f||fg d S r3   r   )r#   r1   save_parentdelete_parentrJ   r9   r:   rH   rL   r   r   r$   r$   r%   rG   v  sR   

z"OneToManyDP.per_state_dependenciesc                 C  s   | j j o
| jdk }|D ]D}||| j| j}|rQ|jD ]}|d ur;| |du r;| j jr6|j	|dd q|	| q|rQ|j
D ]}|d urP|j	|d| jd qAqd S )NallFTrH   delete	operationr   )r   r   r   rY   r   r   rK   r,   delete_orphanregister_object	unchangedr   r#   rQ   rE   should_null_fksr.   r]   rI   r$   r$   r%   rR     s*   



zOneToManyDP.presort_deletesc              	   C  sZ  | d| ft}| jj o| jdk }|D ]}| ||}|r"| jr)tjtj	B }ntj
tj	B }||| j|}|r|jD ]}	|	d urL|j|	dd| jd q<||j |jD ]9}	| jjsi|rh|j|	dd| jd qV| |	du r|j|	dd| jd | jd|	D ]\}
}}}|j|dd	 qqV|r|r|jD ]}	|	d ur|j|	d| jd
| jd qqd S )Nchildren_addedr   Tadd)Zcancel_deleter   r   Fr   rH   r   r   r   z	pk changer   )rr   rs   r   r   r   r{   r   r   r   rX   r   rY   r   addedr   r   r   rK   r,   r   cascade_iteratorr   )r#   rQ   rE   r   r   r.   pks_changedr[   r]   rI   cmst_dct_r$   r$   r%   rT     s|   





zOneToManyDP.presort_savesc              
   C  s   | j s| jdksu|d| ft}|D ]d}||| j| j}|rt|jD ]$}|d urF| |du rF| 	||d d|d | j rF|rF| 
|||g q"| j sN| jjstt|j|D ]}|d urs| 	||d d|d | j rs|rs| 
|||g qVqd S d S )Nr   r   FT)r   r   rr   rs   rY   r   r   rK   r,   rj   ry   r   r   r   
difference)r#   rQ   rE   r   r.   r]   rI   r$   r$   r%   rV     s>   




zOneToManyDP.process_deletesc              
   C  s   | j j o
| jdk }|D ]]}||| jtj}|rj|jD ]}| ||d d|d |d ur8| j	r8| 
|||g q|jD ]}|rS| j jsS| |sS| ||d d|d q<| ||rj|jD ]}| ||d d|d q]qd S )Nr   FT)r   r   r   rY   r   r   r   r   rj   r   ry   rK   r,   r{   r   r   r$   r$   r%   rW   B  sB   





zOneToManyDP.process_savesc           	   	   C  sr   |}|}|  | |d u s| js||rd S |r%t|| j| jj d S t|| j	|| j| jj|| j
o5| d S r'   )rd   r   
is_deletedr   clearr   r   r    populater   r   )	r#   r.   rI   rh   ri   rQ   r   sourcedestr$   r$   r%   rj   d  s(   
zOneToManyDP._synchronizec                 C     t ||| j| jjS r'   r   source_modifiedr   r   r    rz   r$   r$   r%   r{   {     zOneToManyDP._pks_changedN)r}   r   r   r8   rG   rR   rT   rV   rW   rj   r{   r$   r$   r$   r%   r   L  s    )AD,"r   c                   @  sP   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_processorsrF   DetectKeySwitch)r#   r   r   r$   r$   r%   r&     s   zManyToOneDP.__init__c           
   
   C  s   | j r2t|| jjd}t|| jjd}	|j||f||f||f||	f||	f|	|f|	|fg d S |j||f||f||f||fg d S r3   r   r   r   r   r6   r   r   )
r#   r1   r;   r<   r=   r>   r9   r:   parent_post_updatesparent_pre_updatesr$   r$   r%   r8     s0   


z%ManyToOneDP.per_property_dependenciesc	                 C  s   | j rI|s/t|| jjd}	|r|j||	f|	|fg d S |j||f||f||	fg d S t|| jjd}
|j||
f|
|f|
|fg d S |sf|s[|j||f||fg d S |j||fg d S |rs|j||fg d S d S r3   r   )r#   r1   r   r   rJ   r9   r:   rH   rL   r   r   r$   r$   r%   rG     sF   

z"ManyToOneDP.per_state_dependenciesc                 C  s   | j js| j jrP|D ]G}||| j| j}|rO| j jr | }n| }|D ](}|d u r-q&|j|dd| j	d | j
d|}|D ]\}}	}
}|j|
dd q@q&q
d S d S )NTr   r   r   )r   r   r   rY   r   r   sumZnon_deletedr   r   r   r   )r#   rQ   rE   r.   r]   ZtodeleterI   tr   r   r   r   r$   r$   r%   rR     s2   

zManyToOneDP.presort_deletesc                 C  s   |D ]H}|j |d| jd | jjrJ||| j| j}|rJ|jD ]*}| |du rI|j |dd| jd | j	
d|}|D ]\}}}	}
|j |	dd q;qqd S )Nr   r   FTr   r   r   )r   r   r   r   rY   r   r   rK   r,   r   r   )r#   rQ   rE   r.   r]   rI   r   r   r   r   r   r$   r$   r%   rT     s(   

zManyToOneDP.presort_savesc                 C  sz   | j r5| jjs7| jdks9|D ],}| |d d d| |r4| j r4||| j| j}|r4| j|||	 dd qd S d S d S d S )Nr   T)rx   )
r   r   r   r   rj   rY   r   r   ry   r   )r#   rQ   rE   r.   r]   r$   r$   r%   rV     s&   


zManyToOneDP.process_deletesc              
   C  s~   |D ]:}| || jtj}|r<|jr#|jD ]}| ||d d|d qn|jr0| |d d d|d | jr<| |||	  qd S )NFr   Tr   )
rY   r   r   r   r   rj   rK   r   ry   r   )r#   rQ   rE   r.   r]   rI   r$   r$   r%   rW   '  s&   

zManyToOneDP.process_savesNc              	   C  s   |d u s| j s||rd S |d ur,|d ur,|j|s,tdt||| jf  d S |s2|d u r>t	
|| j| jj d S | | 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    rd   r   r   r#   r.   rI   rh   ri   rQ   r   r$   r$   r%   rj   9  s8   	

zManyToOneDP._synchronizer'   )r}   r   r   r&   r8   rG   rR   rT   rV   rW   rj   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 v rd S || d d S )NFc                 s  s    | ]}|j V  qd S r'   )r   )rl   r   r$   r$   r%   	<genexpr>s  s
    
z=DetectKeySwitch.per_property_preprocessors.<locals>.<genexpr>)r   ro   r   r/   r0   r$   r$   r%   r2   n  s   z*DetectKeySwitch.per_property_preprocessorsc                 C  s6   t || jj}t || dd}|j||fg d S rO   )r   r5   r   rA   r4   r   r   )r#   r1   r;   r9   r$   r$   r%   r?   {  s   z*DetectKeySwitch.per_property_flush_actionsc                 C  rU   r'   r$   )r#   r1   rE   rH   r$   r$   r%   rM     rS   z'DetectKeySwitch.per_state_flush_actionsc                 C  rU   r'   r$   rP   r$   r$   r%   rR     rS   zDetectKeySwitch.presort_deletesc                 C  s   | j s| || d S d S r'   r   _process_key_switches)r#   r1   rE   r$   r$   r%   rT     s   zDetectKeySwitch.presort_savesc                 C  s"   |s| j r| ||}t|S dS rO   )r   _key_switchersbool)r#   r1   rE   rH   dr$   r$   r%   r^     s   
z DetectKeySwitch.prop_has_changesc                 C  s   J r'   r$   rP   r$   r$   r%   rV     rS   zDetectKeySwitch.process_deletesc                 C  s   | j sJ | || d S r'   r   rP   r$   r$   r%   rW     s   
zDetectKeySwitch.process_savesc                 C  sZ   | d| fdd \}}||}|D ]}||vr*| ||r%|| q|| q|S )NZpk_switchersc                   S  s   t  t  fS r'   )rs   r$   r$   r$   r%   <lambda>  s    z0DetectKeySwitch._key_switchers.<locals>.<lambda>)rr   unionr{   r   )r#   r1   rE   ZswitchedZnotswitchedZ	allstatesr\   r$   r$   r%   r     s   

zDetectKeySwitch._key_switchersc           	   
   C  s   |  ||}|rb|jj D ]U}t|j| jjsq|j}|| j	j
||| jd}|tjura|d ura| jjr>|s9q|d }n|}t|}||v ra||d| j t|| j|| j| jj|| j qd S d S )N)r[   r   F)r   r   Zidentity_mapZ
all_states
issubclassrc   r   rD   r+   r   getr   r   ZPASSIVE_NO_RESULTr   rb   Zinstance_stater   r   r   r   r   r    )	r#   ZdeplistrQ   Z	switchersr.   Zdict_rw   Zrelated_objZrelated_stater$   r$   r%   r     sB   


z%DetectKeySwitch._process_key_switchesc                 C  s    t |jot||| j| jjS r'   )r   r   r   r   r   r   r    rz   r$   r$   r%   r{     s   zDetectKeySwitch._pks_changedN)r}   r   r   __doc__r2   r?   rM   rR   rT   r^   rV   rW   r   r   r{   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#   r1   r;   r<   r=   r>   r9   r:   r$   r$   r%   r8     s   
z&ManyToManyDP.per_property_dependenciesc	           	      C  s\   |s |r|j ||f||fg d S |j ||f||fg d S |j ||f||fg d S r'   r   )	r#   r1   r   r   rJ   r9   r:   rH   rL   r$   r$   r%   rG     s   z#ManyToManyDP.per_state_dependenciesc                 C  s*   | j s|D ]}||| j| j qd S d S r'   )r   rY   r   r   )r#   rQ   rE   r.   r$   r$   r%   rR     s   
zManyToManyDP.presort_deletesc           
      C  s   | j s|D ]}| ||r||| jtj}q| jjsd S |D ]9}||| jtj}|rX|j	D ](}| 
|du rW|j|dd| jd | jd|D ]\}}}}	|j|dd qIq/qd S )NFTr   r   r   )r   r{   rY   r   r   r   r   r   r   rK   r,   r   r   r   r   )
r#   rQ   rE   r.   r]   rI   r   r   r   r   r$   r$   r%   rT     s8   


zManyToManyDP.presort_savesc              
     s   g }g }g }|  |}t }|D ]C | | j| j}|rS| D ]#}	|	d u s1|d ur2 |	f|v r2q!i }
|  |	|
d|ds?q!||
 q!| fdd| D  q|d ur]|| | 	|||| d S )NFr   c                 3      | ]}| fV  qd S r'   r$   rl   r   r.   r$   r%   r   Y      z/ManyToManyDP.process_deletes.<locals>.<genexpr>)
rt   rs   rY   r   r   Z	non_addedrj   rF   r   	_run_crud)r#   rQ   rE   secondary_deletesecondary_insertsecondary_update	processedtmpr]   rI   rh   r$   r   r%   rV   :  s@   


zManyToManyDP.process_deletesc              
     s  g }g }g }|  |}t }|D ] | j o| | }|r%tjtjB }	ntjtjB }	| | j	|	}
|
r|
j
D ]}|d urE |f|v rEq8i }|  ||d|dsRq8|| q8|
jD ]}|d urh |f|v rhq[i }|  ||d|dsuq[|| q[| fdd|
j
|
j D  |r|
jD ]!}i }t | j|d| jj t|| j|d| jj || qq|d ur|| | |||| d S )NFr   r   c                 3  r   r'   r$   r   r   r$   r%   r     r   z-ManyToManyDP.process_saves.<locals>.<genexpr>old_)rt   rs   r   r{   r   r   rX   r   rY   r   r   rj   rF   rK   r   r   r   r   r   r    r   secondary_synchronize_pairsr   )r#   rQ   rE   r   r   r   r   r   Zneed_cascade_pksr[   r]   rI   rh   r$   r   r%   rW   b  s   


 

zManyToManyDP.process_savesc                   s  |j | j}|rA|d  | j tj fdd| jjD  }|	||}|
 rA|jt|krAtd| jjt||jf |r{|d  | j tj fdd| jjD  }|	||}|
 r{|jt|kr{td| jjt||jf |r| j }|	|| d S d S )Nr   c                   s,   g | ]}|j  v r|tj|j |jd kqS )type_r   r   Z	bindparamtyper   rh   r$   r%   rn     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  v r|tjd |j  |jdkqS )r   r   r   r   r   r$   r%   rn     s
    
zRUPDATE statement on table '%s' expected to update %d row(s); Only %d were matched.)Ztransaction
connectionr   r   r   wherer   and_r   executeZsupports_sane_multi_rowcountZrowcountlenr   ZStaleDataErrordescriptionr   insert)r#   rQ   r   r   r   r   Z	statementresultr$   r   r%   r     s^   

	


	

zManyToManyDP._run_crudc                 C  s   |  | |d u rdS |d ur(|j|s(|js&tdt||| jf  dS t	
|| j|| jj t	
|| j|| jj dS )NFr   T)rd   r   r   rK   r   r   r   r   r   r   Zpopulate_dictr   r    r   r   r   r$   r$   r%   rj     s*   
zManyToManyDP._synchronizec                 C  r   r'   r   rz   r$   r$   r%   r{     r   zManyToManyDP._pks_changedN)r}   r   r   r8   rG   rR   rT   rV   rW   r   rj   r{   r$   r$   r$   r%   r     s    "(M= r   N)r   
__future__r    r   r   r   r   r   r   Z
interfacesr	   r
   r   r!   r   r   r   r   r   r   r(   r$   r$   r$   r%   <module>   s:   	  1  7 bu  >