
    i                         d dl Z d dlZ e j                         Ze j                  d        Zej                   e              y)    Nc            	   #     K   t        j                  ddddddt              E d {   } | j                         E d {   }d}|j	                  |      E d {    |j	                  d	      E d {    | j                         E d {    d
}d}|j                  ||      E d {    | j                         E d {    d}|j	                  |      E d {    |j                         E d {   }|rJ |j                  ||      E d {    |j	                  |      E d {    |j                         E d {   }t        |       | j                         E d {    |j	                  |      E d {    t        |       |j	                  |      E d {    |j                         E d {    | j                          y 7 7 7 }7 g7 R7 77 "7 
7 7 7 7 7 7 s7 Q7 ;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connectr   cursorexecutecommitexecutemanyrollbackfetchallprintclose)connr   	stmt_dropnamesstmt_insertstmt_selectresps          g/var/www/html/jploft-chatbot/venv/lib/python3.12/site-packages/examples/example_transaction_oldstyle.pytest_example_transactionr"      s    &&Kd,2R*8U,02 2D
 %F,I~~i(((~~     {{} 0E8K!!+u555 }} ;K~~k***oo''DO8 !!+u555 ~~k***oo''D	$K{{}~~k***	$K ~~i(((||~JJL_2
 &( 
 6  +'
 6 +' * )s  $G8GG8GG8GG82G3G8
GG8(G)G8 G"G8G%G83G(4G8G*G8*G,+G8G."G8%G0&G8>G2?#G8"G4#G8:G6;G8G8G8G8G8G8"G8%G8(G8*G8,G8.G80G82G84G86G8)asyncior   get_event_loopr   	coroutiner"   run_until_complete     r!   <module>r)      sL      w 	0 0f   02 3r(   