§ <«گe¹مَv—ddlZddlZddlmZGd„dej¦«Zedkrej¦«dSdS)éNé)عmemory_databasecَ2—eZdZd„Zd„Zd„Zd„Zd„Zd„ZdS)ع DumpTestscَt—tjd¦«|_|j ¦«|_dS)Nz:memory:)عsqliteعconnectعcxعcursorعcu©عselfs ْ2/usr/lib/python3.11/test/test_sqlite3/test_dump.pyعsetUpzDumpTests.setUp s*€ف”. ر,ش,ˆŒط”'—.’.ر"ش"ˆŒˆˆَcَ8—|j ¦«dS©N)r عcloser s rعtearDownzDumpTests.tearDown s€طŒڈ ٹ ‰Œˆˆˆrcَâ‡‡‡—gd¢ٹˆfd„‰D¦«‰j ¦«}d„|D¦«ٹdg‰zdgzٹˆˆˆfd„tt‰¦«¦«D¦«dS)N) z#CREATE TABLE "index"("index" blob);z"INSERT INTO "index" VALUES(X'01');z3CREATE TABLE "quoted""table"("quoted""field" text);z4INSERT INTO "quoted""table" VALUES('quoted''value');z‚CREATE TABLE t1(id integer primary key, s1 text, t1_i1 integer not null, i2 integer, unique (s1), constraint t1_idx1 unique (i2));z'INSERT INTO "t1" VALUES(1,'foo',10,20);z(INSERT INTO "t1" VALUES(2,'foo2',30,30);ztCREATE TABLE t2(id integer, t2_i1 integer, t2_i2 integer, primary key (id),foreign key(t2_i1) references t1(t1_i1));zrCREATE TRIGGER trigger_1 update of t1_i1 on t1 begin update t2 set t2_i1 = new.t1_i1 where t2_i1 = old.t1_i1; end;z;CREATE VIEW v1 as select * from t1 left join t2 using (id);cَD•—g|]}‰j |¦«‘ŒS©)rعexecute)ع.0عsrs €rْ z-DumpTests.test_table_dump...s'ّ€ذ3ذ3ذ3 ˆŒڈٹکر ش ذ3ذ3ذ3rcَ—g|]}|‘ŒSrr)rrs rrz-DumpTests.test_table_dump..0s€گnگnگnکQگqگnگnگnrْBEGIN TRANSACTION;ْCOMMIT;cَT•—g|]$}‰ ‰|‰|¦«‘Œ%Sr)عassertEqual)rعiعactual_sqlsع expected_sqlsrs €€€rrz-DumpTests.test_table_dump..3sBّ€ً 0ً 0ً 0طً × ز ک-¨ش*¨K¸¬Nر ;ش ;ً 0ً 0ً 0r)r عiterdumpعrangeعlen)rr"r#r$s` @@rعtest_table_dumpzDumpTests.test_table_dumps؛ّّّ€ًًًˆ ً: 4ذ3ذ3ذ3 ]ذ3ر3ش3ذ3طŒG×زرشˆط$گn !گn‘n”nˆط-ذ.°ر>ط ˆKٌˆ ً 0ً 0ً 0ً 0ً 0ً 0ف‌3ک}ر-ش-ر.ش.ً 0ٌ 0ô 0ً 0ً 0ً 0rcَr—gd¢}|j d |¦«¦«|d dd¦«|d<| dd¦«| gd¢¦«d „|j ¦«D¦«}| ||¦«dS) N)z9CREATE TABLE "t1" (id integer primary key autoincrement);zINSERT INTO "t1" VALUES(NULL);z9CREATE TABLE "t2" (id integer primary key autoincrement);عrعNULLع1rr)zDELETE FROM "sqlite_sequence";z-INSERT INTO "sqlite_sequence" VALUES('t1',1);rcَ—g|]}|‘ŒSrr)rعstmts rrz5DumpTests.test_dump_autoincrement..Gs€ذ6ذ6ذ6ک4گ$ذ6ذ6ذ6r) rع executescriptعjoinعreplaceعinsertعextendr r%r!)rعexpectedعactuals rعtest_dump_autoincrementz!DumpTests.test_dump_autoincrement6sد€ً ً ً ˆً Œ×زکbںgڑg hر/ش/ر0ش0ذ0ًکq”k×)ز)¨&°#ر6ش6ˆگ‰طڈٹکذ/ر0ش0ذ0طڈٹً ً ً ٌ ô ً ً7ذ6 4¤7×#3ز#3ر#5ش#5ذ6ر6ش6ˆط×زک 6ر*ش*ذ*ذ*ذ*rcَ¢—|j d¦«|j d¦«|j d¦«|j dd„td¦«D¦«¦«|j dd„td ¦«D¦«¦«|j ¦«t ¦«5}d |j ¦«¦«}| |¦«| ¦«}d}|D]پ\}}| ||¬¦«5| d |f¦«}| ¦«}| |dd|¦«ddd¦«n#1swxYwYŒ‚ ddd¦«dS#1swxYwYdS)NzBEGIN TRANSACTIONz6CREATE TABLE t1 (id integer primary key autoincrement)z6CREATE TABLE t2 (id integer primary key autoincrement)zINSERT INTO t1 VALUES(?)c3َK—|]}dV—ŒdS©rNr©rع_s rْ zBDumpTests.test_dump_autoincrement_create_new_db..Nَ"èè€ذ8Sذ8SہQ¸ذ8Sذ8Sذ8Sذ8Sذ8Sذ8Sré zINSERT INTO t2 VALUES(?)c3َK—|]}dV—ŒdSr9rr:s rr<zBDumpTests.test_dump_autoincrement_create_new_db..Or=rér*))عt1r>)عt2r@)عtableعseqzc SELECT "seq" FROM "sqlite_sequence" WHERE "name" == ? r)rrعexecutemanyr&r عcommitrr0r%r/rعsubTestعfetchallr!) rعcx2عqueryعcu2عdatasetrCrDعresعrowss rع%test_dump_autoincrement_create_new_dbz/DumpTests.test_dump_autoincrement_create_new_dbJs5€طŒڈٹذ+ر,ش,ذ,طŒڈٹذPرQشQذQطŒڈٹذPرQشQذQطŒ×زذ6ذ8Sذ8Sح%ذPQة(ج(ذ8Sر8Sش8SرTشTذTطŒ×زذ6ذ8Sذ8Sح%ذPQة(ج(ذ8Sر8Sش8SرTشTذTطŒڈٹرشذه ر ش ً 6 #ط—G’GکDœG×,ز,ر.ش.ر/ش/ˆEط×زکeر$ش$ذ$ط—*’*‘,”,ˆCًˆGً&ً 6ً 6‘ گگsط—\’\¨°3گ\ر7ش7ً6ً6طں+ڑ+ً'àکٌ#ô#گCًں<ڑ<™>œ>گDط×$ز$ T¨!¤W¨Q¤Z°ر5ش5ذ5ً6ً6ً6ٌ6ô6ً6ً6ً6ً6ً6ً6ًّّّ6ً6ً6ً6ًّ 6ً 6ً 6ً 6ٌ 6ô 6ً 6ً 6ً 6ً 6ً 6ً 6ً 6ًّّّ 6ً 6ً 6ً 6ً 6ً 6s8أA6GإAF*ئGئ*F.ئ.Gئ1F.ئ2GاGاGcَ,—Gd„d¦«}||j_d}d}d||dg}|j |¦«|j |¦«t |j ¦«¦«}| ||¦«dS)Ncَ—eZdZd„Zd„ZdS)ْ6DumpTests.test_unorderable_row..UnorderableRowcَ—||_dSr©عrow)rrrUs rع__init__z?DumpTests.test_unorderable_row..UnorderableRow.__init__fs €طگ”گگrcَ—|j|SrrT)rعindexs rع__getitem__zBDumpTests.test_unorderable_row..UnorderableRow.__getitem__hs€ط”x ”ذ&rN)ع__name__ع __module__ع__qualname__rVrYrrrعUnorderableRowrRes2€€€€€ً ً ً ً 'ً 'ً 'ً 'ً 'rr]zCREATE TABLE "alpha" ("one");zCREATE TABLE "beta" ("two");rr)r عrow_factoryrrعlistr%r!)rr]عCREATE_ALPHAعCREATE_BETAr4عgots rعtest_unorderable_rowzDumpTests.test_unorderable_rowcs´€ً 'ً 'ً 'ً 'ً 'ٌ 'ô 'ً 'ً -ˆŒشط:ˆط8ˆà طططً ˆً Œڈٹکر$ش$ذ$طŒڈٹکر%ش%ذ%فگ4”7×#ز#ر%ش%ر&ش&ˆط×زک 3ر'ش'ذ'ذ'ذ'rN) rZr[r\rrr(r6rOrcrrrrrso€€€€€ً#ً#ً#ًًًً$0ً$0ً$0ًL+ً+ً+ً(6ً6ً6ً2(ً(ً(ً(ً(rrع__main__) عunittestعsqlite3rع test_dbapirعTestCaserrZعmainrrrْrjsٹًً€€€طذذذط'ذ'ذ'ذ'ذ'ذ'ًn(ًn(ًn(ًn(ًn(گش!ٌn(ôn(ًn(ًbˆzزذط€H„MپO„O€O€O€Oًذr