\d  dZdS)c#K|}dVd}||}g}|D]E\}}}|dkr:|d}dg}|d|Dz }G|dkrdVn-|d rhd |V|d d } |d | } d| D} d| dd| D}||} | D]} d | dV Gd}||}|D]\}}}d |V|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(). 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"c8g|]}d|dd|ddS)z&INSERT INTO "sqlite_sequence" VALUES('z',)).0rows ..\python\lib\sqlite3\dump.py z_iterdump..$sD   O#a&NNSVNNN    sqlite_stat1zANALYZE "sqlite_master";sqlite_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') zCOMMIT;N)cursorexecutefetchall startswithrrjoin) connectioncuq schema_resr table_nametypesqlrowstable_name_identres column_names query_resr names r _iterdumpr- sq     B  AAJO!+!4!4!6!6 ) ) D# * * *::@AAJJLLD>?O       O  > ) ), - - - -  " "9 - - & --$$ % % %&--c488jj3::;KLLMMLLS\\^^LLL D K K  HHeeXdeee e e g gJJqMM  ) )C--A'' ( ( ( ( ) A AJ%..00""dCmmC  !!!!""mmC  !!!! r N)r-rr r r.s#HHHHHr