�
*�_i� � � � S r S rSS.S jrg)c �D � SR U R SS5 5 $ )Nz"{0}"�"z""��format�replace)�names �#/usr/lib/python3.13/sqlite3/dump.py� _quote_namer
s � � �>�>�$�,�,�s�D�1� 2�2� c �D � SR U R SS5 5 $ )Nz'{0}'�'z''r )�values r � _quote_valuer s � � �>�>�%�-�-��T�2� 3�3r
N)�filterc # �
# � SnU R 5 nSUl UR S5 R 5 nU( a Sv � Sv � U( a SnU/nOSn/ nSU S 3nUR Xv5 n/ n UR 5 GH u p�n U
S
:X aN UR S 5 n
S /n U U
R 5 V
Vs/ s H u p�S
[ U
5 SU S3PM snn
-
n M[ U
S:X a Sv � OuU
R S5 ( a M~ U R S5 ( a4 U( d SnSv � SR
[ U
5 [ U 5 5 v � OSR
U 5 v � [ U
5 nUR SU S35 nUR 5 Vs/ s H n[ US 5 PM nnSR
USR S U 5 5 5 nUR U5 nU H nSR
US 5 v � M GM� S U S 3nUR Xv5 nUR 5 H u np�SR
U 5 v � M U( a S v � U H nSR
U5 v � M S!v � gs snn
f s snf 7f)"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().
FNzPRAGMA foreign_key_checkzPRAGMA foreign_keys=OFF;zBEGIN TRANSACTION;zAND "name" LIKE ?� z�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" == 'table'
z%
ORDER BY "name"
�sqlite_sequencez SELECT * FROM "sqlite_sequence";z DELETE FROM "sqlite_sequence"z%INSERT INTO "sqlite_sequence" VALUES(�,�)� sqlite_stat1zANALYZE "sqlite_master";�sqlite_zCREATE VIRTUAL TABLETzPRAGMA writable_schema=ON;zXINSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)VALUES('table',{0},{0},0,{1});z{0};zPRAGMA table_info(� z0SELECT 'INSERT INTO {0} VALUES('{1}')' FROM {0};z','c 3 �V # � U H nS R [ U5 5 v � M! g7f)z||quote({0})||N)r r )�.0�cols r � <genexpr>� _iterdump.<locals>.<genexpr>U s' � � � �EQ�c� �'�'� �C�(8�9�9�\�s �')� z�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
z
zPRAGMA writable_schema=OFF;zCOMMIT;)
�cursor� row_factory�execute�fetchallr �
startswithr r �str�join)�
connectionr �writeable_schema�cu�
violations�filter_name_clause�params�q�
schema_resr �
table_name�type�sql�rows� seq_value�table_name_ident�res�
table_info� column_names� query_res�rowr s r � _iterdumpr8 s� � � � �� � � � �B��B�N���� 6�7�@�@�B�J��(�)�
� �
� 0����� ����
�
� � ! � �A� ���A�&�J��O�!+�!4�!4�!6� �
�#� �*� *��:�:� @�A�D� >� ?�O� �-1�]�]�_� �-<�)�J� 8� �Z�8P�7Q�QR�S\�R]�]^�_�-<� �
�O�
�
�>�
)�,� -�
�
"�
"�9�
-�
-� �
�^�^� 2�
3�
3�#�#'� �2�3�3�39�6�"�:�.�"�3�'�4�
� �-�-��$� %� '�z�2���j�j�-�.>�-?�q�A�B��=@�\�\�^�L�^�z��J�q�M�*�^� �L� >� E� E� � �J�J� �EQ��
�
�� �J�J�q�M� � �C��-�-��A��'� (� �I "7�P
�
� � ! � �A� ���A�&�J�%�.�.�0���d��m�m�C� �!� 1� �+�,� ���m�m�C� �!� � ���o ��0 M�s �B7J�9 I8
�B:J�I>�)CJ)r r r8 � r
r �<module>r: s ��3�4� %)� _r