3 ╪ ў^Б<c @s№ddlZddlZddlZyddlZWnek r<dZYnXGddДdejГZGddДdejГZGddДdejГZ ej ejdkd ГGddДdejГГZGd dДdejГZ ejedГGddДdejГГZGddДdejГZddДZddДZedkr°eГdS)щNc@єLeZdZddДZddДZddДZddДZd d ДZddДZd dДZ ddДZ dS)┌SqliteTypeTestscCє(tjdГ|_|jjГ|_|jjdГdS)N·:memory:z9create table test(i integer, s varchar, f number, b blob)й┌sqlite┌connect┌con┌cursor┌cur┌executeй┌selfйr·*/usr/lib64/python3.6/sqlite3/test/types.py┌setUp"єzSqliteTypeTests.setUpcCє|jjГ|jjГdSйNйr ┌closerrrrr┌tearDown'є zSqliteTypeTests.tearDowncCє8|jjddГ|jjdГ|jjГ}|j|ddГdS)N·insert into test(s) values (?)ї├Цsterreichzselect s from testr)rйr r┌fetchone┌assertEqualйr ┌rowrrr┌CheckString+є zSqliteTypeTests.CheckStringcCrйN·insert into test(i) values (?)щ*·select i from testr)r$rrrrr┌ CheckSmallInt1r!zSqliteTypeTests.CheckSmallIntcCє>d}|jjd|fГ|jjdГ|jjГ}|j|d|ГdSйNщi(r#r%rlrйr Znumrrrr┌ CheckLargeInt7є zSqliteTypeTests.CheckLargeIntcCє>d}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)NчЕыQ╕ @·insert into test(f) values (?)·select f from testrrйr ┌valrrrr┌ CheckFloat>r,zSqliteTypeTests.CheckFloatcCєFd}t|Г}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)NєGuglhupf·insert into test(b) values (?)·select b from testrй┌ memoryviewr rrrйr Zsampler2rrrr┌ CheckBlobEs zSqliteTypeTests.CheckBlobcCs*|jjdГ|jjГ}|j|ddГdS)Nuselect '├Цsterreich'rrrrrrr┌CheckUnicodeExecuteMs z#SqliteTypeTests.CheckUnicodeExecuteN)┌__name__┌ __module__┌__qualname__rrr r&r+r3r;r<rrrrr!src@sКeZdZGddДdГZddДZddДZddДZd d ДZddДZd dДZ ddДZ ddДZddДZddДZ ddДZddДZddДZddДZdS) ┌DeclTypesTestsc@s,eZdZddДZddДZddДZddДZd S) zDeclTypesTests.FoocCst|tГr|jdГ}||_dS)Nzutf-8)┌ isinstanceZbytes┌decoder2)r Z_valrrr┌__init__Ts zDeclTypesTests.Foo.__init__cCst|tjГstS|j|jkSr)rAr@┌FooZNotImplementedr2)r Zotherrrr┌__eq__[szDeclTypesTests.Foo.__eq__cCs|tjkr|jSdSdSr)r┌PrepareProtocolr2)r Zprotocolrrr┌__conform__`s zDeclTypesTests.Foo.__conform__cCs d|jS)N·<%s>)r2rrrr┌__str__fєzDeclTypesTests.Foo.__str__N)r=r>r?rCrErGrIrrrrrDSsrDcCsntjdtjdН|_|jjГ|_|jjdГddДtjd<ddДtjd<tj tjd <d dДtjd<t tjd<dS) NrйZdetect_typeszgcreate table test(i int, s str, f float, b bool, u unicode, foo foo, bin blob, n1 number, n2 number(5))cSєdS)NчЪЩЩЩЩЩG@rй┌xrrr┌oєz&DeclTypesTests.setUp..┌FLOATcSstt|ГГSr)Zbool┌intrNrrrrPrrQ┌BOOL┌FOOcSrL)N┌WRONGrrNrrrrPtrQrV┌NUMBER)rr┌PARSE_DECLTYPESrr r r┌ convertersr@rD┌floatrrrrriszDeclTypesTests.setUpcCє8tjd=tjd=tjd=tjd=|jjГ|jjГdS)NrRrTrUrWйrrYr rrrrrrrwє zDeclTypesTests.tearDowncCr)Nr┌fooz!select s as "s [WRONG]" from testr)r^rrrrrr є zDeclTypesTests.CheckStringcCrr"rrrrrr&Жr_zDeclTypesTests.CheckSmallIntcCr'r(rr*rrrr+Нє zDeclTypesTests.CheckLargeIntcCs>d}|jjd|fГ|jjdГ|jjГ}|j|ddГdS)Nr.r/r0rrMrr1rrrr3Хr`zDeclTypesTests.CheckFloatcCsx|jjddГ|jjdГ|jjГ}|j|ddГ|jjdГ|jjddГ|jjdГ|jjГ}|j|ddГdS) Nr6Fr7rzdelete from testT)F)Trrrrr┌ CheckBoolЭs zDeclTypesTests.CheckBoolcCr-)Nrzinsert into test(u) values (?)zselect u from testrrr1rrr┌CheckUnicodeкr`zDeclTypesTests.CheckUnicodecCsDtjdГ}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)NZblaz insert into test(foo) values (?)zselect foo from testr)r@rDr rrrr1rrr┌CheckFoo▓s zDeclTypesTests.CheckFooc Cs@GddДdГ}|Г}|jtjГП|jjd|fГWdQRXdS)Nc@єeZdZdS)z/DeclTypesTests.CheckUnsupportedSeq..BarNйr=r>r?rrrr┌Bar║єrfr/йZassertRaisesrZInterfaceErrorr rйr rfr2rrr┌CheckUnsupportedSeq╣єz"DeclTypesTests.CheckUnsupportedSeqcCsBGddДdГ}|Г}|jtjГП|jjdd|iГWdQRXdS)Nc@rd)z0DeclTypesTests.CheckUnsupportedDict..BarNrerrrrrf└rgrfz!insert into test(f) values (:val)r2rhrirrr┌CheckUnsupportedDict┐rkz#DeclTypesTests.CheckUnsupportedDictcCr4)Nr5z insert into test(bin) values (?)zselect bin from testrr8r:rrrr;┼s zDeclTypesTests.CheckBlobcCs4|jjdГ|jjdГjГd}|jt|ГtГdS)Nzinsert into test(n1) values (5)zselect n1 from testrйr rrr┌typerZйr Zvaluerrr┌CheckNumber1╬szDeclTypesTests.CheckNumber1cCs4|jjdГ|jjdГjГd}|jt|ГtГdS)zr?rDrrr r&r+r3rarbrcrjrlr;rprqrrrrr@Rs r@c@r)┌ ColNamesTestscCsftjdtjdН|_|jjГ|_|jjdГddДtjd<ddДtjd<d dДtjd <ddДtjd<dS) NrrK·create table test(x foo)cSєd|jdГS)Nz[%s]┌asciiйrBrNrrrrPсrQz%ColNamesTests.setUp..rUcSrt)NrHrurvrNrrrrPтrQ┌BARcSsddS)NirrrNrrrrPуrQ┌EXCcSrL)N┌MARKERrrNrrrrPфrQ┌B1B1)rr┌PARSE_COLNAMESrr r rrYrrrrr▄szColNamesTests.setUpcCr[)NrUrwrxrzr\rrrrrцr]zColNamesTests.tearDowncCs8|jjddГ|jjdГ|jjГd}|j|dГdS)ze Assures that the declared type is not used when PARSE_DECLTYPES is not set. ·insert into test(x) values (?)┌xxx·select x from testrNйr}rйr r2rrr┌CheckDeclTypeNotUsedюsz"ColNamesTests.CheckDeclTypeNotUsedcCs8|jjddГ|jjdГ|jjГd}|j|dГdS)Nr|r~rrrrАrrr┌ CheckNone°szColNamesTests.CheckNonecCsP|jjddГ|jjdГ|jjГd}|j|dГ|j|jjdddГdS)Nr|r}zselect x as "x [bar]" from testrzrOr)r rrr┌descriptionrАrrr┌CheckColName■s zColNamesTests.CheckColNamecCs*|jjdГ|jjГd}|j|dГdS)Nzselect 'other' as "x [b1b1]"rryrrАrrr┌CheckCaseInConverterNameєz&ColNamesTests.CheckCaseInConverterNamecCs(|jjdГ|j|jjdddГdS)zq cursor.description should at least provide the column name(s), even if no row returned. zselect * from test where 0 = 1rrON)r rrrГrrrr┌CheckCursorDescriptionNoRow sz)ColNamesTests.CheckCursorDescriptionNoRowcCs|jjdГ|j|jjГdS)N·insert into test values (1))r rZassertIsNonerГrrrr┌CheckCursorDescriptionInsertsz*ColNamesTests.CheckCursorDescriptionInsertN)r=r>r?rrrБrВrДrЕrЗrЙrrrrrr█s rrщщzCTEs not supportedc@s4eZdZddДZddДZddДZddДZd d ДZdS)┌CommonTableExpressionTestscCr)Nrrsrrrrrrrz CommonTableExpressionTests.setUpcCrrrrrrrr"rz#CommonTableExpressionTests.tearDowncCs6|jjdГ|j|jjГ|j|jjdddГdS)Nz(with one as (select 1) select * from onerZ1йr rZassertIsNotNonerГrrrrr┌CheckCursorDescriptionCTESimple&rЖz:CommonTableExpressionTests.CheckCursorDescriptionCTESimplecCsN|jjdГ|jjdГ|jjdГ|j|jjГ|j|jjdddГdS)Nzinsert into test values(1)zinsert into test values(2)z:with testCTE as (select * from test) select * from testCTErrOrНrrrr┌)CheckCursorDescriptionCTESMultipleColumns+s zDCommonTableExpressionTests.CheckCursorDescriptionCTESMultipleColumnscCst|jjdГ|jjdГ|j|jjГ|j|jjdddГ|jjdГ|j|jjГ|j|jjdddГdS)NrИz?with bar as (select * from test) select * from test where x = 1rrOz?with bar as (select * from test) select * from test where x = 2rНrrrr┌CheckCursorDescriptionCTE2sz4CommonTableExpressionTests.CheckCursorDescriptionCTEN)r=r>r?rrrОrПrРrrrrrМs rМc@є4eZdZddДZeeГZddДZddДZddДZd S) ┌ObjectAdaptationTestscCst|ГSr)rZ)Zobjrrr┌cast=rJzObjectAdaptationTests.castc CsDtjdГ|_ytjt=WnYnXtjttjГ|jjГ|_ dS)Nr) rrr┌adaptersrSZregister_adapterrТrУr r rrrrrAszObjectAdaptationTests.setUpcCs&tjttjf=|jjГ|jjГdSr)rrФrSrFr rrrrrrrJs zObjectAdaptationTests.tearDowncCs0|jjddГ|jjГd}|jt|ГtГdS)Nzselect ?щr)rХrmrАrrr┌CheckCasterIsUsedOsz'ObjectAdaptationTests.CheckCasterIsUsedN)r=r>r?rУ┌staticmethodrrrЦrrrrrТ<s rТz requires zlibc@rС) ┌BinaryConverterTestscCs tj|ГSr)┌zlibZ decompress)Zsrrr┌convertVrJzBinaryConverterTests.convertcCs$tjdtjdН|_tjdtjГdS)NrrKZbin)rrr{rZregister_converterrШrЪrrrrrZszBinaryConverterTests.setUpcCs|jjГdSr)rrrrrrr^rJzBinaryConverterTests.tearDowncCs:dd}|jjdttj|ГГfГjГd}|j||ГdS)Nsabcdefgi zselect ? as "x [bin]"r)rrr9rЩZcompressrr)r ZtestdataZresultrrr┌CheckBinaryInputForConverteras"z1BinaryConverterTests.CheckBinaryInputForConverterN)r=r>r?rЪrЧrrrЫrrrrrШTs rШc@sVeZdZddДZddДZddДZddДZeje j dkdГdd ДГZddДZddДZ dS)┌ DateTimeTestscCs.tjdtjdН|_|jjГ|_|jjdГdS)NrrKz'create table test(d date, ts timestamp))rrrXrr r rrrrrrgszDateTimeTests.setUpcCrrrrrrrrlrzDateTimeTests.tearDowncCsHtjdddГ}|jjd|fГ|jjdГ|jjГd}|j||ГdS)Nщ╘r)щzinsert into test(d) values (?)zselect d from testr)rZDater rrr)r ZdZd2rrr┌CheckSqliteDateps zDateTimeTests.CheckSqliteDatecCsNtjddddddГ}|jjd|fГ|jjdГ|jjГd}|j||ГdS) NrЭr)rЮщщr·insert into test(ts) values (?)·select ts from testйrZ Timestampr rrrйr ┌tsZts2rrr┌CheckSqliteTimestampws z"DateTimeTests.CheckSqliteTimestamprКщz0the date functions are available on 3.1 or latercCsVtjjГ}|jjdГ|jjdГ|jjГd}|jt|ГtjГ|j|j|jГdS)Nz/insert into test(ts) values (current_timestamp)rгr)┌datetimeZutcnowr rrrrnZyear)r Znowrжrrr┌CheckSqlTimestamp~s zDateTimeTests.CheckSqlTimestampcCєPtjdddddddГ}|jjd|fГ|jjd Г|jjГd}|j||ГdS) NrЭr)rЮrаrбri бrвrгrдrеrrr┌CheckDateTimeSubSecondsИє z%DateTimeTests.CheckDateTimeSubSecondscCrл) NrЭr)rЮrаrбri!╔rвrгrдrеrrr┌$CheckDateTimeSubSecondsFloatingPointПrнz2DateTimeTests.CheckDateTimeSubSecondsFloatingPointN)rКrи)r=r>r?rrrЯrз┌unittest┌skipIfr┌sqlite_version_inforкrмrоrrrrrЬfs rЬcCsltjtdГ}tjtdГ}tjtdГ}tjtdГ}tjtdГ}tjtdГ}tjtdГ}tj |||||||fГS)NZCheck) rпZ makeSuiterr@rrrТrШrЬrМZ TestSuite)Zsqlite_type_suiteZdecltypes_type_suiteZcolnames_type_suiteZadaptation_suiteZ bin_suiteZ date_suiteZ cte_suiterrr┌suiteЦsr▓cCstjГ}|jtГГdSr)rпZTextTestRunnerZrunr▓)Zrunnerrrr┌testаsr│Z__main__)rКrЛrК)rйrпZsqlite3rrЩZImportErrorZTestCaserr@rrr░r▒rМrТZ skipUnlessrШrЬr▓r│r=rrrrZs( 1 ? ! 0