File manager - Edit - /opt/saltstack/salt/lib/python3.10/site-packages/salt/states/__pycache__/sqlite3.cpython-310.pyc
Back
o ;j�: � @ sx d Z zddlZdZW n ey dZY nw dd� Zddd�Zdd d �Zd d � Zdd d�Zddd�Z dd� Z dd� Z dS )a� Management of SQLite3 databases =============================== .. versionadded:: 2016.3.0 :depends: - SQLite3 Python Module :configuration: See :py:mod:`salt.modules.sqlite3` for setup instructions The sqlite3 module is used to create and manage sqlite3 databases and execute queries Here is an example of creating a table using sql statements: .. code-block:: yaml users: sqlite3.table_present: - db: /var/www/data/app.sqlite - schema: CREATE TABLE `users` (`username` TEXT COLLATE NOCASE UNIQUE NOT NULL, `password` BLOB NOT NULL, `salt` BLOB NOT NULL, `last_login` INT) Here is an example of creating a table using yaml/jinja instead of sql: .. code-block:: yaml users: sqlite3.table_present: - db: /var/www/app.sqlite - schema: - email TEXT COLLATE NOCASE UNIQUE NOT NULL - firstname TEXT NOT NULL - lastname TEXT NOT NULL - company TEXT NOT NULL - password BLOB NOT NULL - salt BLOB NOT NULL Here is an example of making sure a table is absent: .. code-block:: yaml badservers: sqlite3.table_absent: - db: /var/www/data/users.sqlite Sometimes you would to have specific data in tables to be used by other services Here is an example of making sure rows with specific data exist: .. code-block:: yaml user_john_doe_xyz: sqlite3.row_present: - db: /var/www/app.sqlite - table: users - where_sql: email='john.doe@companyxyz.com' - data: email: john.doe@companyxyz.com lastname: doe firstname: john company: companyxyz.com password: abcdef012934125 salt: abcdef012934125 - require: - sqlite3: users Here is an example of removing a row from a table: .. code-block:: yaml user_john_doe_abc: sqlite3.row_absent: - db: /var/www/app.sqlite - table: users - where_sql: email="john.doe@companyabc.com" - require: - sqlite3: users Note that there is no explicit state to perform random queries, however, this can be approximated with sqlite3's module functions and module.run: .. code-block:: yaml zone-delete: module.run: - name: sqlite3.modify - db: {{ db }} - sql: "DELETE FROM records WHERE id > {{ count[0] }} AND domain_id = {{ domain_id }}" - watch: - sqlite3: zone-insert-12 � NTFc C s t rdS dS )z6 Only load if the sqlite3 module is available T)FzUnable to import sqlite3)� HAS_SQLITE3� r r �G/opt/saltstack/salt/lib/python3.10/site-packages/salt/states/sqlite3.py� __virtual__g s r c C s� | i ddd�}d}z�z�t j|t jd�}t|_d}|du r(t|d| d | �}n t|d| d | |�}t|�dkrCd|d < d |d < ndt|�dkr�td r`d |d < d| |d < |d |d d< nG|du rp|�d| d | �}n |�d| d | |�}|� � |j dkr�d |d < d|d < |d |d d< nd|d < d|d < nd |d < d|d < W n t y� } zd|d < t | �|d < W Y d} ~ nd} ~ ww W |r�|� � |S |r�|� � w w )ax Makes sure the specified row is absent in db. If multiple rows match where_sql, then the state will fail. name Only used as the unique ID db The database file name table The table name to check where_sql The sql to select the row to check where_args The list parameters to substitute in where_sql N� ��name�changes�result�comment�Z detect_types�SELECT * FROM `�` WHERE � Fr �-More than one row matched the specified queryr �testTzRow will be removed in r r �oldz DELETE FROM `z Row removedzUnable to remove rowz Row is absent)�sqlite3�connect�PARSE_DECLTYPES� _dict_factory� row_factory�_query�len�__opts__�execute�commit�rowcount� Exception�str�close) r �db�table� where_sql� where_argsr �conn�rows�cursor�er r r � row_absentp s` � �� ����� �r) c C sD | i ddd�}d}�z��zet j|t jd�}t|_d} |du r*t|d| d | �} n t|d| d | |�} t| �dkrFd|d < d |d < �n*t| �dkr�|�� D ]�\} } | | d v r�| d | | kr�|r�td rsd|d < d| |d < qPg } g } |�� D ]\} } | � d| d � | � | � q{|dur�| |7 } d| d }|d� | �7 }|d7 }||7 }|� || �}|� � |j dkr�d|d < d|d < | d |d d< ||d d< qPd|d < d|d < qPd|d < d|d < nqP|d du r�d|d < d |d < n|td �r d|d < ||d d< d | |d < nfg } g }g }|�� D ]\} } |� d � |� | � | � d| d � �qd | d }|d� | �7 }|d!7 }|d� |�7 }|d"7 }|� ||�}|� � |j dk�rhd|d < ||d d< d#|d < nd|d < d$|d < W n t�y� } zd|d < t|�|d < W Y d}~nd}~ww W |�r�|�� |S |�r�|�� w w )%a� Checks to make sure the given row exists. If row exists and update is True then row will be updated with data. Otherwise it will leave existing row unmodified and check it against data. If the existing data doesn't match data_check the state will fail. If the row doesn't exist then it will insert data into the table. If more than one row matches, then the state will fail. name Only used as the unique ID db The database file name table The table name to check the data data The dictionary of key/value pairs to check against if row exists, insert into the table if it doesn't where_sql The sql to select the row to check where_args The list parameters to substitute in where_sql update True will replace the existing row with data When False and the row exists and data does not equal the row data then the state will fail Nr r r r r r Fr r r r r TzRow will be update in �`z`=?zUPDATE `z` SET �,z WHERE z Row updatedr r �newzRow update failedz)Existing data doesnot match desired statez Row existszRow will be inserted into �?z INSERT INTO `�` (z ) VALUES (�)z Inserted rowzUnable to insert data)r r r r r r r �itemsr �append�joinr r r r r r )r r! r" �datar# r$ �updater r% r& �key�value�columns�params�sqlr' Z value_stmt�valuesr( r r r � row_present� s� !� �� � ����� �r; c C sB | i ddd�}d}z�zit j|t jd�}t|d| g�}t|�dkrStd r1d|d < d | d |d < nA|�d | � |�� |d d |d d< d|d < d | d |d < n t|�dkrfd|d < d | d |d < n d|d < d| d |d < W n ty� } zd|d < t |�|d < W Y d}~nd}~ww W |r�|� � |S |r�|� � w w )z� Make sure the specified table does not exist name The name of the table db The name of the database file Nr r r z<SELECT sql FROM sqlite_master WHERE type='table' AND name=?r r Tr �'z' will be droppedr z DROP TABLE r r r z ' was droppedz' is already absentFz$Multiple tables with the same name=') r r r r r r r r r r r )r r! r r% �tablesr( r r r � table_absent= sH � ����� �r> c C s` | i ddd�}d}�z z�t j|t jd�}t|d| g�}t|�dkr�d}t|t�r-|�� }nt| |�}||d d kr�|r�t d r]d |d < |d d |d d < ||d d < d| d |d< n�|� d| d � |� |� |� � d |d < |d d |d d < ||d d < d| d |d< nrd|d < d| d |d d |d< n_d |d < d| d |d< nRt|�dkr�d}t|t�r�|}nt| |�}t d r�d |d < ||d d < d| d |d< n&|� |� |� � d |d < ||d d < d| d |d< n d|d < d| |d< W n t �y } zd|d < t|�|d< W Y d}~nd}~ww W |�r%|� � |S |�r/|� � w w )a� Make sure the specified table exists with the specified schema name The name of the table db The name of the database file schema The dictionary containing the schema information force If the name of the table exists and force is set to False, the state will fail. If force is set to True, the existing table will be replaced with the new table Nr r r z;SELECT sql FROM sqlite_master WHERE type='table' AND name=?r r r Tr r r r, r< z' will be replacedr z DROP TABLE `r* z Replaced 'FzExpected schema=z actual schema=z ' exists with matching schemaz' will be createdzCreated table 'z#Multiple tables with the same name=)r r r r r � isinstancer �strip�_get_sql_from_schemar r r r r ) r r! �schema�forcer r% r= r9 r( r r r � table_presentm s| � � ����� �rD c C s2 d }|d u r| � |�}|�� S | � ||�}|�� S �N)r Zfetchall)r% r9 � parametersr' r r r r � s �r c C s d| d d� |� d S )NzCREATE TABLE `r. r+ r/ )r2 )r rB r r r rA � s rA c C s, i }t | j�D ] \}}|| ||d < q|S )Nr )� enumerate� description)r' �row�d�idx�colr r r r � s r rE )NF)F) �__doc__r r � ImportErrorr r) r; r> rD r rA r r r r r �<module> s ^ � J 0 Z
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | Generation time: 0 |
proxy
|
phpinfo
|
Settings