
    i                     z   d dl Z d dlZd dlmZ  ej
                         Z ej                  de ej                  dej                  d       ej                  d ej                  d                  Ze j                  d	        Ze j                  d
        Z e j                         j!                   e              y)    N)create_enginetblidT)primary_keyval   c              #      K   | E d {   5 }|j                  d      E d {    |j                  d      E d {    d d d        y 7 @7 (7 # 1 sw Y   y xY ww)NzDROP TABLE IF EXISTS tblzCREATE TABLE tbl (
                                            id serial PRIMARY KEY,
                                            val varchar(255)))execute)engineconns     e/var/www/html/jploft-chatbot/venv/lib/python3.12/site-packages/examples/example_simple_sa_oldstyle.pycreate_tabler      sm     
 B<< :;;;<< !A B 	B 	BB B
;	BB BsF   AA	AAAAAA 
AAAAAc               #   T  K   t        dddd      E d {   } t        |       E d {    | E d {   5 }|j                  t        j	                         j                  d            E d {    |j                  t        j                               E d {   }|D ]"  }t        |j                  |j                         $ |j                         E d {    d d d        | j                          | j                         E d {    y 7 7 7 7 7 |7 ?# 1 sw Y   >xY w7 w)Nroottest_pymysqlz	127.0.0.1 )userdbhostpasswordabc)r   )r   r   r
   r   insertvaluesselectprintr   r   commitclosewait_closed)r   r   resrows       r   gor!      s     %6)7+6/13 3F
 F###
 !<<

 3 3 3 >???cjjl33 	#C#&&#''"	# ;;=  ! LLN!!###!3
 $
?3 	!! ! $s   D(DD(D	D(DD(7D.D/*DD>DDD+D(D&	D(D(D(DDDD#D()asyncio
sqlalchemysaaiomysql.sar   MetaDatametadataTableColumnIntegerStringr   	coroutiner   r!   get_event_looprun_until_complete     r   <module>r1      s      % 2;;=bhhuhryyrzzt<ryy			#/1
 	B B 	$ $(     + +BD 1r0   