Home
last modified time | relevance | path

Searched refs:Tables (Results 1 – 25 of 63) sorted by relevance

123

/packages/providers/ContactsProvider/src/com/android/providers/contacts/
DContactsDatabaseHelper.java168 public interface Tables { interface in ContactsDatabaseHelper
224 + " JOIN " + Tables.ACCOUNTS + " ON ("
230 public static final String RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS = Tables.RAW_CONTACTS
231 + " JOIN " + Tables.ACCOUNTS + " ON ("
234 + "LEFT OUTER JOIN " + Tables.SETTINGS + " ON ("
254 + " FROM " + Tables.ACCOUNTS
265 Tables.CONTACTS
266 + " INNER JOIN " + Tables.RAW_CONTACTS
270 + " INNER JOIN " + Tables.DATA
277 + " FROM " + Tables.MIMETYPES
[all …]
DLegacyApiSupport.java67 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.STATUS_UPDATES + in sPeopleProjectionMap.put()
[all …]
DContactsProvider2.java148 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
460 = new String[] {Tables.GROUPS + "." + Groups._ID};
468 + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?";
473 + "JOIN " + Tables.ACCOUNTS + " ON ("
496 String TABLE = Tables.RAW_CONTACTS_JOIN_ACCOUNTS;
519 + " FROM " + Tables.RAW_CONTACTS
522 + " FROM " + Tables.DATA_JOIN_MIMETYPES
525 + "(SELECT " + Tables.GROUPS + "." + Groups._ID
526 + " FROM " + Tables.GROUPS
531 "UPDATE " + Tables.RAW_CONTACTS +
[all …]
DDataRowHandlerForGroupMembership.java32 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, in updateRawContactsStar()
231 Cursor c = db.query(Tables.GROUPS, Projections.ID,
242 long groupId = db.insert(Tables.GROUPS, null, groupValues);
DCallLogDatabaseHelper.java61 public interface Tables { interface in CallLogDatabaseHelper
119 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in onCreate()
172 db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" + in onCreate()
268 db.execSQL("ALTER TABLE " + Tables.CALLS + " ADD " + Calls.VIA_NUMBER + in upgradeToVersion2()
276 db.execSQL("ALTER TABLE " + Tables.VOICEMAIL_STATUS + " ADD " + Status.SOURCE_TYPE + in upgradeToVersion3()
330 String oldTable = Tables.CALLS + "_old"; in upgradetoVersion8()
336 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in upgradetoVersion8()
440 db.execSQL("INSERT INTO " + Tables.CALLS + " (" + in upgradetoVersion8()
494 calllog.insertOrThrow(Tables.CALLS, null, cv); in migrateFromLegacyTables()
505 calllog.insertOrThrow(Tables.VOICEMAIL_STATUS, null, cv); in migrateFromLegacyTables()
[all …]
DDataRowHandler.java33 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); in insert()
168 db.update(Tables.DATA, values, Data._ID + " =?", mSelectionArgs1); in update()
229 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA, in handleHashIdForUpdate()
275 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA, in handlePrimaryAndSuperPrimary()
323 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1); in delete()
325 db.delete(Tables.PRESENCE, PresenceColumns.RAW_CONTACT_ID + "=?", mSelectionArgs1); in delete()
395 final Cursor cursor = db.query(Tables.DATA, null, Data._ID + "=?", in getAugmentedValues()
DAbstractContactsProvider.java41 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
374 "SELECT * FROM " + Tables.ACCOUNTS + " ORDER BY " + BaseColumns._ID;
377 "SELECT count(*) FROM " + Tables.CONTACTS;
380 "SELECT count(*) FROM " + Tables.DEFAULT_DIRECTORY;
383 "SELECT _id, count(*) as c FROM " + Tables.RAW_CONTACTS
396 + " FROM " + Tables.RAW_CONTACTS
408 + " FROM " + Tables.DATA + " AS d JOIN " + Tables.RAW_CONTACTS + " AS r"
DContactDirectoryManager.java41 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
136 + " FROM " + Tables.DIRECTORIES, null); in areTypeResourceIdsValid()
355 int deletedRows = db.delete(Tables.DIRECTORIES, deleteWhereBuilder.toString(), in scanAllPackages()
376 db.replace(Tables.DIRECTORIES, null, values); in insertDefaultDirectory()
390 db.replace(Tables.DIRECTORIES, null, values); in insertLocalInvisibleDirectory()
458 final int numDeleted = db.delete(Tables.DIRECTORIES, sb.toString(), in updateDirectoriesForPackage()
573 Cursor cursor = db.query(Tables.DIRECTORIES, new String[] { Directory._ID }, in updateDirectories()
583 db.update(Tables.DIRECTORIES, values, Directory._ID + "=?", in updateDirectories()
586 id = db.insert(Tables.DIRECTORIES, null, values); in updateDirectories()
/packages/providers/CalendarProvider/src/com/android/providers/calendar/
DCalendarDatabaseHelper.java141 public interface Tables { interface in 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.EVENTS +
[all …]
DCalendarProvider2.java74 import com.android.providers.calendar.CalendarDatabaseHelper.Tables;
204 Tables.EVENTS_RAW_TIMES + ", " +
205 Tables.EVENTS +
207 CalendarContract.EventsRawTimes.EVENT_ID + " = " + Tables.EVENTS + "." + Events._ID;
210 Tables.EVENTS + " SET " +
216 " FROM " + Tables.EVENTS +
223 + Tables.CALENDARS + " WHERE " + Events.ACCOUNT_NAME + "=? AND " + Events.ACCOUNT_TYPE
233 Tables.EVENTS + "." + Events._ID + "=" + Tables.ATTENDEES + "." + Attendees.EVENT_ID
235 Tables.EVENTS + "." + Events.CALENDAR_ID + "=" + Tables.CALENDARS + "." + Calendars._ID;
238 Tables.ATTENDEES + "." + Attendees._ID + "=? AND " + SQL_WHERE_ATTENDEE_BASE;
[all …]
DCalendarInstancesHelper.java24 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.INSTANCES +
99 " INNER JOIN " + Tables.EVENTS +
[all …]
DCalendarAlarmManager.java19 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"
316 + " AS myAlarmTime" + "," + Tables.INSTANCES + "." + Instances.EVENT_ID in scheduleNextAlarmLocked()
319 + Reminders.MINUTES + " FROM " + Tables.INSTANCES + " INNER JOIN " + Views.EVENTS in scheduleNextAlarmLocked()
320 + " ON (" + Views.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "." in scheduleNextAlarmLocked()
321 + Instances.EVENT_ID + ")" + " INNER JOIN " + Tables.REMINDERS + " ON (" in scheduleNextAlarmLocked()
322 + Tables.INSTANCES + "." + Instances.EVENT_ID + "=" + Tables.REMINDERS + "." in scheduleNextAlarmLocked()
[all …]
/packages/apps/Dialer/java/com/android/dialer/database/
DDialerDatabaseHelper.java117 + Tables.SMARTDIAL_TABLE in setupTables()
153 + Tables.PREFIX_TABLE in setupTables()
165 + Tables.PROPERTIES in setupTables()
178 + Tables.FILTERED_NUMBER_TABLE in setupTables()
207 db.execSQL("DROP TABLE IF EXISTS " + Tables.PREFIX_TABLE); in dropTables()
208 db.execSQL("DROP TABLE IF EXISTS " + Tables.SMARTDIAL_TABLE); in dropTables()
209 db.execSQL("DROP TABLE IF EXISTS " + Tables.PROPERTIES); in dropTables()
210 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in dropTables()
211 db.execSQL("DROP TABLE IF EXISTS " + Tables.VOICEMAIL_ARCHIVE_TABLE); in dropTables()
234 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in onUpgrade()
[all …]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/
DAbstractContactAggregator.java32 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 +
290 "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "(" in AbstractContactAggregator()
297 + " FROM " + Tables.PRESENCE in AbstractContactAggregator()
304 + " FROM " + Tables.PRESENCE in AbstractContactAggregator()
313 " FROM " + Tables.RAW_CONTACTS + in AbstractContactAggregator()
318 "DELETE FROM " + Tables.AGGREGATED_PRESENCE + in AbstractContactAggregator()
[all …]
DContactAggregator2.java42 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
192 final String sql = "SELECT " + RawContacts._ID + " FROM " + Tables.RAW_CONTACTS + in needAggregate()
250 Tables.DATA +" WHERE " + Data.IS_SUPER_PRIMARY + " = 1 AND " + in clearSuperPrimarySetting()
279 String superPrimaryUpdateSql = "UPDATE " + Tables.DATA + in clearSuperPrimarySetting()
294 " FROM " + Tables.AGGREGATION_EXCEPTIONS + in buildExceptionMatchingSql()
402 Tables.RAW_CONTACTS + " WHERE " + RawContacts.CONTACT_ID + "=? AND " + in canBeReused()
721 + RawContacts.CONTACT_ID + " IN " + Tables.DEFAULT_DIRECTORY; in lookupApproximateNameMatches()
731 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS;
949 final String TABLE = Tables.DATA + " dataA"
950 + " JOIN " + Tables.DATA + " dataB" +
[all …]
DContactAggregator.java35 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
127 " FROM " + Tables.RAW_CONTACTS + in aggregateContact()
259 " FROM (SELECT " + DataColumns.MIMETYPE_ID + " FROM " + Tables.DATA + " WHERE " + in clearSuperPrimarySetting()
262 Tables.RAW_CONTACTS + " WHERE " + RawContacts.CONTACT_ID + "=?1)) AS a" + in clearSuperPrimarySetting()
263 " JOIN (SELECT " + DataColumns.MIMETYPE_ID + " FROM " + Tables.DATA + " WHERE " + in clearSuperPrimarySetting()
287 String superPrimaryUpdateSql = "UPDATE " + Tables.DATA + in clearSuperPrimarySetting()
290 " IN (SELECT " + RawContacts._ID + " FROM " + Tables.RAW_CONTACTS + in clearSuperPrimarySetting()
523 String TABLE = Tables.AGGREGATION_EXCEPTIONS
687 final String TABLE = Tables.DATA + " dataA"
688 + " JOIN " + Tables.DATA + " dataB" +
[all …]
/packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/
DContactsDatabaseHelperUpgradeTest.java65 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
571 new TableListEntry(PropertyUtils.Tables.PROPERTIES, PROPERTIES_COLUMNS),
572 new TableListEntry(Tables.ACCOUNTS, ACCOUNTS_COLUMNS),
573 new TableListEntry(Tables.CONTACTS, CONTACTS_COLUMNS),
574 new TableListEntry(Tables.DELETED_CONTACTS, DELETED_CONTACTS_COLUMNS),
575 new TableListEntry(Tables.RAW_CONTACTS, RAW_CONTACTS_COLUMNS),
576 new TableListEntry(Tables.STREAM_ITEMS, STREAM_ITEMS_COLUMNS),
577 new TableListEntry(Tables.STREAM_ITEM_PHOTOS, STREAM_ITEM_PHOTOS_COLUMNS),
578 new TableListEntry(Tables.PHOTO_FILES, PHOTO_FILES_COLUMNS),
579 new TableListEntry(Tables.PACKAGES, PACKAGES_COLUMNS),
[all …]
DContactsDatabaseHelperTest.java35 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
114 mDbHelper.getWritableDatabase().execSQL("delete from " + Tables.ACCOUNTS); in testGetOrCreateAccountId()
138 " FROM " + Tables.MIMETYPES + in testQueryIdWithOneArg_insertWithOneArgAndReturnId()
142 "INSERT INTO " + Tables.MIMETYPES + "(" in testQueryIdWithOneArg_insertWithOneArgAndReturnId()
222 mDb.execSQL("DELETE FROM " + Tables.MIMETYPES + ";"); in testGetCommonMimeTypeIds()
280 final long rawContactId = mDb.insert(Tables.RAW_CONTACTS,null, rawContactValues); in testUpgradeHashId()
295 assertTrue(mDb.insert(Tables.DATA, null, values) > 0); in testUpgradeHashId()
298 final Cursor c = mDb.query(Tables.DATA, new String[]{ContactsContract.Data.HASH_ID}, in testUpgradeHashId()
318 final long rawContactId = mDb.insert(Tables.RAW_CONTACTS,null, rawContactValues); in testUpgradeHashIdForPhoto()
329 assertTrue(mDb.insert(Tables.DATA, null, values) > 0); in testUpgradeHashIdForPhoto()
[all …]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/database/
DContactsTableUtil.java20 import static com.android.providers.contacts.ContactsDatabaseHelper.Tables;
44 final String table = Tables.CONTACTS; in createIndexes()
62 db.update(Tables.CONTACTS, values, Contacts._ID + " = ?", in updateContactLastUpdateByContactId()
93 final String sql = "UPDATE " + Tables.CONTACTS in buildUpdateLastUpdateSql()
98 + " FROM " + Tables.RAW_CONTACTS in buildUpdateLastUpdateSql()
114 return db.delete(Tables.CONTACTS, Contacts._ID + " = ?", new String[]{contactId + ""}); in deleteContact()
125 + " from " + Tables.RAW_CONTACTS in deleteContactIfSingleton()
128 + " from " + Tables.RAW_CONTACTS in deleteContactIfSingleton()
DDeletedContactsTableUtil.java38 db.execSQL("CREATE TABLE " + ContactsDatabaseHelper.Tables.DELETED_CONTACTS + " (" + in create()
45 ContactsDatabaseHelper.Tables.DELETED_CONTACTS, in create()
62 return db.insertWithOnConflict(ContactsDatabaseHelper.Tables.DELETED_CONTACTS, null, values, in insertDeletedContact()
78 return db.delete(ContactsDatabaseHelper.Tables.DELETED_CONTACTS, in deleteOldLogs()
/packages/apps/SettingsIntelligence/src/com/android/settings/intelligence/search/indexing/
DIndexDatabaseHelper.java47 public interface Tables { interface in IndexDatabaseHelper
95 "CREATE VIRTUAL TABLE " + Tables.TABLE_PREFS_INDEX + " USING fts4" +
139 "CREATE TABLE " + Tables.TABLE_META_INDEX +
145 "CREATE TABLE " + Tables.TABLE_SAVED_QUERIES +
153 "CREATE VIRTUAL TABLE " + Tables.TABLE_SITE_MAP + " USING fts4" +
164 "INSERT INTO " + Tables.TABLE_META_INDEX +
168 "SELECT " + MetaColumns.BUILD + " FROM " + Tables.TABLE_META_INDEX + " LIMIT 1;";
326 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); in dropTables()
327 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); in dropTables()
328 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SAVED_QUERIES); in dropTables()
[all …]
/packages/providers/BlockedNumberProvider/src/com/android/providers/blockednumber/
DBlockedNumberDatabaseHelper.java39 public interface Tables { interface in BlockedNumberDatabaseHelper
65 db.execSQL("CREATE TABLE " + Tables.BLOCKED_NUMBERS + " (" + in createTables()
71 db.execSQL("CREATE INDEX blocked_number_idx_original ON " + Tables.BLOCKED_NUMBERS + in createTables()
73 db.execSQL("CREATE INDEX blocked_number_idx_e164 ON " + Tables.BLOCKED_NUMBERS + " (" + in createTables()
109 getWritableDatabase().execSQL("DELETE FROM " + Tables.BLOCKED_NUMBERS); in wipeForTest()
/packages/apps/Settings/src/com/android/settings/fuelgauge/batterytip/
DAnomalyDatabaseHelper.java54 public interface Tables { interface in AnomalyDatabaseHelper
85 "CREATE TABLE " + Tables.TABLE_ANOMALY +
123 "CREATE TABLE " + Tables.TABLE_ACTION +
185 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_ANOMALY); in dropTables()
186 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_ACTION); in dropTables()
/packages/services/Car/tests/CarDeveloperOptions/src/com/android/car/developeroptions/fuelgauge/batterytip/
DAnomalyDatabaseHelper.java54 public interface Tables { interface in AnomalyDatabaseHelper
85 "CREATE TABLE " + Tables.TABLE_ANOMALY +
123 "CREATE TABLE " + Tables.TABLE_ACTION +
185 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_ANOMALY); in dropTables()
186 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_ACTION); in dropTables()
/packages/providers/ContactsProvider/src/com/android/providers/contacts/util/
DPropertyUtils.java30 public interface Tables { interface in PropertyUtils
43 db.execSQL("CREATE TABLE " + Tables.PROPERTIES + " (" + in createPropertiesTable()
54 final Cursor cursor = db.query(Tables.PROPERTIES, in getProperty()
77 db.replace(Tables.PROPERTIES, null, values); in setProperty()

123