hSrSSKrSSKrSSKrSSKrSSKrSSKrSSKrSSKr SSK r SSK r SSK J r Sr"SS\R 5r"SS\5r"SS \5r"S S \5r"S S \5r"SS\R 5r"SS\5r"SS\5r\R2R5\S5/r\ R8(a+\R;\R2R5\S55 \ R<(a+\R;\R2R5\S55 \ R>(a+\R;\R2R5\S55 \ R@(a+\R;\R2R5\S55 \ RB(a+\R;\R2R5\S55 "SS5r"\RF"\5r$\%S:Xa\RL"\$5r'\""5 \ RPr)\*"\5 \*"S\)<35 \)r(\RV"5RY\'5 \ R8(av\RL"\$5r'\RZ"5\ Rl(\*"S5 \*"\ RRP5 \RV"5RY\'5 SSS5 gg!,(df  g=f)z'Unit tests version 2.6.1.0 for adodbapiNcSR[S5Vs/sH'n[R"[R 5PM) sn5$s snf)N )joinrangerandomchoicestring ascii_letters)lengthns mC:\Users\julio\OneDrive\Documentos\Trabajo\Ideas Frescas\venv\Lib\site-packages\adodbapi/test/adodbapitest.py randomstringr(s6 77rKAFMM&"6"67K LLKs.Ac*\rSrSrSrSrSrSrSrSr Sr S r S r S r S rS rS1SjrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSr S r!S!r"S"r#S#r$S$r%S%r&S&r'S'r(S(r)S)r*S*r+S+r,S,r-S-r.S.r/S/r0S0r1g)2 CommonDBTests,zdSelf contained super-simple tests in easy syntax, should work on everything between mySQL and OraclecSUlg)Nunknownengineselfs rsetUpCommonDBTests.setUp/s  cUR$Nrrs r getEngineCommonDBTests.getEngine2s {{rc[erNotImplementedErrorrs r getConnectionCommonDBTests.getConnection5s!!rc>UR5R5$r)r#cursorrs r getCursorCommonDBTests.getCursor8s!!#**,,rc\UR5nURRS:Xdeg)NCursor)r' __class____name__rcrsrs rtestConnectionCommonDBTests.testConnection;s&~~~~&&(222rcUR5nSnX!lUR5nURU:XdS5eg)NcgN connectionr& errorclass errorvalues r8CommonDBTests.testErrorHandlerInherits..Asrz5Error handler on crsr should be same as on connection)r# errorhandlerr&)rconn mycallabler.s rtestErrorHandlerInherits&CommonDBTests.testErrorHandlerInherits?sD!!#I &{{}  J. C .rcPUR5nURSS2 UR5 UR5 g! [ UR5S:Xde[ URS5S:XdeURSS[ R :Xdeg=f)Nr4r)r#messagesclosecommitlenapiProgrammingErrorrr=s r!testDefaultErrorHandlerConnection/CommonDBTests.testDefaultErrorHandlerConnectionHs!!# MM!  ? JJL KKM ?t}}%* **t}}Q'(A- --==#A&#*>*>> >>s AA!B%cJSnUR5nXlUR5 UR5 [ UR 5S:XdeSUlUR5 UR5 [ UR 5S:dS5eg! N%=f)Ncgr3r5r6s rr:=CommonDBTests.testOwnErrorHandlerConnection..UqrrJSetting errorhandler to none should bring back the standard error handler)r#r<rDrErFrC)rr>r=s rtestOwnErrorHandlerConnection+CommonDBTests.testOwnErrorHandlerConnectionSs @ !!#&  4==!Q&&&   JJL KKM4==!A% X %  s  BB"cNUR5R5nURSS2 URS5 g! [ UR5S:Xde[ URS5S:XdeURSS[ R :Xdeg=f)NSELECT abbtytddrf FROM dasdasdr4rrB)r#r&rCexecuterFrG DatabaseErrorr-s rtestDefaultErrorHandlerCursor+CommonDBTests.testDefaultErrorHandlerCursorhs!!#**, MM!  < LL9 : <t}}%* **t}}Q'(A- --==#A&#*;*;; ;;s AA!B$c*SnUR5R5nXlURS5 [ UR 5S:XdeSUlURS5 [ UR 5S:dS5eg! N%=f)Ncgr3r5r6s rr:9CommonDBTests.testOwnErrorHandlerCursor..trOrrTrrP)r#r&r<rUrFrC)rr>r.s rtestOwnErrorHandlerCursor'CommonDBTests.testOwnErrorHandlerCursorrs @ !!#**,& 564==!Q&&&   LL9 :4==!A% X %  s BBc^SnU"S5S:XdeUR5 UR5mUR[U4SjS/5 [R"[ R 5TlTR5nS[R-nURU5 URS[R-5 URS[R-5 UTR [ R'URS [R-5 UR5nUS nURUS S5 US nURUS S 5 URUS S 5 SnU"S5S:XdeXdRS 'URUS S 5 URUS S5 T?UR5 g! N=f!T?O! O=fUR5 f=f)Nc US-$)NrBr5 aStringFields rr::CommonDBTests.testUserDefinedConversions..s q8Hrgabba gabbagabbac">TRU$r)variantConversions)xr=s rr:rbs8O8OPQ8RrrBzDCREATE TABLE xx_%s (fldData VARCHAR(100) NOT NULL, fld2 VARCHAR(20))z7INSERT INTO xx_%s(fldData,fld2) VALUES('gabba','booga')z2INSERT INTO xx_%s(fldData,fld2) VALUES('hey','yo')z/SELECT fldData,fld2 FROM xx_%s ORDER BY fldDatarr4heyheyyoyoc"UR5$r)upperr`s rr:rbs <3E3E3GrupThisUPTHISYO)helpForceDropOnTblTempr# assertRaisesAttributeErrorcopyrGrfr&configtmprUadoStringTypesfetchall assertEqual convertershelpRollbackTblTemp)rduplicatingConverterr.tabdefrowsrowupcaseConverterr=s @rtestUserDefinedConversions(CommonDBTests.testUserDefinedConversionss. '#H '0L@ @@  ' ' )%%'D   n.RUVTW X&*ii0F0F&GD #;;=DV**  LL LLIFJJV  LLDvzzQ ;OD # #C$6$6 7 LLJVZZW X==?Dq'C   SV\ 2q'C   SVX .   SVV ,GO"8,8 88"1OOA    SVX .   SVT * +  $ $ &  +   $ $ &s0GG-G&&G*-H /G21H 2G64H Nc  UR5 UR5nUR5nS[R-U-S-n UR U 5 UR S[R-5 UR S[R-5 UR 5n URU SS5 U SS:XdeURSn U SS;dSU S<S S <S 35eUS :XaDU S[R:Xd+SU S<S [RR<S 35eGOtUS :XaDU S[R:Xd+SU S<S [RR<S 35eGO*US:XaCU S[R:Xd+SU S<S [RR<S 35eOUS:XaCU S[R:Xd+SU S<S [RR<S 35eOUS:XaCU S[R:Xd+SU S<S [RR<S 35eOOUS:XaCU S[R :Xd+SU S<S [R R<S 35eO["eU/n U(aU R%U5 ['U 5n Sn U GHnU S- n UR S[R-X45 UR S[R-U /5 UR 5n U(aU[+UVs/sHn[-U5PM sn5n[/U SU5(dS[-U S5<SU<35eOA[/U S[-U55(d$S[-U S5<S[-U5<35eU(a\US:XaV[0R2R5U S5n[0R2R5U5nURUU5 GMbU(a@[7U5n[7U S5n[9UU- 5U- S:dSU SU4-5eGMU(a'SnUR;U SU;SU S<SU35 GMURU SUSU S<SU<S 35 GM g! UR)5 e=fs snf)Nzb CREATE TABLE xx_%s ( fldId integer NOT NULL, fldData z) z$INSERT INTO xx_%s (fldId) VALUES (1)zSELECT fldId,fldData FROM xx_%sr4r)fldDataflddatazwas "z " expected "r"STRINGNUMBERBINARYDATETIMEROWIDUUIDz.INSERT INTO xx_%s (fldId,fldData) VALUES (?,?)z'SELECT fldData FROM xx_%s WHERE ?=fldIDz result type "z" must be one of z" must be instance of gh㈵>z-Values not almost equal recvd=%s, expected=%fFzValue "z " not in zValues are not equal recvd="z ", expected=")ror#r&rsrtrUfetchonerw descriptionrGrvaluesrrrrOTHERr"extendsetprintADOerrorstupletype isinstanceadodbapi dateconverterDateObjectToIsoFormatStringfloatabs assertTrue)rsqlDataTypeStringDBAPIDataTypeStringpyDatapyDataInputAlternativescompareAlmostEqualallowedReturnValuesr=r.r{rs descTupleinputsfldIdinParamaRV allowedTypesiso1iso2svoks rhelpTestDataTypeCommonDBTests.helpTestDataTypes ##%!!#{{} jj         V ;fjjHI 6CD ]]_ A%!uzz$$Q' |55 aL 8  5 ( *Q<3::- !  !!0 -!H ,Q<3::- !  !!0 -!H ,Q<3::- !  !!0 -!J .Q<3<</ !  ##2 /!G +Q<399, !    / ,!F *Q<399, !    / , & % " MM1 2VG QJE  DvzzQ$ LL9FJJF B"$;N%O;NCd3i;N%OP !"Q%66<@AKV6""Q%f66RU V 6"&9Z&G--II"Q%P--II&Q  t,#&M"Q%L1q5zA~/Cr!uajP/'BOO1!44!"Q%)4G3HI $$1a5&*] ##% &Ps,$S!S7 !S4cLURSSSSS9 URSSSSS9 g)Nrealr皙 @TrrgdFGrrs rtestDataTypeFloatCommonDBTests.testDataTypeFloat9s0 fhN gxTRrc JURSSSSS[R"S5/S9 URSSSSS[R"S5/S9 URSSS S S [R"S 5/S9 UR5S :XaURSSSS/S9 gg)Nz decimal(18,2)rrz3.45z3,45rz numeric(18,2)z decimal(20,2)lG#xoW1z444444444444444444.00z444444444444444444,00444444444444444444MSSQLuniqueidentifierrz&{71A4F49E-39F3-42B1-A41E-48FF154996E6})rdecimalDecimalrrs rtestDataTypeDecmal CommonDBTests.testDataTypeDecmal=s    !'1H I     !'1H I     '' 45!   >> w &  ! !"8%M$N "  'rc UR5S:Xa(URSS[R"S55 gUR5S:Xa>URSS[R"S5SS[R"S5/S 9 gURS S[R"S 55 URSS[R"S55 g) NMySQLz DECIMAL(20,4)rz-922337203685477.5808 PostgreSQLmoneyTg-C6 )rr smallmoneyz 214748.02)rrrrrs rtestDataTypeMoneyCommonDBTests.testDataTypeMoney\s >> w &  ! !7??;R+S ^^  -  ! ! 78#')OO$;<% "   ! !,'//+:V W  ! !7??3J#K rc<UR5S:waURSSS5 URSSS5 UR5S;aURSSS 5 UR5S ;aURS SS S S /S 9 URSSS5 g)Nrtinyintrssmallinti)ACCESSrbitr4)rrbigintl^erintirrrs rtestDataTypeIntCommonDBTests.testDataTypeIntrs >> | +  ! !)Xs ; j(F; >> #; ;  ! !x  >> 6 6  ! !%/$< "  eXz:rc>SHnURUSS/SQS9 M g)N)zchar(6)znchar(6)rspam )spamrrrrr)r sqlDataTypes rtestDataTypeCharCommonDBTests.testDataTypeChars+2K  ! !$H " 3rcUR5S:XaSS/nOUR5S:Xa/SQnO/SQnUHnURUSSS/5 M g) Nr varchar(10)textr)rrzcharacter varying)rz nvarchar(10)rntextrrr)r stringKindsrs rtestDataTypeVarChar!CommonDBTests.testDataTypeVarCharsX >> w &(&1K ^^  -FKK'K  ! !+x& J'rc UR5S:XaSnOSnURUS[R"SSS5SS 9 UR5S ;a(URS S[R"SSS5SS 9 [S :waAUR5S ;a,URUS[R "SSSS SS5SS 9 ggg)Nr timestampdatetimer Tr)rr smalldatetime pythontime r4)rrrDatetag Timestamp)rdts rtestDataTypeDateCommonDBTests.testDataTypeDates >> | +BB   HMM$B7D   >> #: :  ! ! dB+#' "  , 4>>#3< $   ! !""4RR;#' "  $ rcSnU[R"U5[U5/nUR5S:Xa'UR SS[R"U5US9 gUR SS[R"U5US9 UR SS[R"U5US9 UR5S:wa'UR S S[R"U5US9 gg) Ns@*rbytearrz binary(5)zvarbinary(100)rimage)rBinarybytesrr)rbinfldarvs rtestDataTypeBinary CommonDBTests.testDataTypeBinarys%xv.f > >> | +  ! !8??6#:PS "   ! !Xxv'>TW "   ! ! '$' "  ~~7*%%Xxv'>TW&+rc$UR5 gr)rors rry!CommonDBTests.helpRollbackTblTemps ##%rcUR5nUR5nURS[R-5 UR (dUR 5 SSS5 g! N =f!,(df  g=f)NzDROP TABLE xx_%s)r#r&rUrsrt autocommitrE)rr=r.s rro$CommonDBTests.helpForceDropOnTblTemps_!!# [[]d  /&**<=KKM ]   ]sA6AA//A31A66 Bc0S[R-nURU5 [ S5H'nURS[RU4-5 M) g![Ra$ UR 5 URU5 Nnf=f)Nz\ CREATE TABLE xx_%s ( fldData INTEGER ) z'INSERT INTO xx_%s (fldData) VALUES (%i))rsrtrUrGrVror)rr.r{is rhelpCreateAndPopulateTableTemp,CommonDBTests.helpCreateAndPopulateTableTemps  jj    ! LL qA LLBfjjRS_T U   !  ' ' ) LL  !sA5BBc(UR5nURU5 URS[R-5 UR 5n[ U5S:XdeSnUSSHnUSU:XdeUS- nM UR5 g)NSELECT fldData FROM xx_%srrr4)r'rrUrsrtrvrFry)rr.rrr}s r testFetchAllCommonDBTests.testFetchAlls~~ ++D1 06::=> ]]_2w!|| a8Cq6Q; ; FA   "rc>UR5nURU5 URS[R-5 UR UR 5 UR5n[U5S:XdeUSSS:XdeUR5 g)NrrrBr) r'rpreparersrtrUcommandrvrFryrr.rs rtestPreparedStatement#CommonDBTests.testPreparedStatements}~~ ++D1 06::=> T\\" ]]_2w!||!uQx1}}   "rc*UR5nURU5 URS5 URS[R -5 UR 5n[U5S:XdeUSSS:XdeUR5 g)NzSELECT * FROM nowhererrrBr) r'rrrUrsrtrvrFryr s rtestWrongPreparedStatement(CommonDBTests.testWrongPreparedStatements~~~ ++D1 ,- '&** 4 ]]_2w!||!uQx1}}   "rcUR5nURU5 URS[R-5 [ U5Hup#USU:XaMe UR 5 g)Nrr)r'rrUrsrt enumeratery)rr.rr}s r testIteratorCommonDBTests.testIteratorsf~~ ++D1 06::=>  FAq6Q; ;    "rcUR5nURU5 SS/nURS[R-U5 UR S:Xa[ UR5S-5 OURUR S5 URS[R-5 UR5n[U5S:XdeUR5 g) N)o)z&INSERT INTO xx_%s (fldData) VALUES (?)z7 Provider does not support rowcount (on .executemany())rBr ) r'r executemanyrsrtrowcountprintrrwrUrvrFry)rr. seq_of_valuesrs rtestExecuteManyCommonDBTests.testExecuteManys~~ ++D1(   4vzz A=  ==B   KL    T]]A . 06::=> ]]_2w"}}   "rcUR5nURU5 URS[R-5 UR S:XaOUR UR S5 UR5 g)Nrrr)r'rrUrsrtrrwryr-s r testRowCountCommonDBTests.testRowCount+sa~~ ++D1 06::=> ==B     T]]A .   "rc<UR5nURU5 URS[R-5 UR S:Xa[ UR5S-5 OURUR S5 UR5 g)Nz$DELETE FROM xx_%s WHERE fldData >= 5rz/ Provider does not support rowcount (on DELETE)) r'rrUrsrtrrrrwryr-s rtestRowCountNoRecordset%CommonDBTests.testRowCountNoRecordset6ss~~ ++D1 ;fjjHI ==B  $.."%VV W   T]]A .   "rcvUR5nURU5 URS[R-5 UR S5n[ U5S:XdeUR S5n[ U5S:XdeUR S5n[ U5S:XdeUR5 g)Nrrr4)r'rrUrsrt fetchmanyrFryr s r testFetchManyCommonDBTests.testFetchMany@s~~ ++D1 06::=> ^^A 2w!|| ^^A 2w!|| ^^A 2w!||   "rcUR5nURU5 URS[R-5 UR 5n[ U5S:XdeSUlUR 5n[ U5S:XdeUR 5n[ U5S:XdeUR 5n[ U5S:XdeUR5 g)Nrr4r#r) r'rrUrsrtr(rF arraysizeryr s rtestFetchManyWithArraySize(CommonDBTests.testFetchManyWithArraySizeLs~~ ++D1 06::=> ^^ 2w!|| ^^ 2w!|| ^^ 2w!|| ^^ 2w!||   "rcUR5nUR5 UR[RUR S05 g)Nznot a valid connect string)r#rDrprGrVdbrIs rtestErrorConnectCommonDBTests.testErrorConnect[s9!!#  #++TWW6RTVWrc UR5 UR5nUR5nS[R-nUR U5 SS/nSnUGH.nUS- nUR S[R-XVSUSUS45 UR S[R-U/5 UR5n[[U55H!nXxXh:XaMS Xx<S Xh<S 35e [U5U:XdS U<S U<S 35e[USS 5n [USS5n X:XdS U <S U <S 35eUS US:XdeURUS:XdeURUS:XaGM/e UR S[R-5 UR5n U SSS:XdeU SSS:XdeU SSS:XdeU SS:XdeU SS:XdeU SS:Xde[S5H&n [S5HnXUXU4:XaMe M( g! UR 5 e=f)Nz CREATE TABLE xx_%s ( fldId integer NOT NULL, fldTwo integer, fldThree integer, fldFour integer) )rBrr#)fghr4zBINSERT INTO xx_%s (fldId,fldTwo,fldThree,fldFour) VALUES (?,?,?,?)rrBz7SELECT fldTwo,fldThree,fldFour FROM xx_%s WHERE ?=fldIDreturned value:"" != test value:"rrfldTwoz)select fldThree,fldFour,fldTwo from xx_%sr5r#fldFourr6)rrr)rr9)r4rBr4)ror#r&rsrtrUrrrrFrfldThreer:rv) rr=r.r{rrrrecjslice1slice2recsrs rtestRowIteratorCommonDBTests.testRowIterator`s ##%!!#{{} jj   V_-G QJE  Xjj!AJ GAJ? LLIFJJV --/C3w<(v+@C S+) :( "3'):7+QG (3s8_F71Q<(F# "6*,=fZqI #x=GAJ. ..<<71:- --;;'!*, ,,EJ @6::MN}}AwqzS   AwqzQAwy!S(((DzQK A%%%DzS   qA1XwqzTQ$Z///K ##%s '/IIc UR5 UR5nSUlUR5nS[R -nUR U5 /SQnSnUHnUS- nS[R -S-nUR XuU45 UR S[R -S -U/5 UR5nURUS US US <S U<S 35 URUSS5 M S[R -S-n Sn UR X5 SUR;dSS<SUR<S 35eURU :XdSU <SUR<S 35eURURU 5 UR S[R -5 UR5nURUS S5 g! UR5 e=f)Nformat CREATE TABLE xx_%s ( fldId integer NOT NULL, fldData varchar(10), fldConst varchar(30)) onetwothreerBr4INSERT INTO xx_zE (fldId,fldConst,fldData) VALUES (%s,'thi%s :may cause? trouble', %s)!SELECT fldData, fldConst FROM xx_z WHERE %s=fldIDrr7r8rzthi%s :may cause? troublezinsert into xx_z) (fldId,fldData) VALUES (%s,'four%sfive'))z(?,z expected:"z" in "z " but found "z(SELECT fldData FROM xx_%s WHERE fldID=20z four%sfive) ror# paramstyler&rsrtrUrrrwqueryr  parameters) rr=r.r{rrrsqlr<selparamss rtestFormatParamstyle"CommonDBTests.testFormatParamstyles ##%!!#"{{}  jj    V(G QJE!**YZ    S'"23 LL3fjj@CTT --/C   As: ##%!!##{{}  jj    V(G QJE  %jj!\]$ 3G LL3fjj@CSS --/C   AcUR5nUR5nURR(aS5eUR U5 URR 5 UR S[R-5 S[R-nUR U5 UR5n[U5S:XdeURR5 UR U5 UR5bS5eUR S[R-5 UR5n[U5S:XdS5eUR5 g) NzUnexpected beginning condition'INSERT INTO xx_%s (fldData) VALUES(100)+SELECT fldData FROM xx_%s WHERE fldData=100r4z?cursor.fetchone should return None if a query retrieves no rowsSELECT fldData from xx_%srz,the original records should still be present)r#r&r7rrrErUrsrtrvrFr=rollbackrry)rr=r. selectSqlrs r testRollBackCommonDBTests.testRollBacks!!#{{}??--O/OO- ++D1   >KLAFJJN  Y ]]_2w!||  Y}}& M & 06::=> ]]_2w!|KKK|   "rcUR5nUR(aS5eUR5nUR U5 UR S[ R-5 UR5 S[ R-nUR U5 UR5n[U5S:XdeUR5 UR5 UR5nUR5nUR5nUR U5 UR5n[U5S:XdeUSSS:XdeSSS5 UR5 g![a gf=f!,(df  N/=f)Nzdefault should be manual commitrurvr4rd)getAnotherConnectionr"rr&rrUrsrtrErvrFrDr#r'ry)rcon2r.ryrr=s r testCommitCommonDBTests.testCommits8 ,,.D??E$EE"{{} ++D1 >KL AFJJN  Y ]]_2w!||  !!#~~ [[]d LL #Br7a< <a58s? "?    "-#   "]sE-AE=- E:9E:= F cUR5nUR(aS5eUR5nUR U5 UR S[ R-5 S[ R-nUR U5 UR5n[U5S:XdeUR5 UR5 UR5nUR U5 UR5nUb SU<35eUR5 g![a gf=f![Ra SnNGf=f)Nzunexpected beginning conditionrurvr4zEcursor.fetchone should return None if a query retrieves no rows. Got )r~r"rr&rrUrsrtrvrFrDr'rrGrVry)rrr.ryrr}s rtestAutoRollbackCommonDBTests.testAutoRollbacks) ,,.D??D$DD"{{} ++D1 >KLAFJJN  Y ]]_2w!||  ~~  LL --/C{ STWSZ [ {   "/#   $   C s#D##!D3# D0/D03E  E cURSS05nUR5nURU5 UR S[ R -5 UR5 UR5nS[ R -nUR U5 UR5n[U5S:XdS5eSSS5 UR5 UR5 g![a gf=f!,(df  N?=f)NrTrurwr#all records should still be present) r~r"r&rrUrsrtrDr'rvrFry)rac_connr.ryrs rtestAutoCommitCommonDBTests.testAutoCommits //t0DEG~~ ++D1 >KL ^^ 3fjj@I LL Br7b= G"G G=      "#     sC-8A C=- C:9C:= D cDUR5nSUlUR5nUR U5 UR S[ R-5 UR5 UR5nUR5 UR5nS[ R-nUR U5 UR5n[U5S:XdS5eSSS5 UR5 g![a gf=f!,(df  N/=f)NTrurwrr)r~r"rr&rrUrsrtrDr#r'rvrFry)rrr.r=ryrs rtestSwitchedAutoCommit$CommonDBTests.testSwitchedAutoCommits //1G"~~ ++D1 >KL !!#  ^^ 3fjj@I LL Br7b= G"G G=    "!#    sDA D D D Dc"SS[5n"SS[5n"SS[5nU"[S55nU"[R "SS 55nU"[R"55nUR 5 UR5nUR5nS [R-n URU 5 URS [R-XEU45 UR5 UR5nUR5nS [R-n URU 5 UR5n URU R U5 URU R"U5 UR%U R&U5 SSS5 UR)5 g!,(df  N=f) Nc\rSrSrSrg);CommonDBTests.testExtendedTypeHandling..XtendStringir5Nr, __module__ __qualname____firstlineno____static_attributes__r5rr XtendStringr rrc\rSrSrSrg)8CommonDBTests.testExtendedTypeHandling..XtendIntir5Nrr5rrXtendIntrrrrc\rSrSrSrg):CommonDBTests.testExtendedTypeHandling..XtendFloatir5Nrr5rr XtendFloatrrrrrbiiz CREATE TABLE xx_%s ( s VARCHAR(40) NOT NULL, i INTEGER NOT NULL, f REAL NOT NULL)z,INSERT INTO xx_%s (s, i, f) VALUES (?, ?, ?)zSELECT s, i, f from xx_%s)strrrrrrandintror#r&rsrtrUrDr'rrwrrassertAlmostEqualfry) rrrrxsxixfr=r.r{ryr}s rtestExtendedTypeHandling&CommonDBTests.testExtendedTypeHandlingsm #  s   b) * fnnT3/ 0   ( ##%!!#{{} $ jj    V :VZZ G"RT  !!# ^^ 3fjj@I LL --/C   SUUB '   SUUB '  " "355" -   " s B G Gr)NNN)2r,rrr__doc__rrr#r'r/r?rJrQrWr\rrrrrrrrrrryrorrr rrrr r$r)r-r1rArSrgrlrrrzrrrrrrr5rrrr,sj "-3  ? *< &/'l!% AFS>,;"K 4,&V$ ## ###& ## # #X A0F;/z,-\.-`G-R#.#6#8#&#*'#rrcH\rSrSrSrSrSrS SjrSrSr S r S r S r g) TestADOwithSQLServeri'c[R"[RS0[RSD6UlSURlSUl[RUlg)Nrr4rbr)rsdbSqlServerconnectconnStrSQLServerr=timeoutrr0rs rrTestADOwithSQLServer.setUp(sW--  $ $Q ' +1+B+B1+E    ++rcURR5 URR5 SUlg! N'=f! N=frr=rxrDrs rtearDownTestADOwithSQLServer.tearDown0F  II     IIOO      ?AAA cUR$rr=rs rr#"TestADOwithSQLServer.getConnection; yyrNc[RSR5nU(aURU5 [R"[RS0UD6$Nr4r)rsrrrupdaterraddkeyskeyss rr~)TestADOwithSQLServer.getAnotherConnection>sK&&q)..0  KK ((&*A*A!*DMMMrcURR5nSnURS5 URR5 URU5 UR SS5nUSS:XdUS<S35eUSS :XdUS<S 35eUS S :XdUS <S 35eURR 5 g! N=f)Na CREATE PROCEDURE sp_DeleteMeOnlyForTesting @theInput varchar(50), @theOtherInput varchar(50), @theOutput varchar(100) OUTPUT AS SET @theOutput=@theInput+@theOtherInput (DROP PROCEDURE sp_DeleteMeOnlyForTestingsp_DeleteMeOnlyForTesting) DodsworthAnnez rrz is not "Dodsworth"r4rz is not "Anne"rB DodsworthAnnez is not "DodsworthAnne")r=r&rUrEcallprocrx)rr.spdef retvaluess r$testVariableReturningStoredProcedure9TestADOwithSQLServer.testVariableReturningStoredProcedureDsyy!  LLC D II    UMM ')P |{*Ry|.>>Q,RR*|v%H)A,)9'HH%|. |5 6 .   s +C CcUR5nURU5 S[R<S[R<S[R<S3nUR S5 UR R 5 UR U5 URS5nUR5nURUSS5 UR5S:XdS 5eUR5(aS 5eUR5S:XdS 5eUR5nURUSSS 5 UR5bS 5eUR5 g! N=f)Nzo CREATE PROCEDURE sp_DeleteMe_OnlyForTesting AS SELECT fldData FROM xx_z= ORDER BY fldData ASC SELECT fldData From xx_z> where fldData = -9999 SELECT fldData FROM xx_z+ ORDER BY fldData DESC z)DROP PROCEDURE sp_DeleteMe_OnlyForTestingsp_DeleteMe_OnlyForTestingrTzOperation should succeedzShould be an empty second setzthird set should be presentz'No more return sets, should return None) r'rrsrtrUr=rErrrwnextsetrvry)rr.rrr}rowdescs rtestMultipleSetReturn*TestADOwithSQLServer.testMultipleSetReturn_s4~~ ++D1 JJ JJ JJ    LLD E II    UMM">? mmo Q#||~%A'AA%==??C$CC"||~%D'DD%--/ A*||~%P'PP%   "  s +E11E5c URR5nSnURS5 URR5 URU5 UR S[ R "SSSSSS5S S /5nUS S :Xd S US -5eURR5 g! Nt=f)Na1 CREATE PROCEDURE sp_DeleteMeOnlyForTesting @theInput DATETIME, @theOtherInput varchar(50), @theOutput varchar(100) OUTPUT AS SET @theOutput = CONVERT(CHARACTER(20), @theInput, 0) + @theOtherInput rrirrr4Beepz rBzDec 25 2014 12:01AM Beepzvalue was="%s")r=r&rUrErrrrxrr.rresults rtestDatetimeProcedureParameter3TestADOwithSQLServer.testDatetimeProcedureParametersyy!  LLC D II    U '   b"aA 6 I  ay66T8H6RS98TT6   s +B99B=cURR5nSnURS5 URR5 URU5 [R "[ R[ R4URS/S/SQ05nUS(a)S[US5;dS [U5;dS 5eOUS(d US5eURR5 g! N=f) Na. CREATE PROCEDURE sp_DeleteMeOnlyForTesting @theInput DATETIME, @theOtherInput varchar(50), @theOutput varchar(100) OUTPUT AS SET @theOutput = CONVERT(CHARACTER(20), @theInput) + @theOtherInput rrrO)z this is wrongrz not Alicerz @theInputr4rVz(Identifies the wrong erroneous parameter) r=r&rUrE tryconnection%try_operation_with_expected_exceptionrG DataErrorrVrrrxrs r%testIncorrectStoredProcedureParameter:TestADOwithSQLServer.testIncorrectStoredProcedureParametersyy!  LLC D II    UDD ]]C-- . MM ( ) A B   !9#fQi.0Os6{4R : R!9 'fQi '9 #  s +DDr=r0rr) r,rrrrrr#r~rrrrrr5rrrr's,, N 6 #D2rrc6\rSrSrSrSrSrS SjrSrSr g) TestADOwithAccessDBic[R"[RS0[RSD6UlSURlSUl[RUlg)Nrr4rbr)rsdbAccessconnect connStrAccessr=rrr0rs rrTestADOwithAccessDB.setUpsW**  ! !! $ (.(<( GGV))!, H0D0DQ0G H}}  rrr r,rrrrrr#r~rrr5rrrrs) Xrrc6\rSrSrSrSrSrS SjrSrSr g) TestADOwithMySqlic[R"[RS0[RSD6UlSURlSUl[RUlg)Nrr4rbr)rsdbMySqlconnect connStrMySqlr=rrr0rs rrTestADOwithMySql.setUpsW))   # '-':':1'=    ''rcURR5 URR5 SUlg! N'=f! N=frrrs rrTestADOwithMySql.tearDownrrcUR$rrrs rr#TestADOwithMySql.getConnectionrrNc[RSR5nU(aURU5 [R"[RS0UD6$r)rsrrrrrrs rr~%TestADOwithMySql.getAnotherConnectionsK""1%**,  KK $$f&9&9!&<EEErcvUR"[RS0[RSD6nUcegr)r0rsrrs rrTestADOwithMySql.testOkConnects5 GGV((+ Fv/B/B1/E F}}rrrrr5rrrrs( F rrc6\rSrSrSrSrSrS SjrSrSr g) TestADOwithPostgresic[R"[RS0[RSD6UlSURlSUl[RUlg)Nrr4rbr)rsdbPostgresConnectconnStrPostgresr=rrr0rs rrTestADOwithPostgres.setUpsW,,  # #A & *0*@*@*C   " **rcURR5 URR5 SUlg! N'=f! N=frrrs rrTestADOwithPostgres.tearDown&rrcUR$rrrs rr#!TestADOwithPostgres.getConnection1rrNc[RSR5nU(aURU5 [R"[RS0UD6$r)rsrrrrrrs rr~(TestADOwithPostgres.getAnotherConnection4sK%%a(--/  KK '')?)?)BKdKKrcvUR"[RS0[RSD6nUcegr)r0rsrrs rr!TestADOwithPostgres.testOkConnect:s5 GGV++A. L&2H2H2K L}}rrrrr5rrrrs+ L rrcD\rSrSrSrSrSrSrSrSr Sr S r S r g ) TimeConverterInterfaceTesti\cLURRSSS5(deg)NrB)tcrrs r testIDate$TimeConverterInterfaceTest.testIDate]sww||D!Q''''rcLURRSSS5(deg)N rB)rTimers r testITime$TimeConverterInterfaceTest.testITime`sww||B1%%%%rcRURRSSSSSS5(deg)NrrBrr4)rrrs rtestITimestamp)TimeConverterInterfaceTest.testITimestampcs'ww  q!RA6666rcHURRS5(deg)N?mUxG@)rDateObjectFromCOMDaters rtestIDateObjectFromCOMDate5TimeConverterInterfaceTest.testIDateObjectFromCOMDatefsww,,];;;;rc>[URS5(deg)NCOMDate)hasattrrrs r testICOMDate'TimeConverterInterfaceTest.testICOMDateistww ****rcURRSSS5nURRU5nSnX#:XdU5eg)Nrrg@)rrr#rdcomDatecorrects r testExactDate(TimeConverterInterfaceTest.testExactDatels@ GGLLr2 &''//!$!*7*!rc<URRSSSSSS5nURRU5nSnURX#5 URRSSS S SS 5nURRU5nS nURX#5 g) Nr(rrrrg@r'gSsn@)rrr#rwr)s rtestExactTimestamp-TimeConverterInterfaceTest.testExactTimestamprs GG  dBB1 5''//!$ * GG  dAq"b" 5''//!$$ *rcbURRSSSSSS5nURRU5nUR[ USS5S5 URR S S S 5nURRU5nUR[ USS5S 5 g) Nr(rrrrrz1994-11-15 12:03:10r0r'rBz 2003-05-02)rrrrwrr)rr*isors r testIsoFormat(TimeConverterInterfaceTest.testIsoFormat}s GG  dBB2 6gg11!4 S"X(=> WW\\$1 %gg11"5 S"X 5rr5N) r,rrrrrrr r%r-r4r9rr5rrrr\s*(&7<++ +6rrc8\rSrSrSrSrSrSrSrSr Sr g ) TestPythonTimeConverteric8[R"5Ulgr)rGpythonTimeConverterrrs rrTestPythonTimeConverter.setUps))+rc[R"S5n[R"U5nURR U5n[ US- 5S:d SU-5eg)N) rr1rrr4r#rrUUUUUU?z%f more than an hour wrong)timemktime localtimerr#r)rmktcmds r testCOMDate#TestPythonTimeConverter.testCOMDatesU [[U V NN2 ggooa 3&'(2V4PSV4VV2rcURRS5n[R"[R"S55n[R"[R"S55nX!s=:aU:d O SUS35eg)Nr) rr1rrr2r4r#rBr) rr1rr2rBr#rBrrz$" should be about 2002-6-28 12:15:01)rrrDgmtimerE)rrIt1t2s rtestDateObjectFromCOMDate1TestPythonTimeConverter.testDateObjectFromCOMDatesmgg++M: [[ KKS T [[ KKT U }"}K#&JKK}rc[R"S5n[R"S5nURRSSS5nU[R"U5s=:a U:dU5e U5eg)N) rr1rrArr4r#r) rr1rbrArr4r#rBrrr1rM)rDrErrrrOrPobjs rtestDate TestPythonTimeConverter.testDatesb [[T U [[T Uggll4B'DKK$)r).3.).3.)rcURURRSSS5[R"S55 g)NrArrBi)rwrrrDrNrs rtestTime TestPythonTimeConverter.testTimes0  GGLLR #T[[1K%L rc"[R"[R"S55n[R"[R"S55nURR SSSSSS5nXs=:a U:dU5e U5eg) N) rr1rrAr2r4r#rBr) rr1rrAr4r#rBrrr1rrArrB)rDrFrErrrUs r testTimestamp%TestPythonTimeConverter.testTimestampsw ^^ KKT U ^^ KKT U ggaRQ7}"}!c!}!c!}rrN r,rrrrrJrQrWrZr^rr5rrr<r<s",W L/  "rr<c8\rSrSrSrSrSrSrSrSr Sr g ) TestPythonDateTimeConverteric8[R"5Ulgr)rGpythonDateTimeConverterrrs rr!TestPythonDateTimeConverter.setUps--/rc[R"SSSSSS5nURRU5n[US- 5S:dS 5eg) Nrr1rrArr4rrCzmore than an hour wrong)rrr#r)rrHrIs rrJ'TestPythonDateTimeConverter.testCOMDatesL   dAr2r1 5ggooa 3&'(2M4MM2rc URRS5n[R"SSSSSS5n[R"SSSSSS5nX!s=:a U:dU5e U5e[R"SSSSSSS 5nURRURRU55nX%s=:a U:dU5e U5eg) Nrrr1rrAr2r4r]i )rrrr#)rrIrOrPtxc1s rrQ5TestPythonDateTimeConverter.testDateObjectFromCOMDatesgg++M:   tQBA 6   tQBA 6}"}!c!}!c!}    !RRF WW * *477??2+> ?||R|R|rc[R"SSS5n[R"SSS5nURRSSS5nXs=:a U:dU5e U5eg)Nrr1rrbrM)rdaterrrUs rrW$TestPythonDateTimeConverter.testDatesY ]]4B ' ]]4B 'ggll4B'}"}!c!}!c!}rcURURRSSS5R5SSS5 g)NrArrBrz18:15:02)rwrr isoformatrs rrZ$TestPythonDateTimeConverter.testTimes3 b"a0::r5rrrs-,  #Mx#H%%x#vQ=Qh-@}D-~(6!2!2(6V)"8)"X#""<#"N 223NPVW   MM""667NPVW  MM""667JFS  MM""667KVT  MM""667GP  MM""667JFS ;; 6" zmmE"G  '55 g 0DFG, !%%g.   mmG/2.E.E.GH   + - . (##11 2  # # % ) )' 2    s %C K99 L