B
ÊÍyŽö\Rã @ s d d„ Z dS )c
c s | ¡ }dV d}| |¡}xÂ| ¡ D ]¶\}}}|dkr@dV n*|dkrPdV n| d¡r^q&n d |¡V | d d
¡}| d |¡¡}d d
„ | ¡ D ƒ} d |d dd„ | D ƒ¡¡}| |¡}
x |
D ]} d | d ¡V qÄW q&W d}| |¡}x"| ¡ D ]\} }}d |¡V qøW 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"
Zsqlite_sequencez DELETE FROM "sqlite_sequence";Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};ú"z""zPRAGMA table_info("{0}")c S s g | ]}t |d ƒ‘qS )é )Ústr)Ú.0Z
table_info© r ú1/opt/alt/python37/lib64/python3.7/sqlite3/dump.pyú
3 s z _iterdump..z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";ú,c s s | ]}d | dd¡¡V qdS )z'||quote("{0}")||'r z""N)ÚformatÚreplace)r Úcolr r r ú 6 s z _iterdump..é z£
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
zCOMMIT;N)ZcursorZexecuteZfetchallÚ
startswithr r
Újoin)
Z
connectionZcuÚqZ
schema_resZ
table_nameÚtypeZsqlZtable_name_identZresZ column_namesZ query_resÚrowÚnamer r r Ú _iterdump
s4
r N)r r r r r Ú
ó