← Back
Editing: dump.cpython-33.pyc
� �� 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 <listcomp>3 s u _iterdump.<locals>.<listcomp>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 <genexpr>6 s u _iterdump.<locals>.<genexpr>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 <module> s
Save File
Cancel