ContactsContract.Data
public
static
final
class
ContactsContract.Data
extends Object
implements
ContactsContract.DataColumnsWithJoins
| java.lang.Object | |
| ↳ | android.provider.ContactsContract.Data |
Constants for the data table, which contains data points tied to a raw contact. Each row of the data table is typically used to store a single piece of contact information (such as a phone number) and its associated metadata (such as whether it is a work or home number).
Data kinds
Data is a generic table that can hold any kind of contact data.
The kind of data stored in a given row is specified by the row's
ContactsContract.DataColumns.MIMETYPE value, which determines the meaning of the
generic columns ContactsContract.DataColumns.DATA1 through
ContactsContract.DataColumns.DATA15.
For example, if the data kind is
Phone.CONTENT_ITEM_TYPE, then the column
ContactsContract.DataColumns.DATA1 stores the
phone number, but if the data kind is
Email.CONTENT_ITEM_TYPE, then ContactsContract.DataColumns.DATA1
stores the email address.
Sync adapters and applications can introduce their own data kinds.
ContactsContract defines a small number of pre-defined data kinds, e.g.
CommonDataKinds.Phone, CommonDataKinds.Email etc. As a
convenience, these classes define data kind specific aliases for DATA1 etc.
For example, Phone.NUMBER is the same as
Data.DATA1.
ContactsContract.DataColumns.DATA1 is an indexed column and should be used for the data element that is
expected to be most frequently used in query selections. For example, in the
case of a row representing email addresses ContactsContract.DataColumns.DATA1 should probably
be used for the email address itself, while ContactsContract.DataColumns.DATA2 etc can be
used for auxiliary information like type of email address.
By convention, ContactsContract.DataColumns.DATA15 is used for storing BLOBs (binary data).
The sync adapter for a given account type must correctly handle every data type used in the corresponding raw contacts. Otherwise it could result in lost or corrupted data.
Similarly, you should refrain from introducing new kinds of data for an other party's account types. For example, if you add a data row for "favorite song" to a raw contact owned by a Google account, it will not get synced to the server, because the Google sync adapter does not know how to handle this data kind. Thus new data kinds are typically introduced along with new account types, i.e. new sync adapters.
Batch operations
Data rows can be inserted/updated/deleted using the traditional
ContentResolver.insert, ContentResolver.update and
ContentResolver.delete methods, however the newer mechanism based
on a batch of ContentProviderOperation will prove to be a better
choice in almost all cases. All operations in a batch are executed in a
single transaction, which ensures that the phone-side and server-side
state of a raw contact are always consistent. Also, the batch-based
approach is far more efficient: not only are the database operations
faster when executed in a single transaction, but also sending a batch of
commands to the content provider saves a lot of time on context switching
between your process and the process in which the content provider runs.
The flip side of using batched operations is that a large batch may lock up the database for a long time preventing other applications from accessing data and potentially causing ANRs ("Application Not Responding" dialogs.)
To avoid such lockups of the database, make sure to insert "yield points"
in the batch. A yield point indicates to the content provider that before
executing the next operation it can commit the changes that have already
been made, yield to other requests, open another transaction and continue
processing operations. A yield point will not automatically commit the
transaction, but only if there is another request waiting on the
database. Normally a sync adapter should insert a yield point at the
beginning of each raw contact operation sequence in the batch. See
ContentProviderOperation.Builder.withYieldAllowed(boolean).
Operations
- Insert
-
An individual data row can be inserted using the traditional
ContentResolver.insert(Uri, ContentValues)method. Multiple rows should always be inserted as a batch.An example of a traditional insert:
ContentValues values = new ContentValues(); values.put(Data.RAW_CONTACT_ID, rawContactId); values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); values.put(Phone.NUMBER, "1-800-GOOG-411"); values.put(Phone.TYPE, Phone.TYPE_CUSTOM); values.put(Phone.LABEL, "free directory assistance"); Uri dataUri = getContentResolver().insert(Data.CONTENT_URI, values);
The same done using ContentProviderOperations:
ArrayList<ContentProviderOperation> ops = new ArrayList<ContentProviderOperation>(); ops.add(ContentProviderOperation.newInsert(Data.CONTENT_URI) .withValue(Data.RAW_CONTACT_ID, rawContactId) .withValue(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE) .withValue(Phone.NUMBER, "1-800-GOOG-411") .withValue(Phone.TYPE, Phone.TYPE_CUSTOM) .withValue(Phone.LABEL, "free directory assistance") .build()); getContentResolver().applyBatch(ContactsContract.AUTHORITY, ops); - Update
-
Just as with insert, update can be done incrementally or as a batch, the batch mode being the preferred method:
ArrayList<ContentProviderOperation> ops = new ArrayList<ContentProviderOperation>(); ops.add(ContentProviderOperation.newUpdate(Data.CONTENT_URI) .withSelection(Data._ID + "=?", new String[]{String.valueOf(dataId)}) .withValue(Email.DATA, "somebody@android.com") .build()); getContentResolver().applyBatch(ContactsContract.AUTHORITY, ops); - Delete
-
Just as with insert and update, deletion can be done either using the
ContentResolver.deletemethod or using a ContentProviderOperation:ArrayList<ContentProviderOperation> ops = new ArrayList<ContentProviderOperation>(); ops.add(ContentProviderOperation.newDelete(Data.CONTENT_URI) .withSelection(Data._ID + "=?", new String[]{String.valueOf(dataId)}) .build()); getContentResolver().applyBatch(ContactsContract.AUTHORITY, ops); - Query
-
- Finding all Data of a given type for a given contact
-
Cursor c = getContentResolver().query(Data.CONTENT_URI, new String[] {Data._ID, Phone.NUMBER, Phone.TYPE, Phone.LABEL}, Data.CONTACT_ID + "=?" + " AND " + Data.MIMETYPE + "='" + Phone.CONTENT_ITEM_TYPE + "'", new String[] {String.valueOf(contactId)}, null); - Finding all Data of a given type for a given raw contact
-
Cursor c = getContentResolver().query(Data.CONTENT_URI, new String[] {Data._ID, Phone.NUMBER, Phone.TYPE, Phone.LABEL}, Data.RAW_CONTACT_ID + "=?" + " AND " + Data.MIMETYPE + "='" + Phone.CONTENT_ITEM_TYPE + "'", new String[] {String.valueOf(rawContactId)}, null); - Finding all Data for a given raw contact
-
Most sync adapters will want to read all data rows for a raw contact
along with the raw contact itself. For that you should use the
RawContactsEntity. See alsoRawContacts.
Columns
Many columns are available via a Data.CONTENT_URI query. For best performance you
should explicitly specify a projection to only those columns that you need.
| Data | |||
|---|---|---|---|
| long | BaseColumns._ID |
read-only | Row ID. Sync adapter should try to preserve row IDs during updates. In other words, it would be a bad idea to delete and reinsert a data row. A sync adapter should always do an update instead. |
| String | ContactsContract.DataColumns.MIMETYPE |
read/write-once |
The MIME type of the item represented by this row. Examples of common MIME types are:
|
| long | ContactsContract.DataColumns.RAW_CONTACT_ID |
read/write-once | The id of the row in the RawContacts table that this data belongs to. |
| int | ContactsContract.DataColumns.IS_PRIMARY |
read/write | Whether this is the primary entry of its kind for the raw contact it belongs to. "1" if true, "0" if false. |
| int | ContactsContract.DataColumns.IS_SUPER_PRIMARY |
read/write | Whether this is the primary entry of its kind for the aggregate contact it belongs to. Any data record that is "super primary" must also be "primary". For example, the super-primary entry may be interpreted as the default contact value of its kind (for example, the default phone number to use for the contact). |
| int | ContactsContract.DataColumns.DATA_VERSION |
read-only | The version of this data record. Whenever the data row changes the version goes up. This value is monotonically increasing. |
| Any type |
ContactsContract.DataColumns.DATA1ContactsContract.DataColumns.DATA2ContactsContract.DataColumns.DATA3ContactsContract.DataColumns.DATA4ContactsContract.DataColumns.DATA5ContactsContract.DataColumns.DATA6ContactsContract.DataColumns.DATA7ContactsContract.DataColumns.DATA8ContactsContract.DataColumns.DATA9ContactsContract.DataColumns.DATA10ContactsContract.DataColumns.DATA11ContactsContract.DataColumns.DATA12ContactsContract.DataColumns.DATA13ContactsContract.DataColumns.DATA14ContactsContract.DataColumns.DATA15
|
read/write |
Generic data columns. The meaning of each column is determined by the
Data columns whose meaning is not explicitly defined for a given MIMETYPE
should not be used. There is no guarantee that any sync adapter will
preserve them. Sync adapters themselves should not use such columns either,
but should instead use |
| Any type |
ContactsContract.DataColumns.SYNC1ContactsContract.DataColumns.SYNC2ContactsContract.DataColumns.SYNC3ContactsContract.DataColumns.SYNC4
|
read/write | Generic columns for use by sync adapters. For example, a Photo row may store the image URL in SYNC1, a status (not loaded, loading, loaded, error) in SYNC2, server-side version number in SYNC3 and error code in SYNC4. |
Some columns from the most recent associated status update are also available through an implicit join.
Join with StatusUpdates |
|||
|---|---|---|---|
| int | ContactsContract.StatusColumns.PRESENCE |
read-only | IM presence status linked to this data row. Compare with
ContactsContract.ContactStatusColumns.CONTACT_PRESENCE, which contains the contact's presence across
all IM rows. See StatusUpdates for individual status definitions.
The provider may choose not to store this value
in persistent storage. The expectation is that presence status will be
updated on a regular basis.
|
| String | ContactsContract.StatusColumns.STATUS |
read-only | Latest status update linked with this data row. |
| long | ContactsContract.StatusColumns.STATUS_TIMESTAMP |
read-only | The absolute time in milliseconds when the latest status was inserted/updated for this data row. |
| String | ContactsContract.StatusColumns.STATUS_RES_PACKAGE |
read-only | The package containing resources for this status: label and icon. |
| long | ContactsContract.StatusColumns.STATUS_LABEL |
read-only | The resource ID of the label describing the source of status update linked
to this data row. This resource is scoped by the ContactsContract.StatusColumns.STATUS_RES_PACKAGE. |
| long | ContactsContract.StatusColumns.STATUS_ICON |
read-only | The resource ID of the icon for the source of the status update linked
to this data row. This resource is scoped by the ContactsContract.StatusColumns.STATUS_RES_PACKAGE. |
Some columns from the associated raw contact are also available through an implicit join. The other columns are excluded as uninteresting in this context.
Join with ContactsContract.RawContacts |
|||
|---|---|---|---|
| long | ContactsContract.RawContactsColumns.CONTACT_ID |
read-only | The id of the row in the Contacts table that this data belongs
to. |
| int | ContactsContract.RawContactsColumns.AGGREGATION_MODE |
read-only | See RawContacts. |
| int | ContactsContract.RawContactsColumns.DELETED |
read-only | See RawContacts. |
The ID column for the associated aggregated contact table
ContactsContract.Contacts is available
via the implicit join to the RawContacts table, see above.
The remaining columns from this table are also
available, through an implicit join. This
facilitates lookup by
the value of a single data element, such as the email address.
Summary
Constants | |
|---|---|
String |
CONTENT_TYPE
The MIME type of the results from |
String |
EXTRA_ADDRESS_BOOK_INDEX
Add this query parameter to a URI to get back row counts grouped by the address book index as cursor extras. |
String |
EXTRA_ADDRESS_BOOK_INDEX_COUNTS
The array of group counts for the corresponding group. |
String |
EXTRA_ADDRESS_BOOK_INDEX_TITLES
The array of address book index titles, which are returned in the same order as the data in the cursor. |
String |
VISIBLE_CONTACTS_ONLY
A boolean parameter for |
Inherited constants |
|---|
Fields | |
|---|---|
public
static
final
Uri |
CONTENT_URI
The content:// style URI for this table, which requests a directory of data rows matching the selection criteria. |
Public methods | |
|---|---|
static
Uri
|
getContactLookupUri(ContentResolver resolver, Uri dataUri)
Build a |
Inherited methods | |
|---|---|
Constants
CONTENT_TYPE
public static final String CONTENT_TYPE
The MIME type of the results from CONTENT_URI.
Constant Value: "vnd.android.cursor.dir/data"
EXTRA_ADDRESS_BOOK_INDEX
public static final String EXTRA_ADDRESS_BOOK_INDEX
Add this query parameter to a URI to get back row counts grouped by the address book index as cursor extras. For most languages it is the first letter of the sort key. This parameter does not affect the main content of the cursor.
Example:
import android.provider.ContactsContract.Contacts;
Uri uri = Contacts.CONTENT_URI.buildUpon()
.appendQueryParameter(Contacts.EXTRA_ADDRESS_BOOK_INDEX, "true")
.build();
Cursor cursor = getContentResolver().query(uri,
new String[] {Contacts.DISPLAY_NAME},
null, null, null);
Bundle bundle = cursor.getExtras();
if (bundle.containsKey(Contacts.EXTRA_ADDRESS_BOOK_INDEX_TITLES) &&
bundle.containsKey(Contacts.EXTRA_ADDRESS_BOOK_INDEX_COUNTS)) {
String sections[] =
bundle.getStringArray(Contacts.EXTRA_ADDRESS_BOOK_INDEX_TITLES);
int counts[] = bundle.getIntArray(Contacts.EXTRA_ADDRESS_BOOK_INDEX_COUNTS);
}
Constant Value: "android.provider.extra.ADDRESS_BOOK_INDEX"
EXTRA_ADDRESS_BOOK_INDEX_COUNTS
public static final String EXTRA_ADDRESS_BOOK_INDEX_COUNTS
The array of group counts for the corresponding group. Contains the same number of elements as the EXTRA_ADDRESS_BOOK_INDEX_TITLES array.
TYPE: int[]
Constant Value: "android.provider.extra.ADDRESS_BOOK_INDEX_COUNTS"
EXTRA_ADDRESS_BOOK_INDEX_TITLES
public static final String EXTRA_ADDRESS_BOOK_INDEX_TITLES
The array of address book index titles, which are returned in the same order as the data in the cursor.
TYPE: String[]
Constant Value: "android.provider.extra.ADDRESS_BOOK_INDEX_TITLES"
VISIBLE_CONTACTS_ONLY
public static final String VISIBLE_CONTACTS_ONLY
A boolean parameter for Data.CONTENT_URI.
This specifies whether or not the returned data items should be filtered to show
data items belonging to visible contacts only.
Constant Value: "visible_contacts_only"
Fields
CONTENT_URI
public static final Uri CONTENT_URI
The content:// style URI for this table, which requests a directory of data rows matching the selection criteria.
Public methods
getContactLookupUri
public static Uri getContactLookupUri (ContentResolver resolver, Uri dataUri)
Build a ContactsContract.Contacts.CONTENT_LOOKUP_URI
style Uri for the parent ContactsContract.Contacts
entry of the given ContactsContract.Data entry.
Returns the Uri for the contact in the first entry returned by
ContentResolver.query(Uri, String[], String, String[], String)
for the provided dataUri. If the query returns null or empty
results, silently returns null.
| Parameters | |
|---|---|
resolver |
ContentResolver |
dataUri |
Uri |
| Returns | |
|---|---|
Uri |
|