OpenGrok
Home
Sort by relevance
Sort by last modified time
Full Search
Definition
Symbol
File Path
History
|
|
Help
Searched
refs:TRIGGER
(Results
1 - 11
of
11
) sorted by null
/external/chromium_org/third_party/sqlite/src/test/
collate6.test
21
#
trigger
support.
23
ifcapable {!
trigger
} {
51
CREATE
TRIGGER
collate6trig BEFORE INSERT ON collate6tab
71
DROP
TRIGGER
collate6trig;
80
CREATE
TRIGGER
collate6trig BEFORE INSERT ON collate6tab BEGIN
99
DROP
TRIGGER
collate6trig;
117
CREATE
TRIGGER
abc_t1 AFTER INSERT ON abc BEGIN
132
CREATE
TRIGGER
abc_t2 AFTER UPDATE ON abc BEGIN
/packages/providers/ContactsProvider/tests/assets/testUnsynced/
legacy_contacts.sql
90
CREATE
TRIGGER
contact_cleanup DELETE ON people BEGIN DELETE FROM peopleLookup WHERE source = old._id;DELETE FROM peopleLookupWithPhoneticName WHERE source = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person = old._id;DELETE FROM groupmembership WHERE person = old._id;DELETE FROM extensions WHERE person = old._id;END;
91
CREATE
TRIGGER
contact_methods_INSERT_typeAndLabel AFTER INSERT ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
92
CREATE
TRIGGER
contact_methods_UPDATE_typeAndLabel AFTER UPDATE ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
93
CREATE
TRIGGER
contact_methods_delete DELETE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
94
CREATE
TRIGGER
contact_methods_insert INSERT ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person;END;
95
CREATE
TRIGGER
contact_methods_update UPDATE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
96
CREATE
TRIGGER
extensions_delete DELETE ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
97
CREATE
TRIGGER
extensions_insert INSERT ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person; END;
98
CREATE
TRIGGER
extensions_update AFTER UPDATE ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person; END;
99
CREATE
TRIGGER
groupmembership_delete DELETE ON groupmembership BEGIN UPDATE people SET _sync_dirty=1 WHERE peopl (…)
[
all
...]
/external/chromium_org/third_party/sqlite/src/tool/
mkkeywordhash.c
116
# define
TRIGGER
0
118
# define
TRIGGER
0x00002000
146
{ "ABORT", "TK_ABORT", CONFLICT|
TRIGGER
},
149
{ "AFTER", "TK_AFTER",
TRIGGER
},
158
{ "BEFORE", "TK_BEFORE",
TRIGGER
},
186
{ "EACH", "TK_EACH",
TRIGGER
},
193
{ "FAIL", "TK_FAIL", CONFLICT|
TRIGGER
},
194
{ "FOR", "TK_FOR",
TRIGGER
},
202
{ "IGNORE", "TK_IGNORE", CONFLICT|
TRIGGER
},
210
{ "INSTEAD", "TK_INSTEAD",
TRIGGER
},
[
all
...]
/packages/providers/ContactsProvider/tests/assets/test1/
legacy_contacts.sql
122
CREATE
TRIGGER
contact_cleanup DELETE ON people BEGIN DELETE FROM peopleLookup WHERE source = old._id;DELETE FROM peopleLookupWithPhoneticName WHERE source = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person = old._id;DELETE FROM groupmembership WHERE person = old._id;DELETE FROM extensions WHERE person = old._id;END;
123
CREATE
TRIGGER
contact_methods_INSERT_typeAndLabel AFTER INSERT ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
124
CREATE
TRIGGER
contact_methods_UPDATE_typeAndLabel AFTER UPDATE ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
125
CREATE
TRIGGER
contact_methods_delete DELETE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
126
CREATE
TRIGGER
contact_methods_insert INSERT ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person;END;
127
CREATE
TRIGGER
contact_methods_update UPDATE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
128
CREATE
TRIGGER
extensions_delete DELETE ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
129
CREATE
TRIGGER
extensions_insert INSERT ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person; END;
130
CREATE
TRIGGER
extensions_update AFTER UPDATE ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person; END;
131
CREATE
TRIGGER
groupmembership_delete DELETE ON groupmembership BEGIN UPDATE people SET _sync_dirty=1 WHERE peopl (…)
[
all
...]
/packages/providers/ContactsProvider/tests/assets/testSynced/
legacy_contacts.sql
146
CREATE
TRIGGER
contact_cleanup DELETE ON people BEGIN DELETE FROM peopleLookup WHERE source = old._id;DELETE FROM peopleLookupWithPhoneticName WHERE source = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person = old._id;DELETE FROM groupmembership WHERE person = old._id;DELETE FROM extensions WHERE person = old._id;END;
147
CREATE
TRIGGER
contact_methods_INSERT_typeAndLabel AFTER INSERT ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
148
CREATE
TRIGGER
contact_methods_UPDATE_typeAndLabel AFTER UPDATE ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
149
CREATE
TRIGGER
contact_methods_delete DELETE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
150
CREATE
TRIGGER
contact_methods_insert INSERT ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person;END;
151
CREATE
TRIGGER
contact_methods_update UPDATE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
152
CREATE
TRIGGER
extensions_delete DELETE ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
153
CREATE
TRIGGER
extensions_insert INSERT ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person; END;
154
CREATE
TRIGGER
extensions_update AFTER UPDATE ON extensions BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person; END;
155
CREATE
TRIGGER
groupmembership_delete DELETE ON groupmembership BEGIN UPDATE people SET _sync_dirty=1 WHERE peopl (…)
[
all
...]
/external/zlib/src/examples/
gzlog.c
263
/* number of stored Kbytes to
trigger
compression (must be >= 32 to allow
266
#define
TRIGGER
1024
[
all
...]
/external/qemu/android/
hw-events.h
427
BTN_CODE(
TRIGGER
, 0x120) \
/external/chromium_org/third_party/sqlite/src/src/
parse.y
85
**
TRIGGER
. "a" is the event type, one of TK_UPDATE, TK_INSERT,
201
SAVEPOINT TEMP
TRIGGER
VACUUM VIEW VIRTUAL
[
all
...]
/external/robolectric/lib/main/
h2-1.2.147.jar
/build/tools/droiddoc/templates-sac/assets/js/
android_3p-bundle.js
[
all
...]
/build/tools/droiddoc/templates-sdk/assets/js/
android_3p-bundle.js
[
all
...]
Completed in 440 milliseconds