o ª›h<ã@sedƒedƒddlZddlZddlZddlZddlZe ¡Zdejvr1e  e¡Z ej  d¡ne  ¡Z e ej vrAej  de ¡e ¡ZddlZddlmZeZdejvrZdej_eejƒedejƒzee ¡ƒZWnd ZYe ¡ZiZd Zd Zd ed <ded<ded<ded<eduršdeged<need<ded<dZer«edkr«n3edkrÆdZ d Z!dZ"dZ#dZ$dZ%de%e$e e!e"e#fZned krÞe &¡rÑd!Z'nd"Z'e (e¡Z)d#e'e)fZed$e›ƒed%e›ƒGd&d'„d'ej*ƒZ+e,d(kre -¡eedƒdSdS))zLThis module depends on the dbapi20 compliance tests created by Stuart Bishopz*(see db-sig mailing list history for info)éNz --packageéz --verboseézTested with dbapi20 %sFztestsql.2txt.us,1430z %s\SQLEXPRESSZadotestÚnameZ adotestuserÚuserZ Sq1234567ÚpasswordÚsecurityZmacro_auto_securityÚhostZ macro_getnodezBProvider=MSOLEDBSQL;DataTypeCompatibility=80;MARS Connection=True;ÚproviderzI%(provider)s; %(security)s; Initial Catalog=%(name)s;Data Source=%(host)szz-PCZxxxz25.223.161.222Z12345678zPostgreSQL UnicodeÚz2%sDriver={%s};Server=%s;Database=%s;uid=%s;pwd=%s;ZyyyzMicrosoft.ACE.OLEDB.12.0zMicrosoft.Jet.OLEDB.4.0zProvider=%s;Data Source=%szUsing Connection String like=z Keywords=c@sZeZdZeZefZeZdd„Z dd„Z dd„Z dd„Z d d „Z d d „Zd d„Zdd„ZdS)Ú test_adodbapicCstj ||¡dS©N)Údbapi20ÚDatabaseAPI20TestÚ__init__)ÚselfÚarg©rúYc:\Users\shubh\Videos\agent\nova\Lib\site-packages\adodbapi/test/test_adodbapi_dbapi20.pyr]óztest_adodbapi.__init__cCs| ¡ d¡dS)NÚ.éÿÿÿÿ)ÚidÚsplit©rrrrÚgetTestMethodName`rztest_adodbapi.getTestMethodNamecCs~tj |¡| ¡dkr=| ¡}|j}|dkrd}nd}| ¡}z | |¡| ¡WnY|  ¡|  ¡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); Z templower) r rÚsetUprÚ_connectZ dbms_nameÚcursorÚexecuteÚcommitÚcloseZ lower_func)rÚconZengineÚsqlÚcurrrrrcs"     æztest_adodbapi.setUpcCsL| ¡dkr| ¡}| ¡}z| d¡WnY| ¡tj |¡dS)Nrzdrop procedure templower)rrrrr r rÚtearDown)rr"r$rrrr%ƒs ztest_adodbapi.tearDowncCs d|j|jf}| |¡dS)z)Should create a procedure called deletemezª create procedure deleteme as begin select count(*) from %sbooze select name from %sbooze end N)Z table_prefixr)rr$r#rrrÚhelp_nextset_setUpŽsþú z test_adodbapi.help_nextset_setUpcCsz| d¡WdSYdS)z*If cleaning up is needed after nextSetTestzdrop procedure deletemeN)r)rr$rrrÚhelp_nextset_tearDownsz#test_adodbapi.help_nextset_tearDowncCsì| ¡}z`| ¡}|jg| ¡}|D]}| |¡q| |¡| d¡| ¡}|ddks1J‚| ¡s7J‚|  ¡}t |ƒt |j ƒksFJ‚| ¡}|dusRJdƒ‚Wz |  |¡W|  ¡dS|  ¡wz |  |¡W|  ¡w|  ¡w)NZdeletemeréz'No more return sets, should return None)rrZddl1Z _populaterr&ZcallprocZfetchoneZnextsetZfetchallÚlenZsamplesr'r!)rr"r$Zstmtsr#Z numberofrowsÚnamesÚsrrrÚ test_nextset¤s*     ý ztest_adodbapi.test_nextsetcCsdSr rrrrrÚtest_setoutputsize½sz test_adodbapi.test_setoutputsizeN)Ú__name__Ú __module__Ú __qualname__ÚdbÚdriverÚconnStrZ connect_argsÚconn_kwsZconnect_kw_argsrrrr%r&r'r,r-rrrrr Xs   r Ú__main__).ÚprintÚplatformÚsysZunittestr ZsetuptestframeworkZmaketempZ testfolderÚargvZmakeadopackageÚpthÚremoveZ find_ado_pathÚpathÚinsertZgetcleanupfunctionÚcleanupZadodbapiZadodbapi.is64bitZis64bitr1ÚverboseÚversionÚ __version__ÚboolÚgetwindowsversionZ onWindowsÚnoder4rÚinstancer3Z _computernameZ _databasenameZ _usernameZ _passwordZ_driverÚ _providerÚPythonr2ZmakemdbZtestmdbrr r.ÚmainrrrrÚsŒ      ÿ ú   iþ