Viewing: sqlite3.cpython-36.pyc
3 �N�b* � @ s� d Z yddlZdZW n ek r, dZY nX dd� Zddd�Zd d � Zd d � Zdd d�Zddd�Z ddd�Z ddd�Z d dd�Z dS ) z Support for SQLite3 � NTFc C s t sdS dS )NF�YThe sqlite3 execution module failed to load: the sqlite3 python library is not available.T)Fr )� HAS_SQLITE3� r r � /usr/lib/python3.6/sqlite3.py� __virtual__ s r c C s& | d kr dS t j| d d�}|j� }|S )NF)Zisolation_level)�sqlite3ZconnectZcursor)�dbZcon�curr r r �_connect s r c C s t jS )zr Return version of pysqlite CLI Example: .. code-block:: bash salt '*' sqlite3.version )r �versionr r r r r ! s r c C s t jS )zw Return version of sqlite CLI Example: .. code-block:: bash salt '*' sqlite3.sqlite_version )r �sqlite_versionr r r r r . s r c C s t | �}|sdS |j|� 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 |j|� |j� }|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 �fetchall)r r r �rowsr r r �fetchO s r c C s& t | �}|sdS |jd� |j� }|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 r r �tablesc s r c C s& t | �}|sdS |jd� |j� }|S )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 r r r r �indicesw s 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)NN)N)N)N) �__doc__r r � ImportErrorr r r r r r r r r r r r r �<module> s
Return