$99 GRAYBYTE WORDPRESS FILE MANAGER $90

3

� f	�@sdd
�ZdS)c

cs
|j�}
d
V
d}|
j
|�
}x�|j�D]�\}}}|dkr@dV
n*|dkrPdV
n|jd�
r^q&ndj|�
V
|jd	d
�}|
j
dj|�
�
}dd
�|j�D�
}	dj|djdd�|	D�
�
�}|
j
|�
}
x|
D]}dj|d�
V
q�Wq&Wd}|
j
|�
}x"|j�D]\}}}dj|�
V
q�WdV
dS)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_sequencezDELETE FROM "sqlite_sequence";Zsqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};�
"z""zPRAGMA table_info("{0}")c
Ssg|]}
t|
d�
�qS)
�
)
�str)�.0Z
table_info�r�1/opt/alt/python36/lib64/python3.6/sqlite3/dump.py�
<listcomp>3sz_iterdump.<locals>.<listcomp>z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";�
,c
ss |]}
dj|
j
d
d��
V
qdS)z'||quote("{0}")||'r
z""N)�format�replace)r�colrrr�	<genexpr>6sz_iterdump.<locals>.<genexpr>�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�namerrr�	_iterdump
s4	
	









	













rN)
rrrrr�<module>
s