Home
last modified time | relevance | path

Searched refs:DatabaseHelper (Results 1 – 25 of 102) sorted by relevance

12345

/packages/apps/Messaging/src/com/android/messaging/datamodel/
DConversationImagePartsView.java23 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns;
24 import com.android.messaging.datamodel.DatabaseHelper.PartColumns;
25 import com.android.messaging.datamodel.DatabaseHelper.ParticipantColumns;
39 + DatabaseHelper.MESSAGES_TABLE + '.' + MessageColumns.CONVERSATION_ID
41 + DatabaseHelper.PARTS_TABLE + '.' + PartColumns.CONTENT_URI
43 + DatabaseHelper.PARTICIPANTS_TABLE + '.' + ParticipantColumns.FULL_NAME
45 + DatabaseHelper.PARTS_TABLE + '.' + PartColumns.CONTENT_URI
49 + DatabaseHelper.PARTS_TABLE + '.' + PartColumns.CONTENT_TYPE
54 + DatabaseHelper.PARTICIPANTS_TABLE + '.' + ParticipantColumns.DISPLAY_DESTINATION
56 + DatabaseHelper.MESSAGES_TABLE + '.' + MessageColumns.RECEIVED_TIMESTAMP
[all …]
DBugleDatabaseOperations.java31 import com.android.messaging.datamodel.DatabaseHelper.ConversationColumns;
32 import com.android.messaging.datamodel.DatabaseHelper.ConversationParticipantsColumns;
33 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns;
34 import com.android.messaging.datamodel.DatabaseHelper.PartColumns;
35 import com.android.messaging.datamodel.DatabaseHelper.ParticipantColumns;
264 + " FROM " + DatabaseHelper.CONVERSATIONS_TABLE in getExistingConversation()
296 cursor = dbWrapper.query(DatabaseHelper.CONVERSATIONS_TABLE, in getThreadId()
331 cursor = db.query(DatabaseHelper.PARTICIPANTS_TABLE, in isBlockedParticipant()
404 final long conversationRowId = dbWrapper.insert(DatabaseHelper.CONVERSATIONS_TABLE, null, in createConversationInTransaction()
479 dbWrapper.delete(DatabaseHelper.MESSAGES_TABLE, in deleteConversation()
[all …]
DDatabaseUpgradeHelper.java41 DatabaseHelper.rebuildTables(db); in doOnUpgrade()
53 DatabaseHelper.dropAllViews(db); in doUpgradeWithExceptions()
54 DatabaseHelper.rebuildAllViews(new DatabaseWrapper(context, db)); in doUpgradeWithExceptions()
60 db.execSQL("ALTER TABLE " + DatabaseHelper.CONVERSATIONS_TABLE + " ADD COLUMN " + in upgradeToVersion2()
61 DatabaseHelper.ConversationColumns.IS_ENTERPRISE + " INT DEFAULT(0)"); in upgradeToVersion2()
93 DatabaseHelper.rebuildTables(db); in onDowngrade()
DMessagingContentProvider.java31 import com.android.messaging.datamodel.DatabaseHelper.ConversationColumns;
32 import com.android.messaging.datamodel.DatabaseHelper.ConversationParticipantsColumns;
33 import com.android.messaging.datamodel.DatabaseHelper.ParticipantColumns;
65 static final Uri PARTS_URI = Uri.parse(CONTENT_AUTHORITY + DatabaseHelper.PARTS_TABLE);
240 private DatabaseHelper mDatabaseHelper;
295 queryBuilder.setTables(DatabaseHelper.PARTICIPANTS_TABLE); in query()
301 + " FROM " + DatabaseHelper.CONVERSATION_PARTICIPANTS_TABLE in query()
304 + DatabaseHelper.PARTICIPANTS_TABLE + " WHERE " in query()
314 queryBuilder.setTables(DatabaseHelper.PARTICIPANTS_TABLE); in query()
403 protected DatabaseHelper getDatabase() { in getDatabase()
[all …]
DNotificationState.java22 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns;
54 DatabaseHelper.MessageColumns.SEEN + " = 0)";
56 static final String FAILED_ORDER_BY = DatabaseHelper.MessageColumns.CONVERSATION_ID + ", " +
57 DatabaseHelper.MessageColumns.SENT_TIMESTAMP + " asc";
DParticipantRefresh.java30 import com.android.messaging.datamodel.DatabaseHelper.ConversationColumns;
31 import com.android.messaging.datamodel.DatabaseHelper.ConversationParticipantsColumns;
32 import com.android.messaging.datamodel.DatabaseHelper.ParticipantColumns;
263 cursor = db.query(DatabaseHelper.PARTICIPANTS_TABLE, in refreshParticipants()
319 cursor = db.query(DatabaseHelper.PARTICIPANTS_TABLE, in getExistingSubIds()
338 "UPDATE " + DatabaseHelper.PARTICIPANTS_TABLE + " SET "
375 db.execSQL(DatabaseHelper.getCreateSelfParticipantSql(subId)); in refreshSelfParticipantList()
617 db.update(DatabaseHelper.PARTICIPANTS_TABLE, values, ParticipantColumns._ID + "=?", in updateParticipant()
636 cursor = db.query(DatabaseHelper.PARTICIPANTS_TABLE, in getInactiveSelfParticipantIds()
674 cursor = db.query(DatabaseHelper.CONVERSATIONS_TABLE, in getConversationsWithSelfParticipantIds()
DDatabaseHelper.java45 public class DatabaseHelper extends SQLiteOpenHelper { class
569 private static DatabaseHelper sHelperInstance; // Protected by sLock.
582 public static DatabaseHelper getInstance(final Context context) { in getInstance()
585 sHelperInstance = new DatabaseHelper(context); in getInstance()
596 private DatabaseHelper(final Context context) { in DatabaseHelper() method in DatabaseHelper
608 static DatabaseHelper getNewInstanceForTest(final Context context) { in getNewInstanceForTest()
610 return new DatabaseHelper(context); in getNewInstanceForTest()
678 for (final String sql : DatabaseHelper.CREATE_VIEW_SQLS) { in rebuildAllViews()
/packages/apps/Messaging/src/com/android/messaging/datamodel/data/
DConversationListItemData.java24 import com.android.messaging.datamodel.DatabaseHelper;
25 import com.android.messaging.datamodel.DatabaseHelper.ConversationColumns;
26 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns;
27 import com.android.messaging.datamodel.DatabaseHelper.ParticipantColumns;
293 DatabaseHelper.CONVERSATIONS_TABLE + '.' + ConversationColumns._ID
295 + DatabaseHelper.CONVERSATIONS_TABLE + '.' + ConversationColumns.NAME
297 + DatabaseHelper.CONVERSATIONS_TABLE + '.' + ConversationColumns.CURRENT_SELF_ID
299 + DatabaseHelper.CONVERSATIONS_TABLE + '.' + ConversationColumns.ARCHIVE_STATUS
301 + DatabaseHelper.MESSAGES_TABLE + '.' + MessageColumns.READ
303 + DatabaseHelper.CONVERSATIONS_TABLE + '.' + ConversationColumns.ICON
[all …]
DConversationMessageData.java25 import com.android.messaging.datamodel.DatabaseHelper;
26 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns;
27 import com.android.messaging.datamodel.DatabaseHelper.PartColumns;
28 import com.android.messaging.datamodel.DatabaseHelper.ParticipantColumns;
627 + DatabaseHelper.MESSAGES_TABLE + "." + MessageColumns.CONVERSATION_ID + "=?)" in getConversationMessagesQuerySql()
635 + DatabaseHelper.MESSAGES_TABLE + "." + MessageColumns.CONVERSATION_ID + "=?)" in getConversationMessageIdsQuerySql()
642 + "(" + DatabaseHelper.MessageColumns.STATUS + " in (" in getNotificationQuerySql()
646 + DatabaseHelper.MessageColumns.SEEN + " = 0)" in getNotificationQuerySql()
654 + DatabaseHelper.MESSAGES_TABLE + "." + MessageColumns.CONVERSATION_ID + "=?" in getWearableQuerySql()
656 + DatabaseHelper.MessageColumns.STATUS + " IN (" in getWearableQuerySql()
[all …]
/packages/apps/DocumentsUI/src/com/android/documentsui/queries/
DSearchHistoryManager.java49 DatabaseHelper.COLUMN_KEYWORD, DatabaseHelper.COLUMN_LAST_UPDATED_TIME
53 private final DatabaseHelper mHelper;
65 mHelper = new DatabaseHelper(context); in SearchHistoryManager()
86 private static class DatabaseHelper extends SQLiteOpenHelper { class in SearchHistoryManager
94 private DatabaseHelper(Context context) { in DatabaseHelper() method in SearchHistoryManager.DatabaseHelper
196 queryBuilder.setTables(DatabaseHelper.HISTORY_TABLE); in getSortedHistoryList()
199 null, null, null, DatabaseHelper.COLUMN_LAST_UPDATED_TIME + " DESC"); in getSortedHistoryList()
204 values.put(DatabaseHelper.COLUMN_KEYWORD, mKeyword); in addDatabaseData()
205 values.put(DatabaseHelper.COLUMN_LAST_UPDATED_TIME, System.currentTimeMillis()); in addDatabaseData()
208 DatabaseHelper.HISTORY_TABLE, null, values); in addDatabaseData()
[all …]
/packages/providers/MediaProvider/tests/src/com/android/providers/media/
DDatabaseHelperTest.java21 import static com.android.providers.media.DatabaseHelper.TEST_CLEAN_DB;
22 import static com.android.providers.media.DatabaseHelper.TEST_DOWNGRADE_DB;
23 import static com.android.providers.media.DatabaseHelper.TEST_UPGRADE_DB;
24 import static com.android.providers.media.DatabaseHelper.makePristineSchema;
83 try (DatabaseHelper helper = new DatabaseHelperU(sIsolatedContext, TEST_CLEAN_DB)) { in testFilterVolumeNames()
165 try (DatabaseHelper helper = new DatabaseHelperR(sIsolatedContext, TEST_CLEAN_DB)) { in testArtistsAndAlbumsIncludeOnlyMusic()
227 try (DatabaseHelper helper = new DatabaseHelperR(sIsolatedContext, TEST_CLEAN_DB)) { in testTransactions()
256 private void assertDowngrade(Class<? extends DatabaseHelper> before, in assertDowngrade()
257 Class<? extends DatabaseHelper> after) throws Exception { in assertDowngrade()
258 try (DatabaseHelper helper = before.getConstructor(Context.class, String.class) in assertDowngrade()
[all …]
DDatabaseBackupAndRecoveryTest.java19 import static com.android.providers.media.DatabaseHelper.INTERNAL_DB_NEXT_ROW_ID_XATTR_KEY;
20 import static com.android.providers.media.DatabaseHelper.INTERNAL_DB_NEXT_ROW_ID_XATTR_KEY_PREFIX;
21 import static com.android.providers.media.DatabaseHelper.INTERNAL_DB_SESSION_ID_XATTR_KEY;
/packages/apps/Messaging/src/com/android/messaging/datamodel/action/
DProcessPendingMessagesAction.java29 import com.android.messaging.datamodel.DatabaseHelper;
30 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns;
329 sendingCnt = (int) db.queryNumEntries(DatabaseHelper.MESSAGES_TABLE, in findNextMessageToSend()
330 DatabaseHelper.MessageColumns.STATUS + " IN (?, ?) AND " in findNextMessageToSend()
331 + DatabaseHelper.MessageColumns.SELF_PARTICIPANT_ID + " =? ", in findNextMessageToSend()
339 cursor = db.query(DatabaseHelper.MESSAGES_TABLE, in findNextMessageToSend()
341 DatabaseHelper.MessageColumns.STATUS + " IN (?, ?) AND " in findNextMessageToSend()
342 + DatabaseHelper.MessageColumns.SELF_PARTICIPANT_ID + " =? ", in findNextMessageToSend()
350 DatabaseHelper.MessageColumns.RECEIVED_TIMESTAMP + " ASC"); in findNextMessageToSend()
354 values.put(DatabaseHelper.MessageColumns.STATUS, in findNextMessageToSend()
[all …]
DFixupMessageStatusOnStartupAction.java24 import com.android.messaging.datamodel.DatabaseHelper;
61 values.put(DatabaseHelper.MessageColumns.STATUS, in executeAction()
63 downloadFailedCnt = db.update(DatabaseHelper.MESSAGES_TABLE, values, in executeAction()
64 DatabaseHelper.MessageColumns.STATUS + " IN (?, ?)", in executeAction()
71 values.put(DatabaseHelper.MessageColumns.STATUS, in executeAction()
73 sendFailedCnt = db.update(DatabaseHelper.MESSAGES_TABLE, values, in executeAction()
74 DatabaseHelper.MessageColumns.STATUS + " IN (?, ?)", in executeAction()
DMarkAsSeenAction.java26 import com.android.messaging.datamodel.DatabaseHelper;
27 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns;
83 final int count = db.update(DatabaseHelper.MESSAGES_TABLE, values, in executeAction()
91 db.update(DatabaseHelper.MESSAGES_TABLE, values, in executeAction()
DUpdateMessagePartSizeAction.java25 import com.android.messaging.datamodel.DatabaseHelper;
27 import com.android.messaging.datamodel.DatabaseHelper.PartColumns;
72 BugleDatabaseOperations.updateRowIfExists(db, DatabaseHelper.PARTS_TABLE, in executeAction()
/packages/providers/MediaProvider/tests/src/com/android/providers/media/photopicker/data/
DExternalDbFacadeTest.java56 import com.android.providers.media.DatabaseHelper;
114 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testDeletedMedia_addAndRemove()
200 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testDeletedMedia_onInsert()
237 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testDeletedMedia_onUpdate_mediaType()
315 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testDeletedMedia_onUpdate_trashed()
367 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testDeletedMedia_onUpdate_pending()
419 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testOnUpdate_visibleFavorite()
455 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testOnUpdate_hiddenFavorite()
491 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testOnUpdate_visibleSpecialFormat()
527 try (DatabaseHelper helper = new TestDatabaseHelper(sIsolatedContext)) { in testOnUpdate_hiddenSpecialFormat()
[all …]
/packages/modules/HealthFitness/service/java/com/android/server/healthconnect/storage/datatypehelpers/
DDatabaseHelper.java32 public abstract class DatabaseHelper { class
34 private static Set<DatabaseHelper> getDatabaseHelpers() { in getDatabaseHelpers()
53 for (DatabaseHelper databaseHelper : getDatabaseHelpers()) { in clearAllData()
60 for (DatabaseHelper databaseHelper : getDatabaseHelpers()) { in clearAllCache()
/packages/apps/Messaging/tests/src/com/android/messaging/datamodel/data/
DTestDataFactory.java28 import com.android.messaging.datamodel.DatabaseHelper;
29 import com.android.messaging.datamodel.DatabaseHelper.ConversationColumns;
30 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns;
31 import com.android.messaging.datamodel.DatabaseHelper.PartColumns;
32 import com.android.messaging.datamodel.DatabaseHelper.ParticipantColumns;
302 final long conversationId = db.insert(DatabaseHelper.CONVERSATIONS_TABLE, null, in createTestData()
313 … final long messageId = db.insert(DatabaseHelper.MESSAGES_TABLE, null, messageValues); in createTestData()
321 db.insert(DatabaseHelper.PARTS_TABLE, null, partValues); in createTestData()
326 final int updatedCount = db.update(DatabaseHelper.CONVERSATIONS_TABLE, in createTestData()
/packages/providers/TvProvider/tests/src/com/android/providers/tv/
DTvProviderForTesting.java30 DatabaseHelper mDatabaseHelper;
66 DatabaseHelper getDatabaseHelper() { in getDatabaseHelper()
75 mDatabaseHelper = DatabaseHelper.getInstance(getContext()); in insertWatchedProgramSync()
82 private static class DatabaseHelperForTesting extends TvProvider.DatabaseHelper {
/packages/providers/TvProvider/src/com/android/providers/tv/
DTransientRowHelper.java29 import com.android.providers.tv.TvProvider.DatabaseHelper;
41 private DatabaseHelper mDatabaseHelper;
62 mDatabaseHelper = DatabaseHelper.getInstance(context); in TransientRowHelper()
66 TransientRowHelper(Context context, DatabaseHelper databaseHelper) { in TransientRowHelper()
DTvProviderUpgradeReceiver.java29 import com.android.providers.tv.TvProvider.DatabaseHelper;
68 DatabaseHelper helper = DatabaseHelper.getInstance(context); in onReceive()
/packages/providers/MediaProvider/src/com/android/providers/media/
DDatabaseBackupAndRecovery.java19 import static com.android.providers.media.DatabaseHelper.DATA_MEDIA_XATTR_DIRECTORY_PATH;
20 import static com.android.providers.media.DatabaseHelper.EXTERNAL_DB_NEXT_ROW_ID_XATTR_KEY_PREFIX;
21 import static com.android.providers.media.DatabaseHelper.EXTERNAL_DB_SESSION_ID_XATTR_KEY_PREFIX;
22 import static com.android.providers.media.DatabaseHelper.INTERNAL_DB_NEXT_ROW_ID_XATTR_KEY_PREFIX;
23 import static com.android.providers.media.DatabaseHelper.INTERNAL_DB_SESSION_ID_XATTR_KEY_PREFIX;
322 public void backupDatabases(DatabaseHelper internalDatabaseHelper, in backupDatabases()
323 DatabaseHelper externalDatabaseHelper, CancellationSignal signal) { in backupDatabases()
357 protected synchronized void backupInternalDatabase(DatabaseHelper internalDbHelper, in backupInternalDatabase()
398 protected synchronized void backupExternalDatabase(DatabaseHelper externalDbHelper, in backupExternalDatabase()
532 protected void updateNextRowIdXattr(DatabaseHelper helper, long id) { in updateNextRowIdXattr()
[all …]
/packages/apps/DocumentsUI/src/com/android/documentsui/picker/
DPickCountRecordProvider.java68 private PickCountRecordProvider.DatabaseHelper mHelper;
70 private static class DatabaseHelper extends SQLiteOpenHelper { class in PickCountRecordProvider
75 public DatabaseHelper(Context context) { in DatabaseHelper() method in PickCountRecordProvider.DatabaseHelper
96 mHelper = new DatabaseHelper(getContext()); in onCreate()
/packages/apps/Launcher3/tests/src/com/android/launcher3/model/
DDbDowngradeHelperTest.java76 assertEquals(DatabaseHelper.SCHEMA_VERSION, DbDowngradeHelper.parse(mSchemaFile).version); in testDowngradeSchemaMatchesVersion()
147 assertEquals(DatabaseHelper.SCHEMA_VERSION, in testDowngrade_success_v22()
166 DbDowngradeHelper.updateSchemaFile(mSchemaFile, DatabaseHelper.SCHEMA_VERSION, mContext); in setupTestDb()
168 DatabaseHelper dbHelper = new MyDatabaseHelper(); in setupTestDb()
223 private class MyDatabaseHelper extends DatabaseHelper {

12345