Warning: Cannot modify header information - headers already sent by (output started at /var/www/jonas-eriksen.dk/pic/private/index.php:1) in /var/www/jonas-eriksen.dk/pic/private/index.php on line 215
!A?h
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 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().
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"c 8 g | ]}d |d d|d dS )z&INSERT INTO "sqlite_sequence" VALUES(' z', ) ).0rows %/usr/lib64/python3.11/sqlite3/dump.py
z_iterdump..% 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..= 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 z_iterdump..@ 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_identrescolumn_names query_resr
names r _iterdumpr/
s B
A AJO!+!4!4!6!6 ") ")
D#***::@AAJJLLD>?O
O
>
)
),----
"
"9
-
- &
^^2
3
3
&#
4#' 233399? ((d33kk#t,,: :
--$$%%% &--c488jj3::;KLLMMLLS\\^^LLLDKKHHeeXdeeeee
g
g JJqMM ) )C--A''(((( ) A AJ%..00 " "dCmmC !!!! -+,,, " "mmC !!!!
r
N)r/ r r
r r0 s# N N N N Nr