python (3.11.7)
e
d Z dS )c # K d}| }dV d}| | }g }| D ]\ }}}|dk r:| d } dg}|d | D z
}G|dk rd V n| d
rh| d rI|sd }d
V d | dd | dd V nd | V | dd }
| d |
} d | D } d |
d d | D }| | }
|
D ] }d |d V d}| | }| D ] \ }}}d | V |rdV |D ]}d | V d V d S ) 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";z DELETE FROM "sqlite_sequence"c 8 g | ]}d |d d|d dS )z&INSERT INTO "sqlite_sequence" VALUES(' z', ) ).0rows @/BuggyBox/python/3.11.7/bootstrap/lib/python3.11/sqlite3/dump.py
<listcomp>z _iterdump.<locals>.<listcomp>% sD O#a&NNSVNNN 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}")c 8 g | ]}t |d S )r )str)r
table_infos r r z _iterdump.<locals>.<listcomp>= s$ LLLzJqM**LLLr
z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";,c 3 h K | ]-}d | dd V .dS )z'||quote("{0}")||'r r N)formatreplace)r cols r <genexpr>z _iterdump.<locals>.<genexpr>@ s@ eeQT-44S[[d5K5KLLeeeeeer
r z
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
zPRAGMA writable_schema=OFF;zCOMMIT;N)cursorexecutefetchall
startswithr r join)
connectionwriteable_schemacuq
schema_resr
table_nametypesqlrowstable_name_identres column_names query_resr
names r _iterdumpr/
s B
A A JO!+!4!4!6!6 ") ")
D# * * *:: @AAJJLLD > ?O
O
>
)
), - - - -
"
"9
-
- &
^^ 2
3
3
&#
4#' 233399? ((d33kk#t,,: :
--$$ % % % &--c488jj3::;KLLMMLLS\\^^LLL D K K HHeeXdeee e e
g
g JJqMM ) )C--A'' ( ( ( ( ) A A J%..00 " "dCmmC !!!! -+,,, " "mmC !!!!
r
N)r/ r r
r <module>r0 s# N N N N Nr
Browse
Usage
Versions