Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Test a couple of the examples in foreignkeys.html. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
a2fb7902c01f8b095b25d338fc2f23cb |
| User & Date: | dan 2009-10-08 19:02:51 |
Context
|
2009-10-09
| ||
| 18:16 | Add test cases to e_fkey.test. (check-in: e391dfe7 user: dan tags: trunk) | |
|
2009-10-08
| ||
| 19:02 | Test a couple of the examples in foreignkeys.html. (check-in: a2fb7902 user: dan tags: trunk) | |
| 17:42 | Add test cases to test file "e_fkey.test". (check-in: 23e0f61a user: dan tags: trunk) | |
Changes
Changes to test/e_fkey.test.
14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
#
set testdir [file dirname $argv0]
source $testdir/tester.tcl
ifcapable {!foreignkey} { finish_test ; return }
execsql "PRAGMA foreign_keys = ON"
#-------------------------------------------------------------------------
# /* EV: R-36018-21755 */
# /* EV: R-25384-39337 */
#
# Test that parent keys are not checked when tables are created.
#
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 |
#
set testdir [file dirname $argv0]
source $testdir/tester.tcl
ifcapable {!foreignkey} { finish_test ; return }
execsql "PRAGMA foreign_keys = ON"
#-------------------------------------------------------------------------
# /* EV: R-51437-39891 */
#
# Test an example from the "ON DELETE and ON UPDATE Actions" section
# of foreignkeys.html.
#
drop_all_tables
do_test e_fkey-13.1 {
execsql {
CREATE TABLE parent(x PRIMARY KEY);
CREATE TABLE child(y REFERENCES parent ON UPDATE SET NULL);
INSERT INTO parent VALUES('key');
INSERT INTO child VALUES('key');
}
} {}
do_test e_fkey-13.2 {
execsql {
UPDATE parent SET x = 'key';
SELECT IFNULL(y, 'null') FROM child;
}
} {key}
do_test e_fkey-13.3 {
execsql {
UPDATE parent SET x = 'key2';
SELECT IFNULL(y, 'null') FROM child;
}
} {null}
#-------------------------------------------------------------------------
# /* EV: R-07065-59588 */
#
# Test an example from the "ON DELETE and ON UPDATE Actions" section
# of foreignkeys.html.
#
drop_all_tables
do_test e_fkey-14.1 {
execsql {
CREATE TABLE artist(
artistid INTEGER PRIMARY KEY,
artistname TEXT
);
CREATE TABLE track(
trackid INTEGER,
trackname TEXT,
trackartist INTEGER DEFAULT 0 REFERENCES artist(artistid) ON DELETE SET DEFAULT
);
INSERT INTO artist VALUES(3, 'Sammy Davis Jr.');
INSERT INTO track VALUES(14, 'Mr. Bojangles', 3);
}
} {}
do_test e_fkey-14.2 {
catchsql { DELETE FROM artist WHERE artistname = 'Sammy Davis Jr.' }
} {1 {foreign key constraint failed}}
do_test e_fkey-14.3 {
execsql {
INSERT INTO artist VALUES(0, 'Unknown Artist');
DELETE FROM artist WHERE artistname = 'Sammy Davis Jr.';
}
} {}
do_test e_fkey-14.4 {
execsql { SELECT * FROM artist }
} {0 {Unknown Artist}}
do_test e_fkey-14.5 {
execsql { SELECT * FROM track }
} {14 {Mr. Bojangles} 0}
#-------------------------------------------------------------------------
# /* EV: R-25213-27898 */
#
# Test an example from the "ON DELETE and ON UPDATE Actions" section
# of foreignkeys.html.
#
drop_all_tables
do_test e_fkey-15.1 {
execsql {
CREATE TABLE artist(
artistid INTEGER PRIMARY KEY,
artistname TEXT
);
CREATE TABLE track(
trackid INTEGER,
trackname TEXT,
trackartist INTEGER REFERENCES artist(artistid) ON UPDATE CASCADE
);
INSERT INTO artist VALUES(1, 'Dean Martin');
INSERT INTO artist VALUES(2, 'Frank Sinatra');
INSERT INTO track VALUES(11, 'That''s Amore', 1);
INSERT INTO track VALUES(12, 'Christmas Blues', 1);
INSERT INTO track VALUES(13, 'My Way', 2);
}
} {}
do_test e_fkey-15.2 {
execsql {
UPDATE artist SET artistid = 100 WHERE artistname = 'Dean Martin';
}
} {}
do_test e_fkey-15.3 {
execsql { SELECT * FROM artist }
} {2 {Frank Sinatra} 100 {Dean Martin}}
do_test e_fkey-15.4 {
execsql { SELECT * FROM track }
} {11 {That's Amore} 100 12 {Christmas Blues} 100 13 {My Way} 2}
#-------------------------------------------------------------------------
# /* EV: R-36018-21755 */
# /* EV: R-25384-39337 */
#
# Test that parent keys are not checked when tables are created.
#
|