mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 07:29:41 +00:00
45 lines
967 B
Plaintext
45 lines
967 B
Plaintext
|
|
CREATE TABLE t1(a, b);
|
|
CREATE TABLE t2(c, d);
|
|
CREATE TABLE t3(e, f);
|
|
|
|
|
|
# ATTACH 'test.db2' AS aux;
|
|
# CREATE TABLE aux.t4(x);
|
|
# INSERT INTO aux.t4 VALUES(5);
|
|
#
|
|
# CREATE TRIGGER tr1 AFTER INSERT ON t1 WHEN new.a IN (SELECT x FROM aux.t4)
|
|
# BEGIN
|
|
# SELECT 1;
|
|
# END;
|
|
#
|
|
INSERT INTO t1 VALUES(1,1);
|
|
INSERT INTO t1 VALUES(5,5);
|
|
|
|
PRAGMA writable_schema = 1;
|
|
INSERT INTO sqlite_master VALUES('trigger', 'tr1', 't1', 0,
|
|
'CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
|
|
INSERT INTO t2 VALUES(?1, ?2);
|
|
END'
|
|
);
|
|
|
|
INSERT INTO sqlite_master VALUES('trigger', 'tr2', 't3', 0,
|
|
'CREATE TRIGGER tr2 AFTER INSERT ON t3 WHEN ?1 IS NULL BEGIN
|
|
UPDATE t2 SET c=d WHERE c IS ?2;
|
|
END'
|
|
);
|
|
|
|
|
|
INSERT INTO t1 VALUES(1, 2);
|
|
SELECT * FROM t2;
|
|
|
|
SELECT * FROM t1
|
|
|
|
DELETE FROM t2;
|
|
INSERT INTO t2 VALUES('x', 'y');
|
|
INSERT INTO t2 VALUES(NULL, 'z');
|
|
INSERT INTO t3 VALUES(1, 2);
|
|
SELECT * FROM t3;
|
|
SELECT * FROM t2;
|
|
|