/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 | 58 sURIMatcher.addURI("contacts", "people/#/contact_methods", PEOPLE_CONTACTMETHODS); 59 sURIMatcher.addURI("contacts", "people/#/contact_methods/#", PEOPLE_CONTACTMETHODS_ID); 64 sURIMatcher.addURI("contacts", "contact_methods", CONTACTMETHODS); 65 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 | 547 * Test case for the behavior of the ContactsProvider's contact_methods table 613 "contact_methods._id" + " = " + id, null, null, null); 627 "contact_methods._id" + " = " + id, null, null, null); [all...] |
/frameworks/base/core/java/android/provider/ |
Contacts.java | 423 * <P>Type: INTEGER (foreign key to contact_methods table on the 701 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...] |
/external/robolectric/v1/lib/main/ |
android.jar | |
/prebuilts/sdk/18/ |
android.jar | |
/prebuilts/sdk/21/ |
android.jar | |