3 ╪ ў^Б<у @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@sLeZdZddДZddДZddДZddДZd d ДZddДZd dДZ ddДZ dS)┌SqliteTypeTestscCs(tjdГ|_|jjГ|_|jjdГdS)Nz: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"szSqliteTypeTests.setUpcCs|jjГ|jjГdS)N)r┌closer)r r r r┌tearDown's zSqliteTypeTests.tearDowncCs8|jjddГ|jjdГ|jjГ}|j|ddГdS)Nzinsert into test(s) values (?)ї├Цsterreichzselect s from testr)r)rr┌fetchone┌assertEqual)r ┌rowr r r┌CheckString+s zSqliteTypeTests.CheckStringcCs8|jjddГ|jjdГ|jjГ}|j|ddГdS)Nzinsert into test(i) values (?)щ*zselect i from testr)r)rrrr)r rr r r┌ CheckSmallInt1s zSqliteTypeTests.CheckSmallIntcCs>d}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)Nщщ(zinsert into test(i) values (?)zselect i from testrl)rrrr)r ┌numrr r r┌ CheckLargeInt7s zSqliteTypeTests.CheckLargeIntcCs>d}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)NgЕыQ╕ @zinsert into test(f) values (?)zselect f from testr)rrrr)r ┌valrr r r┌ CheckFloat>s zSqliteTypeTests.CheckFloatcCsFd}t|Г}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)NsGuglhupfzinsert into test(b) values (?)zselect b from testr)┌ memoryviewrrrr)r ┌samplerrr r r┌ CheckBlobEs zSqliteTypeTests.CheckBlobcCs*|jjdГ|jjГ}|j|ddГdS)Nuselect '├Цsterreich'ru├Цsterreich)rrrr)r rr r r┌CheckUnicodeExecuteMs z#SqliteTypeTests.CheckUnicodeExecuteN)┌__name__┌ __module__┌__qualname__rrrrrrrrr r r rr!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)┌ isinstance┌bytes┌decoder)r Z_valr r r┌__init__Ts zDeclTypesTests.Foo.__init__cCst|tjГstS|j|jkS)N)r$r#┌Foo┌NotImplementedr)r ┌otherr r r┌__eq__[szDeclTypesTests.Foo.__eq__cCs|tjkr|jSdSdS)N)r┌PrepareProtocolr)r Zprotocolr r r┌__conform__`s zDeclTypesTests.Foo.__conform__cCs d|jS)Nz<%s>)r)r r r r┌__str__fszDeclTypesTests.Foo.__str__N)r r!r"r'r+r-r.r r r rr(Ssr(cCsntjdtjdН|_|jjГ|_|jjdГddДtjd<ddДtjd<tj tjd <d dДtjd<t tjd<dS) Nz:memory:)┌detect_typeszgcreate table test(i int, s str, f float, b bool, u unicode, foo foo, bin blob, n1 number, n2 number(5))cSsdS)NgЪЩЩЩЩЩG@r )┌xr r r┌osz&DeclTypesTests.setUp..┌FLOATcSstt|ГГS)N)┌bool┌int)r0r r rr1rs┌BOOL┌FOOcSsdS)N┌WRONGr )r0r r rr1tsr7┌NUMBER)rr┌PARSE_DECLTYPESrrrr┌ convertersr#r(┌float)r r r rriszDeclTypesTests.setUpcCs8tjd=tjd=tjd=tjd=|jjГ|jjГdS)Nr2r5r6r8)rr:rr r)r r r rrws zDeclTypesTests.tearDowncCs8|jjddГ|jjdГ|jjГ}|j|ddГdS)Nzinsert into test(s) values (?)┌fooz!select s as "s [WRONG]" from testr)r<)rrrr)r rr r rrs zDeclTypesTests.CheckStringcCs8|jjddГ|jjdГ|jjГ}|j|ddГdS)Nzinsert into test(i) values (?)rzselect i from testr)r)rrrr)r rr r rrЖs zDeclTypesTests.CheckSmallIntcCs>d}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)Nrrzinsert into test(i) values (?)zselect i from testrl)rrrr)r rrr r rrНs zDeclTypesTests.CheckLargeIntcCs>d}|jjd|fГ|jjdГ|jjГ}|j|ddГdS)NgЕыQ╕ @zinsert into test(f) values (?)zselect f from testrgЪЩЩЩЩЩG@)rrrr)r rrr r rrХs zDeclTypesTests.CheckFloatcCsx|jjddГ|jjdГ|jjГ}|j|ddГ|jjdГ|jjddГ|jjdГ|jjГ}|j|ddГdS) Nzinsert into test(b) values (?)Fzselect b from testrzdelete from testT)F)T)rrrr)r rr r r┌ CheckBoolЭs zDeclTypesTests.CheckBoolcCs>d}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)Nu├Цsterreichzinsert into test(u) values (?)zselect u from testr)rrrr)r rrr r r┌CheckUnicodeкs zDeclTypesTests.CheckUnicodecCsDtjdГ}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)NZblaz insert into test(foo) values (?)zselect foo from testr)r#r(rrrr)r rrr r r┌CheckFoo▓s zDeclTypesTests.CheckFooc Cs@GddДdГ}|Г}|jtjГП|jjd|fГWdQRXdS)Nc@seZdZdS)z/DeclTypesTests.CheckUnsupportedSeq..BarN)r r!r"r r r r┌Bar║sr@zinsert into test(f) values (?))┌assertRaisesr┌InterfaceErrorrr)r r@rr r r┌CheckUnsupportedSeq╣sz"DeclTypesTests.CheckUnsupportedSeqcCsBGddДdГ}|Г}|jtjГП|jjdd|iГWdQRXdS)Nc@seZdZdS)z0DeclTypesTests.CheckUnsupportedDict..BarN)r r!r"r r r rr@└sr@z!insert into test(f) values (:val)r)rArrBrr)r r@rr r r┌CheckUnsupportedDict┐sz#DeclTypesTests.CheckUnsupportedDictcCsFd}t|Г}|jjd|fГ|jjdГ|jjГ}|j|d|ГdS)NsGuglhupfz insert into test(bin) values (?)zselect bin from testr)rrrrr)r rrrr r rr┼s zDeclTypesTests.CheckBlobcCs4|jjdГ|jjdГjГd}|jt|ГtГdS)Nzinsert into test(n1) values (5)zselect n1 from testr)rrrr┌typer;)r ┌valuer r r┌CheckNumber1╬szDeclTypesTests.CheckNumber1cCs4|jjdГ|jjdГjГd}|jt|ГtГdS)zr?rCrDrrGrHr r r rr#Rs r#c@sLeZdZddДZddДZddДZddДZd d ДZddДZd dДZ ddДZ dS)┌ ColNamesTestscCsftjdtjdН|_|jjГ|_|jjdГddДtjd<ddДtjd<d dДtjd <ddДtjd<dS) Nz:memory:)r/zcreate table test(x foo)cSsd|jdГS)Nz[%s]┌ascii)r&)r0r r rr1сsz%ColNamesTests.setUp..r6cSsd|jdГS)Nz<%s>rJ)r&)r0r r rr1тs┌BARcSsddS)Nщrr )r0r r rr1уs┌EXCcSsdS)N┌MARKERr )r0r r rr1фs┌B1B1)rr┌PARSE_COLNAMESrrrrr:)r r r rr▄szColNamesTests.setUpcCs8tjd=tjd=tjd=tjd=|jjГ|jjГdS)Nr6rKrMrO)rr:rr r)r r r rrцs zColNamesTests.tearDowncCs8|jjddГ|jjdГ|jjГd}|j|dГdS)ze Assures that the declared type is not used when PARSE_DECLTYPES is not set. zinsert into test(x) values (?)┌xxxzselect x from testrN)rQ)rrrr)r rr r r┌CheckDeclTypeNotUsedюsz"ColNamesTests.CheckDeclTypeNotUsedcCs8|jjddГ|jjdГ|jjГd}|j|dГdS)Nzinsert into test(x) values (?)zselect x from testr)N)rrrr)r rr r r┌ CheckNone°szColNamesTests.CheckNonecCsP|jjddГ|jjdГ|jjГd}|j|dГ|j|jjdddГdS)Nzinsert into test(x) values (?)rQzselect x as "x [bar]" from testrzr0)rQ)rrrr┌description)r rr r r┌CheckColName■s zColNamesTests.CheckColNamecCs*|jjdГ|jjГd}|j|dГdS)Nzselect 'other' as "x [b1b1]"rrN)rrrr)r rr r r┌CheckCaseInConverterNamesz&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 = 1rr0N)rrrrT)r r r r┌CheckCursorDescriptionNoRow sz)ColNamesTests.CheckCursorDescriptionNoRowcCs|jjdГ|j|jjГdS)Nzinsert into test values (1))rrZassertIsNonerT)r r r r┌CheckCursorDescriptionInsertsz*ColNamesTests.CheckCursorDescriptionInsertN)r r!r"rrrRrSrUrVrWrXr r r rrI█s rIщщzCTEs not supportedc@s4eZdZddДZddДZddДZddДZd d ДZdS)┌CommonTableExpressionTestscCs(tjdГ|_|jjГ|_|jjdГdS)Nz:memory:zcreate table test(x foo))rrrrrr)r r r rrsz CommonTableExpressionTests.setUpcCs|jjГ|jjГdS)N)rr r)r r r rr"s z#CommonTableExpressionTests.tearDowncCs6|jjdГ|j|jjГ|j|jjdddГdS)Nz(with one as (select 1) select * from oner┌1)rr┌assertIsNotNonerTr)r r r r┌CheckCursorDescriptionCTESimple&sz: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 testCTErr0)rrr]rTr)r r r r┌)CheckCursorDescriptionCTESMultipleColumns+s zDCommonTableExpressionTests.CheckCursorDescriptionCTESMultipleColumnscCst|jjdГ|jjdГ|j|jjГ|j|jjdddГ|jjdГ|j|jjГ|j|jjdddГdS)Nzinsert into test values (1)z?with bar as (select * from test) select * from test where x = 1rr0z?with bar as (select * from test) select * from test where x = 2)rrr]rTr)r r r r┌CheckCursorDescriptionCTE2sz4CommonTableExpressionTests.CheckCursorDescriptionCTEN)r r!r"rrr^r_r`r r r rr[s r[c@s4eZdZddДZeeГZddДZddДZddДZd S) ┌ObjectAdaptationTestscCst|ГS)N)r;)┌objr r r┌cast=szObjectAdaptationTests.castc CsDtjdГ|_ytjt=WnYnXtjttjГ|jjГ|_ dS)Nz:memory:) rrr┌adaptersr4Zregister_adapterrarcrr)r r r rrAszObjectAdaptationTests.setUpcCs&tjttjf=|jjГ|jjГdS)N)rrdr4r,rr r)r r r rrJs zObjectAdaptationTests.tearDowncCs0|jjddГ|jjГd}|jt|ГtГdS)Nzselect ?щr)re)rrrrrEr;)r rr r r┌CheckCasterIsUsedOsz'ObjectAdaptationTests.CheckCasterIsUsedN)r r!r"rc┌staticmethodrrrfr r r rra<s raz requires zlibc@s4eZdZddДZeeГZddДZddДZddДZd S) ┌BinaryConverterTestscCs tj|ГS)N)┌zlibZ decompress)┌sr r r┌convertVszBinaryConverterTests.convertcCs$tjdtjdН|_tjdtjГdS)Nz:memory:)r/┌bin)rrrPrZregister_converterrhrk)r r r rrZszBinaryConverterTests.setUpcCs|jjГdS)N)rr )r r r rr^szBinaryConverterTests.tearDowncCs:dd}|jjdttj|ГГfГjГd}|j||ГdS)Nsabcdefgщ zselect ? as "x [bin]"r)rrrri┌compressrr)r Ztestdata┌resultr r r┌CheckBinaryInputForConverteras"z1BinaryConverterTests.CheckBinaryInputForConverterN)r r!r"rkrgrrrpr r r rrhTs rhc@sVeZdZddДZddДZddДZddДZeje j dkdГdd ДГZddДZddДZ dS)┌ DateTimeTestscCs.tjdtjdН|_|jjГ|_|jjdГdS)Nz:memory:)r/z'create table test(d date, ts timestamp))rrr9rrrr)r r r rrgszDateTimeTests.setUpcCs|jjГ|jjГdS)N)rr r)r r r rrls zDateTimeTests.tearDowncCsHtjdddГ}|jjd|fГ|jjdГ|jjГd}|j||ГdS)Ni╘rщzinsert into test(d) values (?)zselect d from testr)rZDaterrrr)r ┌dZd2r r r┌CheckSqliteDateps zDateTimeTests.CheckSqliteDatecCsNtjddddddГ}|jjd|fГ|jjdГ|jjГd}|j||ГdS) Ni╘rrrщщrzinsert into test(ts) values (?)zselect ts from test)r┌ Timestamprrrr)r ┌ts┌ts2r r r┌CheckSqliteTimestampws z"DateTimeTests.CheckSqliteTimestamprYщ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)zselect ts from testr)┌datetimeZutcnowrrrrrEZyear)r Znowrxr r r┌CheckSqlTimestamp~s zDateTimeTests.CheckSqlTimestampcCsPtjdddddddГ}|jjd|fГ|jjd Г|jjГd}|j||ГdS) Ni╘rrrrurvri бzinsert into test(ts) values (?)zselect ts from test)rrwrrrr)r rxryr r r┌CheckDateTimeSubSecondsИs z%DateTimeTests.CheckDateTimeSubSecondscCsPtjdddddddГ}|jjd|fГ|jjd Г|jjГd}|j||ГdS) Ni╘rrrrurvri!╔zinsert into test(ts) values (?)zselect ts from test)rrwrrrr)r rxryr r r┌$CheckDateTimeSubSecondsFloatingPointПs z2DateTimeTests.CheckDateTimeSubSecondsFloatingPointN)rYr{)r r!r"rrrtrz┌unittest┌skipIfr┌sqlite_version_infor}r~rr r r rrqfs rqcCsltjtdГ}tjtdГ}tjtdГ}tjtdГ}tjtdГ}tjtdГ}tjtdГ}tj |||||||fГS)NZCheck) rАZ makeSuiterr#rIrarhrqr[Z TestSuite)Zsqlite_type_suiteZdecltypes_type_suiteZcolnames_type_suiteZadaptation_suiteZ bin_suiteZ date_suiteZ cte_suiter r r┌suiteЦsrГcCstjГ}|jtГГdS)N)rАZTextTestRunnerZrunrГ)Zrunnerr r r┌testаsrД┌__main__)rYrZrY)r|rАZsqlite3rri┌ImportErrorZTestCaserr#rIrБrВr[raZ skipUnlessrhrqrГrДr r r r r┌s( 1 ? ! 0