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

/packages/providers/ContactsProvider/src/com/android/providers/contacts/
H A DContactsDatabaseHelper.java111 public interface Tables { interface in class:ContactsDatabaseHelper
189 Tables.CONTACTS
190 + " INNER JOIN " + Tables.RAW_CONTACTS
194 + " INNER JOIN " + Tables.DATA
201 + " FROM " + Tables.MIMETYPES
294 " FROM " + Tables.RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS +
296 " FROM " + Tables.RAW_CONTACTS + " AS " + OUTER_RAW_CONTACTS +
309 "EXISTS (SELECT _id FROM " + Tables.VISIBLE_CONTACTS
310 + " WHERE " + Tables.CONTACTS +"." + Contacts._ID
311 + "=" + Tables
[all...]
H A DProfileAggregator.java22 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
73 " FROM " + Tables.CONTACTS +
H A DDataRowHandlerForGroupMembership.java22 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
44 String TABLE = Tables.RAW_CONTACTS;
62 "SELECT COUNT(*) FROM " + Tables.DATA + " LEFT OUTER JOIN " + Tables .GROUPS
63 + " ON " + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID
66 + " AND " + Tables.DATA + "." + GroupMembership.RAW_CONTACT_ID + "=?"
110 if (db.update(Tables.RAW_CONTACTS, rawContactValues, SELECTION_RAW_CONTACT_ID,
244 c = db.query(Tables.GROUPS, new String[]{RawContacts._ID},
252 c = db.query(Tables.GROUPS, new String[]{RawContacts._ID},
270 long groupId = db.insert(Tables
[all...]
H A DSocialProvider.java22 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
94 columns.put(RawContacts._ID, Tables.RAW_CONTACTS + "." + RawContacts._ID + " AS _id");
171 * Inserts an item into the {@link Tables#ACTIVITIES} table.
209 id = db.insert(Tables.ACTIVITIES, Activities.RAW_ID, values);
231 final Cursor c = db.query(Tables.ACTIVITIES,
265 int replies = db.update(Tables.ACTIVITIES, values,
277 final Cursor c = db.query(Tables.ACTIVITIES,
302 return db.delete(Tables.ACTIVITIES, Activities._ID + "=" + activityId, null);
307 return db.delete(Tables.ACTIVITIES, Activities.AUTHOR_CONTACT_ID + "=" + contactId, null);
332 qb.setTables(Tables
[all...]
H A DContactAggregator.java29 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
86 "UPDATE " + Tables.CONTACTS +
89 " FROM " + Tables.STATUS_UPDATES +
90 " JOIN " + Tables.DATA +
93 " JOIN " + Tables.RAW_CONTACTS +
263 "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "("
270 + " FROM " + Tables.PRESENCE
277 + " FROM " + Tables.PRESENCE
286 " FROM " + Tables.RAW_CONTACTS +
291 "DELETE FROM " + Tables
[all...]
H A DCommonNicknameCache.java20 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
48 public final static String TABLE = Tables.NICKNAME_LOOKUP;
123 String TABLE = Tables.NICKNAME_LOOKUP;
H A DLegacyApiSupport.java28 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
143 " LEFT OUTER JOIN " + Tables.PRESENCE +
144 " ON (" + Tables.PRESENCE + "." + StatusUpdates.DATA_ID + "=" +
146 " FROM " + Tables.PRESENCE +
178 + " THEN (CASE WHEN " + Tables.DATA + "." + Im.PROTOCOL + "=" + Im.PROTOCOL_CUSTOM
179 + " THEN 'custom:'||" + Tables.DATA + "." + Im.CUSTOM_PROTOCOL
180 + " ELSE 'pre:'||" + Tables.DATA + "." + Im.PROTOCOL
182 + " ELSE " + Tables.DATA + "." + Email.DATA
195 "UPDATE " + Tables.CONTACTS +
199 "UPDATE " + Tables
[all...]
H A DCallLogProvider.java23 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
127 qb.setTables(Tables.CALLS);
192 mCallsInserter = new DatabaseUtils.InsertHelper(db, Tables.CALLS);
233 return getDatabaseModifier(db).update(Tables.CALLS, values, selectionBuilder.build(),
246 return getDatabaseModifier(db).delete(Tables.CALLS,
264 return new DbModifierWithNotification(Tables.CALLS, db, context());
272 return new DbModifierWithNotification(Tables.CALLS, insertHelper, context());
H A DDataRowHandlerForOrganization.java18 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
73 " FROM " + Tables.DATA +
84 " FROM " + Tables.DATA +
H A DDataRowHandler.java21 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
41 public static final String TABLE = Tables.DATA_JOIN_MIMETYPES;
110 final long dataId = db.insert(Tables.DATA, null, values);
157 db.update(Tables.DATA, values, Data._ID + " =?", mSelectionArgs1);
206 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA,
254 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1);
256 db.delete(Tables.PRESENCE, PresenceColumns.RAW_CONTACT_ID + "=?", mSelectionArgs1);
325 final Cursor cursor = db.query(Tables.DATA, null, Data._ID + "=?",
H A DDataRowHandlerForPhoneNumber.java20 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
115 db.delete(Tables.PHONE_LOOKUP, PhoneLookupColumns.DATA_ID + "=?", mSelectionArgs1);
125 db.insert(Tables.PHONE_LOOKUP, null, phoneValues);
131 db.insert(Tables.PHONE_LOOKUP, null, phoneValues);
H A DPhotoStore.java19 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
94 mDb.delete(Tables.PHOTO_FILES, null, null);
205 long id = mDb.insert(Tables.PHOTO_FILES, null, values);
274 mDb.delete(ContactsDatabaseHelper.Tables.PHOTO_FILES, PhotoFilesColumns.CONCRETE_ID + "=?",
H A DProfileDatabaseHelper.java66 for (String table : Tables.SEQUENCE_TABLES) {
H A DContactsProvider2.java43 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
242 "UPDATE " + Tables.CONTACTS + " SET " + Contacts.TIMES_CONTACTED + "=" +
247 "UPDATE " + Tables.RAW_CONTACTS + " SET " + RawContacts.TIMES_CONTACTED + "=" +
418 = new String[]{Tables.GROUPS + "." + Groups._ID};
426 + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?";
451 String TABLE = Tables.RAW_CONTACTS;
472 + " FROM " + Tables.RAW_CONTACTS
475 + " FROM " + Tables.DATA_JOIN_MIMETYPES
478 + "(SELECT " + Tables.GROUPS + "." + Groups._ID
479 + " FROM " + Tables
[all...]
H A DLegacyContactImporter.java23 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
255 String INSERT_SQL = "INSERT INTO " + Tables.GROUPS + "(" +
391 String INSERT_SQL = "INSERT INTO " + Tables.RAW_CONTACTS + "(" +
425 String INSERT_SQL = "INSERT INTO " + Tables.CONTACTS + "(" +
445 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
477 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
690 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
756 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
778 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
800 String INSERT_SQL = "INSERT INTO " + Tables
[all...]
H A DContactDirectoryManager.java20 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
137 Cursor cursor = db.query(Tables.DIRECTORIES,
288 int deletedRows = db.delete(Tables.DIRECTORIES, deleteWhereBuilder.toString(),
306 db.replace(Tables.DIRECTORIES, null, values);
320 db.replace(Tables.DIRECTORIES, null, values);
379 db.delete(Tables.DIRECTORIES, sb.toString(), new String[] { packageInfo.packageName });
490 Cursor cursor = db.query(Tables.DIRECTORIES, new String[] { Directory._ID },
500 db.update(Tables.DIRECTORIES, values, Directory._ID + "=?",
503 id = db.insert(Tables.DIRECTORIES, null, values);
H A DSearchIndexManager.java21 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
300 Cursor cursor = db.query(Tables.DATA_JOIN_MIMETYPE_RAW_CONTACTS, ContactIndexQuery.COLUMNS,
341 int count = db.update(Tables.SEARCH_INDEX, mValues,
345 db.insert(Tables.SEARCH_INDEX, null, mValues);
349 db.insert(Tables.SEARCH_INDEX, null, mValues);
H A DDbModifierWithNotification.java24 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
91 mBaseUri = mTableName.equals(Tables.VOICEMAIL_STATUS) ?
93 mIsCallsTable = mTableName.equals(Tables.CALLS);
H A DVoicemailContentProvider.java22 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
65 mVoicemailContentTable = new VoicemailContentTable(Tables.CALLS, context,
67 mVoicemailStatusTable = new VoicemailStatusTable(Tables.VOICEMAIL_STATUS, context,
H A DGlobalSearchSupport.java39 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
79 " FROM " + Tables.AGGREGATED_PRESENCE +
/packages/providers/CalendarProvider/src/com/android/providers/calendar/
H A DCalendarDatabaseHelper.java123 public interface Tables { interface in class:CalendarDatabaseHelper
148 "DELETE FROM " + Tables.INSTANCES +
151 "DELETE FROM " + Tables.EVENTS_RAW_TIMES +
154 "DELETE FROM " + Tables.ATTENDEES +
157 "DELETE FROM " + Tables.REMINDERS +
160 "DELETE FROM " + Tables.CALENDAR_ALERTS +
163 "DELETE FROM " + Tables.EXTENDED_PROPERTIES +
170 "UPDATE " + Tables.EVENTS +
177 " ON " + Tables.EVENTS +
182 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"
317 + " AS myAlarmTime" + "," + Tables.INSTANCES + "." + Instances.EVENT_ID
320 + Reminders.MINUTES + " FROM " + Tables.INSTANCES + " INNER JOIN " + Views.EVENTS
321 + " ON (" + Views.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "."
322 + Instances.EVENT_ID + ")" + " INNER JOIN " + Tables.REMINDERS + " ON ("
323 + Tables
[all...]
H A DCalendarProvider2.java24 import com.android.providers.calendar.CalendarDatabaseHelper.Tables;
187 Tables.EVENTS_RAW_TIMES + ", " +
188 Tables.EVENTS +
190 CalendarContract.EventsRawTimes.EVENT_ID + " = " + Tables.EVENTS + "." + Events._ID;
193 Tables.EVENTS +
210 Tables.EVENTS + "." + Events._ID + "=" + Tables.ATTENDEES + "." + Attendees.EVENT_ID
212 Tables.EVENTS + "." + Events.CALENDAR_ID + "=" + Tables.CALENDARS + "." + Calendars._ID;
215 Tables
[all...]
H A DCalendarInstancesHelper.java23 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/providers/ContactsProvider/tests/src/com/android/providers/contacts/
H A DPhotoStoreTest.java19 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
115 Cursor c = mDb.query(Tables.PHOTO_FILES,
143 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID},
189 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID},

Completed in 900 milliseconds