← Back
Editing: dump.cpython-312.pyc
� �֦i� � � � 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� <genexpr>z _iterdump.<locals>.<genexpr>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 �<module>r. s ��Or-
Save File
Cancel