Š¹¼] ã@sdd„ZdS)c csz|jƒ}dVd}|j|ƒ}x|jƒD]÷\}}}|dkrVdVn7|dkrjdVn#|jdƒrq3ndj|ƒV|jd d ƒ}|jd j|ƒƒ}d d „|jƒDƒ} dj|djdd„| Dƒƒƒ}|j|ƒ} x | D]} dj| dƒVqWq3Wd}|j|ƒ}x+|jƒD]\} }}dj|ƒVqPWdVdS)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";Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};ú"z""zPRAGMA table_info("{0}")cSs g|]}t|dƒ‘qS)é)Ústr)Ú.0Z table_info©rú)/opt/alt/python35/lib64/python3.5/dump.pyú 3s z_iterdump..z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";ú,css*|] }dj|jddƒƒVqdS)z'||quote("{0}")||'rz""N)ÚformatÚreplace)rÚcolrrrú 6sz_iterdump..éz£ SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" IN ('index', 'trigger', 'view') zCOMMIT;)ZcursorZexecuteZfetchallÚ startswithr r Újoin) Ú connectionZcuÚqZ schema_resZ table_nameÚtypeZsqlZtable_name_identÚresZ column_namesZ query_resÚrowÚnamerrrÚ _iterdump s4      rN)rrrrrÚ s