Examples with JSONArray org.json.JSONArray used on opensource projects

Example 91 with JSONArray

use of org.json.JSONArray in project solo by b3log.

the class ArticleRepositoryImpl method getNextArticle.

@Override
public JSONObject getNextArticle(final String articleId) throws RepositoryException {
    final JSONObject currentArticle = get(articleId);
    final Date currentArticleCreateDate = (Date) currentArticle.opt(Article.ARTICLE_CREATE_DATE);
    final Query query = new Query().setFilter(CompositeFilterOperator.and(new PropertyFilter(Article.ARTICLE_CREATE_DATE, FilterOperator.GREATER_THAN, currentArticleCreateDate), new PropertyFilter(Article.ARTICLE_IS_PUBLISHED, FilterOperator.EQUAL, true))).addSort(Article.ARTICLE_CREATE_DATE, SortDirection.ASCENDING).setCurrentPageNum(1).setPageSize(1).setPageCount(1).addProjection(Article.ARTICLE_TITLE, String.class).addProjection(Article.ARTICLE_PERMALINK, String.class).addProjection(Article.ARTICLE_ABSTRACT, String.class);
    final JSONObject result = get(query);
    final JSONArray array = result.optJSONArray(Keys.RESULTS);
    if (1 != array.length()) {
        return null;
    }
    final JSONObject ret = new JSONObject();
    final JSONObject article = array.optJSONObject(0);
    try {
        ret.put(Article.ARTICLE_TITLE, article.getString(Article.ARTICLE_TITLE));
        ret.put(Article.ARTICLE_PERMALINK, article.getString(Article.ARTICLE_PERMALINK));
        ret.put(Article.ARTICLE_ABSTRACT, article.getString((Article.ARTICLE_ABSTRACT)));
    } catch (final JSONException e) {
        throw new RepositoryException(e);
    }
    return ret;
}

Example 92 with JSONArray

use of org.json.JSONArray in project solo by b3log.

the class ArticleRepositoryImpl method getByPermalink.

@Override
public JSONObject getByPermalink(final String permalink) throws RepositoryException {
    final Query query = new Query().setFilter(new PropertyFilter(Article.ARTICLE_PERMALINK, FilterOperator.EQUAL, permalink)).setPageCount(1);
    final JSONObject result = get(query);
    final JSONArray array = result.optJSONArray(Keys.RESULTS);
    if (0 == array.length()) {
        return null;
    }
    return array.optJSONObject(0);
}

Example 93 with JSONArray

use of org.json.JSONArray in project solo by b3log.

the class ArticleRepositoryImpl method getRecentArticles.

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

Example 94 with JSONArray

use of org.json.JSONArray in project solo by b3log.

the class CommentRepositoryImpl method getRecentComments.

@Override
@SuppressWarnings("unchecked")
public List<JSONObject> getRecentComments(final int num) throws RepositoryException {
    final Query query = new Query().addSort(Keys.OBJECT_ID, SortDirection.DESCENDING).setCurrentPageNum(1).setPageSize(num).setPageCount(1);
    List<JSONObject> ret;
    final JSONObject result = get(query);
    final JSONArray array = result.optJSONArray(Keys.RESULTS);
    ret = CollectionUtils.jsonArrayToList(array);
    // Removes unpublished article related comments
    removeForUnpublishedArticles(ret);
    return ret;
}

Example 95 with JSONArray

use of org.json.JSONArray in project solo by b3log.

the class LinkRepositoryImpl method getMaxOrder.

@Override
public int getMaxOrder() throws RepositoryException {
    final Query query = new Query();
    query.addSort(Link.LINK_ORDER, SortDirection.DESCENDING);
    final JSONObject result = get(query);
    final JSONArray array = result.optJSONArray(Keys.RESULTS);
    if (0 == array.length()) {
        return -1;
    }
    return array.optJSONObject(0).optInt(Link.LINK_ORDER);
}