Dashboard
PHP:
8.2.30
OS:
Linux
User:
dh_nv8b2m
/
/
usr
/
lib
/
python3.10
/
sqlite3
/
__pycache__
📤 Upload
📝 New File
📁 New Folder
Close
Editing: dump.cpython-310.pyc
o �*�g� � @ 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
Save
Cancel