o
0i @ 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| ddd | D }||} | D ]
}
d |
d V qrqd}||}| D ] \}}}d |V q|D ]}
d |
V qdV 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 dqS )z&INSERT INTO "sqlite_sequence" VALUES(' z', ) ).0rowr r 3/opt/alt/python310/lib64/python3.10/sqlite3/dump.py
$ s z _iterdump..Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};"""zPRAGMA table_info("{0}")c S s g | ]}t |d qS )r )str)r Z
table_infor r r r : s z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";,c s s" | ] }d |ddV qdS )z'||quote("{0}")||'r
r N)formatreplace)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)ZcursorZexecuteZfetchall
startswithr r join)Z
connectionZcuqZ
schema_resr Z
table_nametypeZsqlZrowsZtable_name_identresZ column_namesZ query_resr namer r r _iterdump
sJ
r N)r r r r r s