python (3.12.0)
̑e
d Z y)c
# ^ K d}| j }d d}|j | }g }|j D ]} \ }}}|dk( rC|j d j } dg}|| D
cg c] }
d|
d d |
d
d c}
z
}P|dk( rd
ns|j d rl|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().
FzBEGIN 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";zDELETE FROM "sqlite_sequence"z&INSERT INTO "sqlite_sequence" VALUES('