Ĥ˙ f c @ 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( u/
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().
u BEGIN TRANSACTION;uŞ
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" == 'table'
ORDER BY "name"
u sqlite_sequenceu DELETE FROM "sqlite_sequence";u sqlite_stat1u ANALYZE "sqlite_master";u sqlite_u {0};u "u ""u PRAGMA table_info("{0}")c S s g | ] } t | d q S( i ( u str( u .0u
table_info( ( u1 /opt/alt/python33/lib64/python3.3/sqlite3/dump.pyu
3 s u _iterdump..u2 SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";u ,c s s* | ] } d j | j d d Vq d S( u '||quote("{0}")||'u "u ""N( u formatu replace( u .0u col( ( u1 /opt/alt/python33/lib64/python3.3/sqlite3/dump.pyu 6 s u _iterdump..i u£
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
u COMMIT;N( u cursoru executeu fetchallu
startswithu formatu replaceu join(
u
connectionu cuu qu
schema_resu
table_nameu typeu sqlu table_name_identu resu column_namesu query_resu rowu name( ( u1 /opt/alt/python33/lib64/python3.3/sqlite3/dump.pyu _iterdump
s4
u _iterdumpN( u _iterdump( ( ( u1 /opt/alt/python33/lib64/python3.3/sqlite3/dump.pyu
s