
    b?i                     j    S SK r S SKrS r\ R                  " 5       r\R                  \" \5      5        g)    Nc           
      J  #    [         R                  " SSSSSSU S9I S h  vN nUR                  5        IS h  vN nSnUR                  U5      I S h  vN   UR                  S	5      I S h  vN   UR	                  5       I S h  vN   S
nSnUR                  XT5      I S h  vN   UR                  5       I S h  vN   SnUR                  U5      I S h  vN   UR                  5       I S h  vN nU(       a   eUR                  XT5      I S h  vN   UR                  U5      I S h  vN   UR                  5       I S h  vN n[        U5        UR	                  5       I S h  vN   UR                  U5      I S h  vN   [        U5        UR                  U5      I S h  vN   UR                  5       I S h  vN   UR                  5         S S S 5      IS h  vN   g  GN GN GN GNz GNe GNK GN6 GN GN	 N N N N N Nb NL N.! , IS h  vN  (       d  f       g = f7f)Nz	127.0.0.1i  root test_pymysqlF)hostportuserpassworddb
autocommitloopzDROP TABLE IF EXISTS namesz
            CREATE TABLE names (
            id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
            name VARCHAR(30) DEFAULT '' NOT NULL,
            cnt TINYINT UNSIGNED DEFAULT 0,
            PRIMARY KEY (id))))Geert)Jan)Michelz$INSERT INTO names (name) VALUES (%s)z&SELECT id, name FROM names ORDER BY id)
aiomysqlconnectcursorexecutecommitexecutemanyrollbackfetchallprintclose)r   connr   	stmt_dropnamesstmt_insertstmt_selectresps           `/var/www/html/livechat/backend/venv/lib/python3.13/site-packages/examples/example_transaction.pytest_example_transactionr"      s    !!{'-%3'+- -D
 {{}}0	nnY'''nn ! " 	" 	" kkm 4<  444 mmo ?nn[)))__&&x   444 nn[)))__&&dkkmnn[)))d nnY'''lln

U }}-
 '	" 	
 	5 	 	*&
 	5 	*& 	) 	(S }}}sP  H#GH#G!H#H	G$H	-G'.H	G*H	"G-#H	:G0;H	G3H	-G6.!H	G9H	(G;)H	 G="H	#G?$H	<H=#H	 H!H	8H9H	H#HH#!H#$H	'H	*H	-H	0H	3H	6H	9H	;H	=H	?H	H	H	H	H#	H HH H#)asyncior   r"   get_event_loopr   run_until_complete     r!   <module>r(      s5     0f    06 7r'   