/packages/providers/ContactsProvider/src/com/android/providers/contacts/ |
H A D | ContactsDatabaseHelper.java | 111 public interface Tables { interface in class:ContactsDatabaseHelper 189 Tables.CONTACTS 190 + " INNER JOIN " + Tables.RAW_CONTACTS 194 + " INNER JOIN " + Tables.DATA 201 + " FROM " + Tables.MIMETYPES 294 " FROM " + Tables.RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS + 296 " FROM " + Tables.RAW_CONTACTS + " AS " + OUTER_RAW_CONTACTS + 309 "EXISTS (SELECT _id FROM " + Tables.VISIBLE_CONTACTS 310 + " WHERE " + Tables.CONTACTS +"." + Contacts._ID 311 + "=" + Tables [all...] |
H A D | ProfileAggregator.java | 22 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 73 " FROM " + Tables.CONTACTS +
|
H A D | DataRowHandlerForGroupMembership.java | 22 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 44 String TABLE = Tables.RAW_CONTACTS; 62 "SELECT COUNT(*) FROM " + Tables.DATA + " LEFT OUTER JOIN " + Tables .GROUPS 63 + " ON " + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID 66 + " AND " + Tables.DATA + "." + GroupMembership.RAW_CONTACT_ID + "=?" 110 if (db.update(Tables.RAW_CONTACTS, rawContactValues, SELECTION_RAW_CONTACT_ID, 244 c = db.query(Tables.GROUPS, new String[]{RawContacts._ID}, 252 c = db.query(Tables.GROUPS, new String[]{RawContacts._ID}, 270 long groupId = db.insert(Tables [all...] |
H A D | SocialProvider.java | 22 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 94 columns.put(RawContacts._ID, Tables.RAW_CONTACTS + "." + RawContacts._ID + " AS _id"); 171 * Inserts an item into the {@link Tables#ACTIVITIES} table. 209 id = db.insert(Tables.ACTIVITIES, Activities.RAW_ID, values); 231 final Cursor c = db.query(Tables.ACTIVITIES, 265 int replies = db.update(Tables.ACTIVITIES, values, 277 final Cursor c = db.query(Tables.ACTIVITIES, 302 return db.delete(Tables.ACTIVITIES, Activities._ID + "=" + activityId, null); 307 return db.delete(Tables.ACTIVITIES, Activities.AUTHOR_CONTACT_ID + "=" + contactId, null); 332 qb.setTables(Tables [all...] |
H A D | ContactAggregator.java | 29 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 86 "UPDATE " + Tables.CONTACTS + 89 " FROM " + Tables.STATUS_UPDATES + 90 " JOIN " + Tables.DATA + 93 " JOIN " + Tables.RAW_CONTACTS + 263 "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "(" 270 + " FROM " + Tables.PRESENCE 277 + " FROM " + Tables.PRESENCE 286 " FROM " + Tables.RAW_CONTACTS + 291 "DELETE FROM " + Tables [all...] |
H A D | CommonNicknameCache.java | 20 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 48 public final static String TABLE = Tables.NICKNAME_LOOKUP; 123 String TABLE = Tables.NICKNAME_LOOKUP;
|
H A D | LegacyApiSupport.java | 28 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 143 " LEFT OUTER JOIN " + Tables.PRESENCE + 144 " ON (" + Tables.PRESENCE + "." + StatusUpdates.DATA_ID + "=" + 146 " FROM " + Tables.PRESENCE + 178 + " THEN (CASE WHEN " + Tables.DATA + "." + Im.PROTOCOL + "=" + Im.PROTOCOL_CUSTOM 179 + " THEN 'custom:'||" + Tables.DATA + "." + Im.CUSTOM_PROTOCOL 180 + " ELSE 'pre:'||" + Tables.DATA + "." + Im.PROTOCOL 182 + " ELSE " + Tables.DATA + "." + Email.DATA 195 "UPDATE " + Tables.CONTACTS + 199 "UPDATE " + Tables [all...] |
H A D | CallLogProvider.java | 23 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 127 qb.setTables(Tables.CALLS); 192 mCallsInserter = new DatabaseUtils.InsertHelper(db, Tables.CALLS); 233 return getDatabaseModifier(db).update(Tables.CALLS, values, selectionBuilder.build(), 246 return getDatabaseModifier(db).delete(Tables.CALLS, 264 return new DbModifierWithNotification(Tables.CALLS, db, context()); 272 return new DbModifierWithNotification(Tables.CALLS, insertHelper, context());
|
H A D | DataRowHandlerForOrganization.java | 18 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 73 " FROM " + Tables.DATA + 84 " FROM " + Tables.DATA +
|
H A D | DataRowHandler.java | 21 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 41 public static final String TABLE = Tables.DATA_JOIN_MIMETYPES; 110 final long dataId = db.insert(Tables.DATA, null, values); 157 db.update(Tables.DATA, values, Data._ID + " =?", mSelectionArgs1); 206 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA, 254 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1); 256 db.delete(Tables.PRESENCE, PresenceColumns.RAW_CONTACT_ID + "=?", mSelectionArgs1); 325 final Cursor cursor = db.query(Tables.DATA, null, Data._ID + "=?",
|
H A D | DataRowHandlerForPhoneNumber.java | 20 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 115 db.delete(Tables.PHONE_LOOKUP, PhoneLookupColumns.DATA_ID + "=?", mSelectionArgs1); 125 db.insert(Tables.PHONE_LOOKUP, null, phoneValues); 131 db.insert(Tables.PHONE_LOOKUP, null, phoneValues);
|
H A D | PhotoStore.java | 19 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 94 mDb.delete(Tables.PHOTO_FILES, null, null); 205 long id = mDb.insert(Tables.PHOTO_FILES, null, values); 274 mDb.delete(ContactsDatabaseHelper.Tables.PHOTO_FILES, PhotoFilesColumns.CONCRETE_ID + "=?",
|
H A D | ProfileDatabaseHelper.java | 66 for (String table : Tables.SEQUENCE_TABLES) {
|
H A D | ContactsProvider2.java | 43 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 242 "UPDATE " + Tables.CONTACTS + " SET " + Contacts.TIMES_CONTACTED + "=" + 247 "UPDATE " + Tables.RAW_CONTACTS + " SET " + RawContacts.TIMES_CONTACTED + "=" + 418 = new String[]{Tables.GROUPS + "." + Groups._ID}; 426 + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?"; 451 String TABLE = Tables.RAW_CONTACTS; 472 + " FROM " + Tables.RAW_CONTACTS 475 + " FROM " + Tables.DATA_JOIN_MIMETYPES 478 + "(SELECT " + Tables.GROUPS + "." + Groups._ID 479 + " FROM " + Tables [all...] |
H A D | LegacyContactImporter.java | 23 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 255 String INSERT_SQL = "INSERT INTO " + Tables.GROUPS + "(" + 391 String INSERT_SQL = "INSERT INTO " + Tables.RAW_CONTACTS + "(" + 425 String INSERT_SQL = "INSERT INTO " + Tables.CONTACTS + "(" + 445 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" + 477 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" + 690 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" + 756 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" + 778 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" + 800 String INSERT_SQL = "INSERT INTO " + Tables [all...] |
H A D | ContactDirectoryManager.java | 20 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 137 Cursor cursor = db.query(Tables.DIRECTORIES, 288 int deletedRows = db.delete(Tables.DIRECTORIES, deleteWhereBuilder.toString(), 306 db.replace(Tables.DIRECTORIES, null, values); 320 db.replace(Tables.DIRECTORIES, null, values); 379 db.delete(Tables.DIRECTORIES, sb.toString(), new String[] { packageInfo.packageName }); 490 Cursor cursor = db.query(Tables.DIRECTORIES, new String[] { Directory._ID }, 500 db.update(Tables.DIRECTORIES, values, Directory._ID + "=?", 503 id = db.insert(Tables.DIRECTORIES, null, values);
|
H A D | SearchIndexManager.java | 21 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 300 Cursor cursor = db.query(Tables.DATA_JOIN_MIMETYPE_RAW_CONTACTS, ContactIndexQuery.COLUMNS, 341 int count = db.update(Tables.SEARCH_INDEX, mValues, 345 db.insert(Tables.SEARCH_INDEX, null, mValues); 349 db.insert(Tables.SEARCH_INDEX, null, mValues);
|
H A D | DbModifierWithNotification.java | 24 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 91 mBaseUri = mTableName.equals(Tables.VOICEMAIL_STATUS) ? 93 mIsCallsTable = mTableName.equals(Tables.CALLS);
|
H A D | VoicemailContentProvider.java | 22 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 65 mVoicemailContentTable = new VoicemailContentTable(Tables.CALLS, context, 67 mVoicemailStatusTable = new VoicemailStatusTable(Tables.VOICEMAIL_STATUS, context,
|
H A D | GlobalSearchSupport.java | 39 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 79 " FROM " + Tables.AGGREGATED_PRESENCE +
|
/packages/providers/CalendarProvider/src/com/android/providers/calendar/ |
H A D | CalendarDatabaseHelper.java | 123 public interface Tables { interface in class:CalendarDatabaseHelper 148 "DELETE FROM " + Tables.INSTANCES + 151 "DELETE FROM " + Tables.EVENTS_RAW_TIMES + 154 "DELETE FROM " + Tables.ATTENDEES + 157 "DELETE FROM " + Tables.REMINDERS + 160 "DELETE FROM " + Tables.CALENDAR_ALERTS + 163 "DELETE FROM " + Tables.EXTENDED_PROPERTIES + 170 "UPDATE " + Tables.EVENTS + 177 " ON " + Tables.EVENTS + 182 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; 68 + Tables.CALENDAR_ALERTS + " AS ca" 69 + " LEFT OUTER JOIN " + Tables.INSTANCES 72 + " LEFT OUTER JOIN " + Tables.REMINDERS + " AS r ON" 77 + " WHERE " + Tables.INSTANCES + "." + Instances.BEGIN + " ISNULL" 317 + " AS myAlarmTime" + "," + Tables.INSTANCES + "." + Instances.EVENT_ID 320 + Reminders.MINUTES + " FROM " + Tables.INSTANCES + " INNER JOIN " + Views.EVENTS 321 + " ON (" + Views.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "." 322 + Instances.EVENT_ID + ")" + " INNER JOIN " + Tables.REMINDERS + " ON (" 323 + Tables [all...] |
H A D | CalendarProvider2.java | 24 import com.android.providers.calendar.CalendarDatabaseHelper.Tables; 187 Tables.EVENTS_RAW_TIMES + ", " + 188 Tables.EVENTS + 190 CalendarContract.EventsRawTimes.EVENT_ID + " = " + Tables.EVENTS + "." + Events._ID; 193 Tables.EVENTS + 210 Tables.EVENTS + "." + Events._ID + "=" + Tables.ATTENDEES + "." + Attendees.EVENT_ID 212 Tables.EVENTS + "." + Events.CALENDAR_ID + "=" + Tables.CALENDARS + "." + Calendars._ID; 215 Tables [all...] |
H A D | CalendarInstancesHelper.java | 23 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/providers/ContactsProvider/tests/src/com/android/providers/contacts/ |
H A D | PhotoStoreTest.java | 19 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 115 Cursor c = mDb.query(Tables.PHOTO_FILES, 143 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID}, 189 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID},
|