$95 GRAYBYTE WORDPRESS FILE MANAGER $50

B

� f	�@sdd
�ZdS)c

cs
|��}
d
V
d}|
�
|�
}x�|��D]�\}}}|dkr@dV
n*|dkrPdV
n|�d�
r^q&nd�|�
V
|�d	d
�}|
�
d�|�
�
}dd
�|��D�
}	d�|d�dd�|	D�
�
�}|
�
|�
}
x|
D]}d�|d�
V
q�Wq&Wd}|
�
|�
}x"|��D]\}}}d�|�
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/python37/lib64/python3.7/sqlite3/dump.py�
<listcomp>3sz_iterdump.<locals>.<listcomp>z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";�
,c
ss |]}
d�|
�
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_identZresZcolumn_namesZ	query_res�row�namerrr�	_iterdump
s4	
	









	













rN)
rrrrr�<module>
�