cj
d Z y)c
# l K d}| j }d|_ d d}|j | }g }|j D ]} \ }}}|dk( rC|j d j } dg}|| D
cg c] }
d|
d d
|
d d c}
z
}P|d
k( 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().
FNzBEGIN 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"z&INSERT INTO "sqlite_sequence" VALUES(' z', ) sqlite_stat1zANALYZE "sqlite_master";sqlite_zCREATE VIRTUAL TABLETzPRAGMA writable_schema=ON;z^INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)VALUES('table','{0}','{0}',0,'{1}');'z''z{0};"""zPRAGMA table_info("{0}")z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";,c 3 ^ K | ]% }d j |j dd ' yw)z'||quote("{0}")||'r
r N)formatreplace).0cols %/usr/lib64/python3.12/sqlite3/dump.py z _iterdump..A s+ eXdQT-44S[[d5KLXds +-z
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
zPRAGMA writable_schema=OFF;zCOMMIT;) cursor row_factoryexecutefetchall
startswithr r strjoin)
connectionwriteable_schemacuq
schema_resr
table_nametypesqlrowsrowtable_name_identres
table_info column_names query_resnames r _iterdumpr+
sf BBN
A A JO!+!4!4!6
D# * *:: @AJJLD > ?O C :#a&SVHAN
O
>
), -
"
"9
-
^^ 2
3##' 2399? ((d3kk#t,:
--$ % &--c48jj3::;KLM=@\\^L^zJqM*^ L D K K HHeXde e
g JJqM C--A' ( C "7J A A J%..0dCmmC ! 1 +, mmC ! g 0 Ms A7H49H*CH4H/+C H4N)r+ r r. s Or-