RoboCursorTest.java

package org.robolectric.fakes;

import android.content.ContentResolver;
import android.database.Cursor;
import android.net.Uri;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.robolectric.RuntimeEnvironment;
import org.robolectric.TestRunners;

import static java.util.Arrays.asList;
import static org.assertj.core.api.Assertions.assertThat;
import static org.robolectric.Shadows.shadowOf;

@RunWith(TestRunners.SelfTest.class)
public class RoboCursorTest {
  private static final String STRING_COLUMN = "stringColumn";
  private static final String LONG_COLUMN = "longColumn";
  private static final String INT_COLUMN = "intColumn";
  private static final String BLOB_COLUMN = "blobColumn";
  private static final String SHORT_COLUMN = "shortColumn";
  private static final String FLOAT_COLUMN = "floatColumn";
  private static final String DOUBLE_COLUMN = "doubleColumn";
  private static final String NULL_COLUMN = "nullColumn";

  private final Uri uri = Uri.parse("http://foo");
  private final RoboCursor cursor = new RoboCursor();
  private ContentResolver contentResolver;

  @Before
  public void setup() throws Exception {
    contentResolver = RuntimeEnvironment.application.getContentResolver();
    shadowOf(contentResolver).setCursor(uri, cursor);

    cursor.setColumnNames(asList(
        STRING_COLUMN,
        LONG_COLUMN,
        INT_COLUMN,
        BLOB_COLUMN,
        SHORT_COLUMN,
        FLOAT_COLUMN,
        DOUBLE_COLUMN,
        NULL_COLUMN
    ));
  }

  @Test
  public void query_shouldMakeQueryParamsAvailable() throws Exception {
    contentResolver.query(uri, new String[]{"projection"}, "selection", new String[]{"selection"}, "sortOrder");
    assertThat(cursor.uri).isEqualTo(uri);
    assertThat(cursor.projection[0]).isEqualTo("projection");
    assertThat(cursor.selection).isEqualTo("selection");
    assertThat(cursor.selectionArgs[0]).isEqualTo("selection");
    assertThat(cursor.sortOrder).isEqualTo("sortOrder");
  }

  @Test
  public void getColumnCount_whenSetColumnNamesHasntBeenCalled_shouldReturnCountFromData() throws Exception {
    RoboCursor cursor = new RoboCursor();
    cursor.setResults(new Object[][]{
        new Object[] {1, 2, 3},
        new Object[] {1, 2},
    });
    assertThat(cursor.getColumnCount()).isEqualTo(3);

    cursor.setColumnNames(asList("a", "b", "c", "d"));
    assertThat(cursor.getColumnCount()).isEqualTo(4);
  }

  @Test
  public void getColumnName_shouldReturnColumnName() throws Exception {
    assertThat(cursor.getColumnCount()).isEqualTo(8);
    assertThat(cursor.getColumnName(0)).isEqualTo(STRING_COLUMN);
    assertThat(cursor.getColumnName(1)).isEqualTo(LONG_COLUMN);
  }

  @Test
  public void getType_shouldReturnColumnType() throws Exception {
    cursor.setResults(new Object[][]{new Object[]{
        "aString", 1234L, 42, new byte[]{1, 2, 3}, 255, 1.25f, 2.5d, null
    }});
    assertThat(cursor.getCount()).isEqualTo(1);
    assertThat(cursor.getType(indexOf(STRING_COLUMN))).isEqualTo(Cursor.FIELD_TYPE_STRING);
    assertThat(cursor.getType(indexOf(LONG_COLUMN))).isEqualTo(Cursor.FIELD_TYPE_INTEGER);
    assertThat(cursor.getType(indexOf(INT_COLUMN))).isEqualTo(Cursor.FIELD_TYPE_INTEGER);
    assertThat(cursor.getType(indexOf(BLOB_COLUMN))).isEqualTo(Cursor.FIELD_TYPE_BLOB);
    assertThat(cursor.getType(indexOf(SHORT_COLUMN))).isEqualTo(Cursor.FIELD_TYPE_INTEGER);
    assertThat(cursor.getType(indexOf(FLOAT_COLUMN))).isEqualTo(Cursor.FIELD_TYPE_FLOAT);
    assertThat(cursor.getType(indexOf(DOUBLE_COLUMN))).isEqualTo(Cursor.FIELD_TYPE_FLOAT);
    assertThat(cursor.getType(indexOf(NULL_COLUMN))).isEqualTo(Cursor.FIELD_TYPE_NULL);
  }

  @Test
  public void get_shouldReturnColumnValue() throws Exception {
    cursor.setResults(new Object[][]{new Object[]{
        "aString", 1234L, 42, new byte[]{1, 2, 3}, 255, 1.25f, 2.5d, null
    }});
    assertThat(cursor.getCount()).isEqualTo(1);
    assertThat(cursor.moveToNext()).isTrue();
    assertThat(cursor.getString(indexOf(STRING_COLUMN))).isEqualTo("aString");
    assertThat(cursor.getLong(indexOf(LONG_COLUMN))).isEqualTo(1234L);
    assertThat(cursor.getInt(indexOf(INT_COLUMN))).isEqualTo(42);
    assertThat(cursor.getBlob(indexOf(BLOB_COLUMN))).containsExactly((byte) 1, (byte) 2, (byte) 3);
    assertThat(cursor.getShort(indexOf(SHORT_COLUMN))).isEqualTo((short) 255);
    assertThat(cursor.getFloat(indexOf(FLOAT_COLUMN))).isEqualTo(1.25f);
    assertThat(cursor.getDouble(indexOf(DOUBLE_COLUMN))).isEqualTo(2.5d);
    assertThat(cursor.isNull(indexOf(NULL_COLUMN))).isTrue();
  }

  @Test
  public void get_shouldConvert() throws Exception {
    cursor.setResults(new Object[][]{new Object[]{
        "aString", 1234L, "42", new byte[]{1, 2, 3}, 255, "1.25", 2.5d, null
    }});
    assertThat(cursor.getCount()).isEqualTo(1);
    assertThat(cursor.moveToNext()).isTrue();
    assertThat(cursor.getString(indexOf(INT_COLUMN))).isEqualTo("42");
    assertThat(cursor.getInt(indexOf(INT_COLUMN))).isEqualTo(42);
    assertThat(cursor.getFloat(indexOf(FLOAT_COLUMN))).isEqualTo(1.25f);
    assertThat(cursor.isNull(indexOf(INT_COLUMN))).isFalse();
    assertThat(cursor.isNull(indexOf(FLOAT_COLUMN))).isFalse();
  }

  @Test
  public void moveToNext_advancesToNextRow() throws Exception {
    cursor.setResults(
        new Object[][]{new Object[]{"aString", 1234L, 41},
            new Object[]{"anotherString", 5678L, 42}
        });

    assertThat(cursor.getCount()).isEqualTo(2);
    assertThat(cursor.getType(0)).isEqualTo(Cursor.FIELD_TYPE_STRING);
    assertThat(cursor.getType(1)).isEqualTo(Cursor.FIELD_TYPE_INTEGER);
    assertThat(cursor.moveToNext()).isTrue();
    assertThat(cursor.moveToNext()).isTrue();
    assertThat(cursor.getColumnName(0)).isEqualTo(STRING_COLUMN);
    assertThat(cursor.getColumnName(1)).isEqualTo(LONG_COLUMN);
    assertThat(cursor.getString(indexOf(STRING_COLUMN))).isEqualTo("anotherString");
    assertThat(cursor.getLong(indexOf(LONG_COLUMN))).isEqualTo(5678L);
    assertThat(cursor.getInt(indexOf(INT_COLUMN))).isEqualTo(42);
  }

  @Test
  public void moveToPosition_movesToAppropriateRow() throws Exception {
    cursor.setResults(new Object[][]{new Object[]{"aString", 1234L, 41}, new Object[]{"anotherString", 5678L, 42}});

    assertThat(cursor.moveToPosition(1)).isTrue();
    assertThat(cursor.getString(indexOf(STRING_COLUMN))).isEqualTo("anotherString");
    assertThat(cursor.getLong(indexOf(LONG_COLUMN))).isEqualTo(5678L);
    assertThat(cursor.getInt(indexOf(INT_COLUMN))).isEqualTo(42);

    assertThat(cursor.moveToPosition(0)).isTrue();
    assertThat(cursor.getString(indexOf(STRING_COLUMN))).isEqualTo("aString");
    assertThat(cursor.getLong(indexOf(LONG_COLUMN))).isEqualTo(1234L);
    assertThat(cursor.getInt(indexOf(INT_COLUMN))).isEqualTo(41);
  }

  @Test
  public void moveToPosition_checksBounds() {
    cursor.setResults(new Object[][]{new Object[]{"aString", 1234L, 41}, new Object[]{"anotherString", 5678L, 42}});
    assertThat(cursor.moveToPosition(2)).isFalse();
    assertThat(cursor.moveToPosition(-1)).isFalse();
  }

  @Test
  public void getCount_shouldReturnNumberOfRows() {
    cursor.setResults(new Object[][]{new Object[]{"aString", 1234L, 41}, new Object[]{"anotherString", 5678L, 42}});
    assertThat(cursor.getCount()).isEqualTo(2);
  }

  @Test
  public void close_isRemembered() throws Exception {
    cursor.close();
    assertThat(cursor.getCloseWasCalled()).isTrue();
  }

  @Test
  public void getColumnIndex_shouldReturnColumnIndex() {
    assertThat(indexOf("invalidColumn")).isEqualTo(-1);
    assertThat(indexOf(STRING_COLUMN)).isEqualTo(0);
    assertThat(cursor.getColumnIndexOrThrow(STRING_COLUMN)).isEqualTo(0);
  }

  @Test(expected = IllegalArgumentException.class)
  public void getColumnIndexOrThrow_shouldThrowException() {
    cursor.getColumnIndexOrThrow("invalidColumn");
  }

  @Test
  public void isBeforeFirst_shouldReturnTrueForPosition() {
    cursor.setResults(new Object[][]{new Object[]{"Foo"}});

    assertThat(cursor.isBeforeFirst()).isTrue();
    cursor.moveToPosition(0);
    assertThat(cursor.isBeforeFirst()).isFalse();
  }

  @Test
  public void isAfterLast_shouldReturnTrueForPosition() {
    cursor.setResults(new Object[][]{new Object[]{"Foo"}});

    assertThat(cursor.isAfterLast()).isFalse();
    cursor.moveToPosition(1);
    assertThat(cursor.isAfterLast()).isTrue();
  }

  @Test
  public void isFirst_shouldReturnTrueForPosition() {
    cursor.setResults(new Object[][]{new Object[]{"Foo"}, new Object[]{"Bar"}});

    cursor.moveToPosition(0);
    assertThat(cursor.isFirst()).isTrue();

    cursor.moveToPosition(1);
    assertThat(cursor.isFirst()).isFalse();
  }

  @Test
  public void isLast_shouldReturnTrueForPosition() {
    cursor.setResults(new Object[][]{new Object[]{"Foo"}, new Object[]{"Bar"}});

    cursor.moveToPosition(0);
    assertThat(cursor.isLast()).isFalse();

    cursor.moveToPosition(1);
    assertThat(cursor.isLast()).isTrue();
  }

  private int indexOf(String stringColumn) {
    return cursor.getColumnIndex(stringColumn);
  }
}