Lines Matching refs:hook
16 # sqlite_commit_hook (tests hook-1..hook-3 inclusive)
17 # sqlite_update_hook (tests hook-4-*)
18 # sqlite_rollback_hook (tests hook-5.*)
20 # $Id: hook.test,v 1.15 2009/04/07 14:14:23 danielk1977 Exp $
24 set ::testprefix hook
26 do_test hook-1.2 {
31 do_test hook-3.1 {
40 do_test hook-3.2 {
43 do_test hook-3.3 {
49 do_test hook-3.4 {
57 do_test hook-3.5 {
68 do_test hook-3.6 {
78 verify_ex_errcode hook-3.6b SQLITE_CONSTRAINT_COMMITHOOK
79 do_test hook-3.7 {
82 do_test hook-3.8 {
86 # Test turnning off the commit hook
88 do_test hook-3.9 {
99 do_test hook-3.10 {
119 # Tests for the update-hook.
121 # 4.1.* - Very simple tests. Test that the update hook is invoked correctly
124 # 4.2.* - Check that the update-hook is invoked for rows modified by trigger
128 # depopulation of indices, to make sure the update-hook is not
137 do_test hook-4.1.1a {
145 # EVIDENCE-OF: R-24531-54682 The update hook is not invoked when
154 do_test hook-4.1.1b {
174 do_test hook-4.1.2 {
196 # EVIDENCE-OF: R-33257-44249 The update hook is not invoked when WITHOUT
199 do_test hook-4.1.2w {
211 # Update hook is not invoked for changes to sqlite_master
213 do_test hook-4.1.3 {
220 do_test hook-4.1.4 {
229 do_test hook-4.2.1 {
242 do_test hook-4.2.2 {
265 # Update-hook + ATTACH
268 do_test hook-4.2.3 {
294 # incorrectly invoke the update-hook.
296 do_test hook-4.3.1 {
314 do_test hook-4.3.2 {
327 do_test hook-4.4 {
339 do_execsql_test hook-4.4.1 {
342 do_test hook-4.4.2 {
350 do_execsql_test hook-4.4.3 {
359 # Test the rollback-hook. The rollback-hook is a bit more complicated than
364 # hook-5.1.* - Test explicit rollbacks.
365 # hook-5.2.* - Test implicit rollbacks caused by constraint failure.
367 # hook-5.3.* - Test implicit rollbacks caused by IO errors.
368 # hook-5.4.* - Test implicit rollbacks caused by malloc() failure.
369 # hook-5.5.* - Test hot-journal rollbacks. Or should the rollback hook
373 do_test hook-5.0 {
374 # Configure the rollback hook to increment global variable
382 do_test hook-5.1.1 {
393 do_test hook-5.2.1 {
403 do_test hook-5.2.2 {
411 # End rollback-hook testing.
415 # Test that if a commit-hook returns non-zero (causing a rollback), the
416 # rollback-hook is invoked.
425 do_test hook-6.1 {
436 do_test hook-6.2 {
442 # The following tests - hook-7.* - test the pre-update hook.
464 # 7.4.1 - Test that the pre-update-hook is invoked only once if a row being
467 # 7.4.2 - Test that the pre-update-hook is invoked if a BEFORE trigger
468 # removes a row being updated. In this case the update hook should
505 db preupdate hook preupdate_hook
763 db preupdate hook preupdate_hook
864 db preupdate hook preupdate_hook
916 # Test that the "update" hook is not fired for operations on the
917 # sqlite_stat1 table performed by ANALYZE, even if a pre-update hook is
932 db preupdate hook preupdate_cb
967 # Test that the pre-update hook is fired for INSERT statements that use
983 db preupdate hook preupdate_cb