RPM Package Manager, CVS Repository http://rpm5.org/cvs/ ____________________________________________________________________________
Server: rpm5.org Name: Jeff Johnson Root: /v/rpm/cvs Email: [email protected] Module: rpm Date: 10-Apr-2010 20:16:46 Branch: HEAD Handle: 2010041018164500 Modified files: rpm/tests/ref sqldb-basic.out sqldb-basic.sql Removed files: rpm/tests/ref sqldb-meta.sql Log: - sanity. Summary: Revision Changes Path 1.4 +55 -0 rpm/tests/ref/sqldb-basic.out 1.4 +22 -3 rpm/tests/ref/sqldb-basic.sql 1.3 +0 -19 rpm/tests/ref/sqldb-meta.sql ____________________________________________________________________________ patch -p0 <<'@@ .' Index: rpm/tests/ref/sqldb-basic.out ============================================================================ $ cvs diff -u -r1.3 -r1.4 sqldb-basic.out --- rpm/tests/ref/sqldb-basic.out 8 Apr 2010 22:50:44 -0000 1.3 +++ rpm/tests/ref/sqldb-basic.out 10 Apr 2010 18:16:45 -0000 1.4 @@ -1,16 +1,71 @@ +.echo on +.explain off +.headers on +.mode list +.nullvalue "" +.output stdout +.prompt 'foo> ' '---> ' +.separator "|" +.timeout 1000 +.timer off +.show + echo: on + explain: off + headers: on + mode: list +nullvalue: "" + output: stdout +separator: "|" + width: .read ref/rpmdb.sql SELECT * from Packages; +i|h 1|bing-1.2-3.noarch 2|bang-4.5-6.noarch 3|boom-7.8.9.noarch SELECT * from Nvra; +k|v bing-1.2-3.noarch|1 bang-4.5-6.noarch|2 boom-7.8.9.noarch|3 SELECT * from Packages; +i|h 1|bing-1.2-3.noarch 3|boom-7.8.9.noarch SELECT * from Nvra; +k|v bing-1.2-3.noarch|1 boom-7.8.9.noarch|3 +.backup main tmp/main.bak +.restore main tmp/main.bak +.dump main +PRAGMA foreign_keys=OFF; +BEGIN TRANSACTION; +COMMIT; +.databases +seq name file +--- --------------- ---------------------------------------------------------- +0 main /X/src/wdj/tests/tmp/sqldb +1 temp +.indices Packages +sqlite_autoindex_Packages_1 +.schema +CREATE TABLE Nvra ( + k TEXT PRIMARY KEY NOT NULL, + v INTEGER REFERENCES Packages(i) ON UPDATE RESTRICT ON DELETE RESTRICT +); +CREATE TABLE Packages ( + i INTEGER UNIQUE PRIMARY KEY NOT NULL, + h BLOB NOT NULL +); +CREATE TRIGGER delete_Packages BEFORE DELETE ON Packages + BEGIN + DELETE FROM Nvra WHERE v = old.rowid; + END; +CREATE TRIGGER insert_Packages AFTER INSERT ON Packages + BEGIN + INSERT INTO Nvra (k,v) VALUES ( new.h, new.rowid ); + END; +.tables +Nvra Packages .exit @@ . patch -p0 <<'@@ .' Index: rpm/tests/ref/sqldb-basic.sql ============================================================================ $ cvs diff -u -r1.3 -r1.4 sqldb-basic.sql --- rpm/tests/ref/sqldb-basic.sql 8 Apr 2010 22:50:44 -0000 1.3 +++ rpm/tests/ref/sqldb-basic.sql 10 Apr 2010 18:16:45 -0000 1.4 @@ -1,9 +1,21 @@ --- Instantiate the rpmdb.sql schema. +-- Configure the SQL parser parameters to known defaults. +.echo on +.explain off +.headers on +-- .log stderr +.mode list +.nullvalue "" +.output stdout +.prompt 'foo> ' '---> ' +.separator "|" +.timeout 1000 +.timer off +.show +-- Instantiate the rpmdb.sql schema. .read ref/rpmdb.sql -- Basic rpmdbAdd/rpmdbRemove operations using SQL triggers. - BEGIN TRANSACTION; INSERT into Packages (h) VALUES ('bing-1.2-3.noarch'); INSERT into Packages (h) VALUES ('bang-4.5-6.noarch'); @@ -21,6 +33,13 @@ SELECT * from Nvra; -- Basic .foo SQL metadata tests. --- .read ref/sqldb-meta.sql +.backup main tmp/main.bak +.restore main tmp/main.bak +.dump main + +.databases +.indices Packages +.schema +.tables .exit @@ . rm -f rpm/tests/ref/sqldb-meta.sql <<'@@ .' Index: rpm/tests/ref/sqldb-meta.sql ============================================================================ [NO CHANGE SUMMARY BECAUSE FILE AS A WHOLE IS JUST REMOVED] @@ . ______________________________________________________________________ RPM Package Manager http://rpm5.org CVS Sources Repository [email protected]
