Format: application/x-python-code
1 o
2
3 ��h< � @ s e d � e d� ddlZddlZddlZddlZddlZe�� Zdejv r1e� e�Z
4 ej� d� ne� � Z
5 e
6 ej
7 vrAej
8 �de
9 � e�� ZddlZddlmZ eZdejv rZdej_e ej� e dej � zee�� �ZW n d ZY e�� Zi Z d
10 Z d Z d e d
11 < de d< de d< de d< e du r�de ge d< ne e d< de d< dZ er�edkr�n3edkr�dZ d Z!dZ"d Z#d Z$d Z%d e%e$e e!e"e#f Z ned kr�e�&� r�d!Z'nd"Z'e�(e�Z)d#e'e)f Z e d$e � �� e d%e ��� G d&d'� d'ej*�Z+e,d(k�re�-� eed� dS dS ))zLThis module depends on the dbapi20 compliance tests created by Stuart Bishopz*(see db-sig mailing list history for info)� Nz --package� z --verbose� zTested with dbapi20 %sFztestsql.2txt.us,1430z
12 %s\SQLEXPRESSZadotest�nameZ adotestuser�userZ Sq1234567�password�securityZmacro_auto_security�hostZ
13 macro_getnodezBProvider=MSOLEDBSQL;DataTypeCompatibility=80;MARS Connection=True;�providerzI%(provider)s; %(security)s; Initial Catalog=%(name)s;Data Source=%(host)szz-PCZxxxz25.223.161.222Z12345678zPostgreSQL Unicode� z2%sDriver={%s};Server=%s;Database=%s;uid=%s;pwd=%s;ZyyyzMicrosoft.ACE.OLEDB.12.0zMicrosoft.Jet.OLEDB.4.0zProvider=%s;Data Source=%sz Using Connection String like=z Keywords=c @ sZ e Zd ZeZefZeZdd� Z dd� Z
14 dd� Z dd� Z d d
15 � Z
16 d d � Zd
17 d� Zdd� ZdS )�
18 test_adodbapic C s t j�| |� d S �N)�dbapi20�DatabaseAPI20Test�__init__)�self�arg� r �Yc:\Users\shubh\Videos\agent\nova\Lib\site-packages\adodbapi/test/test_adodbapi_dbapi20.pyr ] � ztest_adodbapi.__init__c C s | � � �d�d S )N�.�����)�id�split�r r r r �getTestMethodName` r z test_adodbapi.getTestMethodNamec C s~ t j�| � | �� dkr=| �� }|j}|dkrd}nd}|�� }z |�|� |�� W n Y |� � |� � d| _
19 d S d S )N�
20 test_callproczMS Jetz�
21 create procedure templower
22 @theData varchar(50)
23 as
24 select lower(@theData)
25 z�
26 create procedure templower
27 (theData varchar(50))
28 as
29 select lower(theData);
30 Z templower) r
31 r �setUpr �_connectZ dbms_name�cursor�execute�commit�closeZ
32 lower_func)r �conZengine�sql�curr r r r c s"
33
34 �ztest_adodbapi.setUpc C sL | � � dkr | �� }|�� }z|�d� W n Y |�� tj�| � d S )Nr zdrop procedure templower)r r r r r r
35 r �tearDown)r r" r$ r r r r% � s ztest_adodbapi.tearDownc C s d| j | j f }|�|� dS )z)Should create a procedure called deletemez�
36 create procedure deleteme as
37 begin
38 select count(*) from %sbooze
39 select name from %sbooze
40 end
41 N)Z table_prefixr )r r$ r# r r r �help_nextset_setUp� s ��
42 z test_adodbapi.help_nextset_setUpc C s z|� d� W dS Y dS )z*If cleaning up is needed after nextSetTestzdrop procedure deletemeN)r )r r$ r r r �help_nextset_tearDown� s z#test_adodbapi.help_nextset_tearDownc C s� | � � }z`|�� }| jg| �� }|D ]}|�|� q| �|� |�d� |�� }|d dks1J �|�� s7J �|� � }t
43 |�t
44 | j �ksFJ �|�� }|d u sRJ d��W z | � |� W |�
45 � d S |�
46 � w z | � |� W |�
47 � w |�
48 � w )NZdeletemer � z'No more return sets, should return None)r r Zddl1Z _populater r& ZcallprocZfetchoneZnextsetZfetchall�lenZsamplesr' r! )r r" r$ Zstmtsr# Z numberofrows�names�sr r r � test_nextset� s*
49
50 � ztest_adodbapi.test_nextsetc C s d S r r r r r r �test_setoutputsize� s z test_adodbapi.test_setoutputsizeN)�__name__�
51 __module__� __qualname__�db�driver�connStrZ connect_args�conn_kwsZconnect_kw_argsr r r r% r& r' r, r- r r r r r X s r �__main__).�print�platform�sysZunittestr
52 ZsetuptestframeworkZmaketempZ
53 testfolder�argvZmakeadopackage�pth�removeZ
54 find_ado_path�path�insertZgetcleanupfunction�cleanupZadodbapiZadodbapi.is64bitZis64bitr1 �verbose�version� __version__�bool�getwindowsversionZ onWindows�noder4 r �instancer3 Z
55 _computernameZ
56 _databasenameZ _usernameZ _passwordZ_driver� _provider�Pythonr2 ZmakemdbZtestmdbr r r. �mainr r r r �<module> s�
57
58
59
60
61 � �
62
63 i�