/opt/imh-python/lib/python3.9/sqlite3/test/__pycache__
Edit: /opt/imh-python/lib/python3.9/sqlite3/test/__pycache__/dbapi.cpython-39.pyc (45898B)
a
cæhý˜ ã @ s& d dl Z d dlZd dlZd dlZd dlZd dlmZmZm Z G dd„ dej
ƒZ G dd„ dej
ƒZ G dd„ dej
ƒZ
G d d
„ d
ej
ƒZG d d „ d ej
ƒZG d
d„ dej
ƒZG dd„ dej
ƒZG dd„ dej
ƒZG dd„ dej
ƒZG dd„ dej
ƒZG dd„ dej
ƒZdd„ Zdd „ Zed kr"eƒ dS ) é N)Ú
SHORT_TIMEOUTÚTESTFNÚunlinkc @ st e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dd„ Z
dd„ Z dd„ Z dd„ Z
dd„ Zdd„ ZdS ) Ú ModuleTestsc C s | tjddtj ¡ d S )Nz2.0z apilevel is %s, should be 2.0)Ú assertEqualÚsqliteZapilevel©Úself© r
ú3/opt/imh-python/lib/python3.9/sqlite3/test/dbapi.pyÚ
CheckAPILevel" s
ÿzModuleTests.CheckAPILevelc C s | tjddtj ¡ d S )Né z threadsafety is %d, should be 1)r r Z threadsafetyr r
r
r ÚCheckThreadSafety& s
ÿz ModuleTests.CheckThreadSafetyc C s | tjddtj ¡ d S )NZqmarkz%paramstyle is '%s', should be 'qmark')r r Z
paramstyler r
r
r ÚCheckParamStyle* s
ÿÿzModuleTests.CheckParamStylec C s | ttjtƒd¡ d S )Nz&Warning is not a subclass of Exception)Ú
assertTrueÚ
issubclassr ÚWarningÚ Exceptionr r
r
r Ú CheckWarning/ s ÿzModuleTests.CheckWarningc C s | ttjtƒd¡ d S )Nz$Error is not a subclass of Exception)r r r ÚErrorr r r
r
r Ú
CheckError3 s ÿzModuleTests.CheckErrorc C s | ttjtjƒd¡ d S )Nz)InterfaceError is not a subclass of Error)r r r ÚInterfaceErrorr r r
r
r ÚCheckInterfaceError7 s ÿz ModuleTests.CheckInterfaceErrorc C s | ttjtjƒd¡ d S )Nz(DatabaseError is not a subclass of Error)r r r Ú
DatabaseErrorr r r
r
r ÚCheckDatabaseError; s ÿz ModuleTests.CheckDatabaseErrorc C s | ttjtjƒd¡ d S )Nz,DataError is not a subclass of DatabaseError)r r r Ú DataErrorr r r
r
r ÚCheckDataError? s ÿzModuleTests.CheckDataErrorc C s | ttjtjƒd¡ d S )Nz3OperationalError is not a subclass of DatabaseError)r r r ÚOperationalErrorr r r
r
r ÚCheckOperationalErrorC s ÿz!ModuleTests.CheckOperationalErrorc C s | ttjtjƒd¡ d S )Nz1IntegrityError is not a subclass of DatabaseError)r r r ÚIntegrityErrorr r r
r
r ÚCheckIntegrityErrorG s ÿz ModuleTests.CheckIntegrityErrorc C s | ttjtjƒd¡ d S )Nz0InternalError is not a subclass of DatabaseError)r r r Ú
InternalErrorr r r
r
r ÚCheckInternalErrorK s ÿz ModuleTests.CheckInternalErrorc C s | ttjtjƒd¡ d S )Nz3ProgrammingError is not a subclass of DatabaseError)r r r ÚProgrammingErrorr r r
r
r ÚCheckProgrammingErrorO s ÿz!ModuleTests.CheckProgrammingErrorc C s | ttjtjƒd¡ d S )Nz4NotSupportedError is not a subclass of DatabaseError)r r r ÚNotSupportedErrorr r r
r
r ÚCheckNotSupportedErrorS s
ÿþz"ModuleTests.CheckNotSupportedErrorN)Ú__name__Ú
__module__Ú __qualname__r r r r r r r r r r r" r$ r& r
r
r
r r ! s r c @ s– e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dd„ Z
dd„ Z dd„ Z dd„ Z
dd„ Zdd„ Zdd „ Ze ejd kd ¡d d „ ƒZd!S )"ÚConnectionTestsc C s0 t d¡| _| j ¡ }| d¡ | dd¡ d S )Nú:memory:z4create table test(id integer primary key, name text)ú!insert into test(name) values (?)©Úfoo)r ÚconnectÚcxÚcursorÚexecute©r Úcur
r
r ÚsetUpZ s
zConnectionTests.setUpc C s | j ¡ d S ©N©r0 Úcloser r
r
r ÚtearDown` s zConnectionTests.tearDownc C s | j ¡ d S r6 ©r0 Úcommitr r
r
r Ú CheckCommitc s zConnectionTests.CheckCommitc C s | j ¡ | j ¡ dS )zV
A commit should also work when no changes were made to the database.
Nr: r r
r
r ÚCheckCommitAfterNoChangesf s
z)ConnectionTests.CheckCommitAfterNoChangesc C s | j ¡ d S r6 ©r0 Úrollbackr r
r
r Ú
CheckRollbackm s z ConnectionTests.CheckRollbackc C s | j ¡ | j ¡ dS )zX
A rollback should also work when no changes were made to the database.
Nr> r r
r
r ÚCheckRollbackAfterNoChangesp s
z+ConnectionTests.CheckRollbackAfterNoChangesc C s | j ¡ }d S r6 ©r0 r1 r3 r
r
r Ú CheckCursorw s zConnectionTests.CheckCursorc C s> d}| tj¡ t |¡}W d ƒ n1 s00 Y d S )Nz/foo/bar/bla/23534/mydb.db)Ú assertRaisesr r r/ )r ZYOU_CANNOT_OPEN_THISÚconr
r
r ÚCheckFailedOpenz s z ConnectionTests.CheckFailedOpenc C s | j ¡ d S r6 r7 r r
r
r Ú
CheckClose s zConnectionTests.CheckClosec C s¸ | | jjtj¡ | | jjtj¡ | | jjtj¡ | | jjtj¡ | | jjtj¡ | | jjtj¡ | | jj tj ¡ | | jj
tj
¡ | | jj tj ¡ | | jj tj ¡ d S r6 )
r r0 r r r r r r r r r! r# r% r r
r
r ÚCheckExceptions‚ s z ConnectionTests.CheckExceptionsc C s´ t d¡}| ¡ }| |jd¡ | d¡ | |jd¡ | dd¡ | |jd¡ | ddg¡ | ¡ }| |jd¡ | ¡ | |jd¡ | ddg¡ | ¡ }| |jd¡ d S ) Nr+ Fz?create table transactiontest(id integer primary key, name text)z,insert into transactiontest(name) values (?)r- Tz-select name from transactiontest where name=?r. )r r/ r1 r Úin_transactionr2 Úfetchoner; )r r0 r4 Úrowr
r
r ÚCheckInTransaction s
z"ConnectionTests.CheckInTransactionc C s6 | t¡ d| j_W d ƒ n1 s(0 Y d S )NT)rD ÚAttributeErrorr0 rI r r
r
r ÚCheckInTransactionRO¡ s z$ConnectionTests.CheckInTransactionROc C sX | tt¡ G dd„ dƒ}|ƒ }t |¡}| d¡ W d ƒ n1 sJ0 Y dS )z| Checks that we can successfully connect to a database using an object that
is PathLike, i.e. has __fspath__(). c @ s e Zd Zdd„ ZdS )z9ConnectionTests.CheckOpenWithPathLikeObject.
.Pathc S s t S r6 )r r r
r
r Ú
__fspath__ª s zDConnectionTests.CheckOpenWithPathLikeObject..Path.__fspath__N)r' r( r) rO r
r
r
r ÚPath© s rP ú create table test(id integer)N)Ú
addCleanupr r r r/ r2 )r rP Úpathr0 r
r
r ÚCheckOpenWithPathLikeObject¥ s
z+ConnectionTests.CheckOpenWithPathLikeObjectc C s8 t jdk rH| t j¡ t jddd W d ƒ n1 s:0 Y d S | tt¡ t t¡}| d¡ W d ƒ n1 s~0 Y t jdt dd}| d¡ W d ƒ n1 sº0 Y t jdt d ddH}| t j ¡ | d ¡ W d ƒ n1 s
0 Y W d ƒ n1 s*0 Y d S )
N)é é rV r+ T)ZurirQ zfile:z insert into test(id) values(0)z?mode=roz insert into test(id) values(1))
r Úsqlite_version_inforD r% r/ rR r r r2 r )r r0 r
r
r Ú CheckOpenUri° s
, ((z ConnectionTests.CheckOpenUri)rU rU r
z&needs sqlite versions older than 3.3.1c C sP | tj¡ }tjddd W d ƒ n1 s00 Y | t|jƒd¡ d S )Nr+ F)Zcheck_same_threadz shared connections not available)rD r r% r/ r ÚstrÚ exception©r Úcmr
r
r Ú CheckSameThreadErrorOnOldVersion¾ s ,z0ConnectionTests.CheckSameThreadErrorOnOldVersionN)r' r( r) r5 r9 r< r= r@ rA rC rF rG rH rL rN rT rX ÚunittestZskipIfr rW r] r
r
r
r r* X s$
ÿr* c @ s e Zd Zdd„ Zdd„ ZdS )Ú UninitialisedConnectionTestsc C s t j t j¡| _d S r6 )r Ú
ConnectionÚ__new__r0 r r
r
r r5 Ç s z"UninitialisedConnectionTests.setUpc sŠ ‡ fdd„‡ fdd„‡ fdd„‡ fdd„‡ fdd„‡ fdd„f}|D ]@}ˆ j |d ˆ tjd |¡ W d ƒ qD1 sz0 Y qDd S )
Nc s ˆ j jS r6 )r0 Úisolation_levelr
r r
r ÚÌ ó zEUninitialisedConnectionTests.test_uninit_operations..c s ˆ j jS r6 )r0 Ú
total_changesr
r r
r rc Í rd c s ˆ j jS r6 )r0 rI r
r r
r rc Î rd c s
ˆ j ¡ S r6 )r0 Ziterdumpr
r r
r rc Ï rd c s
ˆ j ¡ S r6 rB r
r r
r rc Ð rd c s
ˆ j ¡ S r6 r7 r
r r
r rc Ñ rd )Úfuncz#Base Connection.__init__ not called)ÚsubTestZassertRaisesRegexr r# )r Zfuncsrf r
r r Útest_uninit_operationsÊ s
úþz3UninitialisedConnectionTests.test_uninit_operationsN)r' r( r) r5 rh r
r
r
r r_ Æ s r_ c @ s¤ e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dd„ Z
dd„ Z dd„ Z dd„ Z
dd„ Zdd„ Zdd „ Zd d „ Zd d „ Zd!d"„ Zd#d$„ Zd%d&„ Zd'd(„ Zd)d*„ Zd+d,„ Zd-d.„ Zd/d0„ Zd1d2„ Zd3d4„ Z d5d6„ Z d7d8„ Z d9d:„ Z d;d<„ Z d=d>„ Z!d?d@„ Z"dAdB„ Z#dCdD„ Z$dEdF„ Z%dGdH„ Z&dIdJ„ Z'dKdL„ Z(dMdN„ Z)dOdP„ Z*dQdR„ Z+dSdT„ Z,dUdV„ Z-dWdX„ Z.dYdZ„ Z/d[d\„ Z0d]d^„ Z1d_d`„ Z2dadb„ Z3dcdd„ Z4dedf„ Z5dgS )hÚ CursorTestsc C s6 t d¡| _| j ¡ | _| j d¡ | j dd¡ d S )Nr+ z\create table test(id integer primary key, name text, income number, unique_test text unique)r, r- ©r r/ r0 r1 r4 r2 r r
r
r r5 Û s ÿzCursorTests.setUpc C s | j ¡ | j ¡ d S r6 ©r4 r8 r0 r r
r
r r9 ä s
zCursorTests.tearDownc C s | j d¡ d S )Núdelete from test©r4 r2 r r
r
r ÚCheckExecuteNoArgsè s z CursorTests.CheckExecuteNoArgsc C s< | tj¡ | j d¡ W d ƒ n1 s.0 Y d S )Nz select asdf)rD r r r4 r2 r r
r
r ÚCheckExecuteIllegalSqlë s z"CursorTests.CheckExecuteIllegalSqlc C s< | tj¡ | j d¡ W d ƒ n1 s.0 Y d S )Nzselect 5+4; select 4+5)rD r r r4 r2 r r
r
r ÚCheckExecuteTooMuchSqlï s z"CursorTests.CheckExecuteTooMuchSqlc C s | j d¡ d S )Nzselect 5+4; -- foo barrm r r
r
r ÚCheckExecuteTooMuchSql2ó s z#CursorTests.CheckExecuteTooMuchSql2c C s | j d¡ d S )NzT
select 5+4;
/*
foo
*/
rm r r
r
r ÚCheckExecuteTooMuchSql3ö s z#CursorTests.CheckExecuteTooMuchSql3c C s: | t¡ | j d¡ W d ƒ n1 s,0 Y d S ©Né* )rD Ú TypeErrorr4 r2 r r
r
r ÚCheckExecuteWrongSqlArgÿ s z#CursorTests.CheckExecuteWrongSqlArgc C s | j dd¡ d S )Nú insert into test(id) values (?))rt rm r r
r
r ÚCheckExecuteArgInt s z CursorTests.CheckExecuteArgIntc C s | j dd¡ d S )Nú#insert into test(income) values (?))gq=
×£ˆ£@rm r r
r
r ÚCheckExecuteArgFloat s z CursorTests.CheckExecuteArgFloatc C s | j dd¡ d S )Nr, )ZHugorm r r
r
r ÚCheckExecuteArgString s z!CursorTests.CheckExecuteArgStringc C s@ | j dd¡ | j d| j jf¡ | j ¡ }| |d d¡ d S )Nr, )úHu goz select name from test where id=?r r| )r4 r2 Ú lastrowidrJ r ©r rK r
r
r Ú!CheckExecuteArgStringWithZeroByte s
z-CursorTests.CheckExecuteArgStringWithZeroBytec C sN | t¡ }| j dd¡ W d ƒ n1 s.0 Y | t|jƒd¡ d S )Nrw rt z"parameters are of unsupported type)rD Ú
ValueErrorr4 r2 r rY rZ r[ r
r
r ÚCheckExecuteNonIterable s ,z#CursorTests.CheckExecuteNonIterablec C s> | tj¡ | j dd¡ W d ƒ n1 s00 Y d S )Nrw )é ZEgon©rD r r# r4 r2 r r
r
r ÚCheckExecuteWrongNoOfArgs1 s z&CursorTests.CheckExecuteWrongNoOfArgs1c C s< | tj¡ | j d¡ W d ƒ n1 s.0 Y d S ©Nrw rƒ r r
r
r ÚCheckExecuteWrongNoOfArgs2 s z&CursorTests.CheckExecuteWrongNoOfArgs2c C s< | tj¡ | j d¡ W d ƒ n1 s.0 Y d S r… rƒ r r
r
r ÚCheckExecuteWrongNoOfArgs3" s z&CursorTests.CheckExecuteWrongNoOfArgs3c C s: | j d¡ | j ddg¡ | j ¡ }| |d d¡ d S )Nú%insert into test(name) values ('foo')ú"select name from test where name=?r. r ©r4 r2 rJ r r~ r
r
r ÚCheckExecuteParamList' s
z!CursorTests.CheckExecuteParamListc C sH G dd„ dƒ}| j d¡ | j d|ƒ ¡ | j ¡ }| |d d¡ d S )Nc @ s e Zd Zdd„ Zdd„ ZdS )z0CursorTests.CheckExecuteParamSequence..Lc S s dS )Nr
r
r r
r
r Ú__len__/ s z8CursorTests.CheckExecuteParamSequence..L.__len__c S s |dks J ‚dS )Nr r. r
©r Úxr
r
r Ú __getitem__1 s z.L.__getitem__N©r' r( r) rŒ r r
r
r
r ÚL. s r‘ rˆ r‰ r r. rŠ )r r‘ rK r
r
r ÚCheckExecuteParamSequence- s
z%CursorTests.CheckExecuteParamSequencec C sX G dd„ dƒ}| j d¡ | t¡ | j d|ƒ ¡ W d ƒ n1 sJ0 Y d S )Nc @ s e Zd Zdd„ Zdd„ ZdS )z6CursorTests.CheckExecuteParamSequenceBadLen..Lc S s dd d S )Nr
r r
r r
r
r rŒ = s z>CursorTests.CheckExecuteParamSequenceBadLen..L.__len__c S s t ‚d S r6 )ÚAssertionError)ZslfrŽ r
r
r r ? s zBCursorTests.CheckExecuteParamSequenceBadLen..L.__getitem__Nr r
r
r
r r‘ < s r‘ rˆ r‰ )r4 r2 rD ÚZeroDivisionError)r r‘ r
r
r Ú CheckExecuteParamSequenceBadLen: s z+CursorTests.CheckExecuteParamSequenceBadLenc C s< | j d¡ | j dddi¡ | j ¡ }| |d d¡ d S )Nrˆ ú&select name from test where name=:nameÚnamer. r rŠ r~ r
r
r ÚCheckExecuteDictMappingF s
z#CursorTests.CheckExecuteDictMappingc C sJ G dd„ dt ƒ}| j d¡ | j d|ƒ ¡ | j ¡ }| |d d¡ d S )Nc @ s e Zd Zdd„ ZdS )z6CursorTests.CheckExecuteDictMapping_Mapping..Dc S s dS ©Nr. r
)r Úkeyr
r
r Ú __missing__N s zBCursorTests.CheckExecuteDictMapping_Mapping..D.__missing__N)r' r( r) r› r
r
r
r ÚDM s rœ rˆ r– r r. )Údictr4 r2 rJ r )r rœ rK r
r
r Ú CheckExecuteDictMapping_MappingL s
z+CursorTests.CheckExecuteDictMapping_Mappingc C sN | j d¡ | tj¡" | j dddi¡ W d ƒ n1 s@0 Y d S )Nrˆ z1select name from test where name=:name and id=:idr— r. ©r4 r2 rD r r# r r
r
r Ú$CheckExecuteDictMappingTooLittleArgsV s z0CursorTests.CheckExecuteDictMappingTooLittleArgsc C sH | j d¡ | tj¡ | j d¡ W d ƒ n1 s:0 Y d S )Nrˆ r– rŸ r r
r
r Ú CheckExecuteDictMappingNoArgs[ s z)CursorTests.CheckExecuteDictMappingNoArgsc C sN | j d¡ | tj¡" | j dddi¡ W d ƒ n1 s@0 Y d S )Nrˆ r‰ r— r. rŸ r r
r
r Ú CheckExecuteDictMappingUnnamed` s z*CursorTests.CheckExecuteDictMappingUnnamedc C s | j ¡ d S r6 )r4 r8 r r
r
r rG e s zCursorTests.CheckClosec C sD | j d¡ | j d¡ | j d¡ | j d¡ | | j jd¡ d S )Nrl rˆ zupdate test set name='bar'é ©r4 r2 r Úrowcountr r
r
r ÚCheckRowcountExecuteh s
z CursorTests.CheckRowcountExecutec C s | j d¡ | | j jd¡ dS )zÁ
pysqlite does not know the rowcount of SELECT statements, because we
don't fetch all rows after executing the select statement. The rowcount
has thus to be -1.
zselect 5 union select 6éÿÿÿÿNr¤ r r
r
r ÚCheckRowcountSelecto s z CursorTests.CheckRowcountSelectc C s2 | j d¡ | j dg d¢¡ | | j jd¡ d S )Nrl r, ))r
)r£ ©rU rU )r4 r2 Ú executemanyr r¥ r r
r
r ÚCheckRowcountExecutemanyx s z$CursorTests.CheckRowcountExecutemanyc C s0 | j d¡ | j d¡ | jd| jjdd d S )Nrˆ r£ z"total changes reported wrong value)Úmsg)r4 r2 Z
assertLessr0 re r r
r
r ÚCheckTotalChanges} s z CursorTests.CheckTotalChangesc C s" | j ddd„ tddƒD ƒ¡ d S )Nry c S s g | ]
}|f‘qS r
r
)Ú.0rŽ r
r
r Ú
‡ rd z8CursorTests.CheckExecuteManySequence..éd én )r4 rª Úranger r
r
r ÚCheckExecuteManySequence† s z$CursorTests.CheckExecuteManySequencec C s" G dd„ dƒ}| j d|ƒ ¡ d S )Nc @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )z4CursorTests.CheckExecuteManyIterator..MyIterc S s
d| _ d S ©Né )Úvaluer r
r
r Ú__init__‹ s z=CursorTests.CheckExecuteManyIterator..MyIter.__init__c S s | S r6 r
r r
r
r Ú__iter__Ž s z=CursorTests.CheckExecuteManyIterator..MyIter.__iter__c S s* | j dkrt‚n| j d7 _ | j fS d S )Né
r
)r¶ Ú
StopIterationr r
r
r Ú__next__‘ s
z=CursorTests.CheckExecuteManyIterator..MyIter.__next__N)r' r( r) r· r¸ r» r
r
r
r ÚMyIterŠ s r¼ ry ©r4 rª )r r¼ r
r
r ÚCheckExecuteManyIterator‰ s z$CursorTests.CheckExecuteManyIteratorc C s dd„ }| j d|ƒ ¡ d S )Nc s s t dƒD ] } | fV qd S r´ )r² )Úir
r
r Úmygen› s z4CursorTests.CheckExecuteManyGenerator..mygenry r½ )r rÀ r
r
r ÚCheckExecuteManyGeneratorš s z%CursorTests.CheckExecuteManyGeneratorc C s> | t¡ | j ddg¡ W d ƒ n1 s00 Y d S )Nrt r© ©rD ru r4 rª r r
r
r ÚCheckExecuteManyWrongSqlArg¡ s z'CursorTests.CheckExecuteManyWrongSqlArgc C s@ | tj¡ | j ddg¡ W d ƒ n1 s20 Y d S )Nzselect ?r© )rD r r# r4 rª r r
r
r ÚCheckExecuteManySelect¥ s z"CursorTests.CheckExecuteManySelectc C s< | t¡ | j dd¡ W d ƒ n1 s.0 Y d S )Nry rt r r r
r
r ÚCheckExecuteManyNotIterable© s z'CursorTests.CheckExecuteManyNotIterablec C sv | j d¡ | j dd¡ | j dd¡ | j d¡ g }| j D ]}| |d ¡ q>| |d d¡ | |d d ¡ d S )
Nrl rw )rµ )é z select id from test order by idr rµ r
rÆ )r4 r2 Úappendr )r ZlstrK r
r
r ÚCheckFetchIter s
zCursorTests.CheckFetchIterc C s@ | j d¡ | j ¡ }| |d d¡ | j ¡ }| |d ¡ d S )Núselect name from testr r. rŠ r~ r
r
r Ú
CheckFetchone¹ s
zCursorTests.CheckFetchonec C s" | j ¡ }| ¡ }| |d ¡ d S r6 )r0 r1 rJ r )r ÚcurrK r
r
r ÚCheckFetchoneNoStatementÀ s
z$CursorTests.CheckFetchoneNoStatementc C sr | | jjd¡ d| j_| j d¡ | j d¡ | j d¡ | j d¡ | j d¡ | j ¡ }| t|ƒd¡ d S )Nr
r£ rl z#insert into test(name) values ('A')z#insert into test(name) values ('B')z#insert into test(name) values ('C')rÉ )r r4 Z arraysizer2 Ú fetchmanyÚlen©r Úresr
r
r ÚCheckArraySizeÅ s
zCursorTests.CheckArraySizec C sD | j d¡ | j d¡}| t|ƒd¡ | j d¡}| |g ¡ d S )NrÉ r° r
©r4 r2 rÍ r rÎ rÏ r
r
r ÚCheckFetchmanyÖ s
zCursorTests.CheckFetchmanyc C s. | j d¡ | j jdd}| t|ƒd¡ dS )z0Checks if fetchmany works with keyword argumentsrÉ r° )Úsizer
NrÒ rÏ r
r
r ÚCheckFetchmanyKwArgÝ s z CursorTests.CheckFetchmanyKwArgc C s@ | j d¡ | j ¡ }| t|ƒd¡ | j ¡ }| |g ¡ d S )NrÉ r
)r4 r2 Úfetchallr rÎ rÏ r
r
r Ú
CheckFetchallã s
zCursorTests.CheckFetchallc C s | j g d¢¡ d S )N)rU é rµ )r4 Z
setinputsizesr r
r
r ÚCheckSetinputsizesê s z CursorTests.CheckSetinputsizesc C s | j dd¡ d S )Nrµ r ©r4 Z
setoutputsizer r
r
r ÚCheckSetoutputsizeí s z CursorTests.CheckSetoutputsizec C s | j d¡ d S rs rÚ r r
r
r ÚCheckSetoutputsizeNoColumnð s z&CursorTests.CheckSetoutputsizeNoColumnc C s | | jj| j¡ d S r6 )r r4 Ú
connectionr0 r r
r
r ÚCheckCursorConnectionó s z!CursorTests.CheckCursorConnectionc C sB | t¡$ dd„ }| j |¡}W d ƒ n1 s40 Y d S )Nc S s d S r6 r
r
r
r
r Úfù rd z/CursorTests.CheckWrongCursorCallable..f)rD ru r0 r1 )r rß rË r
r
r ÚCheckWrongCursorCallable÷ s z$CursorTests.CheckWrongCursorCallablec C sL G dd„ dƒ}|ƒ }| t¡ t |¡}W d ƒ n1 s>0 Y d S )Nc @ s e Zd ZdS )z.CursorTests.CheckCursorWrongClass..FooN)r' r( r) r
r
r
r ÚFooý rd rá )rD ru r ZCursor)r rá r. rË r
r
r ÚCheckCursorWrongClassü s z!CursorTests.CheckCursorWrongClassc C sb d}dD ]T}| j |d4 | j | |¡d¡ | | jjd¡ W d ƒ q1 sR0 Y qdS )zV
INSERT OR REPLACE and REPLACE INTO should produce the same behavior.
z+{} INTO test(id, unique_test) VALUES (?, ?))zINSERT OR REPLACEZREPLACE©Ú statement)r
r. r
N)rg r4 r2 Úformatr r} )r Úsqlrä r
r
r ÚCheckLastRowIDOnReplace s
z#CursorTests.CheckLastRowIDOnReplacec C s@ | j dd¡ | | j jd¡ | j dd¡ | | j jd¡ d S )Nz2insert or ignore into test(unique_test) values (?))Útestr£ )r4 r2 r r} r r
r
r ÚCheckLastRowIDOnIgnore s þþz"CursorTests.CheckLastRowIDOnIgnorec
C sØ g }dD ]¶}d}| j d |¡dŒ | j | |¡|f¡ | || jjf¡ | tj¡& | j | |¡|f¡ W d ƒ n1 s„0 Y | || jjf¡ W d ƒ q1 s´0 Y qg d¢}| ||¡ d S )N)ÚFAILÚABORTÚROLLBACKz.INSERT OR {} INTO test(unique_test) VALUES (?)z INSERT OR {}rã )©rê r£ rí ©rë rU rî ©rì rØ rï )
rg rå r4 r2 rÇ r} rD r r r )r Úresultsrä ræ Zexpectedr
r
r ÚCheckLastRowIDInsertOR s 42z"CursorTests.CheckLastRowIDInsertORN)6r' r( r) r5 r9 rn ro rp rq rr rv rx rz r{ r r r„ r† r‡ r‹ r’ r• r˜ rž r r¡ r¢ rG r¦ r¨ r« r r³ r¾ rÁ rà rÄ rÅ rÈ rÊ rÌ rÑ rÓ rÕ r× rÙ rÛ rÜ rÞ rà râ rç ré rñ r
r
r
r ri Ú sf
ri c @ s\ e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dd„ Z
dd„ Z dd„ Z dS )Ú ThreadTestsc C s( t d¡| _| j ¡ | _| j d¡ d S )Nr+ z\create table test(id integer primary key, name text, bin binary, ratio number, ts timestamp))r r/ rE r1 rË r2 r r
r
r r5 ) s zThreadTests.setUpc C s | j ¡ | j ¡ d S r6 )rË r8 rE r r
r
r r9 . s
zThreadTests.tearDownc C sR dd„ }g }t j|| j|dœd}| ¡ | ¡ t|ƒdkrN| d |¡¡ d S )Nc S sH z| ¡ }| d¡ W d S tjy. Y d S | d¡ Y n0 d S ©Nú did not raise ProgrammingErrorúraised wrong exception)r1 rÇ r r# )rE ÚerrorsrË r
r
r Úrun3 s
z'ThreadTests.CheckConCursor..run©rE rö ©ÚtargetÚkwargsr Ú
©Ú threadingÚThreadrE ÚstartÚjoinrÎ Úfail©r r÷ rö Útr
r
r ÚCheckConCursor2 s
zThreadTests.CheckConCursorc C sR dd„ }g }t j|| j|dœd}| ¡ | ¡ t|ƒdkrN| d |¡¡ d S )Nc S sH z| ¡ | d¡ W d S tjy. Y d S | d¡ Y n0 d S ró )r; rÇ r r# rø r
r
r r÷ E s
z'ThreadTests.CheckConCommit..runrø rù r rü rý r r
r
r ÚCheckConCommitD s
zThreadTests.CheckConCommitc C sR dd„ }g }t j|| j|dœd}| ¡ | ¡ t|ƒdkrN| d |¡¡ d S )Nc S sH z| ¡ | d¡ W d S tjy. Y d S | d¡ Y n0 d S ró )r? rÇ r r# rø r
r
r r÷ W s
z)ThreadTests.CheckConRollback..runrø rù r rü rý r r
r
r ÚCheckConRollbackV s
z ThreadTests.CheckConRollbackc C sR dd„ }g }t j|| j|dœd}| ¡ | ¡ t|ƒdkrN| d |¡¡ d S )Nc S sH z| ¡ | d¡ W d S tjy. Y d S | d¡ Y n0 d S ró ©r8 rÇ r r# rø r
r
r r÷ i s
z&ThreadTests.CheckConClose..runrø rù r rü rý r r
r
r Ú
CheckConCloseh s
zThreadTests.CheckConClosec C sR dd„ }g }t j|| j|dœd}| ¡ | ¡ t|ƒdkrN| d |¡¡ d S )Nc S sJ z| d¡ | d¡ W d S tjy0 Y d S | d¡ Y n0 d S )Nú#insert into test(name) values ('a')rô rõ ©r2 rÇ r r# ©rË rö r
r
r r÷ { s
z.ThreadTests.CheckCurImplicitBegin..runr rù r rü ©rþ rÿ rË r r rÎ r r r
r
r ÚCheckCurImplicitBeginz s
z!ThreadTests.CheckCurImplicitBeginc C sR dd„ }g }t j|| j|dœd}| ¡ | ¡ t|ƒdkrN| d |¡¡ d S )Nc S sH z| ¡ | d¡ W d S tjy. Y d S | d¡ Y n0 d S ró r r r
r
r r÷ s
z&ThreadTests.CheckCurClose..runr rù r rü r
r r
r
r Ú
CheckCurCloseΠs
zThreadTests.CheckCurClosec C s^ dd„ }g }| j d¡ tj|| j |dœd}| ¡ | ¡ t|ƒdkrZ| d |¡¡ d S )Nc S sJ z| d¡ | d¡ W d S tjy0 Y d S | d¡ Y n0 d S )NrÉ rô rõ r r r
r
r r÷ Ÿ s
z(ThreadTests.CheckCurExecute..runr
r rù r rü ©rË r2 rþ rÿ r r rÎ r r r
r
r ÚCheckCurExecutež s
zThreadTests.CheckCurExecutec C sj dd„ }g }| j d¡ | j d¡ tj|| j |dœd}| ¡ | ¡ t|ƒdkrf| d |¡¡ d S ) Nc S sH z| ¡ }| d¡ W d S tjy. Y d S | d¡ Y n0 d S ró )rJ rÇ r r# )rË rö rK r
r
r r÷ ² s
z)ThreadTests.CheckCurIterNext..runr
rÉ r rù r rü r r r
r
r ÚCheckCurIterNext± s
z ThreadTests.CheckCurIterNextN)
r' r( r) r5 r9 r r r r r r r r r
r
r
r rò ( s rò c @ sD e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dS )ÚConstructorTestsc C s t ddd¡}d S )NéÔ r¹ é )r ZDate©r Údr
r
r Ú CheckDateÆ s zConstructorTests.CheckDatec C s t ddd¡}d S )Né é' é# )r ZTime©r r r
r
r Ú CheckTimeÉ s zConstructorTests.CheckTimec C s t dddddd¡}d S )Nr r¹ r r r r )r Z Timestamp©r Útsr
r
r ÚCheckTimestampÌ s z ConstructorTests.CheckTimestampc C s t d¡}d S rs )r Z
DateFromTicksr r
r
r ÚCheckDateFromTicksÏ s z#ConstructorTests.CheckDateFromTicksc C s t d¡}d S rs )r Z
TimeFromTicksr r
r
r ÚCheckTimeFromTicksÒ s z#ConstructorTests.CheckTimeFromTicksc C s t d¡}d S rs )r ZTimestampFromTicksr r
r
r ÚCheckTimestampFromTicksÕ s z(ConstructorTests.CheckTimestampFromTicksc C s t d¡}d S )Ns ')r ZBinary)r Úbr
r
r Ú CheckBinaryØ s z ConstructorTests.CheckBinaryN)
r' r( r) r r r r! r" r# r% r
r
r
r r Å s r c @ sD e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dS )ÚExtensionTestsc C sB t d¡}| ¡ }| d¡ | d¡ | ¡ d }| |d¡ d S )Nr+ z
-- bla bla
/* a stupid comment */
create table a(i);
insert into a(i) values (5);
zselect i from ar rµ )r r/ r1 Ú
executescriptr2 rJ r )r rE rË rÐ r
r
r ÚCheckScriptStringSqlÜ s
z#ExtensionTests.CheckScriptStringSqlc C sL t d¡}| ¡ }| t j¡ | d¡ W d ƒ n1 s>0 Y d S )Nr+ z1create table test(x); asdf; create table test2(x)©r r/ r1 rD r r' ©r rE rË r
r
r ÚCheckScriptSyntaxErroré s
z%ExtensionTests.CheckScriptSyntaxErrorc C sL t d¡}| ¡ }| t j¡ | d¡ W d ƒ n1 s>0 Y d S )Nr+ z5create table test(sadfsadfdsa); select foo from hurz;r) r* r
r
r ÚCheckScriptErrorNormalï s
z%ExtensionTests.CheckScriptErrorNormalc C s\ t d¡}| ¡ }| t¡}| d¡ W d ƒ n1 s<0 Y | t|jƒd¡ d S )Nr+ s9 create table test(foo); insert into test(foo) values (5);z script argument must be unicode.) r r/ r1 rD r€ r' r rY rZ )r rE rË r\ r
r
r Ú CheckCursorExecutescriptAsBytesõ s
(z.ExtensionTests.CheckCursorExecutescriptAsBytesc C s. t d¡}| d¡ ¡ d }| |dd¡ d S )Nr+ zselect 5r rµ z Basic test of Connection.execute)r r/ r2 rJ r ©r rE Úresultr
r
r ÚCheckConnectionExecuteü s
z%ExtensionTests.CheckConnectionExecutec C sb t d¡}| d¡ | dddg¡ | d¡ ¡ }| |d d dd ¡ | |d
d d d ¡ d S ) Nr+ zcreate table test(foo)z insert into test(foo) values (?)r© ©rØ z!select foo from test order by foor rU z$Basic test of Connection.executemanyr
rØ )r r/ r2 rª rÖ r r. r
r
r ÚCheckConnectionExecutemany s
z)ExtensionTests.CheckConnectionExecutemanyc C s8 t d¡}| d¡ | d¡ ¡ d }| |dd¡ d S )Nr+ z9create table test(foo); insert into test(foo) values (5);zselect foo from testr rµ z&Basic test of Connection.executescript)r r/ r' r2 rJ r r. r
r
r Ú CheckConnectionExecutescript s
z+ExtensionTests.CheckConnectionExecutescriptN)
r' r( r) r( r+ r, r- r0 r2 r3 r
r
r
r r& Û s
r& c @ sT e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dd„ Z
dd„ Z dS )ÚClosedConTestsc C sJ t d¡}| ¡ | t j¡ | ¡ }W d ƒ n1 s<0 Y d S ©Nr+ )r r/ r8 rD r# r1 r* r
r
r ÚCheckClosedConCursor s
z#ClosedConTests.CheckClosedConCursorc C sJ t d¡}| ¡ | t j¡ | ¡ W d ƒ n1 s<0 Y d S r5 )r r/ r8 rD r# r; ©r rE r
r
r ÚCheckClosedConCommit s
z#ClosedConTests.CheckClosedConCommitc C sJ t d¡}| ¡ | t j¡ | ¡ W d ƒ n1 s<0 Y d S r5 )r r/ r8 rD r# r? r7 r
r
r ÚCheckClosedConRollback s
z%ClosedConTests.CheckClosedConRollbackc C sT t d¡}| ¡ }| ¡ | t j¡ | d¡ W d ƒ n1 sF0 Y d S )Nr+ zselect 4)r r/ r1 r8 rD r# r2 r* r
r
r ÚCheckClosedCurExecute" s
z$ClosedConTests.CheckClosedCurExecutec C sX t d¡}| ¡ dd„ }| t j¡ | dd|¡ W d ƒ n1 sJ0 Y d S )Nr+ c S s dS ©Nr‚ r
)rŽ r
r
r rß , rd z3ClosedConTests.CheckClosedCreateFunction..fr. r
)r r/ r8 rD r# Zcreate_function)r rE rß r
r
r ÚCheckClosedCreateFunction) s
z(ClosedConTests.CheckClosedCreateFunctionc C s^ t d¡}| ¡ G dd„ dƒ}| t j¡ | dd|¡ W d ƒ n1 sP0 Y d S )Nr+ c @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )z6ClosedConTests.CheckClosedCreateAggregate..Aggc S s d S r6 r
r r
r
r r· 4 s z?ClosedConTests.CheckClosedCreateAggregate..Agg.__init__c S s d S r6 r
r r
r
r Ústep6 s z;ClosedConTests.CheckClosedCreateAggregate..Agg.stepc S s dS r; r
r r
r
r Úfinalize8 s z?ClosedConTests.CheckClosedCreateAggregate..Agg.finalizeN)r' r( r) r· r= r> r
r
r
r ÚAgg3 s r? r. r
)r r/ r8 rD r# Zcreate_aggregate)r rE r? r
r
r ÚCheckClosedCreateAggregate0 s
z)ClosedConTests.CheckClosedCreateAggregatec C sT t d¡}| ¡ dd„ }| t j¡ | |¡ W d ƒ n1 sF0 Y d S )Nr+ c W s t jS r6 )r ZDENY)Úargsr
r
r Ú
authorizer@ s z;ClosedConTests.CheckClosedSetAuthorizer..authorizer)r r/ r8 rD r# Zset_authorizer)r rE rB r
r
r ÚCheckClosedSetAuthorizer= s
z'ClosedConTests.CheckClosedSetAuthorizerc C sV t d¡}| ¡ dd„ }| t j¡ | |d¡ W d ƒ n1 sH0 Y d S )Nr+ c S s d S r6 r
r
r
r
r ÚprogressH rd z?ClosedConTests.CheckClosedSetProgressCallback..progressr° )r r/ r8 rD r# Zset_progress_handler)r rE rD r
r
r Ú CheckClosedSetProgressCallbackE s
z-ClosedConTests.CheckClosedSetProgressCallbackc C sH t d¡}| ¡ | t j¡ |ƒ W d ƒ n1 s:0 Y d S r5 )r r/ r8 rD r# r7 r
r
r ÚCheckClosedCallL s
z ClosedConTests.CheckClosedCallN) r' r( r) r6 r8 r9 r: r< r@ rC rE rF r
r
r
r r4 s
r4 c @ s e Zd Zdd„ ZdS )ÚClosedCurTestsc C sŽ t d¡}| ¡ }| ¡ dD ]j}|dv r0d}n|dkrFdddgf}ng }| t j¡" t||ƒ}||Ž W d ƒ q 1 s~0 Y q d S ) Nr+ )r2 rª r' rÖ rÍ rJ )r2 r' )zselect 4 union select 5rª z insert into foo(bar) values (?)r© r1 )r r/ r1 r8 rD r# Úgetattr)r rE rË Z method_nameÚparamsÚmethodr
r
r Ú CheckClosedS s
zClosedCurTests.CheckClosedN)r' r( r) rK r
r
r
r rG R s rG c @ sX e Zd ZdZdd„ Zdd„ Zdd„ Zdd „ Zd
d „ Zd d
„ Z dd„ Z
dd„ Z dd„ Z dS )ÚSqliteOnConflictTestszz
Tests for SQLite's "insert on conflict" feature.
See https://www.sqlite.org/lang_conflict.html for details.
c C s( t d¡| _| j ¡ | _| j d¡ d S )Nr+ zz
CREATE TABLE test(
id INTEGER PRIMARY KEY, name TEXT, unique_name TEXT UNIQUE
);
rj r r
r
r r5 l s zSqliteOnConflictTests.setUpc C s | j ¡ | j ¡ d S r6 rk r r
r
r r9 u s
z SqliteOnConflictTests.tearDownc C sœ d | j _| j ¡ | _| j d¡ | j d¡ | j d¡ | tj¡ | j d¡ W d ƒ n1 sf0 Y | j ¡ | j d¡ | | j
¡ g ¡ d S )NÚBEGINú,INSERT INTO test(name) VALUES ('abort_test')ú8INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')z"SELECT name, unique_name from test© r0 rb r1 r4 r2 rD r r r; r rÖ r r
r
r Ú.CheckOnConflictRollbackWithExplicitTransactiony s *
zDSqliteOnConflictTests.CheckOnConflictRollbackWithExplicitTransactionc C s d | j _| j ¡ | _| j d¡ | j d¡ | j d¡ | tj¡ | j d¡ W d ƒ n1 sf0 Y | j ¡ | j d¡ | | j
¡ ddg¡ d S )NrM rN ú5INSERT OR ABORT INTO test(unique_name) VALUES ('foo')ú"SELECT name, unique_name FROM test©Z
abort_testNr™ rP r r
r
r Ú2CheckOnConflictAbortRaisesWithExplicitTransactionsˆ s *
zHSqliteOnConflictTests.CheckOnConflictAbortRaisesWithExplicitTransactionsc C sr | j d¡ | j d¡ | tj¡ | j d¡ W d ƒ n1 sF0 Y | j d¡ | | j ¡ g ¡ d S )NrN rO rS ©r4 r2 rD r r r rÖ r r
r
r Ú)CheckOnConflictRollbackWithoutTransaction˜ s * z?SqliteOnConflictTests.CheckOnConflictRollbackWithoutTransactionc C sv | j d¡ | j d¡ | tj¡ | j d¡ W d ƒ n1 sF0 Y | j d¡ | | j ¡ ddg¡ d S )NrN rR rS rT r™ rV r r
r
r Ú-CheckOnConflictAbortRaisesWithoutTransactions¢ s * zCSqliteOnConflictTests.CheckOnConflictAbortRaisesWithoutTransactionsc C sZ | j d¡ | tj¡ | j d¡ W d ƒ n1 s:0 Y | | j ¡ g ¡ d S )Nz4INSERT OR FAIL INTO test(unique_name) VALUES ('foo')rV r r
r
r ÚCheckOnConflictFail s *z)SqliteOnConflictTests.CheckOnConflictFailc C s< | j d¡ | j d¡ | j d¡ | | j ¡ dg¡ d S )Nz6INSERT OR IGNORE INTO test(unique_name) VALUES ('foo')z SELECT unique_name FROM testr- ©r4 r2 r rÖ r r
r
r ÚCheckOnConflictIgnore³ s z+SqliteOnConflictTests.CheckOnConflictIgnorec C s< | j d¡ | j d¡ | j d¡ | | j ¡ dg¡ d S )NzFINSERT OR REPLACE INTO test(name, unique_name) VALUES ('Data!', 'foo')zUINSERT OR REPLACE INTO test(name, unique_name) VALUES ('Very different data!', 'foo')rS )zVery different data!r. rZ r r
r
r ÚCheckOnConflictReplaceº s z,SqliteOnConflictTests.CheckOnConflictReplaceN)
r' r( r) Ú__doc__r5 r9 rQ rU rW rX rY r[ r\ r
r
r
r rL e s
rL c @ s$ e Zd Zed Zdd„ Zdd„ ZdS )ÚMultiprocessTestsg @@c C s t tƒ d S r6 )r r r r
r
r r9 Å s zMultiprocessTests.tearDownc
C sN dt › d| j› d}tjtjd|gddtjtjd}| |j¡ | d|j
¡ ¡ ¡ t
jt | jd }z‚z2| | d
¡ W d ƒ n1 sŽ0 Y W n6 t
jyÐ } z |j t|ƒ¡ W Y d }~nd }~0 0 |j d ¡ W | ¡ n
| ¡ 0 | |j¡ z|jd td
W n( tjy: | ¡ | ¡ ‚ Y n0 | |jd¡ d S )Nz´if 1:
import sqlite3
def wait():
print("started")
assert "database is locked" in input()
cx = sqlite3.connect("z ", timeout=aÊ )
cx.create_function("wait", 0, wait)
with cx:
cx.execute("create table t(t)")
try:
# execute two transactions; both will try to lock the db
cx.executescript('''
-- start a transaction and wait for parent
begin transaction;
select * from t;
select wait();
rollback;
-- start a new transaction; would fail if parent holds lock
begin transaction;
select * from t;
rollback;
''')
finally:
cx.close()
z-czutf-8r )ÚencodingÚbufsizeÚstdinÚstdoutÚstarted)Útimeoutz insert into t values('test')zno errorÚend)Úinputrd )r ÚCONNECTION_TIMEOUTÚ
subprocessÚPopenÚsysÚ
executableÚPIPErR Ú communicater rb ÚreadlineÚstripr r/ r2 r ra ÚwriterY r8 Z assertIsNoneÚ
returncoder ÚTimeoutExpiredÚkill)r ZSCRIPTÚprocr0 Úexcr
r
r Ú&test_ctx_mgr_rollback_if_commit_failedÈ s< úú
û ,& z8MultiprocessTests.test_ctx_mgr_rollback_if_commit_failedN)r' r( r) r rg r9 rv r
r
r
r r^ Â s r^ c
C s t td¡} t td¡}t td¡}t td¡}t td¡}t td¡}t td¡}t t d¡}t t
d¡}t t ¡} t t ¡}
t
| ||||||||| |
f ¡S )NZCheck)r^ Z makeSuiter r* ri rò r r& r4 rG rL r_ r^ Z TestSuite) Z module_suiteZconnection_suiteZ cursor_suiteZ thread_suiteZconstructor_suiteZ ext_suiteZclosed_con_suiteZclosed_cur_suiteZon_conflict_suiteZuninit_con_suiteZmultiproc_con_suiter
r
r Úsuite s
ýrw c C s t ¡ } | tƒ ¡ d S r6 )r^ ZTextTestRunnerr÷ rw )Zrunnerr
r
r rè s rè Ú__main__)rh rþ r^ Zsqlite3r rj Z test.supportr r r ZTestCaser r* r_ ri rò r r& r4 rG rL r^ rw rè r' r
r
r
r Ú s. 7n P 4C]G