Examples with Select com.activeandroid.query.Select used on opensource projects

Example 6 with Select

use of com.activeandroid.query.Select in project ActiveAndroid by pardom.

the class CountTest method testCountEmptyResult.

/**
     * Should return the same count as there are entries in the result set if the where-clause
     * matches zero entries.
     */
public void testCountEmptyResult() {
    cleanTable();
    populateTable();
    From from = new Select().from(MockModel.class).where("intField = ?", 3);
    final List<MockModel> list = from.execute();
    final int count = from.count();
    assertEquals(0, count);
    assertEquals(list.size(), count);
}

Example 7 with Select

use of com.activeandroid.query.Select in project ActiveAndroid by pardom.

the class ExistsTest method testCountGroupBy.

/**
     * Should not change the result if group by is used.
     */
public void testCountGroupBy() {
    cleanTable();
    populateTable();
    From from = new Select().from(MockModel.class).groupBy("intField").having("intField = 1");
    final List<MockModel> list = from.execute();
    final boolean exists = from.exists();
    assertTrue(exists);
    assertTrue(list.size() > 0);
}

Example 8 with Select

use of com.activeandroid.query.Select in project ActiveAndroid by pardom.

the class ExistsTest method testCountGroupByEmpty.

/**
     * Should not exist if group by eliminates all rows.
     */
public void testCountGroupByEmpty() {
    cleanTable();
    populateTable();
    From from = new Select().from(MockModel.class).groupBy("intField").having("intField = 3");
    final List<MockModel> list = from.execute();
    final boolean exists = from.exists();
    assertFalse(exists);
    assertFalse(list.size() > 0);
}

Example 9 with Select

use of com.activeandroid.query.Select in project ActiveAndroid by pardom.

the class ExistsTest method testExistsWhereClause.

/**
     * Should return {@code true} since the where-clause matches rows and thus the result set isn't
     * empty.
     */
public void testExistsWhereClause() {
    cleanTable();
    populateTable();
    From from = new Select().from(MockModel.class).where("intField = ?", 1);
    final List<MockModel> list = from.execute();
    final boolean exists = from.exists();
    assertTrue(exists);
    assertTrue(list.size() > 0);
}

Example 10 with Select

use of com.activeandroid.query.Select in project ActiveAndroid by pardom.

the class ExistsTest method testExistsTable.

/**
     * Should return {@code true} since the result set/table isn't empty.
     */
public void testExistsTable() {
    cleanTable();
    populateTable();
    From from = new Select().from(MockModel.class);
    final List<MockModel> list = from.execute();
    final boolean exists = from.exists();
    assertTrue(exists);
    assertTrue(list.size() > 0);
}