o
0i @ s d d Z dS )c c sL | }dV d}||}g }| D ]h\}}}|dkr3|d }dg}|dd |D 7 }q|dkr;d V n |d
rAqd |V |d d
} |d| }
dd |
D } d| ddd | D }||} | D ]
}
d |
d V qsqd}||}| D ] \}}}d |V q|D ]}
d |
V qdV d S )NzBEGIN 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 3/opt/alt/python310/lib64/python3.10/sqlite3/dump.py
$ s z _iterdump..Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};"""zPRAGMA table_info("{0}")c S s g | ]}t |d qS )r )str)r Z
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;)ZcursorZexecuteZfetchall
startswithr r join)Z
connectionZcuqZ
schema_resr Z
table_nametypeZsqlZrowsZtable_name_identresZ column_namesZ query_resr namer r r _iterdump
sL
r N)r r r r r s