Searched refs:Tables (Results 1 - 25 of 54) sorted by relevance

123

/packages/providers/ContactsProvider/src/com/android/providers/contacts/
H A DContactsDatabaseHelper.java149 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 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,
231 Cursor c = db.query(Tables.GROUPS, Projections.ID,
242 long groupId = db.insert(Tables.GROUPS, null, groupValues);
H A DCallLogDatabaseHelper.java61 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 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);
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 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
[all...]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/database/
H A DContactsTableUtil.java20 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 DDeletedContactsTableUtil.java38 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 DPropertyUtils.java30 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 DBlockedNumberDatabaseHelper.java39 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 DCalendarDatabaseHelper.java141 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 DCalendarAlarmManager.java19 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 DCalendarProvider2.java66 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 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
[all...]
/packages/apps/Dialer/java/com/android/dialer/database/
H A DDialerDatabaseHelper.java105 + 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 DIndexDatabaseHelper.java42 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 DSavedQueryRemover.java20 import static com.android.settings.search.IndexDatabaseHelper.Tables.TABLE_SAVED_QUERIES;
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/
H A 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 +
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 DContactAggregator2.java42 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 DProfileAggregator.java25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
81 " FROM " + Tables.CONTACTS +
H A DContactAggregator.java35 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 DContactsDatabaseHelperTest.java37 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 DContactsDatabaseHelperUpgradeTest.java66 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 DCallLogMigrationTest.java72 CallLogDatabaseHelper.Tables.CALLS, null));
75 CallLogDatabaseHelper.Tables.VOICEMAIL_STATUS, null));
H A DPhotoStoreTest.java27 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 DCommonNicknameCache.java25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
49 public final static String TABLE = Tables.NICKNAME_LOOKUP;
127 String TABLE = Tables.NICKNAME_LOOKUP;

Completed in 370 milliseconds

123