File manager - Edit - /opt/saltstack/salt/lib/python3.10/site-packages/salt/modules/__pycache__/sqlite3.cpython-310.pyc
Back
o ;j* � @ s� d Z zddlZdZW n ey dZY nw dd� Zddd�Zd d � Zd d � Zdd d�Zddd�Z ddd�Z ddd�Z ddd�Z dS )z Support for SQLite3 � NTFc C s t sdS dS )N)FzYThe sqlite3 execution module failed to load: the sqlite3 python library is not available.T)� HAS_SQLITE3� r r �H/opt/saltstack/salt/lib/python3.10/site-packages/salt/modules/sqlite3.py� __virtual__ s r c C s& | d u rdS t j| d d�}|�� }|S )NF)Zisolation_level)�sqlite3�connectZcursor)�dbZcon�curr r r �_connect s r c C � t jS )zr Return version of pysqlite CLI Example: .. code-block:: bash salt '*' sqlite3.version )r �versionr r r r r ! � r c C r )zw Return version of sqlite CLI Example: .. code-block:: bash salt '*' sqlite3.sqlite_version )r �sqlite_versionr r r r r . r r c C s t | �}|sdS |�|� dS )a Issue an SQL query to sqlite3 (with no return data), usually used to modify the database in some way (insert, delete, create, etc) CLI Example: .. code-block:: bash salt '*' sqlite3.modify /root/test.db 'CREATE TABLE test(id INT, testdata TEXT);' FT)r �execute)r �sqlr r r r �modify; s r c C s& t | �}|sdS |�|� |�� }|S )z� Retrieve data from an sqlite3 db (returns all rows, be careful!) CLI Example: .. code-block:: bash salt '*' sqlite3.fetch /root/test.db 'SELECT * FROM test;' F�r r Zfetchall)r r r �rowsr r r �fetchO � r c C �& t | �}|sdS |�d� |�� }|S )z� Show all tables in the database CLI Example: .. code-block:: bash salt '*' sqlite3.tables /root/test.db Fz@SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;r �r r r r r r �tablesc r r c C r )z� Show all indices in the database CLI Example: .. code-block:: bash salt '*' sqlite3.indices /root/test.db Fz@SELECT name FROM sqlite_master WHERE type='index' ORDER BY name;r r r r r �indicesw r r c C s t | �S )z� Show all indices in the database, for people with poor spelling skills CLI Example: .. code-block:: bash salt '*' sqlite3.indexes /root/test.db )r )r r r r �indexes� s r )N)NN) �__doc__r r � ImportErrorr r r r r r r r r r r r r �<module> s �
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | Generation time: 0 |
proxy
|
phpinfo
|
Settings