§ <«evãóR—ddlZddlZddlZddlZddlZddlZddlZddlm Z m Z ddlmZm Z mZddlmZd:d„Zejd„¦«Zd„Zd „Zd „Zd„Zd„Zd „Zd„Zd„Zd„Zd„Zd„ZGd„d¦«ZGd„d¦«Z Gd„d¦«Z!Gd„d¦«Z"Gd„d¦«Z#Gd„d¦«Z$Gd„d ¦«Z%Gd!„d"¦«Z&Gd#„d$¦«Z'Gd%„d&ej(¦«Z)Gd'„d(¦«Z*Gd)„d*e+¦«Z,ej-ej.d+kd,¦«Gd-„d.ej(¦«¦«Z/Gd/„d0ej(¦«Z0Gd1„d2ej(¦«Z1Gd3„d4e1¦«Z2Gd5„d6e1¦«Z3Gd7„d8e1¦«Z4e5d9krej6¦«dSdS);éN)ÚMockÚpatch)Ú bigmemtestÚcatch_unraisable_exceptionÚ gc_collect)Úcx_limitÚcó‡‡‡—ˆˆˆfd„}|S)z6Convenience decorator for testing callback tracebacks.có€•‡‡—‰rtj‰¦«ndŠtj‰¦«ˆˆˆˆfd„¦«}|S)NcóÚ•—t¦«5}t||‰‰‰¦«5‰|g|¢Ri|¤Žddd¦«n#1swxYwYddd¦«n#1swxYwY‰|g|¢Ri|¤ŽdS©N)rÚcheck_tracebacks)ÚselfÚargsÚkwargsÚcmÚ_regexÚexcÚfuncÚnames €€€€ú;/usr/lib/python3.11/test/test_sqlite3/test_userfunctions.pyÚwrapperz3with_tracebacks..decorator..wrapper*sø€å+Ñ-Ô-ð 0°å% d¨B°°V¸TÑBÔBð0ð0ØD˜Ð/ Ð/Ð/Ð/¨Ð/Ð/Ð/ð0ð0ð0ñ0ô0ð0ð0ð0ð0ð0ð0øøøð0ð0ð0ð0ð 0ð 0ð 0ñ 0ô 0ð 0ð 0ð 0ð 0ð 0ð 0øøøð 0ð 0ð 0ð 0ð ˆDÐ'˜Ð'Ð'Ð' Ð'Ð'Ð'Ð'Ð's1A¤ =±A½A ÁAÁA ÁAÁAÁA)ÚreÚcompileÚ functoolsÚwraps)rrrrrÚregexs` @€€€rÚ decoratorz"with_tracebacks..decorator(sbøøø€Ø&+Ð5•”˜EÑ"Ô"Ð"°ˆÝ Œ˜Ñ Ô ð (ð (ð (ð (ð (ð (ð (ñ Ô ð (ðˆó©)rrrrs``` rÚwith_tracebacksr!&s0øøø€ððððððððÐrc#ó(K—tjd¦« tj¦«}t j|¦«5dV—ddd¦«n#1swxYwY| |jj|¦«|rAt|jj ¦«}| | |¦«¦«|r%| |jj j|¦«tjd¦«dS#tjd¦«wxYw)zNr8rcó—dS©Né*r r rrÚfunc_returnintrBPs€Ø ˆ2rcó—dS)Nç…ëQ¸ @r r rrÚfunc_returnfloatrERó€Øˆ4rcó—dSr r r rrÚfunc_returnnullrHTrFrcó—dS)Nóblobr r rrÚfunc_returnblobrKVs€Øˆ7rcó—dS)Nìr r rrÚfunc_returnlonglongrNXr8rcó—ddzdS©Nérr r rrÚfunc_raiseexceptionrRZs€Ø€aC€C€C€Crcó—t‚r )ÚMemoryErrorr rrÚfunc_memoryerrorrU\s€Ý Ðrcó—t‚r )Ú OverflowErrorr rrÚfunc_overflowerrorrX^s€Ý Ðrcó—eZdZd„Zd„ZdS)Ú AggrNoStepcó—dSr r ©rs rÚ__init__zAggrNoStep.__init__bó€Øˆrcó—dS©Nér r\s rÚfinalizezAggrNoStep.finalizees€ØˆqrN)r1Ú __module__Ú__qualname__r]rbr rrrZrZas2€€€€€ð ð ð ðððððrrZcó—eZdZd„Zd„ZdS)ÚAggrNoFinalizecó—dSr r r\s rr]zAggrNoFinalize.__init__ir^rcó—dSr r ©rÚxs rÚstepzAggrNoFinalize.steplr^rN)r1rcrdr]rkr rrrfrfhs2€€€€€ð ð ð ð ð ð ð ð rrfcó —eZdZd„Zd„Zd„ZdS)ÚAggrExceptionInInitcó—ddzdSrPr r\s rr]zAggrExceptionInInit.__init__pó€Ø ˆ!‰ˆˆˆrcó—dSr r ris rrkzAggrExceptionInInit.stepsr^rcó—dSr r r\s rrbzAggrExceptionInInit.finalizevr^rN©r1rcrdr]rkrbr rrrmrmosA€€€€€ðððð ð ð ð ð ð ð ð rrmcó —eZdZd„Zd„Zd„ZdS)ÚAggrExceptionInStepcó—dSr r r\s rr]zAggrExceptionInStep.__init__zr^rcó—ddzdSrPr ris rrkzAggrExceptionInStep.step}rorcó—dSr@r r\s rrbzAggrExceptionInStep.finalize€s€ØˆrrNrrr rrrtrtysA€€€€€ð ð ð ððððððððrrtcó —eZdZd„Zd„Zd„ZdS)ÚAggrExceptionInFinalizecó—dSr r r\s rr]z AggrExceptionInFinalize.__init__„r^rcó—dSr r ris rrkzAggrExceptionInFinalize.step‡r^rcó—ddzdSrPr r\s rrbz AggrExceptionInFinalize.finalizeŠrorNrrr rrryryƒsA€€€€€ð ð ð ð ð ð ðððððrrycó —eZdZd„Zd„Zd„ZdS)Ú AggrCheckTypecó—d|_dSr ©Úvalr\s rr]zAggrCheckType.__init__Žs €ØˆŒˆˆrcóª—ttttd¦«tdœ}t||t|¦«u¦«|_dS©N)r,ÚintÚfloatÚNoneÚblob©r,r„r…ÚtypeÚbytesr)rÚ whichTyperÚtheTypes rrkzAggrCheckType.step‘sC€Ý¥cµEÅ4ÈÁ:Ä:Ý ð"ð"ˆåw˜yÔ)T°#©Y¬YÐ6Ñ7Ô7ˆŒˆˆrcó—|jSr r€r\s rrbzAggrCheckType.finalize–ó €ØŒxˆrNrrr rrr~r~sA€€€€€ðððð8ð8ð8ð ððððrr~có —eZdZd„Zd„Zd„ZdS)ÚAggrCheckTypescó—d|_dS©Nrr€r\s rr]zAggrCheckTypes.__init__šs €ØˆŒˆˆrc óÆ—ttttd¦«tdœ}|D]4}|xjt||t|¦«u¦«z c_Œ5dSrƒrˆ)rr‹ÚvalsrŒrs rrkzAggrCheckTypes.stepsc€Ý¥cµEÅ4ÈÁ:Ä:Ý ð"ð"ˆàð =ð =ˆCØˆHŒH˜G IÔ.µ$°s±)´)Ð;Ñ<Ô<Ñ<ˆHŒHˆHð =ð =rcó—|jSr r€r\s rrbzAggrCheckTypes.finalize£rŽrNrrr rrrr™sA€€€€€ðððð=ð=ð=ðððððrrcó —eZdZd„Zd„Zd„ZdS)ÚAggrSumcó—d|_dS)Nçr€r\s rr]zAggrSum.__init__§s €ØˆŒˆˆrcó&—|xj|z c_dSr r€)rrs rrkzAggrSum.stepªs€ØˆŒC‰ˆŒˆˆrcó—|jSr r€r\s rrbzAggrSum.finalizerŽrNrrr rrr—r—¦sA€€€€€ðððððððððððrr—có —eZdZd„Zd„Zd„ZdS)ÚAggrTextcó—d|_dS)Nr ©Útxtr\s rr]zAggrText.__init__±s €ØˆŒˆˆrcó$—|j|z|_dSr rŸ)rr s rrkz AggrText.step³s€Ø”8˜c‘>ˆŒˆˆrcó—|jSr rŸr\s rrbzAggrText.finalizeµrŽrNrrr rrrr°sA€€€€€ðððð"ð"ð"ðððððrrcóP—eZdZd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Zd „Zd„Z d„Zd „Zd„Zeed¬¦«d„¦«Zeed¬¦«d„¦«Zeed¬¦«d„¦«Zd„Zd„Zd„Zd„Zd„Zeed¬¦«d„¦«Zd„Zd„Z e!j"e#j$d kd!¦«d"„¦«Z%e!j"e#j$d kd!¦«d#„¦«Z&e!j"e#j$d kd$¦«d%„¦«Z'd&„Z(d'„Z)ee¦«d(„¦«Z*ee+d)d*¦«d+„¦«Z,e!j-e.j/d,kd-¦«e0d.d/d0¬1¦«d2„¦«¦«Z1e!j-e.j/d,kd-¦«e0d.d3d0¬1¦«d4„¦«¦«Z2d5„Z3d6S)7Ú FunctionTestscód—tjd¦«|_|j ddt¦«|j ddt ¦«|j ddt¦«|j ddt¦«|j ddt¦«|j ddt¦«|j d dt¦«|j d dt¦«|j ddd„¦«|j d dd„¦«|j ddt¦«|j ddt¦«|j ddt¦«|j ddd„¦«|j ddd„¦«|j ddd„¦«|j d¦«dS)Nú:memory:Ú returntextrÚreturntextwithnullÚ returnunicodeÚ returnintÚreturnfloatÚ returnnullÚ returnblobÚreturnlonglongÚ returnnancó —td¦«S)NÚnan)r…r rrúz%FunctionTests.setUp..Ås€½¸u¹¼€rÚreturn_noncont_blobcó2—td¦«ddd…S)NrJé)Ú memoryviewr rrr²z%FunctionTests.setUp..Çs€°GÑ)<Ô)<¸S¸S¸q¸SÔ)A€rÚraiseexceptionÚmemoryerrorÚ overflowerrorÚisblobracó,—t|t¦«Sr )Ú isinstancerŠ©rjs rr²z%FunctionTests.setUp..Ìs€½ À1ÅeÑ8LÔ8L€rÚisnonecó —|duSr r r½s rr²z%FunctionTests.setUp..Ís €¸¸T¸ €rÚspaméÿÿÿÿcó —t|¦«Sr )Úlenr½s rr²z%FunctionTests.setUp..Îs€½¸A¹¼€rzcreate table test(t text))r#ÚconnectÚconÚcreate_functionr7r;r>rBrErHrKrNrRrUrXÚexecuter\s rÚsetUpzFunctionTests.setUpºsø€Ý”> *Ñ-Ô-ˆŒàŒ× Ò ¨qµ/ÑBÔBÐBØŒ× Ò Ð!5°qÕ:QÑRÔRÐRØŒ× Ò °!Õ5GÑHÔHÐHØŒ× Ò ¨aµÑ@Ô@Ð@ØŒ× Ò °Õ3CÑDÔDÐDØŒ× Ò ¨qµ/ÑBÔBÐBØŒ× Ò ¨qµ/ÑBÔBÐBØŒ× Ò Ð!1°1Õ6IÑJÔJÐJØŒ× Ò ¨aÐ1EÐ1EÑFÔFÐFØŒ× Ò Ð!6¸Ø!AÐ!Añ Cô Cð CàŒ× Ò Ð!1°1Õ6IÑJÔJÐJØŒ× Ò °Õ3CÑDÔDÐDØŒ× Ò °!Õ5GÑHÔHÐHàŒ× Ò ¨1Ð.LÐ.LÑMÔMÐMØŒ× Ò ¨1Ð.AÐ.AÑBÔBÐBØŒ× Ò ¨Ð->Ð->Ñ?Ô?Ð?ØŒ×ÒÐ4Ñ5Ô5Ð5Ð5Ð5rcó8—|j ¦«dSr )rÅÚcloser\s rÚtearDownzFunctionTests.tearDownÑs€ØŒŠÑÔÐÐÐrcó°—| tj¦«5|j ddd„¦«ddd¦«dS#1swxYwYdS)NÚblaéœÿÿÿcó—d|zS©Nrµr r½s rr²z9FunctionTests.test_func_error_on_create..Ös €¸A¸a¹C€r)ÚassertRaisesr#ÚOperationalErrorrÅrÆr\s rÚtest_func_error_on_createz'FunctionTests.test_func_error_on_createÔs€Ø × Ò vÔ6Ñ 7Ô 7ð Að AØŒH×$Ò$ U¨D°-°-Ñ@Ô@Ð@ð Að Að Añ Aô Að Að Að Að Að Að Að Aøøøð Að Að Að Að Að As AÁAÁAcóZ—tj}d}t|j|d¬¦«5|j d¦«| tj|¦«5|j d¦«ddd¦«n#1swxYwYddd¦«dS#1swxYwYdS)Nztoo many arguments on functionra)ÚcategoryÚlimitzselect abs(-1)zselect max(1, 2))r#ÚSQLITE_LIMIT_FUNCTION_ARGrrÅrÇÚassertRaisesRegexrÒ)rrÕr4s rÚtest_func_too_many_argsz%FunctionTests.test_func_too_many_argsØs&€ÝÔ3ˆØ.ˆÝ d”h¨¸Ð ;Ñ ;Ô ;ð 6ð 6ØŒH×ÒÐ-Ñ.Ô.Ð.Ø×'Ò'Ô(?ÀÑEÔEð 6ð 6Ø”× Ò Ð!3Ñ4Ô4Ð4ð 6ð 6ð 6ñ 6ô 6ð 6ð 6ð 6ð 6ð 6ð 6øøøð 6ð 6ð 6ð 6ð 6ð 6ð 6ñ 6ô 6ð 6ð 6ð 6ð 6ð 6ð 6ð 6øøøð 6ð 6ð 6ð 6ð 6ð 6s5¦;B Á!BÁ<B ÂB ÂB ÂB ÂB Â B$Â'B$cóÖ—d„}|¦«}|t¦«d<|j dd|¦«|j ¦«}| d¦«dS)Ncó—d„}|S)Ncó—dSr`r r rrÚfz=FunctionTests.test_func_ref_count..getfunc..fâs€Øqrr )rÝs rÚgetfuncz2FunctionTests.test_func_ref_count..getfuncás€ð ð ð àˆHrr6Úreftestrzselect reftest())ÚglobalsrÅrÆÚcursorrÇ)rrÞrÝÚcurs rÚtest_func_ref_countz!FunctionTests.test_func_ref_countàsp€ð ð ð ð ˆG‰IŒIˆØ‰ Œ %ÑàŒ× Ò ¨A¨qÑ1Ô1Ð1ØŒhoŠoÑÔˆØŠÐ&Ñ'Ô'Ð'Ð'Ð'rcó—|j ¦«}| d¦«| ¦«d}| t|¦«t¦«| |d¦«dS)Nzselect returntext()rr6©rÅrárÇÚfetchoner)r‰r,©rrârs rÚtest_func_return_textz#FunctionTests.test_func_return_textìsp€ØŒhoŠoÑÔˆØŠÐ)Ñ*Ô*Ð*ØlŠl‰nŒn˜QÔˆØ×Ò˜c™œ¥CÑ(Ô(Ð(Ø×Ò˜˜eÑ$Ô$Ð$Ð$Ð$rcó—|j ¦«}| d¦« ¦«d}| t|¦«t¦«| |d¦«dS)Nzselect returntextwithnull()rr:rå)rrâÚress rÚ$test_func_return_text_with_null_charz2FunctionTests.test_func_return_text_with_null_charósn€ØŒhoŠoÑÔˆØkŠkÐ7Ñ8Ô8×AÒAÑCÔCÀAÔFˆØ×Ò˜c™œ¥CÑ(Ô(Ð(Ø×Ò˜˜hÑ'Ô'Ð'Ð'Ð'rcó—|j ¦«}| d¦«| ¦«d}| t|¦«t¦«| |d¦«dS)Nzselect returnunicode()rr=rårçs rÚtest_func_return_unicodez&FunctionTests.test_func_return_unicodeùsp€ØŒhoŠoÑÔˆØŠÐ,Ñ-Ô-Ð-ØlŠl‰nŒn˜QÔˆØ×Ò˜c™œ¥CÑ(Ô(Ð(Ø×Ò˜˜eÑ$Ô$Ð$Ð$Ð$rcó—|j ¦«}| d¦«| ¦«d}| t|¦«t¦«| |d¦«dS)Nzselect returnint()rrA)rÅrárÇrær)r‰r„rçs rÚtest_func_return_intz"FunctionTests.test_func_return_intsp€ØŒhoŠoÑÔˆØŠÐ(Ñ)Ô)Ð)ØlŠl‰nŒn˜QÔˆØ×Ò˜c™œ¥CÑ(Ô(Ð(Ø×Ò˜˜bÑ!Ô!Ð!Ð!Ð!rcó,—|j ¦«}| d¦«| ¦«d}| t|¦«t¦«|dks|dkr| d¦«dSdS)Nzselect returnfloat()rgé&1¬ @gTã¥›Ä @zwrong value)rÅrárÇrær)r‰r…Úfailrçs rÚtest_func_return_floatz$FunctionTests.test_func_return_floats„€ØŒhoŠoÑÔˆØŠÐ*Ñ+Ô+Ð+ØlŠl‰nŒn˜QÔˆØ×Ò˜c™œ¥EÑ*Ô*Ð*ØŠ;ˆ;˜# š+˜+ØIŠImÑ$Ô$Ð$Ð$Ð$ð&˜+rcó"—|j ¦«}| d¦«| ¦«d}| t|¦«td¦«¦«| |d¦«dS)Nzselect returnnull()r)rÅrárÇrær)r‰rçs rÚtest_func_return_nullz#FunctionTests.test_func_return_nullsv€ØŒhoŠoÑÔˆØŠÐ)Ñ*Ô*Ð*ØlŠl‰nŒn˜QÔˆØ×Ò˜c™œ¥D¨¡J¤JÑ/Ô/Ð/Ø×Ò˜˜dÑ#Ô#Ð#Ð#Ð#rcó—|j ¦«}| d¦«| ¦«d}| t|¦«t¦«| |d¦«dS)Nzselect returnblob()rrJ)rÅrárÇrær)r‰rŠrçs rÚtest_func_return_blobz#FunctionTests.test_func_return_blobsp€ØŒhoŠoÑÔˆØŠÐ)Ñ*Ô*Ð*ØlŠl‰nŒn˜QÔˆØ×Ò˜c™œ¥EÑ*Ô*Ð*Ø×Ò˜˜gÑ&Ô&Ð&Ð&Ð&rcóÂ—|j ¦«}| d¦«| ¦«d}| |d¦«dS)Nzselect returnlonglong()rrM©rÅrárÇrær)rçs rÚtest_func_return_long_longz(FunctionTests.test_func_return_long_longsT€ØŒhoŠoÑÔˆØŠÐ-Ñ.Ô.Ð.ØlŠl‰nŒn˜QÔˆØ×Ò˜˜eÑ$Ô$Ð$Ð$Ð$rcó¼—|j ¦«}| d¦«| | ¦«d¦«dS)Nzselect returnnan()r)rÅrárÇÚassertIsNoneræ©rrâs rÚtest_func_return_nanz"FunctionTests.test_func_return_nan#sM€ØŒhoŠoÑÔˆØŠÐ(Ñ)Ô)Ð)Ø×Ò˜#Ÿ,š,™.œ.¨Ô+Ñ,Ô,Ð,Ð,Ð,rrR©rcóH—|j ¦«}| tj¦«5}| d¦«| ¦«ddd¦«n#1swxYwY| t|j ¦«d¦«dS)Nzselect raiseexception()ú&user-defined function raised exception© rÅrárÑr#rÒrÇrær)r,Ú exception©rrârs rÚtest_func_exceptionz!FunctionTests.test_func_exception(sÅ€àŒhoŠoÑÔˆØ × Ò vÔ6Ñ 7Ô 7ð ¸2ØKŠKÐ1Ñ2Ô2Ð2ØLŠL‰NŒNˆNð ð ð ñ ô ð ð ð ð ð ð øøøð ð ð ð ð ×Ò˜Rœ\Ñ*Ô*Ð,TÑUÔUÐUÐUÐUs¹*A/Á/A3Á6A3rUcóð—|j ¦«}| t¦«5| d¦«| ¦«ddd¦«dS#1swxYwYdS)Nzselect memoryerror())rÅrárÑrTrÇrærüs rÚtest_func_memory_errorz$FunctionTests.test_func_memory_error0s«€àŒhoŠoÑÔˆØ × Ò {Ñ +Ô +ð ð ØKŠKÐ.Ñ/Ô/Ð/ØLŠL‰NŒNˆNð ð ð ñ ô ð ð ð ð ð ð ð øøøð ð ð ð ð ð s´*A+Á+A/Á2A/rXcóú—|j ¦«}| tj¦«5| d¦«| ¦«ddd¦«dS#1swxYwYdS)Nzselect overflowerror())rÅrárÑr#Ú DataErrorrÇrærüs rÚtest_func_overflow_errorz&FunctionTests.test_func_overflow_error7s®€àŒhoŠoÑÔˆØ × Ò vÔ/Ñ 0Ô 0ð ð ØKŠKÐ0Ñ1Ô1Ð1ØLŠL‰NŒNˆNð ð ð ñ ô ð ð ð ð ð ð ð øøøð ð ð ð ð ð s¹*A0Á0A4Á7A4cóÄ—|j ¦«}| dd¦«| ¦«d}| |d¦«dS)Nzselect spam(?, ?))rarµrrµrørçs rÚtest_any_argumentsz FunctionTests.test_any_arguments>sV€ØŒhoŠoÑÔˆØŠÐ'¨Ñ0Ô0Ð0ØlŠl‰nŒn˜QÔˆØ×Ò˜˜aÑ Ô Ð Ð Ð rcó”—|j d¦«}| | ¦«d¦«dS)Nzselect isblob(x'')r)rÅrÇÚ assertTruerærüs rÚtest_empty_blobzFunctionTests.test_empty_blobDs=€ØŒh×ÒÐ3Ñ4Ô4ˆØŠ˜Ÿš™œ qÔ)Ñ*Ô*Ð*Ð*Ð*rcó²—|j dtd¦«f¦«}| | ¦«d¦«dS)Nzselect isnone(?)r±r)rÅrÇr…r rærüs rÚtest_nan_floatzFunctionTests.test_nan_floatHsG€ØŒh×ÒÐ1µE¸%±L´L°?ÑCÔCˆàŠ˜Ÿš™œ qÔ)Ñ*Ô*Ð*Ð*Ð*rcóZ—d}| t||jjdd¦«dS)Nz1Python int too large to convert to SQLite INTEGERúselect spam(?))ì )rØrWrÅrÇ)rÚerrs rÚtest_too_large_intz FunctionTests.test_too_large_intMs9€ØAˆØ×Ò}¨c°4´8Ô3CØ/°ñ =ô =ð =ð =ð =rc ó„—| td|jjdt d¦«ddd…f¦«dS)Nz%underlying buffer is not C-contiguousrrJrµ)rØÚBufferErrorrÅrÇr¶r\s rÚtest_non_contiguous_blobz&FunctionTests.test_non_contiguous_blobRsM€Ø×Ò{ØFØ#œxÔ/Ð1AÝ *¨7Ñ 3Ô 3°C°C°a°CÔ 8Ð:ñ <ô <ð <ð <ð .append_resultes&ø€ØNŠN˜C¥ c¡¤Ð+Ñ,Ô,Ð,Ð,Ð,rÚtest_paramsrarArÁlÓ{ÑC lrDÚinfÚtextr:uË¢qË¡â±áµ—áµ‰rJrµzselect test_params(?)) rÅrÆr„r…r,rŠÚ bytearrayÚranger¶r‰rÇrær))rr$ÚdatasetrÚ_râr#s @rÚtest_func_paramszFunctionTests.test_func_paramscs#ø€Øˆð -ð -ð -ð -ð -àŒ× Ò °°=ÑAÔAÐAð•ˆIØ •ˆIØ ¥#Ð&Ø ¥#Ð&Ø •5ˆMÝ 5‰\Œ\5Ð!Ø •SˆMØ •sˆOØ .µÐ4Ø •eÐÝ •u˜Q‘x”xÑ Ô ¥%Ð(Ý ˜Ñ Ô ¥%Ð(Ø •4˜‘:”:Ðð ˆðð ð ‰FˆCØ”(×"Ò"Ð#:¸S¸FÑCÔCˆCØLŠL‰NŒNˆNˆNØ×Ò˜ 'Ñ*Ô*Ð*Ð*Ð*r)éér-zRequires SQLite 3.8.3 or highercó”—td¬¦«}|j dd|d¬¦«tjdkr7|j d¦«| |jd¦«dS| tj ¦«5|j d ¦«ddd¦«dS#1swxYwYdS) N©Úreturn_valueÚnondeterministicrF©Ú deterministic©r-érz.select nondeterministic() = nondeterministic()rµz>create index t on test(t) where nondeterministic() is not null) rrÅrÆr#Úsqlite_version_inforÇr)Ú call_countrÑrÒ©rÚmocks rÚtest_func_non_deterministicz)FunctionTests.test_func_non_deterministic„s€å Ð&Ñ&Ô&ˆØŒ× Ò Ð!3°Q¸ÈEÐ ÑRÔRÐRÝÔ%¨ Ò2Ð2ØŒH×ÒÐMÑNÔNÐNØ×Ò˜Tœ_¨aÑ0Ô0Ð0Ð0Ð0à×"Ò"¥6Ô#:Ñ;Ô;ð cð cØ”× Ò Ð!aÑbÔbÐbð cð cð cñ cô cð cð cð cð cð cð cð cøøøð cð cð cð cð cð csÂB=Â=CÃCcó|—td¬¦«}|j dd|d¬¦«tjdkr7|j d¦«| |jd¦«dS |j d ¦«dS#tj$r| d ¦«YdSwxYw)Nr0r4rTr3r5z(select deterministic() = deterministic()raz;create index t on test(t) where deterministic() is not nullz/Unexpected failure while creating partial index) rrÅrÆr#r7rÇr)r8rÒrñr9s rÚtest_func_deterministicz%FunctionTests.test_func_deterministicsÕ€å Ð&Ñ&Ô&ˆØŒ× Ò °!°TÈÐ ÑNÔNÐNÝÔ%¨ Ò2Ð2ØŒH×ÒÐGÑHÔHÐHØ×Ò˜Tœ_¨aÑ0Ô0Ð0Ð0Ð0ð MØ”× Ò Ð!^Ñ_Ô_Ð_Ð_Ð_øÝÔ*ð Mð Mð MØ— ’ ÐKÑLÔLÐLÐLÐLÐLð MøøøsÁ7BÂ$B;Â:B;zSQLite < 3.8.3 neededcó¼—| tj¦«5|j ddt d¬¦«ddd¦«dS#1swxYwYdS)Nr4rTr3)rÑr#ÚNotSupportedErrorrÅrÆr„r\s rÚ%test_func_deterministic_not_supportedz3FunctionTests.test_func_deterministic_not_supportedœs°€à × Ò vÔ7Ñ 8Ô 8ð Rð RØŒH×$Ò$ _°a½ÈDÐ$ÑQÔQÐQð Rð Rð Rñ Rô Rð Rð Rð Rð Rð Rð Rð Røøøð Rð Rð Rð Rð Rð Rs $AÁAÁAcó°—| t¦«5|j ddtd¦«ddd¦«dS#1swxYwYdS)Nr4rT)rÑÚ TypeErrorrÅrÆr„r\s rÚ$test_func_deterministic_keyword_onlyz2FunctionTests.test_func_deterministic_keyword_only¡sª€Ø × Ò yÑ )Ô )ð Dð DØŒH×$Ò$ _°a½¸dÑCÔCÐCð Dð Dð Dñ Dô Dð Dð Dð Dð Dð Dð Dð Døøøð Dð Dð Dð Dð Dð Ds›#AÁAÁAcóÌ—tjd¦«}d„}| dd|¦«|d¦«}~~|g}| |¦«~~t ¦«dS)Nr¦có—dSr r )Úts rÚmd5sumz=FunctionTests.test_function_destructor_via_gc..md5sum©s€ØˆFrÚmd5raz(create table lang (name, first_appeared))r#rÄrÆr!r)rÚdestrGrjÚys rÚtest_function_destructor_via_gcz-FunctionTests.test_function_destructor_via_gc¥sy€õŒ~˜jÑ)Ô)ˆð ð ð ð ×Ò˜U A vÑ.Ô.Ð.ØˆDÐ;Ñ<Ô<ˆØDà ˆCˆØ Š‰Œˆà ˆaÝ‰Œˆˆˆrcó—|j ¦«}d}dD]n}|j dd|fd„¦«| tj|¦«5| d¦«ddd¦«n#1swxYwYŒodS)Nústring or blob too big)llûÿÿÿlÚlargeintrcó—|Sr r )Úvalues rr²z>FunctionTests.test_func_return_too_large_int..»s€È€rzselect largeint())rÅrárÆrØr#rrÇ)rrâr4rPs rÚtest_func_return_too_large_intz,FunctionTests.test_func_return_too_large_int¶sÖ€àŒhoŠoÑÔˆØ&ˆØ+ð 1ð 1ˆEØŒH×$Ò$ Z°ÀÐ4MÐ4MÐ4MÑNÔNÐNØ×'Ò'Ô(8¸#Ñ>Ô>ð 1ð 1Ø—’Ð/Ñ0Ô0Ð0ð 1ð 1ð 1ñ 1ô 1ð 1ð 1ð 1ð 1ð 1ð 1øøøð 1ð 1ð 1ð 1øð 1ð 1sÁBÂB ÂB rÚchrcó —|j ¦«}|j ddt¦«dD]P}| t j¦«5| d|f¦«ddd¦«n#1swxYwYŒQdS)NÚpychrra)iÿØiÿÜzselect pychr(?))rÅrárÆrRrÑr#rÒrÇ)rrârPs rÚ%test_func_return_text_with_surrogatesz3FunctionTests.test_func_return_text_with_surrogates¿sÊ€àŒhoŠoÑÔˆØŒ× Ò ¨!SÑ1Ô1Ð1Ø#ð 9ð 9ˆEØ×"Ò"¥6Ô#:Ñ;Ô;ð 9ð 9Ø—’Ð-°¨xÑ8Ô8Ð8ð 9ð 9ð 9ñ 9ô 9ð 9ð 9ð 9ð 9ð 9ð 9øøøð 9ð 9ð 9ð 9øð 9ð 9sÁBÂB Â B ìzrequires 64bit platformrMr-F)ÚsizeÚmemuseÚdry_runcó—|j ¦«}dD]m}|j dd|fd„¦«| tj¦«5| d¦«ddd¦«n#1swxYwYŒndS)N©iÿÿÿrMÚ largetextrcó—d|zS)NÚbr ©rWs rr²z?FunctionTests.test_func_return_too_large_text..Ìs €ÀsÈTÁz€rzselect largetext()©rÅrárÆrÑr#rrÇ©rrWrâs rÚtest_func_return_too_large_textz-FunctionTests.test_func_return_too_large_textÇsÑ€ðŒhoŠoÑÔˆØ"ð 2ð 2ˆDØŒH×$Ò$ [°!ÀÐ5QÐ5QÐ5QÑRÔRÐRØ×"Ò"¥6Ô#3Ñ4Ô4ð 2ð 2Ø—’Ð0Ñ1Ô1Ð1ð 2ð 2ð 2ñ 2ô 2ð 2ð 2ð 2ð 2ð 2ð 2øøøð 2ð 2ð 2ð 2øð 2ð 2óÁA>Á>B ÂB rµcó—|j ¦«}dD]m}|j dd|fd„¦«| tj¦«5| d¦«ddd¦«n#1swxYwYŒndS)Nr[Ú largeblobrcó—d|zS)Nóbr r_s rr²z?FunctionTests.test_func_return_too_large_blob..Õs €ÀtÈdÁ{€rzselect largeblob()r`ras rÚtest_func_return_too_large_blobz-FunctionTests.test_func_return_too_large_blobÐsÑ€ðŒhoŠoÑÔˆØ"ð 2ð 2ˆDØŒH×$Ò$ [°!ÀÐ5RÐ5RÐ5RÑSÔSÐSØ×"Ò"¥6Ô#3Ñ4Ô4ð 2ð 2Ø—’Ð0Ñ1Ô1Ð1ð 2ð 2ð 2ñ 2ô 2ð 2ð 2ð 2ð 2ð 2ð 2øøøð 2ð 2ð 2ð 2øð 2ð 2rccó¢‡—‰j ddˆfd„¦«d}‰ tj|‰jjd¦«dS)NÚ badreturnrcó•—‰Sr r r\s€rr²z>FunctionTests.test_func_return_illegal_value..Úsø€¸€rrzselect badreturn())rÅrÆrØr#rÒrÇ)rr4s` rÚtest_func_return_illegal_valuez,FunctionTests.test_func_return_illegal_valueÙsaø€ØŒ× Ò ¨a°°°°Ñ>Ô>Ð>Ø6ˆØ×ÒvÔ6¸Ø#œxÔ/Ð1Eñ Gô Gð Gð Gð GrN)4r1rcrdrÈrËrÓrÙrãrèrërírïròrôrörùrýr!ÚZeroDivisionErrorrrTrrWr rrrrrrrrr,ÚunittestÚskipIfr#r7r;r=r@rCrKrQrrUÚ skipUnlessÚsysÚmaxsizerrbrhrlr rrr¤r¤¹sÕ€€€€€ð6ð6ð6ð.ðððAðAðAð6ð6ð6ð (ð (ð (ð%ð%ð%ð(ð(ð(ð%ð%ð%ð"ð"ð"ð%ð%ð%ð$ð$ð$ð'ð'ð'ð%ð%ð%ð-ð-ð-ð €_Ð&Ð-BÐCÑCÔCðVðVñDÔCðVð€_[Ð'9Ð:Ñ:Ô:ððñ;Ô:ðð€_]Ð)=Ð>Ñ>Ô>ððñ?Ô>ðð!ð!ð!ð+ð+ð+ð+ð+ð+ð =ð=ð=ð <ð<ð<ð€_[Ð(<Ð=Ñ=Ô=ððñ>Ô=ðð 2ð2ð2ð +ð+ð+ðB€X„_VÔ/°)Ò;Ð=^Ñ_Ô_ðcðcñ`Ô_ðcð€X„_VÔ/°)Ò;Ð=^Ñ_Ô_ð Mð Mñ`Ô_ð Mð€X„_VÔ/°9Ò<Ð>UÑVÔVðRðRñWÔVðRðDðDðDðððð"€_]Ñ#Ô#ð1ð1ñ$Ô#ð1ð€_Ð'Ð)AÀ5ÑIÔIð9ð9ñJÔIð9ð€XÔ˜œ uÒ,Ð.GÑHÔHØ€ZU 1¨eÐ4Ñ4Ô4ð2ð2ñ5Ô4ñIÔHð2ð€XÔ˜œ uÒ,Ð.GÑHÔHØ€ZU 1¨eÐ4Ñ4Ô4ð2ð2ñ5Ô4ñIÔHð2ðGðGðGðGðGrr¤có,—eZdZd„Zd„Zd„Zd„Zd„ZdS)ÚWindowSumIntcó—d|_dSr’©Úcountr\s rr]zWindowSumInt.__init__ás €ØˆŒ ˆ ˆ rcó&—|xj|z c_dSr rv©rrPs rrkzWindowSumInt.stepäó€Øˆ Œ eÑˆ Œ ˆ ˆ rcó—|jSr rvr\s rrPzWindowSumInt.valueçó €ØŒzÐrcó&—|xj|zc_dSr rvrys rÚinversezWindowSumInt.inverseêrzrcó—|jSr rvr\s rrbzWindowSumInt.finalizeír|rN)r1rcrdr]rkrPr~rbr rrrtrtàs_€€€€€ðððððððððððððððððrrtcó—eZdZdS)Ú BadWindowN)r1rcrdr rrrrðs€€€€€Ø€Drr)r-érzRequires SQLite 3.25.0 or newercóÒ—eZdZd„Zd„Zd„Zee¦«d„¦«Zee¦«d„¦«Z ee ¦«d„¦«Zee ¦«d„¦«Zd„Z d „Zd „ZdS)ÚWindowFunctionTestscó†—tjd¦«|_|j ¦«|_gd¢}|j5|j d¦«|j d|¦«ddd¦«n#1swxYwYgd¢|_d|_|j ddt¦«dS) Nr¦))Úaé)r^rQ)Úcr-)Údr.)Úerazcreate table test(x, y)zinsert into test values(?, ?)))r†é )r^é)rˆé)r‰rŒ)rŠr‹z¨ select x, %s(y) over ( order by x rows between 1 preceding and 1 following ) as sum_y from test order by x Úsumintra)r#rÄrÅrárârÇÚexecutemanyÚexpectedÚqueryÚcreate_window_functionrt)rÚvaluess rrÈzWindowFunctionTests.setUp÷s€Ý”> *Ñ-Ô-ˆŒØ”8—?’?Ñ$Ô$ˆŒð ð ð ˆðŒXð Jð JØŒH×ÒÐ6Ñ7Ô7Ð7ØŒH× Ò Ð!@À&ÑIÔIÐIð Jð Jð Jñ Jô Jð Jð Jð Jð Jð Jð Jøøøð Jð Jð Jð Jð ð ð ˆŒ ðˆŒ ð Œ×'Ò'¨°!µ\ÑBÔBÐBÐBÐBsÁ6BÂB ÂB có®—|j |jdz¦«| |j ¦«|j¦«dS)NrŽ)rârÇr‘r)Úfetchallrr\s rÚtest_win_sum_intz$WindowFunctionTests.test_win_sum_intsK€ØŒ×Ò˜œ hÑ.Ñ/Ô/Ð/Ø×Ò˜œ×*Ò*Ñ,Ô,¨d¬mÑ<Ô<Ð<Ð<Ð.MissingValuecó—dSr r ris rrkzFWindowFunctionTests.test_win_missing_method..MissingValue.step8ó€€€rcó—dSr r ris rr~zIWindowFunctionTests.test_win_missing_method..MissingValue.inverse9rªrcó—dSr@r r\s rrbzJWindowFunctionTests.test_win_missing_method..MissingValue.finalize:ó€ r rrN)r1rcrdrkr~rbr rrÚMissingValuer¨7ó+€€€€€Ø#Ð#Ð#Ø&Ð&Ð&Ø)Ð)Ð)Ð)Ð)rr®có —eZdZd„Zd„Zd„ZdS)úCWindowFunctionTests.test_win_missing_method..MissingInversecó—dSr r ris rrkzHWindowFunctionTests.test_win_missing_method..MissingInverse.step=rªrcó—dSr@r r\s rrPzIWindowFunctionTests.test_win_missing_method..MissingInverse.value>ó€ B Brcó—dSr@r r\s rrbzLWindowFunctionTests.test_win_missing_method..MissingInverse.finalize?rrN)r1rcrdrkrPrbr rrÚMissingInverser±<r¯rr¶có —eZdZd„Zd„Zd„ZdS)ú@WindowFunctionTests.test_win_missing_method..MissingStepcó—dSr@r r\s rrPzFWindowFunctionTests.test_win_missing_method..MissingStep.valueBr´rcó—dSr r ris rr~zHWindowFunctionTests.test_win_missing_method..MissingStep.inverseCrªrcó—dSr@r r\s rrbzIWindowFunctionTests.test_win_missing_method..MissingStep.finalizeDrrN)r1rcrdrPr~rbr rrÚMissingStepr¸As+€€€€€Ø&Ð&Ð&Ø&Ð&Ð&Ø)Ð)Ð)Ð)Ð)rr¼rkrPr~)rœÚclsrŸrar z' method not defined) r¡rÅr’rØr#rÒrârÇr‘r•)rr®r¶r¼r*rœr½rs rÚtest_win_missing_methodz+WindowFunctionTests.test_win_missing_method5sü€ð *ð *ð *ð *ð *ñ *ô *ð *ð *ð *ð *ð *ð *ñ *ô *ð *ð *ð *ð *ð *ð *ñ *ô *ð *ð[Ð!Ø lÐ#Ø ˜Ð'ð ˆð !ð (ð (‰IˆD#Ø—’ 4¨SÑ1Ô1ð (ð (Ø$˜d}}Ø”×/Ò/°°a¸Ñ=Ô=Ð=Ø×+Ò+FÔ,CØ,J°Ð,JÐ,JÐ,JñLôLð(ð(à”H×$Ò$ T¤Z°$Ñ%6Ñ7Ô7Ð7Ø”H×%Ò%Ñ'Ô'Ð'ð(ð(ð(ñ(ô(ð(ð(ð(ð(ð(ð(øøøð(ð(ð(ð(ð (ð (ð (ñ (ô (ð (ð (ð (ð (ð (ð (øøøð (ð (ð (ð (øð (ð (s7ÁAC6Â.MissingFinalizecó—dSr r ris rrkzKWindowFunctionTests.test_win_missing_finalize..MissingFinalize.stepZrªrcó—dSr@r r\s rrPzLWindowFunctionTests.test_win_missing_finalize..MissingFinalize.value[r´rcó—dSr r ris rr~zNWindowFunctionTests.test_win_missing_finalize..MissingFinalize.inverse\rªrN)r1rcrdrkrPr~r rrÚMissingFinalizerÁYs+€€€€€Ø#Ð#Ð#Ø&Ð&Ð&Ø&Ð&Ð&Ð&Ð&rrÅÚmissing_finalizera)rÅr’rârÇr‘r•)rrÅrs rÚtest_win_missing_finalizez-WindowFunctionTests.test_win_missing_finalizeTs‚€ð 'ð 'ð 'ð 'ð 'ñ 'ô 'ð 'ð "ˆØŒ×'Ò'¨¨a°ÑAÔAÐAØŒ×Ò˜œ dÑ*Ñ+Ô+Ð+ØŒ×ÒÑÔÐÐÐrcó¤—|j ddd¦«| tj|jj|jdz¦«dS)NrŽra)rÅr’rÑr#rÒrârÇr‘r\s rÚtest_win_clear_functionz+WindowFunctionTests.test_win_clear_functioncsT€ØŒ×'Ò'¨°!°TÑ:Ô:Ð:Ø×Ò&Ô1°4´8Ô3CØœ* xÑ/ñ 1ô 1ð 1ð 1ð 1rcó$—Gd„dt¦«}d„|jD¦«}|j dd|¦«|j |jdz¦«| |j ¦«|¦«dS)Ncó—eZdZd„Zd„ZdS)úAWindowFunctionTests.test_win_redefine_function..Redefinedcó,—|xj|dzz c_dSrÐrvrys rrkzFWindowFunctionTests.test_win_redefine_function..Redefined.stepks€ 4 :¤:°¸±Ñ#: :¤: : :rcó,—|xj|dzzc_dSrÐrvrys rr~zIWindowFunctionTests.test_win_redefine_function..Redefined.inversels€ d j¤j°E¸A±IÑ&= j¤j j jrN)r1rcrdrkr~r rrÚ RedefinedrÌjs"€€€€€Ø:Ð:Ð:Ø=Ð=Ð=Ð=Ð=rrÏcó4—g|]}|d|ddzf‘ŒS)rrarµr )Ú.0Úvs rú zBWindowFunctionTests.test_win_redefine_function..ms(€Ð:Ð:Ð: qQq”T˜1˜Qœ4 ™6NÐ:Ð:Ð:rrŽra) rtrrÅr’rârÇr‘r)r•)rrÏrs rÚtest_win_redefine_functionz.WindowFunctionTests.test_win_redefine_functionhs¤€ð >ð >ð >ð >ð >ñ >ô >ð >ð;Ð:¨D¬MÐ:Ñ:Ô:ˆàŒ×'Ò'¨°!°YÑ?Ô?Ð?ØŒ×Ò˜œ hÑ.Ñ/Ô/Ð/Ø×Ò˜œ×*Ò*Ñ,Ô,¨hÑ7Ô7Ð7Ð7Ð7rcóÀ—Gd„d¦«}|j dd|¦«| tjd|jj|jdz¦«dS)Ncó —eZdZd„Zd„Zd„ZdS)úIWindowFunctionTests.test_win_error_value_return..ErrorValueReturncó—dSr r r\s rr]zRWindowFunctionTests.test_win_error_value_return..ErrorValueReturn.__init__urªrcó—dSr r ris rrkzNWindowFunctionTests.test_win_error_value_return..ErrorValueReturn.stepvrªrcó—dS)Nrr r\s rrPzOWindowFunctionTests.test_win_error_value_return..ErrorValueReturn.valuews€ G GrN)r1rcrdr]rkrPr rrÚErrorValueReturnr×ts+€€€€€Ø$Ð$Ð$Ø#Ð#Ð#Ø+Ð+Ð+Ð+Ð+rrÛÚerr_val_retrarM)rÅr’rØr#rrârÇr‘)rrÛs rÚtest_win_error_value_returnz/WindowFunctionTests.test_win_error_value_returnss‡€ð ,ð ,ð ,ð ,ð ,ñ ,ô ,ð ,ð Œ×'Ò'¨ °qÐ:JÑKÔKÐKØ×ÒvÔ/Ð1IØ#œxÔ/°´¸mÑ1Kñ Mô Mð Mð Mð MrN)r1rcrdrÈr–ršr!rr¢r¥ÚAttributeErrorr¾rÇrÉrÔrÝr rrr„r„ôs€€€€€ðCðCðCð<=ð=ð=ð<ð<ð<ð €_YÑÔð ,ð ,ñ Ôð ,ð€_YÑÔð ð ñ Ôð ð€_^Ñ$Ô$ð(ð(ñ%Ô$ð(ð<€_^Ñ$Ô$ððñ%Ô$ðð1ð1ð1ð 8ð 8ð 8ðMðMðMðMðMrr„có—eZdZd„Zd„Zd„Zeed¬¦«d„¦«Zd„Z ee d¬¦«d „¦«Zee d ¬¦«d„¦«Zee d¬¦«d „¦«Z d„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„ZdS)ÚAggregateTestsc ó6—tjd¦«|_|j ¦«}| d¦«| dddddtd¦«f¦«|j dd t¦«|j d d t¦«|j dd t¦«|j dd t¦«|j d d t¦«|j ddt¦«|j ddt¦«|j dd t¦«|j dd t¦«dS)Nr¦z´ create table test( t text, i integer, f float, n, b blob ) z6insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)r6rQrDrJÚnostepraÚ nofinalizeÚexcInitÚexcStepÚexcFinalizeÚ checkTyperµÚ checkTypesrÁÚmysumÚaggtxt)r#rÄrÅrárÇr¶Úcreate_aggregaterZrfrmrtryr~rr—rrüs rrÈzAggregateTests.setUpse€Ý”> *Ñ-Ô-ˆŒØŒhoŠoÑÔˆØŠðñ ô ð ð ŠÐLØ At˜T¥:¨gÑ#6Ô#6Ð8ñ :ô :ð :ð Œ×!Ò! (¨AzÑ:Ô:Ð:ØŒ×!Ò! ,°µ>ÑBÔBÐBØŒ×!Ò! )¨QÕ0CÑDÔDÐDØŒ×!Ò! )¨QÕ0CÑDÔDÐDØŒ×!Ò! -°Õ4KÑLÔLÐLØŒ×!Ò! +¨qµ-Ñ@Ô@Ð@ØŒ×!Ò! ,°µNÑCÔCÐCØŒ×!Ò! '¨1gÑ6Ô6Ð6ØŒ×!Ò! (¨AxÑ8Ô8Ð8Ð8Ð8rcó—dSr r r\s rrËzAggregateTests.tearDown˜s €ð ˆrcó¸—| tj¦«5|j ddt ¦«ddd¦«dS#1swxYwYdS)NrÍrÎ)rÑr#rÒrÅrÆr—r\s rÚtest_aggr_error_on_createz(AggregateTests.test_aggr_error_on_creates—€Ø × Ò vÔ6Ñ 7Ô 7ð ;ð ;ØŒH×$Ò$ U¨Dµ'Ñ:Ô:Ð:ð ;ð ;ð ;ñ ;ô ;ð ;ð ;ð ;ð ;ð ;ð ;ð ;øøøð ;ð ;ð ;ð ;ð ;ð ;s "AÁAÁArZrþcó —|j ¦«}| tj¦«5}| d¦«ddd¦«n#1swxYwY| t|j¦«d¦«dS)Nzselect nostep(t) from testz2user-defined aggregate's 'step' method not defined) rÅrárÑr#rÒrÇr)r,rrs rÚtest_aggr_no_stepz AggregateTests.test_aggr_no_step¡sÅ€àŒhoŠoÑÔˆØ × Ò vÔ6Ñ 7Ô 7ð 6¸2ØKŠKÐ4Ñ5Ô5Ð5ð 6ð 6ð 6ñ 6ô 6ð 6ð 6ð 6ð 6ð 6ð 6øøøð 6ð 6ð 6ð 6à×Ò˜Rœ\Ñ*Ô*ØMñ Oô Oð Oð Oð Os¹AÁAÁ"Acó—|j ¦«}d}| tj|¦«5| d¦«| ¦«d}ddd¦«dS#1swxYwYdS)Nz6user-defined aggregate's 'finalize' method not definedzselect nofinalize(t) from testr)rÅrárØr#rÒrÇræ)rrâr4rs rÚtest_aggr_no_finalizez$AggregateTests.test_aggr_no_finalize©sº€ØŒhoŠoÑÔˆØFˆØ × #Ò #¥FÔ$;¸SÑ AÔ Að $ð $ØKŠKÐ8Ñ9Ô9Ð9Ø—,’,‘.”. Ô#ˆCð $ð $ð $ñ $ô $ð $ð $ð $ð $ð $ð $ð $øøøð $ð $ð $ð $ð $ð $s¼0A9Á9A=ÂA=rmcóT—|j ¦«}| tj¦«5}| d¦«| ¦«d}ddd¦«n#1swxYwY| t|j ¦«d¦«dS)Nzselect excInit(t) from testrz7user-defined aggregate's '__init__' method raised errorr©rrârrs rÚtest_aggr_exception_in_initz*AggregateTests.test_aggr_exception_in_init°sÊ€àŒhoŠoÑÔˆØ × Ò vÔ6Ñ 7Ô 7ð $¸2ØKŠKÐ5Ñ6Ô6Ð6Ø—,’,‘.”. Ô#ˆCð $ð $ð $ñ $ô $ð $ð $ð $ð $ð $ð $øøøð $ð $ð $ð $ð ×Ò˜Rœ\Ñ*Ô*Ð,eÑfÔfÐfÐfÐfó¹0A5Á5A9Á *Ñ-Ô-ˆŒØŒ×Òð ñ ô ð ð Œ×ÒÐ,Ñ-Ô-Ð-àŒ×Ò Ô 2Ñ3Ô3Ð3Ð3Ð3rcó—dSr r r\s rrËzAuthorizerTests.tearDownr^rcóø—| tj¦«5}|j d¦«ddd¦«n#1swxYwY| dt |j¦«¦«dS)Núselect * from t2Ú prohibited©rÑr#Ú DatabaseErrorrÅrÇÚassertInr,r©rrs rÚtest_table_accessz!AuthorizerTests.test_table_accesss¦€Ø × Ò vÔ3Ñ 4Ô 4ð 1¸ØŒH×ÒÐ/Ñ0Ô0Ð0ð 1ð 1ð 1ñ 1ô 1ð 1ð 1ð 1ð 1ð 1ð 1øøøð 1ð 1ð 1ð 1à Š l¥C¨¬Ñ$5Ô$5Ñ6Ô6Ð6Ð6Ð6ó AÁAÁAcóø—| tj¦«5}|j d¦«ddd¦«n#1swxYwY| dt |j¦«¦«dS)Núselect c2 from t1r(r)r,s rÚtest_column_accessz"AuthorizerTests.test_column_access!s¦€Ø × Ò vÔ3Ñ 4Ô 4ð 2¸ØŒH×ÒÐ0Ñ1Ô1Ð1ð 2ð 2ð 2ñ 2ô 2ð 2ð 2ð 2ð 2ð 2ð 2øøøð 2ð 2ð 2ð 2à Š l¥C¨¬Ñ$5Ô$5Ñ6Ô6Ð6Ð6Ð6r.có¢—|j d¦«|j d¦«|j d¦«dS)Nr'r0)rÅr$rÇr\s rÚtest_clear_authorizerz%AuthorizerTests.test_clear_authorizer&sL€ØŒ×Ò Ñ%Ô%Ð%ØŒ×ÒÐ+Ñ,Ô,Ð,ØŒ×ÒÐ,Ñ-Ô-Ð-Ð-Ð-rN) r1rcrdÚstaticmethodr!rÈrËr-r1r3r rrrrsx€€€€€Øð ð ñ„\ð ð4ð4ð4ð ð ð ð7ð7ð7ð 7ð7ð7ð .ð.ð.ð.ð.rrcóŠ‡—eZdZed„¦«Zeed¬¦«ˆfd„¦«Zeed¬¦«ˆfd„¦«ZˆxZ S)ÚAuthorizerRaiseExceptionTestscón—|tjkrt‚|dks|dkrt‚tjSr)r#rÚ ValueErrorrrs rr!z+AuthorizerRaiseExceptionTests.authorizer_cb-s6€à•VÔ)Ò)Ð)ÝÐØ4Š<ˆ<˜4 4š<˜<ÝÐÝÔÐrr!rþcóH•—t¦« ¦«dSr ©Úsuperr-©rÚ __class__s €rr-z/AuthorizerRaiseExceptionTests.test_table_access5óø€å ‰Œ×!Ò!Ñ#Ô#Ð#Ð#Ð#rcóH•—t¦« ¦«dSr r:r<s €rr1z0AuthorizerRaiseExceptionTests.test_column_access9r>r) r1rcrdr4r!r!r8r-r1Ú __classcell__)r=s@rr6r6,s¢ø€€€€€Øð ð ñ„\ð ð€_Z oÐ6Ñ6Ô6ð$ð$ð$ð$ñ7Ô6ð$ð€_Z oÐ6Ñ6Ô6ð$ð$ð$ð$ñ7Ô6ð$ð$ð$ð$ð$rr6có$—eZdZed„¦«ZdS)ÚAuthorizerIllegalTypeTestscóZ—|tjkrdS|dks|dkrdStjS)Nr™rr©r#rrrs rr!z(AuthorizerIllegalTypeTests.authorizer_cb>s4€à•VÔ)Ò)Ð)Ø3Ø4Š<ˆ<˜4 4š<˜<Ø3ÝÔÐrN©r1rcrdr4r!r rrrBrB=ó-€€€€€Øð ð ñ„\ð ð ð rrBcó$—eZdZed„¦«ZdS)ÚAuthorizerLargeIntegerTestscóZ—|tjkrdS|dks|dkrdStjS)NrVrrrDrs rr!z)AuthorizerLargeIntegerTests.authorizer_cbGs4€à•VÔ)Ò)Ð)Ø5Ø4Š<ˆ<˜4 4š<˜<Ø5ÝÔÐrNrEr rrrHrHFrFrrHÚ__main__)r r )7r'rr%rrqrnÚsqlite3r#Ú unittest.mockrrÚtest.supportrrrÚtest.test_sqlite3.test_dbapirr!Úcontextmanagerrr7r;r>rBrErHrKrNrRrUrXrZrfrmrtryr~rr—rÚTestCaser¤rtÚ Exceptionrror7r„ràrr6rBrHr1Úmainr rrúrSs×ðð0ÐÐÐØÐÐÐØ € € € Ø € € € Ø € € € Ø€€€ØÐÐÐà%Ð%Ð%Ð%Ð%Ð%Ð%Ð%ØKÐKÐKÐKÐKÐKÐKÐKÐKÐKà1Ð1Ð1Ð1Ð1Ð1ððððð"Ôð1ð1ñÔð1ð$ðððððððððððððððððððððððððððððððððððððñôðð ð ð ð ð ñ ô ð ð ð ð ð ð ñ ô ð ðððððñôððððððñôðð ð ð ð ð ñ ô ð ðððððñôððððððñôððððððñôððdGðdGðdGðdGðdGHÔ%ñdGôdGðdGðN ððððñôðð ð ð ð ð ñ ô ð ð€„Ô+¨jÒ8Ø2ñ4ô4ðEMðEMðEMðEMðEM˜(Ô+ñEMôEMñ4ô4ðEMðPA+ðA+ðA+ðA+ðA+XÔ&ñA+ôA+ðA+ðH'.ð'.ð'.ð'.ð'.hÔ'ñ'.ô'.ð'.ðT$ð$ð$ð$ð$ Oñ$ô$ð$ð" ð ð ð ð ñ ô ð ð ð ð ð ð /ñ ô ð ðˆzÒÐØ€H„MO„O€O€O€OðÐr