o h @s ddZdS)ccsL |}dVd}||}g}|D]h\}}}|dkr3|d}dg}|dd|D7}q|dkr;d Vn |d rAqd |V|d d } |d| } dd| D} d| ddd| D}||} | D] } d | dVqsqd}||}|D] \}}}d |Vq|D]} d | VqdVdS)NzBEGIN 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;)ZcursorZexecuteZfetchall startswithrrjoin)Z connectionZcuqZ schema_resrZ table_nametypeZsqlZrowsZtable_name_identresZ column_namesZ query_resrnamerrr _iterdump sL      rN)rrrrrs