/packages/providers/ContactsProvider/src/com/android/providers/contacts/ |
H A D | ContactsDatabaseHelper.java | 124 public interface Tables { interface in class:ContactsDatabaseHelper 181 + " JOIN " + Tables.ACCOUNTS + " ON (" 187 public static final String RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS = Tables.RAW_CONTACTS 188 + " JOIN " + Tables.ACCOUNTS + " ON (" 191 + "LEFT OUTER JOIN " + Tables.SETTINGS + " ON (" 211 + " FROM " + Tables.ACCOUNTS 222 Tables.CONTACTS 223 + " INNER JOIN " + Tables.RAW_CONTACTS 227 + " INNER JOIN " + Tables.DATA 234 + " 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 | LegacyApiSupport.java | 66 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 122 " JOIN " + Tables.ACCOUNTS + " ON (" 146 " LEFT OUTER JOIN " + Tables.PRESENCE + 147 " ON (" + Tables.PRESENCE + "." + StatusUpdates.DATA_ID + "=" + 149 " FROM " + Tables.PRESENCE + 181 + " THEN (CASE WHEN " + Tables.DATA + "." + Im.PROTOCOL + "=" + Im.PROTOCOL_CUSTOM 182 + " THEN 'custom:'||" + Tables.DATA + "." + Im.CUSTOM_PROTOCOL 183 + " ELSE 'pre:'||" + Tables.DATA + "." + Im.PROTOCOL 185 + " ELSE " + Tables.DATA + "." + Email.DATA 198 "UPDATE " + Tables [all...] |
H A D | DataRowHandlerForOrganization.java | 26 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 74 " FROM " + Tables.DATA + 85 " FROM " + Tables.DATA +
|
H A D | DataRowHandler.java | 33 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 42 public static final String TABLE = Tables.DATA_JOIN_MIMETYPES; 111 final long dataId = db.insert(Tables.DATA, null, values); 158 db.update(Tables.DATA, values, Data._ID + " =?", mSelectionArgs1); 205 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA, 253 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1); 255 db.delete(Tables.PRESENCE, PresenceColumns.RAW_CONTACT_ID + "=?", mSelectionArgs1); 324 final Cursor cursor = db.query(Tables.DATA, null, Data._ID + "=?",
|
H A D | ContactsProvider2.java | 140 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 200 "UPDATE " + Tables.CONTACTS + " SET " + Contacts.TIMES_CONTACTED + "=" + 205 "UPDATE " + Tables.RAW_CONTACTS + " SET " + RawContacts.TIMES_CONTACTED + "=" + 446 = new String[] {Tables.GROUPS + "." + Groups._ID}; 454 + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?"; 459 + "JOIN " + Tables.ACCOUNTS + " ON (" 482 String TABLE = Tables.RAW_CONTACTS_JOIN_ACCOUNTS; 505 + " FROM " + Tables.RAW_CONTACTS 508 + " FROM " + Tables.DATA_JOIN_MIMETYPES 511 + "(SELECT " + Tables [all...] |
H A D | DataRowHandlerForPhoneNumber.java | 27 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 117 db.delete(Tables.PHONE_LOOKUP, PhoneLookupColumns.DATA_ID + "=?", mSelectionArgs1); 127 db.insert(Tables.PHONE_LOOKUP, null, phoneValues); 133 db.insert(Tables.PHONE_LOOKUP, null, phoneValues);
|
H A D | PhotoStore.java | 25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 97 mDb.delete(Tables.PHOTO_FILES, null, null); 208 long id = mDb.insert(Tables.PHOTO_FILES, null, values); 277 mDb.delete(ContactsDatabaseHelper.Tables.PHOTO_FILES, PhotoFilesColumns.CONCRETE_ID + "=?",
|
H A D | ProfileDatabaseHelper.java | 68 for (String table : Tables.SEQUENCE_TABLES) {
|
H A D | CallLogProvider.java | 42 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 165 qb.setTables(Tables.CALLS); 268 mCallsInserter = new DatabaseUtils.InsertHelper(db, Tables.CALLS); 309 return getDatabaseModifier(db).update(Tables.CALLS, values, selectionBuilder.build(), 322 return getDatabaseModifier(db).delete(Tables.CALLS, 340 return new DbModifierWithNotification(Tables.CALLS, db, context()); 348 return new DbModifierWithNotification(Tables.CALLS, insertHelper, context()); 481 if (DatabaseUtils.queryNumEntries(db, Tables.CALLS, 486 db.insert(Tables.CALLS, null, values);
|
H A D | ContactDirectoryManager.java | 39 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 136 Cursor cursor = db.query(Tables.DIRECTORIES, 294 int deletedRows = db.delete(Tables.DIRECTORIES, deleteWhereBuilder.toString(), 312 db.replace(Tables.DIRECTORIES, null, values); 326 db.replace(Tables.DIRECTORIES, null, values); 394 final int numDeleted = db.delete(Tables.DIRECTORIES, sb.toString(), 509 Cursor cursor = db.query(Tables.DIRECTORIES, new String[] { Directory._ID }, 519 db.update(Tables.DIRECTORIES, values, Directory._ID + "=?", 522 id = db.insert(Tables.DIRECTORIES, null, values);
|
H A D | SearchIndexManager.java | 36 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 312 "(SELECT " + RawContacts.CONTACT_ID + " FROM " + Tables.RAW_CONTACTS + 325 final int deleted = db.delete(Tables.SEARCH_INDEX, 328 " FROM " + Tables.RAW_CONTACTS + 360 Cursor cursor = db.query(Tables.DATA_JOIN_MIMETYPE_RAW_CONTACTS, ContactIndexQuery.COLUMNS, 399 db.insert(Tables.SEARCH_INDEX, null, mValues);
|
/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/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; 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" 333 + " AS myAlarmTime" + "," + Tables.INSTANCES + "." + Instances.EVENT_ID 336 + Reminders.MINUTES + " FROM " + Tables.INSTANCES + " INNER JOIN " + Views.EVENTS 337 + " ON (" + Views.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "." 338 + Instances.EVENT_ID + ")" + " INNER JOIN " + Tables.REMINDERS + " ON (" 339 + Tables [all...] |
H A D | CalendarProvider2.java | 65 import com.android.providers.calendar.CalendarDatabaseHelper.Tables; 196 Tables.EVENTS_RAW_TIMES + ", " + 197 Tables.EVENTS + 199 CalendarContract.EventsRawTimes.EVENT_ID + " = " + Tables.EVENTS + "." + Events._ID; 202 Tables.EVENTS + " SET " + 208 " FROM " + Tables.EVENTS + 215 + Tables.CALENDARS + " WHERE " + Events.ACCOUNT_NAME + "=? AND " + Events.ACCOUNT_TYPE 225 Tables.EVENTS + "." + Events._ID + "=" + Tables.ATTENDEES + "." + Attendees.EVENT_ID 227 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/Settings/src/com/android/settings/search/ |
H A D | IndexDatabaseHelper.java | 33 public interface Tables { interface in class:IndexDatabaseHelper 72 "CREATE VIRTUAL TABLE " + Tables.TABLE_PREFS_INDEX + " USING fts4" + 114 "CREATE TABLE " + Tables.TABLE_META_INDEX + 120 "CREATE TABLE " + Tables.TABLE_SAVED_QUERIES + 128 "INSERT INTO " + Tables.TABLE_META_INDEX + 132 "SELECT " + MetaColumns.BUILD + " FROM " + Tables.TABLE_META_INDEX + " LIMIT 1;"; 219 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); 220 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); 221 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SAVED_QUERIES);
|
/packages/apps/Dialer/src/com/android/dialer/database/ |
H A D | DialerDatabaseHelper.java | 87 public interface Tables { interface in class:DialerDatabaseHelper 208 Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.LAST_TIME_USED + ")"; 225 Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.STARRED + " DESC, " 226 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IS_SUPER_PRIMARY + " DESC, " 228 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.TIMES_USED + " DESC, " 229 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IN_VISIBLE_GROUP + " DESC, " 230 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.DISPLAY_NAME_PRIMARY + ", " 231 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.CONTACT_ID + ", " 232 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IS_PRIMARY + " DESC"; 357 db.execSQL("CREATE TABLE " + Tables [all...] |
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/ |
H A D | ContactAggregator.java | 55 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 104 "UPDATE " + Tables.CONTACTS + 107 " FROM " + Tables.STATUS_UPDATES + 108 " JOIN " + Tables.DATA + 111 " JOIN " + Tables.RAW_CONTACTS + 281 "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "(" 288 + " FROM " + Tables.PRESENCE 295 + " FROM " + Tables.PRESENCE 304 " FROM " + Tables.RAW_CONTACTS + 309 "DELETE FROM " + Tables [all...] |
H A D | ProfileAggregator.java | 25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 81 " FROM " + Tables.CONTACTS +
|
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/util/ |
H A D | CommonNicknameCache.java | 23 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 48 public final static String TABLE = Tables.NICKNAME_LOOKUP; 123 String TABLE = Tables.NICKNAME_LOOKUP;
|
/packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/ |
H A D | ContactsDatabaseHelperTest.java | 25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables; 98 mDbHelper.getWritableDatabase().execSQL("delete from " + Tables.ACCOUNTS); 122 " FROM " + Tables.MIMETYPES + 126 "INSERT INTO " + Tables.MIMETYPES + "(" 205 mDb.execSQL("DELETE FROM " + Tables.MIMETYPES);
|
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},
|