| /packages/providers/ContactsProvider/tests/assets/test1/ |
| legacy_contacts.sql | 14 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0); table
15 INSERT INTO contact_methods VALUES(1,2,1,'a@acme.com',NULL,1,NULL,1);
16 INSERT INTO contact_methods VALUES(2,2,1,'b@acme.com',NULL,2,NULL,0);
17 INSERT INTO contact_methods VALUES(3,2,1,'c@acme.com',NULL,3,NULL,0);
18 INSERT INTO contact_methods VALUES(4,2,1,'d@acme.com',NULL,3,NULL,0);
19 INSERT INTO contact_methods VALUES(5,2,3,'a','pre:5',3,NULL,0);
20 INSERT INTO contact_methods VALUES(6,2,3,'b','pre:0',3,NULL,0);
21 INSERT INTO contact_methods VALUES(7,2,3,'c','pre:2',3,NULL,0);
22 INSERT INTO contact_methods VALUES(8,2,3,'d','pre:3',3,NULL,0);
23 INSERT INTO contact_methods VALUES(9,2,3,'e','pre:4',3,NULL,0)
[all...] |
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| legacy_contacts.sql | 11 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0); table
12 INSERT INTO contact_methods VALUES(1,1,1,'gdgjj.fxhnj@ggh.com',NULL,1,NULL,1);
13 INSERT INTO contact_methods VALUES(2,3,1,'weyj@xtdt.com',NULL,1,NULL,1);
14 INSERT INTO contact_methods VALUES(3,5,1,'mail@dom.com',NULL,1,NULL,1);
33 CREATE TABLE people (_id INTEGER PRIMARY KEY AUTOINCREMENT,_sync_account TEXT,_sync_id TEXT,_sync_time TEXT,_sync_version TEXT,_sync_local_id INTEGER,_sync_dirty INTEGER NOT NULL DEFAULT 0,_sync_mark INTEGER,name TEXT COLLATE LOCALIZED,notes TEXT COLLATE LOCALIZED,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,primary_phone INTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_version TEXT,custom_ringtone TEXT,send_to_voicemail INTEGER,phonetic_name TEXT COLLATE LOCALIZED);
71 INSERT INTO sqlite_sequence VALUES('contact_methods',3);
74 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
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) (…)
[all...] |
| /packages/providers/ContactsProvider/tests/assets/testSynced/ |
| legacy_contacts.sql | 12 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0); table
13 INSERT INTO contact_methods VALUES(1,3,1,'weyj@xtdt.com',NULL,1,NULL,1);
14 INSERT INTO contact_methods VALUES(2,4,1,'mail@dom.com',NULL,1,NULL,1);
15 INSERT INTO contact_methods VALUES(3,8,1,'doooooo@sgghhh.com',NULL,1,NULL,1);
16 INSERT INTO contact_methods VALUES(4,9,1,'ahhh@glkbgghh.com',NULL,1,NULL,1);
17 INSERT INTO contact_methods VALUES(5,12,1,'notsynced@gmail.com',NULL,1,NULL,1);
43 CREATE TABLE people (_id INTEGER PRIMARY KEY AUTOINCREMENT,_sync_account TEXT,_sync_id TEXT,_sync_time TEXT,_sync_version TEXT,_sync_local_id INTEGER,_sync_dirty INTEGER NOT NULL DEFAULT 0,_sync_mark INTEGER,name TEXT COLLATE LOCALIZED,notes TEXT COLLATE LOCALIZED,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,primary_phone INTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_version TEXT,custom_ringtone TEXT,send_to_voicemail INTEGER,phonetic_name TEXT COLLATE LOCALIZED);
127 INSERT INTO sqlite_sequence VALUES('contact_methods',5);
130 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
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 groupmembershi (…)
[all...] |
| /frameworks/base/core/java/android/content/ |
| UriMatcher.java | 59 sURIMatcher.addURI("contacts", "people/#/contact_methods", PEOPLE_CONTACTMETHODS);
60 sURIMatcher.addURI("contacts", "people/#/contact_methods/#", PEOPLE_CONTACTMETHODS_ID);
65 sURIMatcher.addURI("contacts", "contact_methods", CONTACTMETHODS);
66 sURIMatcher.addURI("contacts", "contact_methods/#", CONTACTMETHODS_ID);
|
| /packages/providers/ContactsProvider/src/com/android/providers/contacts/ |
| LegacyApiSupport.java | 214 public static final String CONTACT_METHODS = "view_v1_contact_methods";
320 matcher.addURI(authority, "people/#/contact_methods", PEOPLE_CONTACTMETHODS);
323 matcher.addURI(authority, "people/#/contact_methods/#", PEOPLE_CONTACTMETHODS_ID);
343 matcher.addURI(authority, "contact_methods", CONTACTMETHODS);
344 matcher.addURI(authority, "contact_methods/email", CONTACTMETHODS_EMAIL);
345 // matcher.addURI(authority, "contact_methods/email/*", CONTACTMETHODS_EMAIL_FILTER);
346 matcher.addURI(authority, "contact_methods/#", CONTACTMETHODS_ID);
347 // matcher.addURI(authority, "contact_methods/with_presence",
[all...] |
| /cts/tests/tests/provider/src/android/provider/cts/ |
| ContactsTest.java | 504 * Test case for the behavior of the ContactsProvider's contact_methods table
570 "contact_methods._id" + " = " + id, null, null, null);
584 "contact_methods._id" + " = " + id, null, null, null);
[all...] |
| /frameworks/base/core/java/android/provider/ |
| Contacts.java | 424 * <P>Type: INTEGER (foreign key to contact_methods table on the
702 public static final String CONTENT_DIRECTORY = "contact_methods";
[all...] |
| /packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/ |
| LegacyContactsProviderTest.java | 545 assertSelection(ContactMethods.CONTENT_URI, values, "contact_methods",
[all...] |
| /prebuilts/sdk/18/ |
| android.jar | |
