Home
last modified time | relevance | path

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

123

/packages/providers/ContactsProvider/src/com/android/providers/contacts/
DContactsDatabaseHelper.java188 public interface Tables { interface in ContactsDatabaseHelper
242 + " JOIN " + Tables.ACCOUNTS + " ON ("
247 public static final String RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS = Tables.RAW_CONTACTS
248 + " JOIN " + Tables.ACCOUNTS + " ON ("
267 Tables.CONTACTS
268 + " INNER JOIN " + Tables.RAW_CONTACTS
272 + " INNER JOIN " + Tables.DATA
279 + " FROM " + Tables.MIMETYPES
291 + " JOIN " + Tables.ACCOUNTS + " ON ("
314 public static final String RAW_CONTACTS_JOIN_ACCOUNTS = 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);
DLegacyApiSupport.java67 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
120 " JOIN " + Tables.ACCOUNTS + " ON ("
144 " LEFT OUTER JOIN " + Tables.PRESENCE +
145 " ON (" + Tables.PRESENCE + "." + StatusUpdates.DATA_ID + "=" +
147 " FROM " + Tables.PRESENCE +
179 + " THEN (CASE WHEN " + Tables.DATA + "." + Im.PROTOCOL + "=" + Im.PROTOCOL_CUSTOM
180 + " THEN 'custom:'||" + Tables.DATA + "." + Im.CUSTOM_PROTOCOL
181 + " ELSE 'pre:'||" + Tables.DATA + "." + Im.PROTOCOL
183 + " ELSE " + Tables.DATA + "." + Email.DATA
366 " FROM " + Tables.STATUS_UPDATES + in sPeopleProjectionMap.put()
[all …]
DContactsProvider2.java170 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
500 = new String[] {Tables.GROUPS + "." + Groups._ID};
508 + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?";
513 + "JOIN " + Tables.ACCOUNTS + " ON ("
536 String TABLE = Tables.RAW_CONTACTS_JOIN_ACCOUNTS;
559 + " FROM " + Tables.RAW_CONTACTS
562 + " FROM " + Tables.DATA_JOIN_MIMETYPES
565 + "(SELECT " + Tables.GROUPS + "." + Groups._ID
566 + " FROM " + Tables.GROUPS
571 "UPDATE " + Tables.RAW_CONTACTS +
[all …]
DCallLogDatabaseHelper.java76 public interface Tables { interface in CallLogDatabaseHelper
135 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in onCreate()
196 db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" + in onCreate()
339 db.execSQL("ALTER TABLE " + Tables.CALLS + " ADD " + Calls.VIA_NUMBER + in upgradeToVersion2()
347 db.execSQL("ALTER TABLE " + Tables.VOICEMAIL_STATUS + " ADD " + Status.SOURCE_TYPE + in upgradeToVersion3()
401 String oldTable = Tables.CALLS + "_old"; in upgradetoVersion8()
407 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in upgradetoVersion8()
511 db.execSQL("INSERT INTO " + Tables.CALLS + " (" + in upgradetoVersion8()
605 getWritableDatabase().execSQL("DELETE FROM " + Tables.CALLS); in wipeForTest()
DDataRowHandler.java36 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
49 public static final String TABLE = Tables.DATA_JOIN_MIMETYPES;
121 final long dataId = db.insert(Tables.DATA, null, values); in insert()
169 db.update(Tables.DATA, values, Data._ID + " =?", mSelectionArgs1); in update()
230 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA, in handleHashIdForUpdate()
274 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA, in handlePrimaryAndSuperPrimary()
322 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1); in delete()
324 db.delete(Tables.PRESENCE, PresenceColumns.RAW_CONTACT_ID + "=?", mSelectionArgs1); in delete()
393 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"
/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.java76 import com.android.providers.calendar.CalendarDatabaseHelper.Tables;
207 Tables.EVENTS_RAW_TIMES + ", " +
208 Tables.EVENTS +
210 CalendarContract.EventsRawTimes.EVENT_ID + " = " + Tables.EVENTS + "." + Events._ID;
213 Tables.EVENTS + " SET " +
219 " FROM " + Tables.EVENTS +
226 + Tables.CALENDARS + " WHERE " + Events.ACCOUNT_NAME + "=? AND " + Events.ACCOUNT_TYPE
236 Tables.EVENTS + "." + Events._ID + "=" + Tables.ATTENDEES + "." + Attendees.EVENT_ID
238 Tables.EVENTS + "." + Events.CALENDAR_ID + "=" + Tables.CALENDARS + "." + Calendars._ID;
241 Tables.ATTENDEES + "." + Attendees._ID + "=? AND " + SQL_WHERE_ATTENDEE_BASE;
[all …]
DCalendarInstancesHelper.java25 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.java20 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;
104 "UPDATE " + Tables.CONTACTS +
107 " FROM " + Tables.STATUS_UPDATES +
108 " JOIN " + Tables.DATA +
111 " JOIN " + Tables.RAW_CONTACTS +
286 "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "(" in AbstractContactAggregator()
293 + " FROM " + Tables.PRESENCE in AbstractContactAggregator()
300 + " FROM " + Tables.PRESENCE in AbstractContactAggregator()
309 " FROM " + Tables.RAW_CONTACTS + in AbstractContactAggregator()
314 "DELETE FROM " + Tables.AGGREGATED_PRESENCE + in AbstractContactAggregator()
[all …]
DContactAggregator2.java42 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
190 final String sql = "SELECT " + RawContacts._ID + " FROM " + Tables.RAW_CONTACTS + in needAggregate()
248 Tables.DATA +" WHERE " + Data.IS_SUPER_PRIMARY + " = 1 AND " + in clearSuperPrimarySetting()
277 String superPrimaryUpdateSql = "UPDATE " + Tables.DATA + in clearSuperPrimarySetting()
292 " FROM " + Tables.AGGREGATION_EXCEPTIONS + in buildExceptionMatchingSql()
400 Tables.RAW_CONTACTS + " WHERE " + RawContacts.CONTACT_ID + "=? AND " + in canBeReused()
719 + RawContacts.CONTACT_ID + " IN " + Tables.DEFAULT_DIRECTORY; in lookupApproximateNameMatches()
729 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS;
947 final String TABLE = Tables.DATA + " dataA"
948 + " JOIN " + Tables.DATA + " dataB" +
[all …]
DContactAggregator.java35 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
125 " FROM " + Tables.RAW_CONTACTS + in aggregateContact()
257 " FROM (SELECT " + DataColumns.MIMETYPE_ID + " FROM " + Tables.DATA + " WHERE " + in clearSuperPrimarySetting()
260 Tables.RAW_CONTACTS + " WHERE " + RawContacts.CONTACT_ID + "=?1)) AS a" + in clearSuperPrimarySetting()
261 " JOIN (SELECT " + DataColumns.MIMETYPE_ID + " FROM " + Tables.DATA + " WHERE " + in clearSuperPrimarySetting()
285 String superPrimaryUpdateSql = "UPDATE " + Tables.DATA + in clearSuperPrimarySetting()
288 " IN (SELECT " + RawContacts._ID + " FROM " + Tables.RAW_CONTACTS + in clearSuperPrimarySetting()
521 String TABLE = Tables.AGGREGATION_EXCEPTIONS
685 final String TABLE = Tables.DATA + " dataA"
686 + " JOIN " + Tables.DATA + " dataB" +
[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/providers/ContactsProvider/tests/src/com/android/providers/contacts/
DContactsDatabaseHelperTest.java37 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
116 mDbHelper.getWritableDatabase().execSQL("delete from " + Tables.ACCOUNTS); in testGetOrCreateAccountId()
140 " FROM " + Tables.MIMETYPES + in testQueryIdWithOneArg_insertWithOneArgAndReturnId()
144 "INSERT INTO " + Tables.MIMETYPES + "(" in testQueryIdWithOneArg_insertWithOneArgAndReturnId()
224 mDb.execSQL("DELETE FROM " + Tables.MIMETYPES + ";"); in testGetCommonMimeTypeIds()
282 final long rawContactId = mDb.insert(Tables.RAW_CONTACTS,null, rawContactValues); in testUpgradeHashId()
297 assertTrue(mDb.insert(Tables.DATA, null, values) > 0); in testUpgradeHashId()
300 final Cursor c = mDb.query(Tables.DATA, new String[]{ContactsContract.Data.HASH_ID}, in testUpgradeHashId()
320 final long rawContactId = mDb.insert(Tables.RAW_CONTACTS,null, rawContactValues); in testUpgradeHashIdForPhoto()
331 assertTrue(mDb.insert(Tables.DATA, null, values) > 0); in testUpgradeHashIdForPhoto()
[all …]
DContactsDatabaseHelperUpgradeTest.java60 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
650 new TableListEntry(PropertyUtils.Tables.PROPERTIES, PROPERTIES_COLUMNS),
651 new TableListEntry(Tables.ACCOUNTS, ACCOUNTS_COLUMNS),
652 new TableListEntry(Tables.CONTACTS, CONTACTS_COLUMNS),
653 new TableListEntry(Tables.DELETED_CONTACTS, DELETED_CONTACTS_COLUMNS),
654 new TableListEntry(Tables.RAW_CONTACTS, RAW_CONTACTS_COLUMNS),
655 new TableListEntry(Tables.STREAM_ITEMS, STREAM_ITEMS_COLUMNS),
656 new TableListEntry(Tables.STREAM_ITEM_PHOTOS, STREAM_ITEM_PHOTOS_COLUMNS),
657 new TableListEntry(Tables.PHOTO_FILES, PHOTO_FILES_COLUMNS),
658 new TableListEntry(Tables.PACKAGES, PACKAGES_COLUMNS),
[all …]
DContactsDatabaseMigrationTest.java74 "select count(*) from " + ContactsDatabaseHelper.Tables.DATA in testPhoneAccountHandleMigrationMarkingOnUpgrade()
80 "select count(*) from " + ContactsDatabaseHelper.Tables.DATA in testPhoneAccountHandleMigrationMarkingOnUpgrade()
86 "select count(*) from " + ContactsDatabaseHelper.Tables.DATA in testPhoneAccountHandleMigrationMarkingOnUpgrade()
106 "select count(*) from " + ContactsDatabaseHelper.Tables.DATA in testPhoneAccountHandleMigrationOnCreate()
DPhotoStoreTest.java28 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
143 Cursor c = mDb.query(Tables.PHOTO_FILES, in runStorageTestForResource()
164 Cursor c = mDb.query(Tables.PHOTO_FILES, in runStorageTestForResourceWithCrop()
188 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID}, in testRemoveEntry()
234 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID}, in testCleanup()
/packages/apps/SettingsIntelligence/src/com/android/settings/intelligence/search/indexing/
DIndexDatabaseHelper.java50 public interface Tables { interface in IndexDatabaseHelper
100 "CREATE VIRTUAL TABLE " + Tables.TABLE_PREFS_INDEX + " USING fts4" +
146 "CREATE TABLE " + Tables.TABLE_META_INDEX +
152 "CREATE TABLE " + Tables.TABLE_SAVED_QUERIES +
160 "CREATE VIRTUAL TABLE " + Tables.TABLE_SITE_MAP + " USING fts4" +
173 "INSERT INTO " + Tables.TABLE_META_INDEX +
177 "SELECT " + MetaColumns.BUILD + " FROM " + Tables.TABLE_META_INDEX + " LIMIT 1;";
350 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); in dropTables()
351 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); in dropTables()
352 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/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()
/packages/apps/Settings/src/com/android/settings/fuelgauge/batterytip/
DAnomalyDatabaseHelper.java50 public interface Tables { interface in AnomalyDatabaseHelper
82 + Tables.TABLE_ANOMALY
125 + Tables.TABLE_ACTION
204 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_ANOMALY); in dropTables()
205 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_ACTION); in dropTables()

123