Format: application/x-python-code
1 o
2
3 ��h�i � @ s� d Z ddlmZ ddlZddlZddlZddlZddlZddlm Z m
4 Z
5 m Z ddl m
6 Z dZdd � ZG d
7 d � d e�ZG d d
8 � d
9 e�ZG dd� de�ZG dd� de�ZG dd� de�ZG dd� de�ZG dd� de�ZG dd� de�ZG dd� de�ZG d d � d e�ZG d d � d e�Z G d d!� d!�Z G d"d#� d#e �Z G d$d%� d%e �Z e � Z dZ!d&Z"d'Z#d(Z$ej%ej&ej'ej(ej)ej*ej+ej,fZ-ej.fZ/ej0ej1ej2fZ3ej4ej5ej6ej7fZ8ej9ej:fZ;ej<ej=ej>ej?ej@ejAejBfZCejDejEejFfZGejHejIejJejKfZLejMejNejOejPejQejRejSejTfZUG d)d*� d*�ZV eVeC�ZW eVeG�ZX eVe-e3 e8 e; �ZY eVeL�ZZ eVe/�Z[eVeU�Z\e]ejFe^ej9e_d�ejMe`ej<eaej+ejbej4ecej0edejFiZed+d,� Zfd-d.� Zgd/d0� Zhd1d2� Zid3d4� Zjd5d6� Zkd7d8� Zld9d:� Zmd;d<� Znd=d>� Zod?d@� ZpdAdB� ZqdCdD� ZrdEdF� ZsG dGdH� dHetece eugeuf f �ZveveLege;eke8eie3ene-eme/emeCeqeGeoeUeri �ZwexeyddI��\ZzZ{Z|G dJdK� dK�Z}G dLdM� dM�Z~dNdO� ZdPdQ� Z�dS )Rz�adodbapi.apibase - A python DB API 2.0 (PEP 249) interface to Microsoft ADO
10
11 Copyright (C) 2002 Henrik Ekelund, version 2.1 by Vernon Cole
12 * https://sourceforge.net/projects/pywin32
13 * https://sourceforge.net/projects/adodbapi
14 � )� annotationsN)�Callable�Iterable�Mapping� )�
15 ado_constsFc C sZ ||f}z| j �|� W n Y |d ur)z |j �|� W ||�� Y ||��||���N)�messages�append)�
16 connection�cursorZ
17 errorclassZ
18 errorvalue�err� r �Fc:\Users\shubh\Videos\agent\nova\Lib\site-packages\adodbapi/apibase.py�standardErrorHandler s �r c @ � e Zd ZdS )�ErrorN��__name__�
19 __module__� __qualname__r r r r r & � r c @ r )�WarningNr r r r r r / r r c @ r )�InterfaceErrorNr r r r r r 3 r r c @ r )�
20 DatabaseErrorNr r r r r r 7 r r c @ r )�
21 InternalErrorNr r r r r r ; r r c @ r )�OperationalErrorNr r r r r r ? r r c @ r )�ProgrammingErrorNr r r r r r C r r c @ r )�IntegrityErrorNr r r r r r G r r c @ r )� DataErrorNr r r r r r K r r c @ r )�NotSupportedErrorNr r r r r r O r r c @ s e Zd ZdZdS )�FetchFailedErrorz�
22 Error is used by RawStoredProcedureQuerySet to determine when a fetch
23 failed due to a connection being closed or there is no record set
24 returned. (Non-standard, added especially for django)
25 N)r r r �__doc__r r r r r! S s r! c @ sN e Zd Zdd� Zdd� Zddd�Zdd � Zd
26 d � Zd d
27 � Zdd� Z dd� Z
28 dS )�
29 TimeConverterc C sd t �ddd��� d | _t| �ddd��t| �ddd��t| �dddddd��t j t jt jh| _ d S )Nik � � r i� )
30 �datetime�date� toordinal�_ordinal_1899_12_31�type�Date�Time� Timestamp�time�types��selfr r r �__init__� s
31 �zTimeConverter.__init__c
32 C s^ z|� � }z|j}W n d}Y | �||�W S z| �|�W Y S td|�d���)z"Returns a ComDate from a date-timer �Cannot convert "z
33 " to COMdate.)� timetuple� microsecond�ComDateFromTuple�
34 ValueError)r1 �obj�tt�msr r r �COMDate� s
35 zTimeConverter.COMDater c C sd t �|d |d |d �}|�� | j }|d d |d d |d d | }t|�d
36 }|| S ) Nr r � � i � �< � i@B g `� 4B)r& r' r( r) �float)r1 �t� microseconds�d� integerPartr: Z fractPartr r r r6 � s
37 ( z TimeConverter.ComDateFromTuplec C � t �)z3Returns an object of the wanted type from a ComDate��NotImplementedError)r1 �comDater r r �DateObjectFromCOMDate� � z#TimeConverter.DateObjectFromCOMDatec C rF )z8This function constructs an object holding a date value.rG �r1 �year�month�dayr r r r+ � rK zTimeConverter.Datec C rF )z8This function constructs an object holding a time value.rG �r1 �hour�minute�secondr r r r, � rK zTimeConverter.Timec C rF )z>This function constructs an object holding a time stamp value.rG �r1 rM rN rO rQ rR rS r r r r- � rK zTimeConverter.Timestampc
38 C sn z|� d�}W |S ttfy6 t|tj�r |� � d }Y |S z
39 t�d|�}W Y |S td|�d���w )zYThis function should return a string in the format 'YYYY-MM-dd HH:MM:SS:ms' (ms optional)� z 00:00:00z%Y-%m-%d %H:%M:%Sr3 z" to isoformat) � isoformat� TypeError�AttributeError�
40 isinstancer& r' r. �strftimer7 )r1 r8 �sr r r �DateObjectToIsoFormatString� s � ���z)TimeConverter.DateObjectToIsoFormatStringN)r ) r r r r2 r; r6 rJ r+ r, r- r\ r r r r r# � s
41 r# c @ �4 e Zd Zdd� Zdd� Zdd� Zdd� Zd d
42 � Zd S ) �pythonDateTimeConverterc C s t �| � d S r )r# r2 r0 r r r r2 � � z pythonDateTimeConverter.__init__c C st t |tj�r|�� }|�� }tj�tj�|�|�}|S t|�}t|�}|| }tj�|| j �tj |d d� }|S )Ni \&)Z milliseconds)
43 rY r& r( r. �combine� fromordinalrA �intr) � timedelta) r1 rI ZodnZtim�newZfComDaterE � floatpartZdter r r rJ � s ��z-pythonDateTimeConverter.DateObjectFromCOMDatec C � t �|||�S r )r& r' rL r r r r+ � r_ z pythonDateTimeConverter.Datec C rf r )r& r. rP r r r r, � r_ z pythonDateTimeConverter.Timec C s t � ||||||�S r )r& rT r r r r- � � z!pythonDateTimeConverter.TimestampN�r r r r2 rJ r+ r, r- r r r r r^ � s r^ c @ r] ) �pythonTimeConverterc C s t �| � | j�tj� d S r )r# r2 r/ �addr. � struct_timer0 r r r r2 � s
44 z pythonTimeConverter.__init__c C s6 t |tj�r
45 |�� S t|�}d}t�||d �}|S )zReturns ticks since 1970i�Q g @��@)rY r& r4 rA r. �gmtime)r1 rI ZfcomDateZ
46 secondsperdayrB r r r rJ � s z)pythonTimeConverter.DateObjectFromCOMDatec C s | � |||ddd�S �Nr )r- rL r r r r+
47 rg zpythonTimeConverter.Datec C s t �|d | d | �S )Nr? )r. rl rP r r r r,
48 s zpythonTimeConverter.Timec
49 C s" t �t �||||||dddf ��S )Nr �����)r. � localtime�mktimerT r r r r- s �z pythonTimeConverter.TimestampNrh r r r r ri � s ri z2.0�qmark)rq �named�formatZpyformatZdynamicc @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�DBAPITypeObjectc C s t |�| _d S r )� frozenset�values)r1 Z valuesTupler r r r2 P r_ zDBAPITypeObject.__init__c C s
50 || j v S r �rv �r1 �otherr r r �__eq__S �
51 zDBAPITypeObject.__eq__c C s
52 || j vS r rw rx r r r �__ne__V r{ zDBAPITypeObject.__ne__N)r r r r2 rz r| r r r r rt O s rt c C s� t | �}zt| W S tyK ddlm} ||jv r tj Y S t| t �r*tj
53 Y S t| t j �r5tj
54 Y S t| t j�r@tj Y S td| �d|� d���w )Nr ��
55 dateconverterzcannot convert "z" (type=z) to ADO)r* �typeMap�KeyError� r~ r/ �adc�adDaterY �str�adBSTR�numbers�Integral�adBigInt�Real�adDoubler )rD �tpr~ r r r �pyTypeToADOTypez s
56
57
58
59
60
61
62 �r� c C s ddl m} |�| �S )Nr r} )r� r~ rJ )�vr~ r r r �variantConvertDate� s
63 r� c C � t | �S r �r� ��variantr r r � cvtString� � r� c C s t | tj�S r )�_convertNumberWithCulture�decimal�Decimalr� r r r �
64 cvtDecimal� � r� c C r� r )r� r� r r r �
65 cvtNumeric� r� r� c C s
66 t | t�S r )r� rA r� r r r �cvtFloat� r{ r� c
67 C s` z|| �W S t ttjfy/ zt| ��dd�}||�W Y S t ttjfy. Y Y d S w w )N�,�.)r7 rW r� �InvalidOperationr� �replace)r� �fZ
68 europeVsUSr r r r� � s
69 ��r� c C r� r �rb r� r r r �cvtInt� r� r� c C r� r r� r� r r r �cvtLong� r� r� c C r� r )�bytesr� r r r � cvtBuffer� r� r� c C r� r r� r� r r r �
70 cvtUnicode� r� r� c C s | S r r ��xr r r �identity� s r� c C s t dkrtj�d| �d�� | S )Nr z#Conversion called for Unusual data=�
71 )�verbose�sys�stderr�writer� r r r �
72 cvtUnusual� s r� c C s | d u rd S || �S r r )r� �funcr r r �convert_to_python� s r� c @ s$ e Zd ZdZd
73 dd�Zdd
74 d �Zd S )�MultiMapzhA dictionary of ado.type : function
75 -- but you can set multiple items by passing an iterable of keys�aDict�8Mapping[Iterable[int] | int, Callable[[object], object]]c C s |� � D ]\}}|| |< qd S r )�items)r1 r� �kr� r r r r2 � s
76 �zMultiMap.__init__�adoType�Iterable[int] | int�cvtFn�Callable[[object], object]c C s8 t |t�r|D ] }t�| ||� qdS t�| ||� dS )z/set a single item, or a whole iterable of itemsN)rY r �dict� __setitem__)r1 r� r� r* r r r r� � s
77
78 �zMultiMap.__setitem__N)r� r� )r� r� r� r� )r r r r" r2 r� r r r r r� � s
79 r� r> c @ sT e Zd Zdd� Zdd� Zdd� Zdd� Zd d
80 � Zd d � Zd
81 d� Z dd� Z
82 dd� Z dS )�SQLrowc C s || _ || _d S r )�rows�index)r1 r� r� r r r r2 s
83 zSQLrow.__init__c C s6 z | � | jj|�� �W S ty td�|���w )NzUnknown column name "{}")� _getValuer� � columnNames�lowerr� rX rs )r1 �namer r r � __getattr__ s
84 �zSQLrow.__getattr__c C st | j jtkr| j j|| jf }n| j jtkr | j j| j | }n | j j| | j }| j jtu r1|S t|| j j| �S r ) r� �recordset_format�RS_ARRAY� ado_resultsr� � RS_REMOTE�
85 converters�NotImplementedr� )r1 �keyr� r r r r� s zSQLrow._getValuec C s | j jS r )r� �numberOfColumnsr0 r r r �__len__ r� zSQLrow.__len__c s� t |t�rz� �|�W S ty � w t |t�r/|�� jj�}� fdd�t|� D �}t |�S z � �� jj
86 |� � �W S t t
87 fyX t�� \}}}|d|�d� ����|��w )Nc s g | ]}� � |��qS r )r� ��.0�ir0 r r �
88 <listcomp>$ � z&SQLrow.__getitem__.<locals>.<listcomp>zNo such key as "z" in )rY rb r� �
89 IndexError�slice�indicesr� r� �range�tupler� r� r� rW r� �exc_info�with_traceback)r1 r� r� ZvlZer�st�trr r0 r � __getitem__ s$
90 �
91 ��zSQLrow.__getitem__c C � t | �� �S r ��iter�__next__r0 r r r �__iter__. r� zSQLrow.__iter__c c s$ � t | jj�D ]}| �|�V qd S r )r� r� r� r� )r1 �nr r r r� 1 s ��zSQLrow.__next__c C sX t t| jj�� �dd� d�}d}|D ]\}}||� d| �|��d�7 }q|d d� d S ) Nc S s | d S )Nr r r� r r r �<lambda>6 s z!SQLrow.__repr__.<locals>.<lambda>)r� z <SQLrow={�:z, �����z}>)�sorted�listr� r� r� r� )r1 Ztaglistr[ r� r� r r r �__repr__5 s
92 zSQLrow.__repr__c s" t t� fdd�t� jj�D ���S )Nc 3 s � | ]
93 }t � �|��V qd S r )r� r� r� r0 r r � <genexpr>> s � z!SQLrow.__str__.<locals>.<genexpr>)r� r� r� r� r� r0 r r0 r �__str__< s �zSQLrow.__str__N) r r r r2 r� r� r� r� r� r� r� r� r r r r r� s
94 r� c @ r] ) �SQLrowsc C s` || _ z|j| _|j| _|j| _|j| _W n ty* t| _d| _g | _i | _Y nw || _d S rm )r� r� r� r� r� rX r� � numberOfRows)r1 r� r� r r r r r2 L s
95 �
96 zSQLrows.__init__c C s | j S r )r� r0 r r r r� Z s zSQLrows.__len__c s� � j sg S t|t�r|�� j�}� fdd�t|� D �S t|t�rwt|�dkrw|\}}t|t�sGz � j |�
97 � }W n t yF t d|����w � j t
98 krT� j ||f }n� j tkra� j | | }n� j | | }� jtu ro|S t|� j| �S t� |�}|S )Nc s g | ]}t � |��qS r )r� )r� r� r0 r r r� b r� z'SQLrows.__getitem__.<locals>.<listcomp>r< z!adodbapi: no such column name as )r� rY r� r� r� r� r� �lenrb r� r� r� r� r� r� r� r� r� r� )r1 �itemr� r� �jr� �rowr r0 r r� ] s.
99
100 �
101
102
103
104 zSQLrows.__getitem__c C r� r r� r0 r r r r� x r� zSQLrows.__iter__c c s& � t | j�D ]
105 }t| |�}|V qd S r )r� r� r� )r1 r� r� r r r r� { s
106 �
107 �zSQLrows.__next__N)r r r r2 r� r� r� r� r r r r r� J s r� c
108 C s( d}g }| � d�}d}|D ]�}|r%|dkr |d d� }np|d| d 7 }ng|r�|� dd�}||d 7 }d}z|d }W n tyF d }Y nw |rd}|d } | �� sW| dkrs|d7 }z|| } W n tyj Y n w | �� sW| dksW|d |� }||d � }|r�|�|� |d 7 }|s'| }q
109 ||fS )
110 Nr� �'Frn r� r r �_�?)�splitr� �isalnumr
111 )
112 �op�outOpZoutparms�chunks�inQuotes�chunk�spr[ r� �cr r r �changeNamedToQmark� sN � � ��
113 �r� c C s� d}g }| � d�}d}|D ]l}|r)|dkr |dkr |d d� }nV|d| d 7 }nMd|v rj|ri|� dd�}||d 7 }t|�dkrez |d � dd�\}}W n
114 tyZ td | ��w |�|� |d
115 7 }nd }|s/n |� d �}|d
116 �|�7 }| }q
117 ||fS ) Nr� r� Frn z%(r r z)sz+Pyformat SQL has incorrect format near "%s"r� z%s)r� r� r7 r r
118 �join)r� r� Z outparamsr� r� r� r� r[ r r r �changeFormatToQmark� s@ � ��
119
120 ��
121 r� )�r" �
122 __future__r r& r� r� r� r. �collections.abcr r r r� r r� r� r � Exceptionr r r r r r r r r r r! r# r^ ri Zbase_dateconverterZ threadsafetyZapilevelZ
123 paramstyleZaccepted_paramstylesZ adIntegerZ
124 adSmallIntZ adTinyIntZ
125 adUnsignedIntZadUnsignedSmallIntZadUnsignedTinyIntZ adBooleanZadErrorZadoIntegerTypesZ adChapterZ
126 adoRowIdTypesr� Z
127 adFileTimeZadUnsignedBigIntZ adoLongTypesZ adDecimalZ adNumericZ adVarNumericZ
128 adCurrencyZadoExactNumericTypesr� ZadSingleZadoApproximateNumericTypesr� ZadCharZ
129 adLongVarCharZadLongVarWCharZ adVarCharZ
130 adVarWCharZadWCharZadoStringTypesZadBinaryZadLongVarBinaryZ adVarBinaryZadoBinaryTypesZadDBTimeZ
131 adDBTimeStampr� ZadDBDateZadoDateTimeTypesZadEmptyZ adIDispatchZ
132 adIUnknownZ
133 adPropVariantZadArrayZ
134 adUserDefinedZ adVariantZadGUIDZadoRemainingTypesrt �STRING�BINARY�NUMBERZDATETIMEZROWID�OTHER�
135 memoryviewrA r* r� �boolr� rb r� r r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� �objectr� ZvariantConversionsr� r� Z RS_WIN_32r� r� r� r� r� r� r r r r �<module> s� AE! �
136 � � �
137 �
138 � "��J: *