/snap/core22/2411/usr/lib/python3.10/sqlite3/__pycache__
Edit: /snap/core22/2411/usr/lib/python3.10/sqlite3/__pycache__/dump.cpython-310.pyc (2235B)
o
`€wiÜ ã @ 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Ú
$ s ÿÿz _iterdump..Ú 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 Ú = s € z _iterdump..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 Ú s