+
    ir                         ^RI Ht ^RIHt ^RIHt ^RIHt ^RI Ht ^RI Ht ^RI H	t	 ^RI H
t
  ! R	 R
]P                  4      tR# )   )fixtures)eq_)Column)Table)Integer)select)testing)unionc                     a  ] tR t^t o Rt]R 4       t]R 4       tRR ltR t	R t
]P                  P                  ]P                  P                  R 4       4       t]P                  P                   R 4       tR	 tR
 tRtV tR# )DeprecatedCompoundSelectTestTc           
     |    \        R V\        R\        RR7      \        R\        4      \        R\        4      4       R# )
some_tableidT)primary_keyxyN)r   r   r   )clsmetadatas   &&ڄC:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\site-packages\sqlalchemy/testing/suite/test_deprecations.pydefine_tables*DeprecatedCompoundSelectTest.define_tables   s0    4d33 3 	
    c                    VP                  V P                  P                  P                  4       R ^R^R^/R ^R^R^/R ^R^R^/R ^R^R^/.4       R# )r   r   r   N)executetablesr   insert)r   
connections   &&r   insert_data(DeprecatedCompoundSelectTest.insert_data    sk    JJ!!((*q#q#q)q#q#q)q#q#q)q#q#q)		
r   c                X    \        VP                  W$4      P                  4       V4       R # )N)r   r   fetchall)selfconnr   resultparamss   &&&&&r   _assert_result+DeprecatedCompoundSelectTest._assert_result,   s    DLL(113V<r   c                   V P                   P                  p\        V4      P                  VP                  P
                  ^8H  4      p\        V4      P                  VP                  P
                  ^8H  4      p\        W44      p\        P                  ! R4      ;_uu_ 4        V P                  WP                  VP                  P
                  4      RR.4       RRR4       R#   + '       g   i     R# ; ir   zAThe SelectBase.c and SelectBase.columns attributes are deprecatedN)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$$C5	c                (   V P                   P                  p\        V4      P                  VP                  P
                  ^8H  4      p\        V4      P                  VP                  P
                  ^8H  4      p\        W44      P                  4       P                  4       p\        P                  ! R4      ;_uu_ 4        V P                  WP                  VP                  P
                  4      RR.4       RRR4       R#   + '       g   i     R# ; ir)   )r   r   r   r,   r-   r   r
   aliasr	   r.   r&   r/   r0   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   >8D  D	c                   V P                   P                  p\        V4      P                  VP                  P
                  ^8H  4      P                  ^4      P                  VP                  P
                  4      p\        V4      P                  VP                  P
                  ^8H  4      P                  ^4      P                  VP                  P
                  4      p\        W44      P                  ^4      p\        P                  ! R4      ;_uu_ 4        V P                  WP                  VP                  P
                  4      RR.4       RRR4       R#   + '       g   i     R# ; ir)   )r   r   r   r,   r-   r   limitr/   r
   r	   r.   r&   r0   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                   V P                   P                  p\        V4      P                  VP                  P
                  ^8H  4      P                  VP                  P
                  4      p\        V4      P                  VP                  P
                  ^8H  4      P                  VP                  P
                  4      p\        W44      P                  ^4      p\        P                  ! R4      ;_uu_ 4        V P                  WP                  VP                  P
                  4      RR.4       RRR4       R#   + '       g   i     R# ; ir)   )r   r   r   r,   r-   r   r/   r
   r<   r	   r.   r&   r0   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   78D99E
	c                F   V P                   P                  p\        V4      P                  VP                  P
                  ^8H  4      P                  4       p\        V4      P                  VP                  P
                  ^8H  4      P                  4       p\        W44      P                  ^4      p\        P                  ! R4      ;_uu_ 4        V P                  WP                  VP                  P
                  4      RR.4       RRR4       R#   + '       g   i     R# ; ir)   )r   r   r   r,   r-   r   distinctr
   r<   r	   r.   r&   r/   r0   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                F   V P                   P                  p\        V4      P                  VP                  P
                  ^8H  4      P                  ^4      P                  VP                  P
                  4      P                  4       P                  4       p\        V4      P                  VP                  P
                  ^8H  4      P                  ^4      P                  VP                  P
                  4      P                  4       P                  4       p\        W44      P                  ^4      p\        P                  ! R4      ;_uu_ 4        V P                  WP                  VP                  P
                  4      RR.4       RRR4       R#   + '       g   i     R# ; ir)   )r   r   r   r,   r-   r   r<   r/   r8   r
   r	   r.   r&   r0   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)rI   )__name__
__module____qualname____firstlineno____backend__classmethodr   r   r&   r5   r9   r	   requiresorder_by_col_from_union/parens_in_union_contained_select_w_limit_offsetr=   0parens_in_union_contained_select_wo_limit_offsetr@   rD   rG   __static_attributes____classdictcell__)__classdict__s   @r   r   r      s     K
 
 	
 	
=* --EE F . FF G r   r   N) r   
assertionsr   schemar   r   r   r   r	   r
   
TablesTestr   rI   r   r   <module>r[      s3           F8#6#6 Fr   