| Server IP : 212.252.79.165 / Your IP : 216.73.216.45 [ Web Server : Apache System : Linux 212-252-79-165.cprapid.com 5.15.0-153-generic #163-Ubuntu SMP Thu Aug 7 16:37:18 UTC 2025 x86_64 User : cehaburo ( 1001) PHP Version : 8.1.33 Disable Function : exec,passthru,shell_exec,system Domains : 48 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /lib/python3.10/sqlite3/__pycache__/ |
Upload File : |
o
p̦i� � @ s d d� Z dS )c c sJ � | � � }dV d}|�|�}g }|�� D ]h\}}}|dkr2|�d��� }dg}|dd� |D �7 }q|dkr:d V n |�d
�r@qd �|�V |�d d
�} |�d�| ��}
dd� |
�� D �} d�| d�dd� | D ���}|�|�} | D ]
}
d �|
d �V qrqd}|�|�}|�� D ] \}}}d �|�V q�|D ]}
d �|
�V q�dV dS )a/
Returns an iterator to the dump of the database in an SQL text format.
Used to produce an SQL dump of the database. Useful to save an in-memory
database for later restoration. This function should not be called
directly but instead called from the Connection method, iterdump().
zBEGIN TRANSACTION;z�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" == 'table'
ORDER BY "name"
�sqlite_sequencez SELECT * FROM "sqlite_sequence";z DELETE FROM "sqlite_sequence"c S s& g | ]}d |d � d|d � d��qS )z&INSERT INTO "sqlite_sequence" VALUES('� z',� �)� )�.0�rowr r �#/usr/lib/python3.10/sqlite3/dump.py�
<listcomp>$ s ��z _iterdump.<locals>.<listcomp>� sqlite_stat1zANALYZE "sqlite_master";�sqlite_z{0};�"�""zPRAGMA table_info("{0}")c S s g | ]}t |d ��qS )r )�str)r �
table_infor r r r : s z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";�,c s s" � | ] }d � |�dd��V qdS )z'||quote("{0}")||'r r
N)�format�replace)r �colr r r � <genexpr>= s � z _iterdump.<locals>.<genexpr>r z�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
zCOMMIT;N)�cursor�execute�fetchall�
startswithr r �join)�
connection�cu�q�
schema_resr �
table_name�type�sql�rows�table_name_ident�res� column_names� query_resr �namer r r � _iterdump
sJ �
�
�
�
r' N)r' r r r r �<module> s