+
    i                         ^ 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	I H	t	 ^ R
I
Ht ^ RI
Ht  ! R R]P                  4      tR# )    )	bindparam)Column)Integer)MetaData)select)String)Table)testing)text)eq_)fixturesc                     a  ] tR t^t o RtRtRt]R 4       t]R 4       t	R t
]P                  ! R. RO4      ]P                  ! R	RR
.4      R 4       4       tR tR t]P                  ! RRR
.4      ]P                  ! RR]P                   P"                  3R]P                   P$                  3.4      R 4       4       tR tR tR t]P                   P.                  R 4       t]P                   P.                  R 4       tRtV tR# )RowCountTestztest rowcount functionalityTc                    \        R V\        R\        RRR7      \        R\        ^24      4      \        R\        ^4      4      4       R# )	employeesemployee_idFTautoincrementprimary_keyname
departmentN)r	   r   r   r   )clsmetadatas   &&ڀC:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\site-packages\sqlalchemy/testing/suite/test_rowcount.pydefine_tablesRowCountTest.define_tables   sB    # 	 66":&<+	
    c                    . RO;V n         pV P                  P                  pTP                  VP	                  4       \        V4       UUUu. uF  w  pw  rVRVRVRV/NK  	  uppp4       R# u upppi )Angelar   r   r   N)	)r   A)Andrewr    )Anandr    )BobB)Bobetter$   )Buffyr$   )CharlieC)Cynthiar(   )Chrisr(   )datatablesr   executeinsert	enumerate)r   
connectionr+   employees_tableinds   &&     r   insert_dataRowCountTest.insert_data+   sv    

 
	
4 **..""$ "+4!0IAv 61lA>!0	
s   A,c                H   V P                   P                  p\        VP                  P                  VP                  P
                  4      P                  VP                  P                  4      pVP                  V4      P                  4       p\        W@P                  4       R # )N)r,   r   r   cr   r   order_byr   r-   fetchallr   r+   )selfr0   r1   srowss   &&   r   
test_basicRowCountTest.test_basicB   sx    ++//""O$5$5$@$@

(?$$00
1 	
 !!!$--/D))r   	statementupdatedeleteclose_firstFc                   V P                   P                  pVP                  P                  pVP                  '       d7   VP                  VP	                  4       P                  VR 8H  4      RR/4      pEM-VP                  '       d6   VP                  VP                  4       P                  VR 8H  4      RR/4      pMVP                  '       d7   VP                  VP                  4       R^RRRR/R^RRRR/R^RRRR/.4      pMVP                  '       d}   \        VP                  P                  VP                  P                  4      P                  VP                  P                  R 8H  4      pVP                  V4      pVP                  4        MVP                  4        V'       d   XP                  4        XP                  R
9   g   Q hR	# )r(   r   Zr   r   znone 1Xznone 2znone 3N)   )r,   r   r8   r   rA   r-   whererB   r.   r   r   allfailcloserowcount)r;   r0   r@   rC   r1   r   rr<   s   &&&&    r   $test_non_rowcount_scenarios_no_raise1RowCountTest.test_non_rowcount_scenarios_no_raiseK   s   
 ++// %&&11
""&&(..zS/@As#A ""&&(..zS/@As#A ""&&("B,L"B,L"B,LA !!&&(9(9(D(DeO%%00C78  ""1%AEEGNNGGIzzW$$$r   c                    V P                   P                  pVP                  P                  pVP	                  VP                  4       P                  VR 8H  4      RR/4      pVP                  ^8X  g   Q hR# )r(   r   rE   N)r,   r   r8   r   r-   rA   rI   rM   r;   r0   r1   r   rN   s   &&   r   test_update_rowcount1"RowCountTest.test_update_rowcount1v   sj    ++// %&&11
""$**:+<=3
 zzQr   c                    V P                   P                  pVP                  P                  pVP	                  VP                  4       P                  VR 8H  4      RR /4      p\        VP                  ^4       R# )r(   r   N)	r,   r   r8   r   r-   rA   rI   r   rM   rR   s   &&   r   test_update_rowcount2"RowCountTest.test_update_rowcount2   sh    ++// %&&11
""$**:+<=3
 	AJJr   implicit_returningdmlc                   V'       d   V P                   P                  pMP\        R\        4       \	        R\
        RRR7      \	        R\        ^24      4      \	        R\        ^4      4      RR7      pVP                  P                  pVP                  '       d]   VP                  4       P                  VR	8H  4      P                  VP                  P                  R
,           R7      P                  4       pMSVP                  '       d2   VP                  4       P                  VR	8H  4      P                  4       pMVP                  4        VP                  X4      p\!        VP"                  ^4       R# )znote this test should succeed for all RETURNING backends
as of 2.0.  In
Idf28379f8705e403a3c6a937f6a798a042ef2540 we changed rowcount to use
len(rows) when we have implicit returning

r   r   FTr   r   r   )rX   r(   rE   )r   N)r,   r   r	   r   r   r   r   r8   r   rA   rI   valuesreturn_defaultsrB   rK   r-   r   rM   )r;   r0   rX   rY   r1   r   stmtrN   s   &&&&    r   +test_update_delete_rowcount_return_defaults8RowCountTest.test_update_delete_rowcount_return_defaults   s   $ "kk33O#
!"' $	 vvbz*|VAY/#(O %&&11
:::&&(zS()_..99C?@ "	  ZZZ&&(zS() "  HHJt$AJJr   c                T    VP                  R 4      p\        VP                  ^4       R# z8update employees set department='Z' where department='C'N)exec_driver_sqlr   rM   r;   r0   results   && r   test_raw_sql_rowcount"RowCountTest.test_raw_sql_rowcount   s%    ++F
 	FOOQr   c                f    VP                  \        R 4      4      p\        VP                  ^4       R# ra   )r-   r   r   rM   rc   s   && r   test_text_rowcountRowCountTest.test_text_rowcount   s+    ##KL
 	FOOQr   c                    V P                   P                  pVP                  P                  pVP	                  VP                  4       P                  VR 8H  4      4      p\        VP                  ^4       R# )r(   N)	r,   r   r8   r   r-   rB   rI   r   rM   rR   s   &&   r   test_delete_rowcount!RowCountTest.test_delete_rowcount   s`    ++// %&&11
""$**:+<=
 	AJJr   c                2   V P                   P                  pVP                  4       P                  VP                  P
                  \        R 4      8H  4      P                  RR7      pVP                  VR R/R R/R R/.4      p\        VP                  ^4       R# )emp_namer(   )r   r#   r)   nonexistentN)r,   r   rA   rI   r8   r   r   r[   r-   r   rM   r;   r0   r1   r]   rN   s   &&   r   test_multi_update_rowcount'RowCountTest.test_multi_update_rowcount   s    ++//""$U?$$))Yz-BBCVsV# 	 U#Y']+
 	AJJr   c                   V P                   P                  pVP                  4       P                  VP                  P
                  \        R 4      8H  4      pVP                  VR R/R R/R R/.4      p\        VP                  ^4       R# )rn   r#   r)   ro   N)
r,   r   rB   rI   r8   r   r   r-   r   rM   rp   s   &&   r   test_multi_delete_rowcount'RowCountTest.test_multi_delete_rowcount   s    ++//%%'--""i
&;;
 U#Y']+
 	AJJr    N)sane_rowcount)rA   rB   r.   r   )__name__
__module____qualname____firstlineno____doc____requires____backend__classmethodr   r5   r>   r
   	variationrO   rS   rV   requiresupdate_returningdelete_returningr^   re   rh   rk   sane_multi_rowcountrq   rt   __static_attributes____classdictcell__)__classdict__s   @r   r   r      s=    %%LK
 
 
 
, {$LM}tUm4'% 5 N'%R	
 +dE];w''889w''889	
. <.`   )) *& )) *r   r   N)
sqlalchemyr   r   r   r   r   r   r	   r
   r   sqlalchemy.testingr   r   
TablesTestr   rv   r   r   <module>r      s<    !         " 'l8&& lr   