£Á°èZ¨Ä…–K§‚«“ô4“ÒÙ´dîfUÙÃÅ WKbyÊ¦•êŽ…È®FÒ¿ÊÎóCozá¬S@6{Í:›œêZÌ:Š•_%:¢¾¾~;‘Ã~èŠ©ÊÇí`ÔÑ©úë™µ'5I¿fš×WO%ø9¾«¾DK|€ùÍD”Ýs]nHÕ¶ê×Ó¼ãžªéUWŸÈË%DÒÕ¬ï‘]/Åcx  ‰ï2ß]ä6G[]S£ÔÏ¯rs{úëóµmÒï#UQxo·õÞCe]"±/aÙ&Eã4ú9Jé_ÞåëdãöKë)AÞ                  ¯¹ægƒÛowÐø^d™ý½ßB7áyMä9ÜÖUã
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
<html>
3
 f	                 @   s   d d Z dS )c             c   s  | j  }dV  d}|j|}x|j D ]\}}}|dkr@dV  n*|dkrPdV  n|jdr^q&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 V  qW q&W d}|j|}x"|j D ]\}}}dj|V  qW dV  d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().
    zBEGIN TRANSACTION;z
        SELECT "name", "type", "sql"
        FROM "sqlite_master"
            WHERE "sql" NOT NULL AND
            "type" == 'table'
            ORDER BY "name"
        Zsqlite_sequencezDELETE FROM "sqlite_sequence";Zsqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};"z""zPRAGMA table_info("{0}")c             S   s   g | ]}t |d  qS )   )str).0Z
table_info r   1/opt/alt/python36/lib64/python3.6/sqlite3/dump.py
<listcomp>3   s    z_iterdump.<locals>.<listcomp>z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";,c             s   s    | ]}d j |jddV  qdS )z'||quote("{0}")||'r   z""N)formatreplace)r   colr   r   r   	<genexpr>6   s    z_iterdump.<locals>.<genexpr>    z
        SELECT "name", "type", "sql"
        FROM "sqlite_master"
            WHERE "sql" NOT NULL AND
            "type" IN ('index', 'trigger', 'view')
        zCOMMIT;N)ZcursorZexecuteZfetchall
startswithr	   r
   join)Z
connectionZcuqZ
schema_resZ
table_nametypeZsqlZtable_name_identresZcolumn_namesZ	query_resrownamer   r   r   	_iterdump
   s4    		

	


r   N)r   r   r   r   r   <module>
   s    