a
    •˜ëjI  ã                   @   s$  d Z ddlZddlZddlmZ ddlmZ ddlm	Z	 ddlm
Z
 ddlmZ dd	lmZ dd
lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z  ddl!m"Z" G dd„ de j#ƒZ$G dd„ de j%ƒZ&G dd „ d e&e j'ƒZ(G d!d"„ d"e&ƒZ)G d#d$„ d$eƒZ*G d%d&„ d&eƒZ+G d'd(„ d(e jj,ƒZ-G d)d*„ d*e jj.ƒZ/G d+d,„ d,e jj0ƒZ1G d-d.„ d.eƒZ2G d/d0„ d0eƒZ3G d1d2„ d2eƒZ4G d3d4„ d4e j5ƒZ6G d5d6„ d6e j7ƒZ8G d7d8„ d8e j9ƒZ:G d9d:„ d:e j;ƒZ<G d;d<„ d<e j=ƒZ>G d=d>„ d>e j?ƒZ@G d?d@„ d@e jAƒZBG dAdB„ dBe jCƒZDG dCdD„ dDeƒZEG dEdF„ dFeeƒZFG dGdH„ dHejGƒZHG dIdJ„ dJejIƒZJe K¡ ZLG dKdL„ dLeƒZMG dMdN„ dNƒZNG dOdP„ dPeƒZOG dQdR„ dReƒZPG dSdT„ dTeƒZQeQZRdS )Uañ	  
.. dialect:: postgresql+pg8000
    :name: pg8000
    :dbapi: pg8000
    :connectstring: postgresql+pg8000://user:password@host:port/dbname[?key=value&key=value...]
    :url: https://pypi.org/project/pg8000/

.. versionchanged:: 1.4  The pg8000 dialect has been updated for version
   1.16.6 and higher, and is again part of SQLAlchemy's continuous integration
   with full feature support.

.. _pg8000_unicode:

Unicode
-------

pg8000 will encode / decode string values between it and the server using the
PostgreSQL ``client_encoding`` parameter; by default this is the value in
the ``postgresql.conf`` file, which often defaults to ``SQL_ASCII``.
Typically, this can be changed to ``utf-8``, as a more useful default::

    # client_encoding = sql_ascii # actually, defaults to database encoding
    client_encoding = utf8

The ``client_encoding`` can be overridden for a session by executing the SQL:

.. sourcecode:: sql

    SET CLIENT_ENCODING TO 'utf8';

SQLAlchemy will execute this SQL on all new connections based on the value
passed to :func:`_sa.create_engine` using the ``client_encoding`` parameter::

    engine = create_engine(
        "postgresql+pg8000://user:pass@host/dbname", client_encoding="utf8"
    )

.. _pg8000_ssl:

SSL Connections
---------------

pg8000 accepts a Python ``SSLContext`` object which may be specified using the
:paramref:`_sa.create_engine.connect_args` dictionary::

    import ssl

    ssl_context = ssl.create_default_context()
    engine = sa.create_engine(
        "postgresql+pg8000://scott:tiger@192.168.0.199/test",
        connect_args={"ssl_context": ssl_context},
    )

If the server uses an automatically-generated certificate that is self-signed
or does not match the host name (as seen from the client), it may also be
necessary to disable hostname checking::

    import ssl

    ssl_context = ssl.create_default_context()
    ssl_context.check_hostname = False
    ssl_context.verify_mode = ssl.CERT_NONE
    engine = sa.create_engine(
        "postgresql+pg8000://scott:tiger@192.168.0.199/test",
        connect_args={"ssl_context": ssl_context},
    )

.. _pg8000_isolation_level:

pg8000 Transaction Isolation Level
-------------------------------------

The pg8000 dialect offers the same isolation level settings as that
of the :ref:`psycopg2 <psycopg2_isolation_level>` dialect:

* ``READ COMMITTED``
* ``READ UNCOMMITTED``
* ``REPEATABLE READ``
* ``SERIALIZABLE``
* ``AUTOCOMMIT``

.. seealso::

    :ref:`postgresql_isolation_level`

    :ref:`psycopg2_isolation_level`


é    Né   )Úranges)ÚARRAY)Ú_DECIMAL_TYPES)Ú_FLOAT_TYPES)Ú
_INT_TYPES)ÚENUM©ÚINTERVAL)Ú
PGCompiler)Ú	PGDialect)ÚPGExecutionContext)ÚPGIdentifierPreparer)ÚJSON)ÚJSONB)ÚJSONPathType)Ú_SpaceVector)Ú	OIDVECTOR)ÚCITEXTé   )Úexc)Úutil)Ú
processors)Úsqltypes)Úquoted_namec                   @   s   e Zd ZdZdS )Ú	_PGStringTN©Ú__name__Ú
__module__Ú__qualname__Úrender_bind_cast© r!   r!   úd/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/postgresql/pg8000.pyr   ~   s   r   c                   @   s   e Zd ZdZdd„ ZdS )Ú
_PGNumericTc                 C   sv   | j rB|tv rt tj| j¡S |tv s.|tv r2d S t	 
d| ¡‚n0|tv rNd S |tv s^|tv rdtjS t	 
d| ¡‚d S )NzUnknown PG numeric type: %d)Z	asdecimalr   r   Zto_decimal_processor_factoryÚdecimalÚDecimalZ_effective_decimal_return_scaler   r   r   ZInvalidRequestErrorZto_float©ÚselfÚdialectÚcoltyper!   r!   r"   Úresult_processor…   s"    ÿÿÿz_PGNumeric.result_processorN©r   r   r   r    r*   r!   r!   r!   r"   r#   ‚   s   r#   c                   @   s   e Zd ZdZdZdS )Ú_PGFloatÚfloatTN©r   r   r   Z__visit_name__r    r!   r!   r!   r"   r,   ž   s   r,   c                   @   s   e Zd Zdd„ ZdS )Ú_PGNumericNoBindc                 C   s   d S ©Nr!   )r'   r(   r!   r!   r"   Úbind_processor¤   s    z_PGNumericNoBind.bind_processorN)r   r   r   r1   r!   r!   r!   r"   r/   £   s   r/   c                   @   s   e Zd ZdZdd„ ZdS )Ú_PGJSONTc                 C   s   d S r0   r!   r&   r!   r!   r"   r*   «   s    z_PGJSON.result_processorNr+   r!   r!   r!   r"   r2   ¨   s   r2   c                   @   s   e Zd ZdZdd„ ZdS )Ú_PGJSONBTc                 C   s   d S r0   r!   r&   r!   r!   r"   r*   ²   s    z_PGJSONB.result_processorNr+   r!   r!   r!   r"   r3   ¯   s   r3   c                   @   s   e Zd Zdd„ ZdS )Ú_PGJSONIndexTypec                 C   s   t dƒ‚d S )Nzshould not be here)ÚNotImplementedError©r'   Údbapir!   r!   r"   Úget_dbapi_type·   s    z_PGJSONIndexType.get_dbapi_typeN©r   r   r   r8   r!   r!   r!   r"   r4   ¶   s   r4   c                   @   s   e Zd ZdZdZdS )Ú_PGJSONIntIndexTypeZjson_int_indexTNr.   r!   r!   r!   r"   r:   »   s   r:   c                   @   s   e Zd ZdZdZdS )Ú_PGJSONStrIndexTypeZjson_str_indexTNr.   r!   r!   r!   r"   r;   Á   s   r;   c                   @   s   e Zd ZdS )Ú_PGJSONPathTypeN©r   r   r   r!   r!   r!   r"   r<   Ç   s   r<   c                   @   s   e Zd Zdd„ ZdS )Ú_PGEnumc                 C   s   |j S r0   )ÚUNKNOWNr6   r!   r!   r"   r8   Î   s    z_PGEnum.get_dbapi_typeNr9   r!   r!   r!   r"   r>   Í   s   r>   c                   @   s$   e Zd ZdZdd„ Zedd„ ƒZdS )Ú_PGIntervalTc                 C   s   |j S r0   r	   r6   r!   r!   r"   r8   Õ   s    z_PGInterval.get_dbapi_typec                 K   s   t |jd�S )N)Z	precision)r@   Zsecond_precision)ÚclsÚintervalÚkwr!   r!   r"   Úadapt_emulated_to_nativeØ   s    z$_PGInterval.adapt_emulated_to_nativeN)r   r   r   r    r8   ÚclassmethodrD   r!   r!   r!   r"   r@   Ò   s   r@   c                   @   s   e Zd ZdZdS )Ú_PGTimeStampTNr   r!   r!   r!   r"   rF   Ý   s   rF   c                   @   s   e Zd ZdZdS )Ú_PGDateTNr   r!   r!   r!   r"   rG   á   s   rG   c                   @   s   e Zd ZdZdS )Ú_PGTimeTNr   r!   r!   r!   r"   rH   å   s   rH   c                   @   s   e Zd ZdZdS )Ú
_PGIntegerTNr   r!   r!   r!   r"   rI   é   s   rI   c                   @   s   e Zd ZdZdS )Ú_PGSmallIntegerTNr   r!   r!   r!   r"   rJ   í   s   rJ   c                   @   s   e Zd ZdS )Ú_PGNullTypeNr=   r!   r!   r!   r"   rK   ñ   s   rK   c                   @   s   e Zd ZdZdS )Ú_PGBigIntegerTNr   r!   r!   r!   r"   rL   õ   s   rL   c                   @   s   e Zd ZdZdS )Ú
_PGBooleanTNr   r!   r!   r!   r"   rM   ù   s   rM   c                   @   s   e Zd ZdZdS )Ú_PGARRAYTNr   r!   r!   r!   r"   rN   ý   s   rN   c                   @   s   e Zd ZdS )Ú_PGOIDVECTORNr=   r!   r!   r!   r"   rO     s   rO   c                   @   s   e Zd Zdd„ Zdd„ ZdS )Ú_Pg8000Rangec                    s   |j j‰ ‡ fdd„}|S )Nc                    s&   t | tjƒr"ˆ | j| j| j| jƒ} | S r0   )Ú
isinstancer   ÚRangeÚlowerÚupperÚboundsÚempty©Úvalue©Zpg8000_Ranger!   r"   Úto_range	  s
    ÿz-_Pg8000Range.bind_processor.<locals>.to_range©r7   rR   )r'   r(   rZ   r!   rY   r"   r1     s    z_Pg8000Range.bind_processorc                 C   s   dd„ }|S )Nc                 S   s&   | d ur"t j| j| j| j| jd�} | S )N©rU   rV   ©r   rR   rS   rT   rU   Zis_emptyrW   r!   r!   r"   rZ     s    üz/_Pg8000Range.result_processor.<locals>.to_ranger!   )r'   r(   r)   rZ   r!   r!   r"   r*     s    
z_Pg8000Range.result_processorN©r   r   r   r1   r*   r!   r!   r!   r"   rP     s   rP   c                   @   s   e Zd Zdd„ Zdd„ ZdS )Ú_Pg8000MultiRangec                    s   |j j‰ ‡ fdd„}|S )Nc                    sX   t | tƒrPg }| D ]8}t |tjƒr@| ˆ |j|j|j|jƒ¡ q| |¡ q|S | S d S r0   )	rQ   Úlistr   rR   ÚappendrS   rT   rU   rV   )rX   ÚmrÚvrY   r!   r"   Úto_multirange$  s    
ÿz7_Pg8000MultiRange.bind_processor.<locals>.to_multiranger[   )r'   r(   rd   r!   rY   r"   r1   !  s    z _Pg8000MultiRange.bind_processorc                 C   s   dd„ }|S )Nc                 S   s$   | d u rd S t  dd„ | D ƒ¡S d S )Nc                 s   s(   | ] }t j|j|j|j|jd �V  qdS )r\   Nr]   )Ú.0rc   r!   r!   r"   Ú	<genexpr>9  s   ýÿzL_Pg8000MultiRange.result_processor.<locals>.to_multirange.<locals>.<genexpr>)r   Z
MultiRangerW   r!   r!   r"   rd   5  s
    
üz9_Pg8000MultiRange.result_processor.<locals>.to_multiranger!   )r'   r(   r)   rd   r!   r!   r"   r*   4  s    z"_Pg8000MultiRange.result_processorNr^   r!   r!   r!   r"   r_      s   r_   c                   @   s   e Zd Zdd„ Zdd„ ZdS )ÚPGExecutionContext_pg8000c                 C   s:   dt t| ƒƒdd … t tƒ ƒdd … f }t| j ¡ |ƒS )Nzc_%s_%sé   )ÚhexÚidÚ_server_side_idÚServerSideCursorZ_dbapi_connectionÚcursor)r'   Úidentr!   r!   r"   Úcreate_server_side_cursorG  s    *z3PGExecutionContext_pg8000.create_server_side_cursorc                 C   s   | j s
d S d S r0   )Zcompiled©r'   r!   r!   r"   Úpre_execK  s    z"PGExecutionContext_pg8000.pre_execN)r   r   r   ro   rq   r!   r!   r!   r"   rg   F  s   rg   c                   @   s‚   e Zd ZdZdd„ Zedd„ ƒZedd„ ƒZedd	„ ƒZddd„Z	dd„ Z
dd„ Zddd„Zdd„ Zdd„ Zdd„ Zddd„ZdS )rl   Tc                 C   s   || _ || _d S r0   )rn   rm   )r'   rm   rn   r!   r!   r"   Ú__init__S  s    zServerSideCursor.__init__c                 C   s   | j jS r0   )rm   Ú
connectionrp   r!   r!   r"   rs   W  s    zServerSideCursor.connectionc                 C   s   | j jS r0   )rm   Úrowcountrp   r!   r!   r"   rt   [  s    zServerSideCursor.rowcountc                 C   s   | j jS r0   )rm   Údescriptionrp   r!   r!   r"   ru   _  s    zServerSideCursor.descriptionr!   Nc                 C   s(   d| j  d | }| jj|||d� | S )NzDECLARE z NO SCROLL CURSOR FOR )Ústream)rn   rm   Úexecute)r'   Ú	operationÚargsrv   Úopr!   r!   r"   rw   c  s    zServerSideCursor.executec                 C   s   | j  ||¡ | S r0   )rm   Úexecutemany)r'   rx   Z
param_setsr!   r!   r"   r{   h  s    zServerSideCursor.executemanyc                 C   s   | j  d| j ¡ | j  ¡ S )NzFETCH FORWARD 1 FROM )rm   rw   rn   Úfetchonerp   r!   r!   r"   r|   l  s    zServerSideCursor.fetchonec                 C   s@   |d u r|   ¡ S | j dtt|ƒƒ d | j ¡ | j  ¡ S d S )NzFETCH FORWARD z FROM )Úfetchallrm   rw   ÚstrÚintrn   )r'   Únumr!   r!   r"   Ú	fetchmanyp  s    ÿzServerSideCursor.fetchmanyc                 C   s   | j  d| j ¡ | j  ¡ S )NzFETCH FORWARD ALL FROM )rm   rw   rn   r}   rp   r!   r!   r"   r}   y  s    zServerSideCursor.fetchallc                 C   s    | j  d| j ¡ | j  ¡  d S )NzCLOSE )rm   rw   rn   Úcloserp   r!   r!   r"   r‚   }  s    zServerSideCursor.closec                 G   s   | j j|Ž  d S r0   )rm   Úsetinputsizes)r'   Úsizesr!   r!   r"   rƒ   �  s    zServerSideCursor.setinputsizesc                 C   s   d S r0   r!   )r'   ÚsizeÚcolumnr!   r!   r"   Úsetoutputsize„  s    zServerSideCursor.setoutputsize)r!   N)N)N)r   r   r   Úserver_siderr   Úpropertyrs   rt   ru   rw   r{   r|   r�   r}   r‚   rƒ   r‡   r!   r!   r!   r"   rl   P  s    




	rl   c                   @   s   e Zd Zdd„ ZdS )ÚPGCompiler_pg8000c                 K   s,   | j |jfi |¤Žd | j |jfi |¤Ž S )Nz %% )ÚprocessÚleftÚright)r'   ÚbinaryÚoperatorrC   r!   r!   r"   Úvisit_mod_binary‰  s    ÿþÿz"PGCompiler_pg8000.visit_mod_binaryN)r   r   r   r�   r!   r!   r!   r"   rŠ   ˆ  s   rŠ   c                   @   s   e Zd Zdd„ ZdS )ÚPGIdentifierPreparer_pg8000c                 O   s"   t j| g|¢R i |¤Ž d| _d S )NF)r   rr   Z_double_percents)r'   ry   Úkwargsr!   r!   r"   rr   ’  s    z$PGIdentifierPreparer_pg8000.__init__N)r   r   r   rr   r!   r!   r!   r"   r‘   ‘  s   r‘   c                K   @   sÞ  e Zd ZdZdZdZdZdZdZe	Z
eZeZdZdZdZe ejejeejeejeejeeje ej!e"e#e$e%e%ejj&e'ejj(e)ejj*e+ejj,e-ej.e/e0e/ej1e2ej1e2ej3e4ej5e6ej7e8ej9e:ej;e<ej=e>ej?e@eAeBeCjDeEeCjFeEeCjGeEeCjHeEeCjIeEeCjJeEeCjKeLeCjMeLeCjNeLeCjOeLeCjPeLeCjQeLi$¡Zd/dd„ZRejSdd„ ƒZTeUd	d
„ ƒZVdd„ ZWdd„ ZXdd„ ZYdd„ ZZe[dœdd„Z\dd„ Z]dd„ Z^dd„ Z_dd„ Z`dd„ Zad d!„ Zbd"d#„ Zcd0d%d&„Zdd1d'd(„Zed)d*„ Zfd+d,„ ZgejSd-d.„ ƒZhdS )2ÚPGDialect_pg8000Úpg8000TÚformatNc                 K   s<   t j| fi |¤Ž || _| jdk r*tdƒ‚| jr8tdƒ‚d S )N)r   é   é   z$pg8000 1.16.6 or greater is requiredznThe pg8000 dialect does not fully implement ipaddress type handling; INET is supported by default, CIDR is not)r   rr   Úclient_encodingÚ_dbapi_versionr5   Ú_native_inet_types)r'   r˜   r’   r!   r!   r"   rr   ×  s    
ÿzPGDialect_pg8000.__init__c                 C   s8   | j r0t| j dƒr0tdd„ t d| j j¡D ƒƒS dS d S )NÚ__version__c                 S   s   g | ]}t |ƒ‘qS r!   )r   )re   Úxr!   r!   r"   Ú
<listcomp>é  s   ÿz3PGDialect_pg8000._dbapi_version.<locals>.<listcomp>z(\d+)(?:[-\.]?|$))éc   rž   rž   )r7   ÚhasattrÚtupleÚreÚfindallr›   rp   r!   r!   r"   r™   å  s    ÿþÿ	zPGDialect_pg8000._dbapi_versionc                 C   s   t dƒS )Nr”   )Ú
__import__)rA   r!   r!   r"   Úimport_dbapió  s    zPGDialect_pg8000.import_dbapic                 C   s8   |j dd�}d|v r$t|d ƒ|d< | |j¡ g |fS )NÚuser)ÚusernameÚport)Ztranslate_connect_argsr   ÚupdateÚquery)r'   ÚurlÚoptsr!   r!   r"   Úcreate_connect_args÷  s
    z$PGDialect_pg8000.create_connect_argsc                 C   s*   t || jjƒrdt|ƒv rdS dt|ƒv S )Nznetwork errorTzconnection is closed)rQ   r7   ZInterfaceErrorr~   )r'   Úers   rm   r!   r!   r"   Úis_disconnectþ  s
    ÿzPGDialect_pg8000.is_disconnectc                 C   s   dS )N)Ú
AUTOCOMMITzREAD COMMITTEDzREAD UNCOMMITTEDzREPEATABLE READZSERIALIZABLEr!   )r'   Údbapi_connectionr!   r!   r"   Úget_isolation_level_values  s    z+PGDialect_pg8000.get_isolation_level_valuesc                 C   sP   |  dd¡}|dkrd|_n0d|_| ¡ }| d|› �¡ | d¡ | ¡  d S )NÚ_ú r¯   TFz;SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL ÚCOMMIT)ÚreplaceÚ
autocommitrm   rw   r‚   )r'   r°   Úlevelrm   r!   r!   r"   Úset_isolation_level  s    ÿÿ
z$PGDialect_pg8000.set_isolation_level)Úreturnc                 C   s
   t |jƒS r0   )Úboolr¶   )r'   Z
dbapi_connr!   r!   r"   Údetect_autocommit_setting   s    z*PGDialect_pg8000.detect_autocommit_settingc                 C   sD   |  ¡ }z,| d|rdnd ¡ | d¡ W | ¡  n
| ¡  0 d S )Nú-SET SESSION CHARACTERISTICS AS TRANSACTION %sz	READ ONLYz
READ WRITEr´   ©rm   rw   r‚   ©r'   rs   rX   rm   r!   r!   r"   Úset_readonly#  s    
ÿÿzPGDialect_pg8000.set_readonlyc                 C   s>   |  ¡ }z"| d¡ | ¡ d }W | ¡  n
| ¡  0 |dkS )Nzshow transaction_read_onlyr   Úon©rm   rw   r|   r‚   ©r'   rs   rm   Úvalr!   r!   r"   Úget_readonly.  s    
zPGDialect_pg8000.get_readonlyc                 C   sD   |  ¡ }z,| d|rdnd ¡ | d¡ W | ¡  n
| ¡  0 d S )Nr¼   Z
DEFERRABLEzNOT DEFERRABLEr´   r½   r¾   r!   r!   r"   Úset_deferrable8  s    
ÿÿzPGDialect_pg8000.set_deferrablec                 C   s>   |  ¡ }z"| d¡ | ¡ d }W | ¡  n
| ¡  0 |dkS )Nzshow transaction_deferrabler   rÀ   rÁ   rÂ   r!   r!   r"   Úget_deferrableC  s    
zPGDialect_pg8000.get_deferrablec                 C   s8   |  ¡ }| d| dd¡› d�¡ | d¡ | ¡  d S )Nz%
            SET CLIENT_ENCODING TO 'ú'z''r´   )rm   rw   rµ   r‚   )r'   r°   r˜   rm   r!   r!   r"   Ú_set_client_encodingM  s    
ÿ

z%PGDialect_pg8000._set_client_encodingc                 C   s   |j  d|df¡ d S ©Nr   Ú )rs   Z	tpc_begin©r'   rs   Úxidr!   r!   r"   Údo_begin_twophaseT  s    z"PGDialect_pg8000.do_begin_twophasec                 C   s   |j  ¡  d S r0   )rs   Ztpc_preparerË   r!   r!   r"   Údo_prepare_twophaseW  s    z$PGDialect_pg8000.do_prepare_twophaseFc                 C   s   |j  d|df¡ d S rÉ   )rs   Ztpc_rollback©r'   rs   rÌ   Zis_preparedZrecoverr!   r!   r"   Údo_rollback_twophaseZ  s    z%PGDialect_pg8000.do_rollback_twophasec                 C   s   |j  d|df¡ d S rÉ   )rs   Z
tpc_commitrÏ   r!   r!   r"   Údo_commit_twophase_  s    z#PGDialect_pg8000.do_commit_twophasec                 C   s   dd„ |j  ¡ D ƒS )Nc                 S   s   g | ]}|d  ‘qS )r   r!   )re   Úrowr!   r!   r"   r�   e  ó    z8PGDialect_pg8000.do_recover_twophase.<locals>.<listcomp>)rs   Ztpc_recover)r'   rs   r!   r!   r"   Údo_recover_twophased  s    z$PGDialect_pg8000.do_recover_twophasec                    s’   g ‰ dd„ }ˆ   |¡ ˆjd ur6‡fdd„}ˆ   |¡ ˆjdu rRdd„ }ˆ   |¡ ˆjrn‡fdd„}ˆ   |¡ tˆ ƒdkrŠ‡ fdd„}|S d S d S )	Nc                 S   s   | j t | j t< d S r0   )Zpy_typesr~   r   ©Úconnr!   r!   r"   Ú
on_connectj  s    z/PGDialect_pg8000.on_connect.<locals>.on_connectc                    s   ˆ   | ˆ j¡ d S r0   )rÈ   r˜   rÕ   rp   r!   r"   r×   q  s    Fc                 S   s$   |   ddd„ ¡ |   ddd„ ¡ d S )Nie  c                 S   s   | S r0   r!   ©Úsr!   r!   r"   Ú<lambda>z  rÓ   zAPGDialect_pg8000.on_connect.<locals>.on_connect.<locals>.<lambda>iŠ  c                 S   s   | S r0   r!   rØ   r!   r!   r"   rÚ   }  rÓ   )Úregister_in_adapterrÕ   r!   r!   r"   r×   x  s    c                    s    |   dˆ j¡ |   dˆ j¡ d S )Nér   iÚ  )rÛ   Ú_json_deserializerrÕ   rp   r!   r"   r×   ƒ  s    r   c                    s   ˆ D ]}|| ƒ qd S r0   r!   )rÖ   Úfn)Úfnsr!   r"   r×   Ž  s    )ra   r˜   rš   rÝ   Úlen)r'   r×   r!   )rß   r'   r"   r×   g  s     





zPGDialect_pg8000.on_connectc                 C   s   dS )Nú;r!   rp   r!   r!   r"   Ú_dialect_specific_select_one–  s    z-PGDialect_pg8000._dialect_specific_select_one)N)TF)TF)ir   r   r   ZdriverZsupports_statement_cacheZsupports_unicode_statementsZsupports_unicode_bindsZdefault_paramstyleZsupports_sane_multi_rowcountrg   Zexecution_ctx_clsrŠ   Zstatement_compilerr‘   ÚpreparerZsupports_server_side_cursorsr    Zdescription_encodingr   Zupdate_copyr   Zcolspecsr   ÚStringr   ÚNumericr/   ÚFloatr,   r   r2   ÚBooleanrM   ÚNullTyperK   r   r3   r   r   r<   ÚJSONIndexTyper4   ÚJSONIntIndexTyper:   ÚJSONStrIndexTyper;   ZIntervalr@   r
   ÚDateTimerF   ÚDaterG   ÚTimerH   ÚIntegerrI   ÚSmallIntegerrJ   Ú
BigIntegerrL   ÚEnumr>   r   rN   r   rO   r   Z	INT4RANGErP   Z	INT8RANGEZNUMRANGEZ	DATERANGEZTSRANGEZ	TSTZRANGEZINT4MULTIRANGEr_   ZINT8MULTIRANGEZNUMMULTIRANGEZDATEMULTIRANGEZTSMULTIRANGEZTSTZMULTIRANGErr   Zmemoized_propertyr™   rE   r¤   r¬   r®   r±   r¸   rº   r»   r¿   rÄ   rÅ   rÆ   rÈ   rÍ   rÎ   rÐ   rÑ   rÔ   r×   râ   r!   r!   r!   r"   r“   —  sš   Üþ*



	

 ÿ
 ÿ
/r“   )SÚ__doc__r$   r¡   rÊ   r   Úarrayr   ZPGARRAYÚbaser   r   r   r   r
   r   r   r   r   Újsonr   r   r   Z
pg_catalogr   r   Útypesr   r   r   Zenginer   Zsqlr   Zsql.elementsr   rä   r   rå   r#   ræ   r,   r/   r2   r3   ré   r4   rê   r:   rë   r;   r<   r>   r@   rì   rF   rí   rG   rî   rH   rï   rI   rð   rJ   rè   rK   rñ   rL   rç   rM   rN   rO   ZAbstractSingleRangeImplrP   ZAbstractMultiRangeImplr_   Úcounterrk   rg   rl   rŠ   r‘   r“   r(   r!   r!   r!   r"   Ú<module>	   sr   Z#
8	  