use of com.pushtorefresh.storio3.sqlite.operations.put.PutResult in project storio by pushtorefresh.
the class UpdateTest method updateUserBlocking.
private void updateUserBlocking(@NonNull final User userForUpdate) {
final PutResult updateResult = storIOSQLite.put().object(userForUpdate).prepare().executeAsBlocking();
assertThat(updateResult.wasUpdated()).isTrue();
}
use of com.pushtorefresh.storio3.sqlite.operations.put.PutResult in project storio by pushtorefresh.
the class AutoParcelTest method deleteObject.
@Test
public void deleteObject() {
final Book book = Book.builder().id(1).title("What a great book").author("Somebody").build();
final PutResult putResult = storIOSQLite.put().object(book).prepare().executeAsBlocking();
assertThat(putResult.wasInserted()).isTrue();
final DeleteResult deleteResult = storIOSQLite.delete().object(book).prepare().executeAsBlocking();
assertThat(deleteResult.numberOfRowsDeleted()).isEqualTo(1);
final List<Book> storedBooks = storIOSQLite.get().listOfObjects(Book.class).withQuery(Query.builder().table(BookTableMeta.TABLE).build()).prepare().executeAsBlocking();
assertThat(storedBooks).hasSize(0);
}
use of com.pushtorefresh.storio3.sqlite.operations.put.PutResult in project storio by pushtorefresh.
the class CarPersonRelationPutResolver method performPut.
@Override
@NonNull
public PutResult performPut(@NonNull StorIOSQLite storIOSQLite, @NonNull ContentValues contentValues) {
final StorIOSQLite.LowLevel lowLevel = storIOSQLite.lowLevel();
lowLevel.beginTransaction();
try {
final InsertQuery insertQuery = InsertQuery.builder().table(TABLE).build();
final long insertedId = lowLevel.insert(insertQuery, contentValues);
final PutResult putResult = PutResult.newInsertResult(insertedId, insertQuery.table());
lowLevel.setTransactionSuccessful();
return putResult;
} finally {
lowLevel.endTransaction();
}
}
use of com.pushtorefresh.storio3.sqlite.operations.put.PutResult in project storio by pushtorefresh.
the class DefaultPutResolverTest method update.
/**
* Verifies behavior of {@link DefaultPutResolver} for "update"
*/
@Test
public void update() {
final StorIOSQLite storIOSQLite = mock(StorIOSQLite.class);
final StorIOSQLite.LowLevel lowLevel = mock(StorIOSQLite.LowLevel.class);
// item with some id, should be updated
final TestItem testItem = new TestItem(null);
when(storIOSQLite.lowLevel()).thenReturn(lowLevel);
final Query expectedQuery = Query.builder().table(TestItem.TABLE).where(TestItem.COLUMN_ID + " = ?").whereArgs(testItem.getId()).build();
final Cursor cursor = mock(Cursor.class);
when(lowLevel.query(eq(expectedQuery))).thenReturn(cursor);
when(cursor.getCount()).thenReturn(// Some rows already in db -> update should be performed
1);
final Integer expectedNumberOfRowsUpdated = 1;
when(lowLevel.update(any(UpdateQuery.class), any(ContentValues.class))).thenReturn(expectedNumberOfRowsUpdated);
final Set<String> tags = singleton("test_tag");
final UpdateQuery expectedUpdateQuery = UpdateQuery.builder().table(TestItem.TABLE).affectsTags(tags).where(TestItem.COLUMN_ID + " = ?").whereArgs(testItem.getId()).build();
final PutResolver<TestItem> putResolver = new DefaultPutResolver<TestItem>() {
@NonNull
@Override
protected InsertQuery mapToInsertQuery(@NonNull TestItem object) {
fail("Should not be called");
return null;
}
@NonNull
@Override
protected UpdateQuery mapToUpdateQuery(@NonNull TestItem object) {
return expectedUpdateQuery;
}
@NonNull
@Override
protected ContentValues mapToContentValues(@NonNull TestItem object) {
return TestItem.MAP_TO_CONTENT_VALUES.apply(object);
}
};
final ContentValues expectedContentValues = TestItem.MAP_TO_CONTENT_VALUES.apply(testItem);
// Performing Put that should "update"
final PutResult putResult = putResolver.performPut(storIOSQLite, testItem);
verify(lowLevel).beginTransaction();
verify(lowLevel).setTransactionSuccessful();
verify(lowLevel).endTransaction();
// checks that it asks db for results
verify(lowLevel).query(eq(expectedQuery));
// checks that cursor was closed
verify(cursor).close();
// only one query should occur
verify(lowLevel).query(any(Query.class));
// checks that required update was performed
verify(lowLevel).update(eq(expectedUpdateQuery), eq(expectedContentValues));
// only one update should occur
verify(lowLevel).update(any(UpdateQuery.class), any(ContentValues.class));
// no inserts should occur
verify(lowLevel, never()).insert(any(InsertQuery.class), any(ContentValues.class));
// put result checks
assertThat(putResult.wasInserted()).isFalse();
assertThat(putResult.wasUpdated()).isTrue();
assertThat(putResult.numberOfRowsUpdated()).isEqualTo(expectedNumberOfRowsUpdated);
assertThat(putResult.insertedId()).isNull();
assertThat(putResult.affectedTables()).containsExactly(TestItem.TABLE);
assertThat(putResult.affectedTags()).isEqualTo(tags);
}
Aggregations