de.greenrobot.dao.query.WhereCondition Java Examples

private String getDBLuaFileByVersion(String s)
{
    LuaZipFileDao luazipfiledao = DaoManager.getInstance().getLuaZipFileDao();
    int j = (int)luazipfiledao.count();
    Debug.i("chenee", (new StringBuilder()).append("lzipDao.count:").append(j).toString());
    if (j > 0)
    {
        QueryBuilder querybuilder = luazipfiledao.queryBuilder();
        Property aproperty[] = new Property[1];
        aproperty[0] = de.greenrobot.daobracelet.LuaZipFileDao.Properties.Version;
        querybuilder.orderDesc(aproperty);
        querybuilder.where(de.greenrobot.daobracelet.LuaZipFileDao.Properties.Version.eq(s), new WhereCondition[0]);
        LuaZipFile luazipfile = (LuaZipFile)querybuilder.listLazy().get(0);
        String s1 = luazipfile.getVersion();
        Debug.i("chenee", (new StringBuilder()).append("luaZipFile.version:").append(s1).toString());
        return unzip(luazipfile.getZipFile());
    } else
    {
        Debug.e("chenee", (new StringBuilder()).append("read DB zip failed,version:").append(s).toString());
        return null;
    }
}
 

public int getCount4(WhereCondition wherecondition, WhereCondition wherecondition1, WhereCondition wherecondition2, WhereCondition wherecondition3)
{
    QueryBuilder querybuilder = DaoManager.getInstance().getLuaListDao().queryBuilder();
    querybuilder.where(wherecondition, new WhereCondition[0]);
    if (wherecondition1 != null)
    {
        querybuilder.where(wherecondition1, new WhereCondition[0]);
    }
    if (wherecondition2 != null)
    {
        querybuilder.where(wherecondition2, new WhereCondition[0]);
    }
    if (wherecondition2 != null)
    {
        querybuilder.where(wherecondition2, new WhereCondition[0]);
    }
    return (int)querybuilder.count();
}
 

public void delMsg4(WhereCondition wherecondition, WhereCondition wherecondition1, WhereCondition wherecondition2, WhereCondition wherecondition3)
{
    QueryBuilder querybuilder = DaoManager.getInstance().getLuaListDao().queryBuilder();
    querybuilder.where(wherecondition, new WhereCondition[0]);
    if (wherecondition1 != null)
    {
        querybuilder.where(wherecondition1, new WhereCondition[0]);
    }
    if (wherecondition2 != null)
    {
        querybuilder.where(wherecondition2, new WhereCondition[0]);
    }
    if (wherecondition3 != null)
    {
        querybuilder.where(wherecondition3, new WhereCondition[0]);
    }
    querybuilder.buildDelete().executeDeleteWithoutDetachingEntities();
}
 

public static List getList(AbstractDao dao, Property orderProperty, WhereCondition cond, WhereCondition... condMore) {
    setIfLog();
    List indexFavList = dao.queryBuilder()
            .where(cond, condMore)
            .orderAsc(orderProperty)
            .list();
    return indexFavList;
}
 

public int getCount(WhereCondition wherecondition, WhereCondition wherecondition1)
{
    QueryBuilder querybuilder = DaoManager.getInstance().getLuaListDao().queryBuilder();
    querybuilder.where(wherecondition, new WhereCondition[0]);
    if (wherecondition1 != null)
    {
        querybuilder.where(wherecondition1, new WhereCondition[0]);
    }
    return (int)querybuilder.count();
}
 

public void delMsg(WhereCondition wherecondition, WhereCondition wherecondition1)
{
    QueryBuilder querybuilder = DaoManager.getInstance().getLuaListDao().queryBuilder();
    querybuilder.where(wherecondition, new WhereCondition[0]);
    if (wherecondition1 != null)
    {
        querybuilder.where(wherecondition1, new WhereCondition[0]);
    }
    querybuilder.buildDelete().executeDeleteWithoutDetachingEntities();
}
 

public void refreshList()
{
    LuaListDao lualistdao = DaoManager.getInstance().getLuaListDao();
    String s = getDate();
    QueryBuilder querybuilder = lualistdao.queryBuilder().where(de.greenrobot.daobracelet.LuaListDao.Properties.Date.eq(s), new WhereCondition[0]).where(de.greenrobot.daobracelet.LuaListDao.Properties.Type.notEq("8888"), new WhereCondition[0]).where(de.greenrobot.daobracelet.LuaListDao.Properties.Type.notEq("9999"), new WhereCondition[0]);
    Property aproperty[] = new Property[1];
    aproperty[0] = de.greenrobot.daobracelet.LuaListDao.Properties.Id;
    List list = querybuilder.orderDesc(aproperty).list();
    Collections.sort(list, new MyComparator());
    setList(list);
}
 

/**
 * 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;
}
 

/**
 * @see #getList(de.greenrobot.dao.AbstractDao, de.greenrobot.dao.Property, de.greenrobot.dao.query.WhereCondition, de.greenrobot.dao.query.WhereCondition...)
 * @param dao
 * @param whereCondition
 * @param whereConditions
 * @return
 */
public static List getList(AbstractDao dao, WhereCondition whereCondition, WhereCondition... whereConditions) {
    setIfLog();
    List indexFavList = dao.queryBuilder()
            .where(whereCondition, whereConditions)
            .list();
    return indexFavList;
}
 

public static List getList(AbstractDao dao, WhereCondition cond, WhereCondition... condMore) {
    setIfLog();
    List indexFavList = dao.queryBuilder()
            .where(cond, condMore)
            .list();
    return indexFavList;
}
 

/**
 * 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;
}
 

/**
 * @see #getList(de.greenrobot.dao.AbstractDao, de.greenrobot.dao.Property, de.greenrobot.dao.query.WhereCondition, de.greenrobot.dao.query.WhereCondition...)
 * @param dao
 * @param whereCondition
 * @param whereConditions
 * @return
 */
public static List getList(AbstractDao dao, WhereCondition whereCondition, WhereCondition... whereConditions) {
    setIfLog();
    List indexFavList = dao.queryBuilder()
            .where(whereCondition, whereConditions)
            .list();
    return indexFavList;
}
 

public WhereCondition eq(Object obj)
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, "=?", obj);
}
 

public static QueryBuilder getQueryBuilder(AbstractDao dao, WhereCondition cond, WhereCondition... condmore) {
    setIfLog();
    QueryBuilder qb = dao.queryBuilder();
    qb.where(cond, condmore);
    return qb;
}
 

public static List queryBuilderList(AbstractDao dao, WhereCondition cond, WhereCondition... condmore) {
    return getQueryBuilder(dao, cond, condmore).list();
}
 

public static LazyList queryBuilderLazyList(AbstractDao dao, WhereCondition cond, WhereCondition... condmore) {
    return getQueryBuilder(dao, cond, condmore).listLazy();
}
 

public static QueryBuilder getQueryBuilder(AbstractDao dao, WhereCondition cond, WhereCondition... condmore) {
    setIfLog();
    QueryBuilder qb = dao.queryBuilder();
    qb.where(cond, condmore);
    return qb;
}
 

public static void deleteByCondition(AbstractDao dao, WhereCondition cond, WhereCondition... condmore) {
    setIfLog();
    QueryBuilder qb = dao.queryBuilder();
    qb.where(cond, condmore).buildDelete().executeDeleteWithoutDetachingEntities();

}
 

public static QueryBuilder getQueryBuilder(AbstractDao dao, WhereCondition cond, WhereCondition... condmore) {
    setIfLog();
    QueryBuilder qb = dao.queryBuilder();
    qb.where(cond, condmore);
    return qb;
}
 

public transient WhereCondition notIn(Object aobj[])
{
    StringBuilder stringbuilder = new StringBuilder(" NOT IN (");
    SqlUtils.appendPlaceholders(stringbuilder, aobj.length).append(')');
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, stringbuilder.toString(), aobj);
}
 

public WhereCondition between(Object obj, Object obj1)
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, " BETWEEN ? AND ?", new Object[] {
        obj, obj1
    });
}
 

public WhereCondition ge(Object obj)
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, ">=?", obj);
}
 

public WhereCondition gt(Object obj)
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, ">?", obj);
}
 

public WhereCondition in(Collection collection)
{
    return in(collection.toArray());
}
 

public transient WhereCondition in(Object aobj[])
{
    StringBuilder stringbuilder = new StringBuilder(" IN (");
    SqlUtils.appendPlaceholders(stringbuilder, aobj.length).append(')');
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, stringbuilder.toString(), aobj);
}
 

public WhereCondition isNotNull()
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, " IS NOT NULL");
}
 

public WhereCondition isNull()
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, " IS NULL");
}
 

public WhereCondition le(Object obj)
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, "<=?", obj);
}
 

public WhereCondition like(String s)
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, " LIKE ?", s);
}
 

public WhereCondition lt(Object obj)
{
    return new de.greenrobot.dao.query.WhereCondition.PropertyCondition(this, "<?", obj);
}