/packages/providers/ContactsProvider/src/com/android/providers/contacts/ |
H A D | ContactsDatabaseHelper.java | 149 public interface Tables { interface in class:ContactsDatabaseHelper 205 + " JOIN " + Tables.ACCOUNTS + " ON (" 211 public static final String RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS = Tables.RAW_CONTACTS 212 + " JOIN " + Tables.ACCOUNTS + " ON (" 215 + "LEFT OUTER JOIN " + Tables.SETTINGS + " ON (" 235 + " FROM " + Tables.ACCOUNTS 246 Tables.CONTACTS 247 + " INNER JOIN " + Tables.RAW_CONTACTS 251 + " INNER JOIN " + Tables.DATA 258 + " FROM " + Tables [all...] |
H A D | DataRowHandlerForGroupMembership.java | 32 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 45 String TABLE = Tables.RAW_CONTACTS; 59 "SELECT COUNT(*) FROM " + Tables.DATA + " LEFT OUTER JOIN " + Tables .GROUPS 60 + " ON " + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID 63 + " AND " + Tables.DATA + "." + GroupMembership.RAW_CONTACT_ID + "=?" 107 if (db.update(Tables.RAW_CONTACTS, rawContactValues, SELECTION_RAW_CONTACT_ID, 231 Cursor c = db.query(Tables.GROUPS, Projections.ID, 242 long groupId = db.insert(Tables.GROUPS, null, groupValues);
|
H A D | CallLogDatabaseHelper.java | 61 public interface Tables { interface in class:CallLogDatabaseHelper 119 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + 168 db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" + 252 db.execSQL("ALTER TABLE " + Tables.CALLS + " ADD " + Calls.VIA_NUMBER + 260 db.execSQL("ALTER TABLE " + Tables.VOICEMAIL_STATUS + " ADD " + Status.SOURCE_TYPE + 323 calllog.insertOrThrow(Tables.CALLS, null, cv); 334 calllog.insertOrThrow(Tables.VOICEMAIL_STATUS, null, cv); 406 getWritableDatabase().execSQL("DELETE FROM " + Tables.CALLS);
|
H A D | DataRowHandler.java | 33 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 45 public static final String TABLE = Tables.DATA_JOIN_MIMETYPES; 117 final long dataId = db.insert(Tables.DATA, null, values); 168 db.update(Tables.DATA, values, Data._ID + " =?", mSelectionArgs1); 229 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA, 275 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA, 323 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1); 325 db.delete(Tables.PRESENCE, PresenceColumns.RAW_CONTACT_ID + "=?", mSelectionArgs1); 395 final Cursor cursor = db.query(Tables.DATA, null, Data._ID + "=?",
|
H A D | LegacyApiSupport.java | 67 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 118 " JOIN " + Tables.ACCOUNTS + " ON (" 142 " LEFT OUTER JOIN " + Tables.PRESENCE + 143 " ON (" + Tables.PRESENCE + "." + StatusUpdates.DATA_ID + "=" + 145 " FROM " + Tables.PRESENCE + 177 + " THEN (CASE WHEN " + Tables.DATA + "." + Im.PROTOCOL + "=" + Im.PROTOCOL_CUSTOM 178 + " THEN 'custom:'||" + Tables.DATA + "." + Im.CUSTOM_PROTOCOL 179 + " ELSE 'pre:'||" + Tables.DATA + "." + Im.PROTOCOL 181 + " ELSE " + Tables.DATA + "." + Email.DATA 364 " FROM " + Tables [all...] |
/packages/providers/ContactsProvider/src/com/android/providers/contacts/database/ |
H A D | ContactsTableUtil.java | 20 import static com.android.providers.contacts.ContactsDatabaseHelper.Tables; 44 final String table = Tables.CONTACTS; 62 db.update(Tables.CONTACTS, values, Contacts._ID + " = ?", 93 final String sql = "UPDATE " + Tables.CONTACTS 98 + " FROM " + Tables.RAW_CONTACTS 114 return db.delete(Tables.CONTACTS, Contacts._ID + " = ?", new String[]{contactId + ""}); 125 + " from " + Tables.RAW_CONTACTS 128 + " from " + Tables.RAW_CONTACTS
|
H A D | DeletedContactsTableUtil.java | 38 db.execSQL("CREATE TABLE " + ContactsDatabaseHelper.Tables.DELETED_CONTACTS + " (" + 45 ContactsDatabaseHelper.Tables.DELETED_CONTACTS, 62 return db.insertWithOnConflict(ContactsDatabaseHelper.Tables.DELETED_CONTACTS, null, values, 78 return db.delete(ContactsDatabaseHelper.Tables.DELETED_CONTACTS,
|
/packages/providers/ContactsProvider/src/com/android/providers/contacts/util/ |
H A D | PropertyUtils.java | 30 public interface Tables { interface in class:PropertyUtils 43 db.execSQL("CREATE TABLE " + Tables.PROPERTIES + " (" + 54 final Cursor cursor = db.query(Tables.PROPERTIES, 77 db.replace(Tables.PROPERTIES, null, values);
|
/packages/providers/BlockedNumberProvider/src/com/android/providers/blockednumber/ |
H A D | BlockedNumberDatabaseHelper.java | 39 public interface Tables { interface in class:BlockedNumberDatabaseHelper 65 db.execSQL("CREATE TABLE " + Tables.BLOCKED_NUMBERS + " (" + 71 db.execSQL("CREATE INDEX blocked_number_idx_original ON " + Tables.BLOCKED_NUMBERS + 73 db.execSQL("CREATE INDEX blocked_number_idx_e164 ON " + Tables.BLOCKED_NUMBERS + " (" + 109 getWritableDatabase().execSQL("DELETE FROM " + Tables.BLOCKED_NUMBERS);
|
/packages/providers/CalendarProvider/src/com/android/providers/calendar/ |
H A D | CalendarDatabaseHelper.java | 141 public interface Tables { interface in class:CalendarDatabaseHelper 166 "DELETE FROM " + Tables.INSTANCES + 169 "DELETE FROM " + Tables.EVENTS_RAW_TIMES + 172 "DELETE FROM " + Tables.ATTENDEES + 175 "DELETE FROM " + Tables.REMINDERS + 178 "DELETE FROM " + Tables.CALENDAR_ALERTS + 181 "DELETE FROM " + Tables.EXTENDED_PROPERTIES + 188 "UPDATE " + Tables.EVENTS + 195 " ON " + Tables.EVENTS + 200 private static final String CALENDAR_CLEANUP_TRIGGER_SQL = "DELETE FROM " + Tables [all...] |
H A D | CalendarAlarmManager.java | 19 import com.android.providers.calendar.CalendarDatabaseHelper.Tables; 78 + Tables.CALENDAR_ALERTS + " AS ca" 79 + " LEFT OUTER JOIN " + Tables.INSTANCES 82 + " LEFT OUTER JOIN " + Tables.REMINDERS + " AS r ON" 87 + " WHERE " + Tables.INSTANCES + "." + Instances.BEGIN + " ISNULL" 336 + " AS myAlarmTime" + "," + Tables.INSTANCES + "." + Instances.EVENT_ID 339 + Reminders.MINUTES + " FROM " + Tables.INSTANCES + " INNER JOIN " + Views.EVENTS 340 + " ON (" + Views.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "." 341 + Instances.EVENT_ID + ")" + " INNER JOIN " + Tables.REMINDERS + " ON (" 342 + Tables [all...] |
H A D | CalendarProvider2.java | 66 import com.android.providers.calendar.CalendarDatabaseHelper.Tables; 190 Tables.EVENTS_RAW_TIMES + ", " + 191 Tables.EVENTS + 193 CalendarContract.EventsRawTimes.EVENT_ID + " = " + Tables.EVENTS + "." + Events._ID; 196 Tables.EVENTS + " SET " + 202 " FROM " + Tables.EVENTS + 209 + Tables.CALENDARS + " WHERE " + Events.ACCOUNT_NAME + "=? AND " + Events.ACCOUNT_TYPE 219 Tables.EVENTS + "." + Events._ID + "=" + Tables.ATTENDEES + "." + Attendees.EVENT_ID 221 Tables [all...] |
H A D | CalendarInstancesHelper.java | 24 import com.android.providers.calendar.CalendarDatabaseHelper.Tables; 81 "(SELECT " + Tables.INSTANCES + "." + Instances._ID + " as _id" + 82 " FROM " + Tables.INSTANCES + 83 " INNER JOIN " + Tables.EVENTS + 85 Tables.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "." + Instances.EVENT_ID + 87 " WHERE " + Tables.EVENTS + "." + Events._ID + "=? OR " + 88 Tables.EVENTS + "." + Events.ORIGINAL_ID + "=?)"; 97 "(SELECT " + Tables.INSTANCES + "." + Instances._ID + " as _id" + 98 " FROM " + Tables [all...] |
/packages/apps/Dialer/java/com/android/dialer/database/ |
H A D | DialerDatabaseHelper.java | 105 + Tables.SMARTDIAL_TABLE 141 + Tables.PREFIX_TABLE 153 + Tables.PROPERTIES 166 + Tables.FILTERED_NUMBER_TABLE 195 db.execSQL("DROP TABLE IF EXISTS " + Tables.PREFIX_TABLE); 196 db.execSQL("DROP TABLE IF EXISTS " + Tables.SMARTDIAL_TABLE); 197 db.execSQL("DROP TABLE IF EXISTS " + Tables.PROPERTIES); 198 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); 199 db.execSQL("DROP TABLE IF EXISTS " + Tables.VOICEMAIL_ARCHIVE_TABLE); 222 db.execSQL("DROP TABLE IF EXISTS " + Tables 933 public interface Tables { interface in class:DialerDatabaseHelper [all...] |
/packages/apps/Settings/src/com/android/settings/search/ |
H A D | IndexDatabaseHelper.java | 42 public interface Tables { interface in class:IndexDatabaseHelper 92 "CREATE VIRTUAL TABLE " + Tables.TABLE_PREFS_INDEX + " USING fts4" + 138 "CREATE TABLE " + Tables.TABLE_META_INDEX + 144 "CREATE TABLE " + Tables.TABLE_SAVED_QUERIES + 152 "CREATE VIRTUAL TABLE " + Tables.TABLE_SITE_MAP + " USING fts4" + 163 "INSERT INTO " + Tables.TABLE_META_INDEX + 167 "SELECT " + MetaColumns.BUILD + " FROM " + Tables.TABLE_META_INDEX + " LIMIT 1;"; 323 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); 324 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); 325 db.execSQL("DROP TABLE IF EXISTS " + Tables [all...] |
H A D | SavedQueryRemover.java | 20 import static com.android.settings.search.IndexDatabaseHelper.Tables.TABLE_SAVED_QUERIES;
|
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/ |
H A D | AbstractContactAggregator.java | 32 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 105 "UPDATE " + Tables.CONTACTS + 108 " FROM " + Tables.STATUS_UPDATES + 109 " JOIN " + Tables.DATA + 112 " JOIN " + Tables.RAW_CONTACTS + 289 "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "(" 296 + " FROM " + Tables.PRESENCE 303 + " FROM " + Tables.PRESENCE 312 " FROM " + Tables.RAW_CONTACTS + 317 "DELETE FROM " + Tables [all...] |
H A D | ContactAggregator2.java | 42 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 192 final String sql = "SELECT " + RawContacts._ID + " FROM " + Tables.RAW_CONTACTS + 250 Tables.DATA +" WHERE " + Data.IS_SUPER_PRIMARY + " = 1 AND " + 279 String superPrimaryUpdateSql = "UPDATE " + Tables.DATA + 294 " FROM " + Tables.AGGREGATION_EXCEPTIONS + 402 Tables.RAW_CONTACTS + " WHERE " + RawContacts.CONTACT_ID + "=? AND " + 707 + RawContacts.CONTACT_ID + " IN " + Tables.DEFAULT_DIRECTORY; 717 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS; 935 final String TABLE = Tables.DATA + " dataA" 936 + " JOIN " + Tables [all...] |
H A D | ProfileAggregator.java | 25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 81 " FROM " + Tables.CONTACTS +
|
H A D | ContactAggregator.java | 35 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 127 " FROM " + Tables.RAW_CONTACTS + 259 " FROM (SELECT " + DataColumns.MIMETYPE_ID + " FROM " + Tables.DATA + " WHERE " + 262 Tables.RAW_CONTACTS + " WHERE " + RawContacts.CONTACT_ID + "=?1)) AS a" + 263 " JOIN (SELECT " + DataColumns.MIMETYPE_ID + " FROM " + Tables.DATA + " WHERE " + 287 String superPrimaryUpdateSql = "UPDATE " + Tables.DATA + 290 " IN (SELECT " + RawContacts._ID + " FROM " + Tables.RAW_CONTACTS + 523 String TABLE = Tables.AGGREGATION_EXCEPTIONS 687 final String TABLE = Tables.DATA + " dataA" 688 + " JOIN " + Tables [all...] |
/packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/ |
H A D | ContactsDatabaseHelperTest.java | 37 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 115 mDbHelper.getWritableDatabase().execSQL("delete from " + Tables.ACCOUNTS); 139 " FROM " + Tables.MIMETYPES + 143 "INSERT INTO " + Tables.MIMETYPES + "(" 223 mDb.execSQL("DELETE FROM " + Tables.MIMETYPES + ";"); 281 final long rawContactId = mDb.insert(Tables.RAW_CONTACTS,null, rawContactValues); 296 assertTrue(mDb.insert(Tables.DATA, null, values) > 0); 299 final Cursor c = mDb.query(Tables.DATA, new String[]{ContactsContract.Data.HASH_ID}, 319 final long rawContactId = mDb.insert(Tables.RAW_CONTACTS,null, rawContactValues); 330 assertTrue(mDb.insert(Tables [all...] |
H A D | ContactsDatabaseHelperUpgradeTest.java | 66 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 578 new TableListEntry(PropertyUtils.Tables.PROPERTIES, PROPERTIES_COLUMNS), 579 new TableListEntry(Tables.ACCOUNTS, ACCOUNTS_COLUMNS), 580 new TableListEntry(Tables.CONTACTS, CONTACTS_COLUMNS), 581 new TableListEntry(Tables.DELETED_CONTACTS, DELETED_CONTACTS_COLUMNS), 582 new TableListEntry(Tables.RAW_CONTACTS, RAW_CONTACTS_COLUMNS), 583 new TableListEntry(Tables.STREAM_ITEMS, STREAM_ITEMS_COLUMNS), 584 new TableListEntry(Tables.STREAM_ITEM_PHOTOS, STREAM_ITEM_PHOTOS_COLUMNS), 585 new TableListEntry(Tables.PHOTO_FILES, PHOTO_FILES_COLUMNS), 586 new TableListEntry(Tables [all...] |
H A D | CallLogMigrationTest.java | 72 CallLogDatabaseHelper.Tables.CALLS, null)); 75 CallLogDatabaseHelper.Tables.VOICEMAIL_STATUS, null));
|
H A D | PhotoStoreTest.java | 27 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 142 Cursor c = mDb.query(Tables.PHOTO_FILES, 163 Cursor c = mDb.query(Tables.PHOTO_FILES, 187 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID}, 233 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID},
|
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/util/ |
H A D | CommonNicknameCache.java | 25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 49 public final static String TABLE = Tables.NICKNAME_LOOKUP; 127 String TABLE = Tables.NICKNAME_LOOKUP;
|