/snap/core22/2437/usr/lib/python3.10/sqlite3/__pycache__
Edit: /snap/core22/2437/usr/lib/python3.10/sqlite3/__pycache__/dump.cpython-310.pyc (2235B)
o
p̦i @ 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 #/usr/lib/python3.10/sqlite3/dump.py
$ s z _iterdump.. sqlite_stat1zANALYZE "sqlite_master";sqlite_z{0};"""zPRAGMA table_info("{0}")c S s g | ]}t |d qS )r )str)r
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)cursorexecutefetchall
startswithr r join)
connectioncuq
schema_resr
table_nametypesqlrowstable_name_identres column_names query_resr namer r r _iterdump
sJ
r' N)r' r r r r s