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

12

/packages/providers/ContactsProvider/src/com/android/providers/contacts/
H A DContactsDatabaseHelper.java124 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 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 DLegacyApiSupport.java66 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 DDataRowHandlerForOrganization.java26 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
74 " FROM " + Tables.DATA +
85 " FROM " + Tables.DATA +
H A DDataRowHandler.java33 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 DContactsProvider2.java140 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 DDataRowHandlerForPhoneNumber.java27 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 DPhotoStore.java25 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 DProfileDatabaseHelper.java68 for (String table : Tables.SEQUENCE_TABLES) {
H A DCallLogProvider.java42 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 DContactDirectoryManager.java39 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 DSearchIndexManager.java36 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 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/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;
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 DCalendarProvider2.java65 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 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/Settings/src/com/android/settings/search/
H A DIndexDatabaseHelper.java33 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 DDialerDatabaseHelper.java87 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 DContactAggregator.java55 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 DProfileAggregator.java25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
81 " FROM " + Tables.CONTACTS +
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/util/
H A DCommonNicknameCache.java23 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 DContactsDatabaseHelperTest.java25 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 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},

Completed in 310 milliseconds

12