use of com.pushtorefresh.storio3.contentresolver.queries.Query in project storio by pushtorefresh.
the class DefaultPutResolverTest method update.
/**
* Verifies behavior of {@link DefaultPutResolver} for "update"
*/
@Test
public void update() throws Exception {
final StorIOContentResolver storIOContentResolver = mock(StorIOContentResolver.class);
final StorIOContentResolver.LowLevel lowLevel = mock(StorIOContentResolver.LowLevel.class);
// item with some id, should be updated
final TestItem testItem = new TestItem(1L);
when(storIOContentResolver.lowLevel()).thenReturn(lowLevel);
final Query expectedQuery = Query.builder().uri(TestItem.CONTENT_URI).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 UpdateQuery expectedUpdateQuery = UpdateQuery.builder().uri(TestItem.CONTENT_URI).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 UpdateQuery.builder().uri(TestItem.CONTENT_URI).where(TestItem.COLUMN_ID + " = ?").whereArgs(object.getId()).build();
}
@NonNull
@Override
protected ContentValues mapToContentValues(@NonNull TestItem object) {
try {
return TestItem.MAP_TO_CONTENT_VALUES.apply(object);
} catch (Exception e) {
throw new RuntimeException(e);
}
}
};
final ContentValues expectedContentValues = TestItem.MAP_TO_CONTENT_VALUES.apply(testItem);
// Performing Put that should "update"
final PutResult putResult = putResolver.performPut(storIOContentResolver, testItem);
// checks that it asks db for results
verify(lowLevel, times(1)).query(eq(expectedQuery));
// checks that cursor was closed
verify(cursor, times(1)).close();
// only one query should occur
verify(lowLevel, times(1)).query(any(Query.class));
// checks that required update was performed
verify(lowLevel, times(1)).update(eq(expectedUpdateQuery), eq(expectedContentValues));
// only one update should occur
verify(lowLevel, times(1)).update(any(UpdateQuery.class), any(ContentValues.class));
// no inserts should occur
verify(lowLevel, times(0)).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.insertedUri()).isNull();
}
use of com.pushtorefresh.storio3.contentresolver.queries.Query in project storio by pushtorefresh.
the class DefaultPutResolverTest method insert.
/**
* Verifies behavior of {@link DefaultPutResolver} for "insert"
*/
@Test
public void insert() {
final StorIOSQLite storIOSQLite = mock(StorIOSQLite.class);
final StorIOSQLite.LowLevel lowLevel = mock(StorIOSQLite.LowLevel.class);
// item without id, should be inserted
final TestItem testItem = new TestItem(null);
when(storIOSQLite.lowLevel()).thenReturn(lowLevel);
final Long expectedInsertedId = 24L;
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(// No results -> insert should be performed
0);
when(lowLevel.insert(any(InsertQuery.class), any(ContentValues.class))).thenReturn(expectedInsertedId);
final Set<String> tags = singleton("test_tag");
final InsertQuery expectedInsertQuery = InsertQuery.builder().table(TestItem.TABLE).affectsTags(tags).nullColumnHack(null).build();
final PutResolver<TestItem> putResolver = new DefaultPutResolver<TestItem>() {
@NonNull
@Override
protected InsertQuery mapToInsertQuery(@NonNull TestItem object) {
return expectedInsertQuery;
}
@NonNull
@Override
protected UpdateQuery mapToUpdateQuery(@NonNull TestItem object) {
return UpdateQuery.builder().table(TestItem.TABLE).where(TestItem.COLUMN_ID + " = ?").whereArgs(object.getId()).build();
}
@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 "insert"
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 insert was performed
verify(lowLevel).insert(eq(expectedInsertQuery), eq(expectedContentValues));
// only one insert should occur
verify(lowLevel).insert(any(InsertQuery.class), any(ContentValues.class));
// no updates should occur
verify(lowLevel, never()).update(any(UpdateQuery.class), any(ContentValues.class));
// put result checks
assertThat(putResult.wasInserted()).isTrue();
assertThat(putResult.wasUpdated()).isFalse();
assertThat(putResult.insertedId()).isEqualTo(expectedInsertedId);
assertThat(putResult.numberOfRowsUpdated()).isNull();
assertThat(putResult.affectedTables()).containsExactly(TestItem.TABLE);
assertThat(putResult.affectedTags()).isEqualTo(tags);
}
use of com.pushtorefresh.storio3.contentresolver.queries.Query in project storio by pushtorefresh.
the class DefaultGetResolverTest method query.
@Test
public void query() {
final StorIOSQLite storIOSQLite = mock(StorIOSQLite.class);
final StorIOSQLite.LowLevel lowLevel = mock(StorIOSQLite.LowLevel.class);
final Query query = Query.builder().table("test_table").build();
final Cursor expectedCursor = mock(Cursor.class);
when(storIOSQLite.lowLevel()).thenReturn(lowLevel);
when(lowLevel.query(query)).thenReturn(expectedCursor);
final DefaultGetResolver<TestItem> defaultGetResolver = new DefaultGetResolver<TestItem>() {
@NonNull
@Override
public TestItem mapFromCursor(@NonNull StorIOSQLite storIOSQLite, @NonNull Cursor cursor) {
return mock(TestItem.class);
}
};
final Cursor actualCursor = defaultGetResolver.performGet(storIOSQLite, query);
// only one request should occur
verify(lowLevel, times(1)).query(any(Query.class));
// and this request should be equals to original
verify(lowLevel, times(1)).query(query);
assertThat(actualCursor).isSameAs(expectedCursor);
}
use of com.pushtorefresh.storio3.contentresolver.queries.Query in project storio by pushtorefresh.
the class DefaultGetResolverTest method rawQuery.
@Test
public void rawQuery() {
final StorIOSQLite storIOSQLite = mock(StorIOSQLite.class);
final StorIOSQLite.LowLevel lowLevel = mock(StorIOSQLite.LowLevel.class);
final RawQuery rawQuery = RawQuery.builder().query("test sql").build();
final Cursor expectedCursor = mock(Cursor.class);
when(storIOSQLite.lowLevel()).thenReturn(lowLevel);
when(lowLevel.rawQuery(rawQuery)).thenReturn(expectedCursor);
final DefaultGetResolver<TestItem> defaultGetResolver = new DefaultGetResolver<TestItem>() {
@NonNull
@Override
public TestItem mapFromCursor(@NonNull StorIOSQLite storIOSQLite, @NonNull Cursor cursor) {
return mock(TestItem.class);
}
};
final Cursor actualCursor = defaultGetResolver.performGet(storIOSQLite, rawQuery);
// only one request should occur
verify(lowLevel, times(1)).rawQuery(any(RawQuery.class));
// and this request should be equals to original
verify(lowLevel, times(1)).rawQuery(rawQuery);
assertThat(actualCursor).isSameAs(expectedCursor);
}
use of com.pushtorefresh.storio3.contentresolver.queries.Query in project storio by pushtorefresh.
the class GetNumberOfResultsObserveChangesTest method repeatsOperationWithQueryByChangeOfTag.
@Test
public void repeatsOperationWithQueryByChangeOfTag() {
putUserBlocking();
PreparedGetNumberOfResults operation = storIOSQLite.get().numberOfResults().withQuery(query).prepare();
verifyChangesReceived(operation, tagChanges, 1);
}
Aggregations