B Ò­–SÂ÷ã@sDddlZddlZGdd„dejƒZdd„Zdd„Zedkr@eƒdS) éNc@s,eZdZdd„Zdd„Zdd„Zdd„Zd S) Ú DumpTestscCst d¡|_|j ¡|_dS)Nz:memory:)ÚsqliteZconnectÚcxÚcursorÚcu)Úself©rú6/opt/alt/python37/lib64/python3.7/sqlite3/test/dump.pyÚsetUps zDumpTests.setUpcCs|j ¡dS)N)rÚclose)rrrr ÚtearDown szDumpTests.tearDownc stddddddddd d g ‰‡fd d „ˆDƒˆj ¡}d d „|Dƒ‰dgˆdg‰‡‡‡fdd „ttˆƒƒDƒdS)Nz#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);csg|]}ˆj |¡‘qSr)rÚexecute)Ú.0Ús)rrr ú ,sz,DumpTests.CheckTableDump..cSsg|]}|‘qSrr)rrrrr r.szBEGIN TRANSACTION;zCOMMIT;cs g|]}ˆ ˆ|ˆ|¡‘qSr)Ú assertEqual)rÚi)Ú actual_sqlsÚ expected_sqlsrrr r1s)rÚiterdumpÚrangeÚlen)rrr)rrrr ÚCheckTableDumps" zDumpTests.CheckTableDumpcCs`Gdd„dƒ}||j_d}d}d||dg}|j |¡|j |¡t|j ¡ƒ}| ||¡dS)Nc@seZdZdd„Zdd„ZdS)z5DumpTests.CheckUnorderableRow..UnorderableRowcSs ||_dS)N)Úrow)rrrrrr Ú__init__7sz>DumpTests.CheckUnorderableRow..UnorderableRow.__init__cSs |j|S)N)r)rÚindexrrr Ú __getitem__9szADumpTests.CheckUnorderableRow..UnorderableRow.__getitem__N)Ú__name__Ú __module__Ú __qualname__rrrrrr ÚUnorderableRow6sr zCREATE TABLE "alpha" ("one");zCREATE TABLE "beta" ("two");zBEGIN TRANSACTION;zCOMMIT;)rZ row_factoryrr Úlistrr)rr Z CREATE_ALPHAZ CREATE_BETAZexpectedZgotrrr ÚCheckUnorderableRow4s  zDumpTests.CheckUnorderableRowN)rrrr r rr"rrrr rs&rcCst t td¡¡S)NZCheck)ÚunittestZ TestSuiteZ makeSuiterrrrr ÚsuiteIsr$cCst ¡}| tƒ¡dS)N)r#ZTextTestRunnerÚrunr$)Zrunnerrrr ÚtestLsr&Ú__main__)r#Zsqlite3rZTestCaserr$r&rrrrr Ús C