content: /*
   * Symphony - A modern community (forum/BBS/SNS/blog) platform written in Java.
   * Copyright (C) 2012-present, b3log.org
   *
   * This program is free software: you can redistribute it and/or modify
   * it under the terms of the GNU Affero General Public License as published by
   * the Free Software Foundation, either version 3 of the License, or
   * (at your option) any later version.
   *
   * This program is distributed in the hope that it will be useful,
   * but WITHOUT ANY WARRANTY; without even the implied warranty of
   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   * GNU Affero General Public License for more details.
   *
   * You should have received a copy of the GNU Affero General Public License
   * along with this program.  If not, see <https://www.gnu.org/licenses/>.
   */
  package org.b3log.symphony.repository;
  
  import org.b3log.latke.Keys;
  import org.b3log.latke.repository.*;
  import org.b3log.latke.repository.annotation.Repository;
  import org.b3log.symphony.model.Common;
  import org.b3log.symphony.model.Tag;
  import org.b3log.symphony.util.Symphonys;
  import org.json.JSONObject;
  
  import java.util.ArrayList;
  import java.util.List;
  
  /**
   * Tag-Tag relation repository.
   *
   * @author <a href="http://88250.b3log.org">Liang Ding</a>
   * @version 1.0.0.1, Oct 19, 2016
   * @since 1.3.0
   */
  @Repository
  public class TagTagRepository extends AbstractRepository {
  
      /**
       * Public constructor.
       */
      public TagTagRepository() {
          super(Tag.TAG + "_" + Tag.TAG);
      }
  
      /**
       * Gets tag-tag relations by the specified tag1 id.
       *
       * @param tag1Id         the specified tag1 id
       * @param currentPageNum the specified current page number, MUST greater then {@code 0}
       * @param pageSize       the specified page size(count of a page contains objects), MUST greater then {@code 0}
       * @return for example      <pre>
       * {
       *     "pagination": {
       *       "paginationPageCount": 88250
       *     },
       *     "rslts": [{
       *         "oId": "",
       *         "tag1_oId": tag1Id,
       *         "tag2_oId": "",
       *         "weight": int
       *     }, ....]
       * }
       * </pre>
       * @throws RepositoryException repository exception
       */
      public JSONObject getByTag1Id(final String tag1Id, final int currentPageNum, final int pageSize)
              throws RepositoryException {
          final List<Filter> filters = new ArrayList<>();
          filters.add(new PropertyFilter(Tag.TAG + "1_" + Keys.OBJECT_ID, FilterOperator.EQUAL, tag1Id));
          filters.add(new PropertyFilter(Common.WEIGHT, FilterOperator.GREATER_THAN_OR_EQUAL, Symphonys.TAG_RELATED_WEIGHT));
  
          final Query query = new Query().setFilter(new CompositeFilter(CompositeFilterOperator.AND, filters)).
                  setPage(currentPageNum, pageSize).setPageCount(1).
                  addSort(Common.WEIGHT, SortDirection.DESCENDING);
  
          return get(query);
      }
  
      /**
       * Gets tag-tag relations by the specified tag2 id.
       *
       * @param tag2Id         the specified tag2 id
       * @param currentPageNum the specified current page number, MUST greater then {@code 0}
       * @param pageSize       the specified page size(count of a page contains objects), MUST greater then {@code 0}
       * @return for example      <pre>
       * {
       *     "pagination": {
       *       "paginationPageCount": 88250
       *     },
       *     "rslts": [{
       *         "oId": "",
       *         "tag1_oId": "",
       *         "tag2_oId": tag2Id,
       *         "weight": int
       *     }, ....]
       * }
       * </pre>
       * @throws RepositoryException repository exception
       */
      public JSONObject getByTag2Id(final String tag2Id, final int currentPageNum, final int pageSize)
              throws RepositoryException {
          final List<Filter> filters = new ArrayList<>();
          filters.add(new PropertyFilter(Tag.TAG + "2_" + Keys.OBJECT_ID, FilterOperator.EQUAL, tag2Id));
          filters.add(new PropertyFilter(Common.WEIGHT, FilterOperator.GREATER_THAN_OR_EQUAL, Symphonys.TAG_RELATED_WEIGHT));
  
          final Query query = new Query().setFilter(new CompositeFilter(CompositeFilterOperator.AND, filters)).
                  setPage(currentPageNum, pageSize).setPageCount(1).
                  addSort(Common.WEIGHT, SortDirection.DESCENDING);
  
          return get(query);
      }
  
      /**
       * Gets a tag-tag relation by the specified tag1 id and tag2 id.
       *
       * @param tag1Id the specified tag1 id
       * @param tag2Id the specified tag2 id
       * @return for example      <pre>
       * {
       *     "oId": "",
       *     "tag1_oId": tag1Id,
       *     "tag2_oId": tag2Id,
       *     "weight": int
       * }, returns {@code null} if not found
       * </pre>
       * @throws RepositoryException repository exception
       */
      public JSONObject getByTag1IdAndTag2Id(final String tag1Id, final String tag2Id) throws RepositoryException {
          final List<Filter> filters = new ArrayList<>();
          filters.add(new PropertyFilter(Tag.TAG + "1_" + Keys.OBJECT_ID, FilterOperator.EQUAL, tag1Id));
          filters.add(new PropertyFilter(Tag.TAG + "2_" + Keys.OBJECT_ID, FilterOperator.EQUAL, tag2Id));
          final Query query = new Query().setFilter(new CompositeFilter(CompositeFilterOperator.AND, filters));
          return getFirst(query);
      }
  }
  