TruckViewTableTest.java

package com.truckmuncher.app.data.sql;

import android.database.Cursor;

import com.truckmuncher.app.data.PublicContract;
import com.truckmuncher.testlib.ReadableRobolectricTestRunner;

import org.junit.Test;
import org.junit.runner.RunWith;

import static org.assertj.core.api.Assertions.assertThat;

@RunWith(ReadableRobolectricTestRunner.class)
public class TruckViewTableTest extends DatabaseTableTestCase {

    @Test
    public void allExpectedColumnsExist() {
        String[] projection = new String[]{
                PublicContract.Truck._ID,
                PublicContract.Truck.ID,
                PublicContract.Truck.NAME,
                PublicContract.Truck.IMAGE_URL,
                PublicContract.Truck.KEYWORDS,
                PublicContract.Truck.COLOR_PRIMARY,
                PublicContract.Truck.COLOR_SECONDARY,
                PublicContract.Truck.IS_SERVING,
                PublicContract.Truck.LATITUDE,
                PublicContract.Truck.LONGITUDE,
                PublicContract.Truck.DESCRIPTION,
                PublicContract.Truck.PHONE_NUMBER,
                PublicContract.Truck.WEBSITE,
                PublicContract.Truck.OWNER_ID
        };
        Cursor cursor = db.query(Tables.TRUCK, projection, null, null, null, null, null);
        assertThat(cursor).isNotNull();
        assertThat(cursor.getCount()).isZero();
    }

    @Test
    public void tableHasSameNameAsInSqlScript() {
        assertThat(Tables.TRUCK).isEqualTo("truck");
    }
}