org.greenrobot.greendao.query.Query Java Examples

@Test
public void findAllByTitleDesc() {
    LocalKino anotherKino = mock(LocalKino.class);
    doReturn("Banane").when(localKino).getTitle();
    doReturn("Poney").when(anotherKino).getTitle();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino, anotherKino)).when(query).list();

    assertEquals(
            Arrays.asList(anotherKino, localKino),
            new LocalKinoRepository(daoSession).findAllByTitle(false)
    );
}
 

@Test
public void findAllByTitleDesc() {
    Review aReview = mock(Review.class);
    Review anotherReview = mock(Review.class);
    //noinspection ResultOfMethodCallIgnored
    doReturn("Banane").when(aReview).getTitle();
    //noinspection ResultOfMethodCallIgnored
    doReturn("Pingouin").when(anotherReview).getTitle();

    SerieReview aSerieReview = mock(SerieReview.class);
    doReturn(anotherReview).when(serieReview).getReview();
    doReturn(aReview).when(aSerieReview).getReview();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(serieReviewDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(serieReview, aSerieReview)).when(query).list();

    assertEquals(
            Arrays.asList(serieReview, aSerieReview),
            new SerieReviewRepository(daoSession).findAllByTitle(false)
    );
}
 

@Test
public void findAllByTitleAsc() {
    Review aReview = mock(Review.class);
    Review anotherReview = mock(Review.class);
    //noinspection ResultOfMethodCallIgnored
    doReturn("Banane").when(aReview).getTitle();
    //noinspection ResultOfMethodCallIgnored
    doReturn("Pingouin").when(anotherReview).getTitle();

    SerieReview aSerieReview = mock(SerieReview.class);
    doReturn(anotherReview).when(serieReview).getReview();
    doReturn(aReview).when(aSerieReview).getReview();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(serieReviewDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(serieReview, aSerieReview)).when(query).list();

    assertEquals(
            Arrays.asList(aSerieReview, serieReview),
            new SerieReviewRepository(daoSession).findAllByTitle(true)
    );
}
 

@Test
public void findByMovieId() {
    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(serieReviewDao).queryBuilder();
    doReturn(queryBuilder).when(queryBuilder).where(any(WhereCondition.class));
    doReturn(queryBuilder).when(queryBuilder).limit(1);

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Collections.singletonList(serieReview)).when(query).list();

    assertEquals(
            serieReview,
            new SerieReviewRepository(daoSession).findByMovieId(45)
    );

}
 

@Test
public void findByMovieId() {
    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(wishlistMovieDao).queryBuilder();
    doReturn(queryBuilder).when(queryBuilder).where(any(WhereCondition.class));
    doReturn(queryBuilder).when(queryBuilder).limit(1);

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Collections.singletonList(wishlistMovie)).when(query).list();

    assertEquals(
            wishlistMovie,
            new WishlistMovieRepository(daoSession).findByTmdbId(45)
    );

}
 

@Test
public void findBySerieId() {
    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(wishlistSerieDao).queryBuilder();
    doReturn(queryBuilder).when(queryBuilder).where(any(WhereCondition.class));
    doReturn(queryBuilder).when(queryBuilder).limit(1);

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Collections.singletonList(wishlistSerie)).when(query).list();

    assertEquals(
            wishlistSerie,
            new WishlistSerieRepository(daoSession).findByTmdbId(45)
    );

}
 

@Test
public void findByMovieId() {
    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();
    doReturn(queryBuilder).when(queryBuilder).where(any(WhereCondition.class));//LocalKinoDao.Properties.Tmdb_id.eq(45));
    doReturn(queryBuilder).when(queryBuilder).limit(1);

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino)).when(query).list();

    assertEquals(
            localKino,
            new LocalKinoRepository(daoSession).findByMovieId(45)
    );

}
 

@Test
public void findAllByTitleDescNullO2() {
    LocalKino anotherKino = mock(LocalKino.class);
    doReturn(null).when(anotherKino).getTitle();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino, anotherKino)).when(query).list();

    assertEquals(
            Arrays.asList(localKino, anotherKino),
            new LocalKinoRepository(daoSession).findAllByTitle(false)
    );
}
 

@Test
public void findAllByTitleDescNullO1() {
    LocalKino anotherKino = mock(LocalKino.class);
    doReturn(null).when(localKino).getTitle();
    doReturn("Poney").when(anotherKino).getTitle();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino, anotherKino)).when(query).list();

    assertEquals(
            Arrays.asList(anotherKino, localKino),
            new LocalKinoRepository(daoSession).findAllByTitle(false)
    );
}
 

@Test
public void findAllByTitleAscNullO2() {
    LocalKino anotherKino = mock(LocalKino.class);
    doReturn(null).when(anotherKino).getTitle();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino, anotherKino)).when(query).list();

    assertEquals(
            Arrays.asList(anotherKino, localKino),
            new LocalKinoRepository(daoSession).findAllByTitle(true)
    );
}
 

@Test
public void findAllByTitleAscNullO1() {
    LocalKino anotherKino = mock(LocalKino.class);
    doReturn(null).when(localKino).getTitle();
    doReturn("Poney").when(anotherKino).getTitle();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino, anotherKino)).when(query).list();

    assertEquals(
            Arrays.asList(localKino, anotherKino),
            new LocalKinoRepository(daoSession).findAllByTitle(true)
    );
}
 

@Test
public void findAllByTitleAsc() {
    LocalKino anotherKino = mock(LocalKino.class);
    doReturn("Banane").when(localKino).getTitle();
    doReturn("Poney").when(anotherKino).getTitle();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino, anotherKino)).when(query).list();

    assertEquals(
            Arrays.asList(localKino, anotherKino),
            new LocalKinoRepository(daoSession).findAllByTitle(true)
    );
}
 

@Test
public void findAllByYearDesc() {
    TmdbKino oldTmdbKino = mock(TmdbKino.class);
    TmdbKino recentTmdbKino = mock(TmdbKino.class);
    //noinspection ResultOfMethodCallIgnored
    doReturn(1987).when(oldTmdbKino).getYear();
    //noinspection ResultOfMethodCallIgnored
    doReturn(2012).when(recentTmdbKino).getYear();

    LocalKino oldLocalKino = mock(LocalKino.class);
    doReturn(recentTmdbKino).when(localKino).getKino();
    doReturn(oldTmdbKino).when(oldLocalKino).getKino();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino, oldLocalKino)).when(query).list();

    assertEquals(
            Arrays.asList(localKino, oldLocalKino),
            new LocalKinoRepository(daoSession).findAllByYear(false)
    );
}
 

@Test
public void findAllByYearAsc() {
    TmdbKino oldTmdbKino = mock(TmdbKino.class);
    TmdbKino recentTmdbKino = mock(TmdbKino.class);
    //noinspection ResultOfMethodCallIgnored
    doReturn(1987).when(oldTmdbKino).getYear();
    //noinspection ResultOfMethodCallIgnored
    doReturn(2012).when(recentTmdbKino).getYear();

    LocalKino oldLocalKino = mock(LocalKino.class);
    doReturn(recentTmdbKino).when(localKino).getKino();
    doReturn(oldTmdbKino).when(oldLocalKino).getKino();

    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino, oldLocalKino)).when(query).list();

    assertEquals(
            Arrays.asList(oldLocalKino, localKino),
            new LocalKinoRepository(daoSession).findAllByYear(true)
    );
}
 

@Test
public void findAllByReviewDateDesc() {
    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();
    doReturn(queryBuilder).when(queryBuilder).orderDesc(LocalKinoDao.Properties.Review_date);

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Collections.singletonList(localKino)).when(query).list();

    assertEquals(
            Collections.singletonList(localKino),
            new LocalKinoRepository(daoSession).findAllByReviewDate(false)
    );
}
 

@Test
public void findAllByReviewDateAsc() {
    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();
    doReturn(queryBuilder).when(queryBuilder).orderAsc(LocalKinoDao.Properties.Review_date);

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Collections.singletonList(localKino)).when(query).list();

    assertEquals(
            Collections.singletonList(localKino),
            new LocalKinoRepository(daoSession).findAllByReviewDate(true)
    );
}
 

@Test
public void findAllByRatingDesc() {
    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();
    doReturn(queryBuilder).when(queryBuilder).orderDesc(LocalKinoDao.Properties.Rating);

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino)).when(query).list();

    assertEquals(
            Arrays.asList(localKino),
            new LocalKinoRepository(daoSession).findAllByRating(false)
    );
}
 

@Test
public void findAllByRatingAsc() {
    QueryBuilder queryBuilder = mock(QueryBuilder.class);
    doReturn(queryBuilder).when(localKinoDao).queryBuilder();
    doReturn(queryBuilder).when(queryBuilder).orderAsc(LocalKinoDao.Properties.Rating);

    Query query = mock(Query.class);
    doReturn(query).when(queryBuilder).build();

    doReturn(Arrays.asList(localKino)).when(query).list();

    assertEquals(
            Arrays.asList(localKino),
            new LocalKinoRepository(daoSession).findAllByRating(true)
    );
}
 

public static List<NewsChannelTable> loadNewsChannelsWithin(int from, int to) {
        Query<NewsChannelTable> newsChannelTableQuery = MyApplication.getDaoSession().getNewsChannelTableDao().queryBuilder()
                .where(NewsChannelTableDao.Properties.NewsChannelIndex.between(from,to))
                .build();
        return newsChannelTableQuery.list();
//        return DBManager.init(MyApplication.getInstance())
//                .loadNewsChannelsByWhere("news_channel_index BETWEEN ? AND ? ",new String[]{from+"",to+""});
    }
 

/**
     *  加载 用户已选中的频道
     * @return 已被选择的频道
     */
    public static List<NewsChannelTable> loadNewsChannelsMine(){
        Query<NewsChannelTable> newsChannelTableQuery = MyApplication.getDaoSession().getNewsChannelTableDao()
                .queryBuilder()
                .where(NewsChannelTableDao.Properties.NewsChannelSelect.eq(true))
                .orderAsc(NewsChannelTableDao.Properties.NewsChannelIndex)
                .build();
        return newsChannelTableQuery.list();
//        return DBManager.init(MyApplication.getInstance()).loadNewsChannels("1");
    }
 

/**
 *  查询 index > ?  频道
 * @param index
 */
public static List<NewsChannelTable> loadNewsChannelsIndexGt(int index){
    Query<NewsChannelTable> newsChannelTableQuery = MyApplication.getDaoSession().getNewsChannelTableDao().queryBuilder()
            .where(NewsChannelTableDao.Properties.NewsChannelIndex.gt(index)).build();
    return newsChannelTableQuery.list();
    //return DBManager.init(MyApplication.getInstance()).loadNewsChannelsByWhere(" news_channel_index > ? ",new String[]{index+""});
}
 

public void deleteTwoThousandRecords() {
    Query tableSelectQuery = daoSession.getLogEntityDao().queryBuilder().where(LogEntityDao.Properties.Timestamp.le(new Long(new Date().getTime()))).orderAsc(LogEntityDao.Properties.Timestamp).limit(2000).build();
    List<LogEntity> records = tableSelectQuery.list();
    List ids = new ArrayList();
    for(LogEntity log : records){
        ids.add(log.getId());
    }

    DeleteQuery tableDeleteQuery = daoSession.getLogEntityDao().queryBuilder().where(LogEntityDao.Properties.Id.in(ids)).buildDelete();
    tableDeleteQuery.executeDeleteWithoutDetachingEntities();
    daoSession.clear();
    DbUtils.vacuum(daoSession.getDatabase());
}
 

/**
 *  index < channelIndex ，且 未被选中的
 * @param channelIndex
 * @return
 */
public static List<NewsChannelTable> loadNewsChannelsIndexLtAndIsUnselect(int channelIndex) {
    Query<NewsChannelTable> newsChannelTableQuery = MyApplication.getDaoSession().getNewsChannelTableDao().queryBuilder()
            .where(NewsChannelTableDao.Properties.NewsChannelIndex.lt(channelIndex)
                    ,NewsChannelTableDao.Properties.NewsChannelSelect.eq(false))
            .build();
    return newsChannelTableQuery.list();
    //return DBManager.init(MyApplication.getInstance()).loadNewsChannelsByWhere("news_channel_index < ? and news_channel_select = ? ",new String[]{channelIndex+"","0"});
}
 

/** Internal query to resolve the "words" to-many relationship of Image. */
public List<Word> _queryImage_Words(long imageId) {
    synchronized (this) {
        if (image_WordsQuery == null) {
            QueryBuilder<Word> queryBuilder = queryBuilder();
            queryBuilder.join(JoinImagesWithWords.class, JoinImagesWithWordsDao.Properties.WordId)
                .where(JoinImagesWithWordsDao.Properties.ImageId.eq(imageId));
            image_WordsQuery = queryBuilder.build();
        }
    }
    Query<Word> query = image_WordsQuery.forCurrentThread();
    query.setParameter(0, imageId);
    return query.list();
}
 

/**
     *  加载 推荐频道
     * @return 推荐频道列表
     */
    public static List<NewsChannelTable> loadNewsChannelsRecommend(){
        Query<NewsChannelTable> newsChannelTableQuery = MyApplication.getDaoSession().getNewsChannelTableDao()
                .queryBuilder()
                .where(NewsChannelTableDao.Properties.NewsChannelSelect.eq(false))
                .orderAsc(NewsChannelTableDao.Properties.NewsChannelIndex)
                .build();
        return newsChannelTableQuery.list();
//        return DBManager.init(MyApplication.getInstance()).loadNewsChannels("0");
    }
 

public List<TaskTemplate> getTaskWithThisPlanByTypeId(Long planId, Integer typeId) {
    QueryBuilder<TaskTemplate> queryBuilder = daoSession.getTaskTemplateDao().queryBuilder();
    queryBuilder.where(TaskTemplateDao.Properties.TypeId.eq(typeId))
            .join(PlanTaskTemplate.class, PlanTaskTemplateDao.Properties.TaskTemplateId)
            .where(PlanTaskTemplateDao.Properties.PlanTemplateId.eq(planId));
    Query<TaskTemplate> getTaskWithThisPlanByTypeIdQuery = queryBuilder.build();
    return getTaskWithThisPlanByTypeIdQuery.list();
}
 

public List<PlanTemplate> getPlansWithThisTask(Long taskId) {
    QueryBuilder<PlanTemplate> queryBuilder = daoSession.getPlanTemplateDao().queryBuilder();
    queryBuilder.join(PlanTaskTemplate.class, PlanTaskTemplateDao.Properties.PlanTemplateId)
            .where(PlanTaskTemplateDao.Properties.TaskTemplateId.eq(taskId));
    Query<PlanTemplate> getPlansWithThisTaskQuery = queryBuilder.build();
    return getPlansWithThisTaskQuery.list();
}
 

/** Internal query to resolve the "readers" to-many relationship of Message. */
public List<User> _queryMessage_Readers(Long id) {
    synchronized (this) {
        if (message_ReadersQuery == null) {
            QueryBuilder<User> queryBuilder = queryBuilder();
            queryBuilder.where(Properties.Id.eq(null));
            message_ReadersQuery = queryBuilder.build();
        }
    }
    Query<User> query = message_ReadersQuery.forCurrentThread();
    query.setParameter(0, id);
    return query.list();
}
 

/** Internal query to resolve the "words" to-many relationship of Audio. */
public List<Word> _queryAudio_Words(long audioId) {
    synchronized (this) {
        if (audio_WordsQuery == null) {
            QueryBuilder<Word> queryBuilder = queryBuilder();
            queryBuilder.join(JoinAudiosWithWords.class, JoinAudiosWithWordsDao.Properties.WordId)
                .where(JoinAudiosWithWordsDao.Properties.AudioId.eq(audioId));
            audio_WordsQuery = queryBuilder.build();
        }
    }
    Query<Word> query = audio_WordsQuery.forCurrentThread();
    query.setParameter(0, audioId);
    return query.list();
}
 

/** Internal query to resolve the "allophones" to-many relationship of Letter. */
public List<Allophone> _queryLetter_Allophones(long letterId) {
    synchronized (this) {
        if (letter_AllophonesQuery == null) {
            QueryBuilder<Allophone> queryBuilder = queryBuilder();
            queryBuilder.join(JoinLettersWithAllophones.class, JoinLettersWithAllophonesDao.Properties.AllophoneId)
                .where(JoinLettersWithAllophonesDao.Properties.LetterId.eq(letterId));
            letter_AllophonesQuery = queryBuilder.build();
        }
    }
    Query<Allophone> query = letter_AllophonesQuery.forCurrentThread();
    query.setParameter(0, letterId);
    return query.list();
}