1 /* 2 * Copyright (C) 2017 The Android Open Source Project 3 * 4 * Licensed under the Apache License, Version 2.0 (the "License"); 5 * you may not use this file except in compliance with the License. 6 * You may obtain a copy of the License at 7 * 8 * http://www.apache.org/licenses/LICENSE-2.0 9 * 10 * Unless required by applicable law or agreed to in writing, software 11 * distributed under the License is distributed on an "AS IS" BASIS, 12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 13 * See the License for the specific language governing permissions and 14 * limitations under the License 15 */ 16 17 package com.android.dialer.phonelookup.database; 18 19 import android.content.Context; 20 import android.database.sqlite.SQLiteDatabase; 21 import android.database.sqlite.SQLiteOpenHelper; 22 import android.os.SystemClock; 23 import com.android.dialer.common.LogUtil; 24 import com.android.dialer.phonelookup.database.contract.PhoneLookupHistoryContract.PhoneLookupHistory; 25 26 /** {@link SQLiteOpenHelper} for the PhoneLookupHistory database. */ 27 class PhoneLookupHistoryDatabaseHelper extends SQLiteOpenHelper { 28 PhoneLookupHistoryDatabaseHelper(Context appContext)29 PhoneLookupHistoryDatabaseHelper(Context appContext) { 30 super(appContext, "phone_lookup_history.db", null, 1); 31 } 32 33 // TODO(zachh): LAST_MODIFIED is no longer read and can be deleted. 34 private static final String CREATE_TABLE_SQL = 35 "create table if not exists " 36 + PhoneLookupHistory.TABLE 37 + " (" 38 + (PhoneLookupHistory.NORMALIZED_NUMBER + " text primary key not null, ") 39 + (PhoneLookupHistory.PHONE_LOOKUP_INFO + " blob not null, ") 40 + (PhoneLookupHistory.LAST_MODIFIED + " long not null") 41 + ");"; 42 43 private static final String CREATE_INDEX_ON_LAST_MODIFIED_SQL = 44 "create index last_modified_index on " 45 + PhoneLookupHistory.TABLE 46 + " (" 47 + PhoneLookupHistory.LAST_MODIFIED 48 + ");"; 49 50 @Override onCreate(SQLiteDatabase db)51 public void onCreate(SQLiteDatabase db) { 52 LogUtil.enterBlock("PhoneLookupHistoryDatabaseHelper.onCreate"); 53 long startTime = SystemClock.uptimeMillis(); 54 db.execSQL(CREATE_TABLE_SQL); 55 db.execSQL(CREATE_INDEX_ON_LAST_MODIFIED_SQL); 56 // TODO(zachh): Consider logging impression. 57 LogUtil.i( 58 "PhoneLookupHistoryDatabaseHelper.onCreate", 59 "took: %dms", 60 SystemClock.uptimeMillis() - startTime); 61 } 62 63 @Override onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)64 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {} 65 } 66