
\Kc           @   s  d  d k  Z  d  d k Z d  d k Z d e  i f d     YZ d e  i f d     YZ d e  i f d     YZ d e  i f d	     YZ d
 e  i f d     YZ	 d e  i f d     YZ
 d e  i f d     YZ d   Z d   Z e d j o e   n d S(   iNt   ModuleTestsc           B   s}   e  Z d    Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z	 d   Z
 d	   Z d
   Z d   Z d   Z RS(   c         C   s!   |  i  t i d d t i  d  S(   Ns   2.0s   apilevel is %s, should be 2.0(   t   assertEqualt   sqlitet   apilevel(   t   self(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckAPILevel   s    c         C   s!   |  i  t i d d t i  d  S(   Ni   s   threadsafety is %d, should be 1(   R   R   t   threadsafety(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckThreadSafety!   s    c         C   s!   |  i  t i d d t i  d  S(   Nt   qmarks%   paramstyle is '%s', should be 'qmark'(   R   R   t
   paramstyle(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckParamStyle%   s    c         C   s    |  i  t t i t  d  d  S(   Ns*   Warning is not a subclass of StandardError(   t   assert_t
   issubclassR   t   Warningt   StandardError(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckWarning*   s    c         C   s    |  i  t t i t  d  d  S(   Ns(   Error is not a subclass of StandardError(   t
   failUnlessR   R   t   ErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt
   CheckError.   s    c         C   s#   |  i  t t i t i  d  d  S(   Ns)   InterfaceError is not a subclass of Error(   R   R   R   t   InterfaceErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckInterfaceError2   s    c         C   s#   |  i  t t i t i  d  d  S(   Ns(   DatabaseError is not a subclass of Error(   R   R   R   t   DatabaseErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckDatabaseError6   s    c         C   s#   |  i  t t i t i  d  d  S(   Ns,   DataError is not a subclass of DatabaseError(   R   R   R   t	   DataErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckDataError:   s    c         C   s#   |  i  t t i t i  d  d  S(   Ns3   OperationalError is not a subclass of DatabaseError(   R   R   R   t   OperationalErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckOperationalError>   s    c         C   s#   |  i  t t i t i  d  d  S(   Ns1   IntegrityError is not a subclass of DatabaseError(   R   R   R   t   IntegrityErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckIntegrityErrorB   s    c         C   s#   |  i  t t i t i  d  d  S(   Ns0   InternalError is not a subclass of DatabaseError(   R   R   R   t   InternalErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckInternalErrorF   s    c         C   s#   |  i  t t i t i  d  d  S(   Ns3   ProgrammingError is not a subclass of DatabaseError(   R   R   R   t   ProgrammingErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckProgrammingErrorJ   s    c         C   s#   |  i  t t i t i  d  d  S(   Ns4   NotSupportedError is not a subclass of DatabaseError(   R   R   R   t   NotSupportedErrorR   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckNotSupportedErrorN   s    	(   t   __name__t
   __module__R   R   R
   R   R   R   R   R   R   R   R   R    R"   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR       s   												t   ConnectionTestsc           B   sb   e  Z d    Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z	 d   Z
 d	   Z RS(
   c         C   sB   t  i d  |  _ |  i i   } | i d  | i d d  d  S(   Ns   :memory:s4   create table test(id integer primary key, name text)s!   insert into test(name) values (?)t   foo(   s   foo(   R   t   connectt   cxt   cursort   execute(   R   t   cu(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   setUpT   s    c         C   s   |  i  i   d  S(   N(   R(   t   close(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   tearDownZ   s    c         C   s   |  i  i   d  S(   N(   R(   t   commit(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCommit]   s    c         C   s   |  i  i   |  i  i   d S(   sV   
        A commit should also work when no changes were made to the database.
        N(   R(   R/   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCommitAfterNoChanges`   s    c         C   s   |  i  i   d  S(   N(   R(   t   rollback(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckRollbackg   s    c         C   s   |  i  i   |  i  i   d S(   sX   
        A rollback should also work when no changes were made to the database.
        N(   R(   R2   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckRollbackAfterNoChangesj   s    c         C   s   |  i  i   } d  S(   N(   R(   R)   (   R   R+   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCursorq   s    c         C   sG   d } y t  i |  } Wn t  i j
 o d  Sn X|  i d  d  S(   Ns   /foo/bar/bla/23534/mydb.dbs&   should have raised an OperationalError(   R   R'   R   t   fail(   R   t   YOU_CANNOT_OPEN_THISt   con(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckFailedOpent   s    	c         C   s   |  i  i   d  S(   N(   R(   R-   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt
   CheckClose|   s    c         C   s   |  i  |  i i t i  |  i  |  i i t i  |  i  |  i i t i  |  i  |  i i t i  |  i  |  i i t i  |  i  |  i i t i  |  i  |  i i	 t i	  |  i  |  i i
 t i
  |  i  |  i i t i  |  i  |  i i t i  d  S(   N(   t   failUnlessEqualR(   R   R   R   R   R   R   R   R   R   R   R!   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExceptions   s    (   R#   R$   R,   R.   R0   R1   R3   R4   R5   R9   R:   R<   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR%   S   s   									t   CursorTestsc           B   sp  e  Z d    Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z	 d   Z
 d	   Z d
   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z  d   Z! d    Z" d!   Z# d"   Z$ d#   Z% d$   Z& d%   Z' d&   Z( d'   Z) RS((   c         C   sK   t  i d  |  _ |  i i   |  _ |  i i d  |  i i d d  d  S(   Ns   :memory:sC   create table test(id integer primary key, name text, income number)s!   insert into test(name) values (?)R&   (   s   foo(   R   R'   R(   R)   R+   R*   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR,      s    c         C   s   |  i  i   |  i i   d  S(   N(   R+   R-   R(   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR.      s    c         C   s   |  i  i d  d  S(   Ns   delete from test(   R+   R*   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteNoArgs   s    c         C   sU   y! |  i  i d  |  i d  Wn- t i j
 o d  Sn |  i d  n Xd  S(   Ns   select asdfs&   should have raised an OperationalErrors   raised wrong exception(   R+   R*   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteIllegalSql   s    c         C   sU   y! |  i  i d  |  i d  Wn- t i j
 o d  Sn |  i d  n Xd  S(   Ns   select 5+4; select 4+5s   should have raised a Warnings   raised wrong exception(   R+   R*   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteTooMuchSql   s    c         C   s   |  i  i d  d  S(   Ns   select 5+4; -- foo bar(   R+   R*   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteTooMuchSql2   s    c         C   s   |  i  i d  d  S(   NsT   
            select 5+4;

            /*
            foo
            */
            (   R+   R*   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteTooMuchSql3   s    	c         C   sR   y! |  i  i d  |  i d  Wn* t j
 o d  Sn |  i d  n Xd  S(   Ni*   s   should have raised a ValueErrors   raised wrong exception.(   R+   R*   R6   t
   ValueError(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteWrongSqlArg   s    c         C   s   |  i  i d d  d  S(   Ns   insert into test(id) values (?)i*   (   i*   (   R+   R*   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteArgInt   s    c         C   s   |  i  i d d  d  S(   Ns#   insert into test(income) values (?)gq=
ף@(   gq=
ף@(   R+   R*   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteArgFloat   s    c         C   s   |  i  i d d  d  S(   Ns!   insert into test(name) values (?)t   Hugo(   RG   (   R+   R*   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteArgString   s    c         C   sA   y$ |  i  i d d  |  i d  Wn t i j
 o n Xd  S(   Ns   insert into test(id) values (?)i   t   Egons#   should have raised ProgrammingError(   i   RI   (   R+   R*   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteWrongNoOfArgs1   s
    c         C   s>   y! |  i  i d  |  i d  Wn t i j
 o n Xd  S(   Ns   insert into test(id) values (?)s#   should have raised ProgrammingError(   R+   R*   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteWrongNoOfArgs2   s
    c         C   s>   y! |  i  i d  |  i d  Wn t i j
 o n Xd  S(   Ns   insert into test(id) values (?)s#   should have raised ProgrammingError(   R+   R*   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteWrongNoOfArgs3   s
    c         C   sS   |  i  i d  |  i  i d h  d d < |  i  i   } |  i | d d  d  S(   Ns%   insert into test(name) values ('foo')s&   select name from test where name=:nameR&   t   namei    (   R+   R*   t   fetchoneR;   (   R   t   row(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteDictMapping   s    c      	   C   sZ   |  i  i d  y- |  i  i d h  d d < |  i d  Wn t i j
 o n Xd  S(   Ns%   insert into test(name) values ('foo')s1   select name from test where name=:name and id=:idR&   RM   s#   should have raised ProgrammingError(   R+   R*   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt$   CheckExecuteDictMappingTooLittleArgs   s    c         C   sN   |  i  i d  y! |  i  i d  |  i d  Wn t i j
 o n Xd  S(   Ns%   insert into test(name) values ('foo')s&   select name from test where name=:names#   should have raised ProgrammingError(   R+   R*   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteDictMappingNoArgs   s    c      	   C   sZ   |  i  i d  y- |  i  i d h  d d < |  i d  Wn t i j
 o n Xd  S(   Ns%   insert into test(name) values ('foo')s"   select name from test where name=?R&   RM   s#   should have raised ProgrammingError(   R+   R*   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteDictMappingUnnamed   s    c         C   s   |  i  i   d  S(   N(   R+   R-   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR:      s    c         C   sZ   |  i  i d  |  i  i d  |  i  i d  |  i  i d  |  i |  i  i d  d  S(   Ns   delete from tests%   insert into test(name) values ('foo')s   update test set name='bar'i   (   R+   R*   R;   t   rowcount(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckRowcountExecute  s
    c         C   sF   |  i  i d  |  i  i d d d d g  |  i |  i  i d  d  S(	   Ns   delete from tests!   insert into test(name) values (?)i   i   i   (   i   (   i   (   i   (   R+   R*   t   executemanyR;   RT   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckRowcountExecutemany
  s    c         C   sH   |  i  i d  |  i  i d  |  i i d j  o |  i d  n d  S(   Ns%   insert into test(name) values ('foo')i   s"   total changes reported wrong value(   R+   R*   R(   t   total_changesR6   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckTotalChanges  s    c         C   s>   |  i  i d g  } t d d  D] } | | f q  ~  d  S(   Ns#   insert into test(income) values (?)id   in   (   R+   RV   t   range(   R   t   _[1]t   x(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteManySequence  s    c         C   s-   d d d     Y} |  i  i d |    d  S(   Nt   MyIterc           B   s   e  Z d    Z d   Z RS(   c         S   s   d |  _  d  S(   Ni   (   t   value(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   __init__  s    c         S   s7   |  i  d j o
 t  n |  i  d 7_  |  i  f Sd  S(   Ni
   i   (   R_   t   StopIteration(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   next!  s    
(   R#   R$   R`   Rb   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR^     s   	s#   insert into test(income) values (?)(    (   R+   RV   (   R   R^   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteManyIterator  s    c         C   s#   d   } |  i  i d |    d  S(   Nc          s   s#   x t  d  D] }  |  f Vq Wd  S(   Ni   (   RZ   (   t   i(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   mygen+  s     s#   insert into test(income) values (?)(   R+   RV   (   R   Re   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteManyGenerator*  s    	c         C   sX   y' |  i  i d d g  |  i d  Wn* t j
 o d  Sn |  i d  n Xd  S(   Ni*   i   s   should have raised a ValueErrors   raised wrong exception.(   i   (   R+   RV   R6   RC   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteManyWrongSqlArg1  s    c         C   s[   y' |  i  i d d g  |  i d  Wn- t i j
 o d  Sn |  i d  n Xd  S(   Ns   select ?i   s%   should have raised a ProgrammingErrors   raised wrong exception.(   i   (   R+   RV   R6   R   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteManySelect:  s    c         C   so   y$ |  i  i d d  |  i d  WnD t j
 o d  Sn/ t j
 o" } d G| i GH|  i d  n Xd  S(   Ns#   insert into test(income) values (?)i*   s   should have raised a TypeErrort   raiseds   raised wrong exception.(   R+   RV   R6   t	   TypeErrort	   Exceptiont	   __class__(   R   t   e(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckExecuteManyNotIterableC  s    c         C   s   |  i  i d  |  i  i d d  |  i  i d d	  |  i  i d  g  } x" |  i  D] } | i | d  qV W|  i | d d  |  i | d d  d  S(
   Ns   delete from tests   insert into test(id) values (?)i   i   s   select id from test order by idi    i   (   i   (   i   (   R+   R*   t   appendR;   (   R   t   lstRO   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckFetchIterM  s    
 c         C   sV   |  i  i d  |  i  i   } |  i | d d  |  i  i   } |  i | d   d  S(   Ns   select name from testi    R&   (   R+   R*   RN   R;   t   None(   R   RO   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckFetchoneY  s
    c         C   s/   |  i  i   } | i   } |  i | d   d  S(   N(   R(   R)   RN   R;   Rr   (   R   t   curRO   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckFetchoneNoStatement`  s    c         C   s   |  i  |  i i d  d |  i _ |  i i d  |  i i d  |  i i d  |  i i d  |  i i d  |  i i   } |  i  t |  d  d  S(   Ni   i   s   delete from tests#   insert into test(name) values ('A')s#   insert into test(name) values ('B')s#   insert into test(name) values ('C')s   select name from test(   R;   R+   t	   arraysizeR*   t	   fetchmanyt   len(   R   t   res(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckArraySizee  s    c         C   s^   |  i  i d  |  i  i d  } |  i t |  d  |  i  i d  } |  i | g   d  S(   Ns   select name from testid   i   (   R+   R*   Rw   R;   Rx   (   R   Ry   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckFetchmanyv  s
    c         C   sX   |  i  i d  |  i  i   } |  i t |  d  |  i  i   } |  i | g   d  S(   Ns   select name from testi   (   R+   R*   t   fetchallR;   Rx   (   R   Ry   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckFetchall}  s
    c         C   s   |  i  i d d d g  d  S(   Ni   i   i   (   R+   t   setinputsizes(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckSetinputsizes  s    c         C   s   |  i  i d d  d  S(   Ni   i    (   R+   t   setoutputsize(   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckSetoutputsize  s    c         C   s   |  i  i d  d  S(   Ni*   (   R+   R   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckSetoutputsizeNoColumn  s    c         C   s   |  i  |  i i |  i  d  S(   N(   R;   R+   t
   connectionR(   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCursorConnection  s    c         C   sW   y, d   } |  i  i |  } |  i d  Wn t j
 o d  Sn X|  i d  d  S(   Nc           S   s   d  S(   N(    (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   f  s    s   should have raised a TypeErrors   should have raised a ValueError(   R(   R)   R6   Rj   (   R   R   Rt   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckWrongCursorCallable  s    		c         C   sV   d d d     Y} |   } y  t  i |  } |  i d  Wn t j
 o n Xd  S(   Nt   Fooc           B   s   e  Z RS(    (   R#   R$   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s    s   should have raised a ValueError(    (   R   t   CursorR6   Rj   (   R   R   R&   Rt   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCursorWrongClass  s    	(*   R#   R$   R,   R.   R>   R?   R@   RA   RB   RD   RE   RF   RH   RJ   RK   RL   RP   RQ   RR   RS   R:   RU   RW   RY   R]   Rc   Rf   Rg   Rh   Rn   Rq   Rs   Ru   Rz   R{   R}   R   R   R   R   R   R   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR=      sP   																										
								
												t   ThreadTestsc           B   sb   e  Z d    Z d   Z d   Z d   Z d   Z d   Z d   Z d   Z	 d   Z
 d	   Z RS(
   c         C   s8   t  i d  |  _ |  i i   |  _ |  i i d  d  S(   Ns   :memory:s\   create table test(id integer primary key, name text, bin binary, ratio number, ts timestamp)(   R   R'   R8   R)   Rt   R*   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR,     s    c         C   s   |  i  i   |  i i   d  S(   N(   Rt   R-   R8   (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR.     s    c         C   s   d   } g  } t  i d | d h  |  i d <| d < } | i   | i   t |  d j o |  i d i |   n d  S(   Nc         S   sU   y! |  i    } | i d  d  SWn- t i j
 o d  Sn | i d  n Xd  S(   Ns   did not raise ProgrammingErrors   raised wrong exception(   R)   Ro   R   R   (   R8   t   errorsRt   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   run  s    t   targett   kwargsR8   R   i    s   
(   t	   threadingt   ThreadR8   t   startt   joinRx   R6   (   R   R   R   t   t(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckConCursor  s    	
-

c         C   s   d   } g  } t  i d | d h  |  i d <| d < } | i   | i   t |  d j o |  i d i |   n d  S(   Nc         S   sS   y |  i    | i d  d  SWn- t i j
 o d  Sn | i d  n Xd  S(   Ns   did not raise ProgrammingErrors   raised wrong exception(   R/   Ro   R   R   (   R8   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s    
R   R   R8   R   i    s   
(   R   R   R8   R   R   Rx   R6   (   R   R   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckConCommit  s    	
-

c         C   s   d   } g  } t  i d | d h  |  i d <| d < } | i   | i   t |  d j o |  i d i |   n d  S(   Nc         S   sS   y |  i    | i d  d  SWn- t i j
 o d  Sn | i d  n Xd  S(   Ns   did not raise ProgrammingErrors   raised wrong exception(   R2   Ro   R   R   (   R8   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s    
R   R   R8   R   i    s   
(   R   R   R8   R   R   Rx   R6   (   R   R   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckConRollback  s    	
-

c         C   s   d   } g  } t  i d | d h  |  i d <| d < } | i   | i   t |  d j o |  i d i |   n d  S(   Nc         S   sS   y |  i    | i d  d  SWn- t i j
 o d  Sn | i d  n Xd  S(   Ns   did not raise ProgrammingErrors   raised wrong exception(   R-   Ro   R   R   (   R8   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s    
R   R   R8   R   i    s   
(   R   R   R8   R   R   Rx   R6   (   R   R   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckConClose  s    	
-

c         C   s   d   } g  } t  i d | d h  |  i d <| d < } | i   | i   t |  d j o |  i d i |   n d  S(   Nc         S   sV   y" |  i  d  | i d  d  SWn- t i j
 o d  Sn | i d  n Xd  S(   Ns#   insert into test(name) values ('a')s   did not raise ProgrammingErrors   raised wrong exception(   R*   Ro   R   R   (   Rt   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s    R   R   Rt   R   i    s   
(   R   R   Rt   R   R   Rx   R6   (   R   R   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCurImplicitBegin  s    	
-

c         C   s   d   } g  } t  i d | d h  |  i d <| d < } | i   | i   t |  d j o |  i d i |   n d  S(   Nc         S   sS   y |  i    | i d  d  SWn- t i j
 o d  Sn | i d  n Xd  S(   Ns   did not raise ProgrammingErrors   raised wrong exception(   R-   Ro   R   R   (   Rt   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s    
R   R   Rt   R   i    s   
(   R   R   Rt   R   R   Rx   R6   (   R   R   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCurClose  s    	
-

c         C   s   d   } g  } |  i  i d  t i d | d h  |  i  d <| d < } | i   | i   t |  d j o |  i d i |   n d  S(	   Nc         S   sV   y" |  i  d  | i d  d  SWn- t i j
 o d  Sn | i d  n Xd  S(   Ns   select name from tests   did not raise ProgrammingErrors   raised wrong exception(   R*   Ro   R   R   (   Rt   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s    s#   insert into test(name) values ('a')R   R   Rt   R   i    s   
(   Rt   R*   R   R   R   R   Rx   R6   (   R   R   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCurExecute  s    	
-

c         C   s   d   } g  } |  i  i d  |  i  i d  t i d | d h  |  i  d <| d < } | i   | i   t |  d j o |  i d	 i |   n d  S(
   Nc         S   sU   y! |  i    } | i d  d  SWn- t i j
 o d  Sn | i d  n Xd  S(   Ns   did not raise ProgrammingErrors   raised wrong exception(   RN   Ro   R   R   (   Rt   R   RO   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR   -  s    s#   insert into test(name) values ('a')s   select name from testR   R   Rt   R   i    s   
(   Rt   R*   R   R   R   R   Rx   R6   (   R   R   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckCurIterNext,  s    	
-

(   R#   R$   R,   R.   R   R   R   R   R   R   R   R   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s   									t   ConstructorTestsc           B   sG   e  Z d    Z d   Z d   Z d   Z d   Z d   Z d   Z RS(   c         C   s   t  i d d d  } d  S(   Ni  i
   i   (   R   t   Date(   R   t   d(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt	   CheckDateA  s    c         C   s   t  i d d d  } d  S(   Ni   i'   i#   (   R   t   Time(   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt	   CheckTimeD  s    c         C   s"   t  i d d d d d d  } d  S(   Ni  i
   i   i   i'   i#   (   R   t	   Timestamp(   R   t   ts(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckTimestampG  s    c         C   s   t  i d  } d  S(   Ni*   (   R   t   DateFromTicks(   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckDateFromTicksJ  s    c         C   s   t  i d  } d  S(   Ni*   (   R   t   TimeFromTicks(   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckTimeFromTicksM  s    c         C   s   t  i d  } d  S(   Ni*   (   R   t   TimestampFromTicks(   R   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckTimestampFromTicksP  s    c         C   s   t  i t d  d  } d  S(   Ni    t   '(   R   t   Binaryt   chr(   R   t   b(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckBinaryS  s    (	   R#   R$   R   R   R   R   R   R   R   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR   @  s   						t   ExtensionTestsc           B   sG   e  Z d    Z d   Z d   Z d   Z d   Z d   Z d   Z RS(   c         C   sY   t  i d  } | i   } | i d  | i d  | i   d } |  i | d  d  S(   Ns   :memory:s   
            -- bla bla
            /* a stupid comment */
            create table a(i);
            insert into a(i) values (5);
            s   select i from ai    i   (   R   R'   R)   t   executescriptR*   RN   R;   (   R   R8   Rt   Ry   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckScriptStringSqlW  s    c         C   sY   t  i d  } | i   } | i d  | i d  | i   d } |  i | d  d  S(   Ns   :memory:u   
            create table a(i);
            insert into a(i) values (5);
            select i from a;
            delete from a;
            insert into a(i) values (6);
            s   select i from ai    i   (   R   R'   R)   R   R*   RN   R;   (   R   R8   Rt   Ry   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckScriptStringUnicoded  s    c         C   sh   t  i d  } | i   } t } y | i d  Wn t  i j
 o t } n X|  i | t d  d  S(   Ns   :memory:s   create table test(sadfsadfdsas   should have raised an exception(   R   R'   R)   t   FalseR   R   t   TrueR;   (   R   R8   Rt   Ri   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckScriptErrorIncompleter  s    c         C   sh   t  i d  } | i   } t } y | i d  Wn t  i j
 o t } n X|  i | t d  d  S(   Ns   :memory:s5   create table test(sadfsadfdsa); select foo from hurz;s   should have raised an exception(   R   R'   R)   R   R   R   R   R;   (   R   R8   Rt   Ri   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckScriptErrorNormal|  s    c         C   s?   t  i d  } | i d  i   d } |  i | d d  d  S(   Ns   :memory:s   select 5i    i   s    Basic test of Connection.execute(   R   R'   R*   RN   R;   (   R   R8   t   result(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckConnectionExecute  s    c         C   s   t  i d  } | i d  | i d d
 d g  | i d  i   } |  i | d d d d  |  i | d	 d d d  d  S(   Ns   :memory:s   create table test(foo)s    insert into test(foo) values (?)i   i   s!   select foo from test order by fooi    s$   Basic test of Connection.executemanyi   (   i   (   i   (   R   R'   R*   RV   R|   R;   (   R   R8   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckConnectionExecutemany  s    c         C   sL   t  i d  } | i d  | i d  i   d } |  i | d d  d  S(   Ns   :memory:s9   create table test(foo); insert into test(foo) values (5);s   select foo from testi    i   s&   Basic test of Connection.executescript(   R   R'   R   R*   RN   R;   (   R   R8   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckConnectionExecutescript  s    (	   R#   R$   R   R   R   R   R   R   R   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR   V  s   			
	
		t   ClosedTestsc           B   s>   e  Z d    Z d   Z d   Z d   Z d   Z d   Z RS(   c         C   s   d  S(   N(    (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR,     s    c         C   s   d  S(   N(    (   R   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR.     s    c         C   sf   t  i d  } | i   y | i   } |  i d  Wn) t  i j
 o n |  i d  n Xd  S(   Ns   :memory:s%   Should have raised a ProgrammingError(   R   R'   R-   R)   R6   R   (   R   R8   Rt   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckClosedConCursor  s    
c         C   sd   t  i d  } | i   y | i   |  i d  Wn) t  i j
 o n |  i d  n Xd  S(   Ns   :memory:s%   Should have raised a ProgrammingError(   R   R'   R-   R/   R6   R   (   R   R8   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckClosedConCommit  s    

c         C   sd   t  i d  } | i   y | i   |  i d  Wn) t  i j
 o n |  i d  n Xd  S(   Ns   :memory:s%   Should have raised a ProgrammingError(   R   R'   R-   R2   R6   R   (   R   R8   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckClosedConRollback  s    

c         C   ss   t  i d  } | i   } | i   y | i d  |  i d  Wn) t  i j
 o n |  i d  n Xd  S(   Ns   :memory:s   select 4s%   Should have raised a ProgrammingError(   R   R'   R)   R-   R*   R6   R   (   R   R8   Rt   (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   CheckClosedCurExecute  s    
(   R#   R$   R,   R.   R   R   R   R   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyR     s   					c          C   s   t  i t d  }  t  i t d  } t  i t d  } t  i t d  } t  i t d  } t  i t d  } t  i t d  } t  i	 |  | | | | | | f  S(   Nt   Check(
   t   unittestt	   makeSuiteR    R%   R=   R   R   R   R   t	   TestSuite(   t   module_suitet   connection_suitet   cursor_suitet   thread_suitet   constructor_suitet	   ext_suitet   closed_suite(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   suite  s    c          C   s    t  i   }  |  i t    d  S(   N(   R   t   TextTestRunnerR   R   (   t   runner(    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pyt   test  s    t   __main__(   R   R   t   sqlite3R   t   TestCaseR    R%   R=   R   R   R   R   R   R   R#   (    (    (    s(   /usr/lib/python2.5/sqlite3/test/dbapi.pys   <module>   s   79 C4	
	