observe.common.VesselDto.capacity

 observe.common.VesselDto.changeDate

 observe.common.VesselDto.comId

 observe.common.VesselDto.flagCountry

 observe.common.VesselDto.generalTab

 observe.common.VesselDto.imoId

 observe.common.VesselDto.keelCodeFlotte

 observe.common.VesselDto.length

 observe.common.VesselDto.lloydId

                 </cell>

               </row>

               <row>

                 <cell anchor="west">

                 </cell>

                 <cell anchor='east' weightx="1" fill="both">

                 </cell>

               </row>

                 </cell>

               </row>

               <row>

                 <cell anchor="west">

                 </cell>

                 <cell anchor='east' weightx="1" fill="both">

                 </cell>

               </row>

                       VesselDto.PROPERTY_SEARCH_MAXIMUM,

                       VesselDto.PROPERTY_CHANGE_DATE,

                       VesselDto.PROPERTY_COM_ID,

                       VesselDto.PROPERTY_IMO_ID,

                       VesselDto.PROPERTY_NATIONAL_ID,

                       VesselDto.PROPERTY_RADIO_CALL_SIGN_ID,

 power + {*:1} Integer

 searchMaximum + {*:1} Float

 comment + {*:1} String

 nationalId + {*:1} String

 comId + {*:1} String

 tuviId + {*:1} String

 observe.common.VesselDto.capacity=Capacity

 observe.common.VesselDto.changeDate=Change date

 observe.common.VesselDto.comId=EU Id

 observe.common.VesselDto.flagCountry=Flag country

 observe.common.VesselDto.fleetCountry=Fleet country

 observe.common.VesselDto.generalTab=General caracteristics

 observe.common.VesselDto.imoId=IMO Id

 observe.common.VesselDto.keelCode=Keel code

 observe.common.VesselDto.keelCodeFlotte=Keel / Flotte

 observe.common.VesselDto.length=Length

 observe.common.VesselDto.capacity=Capacidad de transporte

 observe.common.VesselDto.changeDate=Fecha de carga

 observe.common.VesselDto.comId=Id EU

 observe.common.VesselDto.flagCountry=Bandera

 observe.common.VesselDto.fleetCountry=País

 observe.common.VesselDto.generalTab=Características generales

 observe.common.VesselDto.imoId=Id IMO

 observe.common.VesselDto.keelCode=Código de Quilla

 observe.common.VesselDto.keelCodeFlotte=Código de Quilla / Flota

 observe.common.VesselDto.length=Longitud eslora total

 observe.common.VesselDto.capacity=Capacité transport (m³)

 observe.common.VesselDto.changeDate=Date changement pavillon

 observe.common.VesselDto.comId=Id EU

 observe.common.VesselDto.flagCountry=Pavillon

 observe.common.VesselDto.fleetCountry=Flotte

 observe.common.VesselDto.generalTab=Caractéristiques générales

 observe.common.VesselDto.imoId=Id IMO

 observe.common.VesselDto.keelCode=Code quille

 observe.common.VesselDto.keelCodeFlotte=Code quille /Code flotte

 observe.common.VesselDto.length=Longueur hors tout

         entity.setSearchMaximum(dto.getSearchMaximum());

         entity.setComment(dto.getComment());

         entity.setComId(dto.getComId());

         entity.setImoId(dto.getImoId());

         entity.setNationalId(dto.getNationalId());

         entity.setRadioCallSignId(dto.getRadioCallSignId());

         dto.setSearchMaximum(entity.getSearchMaximum());

         dto.setComment(entity.getComment());

         dto.setComId(entity.getComId());

         dto.setImoId(entity.getImoId());

         dto.setNationalId(entity.getNationalId());

         dto.setRadioCallSignId(entity.getRadioCallSignId());

 sex {*:1} referential.common.Sex | notNull lazy=false

 startDate + {*:1} Date

 endDate + {*:1} Date

 source + {*:1} String | hibernateAttributeType=text

 computeFromFormulaOne(data float) Float

 computeFromFormulaTwo(data float) Float

 setQuadrant(quadrant Integer)

 referential.common.LengthLengthParameter > referential.common.FormulaSupport | entity

 abstract referential.common.LengthWeightAble

 referential.common.LengthWeightParameter > referential.common.FormulaSupport | entity

 meanLength + {*:1} Float

 meanWeight + {*:1} Float

 referential.common.LengthMeasureMethod > referential.I18nReferentialEntity | entity

 power + {*:1} Integer

 searchMaximum + {*:1} Float | sqlType=numeric

 comment + {*:1} String | hibernateAttributeType=text

 nationalId + {*:1} String

 comId + {*:1} String

 tuviId + {*:1} String

 CREATE TABLE common.sizemeasuretype(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_sizemeasuretype PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needcomment BOOLEAN DEFAULT FALSE, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255));

 CREATE TABLE common.speciesgroup(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_speciesgroup PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, code VARCHAR(255), uri VARCHAR(255), status INTEGER DEFAULT 1, needcomment BOOLEAN, label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), lastupdatedate TIMESTAMP DEFAULT now() NOT NULL);

 CREATE TABLE common.species(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_species PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, code VARCHAR(255), homeid VARCHAR(255), wormsid BIGINT, uri VARCHAR(255), status INTEGER DEFAULT 1, faocode VARCHAR(255), needcomment BOOLEAN, scientificlabel VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), minlength NUMERIC, maxlength NUMERIC, minweight NUMERIC, maxweight NUMERIC, speciesgroup VARCHAR(255), lastupdatedate TIMESTAMP DEFAULT now() NOT NULL, sizemeasuretype VARCHAR(255));

 CREATE TABLE common.speciesgroupreleasemode(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_species_group_release_mode PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needcomment BOOLEAN DEFAULT FALSE, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255));

 CREATE TABLE common.specieslist(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_specieslist PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), needcomment BOOLEAN DEFAULT FALSE, lastupdatedate TIMESTAMP DEFAULT now() NOT NULL);

 CREATE TABLE common.vesselsizecategory(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_vesselsizecategory PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, code VARCHAR(255), uri VARCHAR(255), status INTEGER DEFAULT 1, capacitylabel VARCHAR(255), gaugelabel VARCHAR(255), needcomment BOOLEAN DEFAULT FALSE, lastupdatedate TIMESTAMP DEFAULT now() NOT NULL);

 CREATE TABLE common.vesseltype(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_vesseltype PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, code VARCHAR(255), uri VARCHAR(255), status INTEGER DEFAULT 1, label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), needcomment BOOLEAN DEFAULT FALSE, lastupdatedate TIMESTAMP DEFAULT now() NOT NULL);

 CREATE TABLE common.weightmeasuremethod(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_weightmeasuremethod PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needcomment BOOLEAN DEFAULT FALSE, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255));

 CREATE TABLE common.weightmeasuretype(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_weightmeasuretype PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needcomment BOOLEAN DEFAULT FALSE, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255));

 CREATE TABLE common.wind(topiaid VARCHAR(255) NOT NULL CONSTRAINT pk_wind PRIMARY KEY, topiaversion BIGINT NOT NULL, topiacreatedate DATE NOT NULL, code VARCHAR(255), speedrange VARCHAR(255), waveheight VARCHAR(255), uri VARCHAR(255), status INTEGER DEFAULT 1, label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255), label4 VARCHAR(255), label5 VARCHAR(255), label6 VARCHAR(255), label7 VARCHAR(255), label8 VARCHAR(255), needcomment BOOLEAN DEFAULT FALSE, lastupdatedate TIMESTAMP DEFAULT now() NOT NULL);

 CREATE TABLE common.speciesgroup_speciesgroupreleasemode(speciesgroup VARCHAR(255) NOT NULL, speciesgroupreleasemode VARCHAR(255) NOT NULL);

 CREATE TABLE common.species_specieslist(specieslist VARCHAR(255) NOT NULL, species VARCHAR(255) NOT NULL);

 INSERT INTO common.country(topiaid, topiaversion, topiacreatedate, code, uri, iso2code, iso3code, status, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate) SELECT topiaid, topiaversion, topiacreatedate, code, uri, iso2code, iso3code, status, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate FROM observe_common.country;

 INSERT INTO common.dataquality(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8) SELECT topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM observe_common.dataquality;

 INSERT INTO common.fpazone(topiaid, topiaversion, topiacreatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8, startdate, enddate, needcomment, lastupdatedate) SELECT topiaid, topiaversion, topiacreatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8, startdate, enddate, needcomment, lastupdatedate FROM observe_common.fpazone;

 INSERT INTO common.specieslist(topiaid, topiaversion, topiacreatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate) SELECT topiaid, topiaversion, topiacreatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate FROM observe_common.specieslist;

 INSERT INTO common.vesselsizecategory(topiaid, topiaversion, topiacreatedate, code, uri, status, capacitylabel, gaugelabel, needcomment, lastupdatedate) SELECT topiaid, topiaversion, topiacreatedate, code, uri, status, capacitylabel, gaugelabel, needcomment, lastupdatedate FROM observe_common.vesselsizecategory;

 INSERT INTO common.vesseltype(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate) SELECT topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate FROM observe_common.vesseltype;

 INSERT INTO common.weightmeasuremethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8) SELECT topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM observe_common.weightmeasuremethod;

 INSERT INTO common.weightmeasuretype(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8) SELECT topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM observe_common.weightmeasuretype;

 INSERT INTO common.wind(topiaid, topiaversion, topiacreatedate, code, speedrange, waveheight, uri, status, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate) SELECT topiaid, topiaversion, topiacreatedate, code, speedrange, waveheight, uri, status, label1, label2, label3, label4, label5, label6, label7, label8, needcomment, lastupdatedate FROM observe_common.wind;

             log.error(String.format("No size measure type found for TargetLength (%s) will use the one of the species", lengthWeightComputable.getTopiaId()));

             inputSizeMeasureType = species.getSizeMeasureType();

         }

         Optional<LengthWeightParameter> optionalLengthWeightParameter = activityContext.findLengthWeightParameter(species, sex, inputSizeMeasureType);

         if (!optionalLengthWeightParameter.isPresent()) {

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

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

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

  * License along with this program.  If not, see

  * <http://www.gnu.org/licenses/gpl-3.0.html>.

 import com.opensymphony.xwork2.interceptor.annotations.After;

 import fr.ird.observe.dto.referential.ReferenceStatus;

 import fr.ird.observe.entities.referential.LengthWeightParameterNotFoundException;

 import fr.ird.observe.entities.referential.common.LengthWeightParameterTopiaDao;

 import fr.ird.observe.entities.referential.common.LengthWeightParameters;

 import fr.ird.observe.entities.referential.common.Ocean;

 import fr.ird.observe.entities.referential.common.OceanTopiaDao;

 import fr.ird.observe.entities.referential.common.Sex;

 import fr.ird.observe.entities.referential.common.SexTopiaDao;

 import fr.ird.observe.entities.referential.common.Species;

 import fr.ird.observe.entities.referential.common.SpeciesTopiaDao;

 import fr.ird.observe.services.local.service.ServiceLocalTestSupport;

 import fr.ird.observe.test.spi.CopyDatabaseConfiguration;

 import org.apache.logging.log4j.LogManager;

 import org.junit.Assert;

 import org.junit.Before;

 import org.junit.Test;

                                                       Species species,

                                                       Ocean ocean,

                                                       Sex sex,

                                                       Date startDate,

                                                       Date endDate) {

         entity.setSpecies(species);

         entity.setSex(sex);

         entity.setOcean(ocean);

         entity.setStartDate(startDate);

         entity.setEndDate(endDate);

         entity.setStatus(ReferenceStatus.enabled);

         SpeciesTopiaDao speciesDAO = persistenceContext.getCommonSpeciesDao();

         OceanTopiaDao oceanDAO = persistenceContext.getCommonOceanDao();

         SexTopiaDao sexDao = persistenceContext.getCommonSexDao();

         Optional<Species> optionalSpecies = Optional.ofNullable(speciesDAO.forFaoCodeEquals("ALB").tryFindUnique().orNull());

         Assert.assertTrue("Could not find species with faoCode: DOL", optionalSpecies.isPresent());

         Optional<Sex> optionalFemaleSex = Optional.ofNullable(sexDao.forCodeEquals("2").tryFindUnique().orNull());

         Assert.assertTrue("Could not find sex with code 2 (female)", optionalFemaleSex.isPresent());

         Date firstStartDate = DateUtil.createDate(1, 1, 2010);

         Date firstEndDate = DateUtil.createDate(31, 12, 2010);

         Date secondStartDate = DateUtil.createDate(1, 1, 2011);

         Ocean indianOcean = optionalIndianOcean.orElse(null);

         // Ajout parametrage Male / Atlantique (2010)

         // Ajout parametrage Male / Atlantique (après 2010)

         // Ajout parametrage Male / Indien (2010)

         // Ajout parametrage Male / Indien (Après 2010)

     }

         SpeciesTopiaDao speciesDAO = persistenceContext.getCommonSpeciesDao();

         OceanTopiaDao oceanDAO = persistenceContext.getCommonOceanDao();

         SexTopiaDao sexDao = persistenceContext.getCommonSexDao();

         Optional<Species> optionalSpecies = Optional.ofNullable(speciesDAO.forFaoCodeEquals("ALB").tryFindUnique().orNull());

         Assert.assertTrue("Could not find species with faoCode: DOL", optionalSpecies.isPresent());

         Ocean indianOcean = optionalIndianOcean.orElse(null);

         Ocean pacificOcean = optionalPacificOcean.orElse(null);

         // this test is now working!!! since we manage now perfectly null-null date range