File manager - Edit - /opt/saltstack/salt/lib/python3.10/site-packages/salt/modules/__pycache__/oracle.cpython-310.pyc
Back
o ;j^ � @ s� d Z ddlZddlZddlmZ e�e�ZzddlZej ej d�Z dZ W n e y4 ddd�Z dZ Y nw d Zd d � Zd d � Zdd� Zdd� Zeded�dd� �Zdd� Zeded�dd� �Zeded�dd� �Zd d d �Zd d � ZdS )!a� Oracle DataBase connection module :maintainer: Vladimir Bormotov <bormotov@gmail.com> :maturity: new :depends: cx_Oracle :platform: all :configuration: module provide connections for multiple Oracle DB instances. **OS Environment** .. code-block:: yaml ORACLE_HOME: path to oracle product PATH: path to Oracle Client libs need to be in PATH **pillar** .. code-block:: yaml oracle: dbs: <db>: uri: connection credentials in format: user/password@host[:port]/sid[ servicename as {sysdba|sysoper}] optional keyword servicename will determine whether it is a sid or service_name <db>: uri: ..... � N)�depends)ZsysdbaZsysoperT� � F�oraclec C s t rtS dS )z1 Load module only if cx_Oracle installed )FzDoracle execution module not loaded: python oracle library not found.)� HAS_CX_ORACLE�__virtualname__� r r �G/opt/saltstack/salt/lib/python3.10/site-packages/salt/modules/oracle.py� __virtual__6 s r c C s dS )z Fallback function stub zDNeed "cx_Oracle" and Oracle Client installed for this function existr r r r r �_cx_oracle_reqB s r c C s, |t jt jt jt jfv r| �t|| j�S dS )z� Return strings values as python unicode string http://www.oracle.com/technetwork/articles/dsl/tuininga-cx-oracle-084866.html N)� cx_Oracle�STRINGZ LONG_STRINGZ FIXED_CHARZCLOB�var�strZ arraysize)�cursor�nameZ default_type�sizeZ precisionZscaler r r �_unicode_outputI s ��r c C s | � dd�}t|�dkr|\}}t| }n|d }d}d}|�d�\}}|�d�\}}|�d�\} } d| v rAd }| �d�d �� } | �d �} t| �dkrQ| \} } n| d } d } t�d ||| | | |f� d tjd< |ryt � ||t j | | | d�|�}n t � ||t � | | | �|�}t |_ |S )zm uri = user/password@host[:port]/sid[ as {sysdba|sysoper}] Return cx_Oracle.Connection instance z as � r r F�@�/Z servicenameT�:i� z connect: %sz .AL32UTF8�NLS_LANG)Z service_name)�rsplit�len�MODE�split�strip�log�debug�os�environr �connectZmakedsnr Zoutputtypehandler)�uriZuri_lZ credentials�modeZ serv_nameZuserpassZ hostportsid�user�passwordZhostportZsidZ hostport_l�host�port�connr r r �_connectX s: ��r* r )Zfallback_functionc C s4 t �d| |� tt| �| d �}|�� �|��� S )z� Run SQL query and return result CLI Example: .. code-block:: bash salt '*' oracle.run_query my_db "select * from my_table" zrun query on %s: %sr# )r r r* �show_dbsr ZexecuteZfetchall)�db�queryr) r r r � run_query� s r. c G sV | rt �d| � i }| D ] }td d| �||< q |S td d�}t �dt|�� |S )z� Show databases configuration from pillar. Filter by `*args` CLI Example: .. code-block:: bash salt '*' oracle.show_dbs salt '*' oracle.show_dbs my_db zget dbs from pillar: %s� pillar.getz oracle:dbs:� oracle:dbsz get all (%s) dbs from pillar)r r �__salt__r )�dbs�resultr, � pillar_dbsr r r r+ � s r+ c G st t d d�}dd� }i }| r%t�d| � | D ] }||v r"||�||< q|S t�dt| �� | D ]}||�||< q/|S )z� Server Version (select banner from v$version) CLI Example: .. code-block:: bash salt '*' oracle.version salt '*' oracle.version my_db r/ r0 c S s dd� t | d�D �S )Nc S s g | ]}|d �qS )r r )�.0�rr r r � <listcomp>� s �z0version.<locals>.get_version.<locals>.<listcomp>z,select banner from v$version order by banner)r. )�xr r r � get_version� s �z version.<locals>.get_versionzget db versions for: %szget all (%s) dbs versions)r1 r r r )r2 r4 r9 r3 r, r r r �version� s ��r: c C s d� dd� t�� D ��S )zs Oracle Client Version CLI Example: .. code-block:: bash salt '*' oracle.client_version �.c s s � | ]}t |�V qd S �N)r )r5 r8 r r r � <genexpr>� s � z!client_version.<locals>.<genexpr>)�joinr Z clientversionr r r r �client_version� s r? c C s | r t d d| �S t d d�S )z� Show Pillar segment oracle.* and subitem with notation "item:subitem" CLI Example: .. code-block:: bash salt '*' oracle.show_pillar salt '*' oracle.show_pillar dbs:my_db r/ zoracle:r )r1 )�itemr r r � show_pillar� s rA c C s2 g d�} i }| D ]}|t jv rt j| ||< q|S )z� Show Environment used by Oracle Client CLI Example: .. code-block:: bash salt '*' oracle.show_env .. note:: at first _connect() ``NLS_LANG`` will forced to '.AL32UTF8' )�PATHZ ORACLE_HOMEZ TNS_ADMINr )r r! )Zenvsr3 �envr r r �show_env� s �rD r< )�__doc__�loggingr Zsalt.utils.decoratorsr � getLogger�__name__r r ZSYSDBAZSYSOPERr r � ImportErrorr r r r r* r. r+ r: r? rA rD r r r r �<module> s6 " � +
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | Generation time: 0 |
proxy
|
phpinfo
|
Settings