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

12

/packages/providers/ContactsProvider/src/com/android/providers/contacts/
H A DContactsDatabaseHelper.java126 public interface Tables { interface in class:ContactsDatabaseHelper
184 + " JOIN " + Tables.ACCOUNTS + " ON ("
190 public static final String RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS = Tables.RAW_CONTACTS
191 + " JOIN " + Tables.ACCOUNTS + " ON ("
194 + "LEFT OUTER JOIN " + Tables.SETTINGS + " ON ("
214 + " FROM " + Tables.ACCOUNTS
225 Tables.CONTACTS
226 + " INNER JOIN " + Tables.RAW_CONTACTS
230 + " INNER JOIN " + Tables.DATA
237 + " FROM " + Tables
[all...]
H A DDataRowHandlerForGroupMembership.java31 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
44 String TABLE = Tables.RAW_CONTACTS;
58 "SELECT COUNT(*) FROM " + Tables.DATA + " LEFT OUTER JOIN " + Tables .GROUPS
59 + " ON " + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID
62 + " AND " + Tables.DATA + "." + GroupMembership.RAW_CONTACT_ID + "=?"
106 if (db.update(Tables.RAW_CONTACTS, rawContactValues, SELECTION_RAW_CONTACT_ID,
230 Cursor c = db.query(Tables.GROUPS, Projections.ID,
241 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.java25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
73 " FROM " + Tables.DATA +
84 " FROM " + Tables.DATA +
H A DDataRowHandler.java32 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);
204 final Cursor c = mDbHelper.getReadableDatabase().query(Tables.DATA,
252 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1);
254 db.delete(Tables.PRESENCE, PresenceColumns.RAW_CONTACT_ID + "=?", mSelectionArgs1);
323 final Cursor cursor = db.query(Tables.DATA, null, Data._ID + "=?",
H A DContactsProvider2.java145 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
208 "UPDATE " + Tables.CONTACTS + " SET " + Contacts.TIMES_CONTACTED + "=" +
213 "UPDATE " + Tables.RAW_CONTACTS + " SET " + RawContacts.TIMES_CONTACTED + "=" +
466 = new String[] {Tables.GROUPS + "." + Groups._ID};
474 + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?";
479 + "JOIN " + Tables.ACCOUNTS + " ON ("
502 String TABLE = Tables.RAW_CONTACTS_JOIN_ACCOUNTS;
525 + " FROM " + Tables.RAW_CONTACTS
528 + " FROM " + Tables.DATA_JOIN_MIMETYPES
531 + "(SELECT " + Tables
[all...]
H A DCallLogProvider.java49 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
98 "UPDATE " + Tables.CALLS + " SET " + Calls.PHONE_ACCOUNT_HIDDEN + "=0 WHERE " +
102 "UPDATE " + Tables.CALLS + " SET " + Calls.PHONE_ACCOUNT_HIDDEN + "=0 WHERE " +
204 qb.setTables(Tables.CALLS);
309 mCallsInserter = new DatabaseUtils.InsertHelper(db, Tables.CALLS);
351 return getDatabaseModifier(db).update(Tables.CALLS, values, selectionBuilder.build(),
365 return getDatabaseModifier(db).delete(Tables.CALLS,
387 return new DbModifierWithNotification(Tables.CALLS, db, context());
395 return new DbModifierWithNotification(Tables.CALLS, insertHelper, context());
570 if (DatabaseUtils.queryNumEntries(db, 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) {
/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;
79 + Tables.CALENDAR_ALERTS + " AS ca"
80 + " LEFT OUTER JOIN " + Tables.INSTANCES
83 + " LEFT OUTER JOIN " + Tables.REMINDERS + " AS r ON"
88 + " WHERE " + Tables.INSTANCES + "." + Instances.BEGIN + " ISNULL"
366 + " AS myAlarmTime" + "," + Tables.INSTANCES + "." + Instances.EVENT_ID
369 + Reminders.MINUTES + " FROM " + Tables.INSTANCES + " INNER JOIN " + Views.EVENTS
370 + " ON (" + Views.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "."
371 + Instances.EVENT_ID + ")" + " INNER JOIN " + Tables.REMINDERS + " ON ("
372 + Tables
[all...]
H A DCalendarProvider2.java65 import com.android.providers.calendar.CalendarDatabaseHelper.Tables;
189 Tables.EVENTS_RAW_TIMES + ", " +
190 Tables.EVENTS +
192 CalendarContract.EventsRawTimes.EVENT_ID + " = " + Tables.EVENTS + "." + Events._ID;
195 Tables.EVENTS + " SET " +
201 " FROM " + Tables.EVENTS +
208 + Tables.CALENDARS + " WHERE " + Events.ACCOUNT_NAME + "=? AND " + Events.ACCOUNT_TYPE
218 Tables.EVENTS + "." + Events._ID + "=" + Tables.ATTENDEES + "." + Attendees.EVENT_ID
220 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/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/
H A 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 +
287 "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "("
294 + " FROM " + Tables.PRESENCE
301 + " FROM " + Tables.PRESENCE
310 " FROM " + Tables.RAW_CONTACTS +
315 "DELETE FROM " + Tables
[all...]
H A DContactAggregator2.java41 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
190 final String sql = "SELECT " + RawContacts._ID + " FROM " + Tables.RAW_CONTACTS +
248 Tables.DATA +" WHERE " + Data.IS_SUPER_PRIMARY + " = 1 AND " +
277 String superPrimaryUpdateSql = "UPDATE " + Tables.DATA +
292 " FROM " + Tables.AGGREGATION_EXCEPTIONS +
400 Tables.RAW_CONTACTS + " WHERE " + RawContacts.CONTACT_ID + "=? AND " +
705 + RawContacts.CONTACT_ID + " IN " + Tables.DEFAULT_DIRECTORY;
715 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS;
933 final String TABLE = Tables.DATA + " dataA"
934 + " JOIN " + Tables
[all...]
H A DProfileAggregator.java25 import com.android.providers.contacts.ContactsDatabaseHelper.Tables;
81 " FROM " + Tables.CONTACTS +
H A DContactAggregator.java34 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/apps/Dialer/src/com/android/dialer/database/
H A DDialerDatabaseHelper.java88 public interface Tables { interface in class:DialerDatabaseHelper
212 Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.LAST_TIME_USED + ")";
229 Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.STARRED + " DESC, "
230 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IS_SUPER_PRIMARY + " DESC, "
232 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.TIMES_USED + " DESC, "
233 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IN_VISIBLE_GROUP + " DESC, "
234 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.DISPLAY_NAME_PRIMARY + ", "
235 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.CONTACT_ID + ", "
236 + Tables.SMARTDIAL_TABLE + "." + SmartDialDbColumns.IS_PRIMARY + " DESC";
361 db.execSQL("CREATE TABLE " + Tables
[all...]
/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 2634 milliseconds

12