
    i                     j    d dl Z d dlZd Z e j                         Zej                   ee             y)    Nc           	      >  K   t        j                  dddddd|        d {   }|j                         4 d {   }d}|j                  |       d {    |j                  d	       d {    |j	                          d {    d
}d}|j                  ||       d {    |j                          d {    d}|j                  |       d {    |j                          d {   }|rJ |j                  ||       d {    |j                  |       d {    |j                          d {   }t        |       |j	                          d {    |j                  |       d {    t        |       |j                  |       d {    |j                          d {    |j                          d d d       d {    y 7 7 7 7 w7 b7 G7 27 7 7 7 7 7 7 7 b7 L7 .# 1 d {  7  sw Y   y xY ww)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/jploft-chatbot/venv/lib/python3.12/site-packages/examples/example_transaction.pytest_example_transactionr"      s    !!{'-%3'+- -D
 {{} * *0	nnY'''nn ! " 	" 	" kkm 4<  e444 mmo ?nn[)))__&&x   e444 nn[)))__&&dkkmnn[)))d nnY'''lln

U* * *-
*'	" 	
 	5 	 	*&
 	5 	*& 	) 	(S* * * *sP   HGHG HHG#H/G&0HG)H%G,&H=G/>HG2H0G51HG8H'G:(H?G< "H"G>#H;H <#HH H7H8HHHH H#H&H)H,H/H2H5H8H:H<H>H HHHHHHHH)asyncior   r"   get_event_loopr   run_until_complete     r!   <module>r(      s7     0f w   06 7r'   