f  dZdS)c#Kd}|}dVd}||}g}|D]\}}}|dkr:|d} dg}|d| Dz }G|dkrd Vn|d rh|d rI|sd }d Vd|dd|ddVnd|V|dd} |d| } d| D} d| dd| D}||} | D]}d|dV d}||}|D]\}}}d|V|rdV|D]}d|VdVdS)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(). FzBEGIN 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"c8g|]}d|dd|ddS)z&INSERT INTO "sqlite_sequence" VALUES('z',)).0rows 3/opt/alt/python311/lib64/python3.11/sqlite3/dump.py z_iterdump..%sD   O#a&NNSVNNN    sqlite_stat1zANALYZE "sqlite_master";sqlite_zCREATE VIRTUAL TABLETzPRAGMA writable_schema=ON;z^INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)VALUES('table','{0}','{0}',0,'{1}');'z''z{0};"""zPRAGMA table_info("{0}")c8g|]}t|dS)r)str)r table_infos r r z_iterdump..=s$LLLzJqM**LLLr z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";,c3hK|]-}d|ddV.dS)z'||quote("{0}")||'rrN)formatreplace)r cols r z_iterdump..@s@eeQT-44S[[d5K5KLLeeeeeer rz SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" IN ('index', 'trigger', 'view') zPRAGMA writable_schema=OFF;zCOMMIT;N)cursorexecutefetchall startswithrrjoin) connectionwriteable_schemacuq schema_resr table_nametypesqlrowstable_name_identres column_names query_resr names r _iterdumpr/ s     B  AAJO!+!4!4!6!6")") D# * * *::@AAJJLLD>?O       O  > ) ), - - - -  " "9 - - &  ^^2 3 3 &# 4#' 233399? ((d33kk#t,,::     --$$ % % %&--c488jj3::;KLLMMLLS\\^^LLL D K K  HHeeXdeee e e g gJJqMM  ) )C--A'' ( ( ( ( ) A AJ%..00""dCmmC  !!!!-+,,,""mmC  !!!! r N)r/rr r r0s#NNNNNr