î
e f ã @ s d d „ Z d S)c
c sz | j ƒ } d Vd } | j | ƒ } x| j ƒ D]÷ \ } } } | d k rV d Vn7 | d k rj d Vn# | j d ƒ r q3 n d j | ƒ V| j d d
ƒ } | j d j | ƒ ƒ } d d
„ | j ƒ Dƒ } d j | d j d d „ | Dƒ ƒ ƒ } | j | ƒ }
x |
D] } d j | d ƒ VqWq3 Wd } | j | ƒ } x+ | j ƒ D] \ } } } d j | ƒ VqPWd Vd S)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"
Zsqlite_sequencez DELETE FROM "sqlite_sequence";Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};ú"z""zPRAGMA table_info("{0}")c S s g | ] } t | d ƒ ‘ q S)é )Ústr)Ú.0Z
table_info© r ú1/opt/alt/python34/lib64/python3.4/sqlite3/dump.pyú
3 s z _iterdump..z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";ú,c s s* | ] } d j | j d d ƒ ƒ Vq d S)z'||quote("{0}")||'r z""N)ÚformatÚreplace)r Úcolr r r ú 6 s z _iterdump..é z£
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
zCOMMIT;N)ZcursorZexecuteZfetchallÚ
startswithr r
Újoin)
Z
connectionZcuÚqZ
schema_resZ
table_nameÚtypeZsqlZtable_name_identÚresZ column_namesZ query_resÚrowÚnamer r r Ú _iterdump
s4
r N)r r r r r Ú
s