�
c��j�
� �
� d � Z y)c
# �l K � d}| j � }d|_ d�� d}|j |� }g }|j � D �]} \ }}}|dk( rC|j d� j � } dg}|| D �
cg c] }
d|
d � d
|
d � d ��� c}
z
}�P|d
k( rd�� ns|j d� r�l|j d� r=|sd}d�� dj |j
dd� |j
dd� � �� ndj |� �� |j
dd� } |j dj | � � } | j � D �
cg c] }
t |
d � �� }}
dj | dj d � |D � � � }|j |� }|D ] }
dj |
d � �� � ��� d }|j |� }|j � D ] \ }}}dj |� �� � |rd �� |D ] }
dj |
� �� � d �� yc c}
w c c}
w �w) 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().
FNzBEGIN 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"z&INSERT INTO "sqlite_sequence" VALUES('� z',� �)� sqlite_stat1zANALYZE "sqlite_master";�sqlite_zCREATE VIRTUAL TABLETzPRAGMA writable_schema=ON;z^INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)VALUES('table','{0}','{0}',0,'{1}');�'z''z{0};�"�""zPRAGMA table_info("{0}")z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";�,c 3 �^ K � | ]% }d j |j dd� � �� �' y�w)z'||quote("{0}")||'r
r N)�format�replace)�.0�cols �%/usr/lib64/python3.12/sqlite3/dump.py� z _iterdump..A s+ � �� �e�Xd�QT�-�4�4�S�[�[��d�5K�L�Xd�s �+-z�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
zPRAGMA writable_schema=OFF;zCOMMIT;) �cursor� row_factory�execute�fetchall�
startswithr r �str�join)�
connection�writeable_schema�cu�q�
schema_resr �
table_name�type�sql�rows�row�table_name_ident�res�
table_info� column_names� query_res�names r � _iterdumpr+
sf � �� � �� � � � �B��B�N�
� � �A� ���A� �J��O�!+�!4�!4�!6� �
�D�#� �*� *��:�:� @�A�J�J�L�D� >� ?�O� � � � �C� :�#�a�&���S��V�H�A�N� � �
�O�
�
�>�
)�,� -�
�
"�
"�9�
-� �
�^�^� 2�
3�#�#'� �2�3�9�9?�� �(�(��d�3��k�k�#�t�,�:�
� �-�-��$� %� &�-�-�c�4�8���j�j�3�:�:�;K�L�M��=@�\�\�^�L�^�z��J�q�M�*�^� �L� D� K� K� � �H�H�e�Xd�e� e�
g�� �J�J�q�M� � �C��-�-��A��'� (� �C "7�J �A� ���A� �J�%�.�.�0���d�C��m�m�C� �!� 1� �+�,� ���m�m�C� �!� � ���g ��0 M�s �A7H4�9H*�CH4�H/�+C H4N)r+ � � r �r. s ��Or-