Java StorIOSQLite类代码示例

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
public synchronized static StorIOSQLite get(Context context) {
    if (INSTANCE != null) {
        return INSTANCE;
    }

    INSTANCE = DefaultStorIOSQLite.builder()
            .sqliteOpenHelper(new StorIODbHelper(context))
            .addTypeMapping(StockUpdate.class, SQLiteTypeMapping.<StockUpdate>builder()
                    .putResolver(new StockUpdatePutResolver())
                    .getResolver(new StockUpdateGetResolver())
                    .deleteResolver(new StockUpdateDeleteResolver())
                    .build())
            .build();

    return INSTANCE;
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
public synchronized static StorIOSQLite get(Context context) {
    if (INSTANCE != null) {
        return INSTANCE;
    }

    INSTANCE = DefaultStorIOSQLite.builder()
            .sqliteOpenHelper(new StorIODbHelper(context))
            .addTypeMapping(StockUpdate.class, SQLiteTypeMapping.<StockUpdate>builder()
                    .putResolver(new StockUpdatePutResolver())
                    .getResolver(createGetResolver())
                    .deleteResolver(createDeleteResolver())
                    .build())
            .build();

    return INSTANCE;
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void shouldPassSQLWithArgsToExecSQL() {
    SQLiteOpenHelper sqLiteOpenHelper = mock(SQLiteOpenHelper.class);
    SQLiteDatabase sqLiteDatabase = mock(SQLiteDatabase.class);
    when(sqLiteOpenHelper.getWritableDatabase("password")).thenReturn(sqLiteDatabase);
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(sqLiteOpenHelper, "password")
            .build();
    RawQuery rawQuery = RawQuery.builder()
            .query("DROP TABLE users")
            .args("arg1", "arg2")
            .build();
    storIOSQLite
            .lowLevel()
            .executeSQL(rawQuery);
    verify(sqLiteOpenHelper).getWritableDatabase("password");
    verify(sqLiteDatabase).execSQL(eq(rawQuery.query()), eq(new String[]{"arg1", "arg2"}));
    verifyNoMoreInteractions(sqLiteOpenHelper, sqLiteDatabase);
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void shouldPassSQLWithoutArgsToExecSQL() {
    SQLiteOpenHelper sqLiteOpenHelper = mock(SQLiteOpenHelper.class);
    SQLiteDatabase sqLiteDatabase = mock(SQLiteDatabase.class);
    when(sqLiteOpenHelper.getWritableDatabase("password")).thenReturn(sqLiteDatabase);
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(sqLiteOpenHelper, "password")
            .build();
    RawQuery rawQuery = RawQuery.builder()
            .query("DROP TABLE IF EXISTS someTable")
            .build(); // No args!
    storIOSQLite
            .lowLevel()
            .executeSQL(rawQuery);
    verify(sqLiteOpenHelper).getWritableDatabase("password");
    verify(sqLiteDatabase).execSQL(eq(rawQuery.query()));
    verifyNoMoreInteractions(sqLiteOpenHelper, sqLiteDatabase);
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void shouldPassArgsToInsertWithOnConflict() {
    SQLiteOpenHelper sqLiteOpenHelper = mock(SQLiteOpenHelper.class);
    SQLiteDatabase sqLiteDatabase = mock(SQLiteDatabase.class);
    when(sqLiteOpenHelper.getWritableDatabase("password")).thenReturn(sqLiteDatabase);
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(sqLiteOpenHelper, "password")
            .build();
    InsertQuery insertQuery = InsertQuery.builder()
            .table("test_table")
            .nullColumnHack("custom_null_hack")
            .build();
    ContentValues contentValues = mock(ContentValues.class);
    int conflictAlgorithm = SQLiteDatabase.CONFLICT_ROLLBACK;
    storIOSQLite.lowLevel().insertWithOnConflict(insertQuery, contentValues, conflictAlgorithm);
    verify(sqLiteDatabase).insertWithOnConflict(
            eq("test_table"),
            eq("custom_null_hack"),
            same(contentValues),
            eq(SQLiteDatabase.CONFLICT_ROLLBACK)
    );
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void notifyAboutChangesShouldNotAcceptNullAsChanges() {
    SQLiteOpenHelper sqLiteOpenHelper = mock(SQLiteOpenHelper.class);
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(sqLiteOpenHelper, "password")
            .build();
    StorIOSQLite.LowLevel lowLevel = storIOSQLite.lowLevel();
    assertThat(lowLevel).isNotNull();
    try {
        //noinspection ConstantConditions
        lowLevel.notifyAboutChanges(null);
        failBecauseExceptionWasNotThrown(NullPointerException.class);
    } catch (NullPointerException expected) {
        assertThat(expected).hasMessage("Changes can not be null");
    }
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void observeChangesAndNotifyAboutChangesShouldWorkCorrectly() {
    SQLiteOpenHelper sqLiteOpenHelper = mock(SQLiteOpenHelper.class);
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(sqLiteOpenHelper, "password")
            .build();
    TestSubscriber<Changes> testSubscriber = new TestSubscriber<>();
    storIOSQLite
            .observeChanges()
            .subscribe(testSubscriber);
    testSubscriber.assertNoValues();
    Changes changes = Changes.newInstance("test_table");
    storIOSQLite
            .lowLevel()
            .notifyAboutChanges(changes);
    testSubscriber.assertValue(changes);
    testSubscriber.assertNoErrors();
    testSubscriber.unsubscribe();
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
public static StorIOSQLite getStorIOSQLite(Context context) {
    if (mStorIOSQLite != null) {
        return mStorIOSQLite;
    }
    mStorIOSQLite = DefaultStorIOSQLite.builder()
        .sqliteOpenHelper(new DbOpenHelper(context))
        .addTypeMapping(Post.class, SQLiteTypeMapping.<Post>builder()
            // object that knows how to perform Put Operation (insert or update)
            .putResolver(new PostStorIOSQLitePutResolver())
            // object that knows how to perform Get Operation
            .getResolver(new PostStorIOSQLiteGetResolver())
            // object that knows how to perform Delete Operation
            .deleteResolver(new PostStorIOSQLiteDeleteResolver())
            .build())
        .addTypeMapping(Comment.class, SQLiteTypeMapping.<Comment>builder()
            .putResolver(new CommentStorIOSQLitePutResolver())
            .getResolver(new CommentStorIOSQLiteGetResolver())
            .deleteResolver(new CommentStorIOSQLiteDeleteResolver())
            .build())
        .build();

    return mStorIOSQLite;
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
public static StorIOSQLite getStorIO(Context context) {
    if (mStorIOSQLite != null) {
        return mStorIOSQLite;
    }

    mStorIOSQLite = DefaultStorIOSQLite.builder()
            .sqliteOpenHelper(new OpenHelper(context))
            .addTypeMapping(HistoryItem.class, SQLiteTypeMapping.<HistoryItem>builder()
                    .putResolver(new HistoryItemStorIOSQLitePutResolver())
                    .getResolver(new HistoryItemStorIOSQLiteGetResolver())
                    .deleteResolver(new HistoryItemStorIOSQLiteDeleteResolver())
                    .build())
    .build();

    return mStorIOSQLite;
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Provides @PerApp StorIOSQLite provideStorIOSQLite(RxBsuirOpenHelper openHelper, Gson gson) {
  return DefaultStorIOSQLite.builder()
      .sqliteOpenHelper(openHelper)
      .addTypeMapping(StudentGroup.class, SQLiteTypeMapping.<StudentGroup>builder().putResolver(
          new StudentGroupStorIOSQLitePutResolver())
          .getResolver(new StudentGroupStorIOSQLiteGetResolver())
          .deleteResolver(new StudentGroupStorIOSQLiteDeleteResolver())
          .build())
      .addTypeMapping(Lesson.class,
          SQLiteTypeMapping.<Lesson>builder().putResolver(new LessonStorIOSQLitePutResolver(gson))
              .getResolver(new LessonStorIOISQLiteGetResolver(gson))
              .deleteResolver(new LessonStorIOSQLiteDeleteResolver())
              .build())
      .addTypeMapping(Employee.class, SQLiteTypeMapping.<Employee>builder().putResolver(
          new EmployeeStorIOSQLitePutResolver(gson))
          .getResolver(new EmployeeStorIOISQLiteGetResolver(gson))
          .deleteResolver(new EmployeeStorIOSQLiteDeleteResolver())
          .build())
      .build();
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void shouldCloseSQLiteOpenHelper() throws IOException {
    SQLiteOpenHelper sqLiteOpenHelper = mock(SQLiteOpenHelper.class);
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(sqLiteOpenHelper, "password")
            .build();
    // Should not call close before explicit call to close
    verify(sqLiteOpenHelper, times(0)).close();
    storIOSQLite.close();
    // Should call close on SQLiteOpenHelper
    verify(sqLiteOpenHelper).close();
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void nestedTransactionShouldWorkNormally() {
    SQLiteOpenHelper sqLiteOpenHelper = mock(SQLiteOpenHelper.class);
    SQLiteDatabase sqLiteDatabase = mock(SQLiteDatabase.class);
    when(sqLiteOpenHelper.getWritableDatabase("password")).thenReturn(sqLiteDatabase);
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(sqLiteOpenHelper, "password")
            .build();
    // External transaction
    storIOSQLite.lowLevel().beginTransaction();
    try {
        try {
            // Nested transaction
            storIOSQLite.lowLevel().beginTransaction();
            storIOSQLite
                    .lowLevel()
                    .notifyAboutChanges(Changes.newInstance("table1"));
            storIOSQLite
                    .lowLevel()
                    .notifyAboutChanges(Changes.newInstance("table2"));
            // Finishing nested transaction
            storIOSQLite.lowLevel().setTransactionSuccessful();
        } finally {
            storIOSQLite.lowLevel().endTransaction();
        }
        // Marking external transaction as successful
        storIOSQLite.lowLevel().setTransactionSuccessful();
    } finally {
        // Finishing external transaction
        storIOSQLite.lowLevel().endTransaction();
    }
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void observeChangesInTablesShouldNotAcceptNullAsTables() {
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(mock(SQLiteOpenHelper.class), "password")
            .build();
    try {
        //noinspection ConstantConditions
        storIOSQLite.observeChangesInTables(null);
        failBecauseExceptionWasNotThrown(NullPointerException.class);
    } catch (NullPointerException expected) {
        assertThat(expected).hasMessage("Set of tables can not be null");
    }
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void observeChangesInTables() {
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(mock(SQLiteOpenHelper.class), "password")
            .build();
    TestSubscriber<Changes> testSubscriber = new TestSubscriber<>();
    Set<String> tables = new HashSet<>(2);
    tables.add("table1");
    tables.add("table2");
    storIOSQLite
            .observeChangesInTables(tables)
            .subscribe(testSubscriber);
    testSubscriber.assertNoValues();
    Changes changes1 = Changes.newInstance("table1");
    storIOSQLite
            .lowLevel()
            .notifyAboutChanges(changes1);
    testSubscriber.assertValue(changes1);
    Changes changes2 = Changes.newInstance("table2");
    storIOSQLite
            .lowLevel()
            .notifyAboutChanges(changes2);
    testSubscriber.assertValues(changes1, changes2);
    Changes changes3 = Changes.newInstance("table3");
    storIOSQLite
            .lowLevel()
            .notifyAboutChanges(changes3);
    // changes3 or any other changes are not expected here
    testSubscriber.assertValues(changes1, changes2);
    testSubscriber.assertNoErrors();
    testSubscriber.unsubscribe();
}
 

import com.pushtorefresh.storio.sqlite.StorIOSQLite; //导入依赖的package包/类
@Test
public void observeChangesInTableShouldNotAcceptNullAsTables() {
    StorIOSQLite storIOSQLite = CipherStoreIO.builder()
            .sqliteOpenHelper(mock(SQLiteOpenHelper.class), "password")
            .build();
    try {
        //noinspection ConstantConditions
        storIOSQLite.observeChangesInTable(null);
        failBecauseExceptionWasNotThrown(NullPointerException.class);
    } catch (NullPointerException expected) {
        assertThat(expected).hasMessage("Table can not be null or empty");
    }
}