SITools2

This folder contains the developments of HESIOD.

 /*******************************************************************************

 * Copyright 2010-2013 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 *

 * This file is part of SITools2.

 *

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 *

 * SITools2 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.

 *

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.cnes.sitools.astro.vo.conesearch;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.extensions.common.InputsValidation;

import fr.cnes.sitools.extensions.common.NotNullAndNotEmptyValidation;

import fr.cnes.sitools.extensions.common.RangeValidation;

import fr.cnes.sitools.extensions.common.StatusValidation;

import fr.cnes.sitools.extensions.common.Validation;

import java.util.ArrayList;

import java.util.Collections;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import java.util.Map.Entry;

import java.util.Set;

import java.util.logging.Level;

import java.util.logging.Logger;

import net.ivoa.xml.votable.v1.Info;

import org.restlet.Context;

import org.restlet.Request;

/**

 * This object provides methods to handle input parameters for the cone search protocol.

 *

 * @author Jean-Christophe Malapert

 */

public class ConeSearchInputParameters implements ConeSearchDataModelInterface {

  /**

   * Logger.

   */

  private static final Logger LOG = Logger.getLogger(ConeSearchInputParameters.class.getName());

  /**

   * Default verbosity mode.

   */

  private static final int DEFAULT_VERBOSITY_MODE = 0;

  /**

   * Verbosity mode.

   */

  private transient int verb = DEFAULT_VERBOSITY_MODE;

  /**

   * Data model.

   */

  private final transient Map dataModel = new HashMap();

  /**

   * User request.

   */

  private final transient Request request;

  /**

   * Application context.

   */

  private final transient Context context;

  /**

   * Application.

   */

  private final transient DataSetApplication datasetApp;

  /**

   * Right ascension of the cone center.

   */

  private transient double rightAscension;

  /**

   * Declination of the cone center.

   */

  private transient double declination;

  /**

   * Radius of the cone.

   */

  private transient double radius;

  /**

   * Constructor.

   *

   * @param datasetAppVal dataset application

   * @param requestVal Request

   * @param contextVal Context

   * @param maxSr maxSr for the cone search

   * @param verbosity verbosity

   * @param verbVal verbosity level

   */

  public ConeSearchInputParameters(final DataSetApplication datasetAppVal, final Request requestVal, final Context contextVal,

          final double maxSr, final boolean verbosity, final int verbVal) {

    this.datasetApp = datasetAppVal;

    this.context = contextVal;

    this.request = requestVal;

    final String raInput = this.request.getResourceRef().getQueryAsForm().getFirstValue(ConeSearchProtocolLibrary.RA);

    final String decInput = this.request.getResourceRef().getQueryAsForm().getFirstValue(ConeSearchProtocolLibrary.DEC);

    final String srInput = this.request.getResourceRef().getQueryAsForm().getFirstValue(ConeSearchProtocolLibrary.SR);

    final String verbInput = this.request.getResourceRef().getQueryAsForm().getFirstValue(ConeSearchProtocolLibrary.VERB);

    if(raInput == null && decInput == null && srInput == null){

        Info info = new Info();

        info.setName("QUERY_STATUS");

        info.setValueAttribute("ERROR");

        info.setValue("RA, DEC and SR must be not null");

        final List<Info> listInfos = new ArrayList<Info>();

        listInfos.add(info);

        this.dataModel.put("infos", listInfos);

    }else{

        checkInputParameters(raInput, decInput, srInput, maxSr, verbInput, verbosity, verbVal);

    }

  }

  /**

   * Check input parameters.

   *

   * @param raInput Ra

   * @param decInput Dec

   * @param srInput Sr

   * @param maxSr maxSr

   * @param verbosity verbosity

   * @param verbInput user inpur verb

   * @param verbVal verbosity from admin

   */

  private void checkInputParameters(final String raInput, final String decInput, final String srInput, final double maxSr,

          final String verbInput, final boolean verbosity, final int verbVal) {

    final List<Info> infos = new ArrayList<Info>();

    final Map<String, String> validationMap = new HashMap<String, String>();

    validationMap.put(ConeSearchProtocolLibrary.RA, raInput);

    validationMap.put(ConeSearchProtocolLibrary.DEC, decInput);

    validationMap.put(ConeSearchProtocolLibrary.SR, srInput);

    validationMap.put(ConeSearchProtocolLibrary.VERB, verbInput);

    validationMap.put(ConeSearchProtocolLibrary.VERBOSITY, String.valueOf(verbosity));

    Validation validation = new InputsValidation(validationMap);

    validation = new RangeValidation(validation, ConeSearchProtocolLibrary.RA, ConeSearchProtocolLibrary.RA_MIN, ConeSearchProtocolLibrary.RA_MAX);

    validation = new RangeValidation(validation, ConeSearchProtocolLibrary.DEC, ConeSearchProtocolLibrary.DEC_MIN, ConeSearchProtocolLibrary.DEC_MAX);

    validation = new RangeValidation(validation, ConeSearchProtocolLibrary.SR, 0, maxSr);

    validation = new NotNullAndNotEmptyValidation(validation, ConeSearchProtocolLibrary.VERBOSITY);

    validation = new NotNullAndNotEmptyValidation(validation, ConeSearchProtocolLibrary.VERB, String.valueOf(verbVal));

    final StatusValidation status = validation.validate();

    if (status.isValid()) {

        final Map<String, String> input = validation.getMap();

        this.rightAscension = Double.valueOf(input.get(ConeSearchProtocolLibrary.RA));

        this.declination = Double.valueOf(input.get(ConeSearchProtocolLibrary.DEC));

        this.radius = Double.valueOf(input.get(ConeSearchProtocolLibrary.SR));

        this.verb = Integer.valueOf(input.get(ConeSearchProtocolLibrary.VERB));

    } else {

        Info infoError = new Info();

        infoError.setName("QUERY_STATUS");

        infoError.setValueAttribute("ERROR");

        infos.add(infoError);

        final Map<String, String> errors = status.getMessages();

        final Set<Entry<String, String>> entries = errors.entrySet();

        for (Entry<String, String> entry : entries) {

            final Info info = new Info();

            info.setID(entry.getKey());

            info.setName("Error in " + entry.getKey());

            info.setValueAttribute("Error in input " + entry.getKey() + ": " + entry.getValue());

            infos.add(info);

            LOG.log(Level.FINEST, "{0}: {1}", new Object[]{entry.getKey(), entry.getValue()});

        }

    }

    if (!infos.isEmpty()) {

      this.dataModel.put("infos", infos);

    }

  }

  /**

   * Get Ra.

   *

   * @return Ra

   */

  public final double getRa() {

    return this.rightAscension;

  }

  /**

   * Get Dec.

   *

   * @return Dec

   */

  public final double getDec() {

    return this.declination;

  }

  /**

   * Get Sr.

   *

   * @return Sr

   */

  public final double getSr() {

    return this.radius;

  }

  /**

   * Get verbosity level.

   *

   * @return verbosity level

   */

  public final int getVerb() {

    return this.verb;

  }

  @Override

  public final Map getDataModel() {

    return Collections.unmodifiableMap(this.dataModel);

  }

  /**

   * Returns the request.

   *

   * @return Request

   */

  public final Request getRequest() {

    return this.request;

  }

  /**

   * Returns the context.

   *

   * @return Context

   */

  public final Context getContext() {

    return this.context;

  }

  /**

   * Get DatasetApplication.

   *

   * @return Dataset application

   */

  public final DataSetApplication getDatasetApplication() {

    return this.datasetApp;

  }

}

 /*******************************************************************************

 * Copyright 2010-2013 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 *

 * This file is part of SITools2.

 *

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 *

 * SITools2 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.

 *

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.cnes.sitools.astro.vo.sia;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.dataset.dto.ColumnConceptMappingDTO;

import fr.cnes.sitools.dictionary.model.Concept;

import fr.cnes.sitools.extensions.common.InputsValidation;

import fr.cnes.sitools.extensions.common.NotNullAndNotEmptyValidation;

import fr.cnes.sitools.extensions.common.NumberArrayValidation;

import fr.cnes.sitools.extensions.common.SpatialGeoValidation; 

import fr.cnes.sitools.extensions.common.StatusValidation;

import fr.cnes.sitools.extensions.common.Validation;

import fr.cnes.sitools.plugins.resources.model.ResourceModel;

import fr.cnes.sitools.util.Util;

import java.math.BigInteger;

import java.util.ArrayList;

import java.util.Collections;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import java.util.Set;

import java.util.logging.Level;

import java.util.logging.Logger;

import net.ivoa.xml.votable.v1.AnyTEXT;

import net.ivoa.xml.votable.v1.DataType;

import net.ivoa.xml.votable.v1.Field;

import net.ivoa.xml.votable.v1.Info;

import net.ivoa.xml.votable.v1.Option;

import net.ivoa.xml.votable.v1.Param;

import net.ivoa.xml.votable.v1.Values;

import org.restlet.Context;

import org.restlet.Request;

/**

 * Input parameters for SIA.

 *

 * @author Jean-Crhistophe Malapert <jean-christophe.malapert@cnes.fr>

 */

import fr.cnes.sitools.common.exception.SitoolsException;

import fr.cnes.sitools.dataset.dto.DictionaryMappingDTO;

public class SimpleImageAccessInputParameters implements DataModelInterface {

  /**

   * Logger.

   */

  private static final Logger LOG = Logger.getLogger(SimpleImageAccessInputParameters.class.getName());

  /**

   * Init value for right ascension parameter of the user input.

   */

  private transient double ra = 0.0;

  /**

   * Init value for declination parameter of the user input.

   */

  private transient double dec = 0.0;

  /**

   * Array that stores the size parameter of the user input.

   */

  private transient double[] size;

  /**

   * Default value for the verb parameter of the user input.

   */

  private transient int verb = 0;

  /**

   * Data model that stores the metadata response of the service.

   */

  private final transient Map dataModel = new HashMap();

  /**

   * Request.

   */

  private final transient Request request;

  /**

   * Context.

   */

  private final transient Context context;

  /**

   * Application where this resources is linked.

   */

  private final transient DataSetApplication datasetApp;

  /**

   * Configuration parameters of this resource.

   */

  private final transient ResourceModel resourceModel;

  /**

   * Constructs the objet that returns the metadata of the service.

   * @param datasetAppVal application

   * @param requestVal request

   * @param contextVal context

   * @param resourceModelVal configuration parameters

   */

  public SimpleImageAccessInputParameters(final DataSetApplication datasetAppVal, final Request requestVal, final Context contextVal, final ResourceModel resourceModelVal) {

    this.datasetApp = datasetAppVal;

    this.context = contextVal;

    this.request = requestVal;

    this.resourceModel = resourceModelVal;

    final String posInput = this.request.getResourceRef().getQueryAsForm().getFirstValue(SimpleImageAccessProtocolLibrary.POS);

    final String sizeInput = this.request.getResourceRef().getQueryAsForm().getFirstValue(SimpleImageAccessProtocolLibrary.SIZE);

    final String format = this.request.getResourceRef().getQueryAsForm().getFirstValue(SimpleImageAccessProtocolLibrary.FORMAT);

    final String intersect = this.request.getResourceRef().getQueryAsForm().getFirstValue(SimpleImageAccessProtocolLibrary.INTERSECT);

    final String verbosity = this.request.getResourceRef().getQueryAsForm().getFirstValue(SimpleImageAccessProtocolLibrary.VERB);

    //TODO check the differentParameters

    if(posInput == null && sizeInput == null){

        Info info = new Info();

        info.setName("QUERY_STATUS");

        info.setValueAttribute("ERROR");

        final List<Info> listInfos = new ArrayList<Info>();

        listInfos.add(info);

        this.dataModel.put("infos", listInfos);

        if(format.equalsIgnoreCase("METADATA")){

            fillMetadataFormat();

        }

    }else{

        if (Util.isSet(format) && format.equals(SimpleImageAccessProtocolLibrary.ParamStandardFormat.METADATA.name())) {

            fillMetadataFormat();

        } else {

            checkInputParameters(posInput, sizeInput);

        }

    }

  }

  /**

   * Fills metadata response.

   */

  private void fillMetadataFormat() {

    this.dataModel.put("description", this.resourceModel.getParameterByName(SimpleImageAccessProtocolLibrary.DESCRIPTION).getValue());

    final Info info = new Info();

    info.setName("QUERY_STATUS");

    info.setValueAttribute("OK");

    final List<Info> listInfos = new ArrayList<Info>();

    listInfos.add(info);

    this.dataModel.put("infos", listInfos);

    final List<Param> listParam = new ArrayList<Param>();

    Param param = new Param();

    param.setName("INPUT:POS");

    param.setValue("0,0");

    param.setDatatype(DataType.DOUBLE);

    AnyTEXT anyText = new AnyTEXT();

    anyText.getContent().add("Search Position in the form ra,dec where ra and dec are given in decimal degrees in the ICRS coordinate system.");

    param.setDESCRIPTION(anyText);

    listParam.add(param);

    param = new Param();

    param.setName("INPUT:SIZE");

    param.setValue("0.05");

    param.setDatatype(DataType.DOUBLE);

    anyText = new AnyTEXT();

    anyText.getContent().add("Size of search region in the RA and Dec directions.");

    param.setDESCRIPTION(anyText);

    listParam.add(param);

    param = new Param();

    param.setName("INPUT:FORMAT");

    param.setValue(SimpleImageAccessProtocolLibrary.ParamStandardFormat.ALL.name());

    param.setDatatype(DataType.CHAR);

    param.setArraysize("*");

    anyText = new AnyTEXT();

    anyText.getContent().add("Requested format of images.");

    param.setDESCRIPTION(anyText);

    final List<String> formatList = SimpleImageAccessProtocolLibrary.ParamStandardFormat.getCtes();

    final Values values = new Values();

    for (String formatIter : formatList) {

      final Option option = new Option();

      option.setValue(formatIter);

      values.getOPTION().add(option);

    }

    param.setVALUES(values);

    //TODO : le faire pour chaque format

    listParam.add(param);

    param = new Param();

    param.setName("INPUT:INTERSECT");

    param.setValue(this.resourceModel.getParameterByName(SimpleImageAccessProtocolLibrary.INTERSECT).getValue());

    param.setDatatype(DataType.CHAR);

    anyText = new AnyTEXT();

    anyText.getContent().add("Choice of overlap with requested region.");

    param.setDESCRIPTION(anyText);

    listParam.add(param);

    param = new Param();

    param.setName("INPUT:VERB");

    param.setValue(this.resourceModel.getParameterByName(SimpleImageAccessProtocolLibrary.VERB).getValue());

    param.setDatatype(DataType.INT);

    anyText = new AnyTEXT();

    anyText.getContent().add("Verbosity level, controlling the number of columns returned.");

    param.setDESCRIPTION(anyText);

    listParam.add(param);

    dataModel.put("params", listParam);

    //******************************************************************************************************************

    //******************************************************************************************************************

    //******************************************************************************************************************

    String dictionaryName = resourceModel.getParameterByName(SimpleImageAccessProtocolLibrary.DICTIONARY).getValue();

    final List<String> columnList = new ArrayList<String>();

    List<Field> fieldList = new ArrayList<Field>();

    try {

        List<ColumnConceptMappingDTO> mappingList = getDicoFromConfiguration(datasetApp, dictionaryName);

        setFields(fieldList, columnList, mappingList);

    }catch (SitoolsException ex) {

    }

  }

  /**

   * Checks input parameters.

   * @param posInput input parameter for POS

   * @param sizeInput input parameter for SIZE

   */

  private void checkInputParameters(final String posInput, final String sizeInput) {

    final List<Info> infos = new ArrayList<Info>();

    final Map<String, String> validationMap = new HashMap<String, String>();

    validationMap.put(SimpleImageAccessProtocolLibrary.POS, posInput);

    validationMap.put(SimpleImageAccessProtocolLibrary.SIZE, sizeInput);    

    Validation validation = new InputsValidation(validationMap);

    validation = new NotNullAndNotEmptyValidation(validation, SimpleImageAccessProtocolLibrary.POS);

    validation = new NotNullAndNotEmptyValidation(validation, SimpleImageAccessProtocolLibrary.SIZE);

    if(validation.validate().isValid()){

        validation = new SpatialGeoValidation(validation, SimpleImageAccessProtocolLibrary.POS, 0, 1, new double[]{0.0, 360.0}, new double[]{-90.0, 90.0});

        // LA LIGNE SUIVANTE A ETE AJOUTEE POUR VERIFIER QUE LA SIZE EST BIEN UN ARRAY DE NOMBRE

        validation = new NumberArrayValidation(validation, SimpleImageAccessProtocolLibrary.SIZE, ",", 1, 2);

        //-----------------------------------------------------------------------------------------------

    }  

    StatusValidation status = validation.validate();

    if (status.isValid()) {

        final String pos = validation.getMap().get(SimpleImageAccessProtocolLibrary.POS);

        final String[] arrayPos = pos.split(",");

        this.ra = Double.valueOf(arrayPos[0]);

        this.dec = Double.valueOf(arrayPos[1]);

        final String size = validation.getMap().get(SimpleImageAccessProtocolLibrary.SIZE);

        final String[] arraySize = size.split(",");

        if(arraySize.length == 1) {

            this.size = new double[1];

            this.size[0] = Double.valueOf(arraySize[0]);

        } else {

            this.size = new double[2];

            this.size[0] = Double.valueOf(arraySize[0]);

            this.size[1] = Double.valueOf(arraySize[1]);

        }

    } else {

        Info info = new Info();

        info.setName("QUERY_STATUS");

        info.setValueAttribute("ERROR");

        infos.add(info);

        final Map<String, String> errors = status.getMessages();

        final Set<Map.Entry<String, String>> entries = errors.entrySet();        

        for (Map.Entry<String, String> entry : entries) {

            info = new Info();

            info.setID(entry.getKey());

            info.setName("Error in " + entry.getKey());

            info.setValueAttribute("Error in input " + entry.getKey() + ": " + entry.getValue());

            infos.add(info);

            LOG.log(Level.FINEST, "{0}: {1}", new Object[]{entry.getKey(), entry.getValue()});            

        }

    }

    if (!infos.isEmpty()) {

      this.dataModel.put("infos", infos);

    }

  }

  @Override

  public final Map getDataModel() {

    return Collections.unmodifiableMap(this.dataModel);

  }

  /**

   * Get Ra.

   *

   * @return Ra

   */

  public final double getRa() {

    return this.ra;

  }

  /**

   * Get Dec.

   *

   * @return Dec

   */

  public final double getDec() {

    return this.dec;

  }

  /**

   * Get Sr.

   *

   * @return Sr

   */

  public final double[] getSize() {

      final double[] copySize = new double[this.size.length];

      System.arraycopy(this.size, 0, copySize, 0, this.size.length);

      return copySize;

  }

  /**

   * Get the request.

   *

   * @return Request

   */

  public final Request getRequest() {

    return this.request;

  }

  /**

   * Get the context.

   *

   * @return Context

   */

  public final Context getContext() {

    return this.context;

  }

  /**

   * Get DatasetApplication.

   *

   * @return Dataset application

   */

  public final DataSetApplication getDatasetApplication() {

    return this.datasetApp;

  }

  /**

   * Get verb.

   * @return verb

   */

  public final int getVerb() {

    return this.verb;

  }

  //----------------------------------------------------------------------------

  //----------------------------------------------------------------------------

  //----------------------------------------------------------------------------

  /**

   * Set Fields and columnSqlAliasList.

   *

   * @param fieldList List of fields to display on the VOTable

   * @param columnList List of SQL column

   * @param mappingList List of SQL column/concept

   */

  private void setFields(final List<Field> fieldList, final List<String> columnList, final List<ColumnConceptMappingDTO> mappingList) {

    for (ColumnConceptMappingDTO mappingIter : mappingList) {

      String id = null;

      String name = null;

      String ucd = null;

      String utype = null;

      String ref = null;

      String datatype = null;

      String width = null;

      String precision = null;

      String unit = null;

      String type = null;

      String xtype = null;

      String arraysize = null;

      String descriptionValue = null;

      columnList.add(mappingIter.getColumnAlias());

      final Concept concept = mappingIter.getConcept();

      if (concept.getName() != null) {

        name = concept.getName();

      }

      if (concept.getPropertyFromName("ID").getValue() != null) {

        id = concept.getPropertyFromName("ID").getValue();

      }

      if (concept.getPropertyFromName("ucd").getValue() != null) {

        ucd = concept.getPropertyFromName("ucd").getValue();

      }

      if (concept.getPropertyFromName("utype").getValue() != null) {

        utype = concept.getPropertyFromName("utype").getValue();

      }

      if (concept.getPropertyFromName("ref").getValue() != null) {

        ref = concept.getPropertyFromName("ref").getValue();

      }

      if (concept.getPropertyFromName("datatype").getValue() != null) {

        datatype = concept.getPropertyFromName("datatype").getValue();

      }

      if (concept.getPropertyFromName("width").getValue() != null) {

        width = concept.getPropertyFromName("width").getValue();

      }

      if (concept.getPropertyFromName("precision").getValue() != null) {

        precision = concept.getPropertyFromName("precision").getValue();

      }

      if (concept.getPropertyFromName("unit").getValue() != null) {

        unit = concept.getPropertyFromName("unit").getValue();

      }

      if (concept.getPropertyFromName("type").getValue() != null) {

        type = concept.getPropertyFromName("type").getValue();

      }

      if (concept.getPropertyFromName("xtype").getValue() != null) {

        xtype = concept.getPropertyFromName("xtype").getValue();

      }

      if (concept.getPropertyFromName("arraysize").getValue() != null) {

        arraysize = concept.getPropertyFromName("arraysize").getValue();

      }

      if (concept.getDescription() != null) {

        descriptionValue = concept.getDescription();

      }

      final Field field = new Field();

      field.setID(id);

      field.setName(name);

      field.setUcd(ucd);

      field.setUtype(utype);

      field.setRef(ref);

      field.setDatatype(DataType.fromValue(datatype));

      if (width != null) {

        field.setWidth(BigInteger.valueOf(Long.valueOf(width)));

      }

      field.setPrecision(precision);

      field.setUnit(unit);

      field.setType(type);

      field.setXtype(xtype);

      field.setArraysize(arraysize);

      final AnyTEXT anyText = new AnyTEXT();

      anyText.getContent().add(descriptionValue);

      field.setDESCRIPTION(anyText);

      fieldList.add(field);

    }

    dataModel.put("fields", fieldList);

  }

  /**

   * Provide the mapping between SQL column/concept for a given dictionary.

   *

   * @param datasetApp Application where this service is attached

   * @param dicoToFind Dictionary name to find

   * @return Returns a mapping SQL column/Concept

   * @throws SitoolsException No mapping has been done or cannot find the dico

   */

  protected List<ColumnConceptMappingDTO> getDicoFromConfiguration(final DataSetApplication datasetApp,

          final String dicoToFind) throws SitoolsException {

    List<ColumnConceptMappingDTO> colConceptMappingDTOList = null;

    // Get the list of dictionnaries related to the datasetApplication

    final List<DictionaryMappingDTO> dicoMappingList = datasetApp.getDictionaryMappings();

    if (!Util.isSet(dicoMappingList) || dicoMappingList.isEmpty()) {

      throw new SitoolsException("No mapping with VO concepts has been done. please contact the administrator");

    }

    // For each dictionary, find the interesting one and return the mapping SQLcolumn/concept

    for (DictionaryMappingDTO dicoMappingIter : dicoMappingList) {

      final String dicoName = dicoMappingIter.getDictionaryName();

      if (dicoToFind.equals(dicoName)) {

        colConceptMappingDTOList = dicoMappingIter.getMapping();

        break;

      }

    }

    return colConceptMappingDTOList;

  }

}

This folder contains the developments of HESIOD in Java.

fr.ias.sitools.converters.FileSizeConverter

fr.ias.sitools.converters.RaDecToXYZConverter

fr.ias.sitools.filters.basic.BooleanCorotAsteroAndExo

fr.ias.sitools.filters.basic.BooleanCustom

fr.ias.sitools.filters.basic.GroupCheckBoxMasterLigthCurves

fr.ias.sitools.filters.basic.NThreeVariability

fr.ias.sitools.filters.basic.TextFieldSQLLikeFilter

fr.ias.sitools.filters.basic.DateBeginEndFilter

fr.ias.sitools.filters.basic.SingleValueLikeFilter

fr.ias.sitools.filters.basic.ListBoxSpectralTypeCorot

fr.ias.sitools.filters.basic.ListBoxLumClassCorot

fr.ias.sitools.filters.basic.TextAreaCorotFilter

fr.ias.sitools.resources.spectrofits.GetFitsDataSpectroModel

fr.ias.sitools.resources.fits.ShowHeaderModel

fr.ias.sitools.astro.resolverName.CorotIdResolverModel

fr.ias.sitools.resources.vo.SimpleSpectralAccessResourceModel

fr.ias.sitools.resources.geojson.DatasetToJsonModel

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package fr.ias.sitools.converters;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.ConstraintViolationLevel;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.converter.business.AbstractConverter;

import fr.cnes.sitools.dataset.converter.model.ConverterParameter;

import fr.cnes.sitools.dataset.converter.model.ConverterParameterType;

import fr.cnes.sitools.datasource.jdbc.model.AttributeValue;

import fr.cnes.sitools.datasource.jdbc.model.Record;

import java.util.HashSet;

import java.util.Map;

import java.util.Set;

import java.util.logging.Level;

import java.util.logging.Logger;

/**

 *

 * @author Marc

 */

public class FileSizeConverter extends AbstractConverter {

    /** Class logger */

    private static final Logger LOGGER = Logger.getLogger(FileSizeConverter.class.getName());

    public FileSizeConverter() {

        this.setName("FileSizeConverter");

        this.setDescription("A converter applying an unit conversion from bytes into Kb or Mb or Gb");

        this.setClassAuthor("Marc NICOLAS");

        this.setClassOwner("IAS");

        this.setClassVersion("0.1");

        ConverterParameter colFileSize = new ConverterParameter("colFileSizeInBytes", "row of dataset with the filesize in bytes",ConverterParameterType.CONVERTER_PARAMETER_IN);

        ConverterParameter colFileSizeConvert = new ConverterParameter("colFileSizeConvert", "File Size converted", ConverterParameterType.CONVERTER_PARAMETER_OUT);

        this.addParam(colFileSize);

        this.addParam(colFileSizeConvert);

        LOGGER.log(Level.INFO, "Converter :{0} version {1}", new Object[] { this.getName(), this.getClassVersion() });

    }   

    @Override

    public Record getConversionOf(Record record) throws Exception {

        Record out = record;

        String result = "";

        AttributeValue attrOut = this.getOutParam("colFileSizeConvert", out); 

        AttributeValue attrIn = this.getInParam("colFileSizeInBytes", out);

        if (!isNull(attrIn) && !isNull(attrOut)) {

            try{

                double input = Double.parseDouble(attrIn.getValue().toString());

                if(input>0 && input<1024){

                    result = (double)Math.round(input*10)/10 +" o";

                }else if(input >= 1024 && input < Math.pow(1024, 2) ){

                   result = (double)Math.round((input/1024)*10)/10+" Ko"; 

                }else if(input >=Math.pow(1024, 2) && input < Math.pow(1024, 3)){

                    result = (double)Math.round((input/Math.pow(1024, 2))*10)/10+" Mo" ;

                }else if( input >= Math.pow(1024, 3) && input < Math.pow(1024, 4)){

                    result = (double)Math.round((input/Math.pow(1024, 3))*10)/10+" Go" ;

                }

                if(!result.isEmpty()){

                    attrOut.setValue(result);

                }

            }catch (Exception e) {

                attrOut.setValue(Double.NaN);

            }

        }

        return out;

    }

   @Override

  public Validator<AbstractConverter> getValidator() {

    // TODO Auto-generated method stub

    return new Validator<AbstractConverter>() {

      @Override

      public Set<ConstraintViolation> validate(AbstractConverter item) {

        Set<ConstraintViolation> constraints = new HashSet<ConstraintViolation>();

        Map<String, ConverterParameter> params = item.getParametersMap();

        ConverterParameter param = params.get("colFileSizeInBytes");

        if(param.getAttachedColumn().isEmpty()){

          ConstraintViolation constraint = new ConstraintViolation();

          constraint.setMessage("You must choose the column with filesize in bytes data");

          constraint.setLevel(ConstraintViolationLevel.CRITICAL);

          constraint.setValueName(param.getName());

          constraints.add(constraint);

        }

        param = params.get("colFileSizeConvert");

        if(param.getAttachedColumn().isEmpty()){

          ConstraintViolation constraint = new ConstraintViolation();

          constraint.setMessage("You must choose the output column");

          constraint.setLevel(ConstraintViolationLevel.CRITICAL);

          constraint.setValueName(param.getName());

          constraints.add(constraint);

        }

        return constraints;

      }

    };

  }

}

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package fr.ias.sitools.converters;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.ConstraintViolationLevel;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.converter.business.AbstractConverter;

import fr.cnes.sitools.dataset.converter.model.ConverterParameter;

import fr.cnes.sitools.dataset.converter.model.ConverterParameterType;

import fr.cnes.sitools.datasource.jdbc.model.AttributeValue;

import fr.cnes.sitools.datasource.jdbc.model.Record;

import java.util.HashSet;

import java.util.Map;

import java.util.Set;

import java.util.logging.Level;

import java.util.logging.Logger;

/**

 *

 * @author marc

 */

public class RaDecToXYZConverter extends AbstractConverter {

    /*

        Formule de changement de coordonée : 

            X=cos(DEC)*cos(RA)

            Y=cos(DEC)*sin(RA)

            Z=sin(DEC) 

    */

    /** Class logger */

    private static final Logger LOGGER = Logger.getLogger(RaDecToXYZConverter.class.getName());

    public RaDecToXYZConverter() {

        this.setName("RaDecToXYZConverter");

        this.setDescription("A converter applying an unit conversion from Ra and Dec into X, Y and Z coordinates");

        this.setClassAuthor("Marc NICOLAS");

        this.setClassOwner("IAS");

        this.setClassVersion("0.1");

        ConverterParameter colRa = new ConverterParameter("colRa", "row of dataset with the ra coordinate",ConverterParameterType.CONVERTER_PARAMETER_IN);

        ConverterParameter colDec = new ConverterParameter("colDec", "row of dataset with the dec coordinate",ConverterParameterType.CONVERTER_PARAMETER_IN);

        ConverterParameter colX = new ConverterParameter("colX", "Column for coordiante X", ConverterParameterType.CONVERTER_PARAMETER_OUT);

        ConverterParameter colY = new ConverterParameter("colY", "Column for coordiante Y", ConverterParameterType.CONVERTER_PARAMETER_OUT);

        ConverterParameter colZ = new ConverterParameter("colZ", "Column for coordiante Z", ConverterParameterType.CONVERTER_PARAMETER_OUT);

        this.addParam(colRa);

        this.addParam(colDec);

        this.addParam(colX);

        this.addParam(colY);

        this.addParam(colZ);

        LOGGER.log(Level.INFO, "Converter :{0} version {1}", new Object[] { this.getName(), this.getClassVersion() });

    }

    @Override

    public Record getConversionOf(Record record) throws Exception {

        Record out = record;

        Double x, y, z;

        AttributeValue attrOutX = this.getOutParam("colX", out); 

        AttributeValue attrOutY = this.getOutParam("colY", out); 

        AttributeValue attrOutZ = this.getOutParam("colZ", out); 

        AttributeValue attrInRa = this.getInParam("colRa", out);

        AttributeValue attrInDec = this.getInParam("colDec", out);

        if(!isNull(attrInRa) && !isNull(attrInRa)/* && !isNull(attrOutX) && !isNull(attrOutY) && !isNull(attrOutZ)*/){

            try{

                Double ra = Double.parseDouble(attrInRa.getValue().toString());

                Double dec = Double.parseDouble(attrInDec.getValue().toString());

                x = Math.cos(dec)*Math.cos(ra);

                y = Math.cos(dec)*Math.sin(ra);

                z = Math.sin(dec);

               if(!x.isNaN()){

                   attrOutX.setValue(x);

               }

               if(!y.isNaN()){

                   attrOutY.setValue(y);

               }

               if(!z.isNaN()){

                   attrOutZ.setValue(z);

               }

            }catch(NumberFormatException e){

            }

        }

        return out;

    }

    @Override

    public Validator<?> getValidator() {

        // TODO Auto-generated method stub

    return new Validator<AbstractConverter>() {

      @Override

      public Set<ConstraintViolation> validate(AbstractConverter item) {

        Set<ConstraintViolation> constraints = new HashSet<ConstraintViolation>();

        /*Map<String, ConverterParameter> params = item.getParametersMap();

        ConverterParameter param = params.get("colFileSizeInBytes");

        if(param.getAttachedColumn().isEmpty()){

          ConstraintViolation constraint = new ConstraintViolation();

          constraint.setMessage("You must choose the column with filesize in bytes data");

          constraint.setLevel(ConstraintViolationLevel.CRITICAL);

          constraint.setValueName(param.getName());

          constraints.add(constraint);

        }

        param = params.get("colFileSizeConvert");

        if(param.getAttachedColumn().isEmpty()){

          ConstraintViolation constraint = new ConstraintViolation();

          constraint.setMessage("You must choose the output column");

          constraint.setLevel(ConstraintViolationLevel.CRITICAL);

          constraint.setValueName(param.getName());

          constraints.add(constraint);

        }*/

        return constraints;

      }

    };

    }

}

/*******************************************************************************

 * Copyright 2011 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 * 

 * This file is part of SITools2.

 * 

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 * 

 * SITools2 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.

 * 

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.ias.sitools.filters.basic;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import java.util.Set;

import org.restlet.Request;

import org.restlet.data.Form;

import org.restlet.ext.wadl.ParameterInfo;

import org.restlet.ext.wadl.ParameterStyle;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.dataset.filter.business.AbstractFilter;

import fr.cnes.sitools.dataset.model.Column;

import fr.cnes.sitools.dataset.model.DataSet;

import fr.cnes.sitools.dataset.model.Operator;

import fr.cnes.sitools.dataset.model.Predicat;

import fr.cnes.sitools.util.SQLUtils;

/**

 * Filter defined for Date Between Component

 * 

 * 

 * @author d.arpin

 * <a href="https://sourceforge.net/tracker/?func=detail&atid=2158259&aid=3411383&group_id=531341">[3411383]</a><br/>

 * 2011/09/19 d.arpin {add quotes arround date Value}

 */

public final class DateBeginEndFilter extends AbstractFilter {

  /**

   * The index of TYPE

   */

  private static final int TYPE = 0;

  /**

   * The index of COLUMN

   */

  private static final int COLUMN = 1;

  /**

   * The index of Values

   */

  private static final int VALUES = 2;

  /** The TEMPLATE_PARAM */

  private static final String TEMPLATE_PARAM = "p[#]";

  /**

   * the values from to

   */

  private String[] values;

  /**

   * The list of component that uses this filter

   */

  private enum TYPE_COMPONENT {

    /** DefaultType */

    DATE_BEGIN_END

  }

  /**

   * Default constructor

   */

  public DateBeginEndFilter() {

    super();

    this.setName("DateBeginEndFilter");

    this.setDescription("Required when using Date Between Components between 2 columns");

    this.setClassAuthor("HUSSON@IAS");

    this.setClassAuthor("HUSSON@IAS");

    this.setClassOwner("IAS");

    this.setClassVersion("0.1");

    this.setDefaultFilter(true);

    HashMap<String, ParameterInfo> rpd = new HashMap<String, ParameterInfo>();

    ParameterInfo paramInfo;

    paramInfo = new ParameterInfo("p[#]", false, "xs:string", ParameterStyle.QUERY,

    "DATE_BEGIN_END|columnFrom,columnTo|valueFrom|valueTo");

    rpd.put("0", paramInfo);

    this.setRequestParamsDescription(rpd);

    //

  }

  @Override

  public List<Predicat> createPredicats(Request request, List<Predicat> predicats) throws Exception {

    // Get the dataset

    DataSetApplication dsApplication = null;

    DataSet ds = null;

    Form params = request.getResourceRef().getQueryAsForm();

    boolean filterExists = true;

    int i = 0;

    // Build predicat for filters param

    while (filterExists) {

      String index = TEMPLATE_PARAM.replace("#", Integer.toString(i++));

      String formParam = params.getFirstValue(index);

      if (formParam != null) {

        String[] parameters = formParam.split("\\|");

        TYPE_COMPONENT[] types = TYPE_COMPONENT.values();

        Boolean trouve = false;

        for (TYPE_COMPONENT typeCmp : types) {

          if (typeCmp.name().equals(parameters[TYPE])) {

            trouve = true;

          }

        }

        if (trouve) {

          if (dsApplication == null) {

            dsApplication = (DataSetApplication) getContext().getAttributes().get("DataSetApplication");

            ds = dsApplication.getDataSet();

          }

          String columnfrom = null;

          String columnto = null;

          if (parameters.length >= VALUES) {

            columnfrom = parameters[COLUMN].split(",")[0];

            columnto = parameters[COLUMN].split(",")[1];

            Column colfrom = ds.findByColumnAlias(columnfrom);

            Column colto = ds.findByColumnAlias(columnto);

            if (colfrom != null && colfrom.getFilter() != null && colfrom.getFilter() && checkValues(parameters) && colto != null && colto.getFilter() != null && colto.getFilter()) {

              // escape the values to avoid SQL injection

              String valuefrom = "'" + SQLUtils.escapeString(values[0]) + "'";

              String valueto = "'" + SQLUtils.escapeString(values[1]) + "'";

              Predicat predicat = new Predicat();

              predicat.setLeftAttribute(colfrom);

              predicat.setNbOpenedParanthesis(1);

              predicat.setNbClosedParanthesis(0);

              predicat.setCompareOperator(Operator.GTE);

              predicat.setRightValue(valuefrom);

              predicats.add(predicat);

              predicat = new Predicat();

              predicat.setLeftAttribute(colto);

              predicat.setNbOpenedParanthesis(0);

              predicat.setNbClosedParanthesis(1);

              predicat.setCompareOperator(Operator.LTE);

              predicat.setRightValue(valueto);

              predicats.add(predicat);

            }

          }

        }

      }

      else {

        filterExists = false;

      }

    }

    return predicats;

  }

  /**

   * Check values of the form

   * 

   * @param parameters

   *          the parameters of the filter

   * @return true if values agree

   */

  private boolean checkValues(String[] parameters) {

    values = Arrays.copyOfRange(parameters, VALUES, parameters.length);

    if (values.length == 2) {

      return true;

    }

    return false;

  }

  /**

   * Gets the validator for this Filter

   * 

   * @return the validator for the filter

   */

  @Override

  public Validator<AbstractFilter> getValidator() {

    return new Validator<AbstractFilter>() {

      @Override

      public Set<ConstraintViolation> validate(AbstractFilter item) {

        return null;

      }

    };

  }

}

     /*******************************************************************************

 * Copyright 2010-2013 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 *

 * This file is part of SITools2.

 *

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 *

 * SITools2 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.

 *

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.ias.sitools.filters.basic;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import java.util.Set;

import org.restlet.Request;

import org.restlet.data.Form;

import org.restlet.ext.wadl.ParameterInfo;

import org.restlet.ext.wadl.ParameterStyle;

import fr.cnes.sitools.common.validator.ConstraintViolation;

import fr.cnes.sitools.common.validator.Validator;

import fr.cnes.sitools.dataset.DataSetApplication;

import fr.cnes.sitools.dataset.filter.business.AbstractFilter;

import fr.cnes.sitools.dataset.model.Column;

import fr.cnes.sitools.dataset.model.DataSet;

import fr.cnes.sitools.dataset.model.Operator;

import fr.cnes.sitools.dataset.model.Predicat;

import fr.cnes.sitools.dataset.plugins.filters.core.AbstractFormFilter;

import static fr.cnes.sitools.dataset.plugins.filters.core.AbstractFormFilter.TEMPLATE_PARAM;

import static fr.cnes.sitools.dataset.plugins.filters.core.AbstractFormFilter.TEMPLATE_PARAM_CONCEPT;

import static fr.cnes.sitools.dataset.plugins.filters.core.AbstractFormFilter.VALUES;

import fr.cnes.sitools.util.SQLUtils;

/**

 * Filter defined for Multiple Value Component

 * 

 * 

 * @author d.arpin

 */

public final class ListBoxMultipleIAS extends AbstractFormFilter {

  /**

   * The list of component that uses this filter

   */

  private enum TYPE_COMPONENT {

    /** List box type */

    LISTBOXMULTIPLE_IAS,

  }

  /**

   * Default constructor

   */

  public ListBoxMultipleIAS() {

    super();

    this.setName("ListBoxMultipleIAS");

    this.setDescription("Required when using Multiple Value Components");

    this.setClassAuthor("Marc NICOLAS");

    this.setClassOwner("IAS");

    this.setClassVersion("0.1");

    this.setDefaultFilter(true);

    HashMap<String, ParameterInfo> rpd = new HashMap<String, ParameterInfo>();

    ParameterInfo paramInfo;

    paramInfo = new ParameterInfo("p[#]", false, "xs:string", ParameterStyle.QUERY,

        "LISTBOXMULTIPLE|columnAlias|value1|...|value n");

    rpd.put("0", paramInfo);

    paramInfo = new ParameterInfo("p[#]", false, "xs:string", ParameterStyle.QUERY,

        "CHECKBOX|columnAlias|value1|...|value n");

    rpd.put("1", paramInfo);

    paramInfo = new ParameterInfo("c[#]", false, "xs:string", ParameterStyle.QUERY,

        "LISTBOXMULTIPLE|dictionaryName,conceptName|value1|...|value n");

    rpd.put("2", paramInfo);

    /*paramInfo = new ParameterInfo("c[#]", false, "xs:string", ParameterStyle.QUERY,

        "CHECKBOX|dictionaryName,conceptName|value1|...|value n");

    rpd.put("3", paramInfo);

    this.setRequestParamsDescription(rpd);*/

    //

  }

  @Override

  public List<Predicat> createPredicats(Request request, List<Predicat> predicats) throws Exception {

    // Get the dataset

    DataSetApplication dsApplication = null;

    DataSet ds = null;

    boolean isConcept = true;

    Form params = request.getResourceRef().getQueryAsForm();

    boolean filterExists = true;

    int i = 0;

    // Build predicat for filters param

    while (filterExists) {

      // first check if the filter is applied on a Concept or not

      String index = TEMPLATE_PARAM_CONCEPT.replace("#", Integer.toString(i));

      String formParam = params.getFirstValue(index);

      if (formParam == null) {

        isConcept = false;

        index = TEMPLATE_PARAM.replace("#", Integer.toString(i));

        formParam = params.getFirstValue(index);

      }

      i++;

      if (formParam != null) {

        String[] parameters = formParam.split("\\|");

        TYPE_COMPONENT[] types = TYPE_COMPONENT.values();

        Boolean trouve = false;

        for (TYPE_COMPONENT typeCmp : types) {

          if (typeCmp.name().equals(parameters[TYPE])) {

            trouve = true;

          }

        }

        if (trouve) {

          if (dsApplication == null) {

            dsApplication = (DataSetApplication) getContext().getAttributes().get("DataSetApplication");

            ds = dsApplication.getDataSet();

          }

          String columnAlias = null;

          if (parameters.length >= VALUES) {

            /*

             * columnsAlias = parameters[COLUMN].split(","); ArrayList<Column> columns = new ArrayList<Column>(); for

             * (String columnAlias : columnsAlias) { Column col = ds.findByColumnAlias(columnAlias); if (col != null) {

             * columns.add(col); }

             * 

             * }

             */

            columnAlias = getColumnAlias(isConcept, parameters, dsApplication);

            if (columnAlias != null) {

              Column col = ds.findByColumnAlias(columnAlias);

              if (col != null && col.getFilter() != null && col.getFilter()) {

                String[] values = Arrays.copyOfRange(parameters, VALUES, parameters.length);

                Predicat predicat = new Predicat();

                if (values != null) {

                  predicat.setLeftAttribute(col);

                  predicat.setNbOpenedParanthesis(0);

                  predicat.setNbClosedParanthesis(0);

                  predicat.setCompareOperator(Operator.IN);

                  List<String> in = new ArrayList<String>();

                  for (String value : values) {

                    // escape every value to avoid SQL injections

                    in.add(SQLUtils.escapeString(value));

                  }

                  predicat.setRightValue(in);

                  predicats.add(predicat);

                }

              }

            }

          }

        }

      }

      else {

        filterExists = false;

      }

    }

    return predicats;

  }

  /**

   * Gets the validator for this Filter

   * 

   * @return the validator for the filter

   */

  @Override

  public Validator<AbstractFilter> getValidator() {

    return new Validator<AbstractFilter>() {

      @Override

      public Set<ConstraintViolation> validate(AbstractFilter item) {

        // TODO Auto-generated method stub

        return null;

      }

    };

  }

}

     /*******************************************************************************

 * Copyright 2010-2013 CNES - CENTRE NATIONAL d'ETUDES SPATIALES

 *

 * This file is part of SITools2.

 *

 * SITools2 is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 *

 * SITools2 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.

 *

 * You should have received a copy of the GNU General Public License

 * along with SITools2.  If not, see <http://www.gnu.org/licenses/>.

 ******************************************************************************/

package fr.ias.sitools.filters.basic;

import java.util.ArrayList;