o ?Og @s ddZdS)ccsJ|}dVd}||}g}|D]h\}}}|dkr2|d}dg}|dd|D7}q|dkr:d Vn |d r@qd |V|d d } |d| } dd| D} d| ddd| D}||} | D] } d | dVqrqd}||}|D] \}}}d |Vq|D]} d | VqdVdS)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" sqlite_sequencez SELECT * FROM "sqlite_sequence";zDELETE FROM "sqlite_sequence"cSs&g|]}d|dd|ddqS)z&INSERT INTO "sqlite_sequence" VALUES('z',)).0rowrr3/opt/alt/python310/lib64/python3.10/sqlite3/dump.py $sz_iterdump..Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};"""zPRAGMA table_info("{0}")cSsg|]}t|dqS)r)str)rZ table_inforrrr :sz2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";,css"|] }d|ddVqdS)z'||quote("{0}")||'r r N)formatreplace)rcolrrr =s z_iterdump..rz SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" IN ('index', 'trigger', 'view') zCOMMIT;N)ZcursorZexecuteZfetchall startswithrrjoin)Z connectionZcuqZ schema_resrZ table_nametypeZsqlZrowsZtable_name_identresZ column_namesZ query_resrnamerrr _iterdump sJ       rN)rrrrrs