content: /*
   * Copyright (C) 2012-2023 52°North Spatial Information Research GmbH
   *
   * This program is free software; you can redistribute it and/or modify it
   * under the terms of the GNU General Public License version 2 as published
   * by the Free Software Foundation.
   *
   * If the program is linked with libraries which are licensed under one of
   * the following licenses, the combination of the program with the linked
   * library is not considered a "derivative work" of the program:
   *
   *     - Apache License, version 2.0
   *     - Apache Software License, version 1.0
   *     - GNU Lesser General Public License, version 3
   *     - Mozilla Public License, versions 1.0, 1.1 and 2.0
   *     - Common Development and Distribution License (CDDL), version 1.0
   *
   * Therefore the distribution of the program linked with libraries licensed
   * under the aforementioned licenses, is permitted by the copyright holders
   * if the distribution is compliant with both the GNU General Public
   * License version 2 and the aforementioned licenses.
   *
   * 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 General
   * Public License for more details.
   */
  package org.n52.sos.ds.hibernate.util;
  
  import java.util.List;
  
  /**
   * Utility class for Hibernate native SQL queries.
   *
   * @since 4.0.0
   */
  public final class HibernateSQLQueryUtilities {
  
      private HibernateSQLQueryUtilities() {
      }
  
      /**
       * Get distinct value for properties and table name
       *
       * @param properties
       *            Properties
       * @param tableName
       *            table name
       * @return Distinct value
       */
      public static String getSelectDistinctFromQuery(List<String> properties, List<String> restrictions,
              String tableName) {
          StringBuilder query = new StringBuilder();
          query.append(DefaultHibernateConstants.SELECT);
          query.append(DefaultHibernateConstants.DISTINCT);
          for (String property : properties) {
              query.append(property);
              query.append(",");
          }
          query.delete(query.lastIndexOf(","), query.length());
          query.append(DefaultHibernateConstants.FROM);
          query.append(tableName);
          if (restrictions != null && !restrictions.isEmpty()) {
              query.append(DefaultHibernateConstants.WHERE);
              for (String restriction : restrictions) {
                  query.append(restriction);
                  query.append(DefaultHibernateConstants.AND);
              }
              query.delete(query.lastIndexOf(DefaultHibernateConstants.AND), query.length());
          }
          query.append(";");
          return query.toString();
      }
  }
  