Plan 9 from Bell Labs’s /usr/web/sources/contrib/jas/root/sys/lib/python2.7/sqlite3/dump.pyo

Copyright © 2021 Plan 9 Foundation.
Distributed under the MIT License.
Download the Plan 9 distribution.


��Qc@s
d�ZdS(ccsx|j�}dVd}|j|�}x|j�D]�}}}|dkrVdVn2|dkrjdVn|jd�rq3n	d|V|jd	d
�}|jdj|��}g|j�D]}	t|	d�^q�}
d
j|djd�|
D���}|j|�}x|D]}d|dVqWq3Wd}|j|�}x&|j�D]\}
}}d|VqSWdVdS(s/
    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().
    sBEGIN TRANSACTION;s�
        SELECT "name", "type", "sql"
        FROM "sqlite_master"
            WHERE "sql" NOT NULL AND
            "type" == 'table'
            ORDER BY "name"
        tsqlite_sequencesDELETE FROM "sqlite_sequence";tsqlite_stat1sANALYZE "sqlite_master";tsqlite_s%s;t"s""sPRAGMA table_info("{0}")is2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";t,css*|] }dj|jdd��VqdS(s'||quote("{0}")||'Rs""N(tformattreplace(t.0tcol((s"/sys/lib/python2.7/sqlite3/dump.pys	<genexpr>6sis�
        SELECT "name", "type", "sql"
        FROM "sqlite_master"
            WHERE "sql" NOT NULL AND
            "type" IN ('index', 'trigger', 'view')
        sCOMMIT;N(tcursortexecutetfetchallt
startswithRRtstrtjoin(t
connectiontcutqt
schema_rest
table_namettypetsqlttable_name_identtrest
table_infotcolumn_namest	query_restrowtname((s"/sys/lib/python2.7/sqlite3/dump.pyt	_iterdump
s4				)

N(R(((s"/sys/lib/python2.7/sqlite3/dump.pyt<module>
s

Bell Labs OSI certified Powered by Plan 9

(Return to Plan 9 Home Page)

Copyright © 2021 Plan 9 Foundation. All Rights Reserved.
Comments to [email protected].