
    r@;j                         e d             e d           ddlZddlZddlZddlZddlZ ej                    Zdej        v r+ ej	        e          Z
ej                            d           n ej                    Z
e
ej        vrej                            de
            ej                    ZddlZddlmZ eZdej        v rdej        _         e ej                    e dej        z              ej                    Zi Zd	Zd
Zded<   ded<   ded<   ded<   edeged<   need<   ded<   dZej        dk    redk    rnYedk    r!dZdZdZdZ dZ!dZ"e"de!d ed!ed"ed#e d$Zn2ed%k    r, ej#                    rd&Z$nd'Z$ ej%        e          Z&d(e$d)e&Z e d*e             e d+e            G d, d-ej'                  Z(e)d.k    r ej*                      eed           dS dS )/zLThis module depends on the dbapi20 compliance tests created by Stuart Bishopz*(see db-sig mailing list history for info)    Nz	--package   z	--verbose   zTested with dbapi20 %sztestsql.2txt.us,1430z%s\SQLEXPRESSadotestnameadotestuseruser	Sq1234567passwordsecuritymacro_auto_securityhostmacro_getnodezBProvider=MSOLEDBSQL;DataTypeCompatibility=80;MARS Connection=True;providerzI%(provider)s; %(security)s; Initial Catalog=%(name)s;Data Source=%(host)swin32zz-PCxxxz25.223.161.22212345678zPostgreSQL Unicode zDriver={z	};Server=z
;Database=z;uid=z;pwd=;yyyzMicrosoft.ACE.OLEDB.12.0zMicrosoft.Jet.OLEDB.4.0z	Provider=z;Data Source=zUsing Connection String like=z	Keywords=c                   L    e Zd ZeZefZeZd Z	d Z
d Zd Zd Zd Zd Zd Zd	S )
test_adodbapic                 F    t           j                            | |           d S N)dbapi20DatabaseAPI20Test__init__)selfargs     qC:\Users\Administrator\AppData\Local\Temp\2\pip-target-b0z114gj\lib\python\adodbapi/test/test_adodbapi_dbapi20.pyr   ztest_adodbapi.__init__X   s!    !**455555    c                 \    |                                                      d          d         S )N.)idsplitr   s    r   getTestMethodNameztest_adodbapi.getTestMethodName[   s!    wwyys##B''r    c                    t           j                            |            |                                 dk    r|                                 }|j        }|dk    rd}nd}|                                }	 |                    |           |                                 n#  Y nxY w|	                                 |	                                 d| _
        d S d S )Ntest_callproczMS Jetz
                    create procedure templower
                        @theData varchar(50)
                    as
                        select lower(@theData)
                z
                    create procedure templower
                        (theData varchar(50))
                    as
                        select lower(theData);
                	templower)r   r   setUpr'   _connect	dbms_namecursorexecutecommitclose
lower_func)r   conenginesqlcurs        r   r+   ztest_adodbapi.setUp^   s     	!''---!!##66--//C]F!! **,,CC   

IIKKKIIKKK)DOOO5 76s   3)B B!c                 (   |                                  dk    rZ|                                 }|                                }	 |                    d           n#  Y nxY w|                                 t
          j                            |            d S )Nr)   zdrop procedure templower)r'   r,   r.   r/   r0   r   r   tearDown)r   r3   r6   s      r   r8   ztest_adodbapi.tearDown~   s    !!##66--//C**,,C67777JJLLL!**400000s   A Ac                 V    d| j         d| j         d}|                    |           dS )z)Should create a procedure called deletemeza
            create procedure deleteme as
            begin
                select count(*) from z'booze
                select name from zbooze
            end
        N)table_prefixr/   )r   r6   r5   s      r   help_nextset_setUpz test_adodbapi.help_nextset_setUp   s@    ` 	
 	Cr    c                 B    	 |                     d           dS #  Y dS xY w)z*If cleaning up is needed after nextSetTestzdrop procedure deletemeN)r/   )r   r6   s     r   help_nextset_tearDownz#test_adodbapi.help_nextset_tearDown   s0    	KK122222	DDs    c                 X   |                                  }	 |                                }| j        g|                                 z   }|D ]}|                    |           |                     |           |                    d           |                                }|d         dk    sJ |                                sJ |	                                }t          |          t          | j                  k    sJ |                                }|
J d            	 	 |                     |           |                                 d S # |                                 w xY w# 	 |                     |           |                                 w # |                                 w xY wxY w)Ndeletemer      z'No more return sets, should return None)r,   r.   ddl1	_populater/   r;   callprocfetchonenextsetfetchalllensamplesr=   r1   )r   r3   r6   stmtsr5   numberofrowsnamesss           r   test_nextsetztest_adodbapi.test_nextset   s   mmoo	**,,CYK$.."2"22E ! !C    ##C(((LL$$$<<>>L?a'''';;==  =LLNNEu::T\!2!22222A99G9999**3///				**3///				s0   DE$  E E!$F)&F;F)F&&F)c                     d S r    r&   s    r   test_setoutputsizez test_adodbapi.test_setoutputsize   s    r    N)__name__
__module____qualname__dbdriverconnStrconnect_argsconn_kwsconnect_kw_argsr   r'   r+   r8   r;   r=   rM   rP   rO   r    r   r   r   S   s        F:LO6 6 6( ( (* * *@	1 	1 	1      2    r    r   __main__)+printplatformsysunittestr   setuptestframeworkmaketemp
testfolderargvmakeadopackagepthremovefind_ado_pathpathinsertgetcleanupfunctioncleanupadodbapiadodbapi.is64bitis64bitrT   verboseversion__version__noderX   r   instancerV   _computername_databasename	_username	_password_driver	_providerPythonrU   makemdbtestmdbr   r   rQ   mainrO   r    r   <module>r}      s'   T U U U 2 3 3 3  



      ((**
#(
+

+J
7
7CHOOK    
*

*
,
,CchHOOAs
/

/
1
1  " " " " " "#(BK h    !44 5 5 5x}   " ",	 <!' 2H_HV I 	  V<7tv~~	U]]$MMII"GI						GG 
U]]w~ ++*( (44GG/5vvww?G /g// 0 0 0 (   f f f f fG- f f fR zHMOOOGJ r    