
    5h                         S SK Jr  S SKJr  S SKJr  S SKJr  SSK Jr  SSK Jr  SSK J	r	  SS	K J
r
   " S
 S\R                  5      rg)   )fixtures)eq_)Column)Table   )Integer)select)testing)unionc                       \ rS rSrSr\S 5       r\S 5       rSS jrS r	S r
\R                  R                  \R                  R                  S	 5       5       r\R                  R                   S
 5       rS rS rSrg)DeprecatedCompoundSelectTest   Tc           
      t    [        SU[        S[        SS9[        S[        5      [        S[        5      5        g )N
some_tableidT)primary_keyxy)r   r   r   )clsmetadatas     u/var/www/html/cementerio_25MayoBackend/env/lib/python3.13/site-packages/sqlalchemy/testing/suite/test_deprecations.pydefine_tables*DeprecatedCompoundSelectTest.define_tables   s0    4d33 3 	
    c           
          UR                  U R                  R                  R                  5       SSSS.SSSS.SSSS.SSSS./5        g )N   r   )r   r   r   r         )executetablesr   insert)r   
connections     r   insert_data(DeprecatedCompoundSelectTest.insert_data    sS    JJ!!((*qq)qq)qq)qq)		
r    c                 V    [        UR                  X$5      R                  5       U5        g )N)r   r   fetchall)selfconnr	   resultparamss        r   _assert_result+DeprecatedCompoundSelectTest._assert_result,   s    DLL(113V<r   c                    U R                   R                  n[        U5      R                  UR                  R
                  S:H  5      n[        U5      R                  UR                  R
                  S:H  5      n[        X45      n[        R                  " S5         U R                  XR                  UR                  R
                  5      SS/5        S S S 5        g ! , (       d  f       g = fNr   r   AThe SelectBase.c and SelectBase.columns attributes are deprecatedr   r   r   r   r   r   )r    r   r	   wherecr   r   r
   expect_deprecatedr,   order_byr(   r"   tables1s2u1s         r   test_plain_union-DeprecatedCompoundSelectTest.test_plain_union/   s    &&E]  q1E]  q12]&&(
 KK09i2H	
 
 
s   8C
C)c                    U R                   R                  n[        U5      R                  UR                  R
                  S:H  5      n[        U5      R                  UR                  R
                  S:H  5      n[        X45      R                  5       R                  5       n[        R                  " S5         U R                  XR                  UR                  R
                  5      SS/5        S S S 5        g ! , (       d  f       g = fr/   )r    r   r	   r3   r4   r   r   aliasr
   r5   r,   r6   r7   s         r   "_dont_test_select_from_plain_union?DeprecatedCompoundSelectTest._dont_test_select_from_plain_unionD   s    &&E]  q1E]  q12]  "))+&&(
 KK09i2H	
 
 
s   68C77
Dc                    U R                   R                  n[        U5      R                  UR                  R
                  S:H  5      R                  S5      R                  UR                  R
                  5      n[        U5      R                  UR                  R
                  S:H  5      R                  S5      R                  UR                  R
                  5      n[        X45      R                  S5      n[        R                  " S5         U R                  XR                  UR                  R
                  5      SS/5        S S S 5        g ! , (       d  f       g = fNr   r   r   r0   r1   r2   )r    r   r	   r3   r4   r   limitr6   r   r
   r5   r,   r7   s         r   &test_limit_offset_selectable_in_unionsCDeprecatedCompoundSelectTest.test_limit_offset_selectable_in_unionsR   s     &&E]  q177:CCEGGJJOE]  q177:CCEGGJJO2]  #&&(
 KK09i2H	
 
 
s   8E
Ec                    U R                   R                  n[        U5      R                  UR                  R
                  S:H  5      R                  UR                  R
                  5      n[        U5      R                  UR                  R
                  S:H  5      R                  UR                  R
                  5      n[        X45      R                  S5      n[        R                  " S5         U R                  XR                  UR                  R
                  5      SS/5        S S S 5        g ! , (       d  f       g = fr/   )r    r   r	   r3   r4   r   r6   r   rD   r
   r5   r,   r7   s         r   "test_order_by_selectable_in_unions?DeprecatedCompoundSelectTest.test_order_by_selectable_in_unionsb   s    &&E]  q1::577::FE]  q1::577::F2]  #&&(
 KK09i2H	
 
 
s   /8D00
D>c                 .   U R                   R                  n[        U5      R                  UR                  R
                  S:H  5      R                  5       n[        U5      R                  UR                  R
                  S:H  5      R                  5       n[        X45      R                  S5      n[        R                  " S5         U R                  XR                  UR                  R
                  5      SS/5        S S S 5        g ! , (       d  f       g = fr/   )r    r   r	   r3   r4   r   distinctr   rD   r
   r5   r,   r6   r7   s         r   "test_distinct_selectable_in_unions?DeprecatedCompoundSelectTest.test_distinct_selectable_in_unionsq   s    &&E]  q1::<E]  q1::<2]  #&&(
 KK09i2H	
 
 
s   8D
Dc                 .   U R                   R                  n[        U5      R                  UR                  R
                  S:H  5      R                  S5      R                  UR                  R
                  5      R                  5       R                  5       n[        U5      R                  UR                  R
                  S:H  5      R                  S5      R                  UR                  R
                  5      R                  5       R                  5       n[        X45      R                  S5      n[        R                  " S5         U R                  XR                  UR                  R
                  5      SS/5        S S S 5        g ! , (       d  f       g = frC   )r    r   r	   r3   r4   r   rD   r6   r?   r   r
   r5   r,   r7   s         r   .test_limit_offset_aliased_selectable_in_unionsKDeprecatedCompoundSelectTest.test_limit_offset_aliased_selectable_in_unions   s   &&5MU577::?#U1XXeggjj!UWVX 	 5MU577::?#U1XXeggjj!UWVX 	 2]  #&&(
 KK09i2H	
 
 
s   8F
FN)r%   )__name__
__module____qualname____firstlineno____backend__classmethodr   r#   r,   r<   r@   r
   requiresorder_by_col_from_union/parens_in_union_contained_select_w_limit_offsetrE   0parens_in_union_contained_select_wo_limit_offsetrH   rL   rO   __static_attributes__r%   r   r   r   r      s    K
 
 	
 	
=* --EE F . FF Gr   r   N) r   
assertionsr   schemar   r   r   r	   r
   r   
TablesTestr   r%   r   r   <module>r`      s3           F8#6#6 Fr   