Format: application/x-python-code
1 o
2
3 ��h�� � @ s\ d Z ddlZddlZddlZddlZddlZddlZddlZddlZ ddl
4 Z
5 ddl Z ddl m
6 Z dd� ZG dd� dej�ZG dd� de�ZG d d
7 � d
8 e�ZG d d � d e�ZG d
9 d� de�ZG dd� dej�ZG dd� de�ZG dd� de�Zej�ed�gZe j r�e� ej�ed�� e j r�e� ej�ed�� e j r�e� ej�ed�� e j r�e� ej�ed�� e j!r�e� ej�ed�� G dd� d�Z"e�#e�Z$e%dk�r,e�&e$�Z'e"� �H e j(Z)e*e � e*de)f � e)Z(e�+� �,e'� e j �re�&e$�Z'e�-� e j _(e*d� e*e j j(� e�+� �,e'� W d � dS W d � dS 1 �s%w Y dS dS )z'Unit tests version 2.6.1.0 for adodbapi� Nc C s d� dd� td�D ��S )N� c S s g | ]}t �tj��qS � )�random�choice�string�
10 ascii_letters)�.0�nr r �Pc:\Users\shubh\Videos\agent\nova\Lib\site-packages\adodbapi/test/adodbapitest.py�
11 <listcomp>) s z randomstring.<locals>.<listcomp>� )�join�range)�lengthr r r
12 � randomstring( � r c @ sx e Zd ZdZdd� Zdd� Zdd� Zdd � Zd
13 d � Zd d
14 � Z dd� Z
15 dd� Z dd� Z dd� Z
16 dd� Z d[dd�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/dS )\�
17 CommonDBTestszdSelf contained super-simple tests in easy syntax, should work on everything between mySQL and Oraclec C s
18 d| _ d S )N�unknown��engine��selfr r r
19 �setUp/ s
20 zCommonDBTests.setUpc C � | j S �Nr r r r r
21 � getEngine2 � zCommonDBTests.getEnginec C s t �r ��NotImplementedErrorr r r r
22 �
23 getConnection5 � zCommonDBTests.getConnectionc C s | � � �� S r )r �cursorr r r r
24 � getCursor8 � zCommonDBTests.getCursorc C s | � � }|jjdks J �d S )NZCursor)r" � __class__�__name__�r �crsrr r r
25 �testConnection; s z CommonDBTests.testConnectionc C s4 | � � }dd� }||_|�� }|j|ksJ d��d S )Nc S � dS �N� r ��
26 connectionr! Z
27 errorclassZ
28 errorvaluer r r
29 �<lambda>A � z8CommonDBTests.testErrorHandlerInherits.<locals>.<lambda>z5Error handler on crsr should be same as on connection)r � errorhandlerr! )r �conn�
30 mycallabler' r r r
31 �testErrorHandlerInherits? s �z&CommonDBTests.testErrorHandlerInheritsc C sx | � � }|jd d �= z |�� |�� W d S t|j�dks"J �t|jd �dks-J �|jd d tjks9J �Y d S )Nr+ r � )r �messages�close�commit�len�apiZProgrammingError�r r1 r r r
32 �!testDefaultErrorHandlerConnectionH s z/CommonDBTests.testDefaultErrorHandlerConnectionc C sv dd� }| � � }||_|�� |�� t|j�dks J �d |_z
33 |�� |�� W n Y t|j�dks9J d��d S )Nc S r) r* r r, r r r
34 r. U r/ z=CommonDBTests.testOwnErrorHandlerConnection.<locals>.<lambda>r �JSetting errorhandler to none should bring back the standard error handler)r r0 r6 r7 r8 r5 )r r2 r1 r r r
35 � testOwnErrorHandlerConnectionS s � �z+CommonDBTests.testOwnErrorHandlerConnectionc C sv | � � �� }|jd d �= z|�d� W d S t|j�dks!J �t|jd �dks,J �|jd d tjks8J �Y d S )N� SELECT abbtytddrf FROM dasdasdr+ r r4 )r r! r5 �executer8 r9 �
36 DatabaseErrorr& r r r
37 � testDefaultErrorHandlerCursorh s z+CommonDBTests.testDefaultErrorHandlerCursorc C sn dd� }| � � �� }||_|�d� t|j�dksJ �d |_z|�d� W n Y t|j�dks5J d��d S )Nc S r) r* r r, r r r
38 r. t r/ z9CommonDBTests.testOwnErrorHandlerCursor.<locals>.<lambda>r> r r< )r r! r0 r? r8 r5 )r r2 r' r r r
39 �testOwnErrorHandlerCursorr s �
40 �z'CommonDBTests.testOwnErrorHandlerCursorc sn z�dd� }|d�dks
41 J �| � � | �� � | �t� fdd�dg� t�tj�� _� �� }dtj }|�
42 |� |�
43 dtj � |�
44 d tj � |� jtj < |�
45 d
46 tj � |� � }|d }| �
47 |d d� |d }| �
48 |d d
49 � | �
50 |d d� dd� }|d�dks�J �||jd < | �
51 |d d
52 � | �
53 |d d� W z� `W n Y | �� d S z� `W n Y | �� w )Nc S s | d S )Nr4 r �Z aStringFieldr r r
54 r. � � z:CommonDBTests.testUserDefinedConversions.<locals>.<lambda>ZgabbaZ
55 gabbagabbac s
56 � j | S r )�variantConversions)�x�r1 r r
57 r. � s
58 r4 zDCREATE TABLE xx_%s (fldData VARCHAR(100) NOT NULL, fld2 VARCHAR(20))z7INSERT INTO xx_%s(fldData,fld2) VALUES('gabba','booga')z2INSERT INTO xx_%s(fldData,fld2) VALUES('hey','yo')z/SELECT fldData,fld2 FROM xx_%s ORDER BY fldDatar r+ ZheyheyZyoyoc S s | � � S r )�upperrC r r r
59 r. � rD ZupThisZUPTHISZYO)�helpForceDropOnTblTempr � assertRaises�AttributeError�copyr9 rE r! �config�tmpr? ZadoStringTypes�fetchall� assertEqual�
60 converters�helpRollbackTblTemp)r ZduplicatingConverterr' �tabdef�rows�rowZupcaseConverterr rG r
61 �testUserDefinedConversions� sT ��
62 ��
63 �
64 z(CommonDBTests.testUserDefinedConversionsNc C s� | � � | �� }|�� }dtj | d } |�| � |�dtj � |�dtj � |�� }
65 | �|
66 d d � |
67 d dks>J �|jd } | d dv sSJ d| d d f ��|d
68 krk| d t j
69 ksjJ d| d t j
70 j f ��nz|d kr�| d t j ks�J d| d t j j f ��nb|d kr�| d t j
71 ks�J d| d t j
72 j f ��nJ|d
73 kr�| d t jks�J d| d t jj f ��n2|dkr�| d t jks�J d| d t jj f ��n|dkr�| d t jks�J d| d t jj f ��nt�|g} |r�| �|� t| �} d}
74 | D ]�}|
75 d7 }
76 z
77 |�dtj |
78 |f� W n |�� � |�dtj |
79 g� |�� }
80 |�rBtdd� |D ��}t|
81 d |��sAJ dt|
82 d �|f ��nt|
83 d t|���sZJ dt|
84 d �t|�f ��|�rw|d
85 k�rwtj�|
86 d �}tj�|�}| �||� q�|�r�t|�}t|
87 d �}t || �| dk �s�J d|
88 d |f ��q�|�r�d}| � |
89 d |v d|
90 d �d|� �� q�| �|
91 d |d|
92 d |f � q�d S ) Nzb
93 CREATE TABLE xx_%s (
94 fldId integer NOT NULL,
95 fldData z)
96 z$INSERT INTO xx_%s (fldId) VALUES (1)z SELECT fldId,fldData FROM xx_%sr+ r )�fldDataZflddatazwas "%s" expected "%s"rW �STRING�NUMBER�BINARY�DATETIME�ROWID�UUIDz.INSERT INTO xx_%s (fldId,fldData) VALUES (?,?)z'SELECT fldData FROM xx_%s WHERE ?=fldIDc S s g | ]}t |��qS r )�type)r ZaRVr r r
97 r s z2CommonDBTests.helpTestDataType.<locals>.<listcomp>z"result type "%s" must be one of %sz'result type "%s" must be instance of %sg�h㈵��>z-Values not almost equal recvd=%s, expected=%fFzValue "z " not in z.Values are not equal recvd="%s", expected="%s") rI r r! rM rN r? �fetchonerP � descriptionr9 rX �valuesrY rZ r[ r\ �OTHERr �extend�set�printADOerrors�tuple�
98 isinstancer^ �adodbapi�
99 dateconverter�DateObjectToIsoFormatString�float�abs�
100 assertTrue)r ZsqlDataTypeStringZDBAPIDataTypeStringZpyDataZpyDataInputAlternatives�compareAlmostEqual�allowedReturnValuesr1 r' rS �rsZ descTuple�inputs�fldId�inParamZ allowedTypesZiso1Ziso2�s�v�okr r r
101 �helpTestDataType� s� ����
102
103
104 �
105 �
106 �
107 �
108 �
109 �
110 �
111 � ��
112 ��� �
113 �
114 ���z CommonDBTests.helpTestDataTypec C s( | j ddddd� | j ddddd� d S )N�realrY 皙���� @T�rn rk gd��F��G�rw r r r r
115 �testDataTypeFloat9 s z CommonDBTests.testDataTypeFloatc C s� | j dddddt�d�gd� | j dddddt�d�gd� | j ddd d
116 d t�d �gd� | �� d
117 kr?| j ddddgd� d S d S )Nz
118 decimal(18,2)rY ry z3.45z3,45�ro z
119 numeric(18,2)z
120 decimal(20,2)l G#xoW1z444444444444444444.00z444444444444444444,00Z444444444444444444�MSSQLZuniqueidentifierr] z&{71A4F49E-39F3-42B1-A41E-48FF154996E6})rw �decimal�Decimalr r r r r
121 �testDataTypeDecmal= s: ����
122
123 ��z CommonDBTests.testDataTypeDecmalc C s� | � � dkr| �ddt�d�� d S | � � dkr,| jddt�d�ddt�d�gd � d S | �d
124 dt�d �� | �ddt�d�� d S ) N�MySQLz
125 DECIMAL(20,4)rY z-922337203685477.5808�
126 PostgreSQLZmoneyTg-C ��6
127 �)rn ro Z
128 smallmoneyz 214748.02)r rw r r� r r r r
129 �testDataTypeMoney\ s$ � �
130 � �z CommonDBTests.testDataTypeMoneyc C sv | � � dkr
131 | �ddd� | �ddd� | � � dvr!| �ddd � | � � d
132 v r2| jd dd d d gd
133 � | �ddd� d S )Nr� ZtinyintrY �s Zsmallinti ���)�ACCESSr� �bitr+ )r~ r� Zbigintl ^�e r} �inti����r rw r r r r
134 �testDataTypeIntr s � �z CommonDBTests.testDataTypeIntc C s$ dD ]
135 }| j |ddg d�d� qd S )N)zchar(6)znchar(6)rX �spam )�spamr� r� r� r} r{ )r � sqlDataTyper r r
136 �testDataTypeChar� s ��z CommonDBTests.testDataTypeCharc C sT | � � dkr ddg}n| � � dkrg d�}ng d�}|D ] }| �|dddg� q d S ) Nr� � varchar(10)�textr� )r� r� zcharacter varying)r� z nvarchar(10)r� ZntextrX r� r� )r Z stringKindsr� r r r
137 �testDataTypeVarChar� s
138
139 �z!CommonDBTests.testDataTypeVarCharc C s� | � � dkr d}nd}| j|dt�ddd�dd � | � � d
140 vr-| jd dt�ddd�dd � td krJ| � � d
141 vrL| j|dt�dddd
142 dd�dd � d S d S d S )Nr� � timestamp�datetimer[ �� �
143 � Trz )r� r� Z
144 smalldatetimeZ
145 pythontime� � r+ )r rw rh �Date�tag� Timestamp)r �dtr r r
146 �testDataTypeDate� s* � �
147 ��z CommonDBTests.testDataTypeDatec C s� d}|t �|�t|�g}| �� dkr | jddt �|�|d� d S | jddt �|�|d� | jddt �|�|d� | �� dkrL| jd dt �|�|d� d S d S )
148 Ns �@*r� ZbytearZ r} z binary(5)zvarbinary(100)r� �image)rh �Binary�bytesr rw )r ZbinfldZarvr r r
149 �testDataTypeBinary� s(
150 ���
151 ��z CommonDBTests.testDataTypeBinaryc C s | � � d S r )rI r r r r
152 rR � r# z!CommonDBTests.helpRollbackTblTempc C sr | � � }|�� �'}z|�dtj � |js|�� W n Y W d � d S W d � d S 1 s2w Y d S )NzDROP TABLE xx_%s)r r! r? rM rN �
153 autocommitr7 )r r1 r' r r r
154 rI � s
155 ���" z$CommonDBTests.helpForceDropOnTblTempc C sf dt j }z|�|� W n tjy | �� |�|� Y nw td�D ] }|�dt j|f � q$d S )Nz\
156 CREATE TABLE xx_%s (
157 fldData INTEGER
158 )
159 � z'INSERT INTO xx_%s (fldData) VALUES (%i))rM rN r? r9 r@ rI r )r r' rS �ir r r
160 � helpCreateAndPopulateTableTemp� s ��� �z,CommonDBTests.helpCreateAndPopulateTableTempc C st | � � }| �|� |�dtj � |�� }t|�dks J �d}|dd� D ]}|d |ks/J �|d7 }q%| �� d S )N�SELECT fldData FROM xx_%sr� � �����r r+ )r" r� r? rM rN rO r8 rR )r r' rp r� rU r r r
161 � testFetchAll� s
162
163 zCommonDBTests.testFetchAllc C sf | � � }| �|� |�dtj � |�|j� |�� }t|�dks#J �|d d dks-J �| � � d S )Nr� r� r4 r )
164 r" r� �preparerM rN r? �commandrO r8 rR �r r' rp r r r
165 �testPreparedStatement� s
166 z#CommonDBTests.testPreparedStatementc C sd | � � }| �|� |�d� |�dtj � |�� }t|�dks"J �|d d dks,J �| �� d S )NzSELECT * FROM nowherer� r� r4 r ) r" r� r� r? rM rN rO r8 rR r� r r r
167 �testWrongPreparedStatement s
168
169 � z(CommonDBTests.testWrongPreparedStatementc C sP | � � }| �|� |�dtj � t|�D ] \}}|d |ks!J �q| �� d S )Nr� r )r" r� r? rM rN � enumeraterR )r r' r� rU r r r
170 � testIterator s
171 � zCommonDBTests.testIteratorc C s� | � � }| �|� ddg}|�dtj |� |jdkr$t| �� d � n| �|jd� |� dtj � |�
172 � }t |�dks?J �| � � d S ) N)�o )�� z&INSERT INTO xx_%s (fldData) VALUES (?)�����z7 Provider does not support rowcount (on .executemany())r4 r� � )
173 r" r� Z executemanyrM rN �rowcount�printr rP r? rO r8 rR )r r' Z
174 seq_of_valuesrp r r r
175 �testExecuteMany s"
176
177 �
178 �� z CommonDBTests.testExecuteManyc C sH | � � }| �|� |�dtj � |jdkrn| �|jd� | �� d S )Nr� r� r� )r" r� r? rM rN r� rP rR r& r r r
179 � testRowCount+ s
180
181 zCommonDBTests.testRowCountc C sX | � � }| �|� |�dtj � |jdkr t| �� d � n| �|jd� | � � d S )Nz$DELETE FROM xx_%s WHERE fldData >= 5r� z/ Provider does not support rowcount (on DELETE)� )
182 r" r� r? rM rN r� r� r rP rR r& r r r
183 �testRowCountNoRecordset6 s
184
185 z%CommonDBTests.testRowCountNoRecordsetc C s| | � � }| �|� |�dtj � |�d�}t|�dks J �|�d�}t|�dks+J �|�d�}t|�dks8J �| �� d S )Nr� r� � r+ )r" r� r? rM rN � fetchmanyr8 rR r� r r r
186 �
187 testFetchMany@ s
188
189
190
191 zCommonDBTests.testFetchManyc C s� | � � }| �|� |�dtj � |�� }t|�dks J �d|_|�� }t|�dks,J �|�� }t|�dks8J �|�� }t|�dksDJ �| �� d S )Nr� r+ r� r ) r" r� r? rM rN r� r8 Z arraysizerR r� r r r
192 �testFetchManyWithArraySizeL s
193 z(CommonDBTests.testFetchManyWithArraySizec C s( | � � }|�� | �tj| jdi � d S )Nznot a valid connect string)r r6 rJ r9 r@ �dbr: r r r
194 �testErrorConnect[ s z CommonDBTests.testErrorConnectc
195 C s: | � � | �� }|�� }dtj }|�|� ddg}d}|D ]�}|d7 }z|�dtj ||d |d |d f� W n |�� � |�dtj |g� |�� }tt |��D ]}|| || kslJ d || || f ��qVt
196 |�|ks~J d
197 |�d |�d ���t
198 |d d
199 � �} t
200 |dd� �}
201 | |
202 ks�J d
203 | �d |
204 �d ���|d |d ks�J �|j |d ks�J �|j |d ks�J �q |�dtj � |�
205 � } | d d dks�J �| d d dks�J �| d d dks�J �| d dks�J �| d dks�J �| d dks�J �td�D ]} td�D ]}| | | | | |f k�sJ ��q�q d S )Nz�
206 CREATE TABLE xx_%s (
207 fldId integer NOT NULL,
208 fldTwo integer,
209 fldThree integer,
210 fldFour integer)
211 )r4 r� r� )�f �g �h r+ zBINSERT INTO xx_%s (fldId,fldTwo,fldThree,fldFour) VALUES (?,?,?,?)r r4 z7SELECT fldTwo,fldThree,fldFour FROM xx_%s WHERE ?=fldID�&returned value:"%s" != test value:"%s"zreturned value:"z" != test value:"�"r� �fldTwoz)select fldThree,fldFour,fldTwo from xx_%sr� r� �fldFourr� )r r r� )r r� )r+ r4 r� )rI r r! rM rN r? re r_ r r8 rf ZfldThreer� rO )
212 r r1 r' rS rq rr rs �rec�jZslice1Zslice2Zrecsr� r r r
213 �testRowIterator` sn ��
214
215 �����
216 � "��z CommonDBTests.testRowIteratorc C sb | � � | �� }d|_|�� }dtj }|�|� g d�}d}|D ]G}|d7 }dtj d }z
217 |�|||f� W n |�� � |�dtj d |g� |�� }| � |d
218 |d |d
219 |f � | � |d d � q!d
220 tj d } d}
221 |�| |
222 � d|j
223 v s�J dd|j
224 f ��|j | ks�J d| |j f ��| � |j |
225 � |�dtj � |�� }| � |d
226 d� d S )N�format��
227 CREATE TABLE xx_%s (
228 fldId integer NOT NULL,
229 fldData varchar(10),
230 fldConst varchar(30))
231 ��one�two�threer4 r+ �INSERT INTO xx_zE (fldId,fldConst,fldData) VALUES (%s,'thi%s :may cause? trouble', %s)�!SELECT fldData, fldConst FROM xx_z WHERE %s=fldIDr r� zthi%s :may cause? troublezinsert into xx_z) (fldId,fldData) VALUES (%s,'four%sfive'))� z(?,zexpected:"%s" in "%s"z expected:"%s" but found "%s"z(SELECT fldData FROM xx_%s WHERE fldID=20z
232 four%sfive)
233 rI r �
234 paramstyler! rM rN r? re r_ rP �queryr� �
235 parameters) r r1 r' rS rq rr rs �sqlr� �sel�paramsr r r
236 �testFormatParamstyle� sZ ��
237 ��� �� � z"CommonDBTests.testFormatParamstylec C �� | � � | �� }|�� }d|_dtj }|�|� g d�}d}|D ];}|d7 }z|�dtj ||d�� W n |�� � |�dtj d |i� |�� }| � |d
238 |d |d
239 |f � q!|�d tj d
240 di� |�dtj � |�� }| � |d
241 d� d S )N�named�
242 CREATE TABLE xx_%s (
243 fldId integer NOT NULL,
244 fldData varchar(10))
245 ��four�five�sixr� r+ �5INSERT INTO xx_%s (fldId,fldData) VALUES (:Id,:f_Val)�Zf_Val�Idz)SELECT fldData FROM xx_%s WHERE fldID=:Idr� r r� �:insert into xx_%s (fldId,fldData) VALUES (:xyz,'six:five')�xyz� �(SELECT fldData FROM xx_%s WHERE fldID=30�six:five�
246 rI r r! r� rM rN r? re r_ rP �r r1 r' rS rq rr rs r� r r r
247 �testNamedParamstyle� sN ��
248 �����z!CommonDBTests.testNamedParamstylec C r� )NZpyformatr� r� r� r+ z=INSERT INTO xx_%s (fldId,fldData) VALUES (%%(Id)s,%%(f_Val)s)r� z-SELECT fldData FROM xx_%s WHERE fldID=%%(Id)sr� r r� z?insert into xx_%s (fldId,fldData) VALUES (%%(xyz)s,'six%%five')r� r� r� zsix%fiver� r� r r r
249 �testPyformatParamstyle sT ��
250 ������z$CommonDBTests.testPyformatParamstylec
251 C s� | � � | �� }d|_|�� }dtj }|�|� g d�}d}|D ]G}|d7 }z|�dtj d ||f� W n |�� � d}|�d tj d
252 |g� |�� }| � |d |d |d |f � | � |d |� q!d
253 }|D ];}|d7 }z|�dtj ||d�� W n |�� � |�dtj d|i� |�� }| � |d |d |d |f � qmdtj } |�
254 | � |�| ddi� |�dtj � |�� }| � |d d� d S )NZdynamicr� r� r4 r+ r� zD (fldId,fldConst,fldData) VALUES (?,'thi%s :may cause? troub:1e', ?)zthi%s :may cause? troub:1er� z WHERE ?=fldIDr r� r� r� r� z)SELECT fldData FROM xx_%s WHERE :Id=fldIDr� r� r� r� r� r� ) rI r r� r! rM rN r? re r_ rP r� )
255 r r1 r' rS rq rr rs Ztroubler� Zppdcmdr r r
256 �testAutomaticParamstyle> s� ��
257 ��� �������
258 z%CommonDBTests.testAutomaticParamstylec C s� | � � }|�� }|jjrJ d��| �|� |j�� |�dtj � dtj }|�|� |� � }t
259 |�dks8J �| j � � |�|� |�
260 � d u sLJ d��|�dtj � |� � }t
261 |�dksbJ d��| �� d S ) Nz Unexpected beginning condition�'INSERT INTO xx_%s (fldData) VALUES(100)�+SELECT fldData FROM xx_%s WHERE fldData=100r+ z?cursor.fetchone should return None if a query retrieves no rows�SELECT fldData from xx_%sr� z,the original records should still be present)r r! r- r� r� r7 r? rM rN rO r8 r1 �rollbackr_ rR )r r1 r' � selectSqlrp r r r
262 � testRollBack� s&
263
264
265
266
267
268 � zCommonDBTests.testRollBackc C s z| � � }W n
269 ty Y d S w |jrJ d��|�� }| �|� |�dtj � |�� dtj }|�|� |� � }t
270 |�dksCJ �|� � |� � | � � }| �
271 � }|�� �#}|�|� |� � }t
272 |�dksiJ �|d d dkssJ �W d � n1 s}w Y | �� d S )Nz default should be manual commitr� r� r+ r �d )�getAnotherConnectionr r� r! r� r? rM rN r7 rO r8 r6 r r" rR )r �con2r' r� rp r1 r r r
273 �
274 testCommit� s2 �
275
276
277
278
279 � zCommonDBTests.testCommitc C s� z| � � }W n
280 ty Y d S w |jrJ d��|�� }| �|� |�dtj � dtj }|�|� |�� }t |�dks?J �|�
281 � |�
282 � | � � }z |�|� |� � }W n t
283 jyb d }Y nw |d u snJ d|����| �� d S )Nz unexpected beginning conditionr� r� r+ zEcursor.fetchone should return None if a query retrieves no rows. Got )r� r r� r! r� r? rM rN rO r8 r6 r" r_ r9 r@ rR )r r� r' r� rp rU r r r
284 �testAutoRollback� s8 �
285
286
287 � �
288 � z CommonDBTests.testAutoRollbackc C s� z | � ddi�}W n
289 ty Y d S w |�� }| �|� |�dtj � |�� | �� � }dtj }|�|� |� � }t
290 |�dksFJ d��W d � n1 sPw Y |�� | � � d S )Nr� Tr� r� r� �#all records should still be present) r� r r! r� r? rM rN r6 r" rO r8 rR )r �ac_connr' r� rp r r r
291 �testAutoCommit� s& �
292
293
294 � � z CommonDBTests.testAutoCommitc C s� z| � � }W n
295 ty Y d S w d|_|�� }| �|� |�dtj � |�� | � � }|�� | �
296 � � }dtj }|�|� |� � }t |�dksNJ d��W d � n1 sXw Y | �
297 � d S )NTr� r� r� r� )r� r r� r! r� r? rM rN r6 r r" rO r8 rR )r r� r' r1 r� rp r r r
298 �testSwitchedAutoCommit� s* �
299
300
301 � � z$CommonDBTests.testSwitchedAutoCommitc C s& G dd� dt �}G dd� dt�}G dd� dt�}|td��}|t�dd ��}|t�� �}| �� | �� }|�� }d
302 t j
303 } |� | � |� d t j
304 |||f� |� � | �� }| �
305 � �+}d t j
306 }
307 |� |
308 � |�� } | �| j|� | �| j|� | �| j|� W d � n1 s�w Y | �� d S )
309 Nc @ � e Zd ZdS )z;CommonDBTests.testExtendedTypeHandling.<locals>.XtendStringN�r% �
310 __module__� __qualname__r r r r
311 � XtendString� � r c @ r� )z8CommonDBTests.testExtendedTypeHandling.<locals>.XtendIntNr� r r r r
312 �XtendInt r r c @ r� )z:CommonDBTests.testExtendedTypeHandling.<locals>.XtendFloatNr� r r r r
313 �
314 XtendFloat r r r� i����i� z�
315 CREATE TABLE xx_%s (
316 s VARCHAR(40) NOT NULL,
317 i INTEGER NOT NULL,
318 f REAL NOT NULL)z,INSERT INTO xx_%s (s, i, f) VALUES (?, ?, ?)zSELECT s, i, f from xx_%s)�strr� rk r r �randintrI r r! rM rN r? r6 r" r_ rP rt r� ZassertAlmostEqual�frR ) r r r r Zxs�xiZxfr1 r' rS r� rU r r r
319 �testExtendedTypeHandling� s< ��
320 �
321
322 � � z&CommonDBTests.testExtendedTypeHandling)NNN)0r% r r �__doc__r r r r" r( r3 r; r= rA rB rV rw r| r� r� r� r� r� r� r� rR rI r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r
323 r r r r
324 r , sd
325 6
326 �
327
328
329
330
331 C=.0I r c @ sN e Zd Zdd� Zdd� Zdd� Zddd �Zd
332 d � Zd d
333 � Zdd� Z dd� Z
334 dS )�TestADOwithSQLServerc C �8 t jt jd i t jd ��| _d| j_d| _t j| _d S )Nr r+ r� r~ )rM �dbSqlServerconnect�connStrSQLServerr1 �timeoutr r� r r r r
335 r ( � �� zTestADOwithSQLServer.setUpc C �: z| j �� W n Y z| j �� W n Y d | _ d S r �r1 r� r6 r r r r
336 �tearDown0 �
337 z TestADOwithSQLServer.tearDownc C r r rG r r r r
338 r ; r z"TestADOwithSQLServer.getConnectionNc C �2 t jd �� }|r|�|� t jt jd i |��S �Nr+ r )rM r rL �updater �r �addkeys�keysr r r
339 r� > �
340 z)TestADOwithSQLServer.getAnotherConnectionc C s� | j �� }d}z |�d� | j �� W n Y |�|� |�dd�}|d dks2J |d �d���|d d ksAJ |d �d
341 ���|d d ksPJ |d �d
342 ���| j �� d S )Na
343 CREATE PROCEDURE sp_DeleteMeOnlyForTesting
344 @theInput varchar(50),
345 @theOtherInput varchar(50),
346 @theOutput varchar(100) OUTPUT
347 AS
348 SET @theOutput=@theInput+@theOtherInput
349 �(DROP PROCEDURE sp_DeleteMeOnlyForTesting�sp_DeleteMeOnlyForTesting)� Dodsworth�Annez r r z is not "Dodsworth"r+ r z is not "Anne"r4 Z
350 DodsworthAnnez is not "DodsworthAnne")r1 r! r? r7 �callprocr� )r r' �spdef� retvaluesr r r
351 �$testVariableReturningStoredProcedureD s"
352
353
354 � �z9TestADOwithSQLServer.testVariableReturningStoredProcedurec C s� | � � }| �|� dtjtjtjf }z |�d� | j�� W n Y |�|� |�d�}|�� }| � |d d� |�
355 � dksDJ d��|� � rLJ d��|�
356 � dksVJ d��|� � }| � |d d d � |�
357 � d u snJ d
358 ��| � � d S ) Na
359 CREATE PROCEDURE sp_DeleteMe_OnlyForTesting
360 AS
361 SELECT fldData FROM xx_%s ORDER BY fldData ASC
362 SELECT fldData From xx_%s where fldData = -9999
363 SELECT fldData FROM xx_%s ORDER BY fldData DESC
364 z)DROP PROCEDURE sp_DeleteMe_OnlyForTestingZsp_DeleteMe_OnlyForTestingr TzOperation should succeedz Should be an empty second setzthird set should be present� z'No more return sets, should return None)
365 r" r� rM rN r? r1 r7 r! r_ rP ZnextsetrO rR )r r' r" r# rU Zrowdescr r r
366 �testMultipleSetReturn_ s0
367 ��
368
369
370 z*TestADOwithSQLServer.testMultipleSetReturnc C s� | j �� }d}z |�d� | j �� W n Y |�|� |�dt�dddddd�d d
371 g�}|d d ks<J d
372 |d ��| j �� d S )Na1
373 CREATE PROCEDURE sp_DeleteMeOnlyForTesting
374 @theInput DATETIME,
375 @theOtherInput varchar(50),
376 @theOutput varchar(100) OUTPUT
377 AS
378 SET @theOutput = CONVERT(CHARACTER(20), @theInput, 0) + @theOtherInput
379 r r i� r� � r r+ ZBeepz r4 zDec 25 2014 12:01AM Beepzvalue was="%s")r1 r! r? r7 r! rh r� r� �r r' r" �resultr r r
380 � testDatetimeProcedureParameter� s
381
382
383 � z3TestADOwithSQLServer.testDatetimeProcedureParameterc C s� | j �� }d}z |�d� | j �� W n Y |�|� t�tjtjf|j dgdg d�i�}|d rFdt
384 |d �v sEd t
385 |�v sEJ d
386 ��n
387 |d sPJ |d ��| j � � d S ) Na.
388 CREATE PROCEDURE sp_DeleteMeOnlyForTesting
389 @theInput DATETIME,
390 @theOtherInput varchar(50),
391 @theOutput varchar(100) OUTPUT
392 AS
393 SET @theOutput = CONVERT(CHARACTER(20), @theInput) + @theOtherInput
394 r r r� )z
395 this is wrongr z not Alicer z @theInputr+ r@ z(Identifies the wrong erroneous parameter) r1 r! r? r7 �
396 tryconnectionZ%try_operation_with_expected_exceptionr9 Z DataErrorr@ r! r r� r( r r r
397 �%testIncorrectStoredProcedureParameter� s.
398
399
400
401
402 ����z:TestADOwithSQLServer.testIncorrectStoredProcedureParameterr ) r% r r r r r r� r$ r& r* r, r r r r
403 r ' s
404 " r c @ �6 e Zd Zdd� Zdd� Zdd� Zd dd �Zd
405 d � ZdS )
406 �TestADOwithAccessDBc C r
407 )Nr r+ r� r� )rM ZdbAccessconnect�
408 connStrAccessr1 r r r� r r r r
409 r � r zTestADOwithAccessDB.setUpc C r r r r r r r
410 r � r z TestADOwithAccessDB.tearDownc C r r rG r r r r
411 r � r z!TestADOwithAccessDB.getConnectionNc C s t d��)Nz2Jet cannot use a second connection to the databaser )r r r r r
412 r� � s z(TestADOwithAccessDB.getAnotherConnectionc C s4 | j tjd i tjd ��}|d usJ �|�� d S �Nr r+ )r� rM r/ r6 �r �cr r r
413 �
414 testOkConnect� s z!TestADOwithAccessDB.testOkConnectr �r% r r r r r r� r3 r r r r
415 r. � s
416 r. c @ r- )
417 �TestADOwithMySqlc C r
418 )Nr r+ r� r� )rM �dbMySqlconnect� connStrMySqlr1 r r r� r r r r
419 r � r zTestADOwithMySql.setUpc C r r r r r r r
420 r � r zTestADOwithMySql.tearDownc C r r rG r r r r
421 r � r z TestADOwithMySql.getConnectionNc C r r )rM r7 rL r r6 r r r r
422 r� � r z%TestADOwithMySql.getAnotherConnectionc C �, | j tjd i tjd ��}|d usJ �d S r0 )r� rM r7 r1 r r r
423 r3 � � z TestADOwithMySql.testOkConnectr r4 r r r r
424 r5 � �
425 r5 c @ r- )
426 �TestADOwithPostgresc C r
427 )Nr r+ r� r� )rM �dbPostgresConnect�connStrPostgresr1 r r r� r r r r
428 r r zTestADOwithPostgres.setUpc C r r r r r r r
429 r & r z TestADOwithPostgres.tearDownc C r r rG r r r r
430 r 1 r z!TestADOwithPostgres.getConnectionNc C r r )rM r= rL r r< r r r r
431 r� 4 r z(TestADOwithPostgres.getAnotherConnectionc C r8 r0 )r� rM r= r1 r r r
432 r3 : r9 z!TestADOwithPostgres.testOkConnectr r4 r r r r
433 r; r: r; c @ sL e Zd Zdd� Zdd� Zdd� Zdd� Zd d
434 � Zd d � Zd
435 d� Z dd� Z
436 dS )�TimeConverterInterfaceTestc C � | j �ddd�s
437 J �d S )N�� r4 )�tcr� r r r r
438 � testIDate] r z$TimeConverterInterfaceTest.testIDatec C r? )N�
439 r4 )rA �Timer r r r
440 � testITime` r z$TimeConverterInterfaceTest.testITimec C s | j �dddddd�s
441 J �d S )Nr@ r4 rC r+ )rA r� r r r r
442 �testITimestampc s z)TimeConverterInterfaceTest.testITimestampc C s | j �d�sJ �d S )N�?�mUxG�@)rA �DateObjectFromCOMDater r r r
443 �testIDateObjectFromCOMDatef � z5TimeConverterInterfaceTest.testIDateObjectFromCOMDatec C s t | jd�sJ �d S )N�COMDate)�hasattrrA r r r r
444 � testICOMDatei rJ z'TimeConverterInterfaceTest.testICOMDatec C s4 | j �ddd�}| j �|�}d}||ksJ |��d S )N�� r� r� g ���@)rA r� rK �r �dZcomDateZcorrectr r r
445 �
446 testExactDatel s z(TimeConverterInterfaceTest.testExactDatec C sh | j �dddddd�}| j �|�}d}| �||� | j �ddd d
447 dd �}| j �|�}d }| �||� d S )
448 NrN r� r� r� r g ���@�� r� � � � gS��sn�@)rA r� rK rP rO r r r
449 �testExactTimestampr s z-TimeConverterInterfaceTest.testExactTimestampc C sr | j �dddddd�}| j �|�}| �t|d d� �d� | j �d d
450 d �}| j �|�}| �t|d d� �d � d S )
451 NrN r� r� r� r� r� � z1994-11-15 12:03:10rR r� r4 z
452 2003-05-02)rA r� rj rP r r� )r rP Zisor� r r r
453 �
454 testIsoFormat} s z(TimeConverterInterfaceTest.testIsoFormatN) r% r r rB rE rF rI rM rQ rV rX r r r r
455 r> \ s r> c @ �< e Zd Zdd� Zdd� Zdd� Zdd� Zd d
456 � Zd d � Zd
457 S )�TestPythonTimeConverterc C � t �� | _d S r )r9 �pythonTimeConverterrA r r r r
458 r � � z TestPythonTimeConverter.setUpc C s@ t �d�}t �|�}| j�|�}t|d �dk s J d| ��d S )N) r� rS r� � r� r+ r� � r� rG �UUUUUU�?z%f more than an hour wrong)�time�mktime� localtimerA rK rl )r �mk�t�cmdr r r
459 � testCOMDate� s
460
461 z#TestPythonTimeConverter.testCOMDatec C sV | j �d�}t�t�d��}t�t�d��}|| k r |k s)n J d|� d���d S )NrG ) r� rS r� r rT r+ r� r_ r� ) r� rS � r� rT r4 r� r_ r� r� z$" should be about 2002-6-28 12:15:01)rA rH ra �gmtimerb )r rf �t1�t2r r r
462 �testDateObjectFromCOMDate� s ��*z1TestPythonTimeConverter.testDateObjectFromCOMDatec C sR t �d�}t �d�}| j�ddd�}|t �|� k r"|k s'J |�� J |��d S )N) r� rS r� r^ r� r+ r� � r ) r� rS r� r^ r� r+ r� r_ r r� rS rh )ra rb rA r� �r rj rk �objr r r
463 �testDate� s
464
465 .z TestPythonTimeConverter.testDatec C s" | � | j�ddd�t�d�� d S )Nr^ r� r4 i� )rP rA rD ra ri r r r r
466 �testTime� s �z TestPythonTimeConverter.testTimec C s^ t �t �d��}t �t �d��}| j�dddddd�}|| k r(|k s-J |�� J |��d S ) N) r� rS r� r^ rT r+ r� r_ r� ) r� rS r� r^ � r+ r� r_ r� r� rS r� r^ r� r4 )ra rc rb rA r� rn r r r
467 �
468 testTimestamp� s ��(z%TestPythonTimeConverter.testTimestampN� r% r r r rg rl rp rq rs r r r r
469 rZ � s rZ c @ rY )�TestPythonDateTimeConverterc C r[ r )r9 ZpythonDateTimeConverterrA r r r r
470 r � r] z!TestPythonDateTimeConverter.setUpc C s< t � dddddd�}| j�|�}t|d �dk s J d ��d S )
471 Nr� rS r� r^ r� r+ rG r` zmore than an hour wrong)r� rA rK rl )r re rf r r r
472 rg � s z'TestPythonDateTimeConverter.testCOMDatec C s� | j �d�}t�dddddd�}t�dddddd�}|| k r'|k s,J |�� J |��t�ddddddd �}| j �| j �|��}|| k rN|k sSJ |�� J |��d S )
473 NrG r� rS r� r^ rT r+ rr i��
474 )rA rH r� rK )r rf rj rk Ztx�c1r r r
475 rl � s $�(z5TestPythonDateTimeConverter.testDateObjectFromCOMDatec C sT t �ddd�}t �ddd�}| j�ddd�}|| k r#|k s(J |�� J |��d S )Nr� rS r� r� rh )r� �daterA r� rn r r r
476 rp � s (z$TestPythonDateTimeConverter.testDatec C s( | � | j�ddd��� d d� d� d S )Nr^ r� r4 r% z18:15:02)rP rA rD � isoformatr r r r
477 rq � s (z$TestPythonDateTimeConverter.testTimec C sf t � dddddd�}t � dddddd�}| j�dddddd �}|| k r,|k s1J |�� J |��d S )
478 Nr� rS r� r^ rT r+ rr r� r4 )r� rA r� rn r r r
479 rs � s (z)TestPythonDateTimeConverter.testTimestampNrt r r r r
480 ru � s ru �testc @ s e Zd Zdd� Zdd� ZdS )�cleanup_managerc C s d S r r r r r r
481 � __enter__� r zcleanup_manager.__enter__c C s t �t jt j� d S r )rM �cleanupZ
482 testfolderZmdb_name)r �exc_type�exc_val�exc_tbr r r
483 �__exit__� rJ zcleanup_manager.__exit__N)r% r r r{ r� r r r r
484 rz � s rz �__main__z Default Date Converter is %szChanged dateconverter to ).r rL r� r r r ra ZunittestZadodbapitestconfigrM r+ rh Zadodbapi.apibaseZapibaser9 r ZTestCaser r r. r5 r; r> rZ ru ZdefaultTestLoaderZloadTestsFromModuleZsuitesZ
485 doTimeTest�appendZ doAccessTestZdoSqlServerTestZ doMySqlTestZdoPostgresTestrz Z TestSuiteZsuiter% �deepcopyZmysuiteri ZdefaultDateConverterr� ZTextTestRunner�runr\ r r r r
486 �<module> s� B?+, '� � � � � �
487
488
489 � �$��