Spade
Mini Shell
| Directory:~$ /lib64/python3.6/sqlite3/__pycache__/ |
| [Home] [System Details] [Kill Me] |
3
\ �@sdd�ZdS)c
cs|j�}dVd}|j|�}x�|j�D]�\}}}|dkr@dVn*|dkrPdVn|jd�r^q&ndj|�V|jd d
�}|jdj|��}dd
�|j�D�} dj|djdd�| D���}|j|�}
x|
D]}dj|d�Vq�Wq&Wd}|j|�}x"|j�D]\}}}dj|�Vq�WdVdS)NzBEGIN
TRANSACTION;z�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" == 'table'
ORDER BY "name"
Zsqlite_sequencezDELETE FROM
"sqlite_sequence";Zsqlite_stat1zANALYZE
"sqlite_master";Zsqlite_z{0};�"z""zPRAGMA
table_info("{0}")cSsg|]}t|d��qS)�)�str)�.0Z
table_info�r�$/usr/lib64/python3.6/sqlite3/dump.py�
<listcomp>3sz_iterdump.<locals>.<listcomp>z2SELECT
'INSERT INTO "{0}" VALUES({1})' FROM
"{0}";�,css
|]}dj|jdd��VqdS)z'||quote("{0}")||'rz""N)�format�replace)r�colrrr� <genexpr>6sz_iterdump.<locals>.<genexpr>�z�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger',
'view')
zCOMMIT;)ZcursorZexecuteZfetchall�
startswithr r
�join)
Z
connectionZcu�qZ
schema_resZ
table_name�typeZsqlZtable_name_ident�resZcolumn_namesZ query_res�row�namerrr� _iterdump
s4
rN)rrrrr�<module>
s