Examples with Query org.b3log.latke.repository.Query used on opensource projects

Example 66 with Query

use of org.b3log.latke.repository.Query in project solo by b3log.

the class SitemapProcessor method addArticles.

/**
     * Adds articles into the specified sitemap.
     * 
     * @param sitemap the specified sitemap
     * @throws Exception exception
     */
private void addArticles(final Sitemap sitemap) throws Exception {
    // XXX: query all articles?
    final Query query = new Query().setCurrentPageNum(1).setFilter(new PropertyFilter(Article.ARTICLE_IS_PUBLISHED, FilterOperator.EQUAL, true)).addSort(Article.ARTICLE_CREATE_DATE, SortDirection.DESCENDING);
    // XXX: maybe out of memory 
    final JSONObject articleResult = articleRepository.get(query);
    final JSONArray articles = articleResult.getJSONArray(Keys.RESULTS);
    for (int i = 0; i < articles.length(); i++) {
        final JSONObject article = articles.getJSONObject(i);
        final String permalink = article.getString(Article.ARTICLE_PERMALINK);
        final URL url = new URL();
        url.setLoc(Latkes.getServePath() + permalink);
        final Date updateDate = (Date) article.get(Article.ARTICLE_UPDATE_DATE);
        final String lastMod = DateFormatUtils.ISO_DATETIME_TIME_ZONE_FORMAT.format(updateDate);
        url.setLastMod(lastMod);
        sitemap.addURL(url);
    }
}

Example 67 with Query

use of org.b3log.latke.repository.Query in project solo by b3log.

the class SitemapProcessor method addArchives.

/**
     * Adds archives (archive-articles) into the specified sitemap.
     * 
     * @param sitemap the specified sitemap
     * @throws Exception exception
     */
private void addArchives(final Sitemap sitemap) throws Exception {
    final JSONObject result = archiveDateRepository.get(new Query());
    final JSONArray archiveDates = result.getJSONArray(Keys.RESULTS);
    for (int i = 0; i < archiveDates.length(); i++) {
        final JSONObject archiveDate = archiveDates.getJSONObject(i);
        final long time = archiveDate.getLong(ArchiveDate.ARCHIVE_TIME);
        final String dateString = DateFormatUtils.format(time, "yyyy/MM");
        final URL url = new URL();
        url.setLoc(Latkes.getServePath() + "/archives/" + dateString);
        sitemap.addURL(url);
    }
}

Example 68 with Query

use of org.b3log.latke.repository.Query in project solo by b3log.

the class SitemapProcessor method addTags.

/**
     * Adds tags (tag-articles) and tags wall (/tags.html) into the specified sitemap.
     * 
     * @param sitemap the specified sitemap
     * @throws Exception exception
     */
private void addTags(final Sitemap sitemap) throws Exception {
    final JSONObject result = tagRepository.get(new Query());
    final JSONArray tags = result.getJSONArray(Keys.RESULTS);
    for (int i = 0; i < tags.length(); i++) {
        final JSONObject tag = tags.getJSONObject(i);
        final String link = URLEncoder.encode(tag.getString(Tag.TAG_TITLE), "UTF-8");
        final URL url = new URL();
        url.setLoc(Latkes.getServePath() + "/tags/" + link);
        sitemap.addURL(url);
    }
    // Tags wall
    final URL url = new URL();
    url.setLoc(Latkes.getServePath() + "/tags.html");
    sitemap.addURL(url);
}

Example 69 with Query

use of org.b3log.latke.repository.Query in project solo by b3log.

the class ArchiveDateRepositoryImpl method getArchiveDates.

@Override
public List<JSONObject> getArchiveDates() throws RepositoryException {
    final org.b3log.latke.repository.Query query = new Query().addSort(ArchiveDate.ARCHIVE_TIME, SortDirection.DESCENDING).setPageCount(1);
    final JSONObject result = get(query);
    final JSONArray archiveDates = result.optJSONArray(Keys.RESULTS);
    final List<JSONObject> ret = CollectionUtils.jsonArrayToList(archiveDates);
    removeForUnpublishedArticles(ret);
    return ret;
}

Example 70 with Query

use of org.b3log.latke.repository.Query in project solo by b3log.

the class ArticleRepositoryImpl method getMostCommentArticles.

@Override
public List<JSONObject> getMostCommentArticles(final int num) throws RepositoryException {
    final Query query = new Query().addSort(Article.ARTICLE_COMMENT_COUNT, SortDirection.DESCENDING).addSort(Article.ARTICLE_UPDATE_DATE, SortDirection.DESCENDING).setFilter(new PropertyFilter(Article.ARTICLE_IS_PUBLISHED, FilterOperator.EQUAL, true)).setCurrentPageNum(1).setPageSize(num).setPageCount(1);
    final JSONObject result = get(query);
    final JSONArray array = result.optJSONArray(Keys.RESULTS);
    return CollectionUtils.jsonArrayToList(array);
}