| /* |
| * Copyright (C) 2020 The Android Open Source Project |
| * |
| * Licensed under the Apache License, Version 2.0 (the "License"); |
| * you may not use this file except in compliance with the License. |
| * You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, software |
| * distributed under the License is distributed on an "AS IS" BASIS, |
| * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| * See the License for the specific language governing permissions and |
| * limitations under the License. |
| */ |
| |
| package com.android.ims.rcs.uce.eab; |
| |
| import static android.content.ContentResolver.NOTIFY_DELETE; |
| import static android.content.ContentResolver.NOTIFY_INSERT; |
| import static android.content.ContentResolver.NOTIFY_SYNC_TO_NETWORK; |
| import static android.content.ContentResolver.NOTIFY_UPDATE; |
| |
| import android.content.ContentProvider; |
| import android.content.ContentValues; |
| import android.content.Context; |
| import android.content.UriMatcher; |
| import android.database.Cursor; |
| import android.database.sqlite.SQLiteDatabase; |
| import android.database.sqlite.SQLiteOpenHelper; |
| import android.database.sqlite.SQLiteQueryBuilder; |
| import android.net.Uri; |
| import android.os.UserHandle; |
| import android.provider.BaseColumns; |
| import android.text.TextUtils; |
| import android.util.Log; |
| |
| import com.android.internal.annotations.VisibleForTesting; |
| |
| import java.util.ArrayList; |
| import java.util.List; |
| |
| /** |
| * This class provides the ability to query the enhanced address book databases(A.K.A. EAB) based on |
| * both SIP options and UCE presence server data. |
| * |
| * <p> |
| * There are 4 tables in EAB DB: |
| * <ul> |
| * <li><em>Contact:</em> It stores the name and phone number of the contact. |
| * |
| * <li><em>Common:</em> It's a general table for storing the query results and the mechanisms of |
| * querying UCE capabilities. It should be 1:1 mapped to the contact table and has a foreign |
| * key(eab_contact_id) that refers to the id of contact table. If the value of mechanism is |
| * 1 ({@link android.telephony.ims.RcsContactUceCapability#CAPABILITY_MECHANISM_PRESENCE}), the |
| * capability information should be stored in presence table, if the value of mechanism is |
| * 2({@link android.telephony.ims.RcsContactUceCapability#CAPABILITY_MECHANISM_OPTIONS}), it |
| * should be stored in options table. |
| * |
| * <li><em>Presence:</em> It stores the information |
| * ({@link android.telephony.ims.RcsContactUceCapability}) that queried through presence server. |
| * It should be *:1 mapped to the common table and has a foreign key(eab_common_id) that refers |
| * to the id of common table. |
| * |
| * <li><em>Options:</em> It stores the information |
| * ({@link android.telephony.ims.RcsContactUceCapability}) that queried through SIP OPTIONS. It |
| * should be *:1 mapped to the common table and it has a foreign key(eab_common_id) that refers |
| * to the id of common table. |
| * </ul> |
| * </p> |
| */ |
| public class EabProvider extends ContentProvider { |
| // The public URI for operating Eab DB. They support query, insert, delete and update. |
| public static final Uri CONTACT_URI = Uri.parse("content://eab/contact"); |
| public static final Uri COMMON_URI = Uri.parse("content://eab/common"); |
| public static final Uri PRESENCE_URI = Uri.parse("content://eab/presence"); |
| public static final Uri OPTIONS_URI = Uri.parse("content://eab/options"); |
| |
| // The public URI for querying EAB DB. Only support query. |
| public static final Uri ALL_DATA_URI = Uri.parse("content://eab/all"); |
| |
| @VisibleForTesting |
| public static final String AUTHORITY = "eab"; |
| |
| private static final String TAG = "EabProvider"; |
| private static final int DATABASE_VERSION = 2; |
| |
| private static final String EAB_CONTACT_TABLE_NAME = "eab_contact"; |
| private static final String EAB_COMMON_TABLE_NAME = "eab_common"; |
| private static final String EAB_PRESENCE_TUPLE_TABLE_NAME = "eab_presence"; |
| private static final String EAB_OPTIONS_TABLE_NAME = "eab_options"; |
| |
| private static final UriMatcher URI_MATCHER = new UriMatcher(UriMatcher.NO_MATCH); |
| private static final int URL_CONTACT = 1; |
| private static final int URL_COMMON = 2; |
| private static final int URL_PRESENCE = 3; |
| private static final int URL_OPTIONS = 4; |
| private static final int URL_ALL = 5; |
| private static final int URL_ALL_WITH_SUB_ID_AND_PHONE_NUMBER = 6; |
| |
| static { |
| URI_MATCHER.addURI(AUTHORITY, "contact", URL_CONTACT); |
| URI_MATCHER.addURI(AUTHORITY, "common", URL_COMMON); |
| URI_MATCHER.addURI(AUTHORITY, "presence", URL_PRESENCE); |
| URI_MATCHER.addURI(AUTHORITY, "options", URL_OPTIONS); |
| URI_MATCHER.addURI(AUTHORITY, "all", URL_ALL); |
| URI_MATCHER.addURI(AUTHORITY, "all/#/*", URL_ALL_WITH_SUB_ID_AND_PHONE_NUMBER); |
| } |
| |
| private static final String QUERY_CONTACT_TABLE = |
| " SELECT * FROM " + EAB_CONTACT_TABLE_NAME; |
| |
| private static final String JOIN_ALL_TABLES = |
| // join common table |
| " INNER JOIN " + EAB_COMMON_TABLE_NAME |
| + " ON " + EAB_CONTACT_TABLE_NAME + "." + ContactColumns._ID |
| + "=" + EAB_COMMON_TABLE_NAME + "." + EabCommonColumns.EAB_CONTACT_ID |
| |
| // join options table |
| + " LEFT JOIN " + EAB_OPTIONS_TABLE_NAME |
| + " ON " + EAB_OPTIONS_TABLE_NAME + "." + EabCommonColumns._ID |
| + "=" + EAB_OPTIONS_TABLE_NAME + "." + OptionsColumns.EAB_COMMON_ID |
| |
| // join presence table |
| + " LEFT JOIN " + EAB_PRESENCE_TUPLE_TABLE_NAME |
| + " ON " + EAB_PRESENCE_TUPLE_TABLE_NAME + "." + EabCommonColumns._ID |
| + "=" + EAB_PRESENCE_TUPLE_TABLE_NAME + "." |
| + PresenceTupleColumns.EAB_COMMON_ID; |
| |
| /** |
| * The contact table's columns. |
| */ |
| public static class ContactColumns implements BaseColumns { |
| |
| /** |
| * The contact's phone number. It may come from contact provider or someone via |
| * {@link EabControllerImpl#saveCapabilities(List)} to save the capability but the phone |
| * number not in contact provider. |
| * |
| * <P>Type: TEXT</P> |
| */ |
| public static final String PHONE_NUMBER = "phone_number"; |
| |
| /** |
| * The ID of contact that store in contact provider. It refer to the |
| * {@link android.provider.ContactsContract.Data#CONTACT_ID}. If the phone number not in |
| * contact provider, the value should be null. |
| * |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String CONTACT_ID = "contact_id"; |
| |
| /** |
| * The ID of contact that store in contact provider. It refer to the |
| * {@link android.provider.ContactsContract.Data#RAW_CONTACT_ID}. If the phone number not in |
| * contact provider, the value should be null. |
| * |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String RAW_CONTACT_ID = "raw_contact_id"; |
| |
| /** |
| * The ID of phone number that store in contact provider. It refer to the |
| * {@link android.provider.ContactsContract.Data#_ID}. If the phone number not in |
| * contact provider, the value should be null. |
| * |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String DATA_ID = "data_id"; |
| } |
| |
| /** |
| * The common table's columns. The eab_contact_id should refer to the id of contact table. |
| */ |
| public static class EabCommonColumns implements BaseColumns { |
| |
| /** |
| * A reference to the {@link ContactColumns#_ID} that this data belongs to. |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String EAB_CONTACT_ID = "eab_contact_id"; |
| |
| /** |
| * The mechanism of querying UCE capability. Possible values are |
| * {@link android.telephony.ims.RcsContactUceCapability#CAPABILITY_MECHANISM_OPTIONS } |
| * and |
| * {@link android.telephony.ims.RcsContactUceCapability#CAPABILITY_MECHANISM_PRESENCE } |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String MECHANISM = "mechanism"; |
| |
| /** |
| * The result of querying UCE capability. Possible values are |
| * {@link android.telephony.ims.RcsContactUceCapability#REQUEST_RESULT_NOT_ONLINE } |
| * and |
| * {@link android.telephony.ims.RcsContactUceCapability#REQUEST_RESULT_NOT_FOUND } |
| * and |
| * {@link android.telephony.ims.RcsContactUceCapability#REQUEST_RESULT_FOUND } |
| * and |
| * {@link android.telephony.ims.RcsContactUceCapability#REQUEST_RESULT_UNKNOWN } |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String REQUEST_RESULT = "request_result"; |
| |
| /** |
| * The subscription id. |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String SUBSCRIPTION_ID = "subscription_id"; |
| } |
| |
| /** |
| * This is used to generate a instance of {@link android.telephony.ims.RcsContactPresenceTuple}. |
| * See that class for more information on each of these parameters. |
| */ |
| public static class PresenceTupleColumns implements BaseColumns { |
| |
| /** |
| * A reference to the {@link ContactColumns#_ID} that this data belongs to. |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String EAB_COMMON_ID = "eab_common_id"; |
| |
| /** |
| * The basic status of service capabilities. Possible values are |
| * {@link android.telephony.ims.RcsContactPresenceTuple#TUPLE_BASIC_STATUS_OPEN} |
| * and |
| * {@link android.telephony.ims.RcsContactPresenceTuple#TUPLE_BASIC_STATUS_CLOSED} |
| * <P>Type: TEXT</P> |
| */ |
| public static final String BASIC_STATUS = "basic_status"; |
| |
| /** |
| * The OMA Presence service-id associated with this capability. See the OMA Presence SIMPLE |
| * specification v1.1, section 10.5.1. |
| * <P>Type: TEXT</P> |
| */ |
| public static final String SERVICE_ID = "service_id"; |
| |
| /** |
| * The contact uri of service capabilities. |
| * <P>Type: TEXT</P> |
| */ |
| public static final String CONTACT_URI = "contact_uri"; |
| |
| /** |
| * The service version of service capabilities. |
| * <P>Type: TEXT</P> |
| */ |
| public static final String SERVICE_VERSION = "service_version"; |
| |
| /** |
| * The description of service capabilities. |
| * <P>Type: TEXT</P> |
| */ |
| public static final String DESCRIPTION = "description"; |
| |
| /** |
| * The supported duplex mode of service capabilities. Possible values are |
| * {@link android.telephony.ims.RcsContactPresenceTuple.ServiceCapabilities#DUPLEX_MODE_FULL} |
| * and |
| * {@link android.telephony.ims.RcsContactPresenceTuple.ServiceCapabilities#DUPLEX_MODE_HALF} |
| * and |
| * {@link android.telephony.ims.RcsContactPresenceTuple.ServiceCapabilities#DUPLEX_MODE_RECEIVE_ONLY} |
| * and |
| * {@link android.telephony.ims.RcsContactPresenceTuple.ServiceCapabilities#DUPLEX_MODE_SEND_ONLY} |
| * <P>Type: TEXT</P> |
| */ |
| public static final String DUPLEX_MODE = "duplex_mode"; |
| |
| /** |
| * The unsupported duplex mode of service capabilities. Possible values are |
| * {@link android.telephony.ims.RcsContactPresenceTuple.ServiceCapabilities#DUPLEX_MODE_FULL} |
| * and |
| * {@link android.telephony.ims.RcsContactPresenceTuple.ServiceCapabilities#DUPLEX_MODE_HALF} |
| * and |
| * {@link android.telephony.ims.RcsContactPresenceTuple.ServiceCapabilities#DUPLEX_MODE_RECEIVE_ONLY} |
| * and |
| * {@link android.telephony.ims.RcsContactPresenceTuple.ServiceCapabilities#DUPLEX_MODE_SEND_ONLY} |
| * <P>Type: TEXT</P> |
| */ |
| public static final String UNSUPPORTED_DUPLEX_MODE = "unsupported_duplex_mode"; |
| |
| /** |
| * The presence request timestamp. |
| * <P>Type: LONG</P> |
| */ |
| public static final String REQUEST_TIMESTAMP = "presence_request_timestamp"; |
| |
| /** |
| * The audio capable. |
| * <P>Type: BOOLEAN </P> |
| */ |
| public static final String AUDIO_CAPABLE = "audio_capable"; |
| |
| /** |
| * The video capable. |
| * <P>Type: BOOLEAN </P> |
| */ |
| public static final String VIDEO_CAPABLE = "video_capable"; |
| } |
| |
| /** |
| * This is used to generate a instance of {@link android.telephony.ims.RcsContactPresenceTuple}. |
| * See that class for more information on each of these parameters. |
| */ |
| public static class OptionsColumns implements BaseColumns { |
| |
| /** |
| * A reference to the {@link ContactColumns#_ID} that this data belongs to. |
| * <P>Type: INTEGER</P> |
| */ |
| public static final String EAB_COMMON_ID = "eab_common_id"; |
| |
| /** |
| * An IMS feature tag indicating the capabilities of the contact. See RFC3840 #section-9. |
| * <P>Type: TEXT</P> |
| */ |
| public static final String FEATURE_TAG = "feature_tag"; |
| |
| /** |
| * The request timestamp of options capabilities. |
| * <P>Type: LONG</P> |
| */ |
| public static final String REQUEST_TIMESTAMP = "options_request_timestamp"; |
| } |
| |
| @VisibleForTesting |
| public static final class EabDatabaseHelper extends SQLiteOpenHelper { |
| private static final String DB_NAME = "EabDatabase"; |
| private static final List<String> CONTACT_UNIQUE_FIELDS = new ArrayList<>(); |
| private static final List<String> COMMON_UNIQUE_FIELDS = new ArrayList<>(); |
| |
| static { |
| CONTACT_UNIQUE_FIELDS.add(ContactColumns.PHONE_NUMBER); |
| |
| COMMON_UNIQUE_FIELDS.add(EabCommonColumns.EAB_CONTACT_ID); |
| } |
| |
| @VisibleForTesting |
| public static final String SQL_CREATE_CONTACT_TABLE = "CREATE TABLE " |
| + EAB_CONTACT_TABLE_NAME |
| + " (" |
| + ContactColumns._ID + " INTEGER PRIMARY KEY, " |
| + ContactColumns.PHONE_NUMBER + " Text DEFAULT NULL, " |
| + ContactColumns.CONTACT_ID + " INTEGER DEFAULT -1, " |
| + ContactColumns.RAW_CONTACT_ID + " INTEGER DEFAULT -1, " |
| + ContactColumns.DATA_ID + " INTEGER DEFAULT -1, " |
| + "UNIQUE (" + TextUtils.join(", ", CONTACT_UNIQUE_FIELDS) + ")" |
| + ");"; |
| |
| @VisibleForTesting |
| public static final String SQL_CREATE_COMMON_TABLE = "CREATE TABLE " |
| + EAB_COMMON_TABLE_NAME |
| + " (" |
| + EabCommonColumns._ID + " INTEGER PRIMARY KEY, " |
| + EabCommonColumns.EAB_CONTACT_ID + " INTEGER DEFAULT -1, " |
| + EabCommonColumns.MECHANISM + " INTEGER DEFAULT NULL, " |
| + EabCommonColumns.REQUEST_RESULT + " INTEGER DEFAULT -1, " |
| + EabCommonColumns.SUBSCRIPTION_ID + " INTEGER DEFAULT -1, " |
| + "UNIQUE (" + TextUtils.join(", ", COMMON_UNIQUE_FIELDS) + ")" |
| + ");"; |
| |
| @VisibleForTesting |
| public static final String SQL_CREATE_PRESENCE_TUPLE_TABLE = "CREATE TABLE " |
| + EAB_PRESENCE_TUPLE_TABLE_NAME |
| + " (" |
| + PresenceTupleColumns._ID + " INTEGER PRIMARY KEY, " |
| + PresenceTupleColumns.EAB_COMMON_ID + " INTEGER DEFAULT -1, " |
| + PresenceTupleColumns.BASIC_STATUS + " TEXT DEFAULT NULL, " |
| + PresenceTupleColumns.SERVICE_ID + " TEXT DEFAULT NULL, " |
| + PresenceTupleColumns.SERVICE_VERSION + " TEXT DEFAULT NULL, " |
| + PresenceTupleColumns.DESCRIPTION + " TEXT DEFAULT NULL, " |
| + PresenceTupleColumns.REQUEST_TIMESTAMP + " LONG DEFAULT NULL, " |
| + PresenceTupleColumns.CONTACT_URI + " TEXT DEFAULT NULL, " |
| |
| // For ServiceCapabilities |
| + PresenceTupleColumns.DUPLEX_MODE + " TEXT DEFAULT NULL, " |
| + PresenceTupleColumns.UNSUPPORTED_DUPLEX_MODE + " TEXT DEFAULT NULL, " |
| + PresenceTupleColumns.AUDIO_CAPABLE + " BOOLEAN DEFAULT NULL, " |
| + PresenceTupleColumns.VIDEO_CAPABLE + " BOOLEAN DEFAULT NULL" |
| + ");"; |
| |
| @VisibleForTesting |
| public static final String SQL_CREATE_OPTIONS_TABLE = "CREATE TABLE " |
| + EAB_OPTIONS_TABLE_NAME |
| + " (" |
| + OptionsColumns._ID + " INTEGER PRIMARY KEY, " |
| + OptionsColumns.EAB_COMMON_ID + " INTEGER DEFAULT -1, " |
| + OptionsColumns.REQUEST_TIMESTAMP + " LONG DEFAULT NULL, " |
| + OptionsColumns.FEATURE_TAG + " TEXT DEFAULT NULL " |
| + ");"; |
| |
| EabDatabaseHelper(Context context) { |
| super(context, DB_NAME, null, DATABASE_VERSION); |
| } |
| |
| public void onCreate(SQLiteDatabase db) { |
| db.execSQL(SQL_CREATE_CONTACT_TABLE); |
| db.execSQL(SQL_CREATE_COMMON_TABLE); |
| db.execSQL(SQL_CREATE_PRESENCE_TUPLE_TABLE); |
| db.execSQL(SQL_CREATE_OPTIONS_TABLE); |
| } |
| |
| @Override |
| public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldVersion, int newVersion) { |
| Log.d(TAG, "DB upgrade from " + oldVersion + " to " + newVersion); |
| |
| if (oldVersion < 2) { |
| sqLiteDatabase.execSQL("ALTER TABLE " + EAB_CONTACT_TABLE_NAME + " ADD COLUMN " |
| + ContactColumns.CONTACT_ID + " INTEGER DEFAULT -1;"); |
| oldVersion = 2; |
| } |
| } |
| } |
| |
| private EabDatabaseHelper mOpenHelper; |
| |
| @Override |
| public boolean onCreate() { |
| mOpenHelper = new EabDatabaseHelper(getContext()); |
| return true; |
| } |
| |
| /** |
| * Support 6 URLs for querying: |
| * |
| * <ul> |
| * <li>{@link #URL_CONTACT}: query contact table. |
| * |
| * <li>{@link #URL_COMMON}: query common table. |
| * |
| * <li>{@link #URL_PRESENCE}: query presence capability table. |
| * |
| * <li>{@link #URL_OPTIONS}: query options capability table. |
| * |
| * <li>{@link #URL_ALL_WITH_SUB_ID_AND_PHONE_NUMBER}: To provide more efficient query way, |
| * filter by the {@link ContactColumns#PHONE_NUMBER} first and join with others tables. The |
| * format is like content://eab/all/[sub_id]/[phone_number] |
| * |
| * <li> {@link #URL_ALL}: Join all of tables at once |
| * </ul> |
| */ |
| @Override |
| public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, |
| String sortOrder) { |
| SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); |
| SQLiteDatabase db = getReadableDatabase(); |
| int match = URI_MATCHER.match(uri); |
| int subId; |
| String subIdString; |
| |
| Log.d(TAG, "Query URI: " + match); |
| |
| switch (match) { |
| case URL_CONTACT: |
| qb.setTables(EAB_CONTACT_TABLE_NAME); |
| break; |
| |
| case URL_COMMON: |
| qb.setTables(EAB_COMMON_TABLE_NAME); |
| break; |
| |
| case URL_PRESENCE: |
| qb.setTables(EAB_PRESENCE_TUPLE_TABLE_NAME); |
| break; |
| |
| case URL_OPTIONS: |
| qb.setTables(EAB_OPTIONS_TABLE_NAME); |
| break; |
| |
| case URL_ALL_WITH_SUB_ID_AND_PHONE_NUMBER: |
| List<String> pathSegment = uri.getPathSegments(); |
| |
| subIdString = pathSegment.get(1); |
| try { |
| subId = Integer.parseInt(subIdString); |
| } catch (NumberFormatException e) { |
| Log.e(TAG, "NumberFormatException" + e); |
| return null; |
| } |
| qb.appendWhereStandalone(EabCommonColumns.SUBSCRIPTION_ID + "=" + subId); |
| |
| String phoneNumber = pathSegment.get(2); |
| String whereClause; |
| if (TextUtils.isEmpty(phoneNumber)) { |
| Log.e(TAG, "phone number is null"); |
| return null; |
| } |
| whereClause = " where " + ContactColumns.PHONE_NUMBER + "='" + phoneNumber + "' "; |
| qb.setTables( |
| "((" + QUERY_CONTACT_TABLE + whereClause + ") AS " + EAB_CONTACT_TABLE_NAME |
| + JOIN_ALL_TABLES + ")"); |
| break; |
| |
| case URL_ALL: |
| qb.setTables("(" + QUERY_CONTACT_TABLE + JOIN_ALL_TABLES + ")"); |
| break; |
| |
| default: |
| Log.d(TAG, "Query failed. Not support URL."); |
| return null; |
| } |
| return qb.query(db, projection, selection, selectionArgs, null, null, sortOrder); |
| } |
| |
| @Override |
| public Uri insert(Uri uri, ContentValues contentValues) { |
| SQLiteDatabase db = getWritableDatabase(); |
| int match = URI_MATCHER.match(uri); |
| long result = 0; |
| String tableName = ""; |
| switch (match) { |
| case URL_CONTACT: |
| tableName = EAB_CONTACT_TABLE_NAME; |
| break; |
| case URL_COMMON: |
| tableName = EAB_COMMON_TABLE_NAME; |
| break; |
| case URL_PRESENCE: |
| tableName = EAB_PRESENCE_TUPLE_TABLE_NAME; |
| break; |
| case URL_OPTIONS: |
| tableName = EAB_OPTIONS_TABLE_NAME; |
| break; |
| } |
| if (!TextUtils.isEmpty(tableName)) { |
| result = db.insertWithOnConflict(tableName, null, contentValues, |
| SQLiteDatabase.CONFLICT_REPLACE); |
| Log.d(TAG, "Insert uri: " + match + " ID: " + result); |
| if (result > 0) { |
| getContext().getContentResolver().notifyChange(uri, null, NOTIFY_INSERT); |
| } |
| } else { |
| Log.d(TAG, "Insert. Not support URI."); |
| } |
| |
| return Uri.withAppendedPath(uri, String.valueOf(result)); |
| } |
| |
| @Override |
| public int bulkInsert(Uri uri, ContentValues[] values) { |
| SQLiteDatabase db = getWritableDatabase(); |
| int match = URI_MATCHER.match(uri); |
| int result = 0; |
| String tableName = ""; |
| switch (match) { |
| case URL_CONTACT: |
| tableName = EAB_CONTACT_TABLE_NAME; |
| break; |
| case URL_COMMON: |
| tableName = EAB_COMMON_TABLE_NAME; |
| break; |
| case URL_PRESENCE: |
| tableName = EAB_PRESENCE_TUPLE_TABLE_NAME; |
| break; |
| case URL_OPTIONS: |
| tableName = EAB_OPTIONS_TABLE_NAME; |
| break; |
| } |
| |
| if (TextUtils.isEmpty(tableName)) { |
| Log.d(TAG, "bulkInsert. Not support URI."); |
| return 0; |
| } |
| |
| try { |
| // Batch all insertions in a single transaction to improve efficiency. |
| db.beginTransaction(); |
| for (ContentValues contentValue : values) { |
| if (contentValue != null) { |
| db.insertWithOnConflict(tableName, null, contentValue, |
| SQLiteDatabase.CONFLICT_REPLACE); |
| result++; |
| } |
| } |
| db.setTransactionSuccessful(); |
| } finally { |
| db.endTransaction(); |
| } |
| if (result > 0) { |
| getContext().getContentResolver().notifyChange(uri, null, NOTIFY_INSERT); |
| } |
| Log.d(TAG, "bulkInsert uri: " + match + " count: " + result); |
| return result; |
| } |
| |
| @Override |
| public int delete(Uri uri, String selection, String[] selectionArgs) { |
| SQLiteDatabase db = getWritableDatabase(); |
| int match = URI_MATCHER.match(uri); |
| int result = 0; |
| String tableName = ""; |
| switch (match) { |
| case URL_CONTACT: |
| tableName = EAB_CONTACT_TABLE_NAME; |
| break; |
| case URL_COMMON: |
| tableName = EAB_COMMON_TABLE_NAME; |
| break; |
| case URL_PRESENCE: |
| tableName = EAB_PRESENCE_TUPLE_TABLE_NAME; |
| break; |
| case URL_OPTIONS: |
| tableName = EAB_OPTIONS_TABLE_NAME; |
| break; |
| } |
| if (!TextUtils.isEmpty(tableName)) { |
| result = db.delete(tableName, selection, selectionArgs); |
| if (result > 0) { |
| getContext().getContentResolver().notifyChange(uri, null, NOTIFY_DELETE); |
| } |
| Log.d(TAG, "Delete uri: " + match + " result: " + result); |
| } else { |
| Log.d(TAG, "Delete. Not support URI."); |
| } |
| return result; |
| } |
| |
| @Override |
| public int update(Uri uri, ContentValues contentValues, String selection, |
| String[] selectionArgs) { |
| SQLiteDatabase db = getWritableDatabase(); |
| int match = URI_MATCHER.match(uri); |
| int result = 0; |
| String tableName = ""; |
| switch (match) { |
| case URL_CONTACT: |
| tableName = EAB_CONTACT_TABLE_NAME; |
| break; |
| case URL_COMMON: |
| tableName = EAB_COMMON_TABLE_NAME; |
| break; |
| case URL_PRESENCE: |
| tableName = EAB_PRESENCE_TUPLE_TABLE_NAME; |
| break; |
| case URL_OPTIONS: |
| tableName = EAB_OPTIONS_TABLE_NAME; |
| break; |
| } |
| if (!TextUtils.isEmpty(tableName)) { |
| result = db.updateWithOnConflict(tableName, contentValues, |
| selection, selectionArgs, SQLiteDatabase.CONFLICT_REPLACE); |
| if (result > 0) { |
| getContext().getContentResolver().notifyChange(uri, null, NOTIFY_UPDATE); |
| } |
| Log.d(TAG, "Update uri: " + match + " result: " + result); |
| } else { |
| Log.d(TAG, "Update. Not support URI."); |
| } |
| return result; |
| } |
| |
| @Override |
| public String getType(Uri uri) { |
| return null; |
| } |
| |
| @VisibleForTesting |
| public SQLiteDatabase getWritableDatabase() { |
| return mOpenHelper.getWritableDatabase(); |
| } |
| |
| @VisibleForTesting |
| public SQLiteDatabase getReadableDatabase() { |
| return mOpenHelper.getReadableDatabase(); |
| } |
| } |
