$ i< ededddlZddlZddlZddlZddlZejZdejvr+ej eZ ej dnej Z e ej vrej de ejZddlZddlmZeZdejvr dej_eejedejz eejZn #d ZYnxYwejZiZd Zd Zd ed <ded<ded<ded<edeged<need<ded<dZeredkrnYedkr!dZ d Z!dZ"dZ#dZ$dZ%e%de$d e d!e!d"e"d#e#d$ Zn2ed%kr,ej&rd&Z'nd'Z'ej(eZ)d(e'd)e)Zed*eed+eGd,d-ej*Z+e,d.krej-eeddSdS)/zLThis module depends on the dbapi20 compliance tests created by Stuart Bishopz*(see db-sig mailing list history for info)Nz --packagez --verbosezTested with dbapi20 %sFztestsql.2txt.us,1430z %s\SQLEXPRESSadotestname adotestuseruser Sq1234567passwordsecuritymacro_auto_securityhost macro_getnodezBProvider=MSOLEDBSQL;DataTypeCompatibility=80;MARS Connection=True;providerzI%(provider)s; %(security)s; Initial Catalog=%(name)s;Data Source=%(host)szz-PCxxxz25.223.161.22212345678zPostgreSQL UnicodezDriver={z };Server=z ;Database=z;uid=z;pwd=;yyyzMicrosoft.ACE.OLEDB.12.0zMicrosoft.Jet.OLEDB.4.0z Provider=z ;Data Source=zUsing Connection String like=z Keywords=cLeZdZeZefZeZdZ dZ dZ dZ dZ dZdZdZd S) test_adodbapicFtj||dSN)dbapi20DatabaseAPI20Test__init__)selfargs C:\Users\Dell Inspiron 16\Desktop\tws\AgrotaPowerBi\back-agrota-powerbi\mcp-client-agrota\venv\Lib\site-packages\adodbapi/test/test_adodbapi_dbapi20.pyrztest_adodbapi.__init__]s!!**455555c\|ddS)N.)idsplitrs rgetTestMethodNameztest_adodbapi.getTestMethodName`s!wwyys##B''rctj||dkr|}|j}|dkrd}nd}|} |||n#YnxYw| | d|_ dSdS)N test_callproczMS Jetz create procedure templower @theData varchar(50) as select lower(@theData) z create procedure templower (theData varchar(50)) as select lower(theData); templower) rrsetUpr&_connect dbms_namecursorexecutecommitclose lower_func)rconenginesqlcurs rr*ztest_adodbapi.setUpcs !''---  ! ! # # 6 6--//C]F!! **,,C  C      IIKKK IIKKK)DOOO5 7 6s 3)BB!c(|dkrZ|}|} |dn#YnxYw|t j|dS)Nr(zdrop procedure templower)r&r+r-r.r/rrtearDown)rr2r5s rr7ztest_adodbapi.tearDowns  ! ! # # 6 6--//C**,,C  67777  JJLLL!**400000s AAcVd|jd|jd}||dS)z)Should create a procedure called deletemeza create procedure deleteme as begin select count(*) from z'booze select name from zbooze end N) table_prefixr.)rr5r4s rhelp_nextset_setUpz test_adodbapi.help_nextset_setUps@`           CrcB |ddS#YdSxYw)z*If cleaning up is needed after nextSetTestzdrop procedure deletemeN)r.)rr5s rhelp_nextset_tearDownz#test_adodbapi.help_nextset_tearDowns0  KK1 2 2 2 2 2  DDscX|} |}|jg|z}|D]}|||||d|}|ddksJ|sJ| }t|t|j ksJ|}| Jd | || dS#| wxYw# | || w#| wxYwxYw)Ndeletemerz'No more return sets, should return None)r+r-ddl1 _populater.r:callprocfetchonenextsetfetchalllensamplesr<r0)rr2r5stmtsr4 numberofrowsnamesss r test_nextsetztest_adodbapi.test_nextsetsmmoo **,,CYK$.."2"22E ! ! C     # #C ( ( ( LL $ $ $<<>>L?a'''';;== =LLNNEu::T\!2!22222 A99G9999 **3///   **3///  s0DE$ E E!$F)&F;F)F&&F)cdSrr%s rtest_setoutputsizez test_adodbapi.test_setoutputsizes rN)__name__ __module__ __qualname__dbdriverconnStr connect_argsconn_kwsconnect_kw_argsrr&r*r7r:r<rLrOrNrrrrXs F:LO666(((***@ 1 1 1   2     rr__main__).printplatformsysunittestrsetuptestframeworkmaketemp testfolderargvmakeadopackagepthremove find_ado_pathpathinsertgetcleanupfunctioncleanupadodbapiadodbapi.is64bitis64bitrSverboseversion __version__boolgetwindowsversion onWindowsnoderWr instancerU _computername _databasename _username _password_driver _providerPythonrTmakemdbtestmdbrrrPmainrNrrrsWTUUU2333  (  ( * * #( +  +J 7 7CHOOK    *  * , ,CchHOOAs /  / 1 1"""""" #(BKh!44555*S*,,--IIIIIx}   "",