o =?h?ã@sHddlZddlZGdd„dejƒZdd„Zdd„Zedkr"eƒdSdS) éNc@s<eZdZdd„Zdd„Zdd„Zdd„Zd d „Zdd„Zd S)Ú DumpTestscCst d¡|_|j ¡|_dS)Nú:memory:)ÚsqliteÚconnectÚcxÚcursorÚcu©Úself©rú8/opt/alt/python310/lib64/python3.10/sqlite3/test/dump.pyÚsetUpszDumpTests.setUpcCs|j ¡dS©N)rÚcloser rrrÚtearDownszDumpTests.tearDowncsdgd¢‰‡fdd„ˆDƒˆj ¡}dd„|Dƒ‰dgˆdg‰‡‡‡fdd„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);csg|]}ˆj |¡‘qSr)rÚexecute©Ú.0Úsr rrÚ -sz-DumpTests.test_table_dump..cSóg|]}|‘qSrrrrrrr/óúBEGIN TRANSACTION;úCOMMIT;cs g|]}ˆ ˆ|ˆ|¡‘qSr)ÚassertEqual)rÚi©Zactual_sqlsZ expected_sqlsr rrr2sÿ)rÚiterdumpÚrangeÚlen)r rrrrÚtest_table_dumps ÿ ÿzDumpTests.test_table_dumpcCslgd¢}|j d |¡¡|d dd¡|d<| dd¡| gd¢¡d 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);ÚéZNULLÚ1rr)zDELETE FROM "sqlite_sequence";z-INSERT INTO "sqlite_sequence" VALUES('t1',1);rcSrrr)rZstmtrrrrFrz5DumpTests.test_dump_autoincrement..) rÚ executescriptÚjoinÚreplaceÚinsertÚextendrrr)r ÚexpectedZactualrrrÚtest_dump_autoincrement5sz!DumpTests.test_dump_autoincrementc Cs|j d¡|j d¡|j d¡|j ddd„tdƒDƒ¡|j dd d„td ƒDƒ¡|j ¡t d¡}d |j ¡¡}| |¡| ¡}d }|D]0\}}|j||d| d|f¡}| ¡}| |dd|¡Wdƒn1sxwYqMdS)NzBEGIN TRANSACTIONz6CREATE TABLE t1 (id integer primary key autoincrement)z6CREATE TABLE t2 (id integer primary key autoincrement)zINSERT INTO t1 VALUES(?)csó|]}dVqdS©rNr©rÚ_rrrÚ Mó€zBDumpTests.test_dump_autoincrement_create_new_db..é zINSERT INTO t2 VALUES(?)csr+r,rr-rrrr/Nr0érr!))Út1r1)Út2r2)ÚtableÚseqz[ SELECT "seq" FROM "sqlite_sequence" WHERE "name" == ? r)rrZexecutemanyrrZcommitrrr%rr$rZsubTestZfetchallr) r Zcx2ZqueryZcu2Zdatasetr5r6ÚresZrowsrrrÚ%test_dump_autoincrement_create_new_dbIs* þû€ÿz/DumpTests.test_dump_autoincrement_create_new_dbcCs`Gdd„dƒ}||j_d}d}d||dg}|j |¡|j |¡t|j ¡ƒ}| ||¡dS)Nc@seZdZdd„Zdd„ZdS)z6DumpTests.test_unorderable_row..UnorderableRowcSs ||_dSr©Úrow)r rr:rrrÚ__init__eó z?DumpTests.test_unorderable_row..UnorderableRow.__init__cSs |j|Srr9)r ÚindexrrrÚ__getitem__gr<zBDumpTests.test_unorderable_row..UnorderableRow.__getitem__N)Ú__name__Ú __module__Ú__qualname__r;r>rrrrÚUnorderableRowdsrBzCREATE TABLE "alpha" ("one");zCREATE TABLE "beta" ("two");rr)rZrow_factoryrrÚlistrr)r rBZCREATE_ALPHAZCREATE_BETAr)ZgotrrrÚtest_unorderable_rowbsüzDumpTests.test_unorderable_rowN) r?r@rAr rr r*r8rDrrrrrs&rcCstg}t dd„|Dƒ¡S)NcSsg|] }t ¡ |¡‘qSr)ÚunittestZ TestLoaderZloadTestsFromTestCase)rÚtrrrr|szsuite..)rrEZ TestSuite)ZtestsrrrÚsuitews ÿÿrGcCst ¡}| tƒ¡dSr)rEZTextTestRunnerÚrunrG)ZrunnerrrrÚtestsrIÚ__main__)rEZsqlite3rZTestCaserrGrIr?rrrrÚsp ÿ