o […dÜ ã@s dd„ZdS)ccsJ| ¡}dVd}| |¡}g}| ¡D]h\}}}|dkr2| d¡ ¡}dg}|dd„|Dƒ7}q|dkr:d Vn | d ¡r@qd  |¡V| d d ¡} | d | ¡¡} dd„|  ¡Dƒ} d | d dd„| Dƒ¡¡}| |¡} | D] } d  | d¡Vqrqd}| |¡}| ¡D] \}}}d  |¡Vq‰|D]} d  | ¡Vq—dVdS)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|d›d|d›d‘qS)z&INSERT INTO "sqlite_sequence" VALUES('éz',éú)©)Ú.0Úrowrrú#/usr/lib/python3.10/sqlite3/dump.pyÚ $sÿÿz_iterdump..Ú sqlite_stat1zANALYZE "sqlite_master";Úsqlite_z{0};ú"ú""zPRAGMA table_info("{0}")cSsg|]}t|dƒ‘qS)r)Ústr)rÚ table_inforrrr :sz2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";ú,css"|] }d | dd¡¡VqdS)z'||quote("{0}")||'r r N)ÚformatÚreplace)rÚcolrrrÚ =s€ z_iterdump..rz£ SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" IN ('index', 'trigger', 'view') zCOMMIT;N)ÚcursorÚexecuteÚfetchallÚ startswithrrÚjoin)Ú connectionÚcuÚqÚ schema_resrÚ table_nameÚtypeÚsqlÚrowsÚtable_name_identÚresÚ column_namesÚ query_resrÚnamerrrÚ _iterdump sJ€  þ  þ ÿ  r'N)r'rrrrÚs