File manager - Edit - /opt/saltstack/salt/lib/python3.10/site-packages/salt/pillar/__pycache__/mysql.cpython-310.pyc
Back
o ;j � @ s� d Z ddlZddlmZ ddlmZ e�e�Zzddl Z ddl Z ddl Z W n+ e yP zddl Z e �� ddl Z ddl Z ddl Z W n e yM dZ Y nw Y nw dd� ZG dd� de�Zd d � ZdS ) a� Retrieve Pillar data by doing a MySQL query MariaDB provides Python support through the MySQL Python package. Therefore, you may use this module with both MySQL or MariaDB. This module is a concrete implementation of the sql_base ext_pillar for MySQL. :maturity: new :depends: python-mysqldb :platform: all Configuring the mysql ext_pillar ================================ Use the 'mysql' key under ext_pillar for configuration of queries. MySQL configuration of the MySQL returner is being used (mysql.db, mysql.user, mysql.pass, mysql.port, mysql.host) for database connection info. Required python modules: MySQLdb Complete example ================ .. code-block:: yaml mysql: user: 'salt' pass: 'super_secret_password' db: 'salt_db' port: 3306 ssl: cert: /etc/mysql/client-cert.pem key: /etc/mysql/client-key.pem ext_pillar: - mysql: fromdb: query: 'SELECT col1,col2,col3,col4,col5,col6,col7 FROM some_random_table WHERE minion_pattern LIKE %s' depth: 5 as_list: True with_lists: [1,3] � N)�contextmanager)�SqlBaseExtPillarc C s t t�tdu r dfS dfS )z: Confirm that a python mysql client is installed. Nz!No python mysql client installed.� )�bool�MySQLdb� r r �E/opt/saltstack/salt/lib/python3.10/site-packages/salt/pillar/mysql.py� __virtual__J s r c s@ e Zd ZdZedd� �Zdd� Zedd� �Z� fdd �Z � Z S ) �MySQLExtPillarzI This class receives and processes the database rows from MySQL. c C s dS )NZMySQLr )�clsr r r �_db_nameV s zMySQLExtPillar._db_namec C s^ dddddi d�}i }t �di �}|D ]}||vr&t�d|� || ||< q|| ||< q|S )z@ Returns options used for the MySQL connection. Z localhost�salti� )�host�user�pass�db�port�sslZmysqlzUsing default for MySQL %s)Z__opts__�get�log�debug)�self�defaults�_optionsZ_opts�attrr r r � _get_optionsZ s � zMySQLExtPillar._get_optionsc c s� � | � � }tj|d |d |d |d |d |d d�}|�� }z.z|V W n tjy@ } z t�d|j� W Y d }~n d }~ww W |�� d S W |�� d S |�� w ) z& Yield a MySQL cursor r r r r r r )r r �passwdr r r z Error in ext_pillar MySQL: %sN) r r �connect�cursorZ DatabaseErrorr � exception�args�close)r r �connr �errr r r � _get_cursorp s* �� ��� �zMySQLExtPillar._get_cursorc s t � �||�S )z� This function normalizes the config block into a set of queries we can use. The return is a list of consistently laid out dicts. )�super�extract_queries)r r �kwargs�� __class__r r r& � s z MySQLExtPillar.extract_queries) �__name__� __module__� __qualname__�__doc__� classmethodr r r r$ r& � __classcell__r r r( r r Q s r c O s t � j| |g|�R i |��S )zC Execute queries against MySQL, merge and return as a dict )r Zfetch)Z minion_idZpillarr r' r r r � ext_pillar� s r0 )r- �logging� contextlibr Zsalt.pillar.sql_baser � getLoggerr* r r ZMySQLdb.convertersZMySQLdb.cursors� ImportErrorZpymysqlZinstall_as_MySQLdbr r r0 r r r r �<module> s0 / ��� =
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | Generation time: 0 |
proxy
|
phpinfo
|
Settings