Java From.execute方法代码示例

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * Should not change the result if order by is used.
 */
public void testCountOrderBy() {
    cleanTable();
    populateTable();

    From from = new Select()
            .from(MockModel.class)
            .where("intField = ?", 1)
            .orderBy("intField ASC");

    final List<MockModel> list = from.execute();
    final int count = from.count();

    assertEquals(2, count);
    assertEquals(list.size(), count);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * Should return the total number of rows, even if the rows are grouped. May seem weird, just
 * test it in an SQL explorer.
 */
public void testCountGroupBy() {
    cleanTable();
    populateTable();

    From from = new Select()
            .from(MockModel.class)
            .groupBy("intField")
            .having("intField = 1");

    final List<MockModel> list = from.execute();
    final int count = from.count();

    assertEquals(2, count);
    assertEquals(1, list.size());
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * Should not change the result if order by is used.
 */
public void testCountOrderBy() {
    cleanTable();
    populateTable();

    From from = new Select()
            .from(MockModel.class)
            .where("intField = ?", 1)
            .orderBy("intField ASC");

    final List<MockModel> list = from.execute();
    final boolean exists = from.exists();

    assertTrue(exists);
    assertTrue(list.size() > 0);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * 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);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * 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);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
@Override
public List<Audit> getAllAudits(String name, SortCriteria sortCriteria) {
    Timber.v("select all audits name=%s, sortCriteria=%s", name, sortCriteria);
    long now = System.currentTimeMillis();

    From from = new Select()
            .all()
            .from(Audit.class);

    if (StringUtils.isNotBlank(name)) {
        from = from.where(Audit.TABLE_NAME + "." + Audit.COLUMN_NAME + " LIKE ?", "%" + name + "%");
    }

    from = sortCriteria.upgrade(from);
    List<Audit> audits = from.execute();
    for (Audit audit : audits) {
        updateAuditRuleSet(audit);
    }

    Timber.v("select all audits done in %d", System.currentTimeMillis() - now);
    return audits;
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
@Override
public List<Site> searchSites(String noImmo, String name) {
    From from = new Select().from(Site.class);

    if (StringUtils.isNotBlank(noImmo)) {
        from = from.where(Site.COLUMN_NOIMMO + " LIKE ?", "" + noImmo + "%").orderBy(Site.COLUMN_NOIMMO + " ASC");
    }

    if (StringUtils.isNotBlank(name)) {
        from = from.where(Site.COLUMN_NAME + " LIKE ?", "%" + name + "%").orderBy(Site.COLUMN_NAME + " ASC");
    }

    List<Site> sites = from.execute();
    Timber.d("SQL Results : " + sites.size());
    return sites;
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * Should return the same count as there are entries in the result set/table.
 */
public void testCountTable() {
    cleanTable();
    populateTable();

    From from = new Select()
            .from(MockModel.class);

    final List<MockModel> list = from.execute();
    final int count = from.count();

    assertEquals(3, count);
    assertEquals(list.size(), count);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * Should return the same count as there are entries in the result set if the where-clause
 * matches several entries.
 */
public void testCountWhereClause() {
    cleanTable();
    populateTable();

    From from = new Select()
            .from(MockModel.class)
            .where("intField = ?", 1);

    final List<MockModel> list = from.execute();
    final int count = from.count();

    assertEquals(2, count);
    assertEquals(list.size(), count);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * 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);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * 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);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * 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);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
/**
 * Should return {@code false} since the where-clause matches zero rows and thus the result set
 * is empty.
 */
public void testExistsEmptyResult() {
    cleanTable();
    populateTable();

    From from = new Select()
            .from(MockModel.class)
            .where("intField = ?", 3);

    final List<MockModel> list = from.execute();
    final boolean exists = from.exists();

    assertFalse(exists);
    assertFalse(list.size() > 0);
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
@Override
public List<Auditor> searchAuditors(String name) {
    From from = new Select().from(Auditor.class);

    if (StringUtils.isNotBlank(name)) {
        from = from.where(Auditor.COLUMN_USER_NAME + " LIKE ?", "%" + name + "%").orderBy(Auditor.COLUMN_USER_NAME + " ASC");
    }

    return from.execute();
}
 

import com.activeandroid.query.From; //导入方法依赖的package包/类
public static List<Screen> getChildrenOf(long screenId) {
    From where = new Select().from(Screen.class)
            .as("screen")
            .innerJoin(ScreenRelation.class)
            .as("relation")
            .on("screen." + Screen._ID + " = " + "relation.child")
            .where("relation.parent = ?", screenId);
    Log.d(TAG, where.toSql());
    return where
            .execute();
}