ó
    øÞ jÙ  ã                   óŽ   • 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     Úd/var/www/html/gaurav/venv/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   € à×ÑØ�J‰J×!Ñ!×(Ñ(Ó*à˜q qÑ)Ø˜q qÑ)Ø˜q qÑ)Ø˜q qÑ)ð	õ	
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   € ÜˆD�L‰L˜Ó(×1Ñ1Ó3°VÕ<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‹]ˆÜ×&Ò&ð(õ
ð ×ÑØŸK™K¨¯©¯©Ó0°9¸iÐ2Hô÷	
÷ 
ö 
ú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‹]× Ñ Ó"×)Ñ)Ó+ˆÜ×&Ò&ð(õ
ð ×ÑØŸK™K¨¯©¯©Ó0°9¸iÐ2Hô÷	
÷ 
ö 
ú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_unionsÚCDeprecatedCompoundSelectTest.test_limit_offset_selectable_in_unionsR   sñ   € ð —‘×&Ñ&ˆÜ�E‹]× Ñ  §¡§¡¨q¡Ó1×7Ñ7¸Ó:×CÑCÀEÇGÁGÇJÁJÓOˆÜ�E‹]× Ñ  §¡§¡¨q¡Ó1×7Ñ7¸Ó:×CÑCÀEÇGÁGÇJÁJÓOˆä�2‹]× Ñ  Ó#ˆÜ×&Ò&ð(õ
ð ×ÑØŸK™K¨¯©¯©Ó0°9¸iÐ2Hô÷	
÷ 
ö 
ú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×:Ñ:¸5¿7¹7¿:¹:ÓFˆÜ�E‹]× Ñ  §¡§¡¨q¡Ó1×:Ñ:¸5¿7¹7¿:¹:ÓFˆä�2‹]× Ñ  Ó#ˆÜ×&Ò&ð(õ
ð ×ÑØŸK™K¨¯©¯©Ó0°9¸iÐ2Hô÷	
÷ 
ö 
ú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‹]× Ñ  Ó#ˆÜ×&Ò&ð(õ
ð ×ÑØŸK™K¨¯©¯©Ó0°9¸iÐ2Hô÷	
÷ 
ö 
ú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_unionsÚKDeprecatedCompoundSelectTest.test_limit_offset_aliased_selectable_in_unions   s  € Ø—‘×&Ñ&ˆä�5‹Mß‰U�5—7‘7—:‘: ‘?Ó#ß‰U�1‹Xß‰X�e—g‘g—j‘jÓ!ß‰U‹Wß‰V‹Xð 	ô �5‹Mß‰U�5—7‘7—:‘: ‘?Ó#ß‰U�1‹Xß‰X�e—g‘g—j‘jÓ!ß‰U‹Wß‰V‹Xð 	ô �2‹]× Ñ  Ó#ˆÜ×&Ò&ð(õ
ð ×ÑØŸK™K¨¯©¯©Ó0°9¸iÐ2Hô÷	
÷ 
ö 
ú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   