コード例 #1
0
 public static QueryBuilder getQueryBuilder(
     AbstractDao dao, WhereCondition cond, WhereCondition... condmore) {
   setIfLog();
   QueryBuilder qb = dao.queryBuilder();
   qb.where(cond, condmore);
   return qb;
 }
コード例 #2
0
 /**
  * Executes the query and returns the result as a list containing all entities loaded into memory.
  *
  * @param dao
  * @param orderProperty
  * @param whereCondition
  * @param whereConditions
  * @return
  */
 public static List getList(
     AbstractDao dao,
     Property orderProperty,
     WhereCondition whereCondition,
     WhereCondition... whereConditions) {
   setIfLog();
   List indexFavList =
       dao.queryBuilder().where(whereCondition, whereConditions).orderAsc(orderProperty).list();
   return indexFavList;
 }
コード例 #3
0
 /**
  * Executes the query and returns the result as a list containing all entities loaded into memory.
  *
  * @param dao
  * @param isAsc
  * @param orderProperty
  * @return
  */
 public static List getList(AbstractDao dao, boolean isAsc, Property... orderProperty) {
   setIfLog();
   QueryBuilder queryBuilder = dao.queryBuilder();
   if (isAsc) {
     queryBuilder = queryBuilder.orderAsc(orderProperty);
   } else {
     queryBuilder = queryBuilder.orderDesc(orderProperty);
   }
   List indexFavList = queryBuilder.list();
   return indexFavList;
 }
コード例 #4
0
 /**
  * Deletes all matching entities without detaching them from the identity scope (aka
  * session/cache). Note that this method may lead to stale entity objects in the session cache.
  * Stale entities may be returned when loaded by their primary key, but not using queries.
  *
  * @param dao
  * @param cond
  * @param condmore
  */
 public static void deleteByCondition(
     AbstractDao dao, WhereCondition cond, WhereCondition... condmore) {
   setIfLog();
   QueryBuilder qb = dao.queryBuilder();
   qb.where(cond, condmore).buildDelete().executeDeleteWithoutDetachingEntities();
 }
コード例 #5
0
  /**
   * Creates a repeatable Query object based on the given raw SQL where you can pass any WHERE
   * clause and arguments.
   *
   * @param dao
   * @param queryString
   * @return
   */
  public static Query query(AbstractDao dao, String queryString) {
    // queryString="_ID IN " + "(SELECT USER_ID FROM USER_MESSAGE WHERE READ_FLAG = 0)"

    Query query = dao.queryBuilder().where(new WhereCondition.StringCondition(queryString)).build();
    return query;
  }
コード例 #6
0
 /**
  * @see #getList(de.greenrobot.dao.AbstractDao, de.greenrobot.dao.Property,
  *     de.greenrobot.dao.query.WhereCondition, de.greenrobot.dao.query.WhereCondition...)
  * @param dao
  * @return
  */
 public static List getList(AbstractDao dao) {
   setIfLog();
   List indexFavList = dao.queryBuilder().list();
   return indexFavList;
 }