Cross Reference: /packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/LegacyContactsProviderTest.java

Lines Matching refs:values
68         ContentValues values = new ContentValues();
69         putContactValues(values);
71         Uri uri = mResolver.insert(People.CONTENT_URI, values);
72         assertStoredValues(uri, values);
73         assertSelection(People.CONTENT_URI, values, "people", People._ID, ContentUris.parseId(uri));
77         ContentValues values = new ContentValues();
78         putContactValues(values);
80         Uri uri = mResolver.insert(People.CONTENT_URI, values);
82         assertStoredValues(uri, values);
83         assertSelection(People.CONTENT_URI, values, "people", People._ID, personId);
85         values.clear();
86         putContactValues2(values);
87         mResolver.update(uri, values, null, null);
88         assertStoredValues(uri, values);
90         values.clear();
91         putContactValues(values);
92         mResolver.update(People.CONTENT_URI, values, People._ID + "=" + personId, null);
93         assertStoredValues(uri, values);
97         ContentValues values = new ContentValues();
98         values.put(People.NAME, "John Doe");
99         Uri personId = mResolver.insert(People.CONTENT_URI, values);
114         ContentValues values = new ContentValues();
115         values.put(People.NAME, "Deer Doe");
116         mResolver.insert(People.CONTENT_URI, values);
118         values.clear();
119         values.put(People.NAME, "Dear Dough");
120         mResolver.insert(People.CONTENT_URI, values);
122         values.clear();
123         values.put(People.NAME, "D.R. Dauwe");
124         mResolver.insert(People.CONTENT_URI, values);
133         ContentValues values = new ContentValues();
134         values.put(People.NAME, "John Doe");
135         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
140         ContentValues values = new ContentValues();
141         final Uri personUri = mResolver.insert(People.CONTENT_URI, values);
145         values.clear();
146         values.put(Organizations.ISPRIMARY, 1);
147         values.put(Organizations.COMPANY, "Google");
148         values.put(Organizations.TYPE, Organizations.TYPE_WORK);
149         values.put(Organizations.PERSON_ID, personId);
150         Uri orgUri1 = mResolver.insert(Organizations.CONTENT_URI, values);
153         values.clear();
154         values.put(Organizations.COMPANY, "Acme");
155         values.put(Organizations.TYPE, Organizations.TYPE_WORK);
156         values.put(Organizations.PERSON_ID, personId);
157         Uri orgUri2 = mResolver.insert(Organizations.CONTENT_URI, values);
159         values.clear();
160         values.put(People.PRIMARY_ORGANIZATION_ID, ContentUris.parseId(orgUri1));
161         values.put(People.DISPLAY_NAME, "Google");
162         assertStoredValues(personUri, values);
167         values.clear();
168         values.put(People.PRIMARY_ORGANIZATION_ID, ContentUris.parseId(orgUri2));
169         values.put(People.DISPLAY_NAME, "Acme");
170         assertStoredValues(personUri, values);
175         values.clear();
176         values.putNull(People.PRIMARY_ORGANIZATION_ID);
177         values.putNull(People.DISPLAY_NAME);
178         assertStoredValues(personUri, values);
182         ContentValues values = new ContentValues();
183         putContactValuesExceptName(values);
185         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
189         values.clear();
190         values.put(Phones.ISPRIMARY, 1);
191         values.put(Phones.TYPE, Phones.TYPE_WORK);
192         values.put(Phones.PERSON_ID, personId);
193         values.put(Phones.NUMBER, "12345");
194         Uri phoneUri1 = mResolver.insert(Phones.CONTENT_URI, values);
197         values.clear();
198         values.put(Phones.TYPE, Phones.TYPE_WORK);
199         values.put(Phones.PERSON_ID, personId);
200         values.put(Phones.NUMBER, "67890");
201         Uri phoneUri2 = mResolver.insert(Phones.CONTENT_URI, values);
203         values.clear();
204         values.put(People.PRIMARY_PHONE_ID, ContentUris.parseId(phoneUri1));
205         values.put(People.DISPLAY_NAME, "12345");
206         assertStoredValues(personUri, values);
208         values.clear();
209         putContactValuesExceptName(values);
210         values.put(People.PRIMARY_PHONE_ID, ContentUris.parseId(phoneUri1));
211         assertStoredValues(phoneUri2, values);
216         values.clear();
217         values.put(People.PRIMARY_PHONE_ID, ContentUris.parseId(phoneUri2));
218         values.put(People.DISPLAY_NAME, "67890");
219         assertStoredValues(personUri, values);
224         values.clear();
225         values.putNull(People.PRIMARY_PHONE_ID);
226         values.putNull(People.DISPLAY_NAME);
227         assertStoredValues(personUri, values);
231         ContentValues values = new ContentValues();
232         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
236         values.clear();
237         values.put(ContactMethods.PERSON_ID, personId);
238         values.put(ContactMethods.KIND, Contacts.KIND_EMAIL);
239         values.put(ContactMethods.TYPE, ContactMethods.TYPE_HOME);
240         values.put(ContactMethods.DATA, "foo@acme.com");
241         values.put(ContactMethods.ISPRIMARY, 1);
242         Uri emailUri1 = mResolver.insert(ContactMethods.CONTENT_URI, values);
247                 ContactMethods._ID + "=" + ContentUris.parseId(emailUri1), null, values);
249                 ContactMethods._ID + "=" + ContentUris.parseId(emailUri1), null, values);
253         ContentValues values = new ContentValues();
254         putContactValuesExceptName(values);
255         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
259         values.clear();
260         values.put(ContactMethods.PERSON_ID, personId);
261         values.put(ContactMethods.KIND, Contacts.KIND_EMAIL);
262         values.put(ContactMethods.TYPE, ContactMethods.TYPE_HOME);
263         values.put(ContactMethods.DATA, "foo@acme.com");
264         values.put(ContactMethods.ISPRIMARY, 1);
265         Uri emailUri1 = mResolver.insert(ContactMethods.CONTENT_URI, values);
268         values.clear();
269         values.put(ContactMethods.PERSON_ID, personId);
270         values.put(ContactMethods.KIND, Contacts.KIND_EMAIL);
271         values.put(ContactMethods.TYPE, ContactMethods.TYPE_WORK);
272         values.put(ContactMethods.DATA, "bar@acme.com");
273         Uri emailUri2 = mResolver.insert(ContactMethods.CONTENT_URI, values);
275         values.clear();
276         values.put(People.PRIMARY_EMAIL_ID, ContentUris.parseId(emailUri1));
277         values.put(People.DISPLAY_NAME, "foo@acme.com");
278         assertStoredValues(personUri, values);
280         values.clear();
281         putContactValuesExceptName(values);
282         values.put(People.PRIMARY_EMAIL_ID, ContentUris.parseId(emailUri1));
283         assertStoredValues(emailUri2, values);
288         values.clear();
289         values.put(People.PRIMARY_EMAIL_ID, ContentUris.parseId(emailUri2));
290         values.put(People.DISPLAY_NAME, "bar@acme.com");
291         assertStoredValues(personUri, values);
296         values.clear();
297         values.putNull(People.PRIMARY_EMAIL_ID);
298         values.putNull(People.DISPLAY_NAME);
299         assertStoredValues(personUri, values);
303         ContentValues values = new ContentValues();
304         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
323         ContentValues values = new ContentValues();
324         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
327         values.clear();
328         values.put(Organizations.COMPANY, "Sierra");
329         values.put(Organizations.PERSON_ID, personId);
330         values.put(Organizations.TYPE, Organizations.TYPE_CUSTOM);
331         values.put(Organizations.LABEL, "Club");
332         values.put(Organizations.TITLE, "Member");
333         values.put(Organizations.ISPRIMARY, 1);
335         Uri uri = mResolver.insert(Organizations.CONTENT_URI, values);
336         assertStoredValues(uri, values);
337         assertSelection(Organizations.CONTENT_URI, values,
349         assertStoredValues(twigUri, values);
352         assertStoredValues(twigUriWithId, values);
356         ContentValues values = new ContentValues();
357         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
360         values.clear();
361         values.put(Organizations.COMPANY, "Sierra");
362         values.put(Organizations.PERSON_ID, personId);
363         values.put(Organizations.TYPE, Organizations.TYPE_CUSTOM);
364         values.put(Organizations.LABEL, "Club");
365         values.put(Organizations.TITLE, "Member");
366         values.put(Organizations.ISPRIMARY, 0);
368         Uri uri = mResolver.insert(Organizations.CONTENT_URI, values);
370         values.clear();
371         values.put(Organizations.COMPANY, "Planetary");
372         values.put(Organizations.PERSON_ID, personId);
373         values.put(Organizations.TYPE, Organizations.TYPE_CUSTOM);
374         values.put(Organizations.LABEL, "Society");
375         values.put(Organizations.TITLE, "Chair");
376         values.put(Organizations.ISPRIMARY, 1);
378         mResolver.update(uri, values, null, null);
380         assertStoredValues(uri, values);
384         ContentValues values = new ContentValues();
385         putContactValues(values);
386         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
389         values.clear();
390         values.put(Phones.PERSON_ID, personId);
391         values.put(Phones.TYPE, Phones.TYPE_CUSTOM);
392         values.put(Phones.LABEL, "Directory");
393         values.put(Phones.NUMBER, "1-800-4664-411");
394         values.put(Phones.ISPRIMARY, 1);
396         Uri uri = mResolver.insert(Phones.CONTENT_URI, values);
399         expectedResults[0] = new ContentValues(values);
405         assertSelection(Phones.CONTENT_URI, values, "phones",
413         values.clear();
414         putContactValues(values);
415         values.put(People.TYPE, Phones.TYPE_CUSTOM);
416         values.put(People.LABEL, "Directory");
417         values.put(People.NUMBER, "1-800-4664-411");
418         assertStoredValues(personUri, values);
427         ContentValues values = new ContentValues();
428         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
431         values.clear();
432         values.put(Phones.PERSON_ID, personId);
433         values.put(Phones.TYPE, Phones.TYPE_CUSTOM);
434         values.put(Phones.LABEL, "Directory");
435         values.put(Phones.NUMBER, "1-800-4664-411");
436         values.put(Phones.ISPRIMARY, 0);
438         Uri uri = mResolver.insert(Phones.CONTENT_URI, values);
440         values.clear();
441         values.put(Phones.PERSON_ID, personId);
442         values.put(Phones.TYPE, Phones.TYPE_FAX_HOME);
443         values.putNull(Phones.LABEL);
444         values.put(Phones.NUMBER, "1-800-555-4663");
445         values.put(Phones.ISPRIMARY, 1);
447         mResolver.update(uri, values, null, null);
450         expectedValues[0] = values;
456         ContentValues values = new ContentValues();
457         putContactValues(values);
458         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
461         values.clear();
462         values.put(Phones.PERSON_ID, personId);
463         values.put(Phones.TYPE, Phones.TYPE_CUSTOM);
464         values.put(Phones.LABEL, "Directory");
465         values.put(Phones.NUMBER, "800-4664-411");
466         values.put(Phones.ISPRIMARY, 1);
468         Uri uri = mResolver.insert(Phones.CONTENT_URI, values);
472         expectedValues[0] = values;
526         ContentValues values = new ContentValues();
527         putContactValues(values);
528         final Uri personUri = mResolver.insert(People.CONTENT_URI, values);
531         values.clear();
532         values.put(ContactMethods.PERSON_ID, personId);
533         values.put(ContactMethods.KIND, kind);
534         values.put(ContactMethods.TYPE, type);
535         values.put(ContactMethods.LABEL, label);
536         values.put(ContactMethods.DATA, data);
537         values.put(ContactMethods.AUX_DATA, auxData);
538         values.put(ContactMethods.ISPRIMARY, primary ? 1 : 0);
540         Uri uri = mResolver.insert(ContactMethods.CONTENT_URI, values);
543         putContactValues(values);
544         assertStoredValues(uri, values);
545         assertSelection(ContactMethods.CONTENT_URI, values, "contact_methods",
550         assertStoredValues(twigUri, values);
563         ContentValues values = new ContentValues();
564         putContactValues(values);
565         final Uri personUri = mResolver.insert(People.CONTENT_URI, values);
568         values.clear();
569         values.put(ContactMethods.PERSON_ID, personId);
570         values.put(ContactMethods.KIND, kind);
571         values.put(ContactMethods.TYPE, type1);
572         values.put(ContactMethods.LABEL, label1);
573         values.put(ContactMethods.DATA, data1);
574         values.put(ContactMethods.AUX_DATA, auxData1);
575         values.put(ContactMethods.ISPRIMARY, primary1 ? 1 : 0);
577         Uri uri = mResolver.insert(ContactMethods.CONTENT_URI, values);
579         values.clear();
580         values.put(ContactMethods.TYPE, type2);
581         values.put(ContactMethods.LABEL, label2);
582         values.put(ContactMethods.DATA, data2);
583         values.put(ContactMethods.AUX_DATA, auxData2);
584         values.put(ContactMethods.ISPRIMARY, primary2 ? 1 : 0);
585         mResolver.update(uri, values, null, null);
587         assertStoredValues(uri, values);
591         ContentValues values = new ContentValues();
592         final Uri personUri = mResolver.insert(People.CONTENT_URI, values);
595         values.clear();
596         values.put(Extensions.PERSON_ID, personId);
597         values.put(Extensions.NAME, "Foo");
598         values.put(Extensions.VALUE, "Bar");
600         Uri uri = mResolver.insert(Extensions.CONTENT_URI, values);
601         assertStoredValues(uri, values);
602         assertSelection(Extensions.CONTENT_URI, values, "extensions",
607         assertStoredValues(twigUri, values);
611         ContentValues values = new ContentValues();
612         final Uri personUri = mResolver.insert(People.CONTENT_URI, values);
615         values.clear();
616         values.put(Extensions.PERSON_ID, personId);
617         values.put(Extensions.NAME, "Foo");
618         values.put(Extensions.VALUE, "Bar");
620         Uri uri = mResolver.insert(Extensions.CONTENT_URI, values);
622         values.clear();
623         values.put(Extensions.NAME, "Biz");
624         values.put(Extensions.VALUE, "Baz");
625         mResolver.update(uri, values, null, null);
627         assertStoredValues(uri, values);
631         ContentValues values = new ContentValues();
632         values.put(Groups.NAME, "Galois");
633         values.put(Groups.NOTES, "Abel");
634         values.put(Groups.SYSTEM_ID, "12345");
636         Uri groupUri = mResolver.insert(Groups.CONTENT_URI, values);
637         assertStoredValues(groupUri, values);
641         ContentValues values = new ContentValues();
642         values.put(Groups.NAME, "Galois");
643         values.put(Groups.NOTES, "Abel");
644         values.put(Groups.SYSTEM_ID, "12345");
646         Uri groupUri = mResolver.insert(Groups.CONTENT_URI, values);
648         values.clear();
649         values.put(Groups.NAME, "Klein");
650         values.put(Groups.NOTES, "Vierergruppe");
651         values.put(Groups.SYSTEM_ID, "1234");
652         mResolver.update(groupUri, values, null, null);
653         assertStoredValues(groupUri, values);
657         ContentValues values = new ContentValues();
658         values.put(Groups.NOTES, "Abel");
659         Uri groupUri = insertLegacyGroup("Galois", values);
660         Uri personUri = insertPerson("Klein", values);
661         Uri membershipUri = insertLegacyGroupMembership(groupUri, personUri, values);
662         values.put(Groups.NAME, "Galois");
663         values.put(Groups.NOTES, "Abel");
665         assertStoredValues(membershipUri, values);
666         assertSelection(GroupMembership.CONTENT_URI, values, "groupmembership",
670         assertStoredValues(personsGroupsUri, values);
674         ContentValues values = new ContentValues();
675         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
678         values.clear();
679         values.put(Groups.NAME, "Galois");
680         Uri groupUri = mResolver.insert(Groups.CONTENT_URI, values);
684         values.clear();
685         values.put(GroupMembership.GROUP_ID, ContentUris.parseId(groupUri));
686         values.put(GroupMembership.PERSON_ID, personId);
689         assertStoredValues(personsGroupsUri, values);
693         ContentValues values = new ContentValues();
694         Uri groupUri1 = insertLegacyGroup("Galois", values);
695         Uri personUri1 = insertPerson("Klein", values);
696         insertLegacyGroupMembership(groupUri1, personUri1, values);
698         Uri groupUri2 = insertLegacyGroup("Euler", values);
699         Uri personUri2 = insertPerson("Lagrange", values);
700         insertLegacyGroupMembership(groupUri2, personUri2, values);
715         ContentValues values = new ContentValues();
716         Uri personUri = mResolver.insert(People.CONTENT_URI, values);
718         values.clear();
719         values.put(Photos.DATA, photo);
720         values.put(Photos.LOCAL_VERSION, "10");
722         // values.put(Photos.DOWNLOAD_REQUIRED, 1);
723         values.put(Photos.EXISTS_ON_SERVER, 1);
724         values.put(Photos.SYNC_ERROR, "404 does not exist");
727         mResolver.update(photoUri, values, null, null);
728         values.put(Photos.DATA, thumbnailedPhoto);
729         assertStoredValues(photoUri, values);
733         values.put(Photos.LOCAL_VERSION, "11");
734         values.put(Photos.DATA, photo);
736         mResolver.update(contentUri, values, null, null);
737         values.put(Photos.DATA, thumbnailedPhoto);
738         assertStoredValues(contentUri, values);
739         assertStoredValues(photoUri, values);
762         ContentValues values = new ContentValues();
765             values.put(People.NAME, "Deer Dough");
768         final Uri personUri = mResolver.insert(People.CONTENT_URI, values);
774             values.clear();
776             values.put(Photos.DATA, photoData);
777             values.put(Photos.LOCAL_VERSION, "1");
778             values.put(Photos.EXISTS_ON_SERVER, 0);
780             mResolver.update(photoUri, values, null, null);
784             values.clear();
785             values.put(Organizations.ISPRIMARY, 1);
786             values.put(Organizations.COMPANY, "Google");
787             values.put(Organizations.TYPE, Organizations.TYPE_WORK);
788             values.put(Organizations.PERSON_ID, personId);
789             mResolver.insert(Organizations.CONTENT_URI, values);
793             values.clear();
794             values.put(ContactMethods.PERSON_ID, personId);
795             values.put(ContactMethods.KIND, Contacts.KIND_EMAIL);
796             values.put(ContactMethods.TYPE, ContactMethods.TYPE_HOME);
797             values.put(ContactMethods.DATA, "foo@acme.com");
798             values.put(ContactMethods.ISPRIMARY, 1);
799             mResolver.insert(ContactMethods.CONTENT_URI, values);
804             values.clear();
805             values.put(Presence.IM_PROTOCOL, protocol);
806             values.put(Presence.IM_HANDLE, "foo@acme.com");
807             values.put(Presence.IM_ACCOUNT, "foo");
808             values.put(Presence.PRESENCE_STATUS, Presence.OFFLINE);
809             values.put(Presence.PRESENCE_CUSTOM_STATUS, "Coding for Android");
810             mResolver.insert(Presence.CONTENT_URI, values);
814             values.clear();
815             values.put(Phones.PERSON_ID, personId);
816             values.put(Phones.TYPE, Phones.TYPE_HOME);
817             values.put(Phones.NUMBER, "1-800-4664-411");
818             values.put(Phones.ISPRIMARY, 1);
819             mResolver.insert(Phones.CONTENT_URI, values);
828         values.clear();
838         values.put("_id", personId);
839         values.put(SearchManager.SUGGEST_COLUMN_ICON_2, expectedIcon2);
840         values.put(SearchManager.SUGGEST_COLUMN_INTENT_DATA_ID, personId);
841         values.put(SearchManager.SUGGEST_COLUMN_SHORTCUT_ID, personId);
842         values.put(SearchManager.SUGGEST_COLUMN_TEXT_1, expectedText1);
843         values.put(SearchManager.SUGGEST_COLUMN_TEXT_2, expectedText2);
844         assertCursorValues(c, values);
862         ContentValues values = new ContentValues();
863         values.put(Settings._SYNC_ACCOUNT, "foo");
864         values.put(Settings._SYNC_ACCOUNT_TYPE, "bar");
865         values.put(Settings.KEY, Settings.SYNC_EVERYTHING);
866         values.put(Settings.VALUE, 7);
867         mResolver.update(Settings.CONTENT_URI, values, null, null);
876         values.clear();
877         values.put(ContactsContract.Settings.SHOULD_SYNC, 8);
878         mResolver.update(ContactsContract.Settings.CONTENT_URI, values,
885     private Uri insertPerson(String name, ContentValues values) {
886         values.put(People.NAME, name);
887         return mResolver.insert(People.CONTENT_URI, values);
890     private Uri insertLegacyGroup(String name, ContentValues values) {
891         values.put(Groups.NAME, name);
892         return mResolver.insert(Groups.CONTENT_URI, values);
895     private Uri insertLegacyGroupMembership(Uri groupUri, Uri personUri, ContentValues values) {
899         values.clear();
900         values.put(GroupMembership.GROUP_ID, groupId);
901         values.put(GroupMembership.PERSON_ID, personId);
902         Uri membershipUri = mResolver.insert(GroupMembership.CONTENT_URI, values);
906     private void putContactValues(ContentValues values) {
907         putContactValuesExceptName(values);
908         values.put(People.NAME, "Deer Dough");
911     private void putContactValuesExceptName(ContentValues values) {
913         values.put(People.NOTES, "Cash Cow");
914         values.put(People.TIMES_CONTACTED, 3);
915         values.put(People.LAST_TIME_CONTACTED, 10);
916         values.put(People.CUSTOM_RINGTONE, "ringtone");
917         values.put(People.SEND_TO_VOICEMAIL, 1);
918         values.put(People.STARRED, 1);
921     private void putContactValues2(ContentValues values) {
923         values.put(People.NAME, "John Doe");
924         values.put(People.PHONETIC_NAME, "jon dawe");
925         values.put(People.NOTES, "Poor Johnny");
926         values.put(People.TIMES_CONTACTED, 4);
927         values.put(People.LAST_TIME_CONTACTED, 11);
928         values.put(People.CUSTOM_RINGTONE, "rangtone");
929         values.put(People.SEND_TO_VOICEMAIL, 0);
930         values.put(People.STARRED, 0);
949         ContentValues values = new ContentValues();
950         values.put(typeColumn, defaultType);
952             mResolver.insert(uri, values);
961         ContentValues values = new ContentValues();
962         values.put(personIdColumn, personId);
963         values.put(labelColumn, "Foo");
966             mResolver.insert(uri, values);
973     protected void assertSelection(Uri uri, ContentValues values, String legacyTable,
975         values.put(idColumn, id);
977         super.assertSelection(uri, values, qualified, id);