Examples with SQLiteOpenHelper android.database.sqlite.SQLiteOpenHelper used on opensource projects

Example 86 with SQLiteOpenHelper

use of android.database.sqlite.SQLiteOpenHelper in project incubator-weex by apache.

the class HistoryManager method buildHistoryItem.

public HistoryItem buildHistoryItem(int number) {
    SQLiteOpenHelper helper = new DBHelper(activity);
    SQLiteDatabase db = null;
    Cursor cursor = null;
    try {
        db = helper.getReadableDatabase();
        cursor = db.query(DBHelper.TABLE_NAME, COLUMNS, null, null, null, null, DBHelper.TIMESTAMP_COL + " DESC");
        cursor.move(number + 1);
        String text = cursor.getString(0);
        String display = cursor.getString(1);
        String format = cursor.getString(2);
        long timestamp = cursor.getLong(3);
        String details = cursor.getString(4);
        Result result = new Result(text, null, null, BarcodeFormat.valueOf(format), timestamp);
        return new HistoryItem(result, display, details);
    } finally {
        close(cursor, db);
    }
}

Example 87 with SQLiteOpenHelper

use of android.database.sqlite.SQLiteOpenHelper in project AppCenter-SDK-Android by Microsoft.

the class DatabaseManagerTest method getDatabaseFailedOnce.

@Test
public void getDatabaseFailedOnce() {
    /* Mocking instances. */
    Context contextMock = mock(Context.class);
    SQLiteOpenHelper helperMock = mock(SQLiteOpenHelper.class);
    when(helperMock.getWritableDatabase()).thenThrow(new RuntimeException()).thenReturn(mock(SQLiteDatabase.class));
    /* Instantiate real instance for DatabaseManager. */
    DatabaseManager databaseManager = new DatabaseManager(contextMock, "database", "table", 1, null, null);
    databaseManager.setSQLiteOpenHelper(helperMock);
    /* Get database. */
    SQLiteDatabase database = databaseManager.getDatabase();
    /* Verify. */
    assertNotNull(database);
    verify(contextMock).deleteDatabase("database");
}

Example 88 with SQLiteOpenHelper

use of android.database.sqlite.SQLiteOpenHelper in project kripton by xcesco.

the class SQLiteUpdateTestDatabase method updateAndVerify.

/**
 * Allow to update database version to <i>version</i>. This method allows to
 * specify the destination version schema and compare it with schema
 * resulting by version update applied.
 *
 * @param version
 * @param schemaDefinitionInputStream
 * @return
 */
public SQLiteUpdateTestDatabase updateAndVerify(int version, final InputStream schemaDefinitionInputStream) {
    sqlite = new SQLiteOpenHelper(context, MIGRATION_TEST, factory, version, errorHandler) {

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            List<SQLiteUpdateTask> task = findTask(oldVersion, newVersion);
            for (SQLiteUpdateTask item : task) {
                item.execute(db, oldVersion, oldVersion + 1);
                oldVersion++;
            }
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            throw (new KriptonRuntimeException("Unsupported situation"));
        }
    };
    SQLiteSchemaVerifierHelper.verifySchema(sqlite.getWritableDatabase(), schemaDefinitionInputStream);
    return this;
}

Example 89 with SQLiteOpenHelper

use of android.database.sqlite.SQLiteOpenHelper in project fdroidclient by f-droid.

the class DatabaseMigration method migrationsFromDbVersion42Onward.

@Test
public void migrationsFromDbVersion42Onward() {
    Preferences.setupForTests(context);
    SQLiteOpenHelper opener = new MigrationRunningOpenHelper(context);
    opener.getReadableDatabase();
    opener.close();
}

Example 90 with SQLiteOpenHelper

use of android.database.sqlite.SQLiteOpenHelper in project AppCenter-SDK-Android by Microsoft.

the class DatabaseManagerTest method failsToDeleteLogDuringPutWhenFull.

@Test
public void failsToDeleteLogDuringPutWhenFull() {
    /* Mocking instances. */
    Context contextMock = mock(Context.class);
    SQLiteOpenHelper helperMock = mock(SQLiteOpenHelper.class);
    SQLiteDatabase sqLiteDatabase = mock(SQLiteDatabase.class);
    when(helperMock.getWritableDatabase()).thenReturn(sqLiteDatabase);
    /* Mock the select cursor we are using to find logs to evict to fail. */
    mockStatic(SQLiteUtils.class);
    Cursor cursor = mock(Cursor.class);
    SQLiteDiskIOException fatalException = new SQLiteDiskIOException();
    when(cursor.moveToNext()).thenThrow(fatalException);
    SQLiteQueryBuilder sqLiteQueryBuilder = mock(SQLiteQueryBuilder.class, new Returns(cursor));
    when(SQLiteUtils.newSQLiteQueryBuilder()).thenReturn(sqLiteQueryBuilder);
    /* Simulate that database is full and that deletes fail because of the cursor. */
    when(sqLiteDatabase.insertOrThrow(anyString(), anyString(), any(ContentValues.class))).thenThrow(new SQLiteFullException());
    /* Instantiate real instance for DatabaseManager. */
    DatabaseManager databaseManager = new DatabaseManager(contextMock, "database", "table", 1, null, null, null);
    databaseManager.setSQLiteOpenHelper(helperMock);
    /* When we put a log, it will fail to purge. */
    assertEquals(-1, databaseManager.put(mock(ContentValues.class), "priority"));
}