Author: tchemit Date: 2013-01-12 18:59:34 +0100 (Sat, 12 Jan 2013) New Revision: 181 Url: http://forge.codelutin.com/projects/tutti/repository/revisions/181 Log: - refs #1807: [Persistence] Adagio r?\195?\169f?\195?\169rentiel (implements new service) - improve Spring usage (add a ServiceLocator) - add request doc - improve tests Added: trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiEnumerationFile.java trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/ trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceImpl.java trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/TuttiPersistenceServiceLocator.java trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/service/ trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceTest.java Removed: trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ReferentialTest.java Modified: trunk/tutti-persistence-adagio/pom.xml trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiPersistenceAdagioImpl.java trunk/tutti-persistence-adagio/src/main/resources/applicationContext-service-tutti.xml trunk/tutti-persistence-adagio/src/main/resources/beanRefFactory.xml trunk/tutti-persistence-adagio/src/main/resources/queries-override.hbm.xml trunk/tutti-persistence-adagio/src/main/resources/tutti-db-enumerations.properties trunk/tutti-persistence-adagio/src/main/site/rst/referential.rst trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/CruiseTest.java trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/DatabaseResource.java trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ProgramTest.java trunk/tutti-persistence-adagio/src/test/resources/tutti-test.properties Modified: trunk/tutti-persistence-adagio/pom.xml =================================================================== --- trunk/tutti-persistence-adagio/pom.xml 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/pom.xml 2013-01-12 17:59:34 UTC (rev 181) @@ -57,14 +57,12 @@ <artifactId>nuiton-utils</artifactId> </dependency> - <!--dependency> + <dependency> <groupId>com.google.guava</groupId> <artifactId>guava</artifactId> </dependency> - - - <dependency> + <!--dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-lang3</artifactId> </dependency--> @@ -84,16 +82,18 @@ <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> </dependency> + + <dependency> + <groupId>org.springframework</groupId> + <artifactId>spring-beans</artifactId> + </dependency> <!--dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> </dependency> + <dependency> <groupId>org.springframework</groupId> - <artifactId>spring-beans</artifactId> - </dependency> - <dependency> - <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> </dependency> <dependency> Added: trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiEnumerationFile.java =================================================================== --- trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiEnumerationFile.java (rev 0) +++ trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiEnumerationFile.java 2013-01-12 17:59:34 UTC (rev 181) @@ -0,0 +1,156 @@ +package fr.ifremer.tutti.persistence; + +/* + * #%L + * Tutti :: Persistence Adagio (impl) + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2012 - 2013 Ifremer + * %% + * This program 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. + * + * 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>. + * #L% + */ + +import com.google.common.base.Preconditions; +import org.springframework.beans.factory.annotation.Value; + +/** + * Contains all constants usablevia the enumeration file. + * + * @author tchemit <chemit@codelutin.com> + * @since 0.3 + */ +public class TuttiEnumerationFile { + + @Value("${GearClassificationId.SCIENTIFIC_CRUISE}") + public final Integer GEAR_CLASSIFICIATION_ID_SCIENTIFIC = null; + + @Value("${GearClassificationId.FAO}") + public final Integer GEAR_CLASSIFICIATION_ID_FISHING = null; + + @Value("${LocationLevelId.PAYS_ISO3}") + public final Integer LOCATION_LEVEL_ID_COUNTRY = null; + + @Value("${LocationLevelId.LOCALITE}") + public final Integer LOCATION_LEVEL_ID_LOCALITE = null; + + @Value("${LocationLevelId.PROGRAM}") + public final Integer LOCATION_LEVEL_ID_PROGRAMM = null; + + @Value("${LocationLevelId.STRATA}") + public final Integer LOCATION_LEVEL_ID_STRATA = null; + + @Value("${LocationLevelId.SUBSTRATA}") + public final Integer LOCATION_LEVEL_ID_SUB_STRATA = null; + + @Value("${MatrixId.GEAR}") + public final Integer MATRIX_ID_GEAR = null; + + @Value("${MatrixId.INDIVIDUAL}") + public final Integer MATRIX_ID_INDIVIDUAL = null; + + @Value("${MethodId.DECLARATION}") + public final Integer METHOD_ID_DECLARATION = null; + + @Value("${ParameterCode.AGE}") + public final String PARAMETER_CODE_AGE = null; + + @Value("${ParameterCode.WEIGHT}") + public final String PARAMETER_CODE_WEIGHT = null; + + @Value("${ParameterGroupId.ENVIRONEMENT_MEASUREMENT}") + public final Integer PARAMETER_GROUP_ENVIRONEMENT_MEASUREMENT = null; + + @Value("${ParameterGroupId.HYDROLOGIC_MEASUREMENT}") + public final Integer PARAMETER_GROUP_HYDROLOGIC = null; + + @Value("${PmfmId.SIZE_CATEGORY}") + public final Integer PMFM_ID_SIZE_CATEGORY = null; + + @Value("${PmfmId.SEX}") + public final Integer PMFM_ID_SEX = null; + + @Value("${PmfmId.SORTED_UNSORTED}") + public final Integer PMFM_ID_SORTED_UNSORTED = null; + + @Value("${PmfmId.MATURITY}") + public final Integer PMFM_ID_MATURITY = null; + + @Value("${PmfmId.MACRO_WASTE_CATEGORY}") + public final Integer PMFM_ID_MACRO_WASTE_CATEGORY = null; + + @Value("${PmfmId.MACRO_WASTE_SIZE_CATEGORY}") + public final Integer PMFM_ID_MACRO_WASTE_SIZE_CATEGORY = null; + + @Value("${UnitId.NONE}") + public final Integer UNIT_ID_NONE = null; + + @Value("${UserProfilId.OBSERVER}") + public final Integer USER_PROFIL_ID_OBSERVER = null; + + @Value("${UserProfilId.PROJECT_MEMBER}") + public final Integer USER_PROFIL_ID_PROJECT_MEMBER = null; + + @Value("${UserProfilId.USER}") + public final Integer USER_PROFIL_ID_USER = null; + + @Value("${VesselTypeId.SCIENTIFIC_RESEARCH_VESSEL}") + public final Integer VESSEL_TYPE_ID_SCIENTIFIC = null; + + @Value("${VesselTypeId.FISHING_VESSEL}") + public final Integer VESSEL_TYPE_ID_FISHING = null; + + @Value("${LocationLevelId.RECTANGLE_STATISTIQUE_MED}") + public final Integer RECTANGLE_STATISTIQUE_MED = null; + + @Value("${StatusCode.ENABLE}") + public final Integer STATUS_VALID_CODE = null; + + @Value("${StatusCode.TEMPORARY}") + public final Integer STATUS_TEMPORARY_CODE = null; + + public void init() { + Preconditions.checkNotNull(GEAR_CLASSIFICIATION_ID_SCIENTIFIC, "GEAR_CLASSIFICIATION_ID_SCIENTIFIC constant not found"); + Preconditions.checkNotNull(GEAR_CLASSIFICIATION_ID_FISHING, "GEAR_CLASSIFICIATION_ID_FISHING constant not found"); + Preconditions.checkNotNull(LOCATION_LEVEL_ID_COUNTRY, "LOCATION_LEVEL_ID_COUNTRY constant not found"); + Preconditions.checkNotNull(LOCATION_LEVEL_ID_LOCALITE, "LOCATION_LEVEL_ID_LOCALITE constant not found"); + Preconditions.checkNotNull(LOCATION_LEVEL_ID_PROGRAMM, "LOCATION_LEVEL_ID_PROGRAMM constant not found"); + Preconditions.checkNotNull(LOCATION_LEVEL_ID_STRATA, "LOCATION_LEVEL_ID_STRATA constant not found"); + Preconditions.checkNotNull(LOCATION_LEVEL_ID_SUB_STRATA, "LOCATION_LEVEL_ID_SUB_STRATA constant not found"); + Preconditions.checkNotNull(MATRIX_ID_GEAR, "MATRIX_ID_GEAR constant not found"); + Preconditions.checkNotNull(MATRIX_ID_INDIVIDUAL, "MATRIX_ID_INDIVIDUAL constant not found"); + Preconditions.checkNotNull(METHOD_ID_DECLARATION, "METHOD_ID_DECLARATION constant not found"); + Preconditions.checkNotNull(PARAMETER_CODE_AGE, "PARAMETER_CODE_AGE constant not found"); + Preconditions.checkNotNull(PARAMETER_CODE_WEIGHT, "PARAMETER_CODE_WEIGHT constant not found"); + Preconditions.checkNotNull(PARAMETER_GROUP_ENVIRONEMENT_MEASUREMENT, "PARAMETER_GROUP_ENVIRONEMENT_MEASUREMENT constant not found"); + Preconditions.checkNotNull(PARAMETER_GROUP_HYDROLOGIC, "PARAMETER_GROUP_HYDROLOGIC constant not found"); + Preconditions.checkNotNull(PMFM_ID_SIZE_CATEGORY, "PMFM_ID_SIZE_CATEGORY constant not found"); + Preconditions.checkNotNull(PMFM_ID_SEX, "PMFM_ID_SEX constant not found"); + Preconditions.checkNotNull(PMFM_ID_SORTED_UNSORTED, "PMFM_ID_SORTED_UNSORTED constant not found"); + Preconditions.checkNotNull(PMFM_ID_MATURITY, "PMFM_ID_MATURITY constant not found"); + Preconditions.checkNotNull(PMFM_ID_MACRO_WASTE_CATEGORY, "PMFM_ID_MACRO_WASTE_CATEGORY constant not found"); + Preconditions.checkNotNull(PMFM_ID_MACRO_WASTE_SIZE_CATEGORY, "PMFM_ID_MACRO_WASTE_SIZE_CATEGORY constant not found"); + Preconditions.checkNotNull(UNIT_ID_NONE, "UNIT_ID_NONE constant not found"); + Preconditions.checkNotNull(USER_PROFIL_ID_OBSERVER, "USER_PROFIL_ID_OBSERVER constant not found"); + Preconditions.checkNotNull(USER_PROFIL_ID_PROJECT_MEMBER, "USER_PROFIL_ID_PROJECT_MEMBER constant not found"); + Preconditions.checkNotNull(USER_PROFIL_ID_USER, "USER_PROFIL_ID_USER constant not found"); + Preconditions.checkNotNull(VESSEL_TYPE_ID_SCIENTIFIC, "VESSEL_TYPE_ID_SCIENTIFIC constant not found"); + Preconditions.checkNotNull(VESSEL_TYPE_ID_FISHING, "VESSEL_TYPE_ID_FISHING constant not found"); + Preconditions.checkNotNull(RECTANGLE_STATISTIQUE_MED, "LocationLevelId.RECTANGLE_STATISTIQUE_MED constant not found"); + Preconditions.checkNotNull(STATUS_VALID_CODE, "StatusCode.ENABLE constant not found"); + Preconditions.checkNotNull(STATUS_TEMPORARY_CODE, "StatusCode.TEMPORARY constant not found"); + } +} Property changes on: trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiEnumerationFile.java ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Modified: trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiPersistenceAdagioImpl.java =================================================================== --- trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiPersistenceAdagioImpl.java 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/TuttiPersistenceAdagioImpl.java 2013-01-12 17:59:34 UTC (rev 181) @@ -37,25 +37,24 @@ import fr.ifremer.tutti.persistence.entities.data.SpeciesBatch; import fr.ifremer.tutti.persistence.entities.data.SpeciesBatchFrequency; import fr.ifremer.tutti.persistence.entities.protocol.TuttiProtocol; -import fr.ifremer.tutti.persistence.entities.referential.AbstractTuttiReferentialEntity; import fr.ifremer.tutti.persistence.entities.referential.Caracteristic; -import fr.ifremer.tutti.persistence.entities.referential.CaracteristicQualitativeValue; import fr.ifremer.tutti.persistence.entities.referential.Country; import fr.ifremer.tutti.persistence.entities.referential.FishingOperationLocation; import fr.ifremer.tutti.persistence.entities.referential.Gear; import fr.ifremer.tutti.persistence.entities.referential.Person; import fr.ifremer.tutti.persistence.entities.referential.Species; -import fr.ifremer.tutti.persistence.entities.referential.Status; import fr.ifremer.tutti.persistence.entities.referential.Vessel; import fr.ifremer.tutti.persistence.entities.referential.Zone; +import fr.ifremer.tutti.persistence.service.ReferentialPersistenceService; +import fr.ifremer.tutti.persistence.service.TuttiPersistenceServiceLocator; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.Query; import org.hibernate.SessionFactory; -import org.hibernate.type.DateType; import org.hibernate.type.IntegerType; import org.hibernate.type.StringType; import org.hibernate.type.Type; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; @@ -63,13 +62,11 @@ import java.util.Date; import java.util.Iterator; import java.util.List; -import java.util.Properties; /** * @author tchemit <chemit@codelutin.com> * @since 0.2 */ -//@TransactionConfiguration(transactionManager = "transactionManager") @Transactional(readOnly = true) public class TuttiPersistenceAdagioImpl implements TuttiPersistence { @@ -82,21 +79,18 @@ * * @since 0.3 */ + @Autowired(required = true) protected SessionFactory sessionFactory; @Resource(name = "programDao") protected ProgramDao programDao; - protected Properties enumerations; + @Autowired(required = true) + protected ReferentialPersistenceService referentielService; - public void setSessionFactory(SessionFactory sessionFactory) { - this.sessionFactory = sessionFactory; - } + @Autowired(required = true) + protected TuttiEnumerationFile enumeration; - public void setEnumerations(Properties enumerations) { - this.enumerations = enumerations; - } - @Override public String getImplementationName() { return "Persistence Adagio implementation"; @@ -104,8 +98,9 @@ @Override public void open() throws IOException { - Preconditions.checkNotNull(sessionFactory, " No sessionFactory property setted"); - Preconditions.checkNotNull(enumerations, " No enumerations property setted"); + if (log.isInfoEnabled()) { + log.info("Open persistence driver " + getImplementationName()); + } } @Override @@ -114,8 +109,7 @@ if (log.isInfoEnabled()) { log.info("Close persistence driver " + getImplementationName()); } - - sessionFactory.close(); + TuttiPersistenceServiceLocator.close(); } //------------------------------------------------------------------------// @@ -124,322 +118,127 @@ @Override public List<Zone> getAllProgramZone() { - Iterator<Object[]> list = queryList( - "allProgramZones", - "locationLevelId", IntegerType.INSTANCE, getEnumerationIntegerCode("LocationLevelId.PROGRAM")); - - List<Zone> result = Lists.newArrayList(); - while (list.hasNext()) { - Object[] source = list.next(); - Zone target = new Zone(); - target.setId((String) source[0]); - target.setName((String) source[1]); - target.setDescription((String) source[2]); - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[3], target); - result.add(target); - } - return result; + return referentielService.getAllProgramZone(); } @Override public List<Country> getAllCountry() { - Iterator<Object[]> list = queryList( - "allCountries", - "locationLevelId", IntegerType.INSTANCE, getEnumerationIntegerCode("LocationLevelId.PAYS_ISO3")); - - List<Country> result = Lists.newArrayList(); - while (list.hasNext()) { - Object[] source = list.next(); - Country target = new Country(); - target.setId(String.valueOf(source[0])); - target.setName((String) source[1]); - target.setDescription((String) source[2]); - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[3], target); - result.add(target); - } - return result; + return referentielService.getAllCountry(); } @Override public List<Vessel> getAllScientificVessel() { - - Iterator<Object[]> list = queryList( - "allVessels", - "refDate", DateType.INSTANCE, new Date(), - "vesselTypeId", IntegerType.INSTANCE, getEnumerationIntegerCode("VesselTypeId.SCIENTIFIC_RESEARCH_VESSEL")); - - List<Vessel> result = Lists.newArrayList(); - while (list.hasNext()) { - Object[] source = list.next(); - Vessel target = loadVessel(source); - result.add(target); - } - return result; + return referentielService.getAllScientificVessel(); } @Override public List<Vessel> getAllFishingVessel() { - Iterator<Object[]> list = queryList( - "allVessels", - "refDate", DateType.INSTANCE, new Date(), - "vesselTypeId", IntegerType.INSTANCE, getEnumerationIntegerCode("VesselTypeId.FISHING_VESSEL")); - - List<Vessel> result = Lists.newArrayList(); - while (list.hasNext()) { - Object[] source = list.next(); - Vessel target = loadVessel(source); - result.add(target); - } - return result; + return referentielService.getAllFishingVessel(); } @Override - public List<Gear> getAllScientificGear() { - - Iterator<Object[]> sources = queryList( - "allGears", - "gearClassificiationId", IntegerType.INSTANCE, getEnumerationIntegerCode("GearClassificationId.SCIENTIFIC_CRUISE")); - List<Gear> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Gear target = loadGear(source); - result.add(target); - } - return result; + public List<Species> getAllSpecies() { + return referentielService.getAllSpecies(); } @Override - public List<Gear> getAllFishingGear() { - Iterator<Object[]> sources = queryList( - "allGears", - "gearClassificiationId", IntegerType.INSTANCE, getEnumerationIntegerCode("GearClassificationId.FAO")); - List<Gear> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Gear target = loadGear(source); - result.add(target); - } - return result; + public List<Species> getAllBenthosSpecies() { + return referentielService.getAllBenthosSpecies(); } @Override - public List<Person> getAllPerson() { - Iterator<Object[]> list = queryList( - "allPersons", - "observerProfilId", IntegerType.INSTANCE, getEnumerationIntegerCode("UserProfilId.OBSERVER"), - "projectMemberProfilId", IntegerType.INSTANCE, getEnumerationIntegerCode("UserProfilId.PROJECT_MEMBER"), - "userProfilId", IntegerType.INSTANCE, getEnumerationIntegerCode("UserProfilId.USER") - ); - - List<Person> result = Lists.newArrayList(); - while (list.hasNext()) { - Object[] source = list.next(); - Person target = loadPerson(source); - result.add(target); - } - return result; + public List<Species> getAllPlanktonSpecies() { + return referentielService.getAllPlanktonSpecies(); } @Override - public List<Species> getAllSpecies() { - Iterator<Object[]> sources = queryList( - "allSpecies", - "taxonGroupCode", IntegerType.INSTANCE, getEnumerationIntegerCode("TaxonGroupTypeCode.METIER_SPECIES")); - - List<Species> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Species target = loadSpecies(source); - result.add(target); - } - return result; + public Species getSpecies(String speciesId) { + return referentielService.getSpecies(speciesId); } @Override - public Species getSpecies(String speciesId) { - Object[] source = queryUnique("species", - "taxonGroupCode", IntegerType.INSTANCE, Integer.valueOf(speciesId)); - - Species target = loadSpecies(source); - return target; + public List<FishingOperationLocation> getAllFishingOperationStrata(String zoneId) { + return referentielService.getAllFishingOperationStrata(zoneId); } @Override - public List<Species> getAllBenthosSpecies() { - Iterator<Object[]> sources = queryList( - "allBenthosSpecies", - "taxonGroupCode", IntegerType.INSTANCE, getEnumerationIntegerCode("TaxonGroupTypeCode.METIER_SPECIES")); - - List<Species> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Species target = loadSpecies(source); - result.add(target); - } - return result; + public List<FishingOperationLocation> getAllFishingOperationSubStrata(String locationId) { + return referentielService.getAllFishingOperationSubStrata(locationId); } @Override - public List<Species> getAllPlanktonSpecies() { - Iterator<Object[]> sources = queryList( - "allPlanktonSpecies", - "taxonGroupCode", IntegerType.INSTANCE, getEnumerationIntegerCode("TaxonGroupTypeCode.METIER_SPECIES")); - - List<Species> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Species target = loadSpecies(source); - result.add(target); - } - return result; + public List<FishingOperationLocation> getAllFishingOperationLocation(String locationId) { + return referentielService.getAllFishingOperationLocation(locationId); } @Override - public List<Caracteristic> getAllSpeciesLengthStepCaracteristic() { - Iterator<Object[]> sources = queryList( - "allLengthStepCaracteristics", - "matrixId", IntegerType.INSTANCE, getEnumerationIntegerCode("MatrixId.INDIVIDUAL"), - "ageParameterCode", StringType.INSTANCE, getEnumerationStringCode("ParameterCode.AGE"), - "weightParameterCode", StringType.INSTANCE, getEnumerationStringCode("ParameterCode.WEIGHT"), - "methodDeclarationId", IntegerType.INSTANCE, getEnumerationIntegerCode("MethodId.DECLARATION")); - List<Caracteristic> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Caracteristic target = loadCaracteristic(source); - result.add(target); - } - return result; + public List<Caracteristic> getAllFishingOperationEnvironmentCaracteristic() { + return referentielService.getAllFishingOperationEnvironmentCaracteristic(); } @Override public List<Caracteristic> getAllFishingOperationGearCaracteristic() { - Iterator<Object[]> sources = queryList( - "allPmfmsByMatrixId", - "matrixId", IntegerType.INSTANCE, getEnumerationIntegerCode("MatrixId.GEAR")); - List<Caracteristic> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Caracteristic target = loadCaracteristic(source); - result.add(target); - } - return result; + return referentielService.getAllFishingOperationGearCaracteristic(); } @Override - public List<Caracteristic> getAllFishingOperationEnvironmentCaracteristic() { - Iterator<Object[]> sources = queryList( - "allPmfmsByParameterGroudId", - "parameterGroupId", IntegerType.INSTANCE, getEnumerationIntegerCode("ParameterGroupId.ENVIRONEMENT_MEASUREMENT")); - List<Caracteristic> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Caracteristic target = loadCaracteristic(source); - result.add(target); - } - return result; + public List<Caracteristic> getAllFishingOperationHydrologicCaracteristic() { + return referentielService.getAllFishingOperationHydrologicCaracteristic(); } @Override - public List<Caracteristic> getAllFishingOperationHydrologicCaracteristic() { - Iterator<Object[]> sources = queryList( - "allPmfmsByParameterGroudId", - "parameterGroupId", IntegerType.INSTANCE, getEnumerationIntegerCode("ParameterGroupId.HYDROLOGIC_MEASUREMENT")); - List<Caracteristic> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - Caracteristic target = loadCaracteristic(source); - result.add(target); - } - return result; + public List<Caracteristic> getAllSpeciesLengthStepCaracteristic() { + return referentielService.getAllSpeciesLengthStepCaracteristic(); } @Override - public List<FishingOperationLocation> getAllFishingOperationStrata(String zoneId) { - Iterator<Object[]> sources = queryList( - "allFishingOperationStratas", - "locationLevel", IntegerType.INSTANCE, getEnumerationIntegerCode("LocationLevelId.STRATA")); - List<FishingOperationLocation> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - FishingOperationLocation target = loadFishingOperationLocation(source); - result.add(target); - } - return result; + public Caracteristic getSizeCategoryCaracteristic() { + return referentielService.getSizeCategoryCaracteristic(); } @Override - public List<FishingOperationLocation> getAllFishingOperationSubStrata(String locationId) { - Iterator<Object[]> sources = queryList( - "allFishingOperationSubStratas", - "locationLevel", IntegerType.INSTANCE, getEnumerationIntegerCode("LocationLevelId.SUBSTRATA")); - List<FishingOperationLocation> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - FishingOperationLocation target = loadFishingOperationLocation(source); - result.add(target); - } - return result; + public Caracteristic getSexCaracteristic() { + return referentielService.getSexCaracteristic(); } @Override - public List<FishingOperationLocation> getAllFishingOperationLocation(String locationId) { - Iterator<Object[]> sources = queryList( - "allFishingOperationLocalites", - "locationLevel", IntegerType.INSTANCE, getEnumerationIntegerCode("LocationLevelId.LOCALITE")); - List<FishingOperationLocation> result = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - FishingOperationLocation target = loadFishingOperationLocation(source); - result.add(target); - } - return result; + public Caracteristic getSortedUnsortedCaracteristic() { + return referentielService.getSortedUnsortedCaracteristic(); } @Override - public Caracteristic getSizeCategoryCaracteristic() { - Integer pmfmId = getEnumerationIntegerCode("PmfmId.SIZE_CATEGORY"); - Caracteristic result = loadCaracteristic(pmfmId); - return result; + public Caracteristic getMaturityCaracteristic() { + return referentielService.getMaturityCaracteristic(); } @Override - public Caracteristic getSexCaracteristic() { - Integer pmfmId = getEnumerationIntegerCode("PmfmId.SEX"); - Caracteristic result = loadCaracteristic(pmfmId); - return result; + public Caracteristic getMacroWasteCategoryCaracteristic() { + return referentielService.getMacroWasteCategoryCaracteristic(); } @Override - public Caracteristic getSortedUnsortedCaracteristic() { - Integer pmfmId = getEnumerationIntegerCode("PmfmId.SORTED_UNSORTED"); - Caracteristic result = loadCaracteristic(pmfmId); - return result; + public Caracteristic getMacroWasteSizeCategoryCaracteristic() { + return referentielService.getMacroWasteSizeCategoryCaracteristic(); } @Override - public Caracteristic getMaturityCaracteristic() { - Integer pmfmId = getEnumerationIntegerCode("PmfmId.MATURITY"); - Caracteristic result = loadCaracteristic(pmfmId); - return result; + public List<Gear> getAllScientificGear() { + return referentielService.getAllScientificGear(); } @Override - public Caracteristic getMacroWasteCategoryCaracteristic() { - Integer pmfmId = getEnumerationIntegerCode("PmfmId.MACRO_WASTE_CATEGORY"); - Caracteristic result = loadCaracteristic(pmfmId); - return result; + public List<Gear> getAllFishingGear() { + return referentielService.getAllFishingGear(); } @Override - public Caracteristic getMacroWasteSizeCategoryCaracteristic() { - Integer pmfmId = getEnumerationIntegerCode("PmfmId.MACRO_WASTE_SIZE_CATEGORY"); - Caracteristic result = loadCaracteristic(pmfmId); - return result; + public List<Person> getAllPerson() { + return referentielService.getAllPerson(); } + //------------------------------------------------------------------------// //-- Program methods --// //------------------------------------------------------------------------// - //------------------------------------------------------------------------// @Override public List<Program> getAllProgram() { @@ -524,7 +323,7 @@ Object[] source = queryUnique( "cruise", "cruiseId", StringType.INSTANCE, id, - "locationLevelId", IntegerType.INSTANCE, getEnumerationIntegerCode("LocationLevelId.PAYS_ISO3")); + "locationLevelId", IntegerType.INSTANCE, enumeration.LOCATION_LEVEL_ID_LOCALITE); Cruise result = new Cruise(); result.setId(id); @@ -549,11 +348,11 @@ result.setEndDate((Date) source[7]); String vesselCode = (String) source[8]; - Vessel vessel = getVessel(vesselCode); + Vessel vessel = referentielService.getVessel(vesselCode); result.setVessel(Lists.newArrayList(vessel)); Integer managerId = (Integer) source[9]; - Person manager = getPerson(managerId); + Person manager = referentielService.getPerson(managerId); result.setHeadOfMission(Lists.newArrayList(manager)); result.setComment((String) source[10]); @@ -576,33 +375,6 @@ return result; } - protected Vessel getVessel(String vesselCode) { - Object[] source = queryUnique( - "vessel", - "vesselCode", StringType.INSTANCE, vesselCode, - "refDate", DateType.INSTANCE, new Date()); - Vessel result = loadVessel(source); - return result; - } - - protected Person getPerson(Integer personId) { - Object[] source = queryUnique( - "person", - "personId", IntegerType.INSTANCE, personId); - Person result = loadPerson(source); - return result; - } - - protected Person loadPerson(Object[] source) { - Person target = new Person(); - target.setId(String.valueOf(source[0])); - target.setFirstName((String) source[1]); - target.setLastName((String) source[2]); - target.setDepartment((String) source[3]); - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[4], target); - return target; - } - @Override public Cruise createCruise(Cruise bean) { throw new UnsupportedOperationException(); @@ -833,26 +605,6 @@ //-- Internal methods --// //------------------------------------------------------------------------// - protected <E extends AbstractTuttiReferentialEntity> void setStatus(fr.ifremer.adagio.core.dao.referential.Status status, E entity) { - Status newStatus = new Status(); - newStatus.setId(status.getCode()); - newStatus.setName(status.getName()); - entity.setStatus(newStatus); - } - - protected String getEnumerationStringCode(String key) { - String result = enumerations.getProperty(key); - Preconditions.checkNotNull( - result, - "Could not find enumeration code for key [" + key + ']'); - return result; - } - - protected Integer getEnumerationIntegerCode(String key) { - String value = getEnumerationStringCode(key); - return Integer.valueOf(value); - } - protected Iterator<Object[]> queryList(String queryName, Object... params) { Query query = sessionFactory.getCurrentSession().getNamedQuery(queryName); @@ -907,99 +659,4 @@ return (Object[]) result; } - protected void loadCaracteristicQualitativeValues(Caracteristic caracteristic, - Integer pmfmId) { - Preconditions.checkNotNull(caracteristic, "Caracteristic can not be null"); - Preconditions.checkNotNull(pmfmId, "pmfmId can not be null"); - Preconditions.checkArgument(caracteristic.isQualitativeType(), - "Caracteristic must be a qualitativeValue type"); - - Iterator<Object[]> sources = queryList( - "pmfmQualitativeValues", - "pmfmId", IntegerType.INSTANCE, pmfmId); - - List<CaracteristicQualitativeValue> values = Lists.newArrayList(); - while (sources.hasNext()) { - Object[] source = sources.next(); - CaracteristicQualitativeValue target = new CaracteristicQualitativeValue(); - target.setId(String.valueOf(source[0])); - target.setName(String.valueOf(source[1])); - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[2], target); - values.add(target); - } - caracteristic.setQualitativeValue(values); - } - - protected Caracteristic loadCaracteristic(Integer pmfmId) { - - Object[] source = queryUnique("pmfmById", - "pmfmId", IntegerType.INSTANCE, pmfmId); - - Caracteristic target = loadCaracteristic(source); - - if (target.isQualitativeType()) { - - // load qualititative values - loadCaracteristicQualitativeValues(target, pmfmId); - } - return target; - } - - protected Caracteristic loadCaracteristic(Object[] source) { - - Caracteristic target = new Caracteristic(); - target.setId(String.valueOf(source[0])); - target.setParameterName((String)source[1]); - target.setMatrixName((String)source[2]); - target.setFractionName((String)source[3]); - target.setMethodName((String)source[4]); - target.setNumberType((Boolean)source[5]); - target.setQualitativeType((Boolean)source[6]); - target.setSignifFiguresNumber((Integer)source[7]); - target.setMaximumNumberDecimals((Integer)source[8]); - target.setPrecision((Float)source[9]); - target.setUnit((String)source[10]); - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[11], target); - return target; - } - - protected FishingOperationLocation loadFishingOperationLocation(Object[] source) { - FishingOperationLocation target = new FishingOperationLocation(); - target.setId(String.valueOf(source[0])); - target.setName(String.valueOf(source[1])); - target.setLabel(String.valueOf(source[2])); - target.setDescription(String.valueOf(source[3])); - target.setLocationLevel(Integer.valueOf(source[4].toString())); - - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[5], target); - return target; - } - - protected Species loadSpecies(Object[] source) { - Species target = new Species(); - target.setId(String.valueOf(source[0])); - target.setCodeMemo(String.valueOf(source[1])); - target.setName(String.valueOf(source[2])); - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[3], target); - return target; - } - - protected Vessel loadVessel(Object[] source) { - Vessel target = new Vessel(); - target.setId((String) source[0]); - target.setRegistrationCode((String) source[1]); - target.setInternalRegistrationCode((String) source[2]); - target.setName((String) source[3]); - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[4], target); - return target; - } - - protected Gear loadGear(Object[] source) { - Gear result = new Gear(); - result.setId(String.valueOf(source[0])); - result.setName(String.valueOf(source[1])); - result.setLabel(String.valueOf(source[2])); - setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[3], result); - return result; - } } Added: trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceImpl.java =================================================================== --- trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceImpl.java (rev 0) +++ trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceImpl.java 2013-01-12 17:59:34 UTC (rev 181) @@ -0,0 +1,597 @@ +package fr.ifremer.tutti.persistence.service; + +/* + * #%L + * Tutti :: Persistence Adagio (impl) + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2012 - 2013 Ifremer + * %% + * This program 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. + * + * 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>. + * #L% + */ + +import com.google.common.base.Preconditions; +import com.google.common.collect.Lists; +import fr.ifremer.adagio.core.dao.referential.taxon.TaxonRefTaxVO; +import fr.ifremer.adagio.core.dao.referential.taxon.TaxonSpecificDao; +import fr.ifremer.tutti.persistence.TuttiEnumerationFile; +import fr.ifremer.tutti.persistence.entities.referential.AbstractTuttiReferentialEntity; +import fr.ifremer.tutti.persistence.entities.referential.Caracteristic; +import fr.ifremer.tutti.persistence.entities.referential.CaracteristicQualitativeValue; +import fr.ifremer.tutti.persistence.entities.referential.Country; +import fr.ifremer.tutti.persistence.entities.referential.FishingOperationLocation; +import fr.ifremer.tutti.persistence.entities.referential.Gear; +import fr.ifremer.tutti.persistence.entities.referential.Person; +import fr.ifremer.tutti.persistence.entities.referential.Species; +import fr.ifremer.tutti.persistence.entities.referential.Status; +import fr.ifremer.tutti.persistence.entities.referential.Vessel; +import fr.ifremer.tutti.persistence.entities.referential.Zone; +import org.apache.commons.logging.Log; +import org.apache.commons.logging.LogFactory; +import org.hibernate.Query; +import org.hibernate.SessionFactory; +import org.hibernate.type.DateType; +import org.hibernate.type.IntegerType; +import org.hibernate.type.StringType; +import org.hibernate.type.Type; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.transaction.annotation.Transactional; + +import javax.annotation.Resource; +import java.util.Date; +import java.util.Iterator; +import java.util.List; + +/** + * Implementation of the {@link ReferentialPersistenceService} using a adagio + * data-source. + * + * @author tchemit <chemit@codelutin.com> + * @since 0.3 + */ +@Transactional(readOnly = true) +public class ReferentialPersistenceServiceImpl implements ReferentialPersistenceService { + + /** Logger. */ + private static final Log log = + LogFactory.getLog(ReferentialPersistenceServiceImpl.class); + + /** + * Session factory. + * + * @since 0.3 + */ + @Autowired(required = true) + protected SessionFactory sessionFactory; + + @Resource(name = "taxonSpecificDao") + protected TaxonSpecificDao taxonSpecificDao; + + @Autowired(required = true) + protected TuttiEnumerationFile enumeration; + + //------------------------------------------------------------------------// + //-- ReferentialPersistenceService implentation --// + //------------------------------------------------------------------------// + + @Override + public List<Zone> getAllProgramZone() { + Iterator<Object[]> list = queryListWithStatus( + "allProgramZones", + "locationLevelId", IntegerType.INSTANCE, enumeration.LOCATION_LEVEL_ID_PROGRAMM); + + List<Zone> result = Lists.newArrayList(); + while (list.hasNext()) { + Object[] source = list.next(); + Zone target = new Zone(); + target.setId((String) source[0]); + target.setName((String) source[1]); + target.setDescription((String) source[2]); + setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[3], target); + result.add(target); + } + return result; + } + + @Override + public List<Country> getAllCountry() { + Iterator<Object[]> list = queryListWithStatus( + "allCountries", + "locationLevelId", IntegerType.INSTANCE, enumeration.LOCATION_LEVEL_ID_COUNTRY); + + List<Country> result = Lists.newArrayList(); + while (list.hasNext()) { + Object[] source = list.next(); + Country target = new Country(); + target.setId(String.valueOf(source[0])); + target.setName((String) source[1]); + target.setDescription((String) source[2]); + setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[3], target); + result.add(target); + } + return result; + } + + @Override + public List<Vessel> getAllScientificVessel() { + + Iterator<Object[]> list = queryListWithStatus( + "allVessels", + "refDate", DateType.INSTANCE, new Date(), + "vesselTypeId", IntegerType.INSTANCE, enumeration.VESSEL_TYPE_ID_SCIENTIFIC); + + List<Vessel> result = Lists.newArrayList(); + while (list.hasNext()) { + Object[] source = list.next(); + Vessel target = loadVessel(source); + result.add(target); + } + return result; + } + + @Override + public List<Vessel> getAllFishingVessel() { + Iterator<Object[]> list = queryListWithStatus( + "allVessels", + "refDate", DateType.INSTANCE, new Date(), + "vesselTypeId", IntegerType.INSTANCE, enumeration.VESSEL_TYPE_ID_FISHING); + + List<Vessel> result = Lists.newArrayList(); + while (list.hasNext()) { + Object[] source = list.next(); + Vessel target = loadVessel(source); + result.add(target); + } + return result; + } + + + @Override + public Vessel getVessel(String vesselCode) { + Object[] source = queryUnique( + "vessel", + "vesselCode", StringType.INSTANCE, vesselCode, + "refDate", DateType.INSTANCE, new Date()); + Vessel result = loadVessel(source); + return result; + } + + @Override + public List<Gear> getAllScientificGear() { + + Iterator<Object[]> sources = queryListWithStatus( + "allGears", + "gearClassificiationId", IntegerType.INSTANCE, enumeration.GEAR_CLASSIFICIATION_ID_SCIENTIFIC); + List<Gear> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + Gear target = loadGear(source); + result.add(target); + } + return result; + } + + @Override + public List<Gear> getAllFishingGear() { + Iterator<Object[]> sources = queryListWithStatus( + "allGears", + "gearClassificiationId", IntegerType.INSTANCE, enumeration.GEAR_CLASSIFICIATION_ID_FISHING); + List<Gear> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + Gear target = loadGear(source); + result.add(target); + } + return result; + } + + @Override + public List<Person> getAllPerson() { + Iterator<Object[]> list = queryListWithStatus( + "allPersons", + "observerProfilId", IntegerType.INSTANCE, enumeration.USER_PROFIL_ID_OBSERVER, + "projectMemberProfilId", IntegerType.INSTANCE, enumeration.USER_PROFIL_ID_PROJECT_MEMBER, + "userProfilId", IntegerType.INSTANCE, enumeration.USER_PROFIL_ID_USER); + + List<Person> result = Lists.newArrayList(); + while (list.hasNext()) { + Object[] source = list.next(); + Person target = loadPerson(source); + result.add(target); + } + return result; + } + + @Override + public Person getPerson(Integer personId) { + Object[] source = queryUnique( + "person", + "personId", IntegerType.INSTANCE, personId); + Person result = loadPerson(source); + return result; + } + + @Override + public List<Species> getAllSpecies() { + + TaxonRefTaxVO[] sources = taxonSpecificDao.getAllTaxonRefTax(); + + List<Species> result = Lists.newArrayList(); + for (TaxonRefTaxVO source : sources) { + Species target = loadSpecies(source); + result.add(target); + } + return result; + } + + @Override + public Species getSpecies(String speciesId) { + TaxonRefTaxVO source = taxonSpecificDao.getTaxonRefTax( + Integer.valueOf(speciesId)); + + Species target = loadSpecies(source); + return target; + } + + @Override + public List<Species> getAllBenthosSpecies() { + TaxonRefTaxVO[] sources = taxonSpecificDao.getAllTaxonRefTax(); + + List<Species> result = Lists.newArrayList(); + for (TaxonRefTaxVO source : sources) { + Species target = loadSpecies(source); + result.add(target); + } + return result; + } + + @Override + public List<Species> getAllPlanktonSpecies() { + TaxonRefTaxVO[] sources = taxonSpecificDao.getAllTaxonRefTax(); + + List<Species> result = Lists.newArrayList(); + for (TaxonRefTaxVO source : sources) { + Species target = loadSpecies(source); + result.add(target); + } + return result; + } + + @Override + public List<Caracteristic> getAllSpeciesLengthStepCaracteristic() { + Iterator<Object[]> sources = queryListWithStatus( + "allLengthStepCaracteristics", + "matrixId", IntegerType.INSTANCE, enumeration.MATRIX_ID_INDIVIDUAL, + "ageParameterCode", StringType.INSTANCE, enumeration.PARAMETER_CODE_AGE, + "weightParameterCode", StringType.INSTANCE, enumeration.PARAMETER_CODE_WEIGHT, + "methodDeclarationId", IntegerType.INSTANCE, enumeration.METHOD_ID_DECLARATION); + List<Caracteristic> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + Caracteristic target = loadCaracteristic(source); + result.add(target); + } + return result; + } + + @Override + public List<Caracteristic> getAllFishingOperationGearCaracteristic() { + Iterator<Object[]> sources = queryListWithStatus( + "allPmfmsByMatrixId", + "matrixId", IntegerType.INSTANCE, enumeration.MATRIX_ID_GEAR, + "unitIdNone", IntegerType.INSTANCE, enumeration.UNIT_ID_NONE); + List<Caracteristic> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + Caracteristic target = loadCaracteristic(source); + result.add(target); + } + return result; + } + + @Override + public List<Caracteristic> getAllFishingOperationEnvironmentCaracteristic() { + Iterator<Object[]> sources = queryListWithStatus( + "allPmfmsByParameterGroudId", + "parameterGroupId", IntegerType.INSTANCE, enumeration.PARAMETER_GROUP_ENVIRONEMENT_MEASUREMENT, + "unitIdNone", IntegerType.INSTANCE, enumeration.UNIT_ID_NONE); + List<Caracteristic> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + Caracteristic target = loadCaracteristic(source); + result.add(target); + } + return result; + } + + @Override + public List<Caracteristic> getAllFishingOperationHydrologicCaracteristic() { + Iterator<Object[]> sources = queryListWithStatus( + "allPmfmsByParameterGroudId", + "parameterGroupId", IntegerType.INSTANCE, enumeration.PARAMETER_GROUP_HYDROLOGIC, + "unitIdNone", IntegerType.INSTANCE, enumeration.UNIT_ID_NONE); + List<Caracteristic> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + Caracteristic target = loadCaracteristic(source); + result.add(target); + } + return result; + } + + @Override + public List<FishingOperationLocation> getAllFishingOperationStrata(String zoneId) { + Iterator<Object[]> sources = queryListWithStatus( + "allFishingOperationStratas", + "locationLevel", IntegerType.INSTANCE, enumeration.LOCATION_LEVEL_ID_STRATA); + List<FishingOperationLocation> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + FishingOperationLocation target = loadFishingOperationLocation(source); + result.add(target); + } + return result; + } + + @Override + public List<FishingOperationLocation> getAllFishingOperationSubStrata(String locationId) { + Iterator<Object[]> sources = queryListWithStatus( + "allFishingOperationSubStratas", + "locationLevel", IntegerType.INSTANCE, enumeration.LOCATION_LEVEL_ID_SUB_STRATA); + List<FishingOperationLocation> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + FishingOperationLocation target = loadFishingOperationLocation(source); + result.add(target); + } + return result; + } + + @Override + public List<FishingOperationLocation> getAllFishingOperationLocation(String locationId) { + Iterator<Object[]> sources = queryListWithStatus( + "allFishingOperationLocalites", + "locationLevel", IntegerType.INSTANCE, enumeration.LOCATION_LEVEL_ID_LOCALITE); + List<FishingOperationLocation> result = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + FishingOperationLocation target = loadFishingOperationLocation(source); + result.add(target); + } + return result; + } + + @Override + public Caracteristic getSizeCategoryCaracteristic() { + Integer pmfmId = enumeration.PMFM_ID_SIZE_CATEGORY; + Caracteristic result = loadCaracteristic(pmfmId); + return result; + } + + @Override + public Caracteristic getSexCaracteristic() { + Integer pmfmId = enumeration.PMFM_ID_SEX; + Caracteristic result = loadCaracteristic(pmfmId); + return result; + } + + @Override + public Caracteristic getSortedUnsortedCaracteristic() { + Integer pmfmId = enumeration.PMFM_ID_SORTED_UNSORTED; + Caracteristic result = loadCaracteristic(pmfmId); + return result; + } + + @Override + public Caracteristic getMaturityCaracteristic() { + Integer pmfmId = enumeration.PMFM_ID_MATURITY; + Caracteristic result = loadCaracteristic(pmfmId); + return result; + } + + @Override + public Caracteristic getMacroWasteCategoryCaracteristic() { + Integer pmfmId = enumeration.PMFM_ID_MACRO_WASTE_CATEGORY; + Caracteristic result = loadCaracteristic(pmfmId); + return result; + } + + @Override + public Caracteristic getMacroWasteSizeCategoryCaracteristic() { + Integer pmfmId = enumeration.PMFM_ID_MACRO_WASTE_SIZE_CATEGORY; + Caracteristic result = loadCaracteristic(pmfmId); + return result; + } + + //------------------------------------------------------------------------// + //-- Internal methods --// + //------------------------------------------------------------------------// + + protected <E extends AbstractTuttiReferentialEntity> void setStatus(fr.ifremer.adagio.core.dao.referential.Status status, E entity) { + Status newStatus = new Status(); + newStatus.setId(status.getCode()); + newStatus.setName(status.getName()); + entity.setStatus(newStatus); + } + + protected void loadCaracteristicQualitativeValues(Caracteristic caracteristic, + Integer pmfmId) { + Preconditions.checkNotNull(caracteristic, "Caracteristic can not be null"); + Preconditions.checkNotNull(pmfmId, "pmfmId can not be null"); + Preconditions.checkArgument(caracteristic.isQualitativeType(), + "Caracteristic must be a qualitativeValue type"); + + Iterator<Object[]> sources = queryListWithStatus( + "pmfmQualitativeValues", + "pmfmId", IntegerType.INSTANCE, pmfmId); + + List<CaracteristicQualitativeValue> values = Lists.newArrayList(); + while (sources.hasNext()) { + Object[] source = sources.next(); + CaracteristicQualitativeValue target = new CaracteristicQualitativeValue(); + target.setId(String.valueOf(source[0])); + target.setName(String.valueOf(source[1])); + setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[2], target); + values.add(target); + } + caracteristic.setQualitativeValue(values); + } + + protected Caracteristic loadCaracteristic(Integer pmfmId) { + + Object[] source = queryUniqueWithStatus("pmfmById", + "pmfmId", IntegerType.INSTANCE, pmfmId, + "unitIdNone", IntegerType.INSTANCE, enumeration.UNIT_ID_NONE); + + Caracteristic target = loadCaracteristic(source); + + if (target.isQualitativeType()) { + + // load qualititative values + loadCaracteristicQualitativeValues(target, pmfmId); + } + return target; + } + + protected Caracteristic loadCaracteristic(Object[] source) { + + Caracteristic target = new Caracteristic(); + target.setId(String.valueOf(source[0])); + target.setParameterName((String) source[1]); + target.setMatrixName((String) source[2]); + target.setFractionName((String) source[3]); + target.setMethodName((String) source[4]); + target.setNumberType((Boolean) source[5]); + target.setQualitativeType((Boolean) source[6]); + target.setSignifFiguresNumber((Integer) source[7]); + target.setMaximumNumberDecimals((Integer) source[8]); + target.setPrecision((Float) source[9]); + target.setUnit((String) source[10]); + setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[11], target); + return target; + } + + protected FishingOperationLocation loadFishingOperationLocation(Object[] source) { + FishingOperationLocation target = new FishingOperationLocation(); + target.setId(String.valueOf(source[0])); + target.setName(String.valueOf(source[1])); + target.setLabel(String.valueOf(source[2])); + target.setDescription(String.valueOf(source[3])); + target.setLocationLevel(Integer.valueOf(source[4].toString())); + + setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[5], target); + return target; + } + + protected Species loadSpecies(TaxonRefTaxVO source) { + Species target = new Species(); + target.setId(String.valueOf(source.getReferenceTaxonId())); + target.setName(source.getName()); + target.setCodeMemo(source.getRefTaxCode()); + setStatus(source.getStatus(), target); + return target; + } + + protected Vessel loadVessel(Object[] source) { + Vessel target = new Vessel(); + target.setId((String) source[0]); + target.setRegistrationCode((String) source[1]); + target.setInternalRegistrationCode((String) source[2]); + target.setName((String) source[3]); + setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[4], target); + return target; + } + + protected Gear loadGear(Object[] source) { + Gear result = new Gear(); + result.setId(String.valueOf(source[0])); + result.setName(String.valueOf(source[1])); + result.setLabel(String.valueOf(source[2])); + setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[3], result); + return result; + } + + protected Person loadPerson(Object[] source) { + Person target = new Person(); + target.setId(String.valueOf(source[0])); + target.setFirstName((String) source[1]); + target.setLastName((String) source[2]); + target.setDepartment((String) source[3]); + setStatus((fr.ifremer.adagio.core.dao.referential.Status) source[4], target); + return target; + } + + protected Iterator<Object[]> queryListWithStatus(String queryName, + Object... params) { + Query query = createQuery(queryName, params); + query.setString("statusValidCode", enumeration.STATUS_VALID_CODE.toString()); + query.setString("statusTemporaryCode", enumeration.STATUS_TEMPORARY_CODE.toString()); + + Iterator result = query.iterate(); + return result; + } + + protected Iterator<Object[]> queryList(String queryName, Object... params) { + Query query = createQuery(queryName, params); + Iterator result = query.iterate(); + return result; + } + + protected Object[] queryUniqueWithStatus(String queryName, Object... params) { + + Query query = createQuery(queryName, params); + query.setString("statusValidCode", enumeration.STATUS_VALID_CODE.toString()); + query.setString("statusTemporaryCode", enumeration.STATUS_TEMPORARY_CODE.toString()); + + Object result = query.uniqueResult(); + return (Object[]) result; + } + + protected Object[] queryUnique(String queryName, Object... params) { + + Query query = createQuery(queryName, params); + Object result = query.uniqueResult(); + return (Object[]) result; + } + + protected Query createQuery(String queryName, Object... params) { + Query query = sessionFactory.getCurrentSession().getNamedQuery(queryName); + + if (params.length > 0) { + + Preconditions.checkArgument( + params.length % 3 == 0, + "Params must be tuple (paramName, paramType, paramValue)"); + + int nbParams = params.length / 3; + + for (int i = 0; i < nbParams; i++) { + String paramName = (String) params[3 * i]; + Type paramType = (Type) params[3 * i + 1]; + Object paramValue = params[3 * i + 2]; + query.setParameter(paramName, paramValue, paramType); + if (log.isDebugEnabled()) { + log.debug("query [" + queryName + "] (param " + i + + " [" + paramName + '=' + paramValue + "])"); + } + } + } + return query; + } + + +} Property changes on: trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceImpl.java ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Added: trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/TuttiPersistenceServiceLocator.java =================================================================== --- trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/TuttiPersistenceServiceLocator.java (rev 0) +++ trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/TuttiPersistenceServiceLocator.java 2013-01-12 17:59:34 UTC (rev 181) @@ -0,0 +1,59 @@ +package fr.ifremer.tutti.persistence.service; + +/* + * #%L + * Tutti :: Persistence Adagio (impl) + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2012 - 2013 Ifremer + * %% + * This program 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. + * + * 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>. + * #L% + */ + +import fr.ifremer.adagio.core.service.ServiceLocator; +import fr.ifremer.tutti.persistence.TuttiPersistence; + +/** + * To obtain services from spring context. + * + * @author tchemit <chemit@codelutin.com> + * @since 0.3 + */ +public class TuttiPersistenceServiceLocator extends ServiceLocator { + + protected static final TuttiPersistenceServiceLocator INSTANCE = + new TuttiPersistenceServiceLocator(); + + protected TuttiPersistenceServiceLocator() { + super("beanRefFactory.xml", + "TuttiBeanRefFactory"); + } + + public static TuttiPersistence getPersistenceService() { + return INSTANCE.getService("adagioPersistenceService", + TuttiPersistence.class); + } + + public static ReferentialPersistenceService getReferentialPersistenceService() { + return INSTANCE.getService("referentialPersistenceService", + ReferentialPersistenceService.class); + } + + public static void close() { + INSTANCE.shutdown(); + } +} Property changes on: trunk/tutti-persistence-adagio/src/main/java/fr/ifremer/tutti/persistence/service/TuttiPersistenceServiceLocator.java ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Modified: trunk/tutti-persistence-adagio/src/main/resources/applicationContext-service-tutti.xml =================================================================== --- trunk/tutti-persistence-adagio/src/main/resources/applicationContext-service-tutti.xml 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/main/resources/applicationContext-service-tutti.xml 2013-01-12 17:59:34 UTC (rev 181) @@ -24,41 +24,44 @@ --> <beans xmlns="http://www.springframework.org/schema/beans" - xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" - xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" - xmlns:context="http://www.springframework.org/schema/context" - xsi:schemaLocation=" - http://www.springframework.org/schema/tx + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xmlns:tx="http://www.springframework.org/schema/tx" + xmlns:context="http://www.springframework.org/schema/context" + xsi:schemaLocation="http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd - http://www.springframework.org/schema/aop - http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd"> - <!--<context:component-scan base-package="fr.ifremer.adagio.core.service" />--> - <!-- Activates various annotations to be detected in bean classes: Spring's - @Required and @Autowired, as well as JSR 250's @PostConstruct, @PreDestroy - and @Resource (if available) and JPA's @PersistenceContext and @PersistenceUnit - (if available). --> - <!--<context:annotation-config />--> + <!-- Activates various annotations to be detected in bean classes: Spring's + @Required and @Autowired, as well as JSR 250's @PostConstruct, @PreDestroy + and @Resource (if available) and JPA's @PersistenceContext and @PersistenceUnit + (if available). --> + <context:annotation-config /> - <!--Platform Transaction Manager declared as "transactionManager" will be - used. --> - <!--"aspectj" mode enables load-time/compile-time weaving of transactional - methods, which enables those methods to be intercepted even when called internally. - (Unlike Spring generated proxies which will only be intercepted when called - from outside) --> - <tx:annotation-driven transaction-manager="transactionManager" /> + <!--Platform Transaction Manager declared as "transactionManager" will be + used. --> + <!--"aspectj" mode enables load-time/compile-time weaving of transactional + methods, which enables those methods to be intercepted even when called internally. + (Unlike Spring generated proxies which will only be intercepted when called + from outside) --> + <tx:annotation-driven transaction-manager="transactionManager"/> - <bean id="adagioPersistenceService" destroy-method="close" - class="fr.ifremer.tutti.persistence.TuttiPersistenceAdagioImpl"> - <property name="sessionFactory" ref="sessionFactory" /> - </bean> + <bean id="locationService" + class="fr.ifremer.adagio.core.service.referential.location.impl.LocationServiceImpl"/> - <!--Enables the use of @AspectJ style of aspects' declarations. AspectJ - run-time isn't necessarily involved --> - <!--<aop:aspectj-autoproxy />--> + <bean id="referentialPersistenceService" + class="fr.ifremer.tutti.persistence.service.ReferentialPersistenceServiceImpl"/> + <bean id="adagioPersistenceService" init-method="open" destroy-method="close" + class="fr.ifremer.tutti.persistence.TuttiPersistenceAdagioImpl"/> + + <bean init-method="init" + class="fr.ifremer.tutti.persistence.TuttiEnumerationFile"/> + + <!--Enables the use of @AspectJ style of aspects' declarations. AspectJ + run-time isn't necessarily involved --> + <!--<aop:aspectj-autoproxy />--> + <!--bean id="dataSource2" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> @@ -93,372 +96,372 @@ </props> </property--> - <!--property name="mappingResources"> + <!--property name="mappingResources"> + <list> + <value>queries-override2.hbm.xml</value> + <value>file:///home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/Author.hbm.xml</value> + </list> + </property--> + <!--property name="mappingLocations"> <list> - <value>queries-override2.hbm.xml</value> - <value>file:///home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/Author.hbm.xml</value> + <value>classpath:queries.hbm.xml</value> + <value>classpath:queries-override.hbm.xml</value> + <value>file:///home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/PersonSessionVessel.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/UserProfil.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/PersonSession.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/VesselManagePeriod.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/ManagedDataTransfer.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/ManagedDataType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/DepartmentPrivilegeTransfert.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/Person.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/ManagedData.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/ageReader/AgeReaderQualification.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/user/Department.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/Strategy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/PmfmAppliedStrategy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/ReferenceTaxonStrategy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/AppliedStrategy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/AppliedPeriod.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/Program2Person.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/Program.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/AcquisitionLevel.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/BatchModelAppliedStrategy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/Program2Department.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/ProgramPrivilege.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/PmfmStrategy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/technical/optimization/grouping/GroupingVesselHierarchy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/technical/optimization/grouping/GroupingItemHierarchy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/technical/optimization/location/LocationHierarchyException.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/technical/optimization/location/LocationHierarchy.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/DepthGradient.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/NearbySpecificArea.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/RegulationArea2RegulationLocation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/RegulationArea.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/Corpus.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/CorpusType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/RightToProduce.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/MinimumSizeAllowed.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/Fishery.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/seller/SellerType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/seller/Seller.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/PrecisionType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingItem.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingSystem.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingItemType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingSide.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/ProcessingStatus.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/DistanceToCoastGradient.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItem.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemLine.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemArea.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItem2Location.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemPoint.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/SurveyQualification.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/VesselType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/ObjectType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/Status.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/ProcessingType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/LinkedItemType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/gear/GearClassification.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/gear/GearClassificationAssociation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/gear/GearAssociation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/gear/Gear.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/location/Location.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/location/LocationClassification.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/location/LocationLevel.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/location/LocationAssociation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/samplingScheme/denormalized/DenormalizedSamplingStrata.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/buyer/Buyer.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/buyer/BuyerType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/grouping/GroupingClassification.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/grouping/GroupingItem.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/grouping/Grouping.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/grouping/GroupingLevel.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/PhotoType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/SaleType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroup.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupHistoricalRecord.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/ReferenceDocument.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/Citation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonInformation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupInformation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonNameHistory.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/Author.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/ReferenceTaxon.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonInformationHistory.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonName.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonomicLevel.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/VirtualComponent.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselOwner.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/EducationGrade.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselFeatures.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselRegistrationPeriod.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselOwnerPeriod.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselEngineType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselMasterPeriod.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/Vessel.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselMaster.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/metier/Metier.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/order/OrderItem.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/order/OrderType.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/conversion/UnitConversion.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/conversion/WeightLengthConversion.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/conversion/RoundWeightConversion.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/qualification/QualificationRule.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Matrix.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Unit.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/ParameterGroup.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Fraction.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Method.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Pmfm.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Parameter.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/AggregationLevel.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/QualitativeValue.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/NumericalPrecision.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/QualityFlag.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/referential/AnalysisInstrument.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/batch/BatchExhaustiveInventory.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/batch/BatchModel.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/batch/Batch.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/batch/denormalized/DenormalizedBatch.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/batch/denormalized/DenormalisedBatchSortingValue.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/qualification/AppliedQualificationRule.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/qualification/QualifiedItem.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/takeOver/TakeOver.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/physicalGear/PhysicalGearSurvey.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/declaration/DeclaredDocumentReference.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/economy/EconomicalSurvey.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/activity/ActivityCalendar.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/activity/DailyActivityCalendar.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/sale/SaleOrigin.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/sale/Sale.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/fishingTrip/FishingTrip.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/fishingTrip/FishingTripOrigin.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/scientificCruise/ScientificCruise.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/fishingEffort/FishingEffortCalendar.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/landing/LandingOrigin.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/survey/landing/Landing.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/sale/ExpectedSale.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/fishingArea/FishingArea2RegulationLocation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/fishingArea/FishingArea.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/operation/denormalized/DenormalizedOperation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/operation/Operation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/operation/OperationVesselAssociation.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/sample/Sample.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/transshipment/Transshipment.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/LandingMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/VesselPhysicalMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/QuantificationMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/VesselUseMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/file/MeasurementFile.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/VesselPositionMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/SaleMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/photo/Photo.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/TakeOverMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/GearUseMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/SortingMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/SampleMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/SurveyMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/measure/GearPhysicalMeasurement.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/link/LinkedItem.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/produce/Produce.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/history/UpdatedItemHistory.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/history/InsertedItemHistory.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/history/ProcessingHistory.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/history/DeletedItemHistory.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/position/VesselPosition.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/physical/GearPhysicalFeatures.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/physical/VesselPhysicalFeaturesOrigin.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/physical/VesselPhysicalFeatures.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/physical/GearPhysicalFeaturesOrigin.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/use/VesselUseFeaturesOrigin.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/use/GearUseFeaturesOrigin.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/use/VesselUseFeatures.hbm.xml</value> + <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/use/GearUseFeatures.hbm.xml</value> </list> - </property--> - <!--property name="mappingLocations"> - <list> - <value>classpath:queries.hbm.xml</value> - <value>classpath:queries-override.hbm.xml</value> - <value>file:///home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/PersonSessionVessel.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/UserProfil.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/PersonSession.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/VesselManagePeriod.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/ManagedDataTransfer.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/ManagedDataType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/DepartmentPrivilegeTransfert.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/Person.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/ManagedData.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/ageReader/AgeReaderQualification.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/user/Department.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/Strategy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/PmfmAppliedStrategy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/ReferenceTaxonStrategy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/AppliedStrategy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/AppliedPeriod.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/Program2Person.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/Program.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/AcquisitionLevel.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/BatchModelAppliedStrategy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/Program2Department.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/ProgramPrivilege.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/administration/programStrategy/PmfmStrategy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/technical/optimization/grouping/GroupingVesselHierarchy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/technical/optimization/grouping/GroupingItemHierarchy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/technical/optimization/location/LocationHierarchyException.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/technical/optimization/location/LocationHierarchy.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/DepthGradient.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/NearbySpecificArea.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/RegulationArea2RegulationLocation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/RegulationArea.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/Corpus.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/CorpusType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/RightToProduce.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/MinimumSizeAllowed.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/regulation/Fishery.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/seller/SellerType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/seller/Seller.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/PrecisionType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingItem.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingSystem.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingItemType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingSide.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/ProcessingStatus.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/DistanceToCoastGradient.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItem.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemLine.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemArea.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItem2Location.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemPoint.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/SurveyQualification.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/VesselType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/ObjectType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/Status.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/ProcessingType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/LinkedItemType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/gear/GearClassification.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/gear/GearClassificationAssociation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/gear/GearAssociation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/gear/Gear.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/location/Location.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/location/LocationClassification.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/location/LocationLevel.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/location/LocationAssociation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/samplingScheme/denormalized/DenormalizedSamplingStrata.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/buyer/Buyer.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/buyer/BuyerType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/grouping/GroupingClassification.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/grouping/GroupingItem.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/grouping/Grouping.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/grouping/GroupingLevel.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/PhotoType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/SaleType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroup.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupHistoricalRecord.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/ReferenceDocument.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/Citation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonInformation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupInformation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonNameHistory.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/Author.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/ReferenceTaxon.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonInformationHistory.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonName.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/TaxonomicLevel.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/taxon/VirtualComponent.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselOwner.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/EducationGrade.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselFeatures.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselRegistrationPeriod.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselOwnerPeriod.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselEngineType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselMasterPeriod.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/Vessel.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/vessel/VesselMaster.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/metier/Metier.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/order/OrderItem.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/order/OrderType.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/conversion/UnitConversion.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/conversion/WeightLengthConversion.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/conversion/RoundWeightConversion.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/qualification/QualificationRule.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Matrix.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Unit.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/ParameterGroup.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Fraction.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Method.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Pmfm.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/Parameter.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/AggregationLevel.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/pmfm/QualitativeValue.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/NumericalPrecision.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/QualityFlag.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/referential/AnalysisInstrument.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/batch/BatchExhaustiveInventory.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/batch/BatchModel.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/batch/Batch.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/batch/denormalized/DenormalizedBatch.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/batch/denormalized/DenormalisedBatchSortingValue.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/qualification/AppliedQualificationRule.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/qualification/QualifiedItem.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/takeOver/TakeOver.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/physicalGear/PhysicalGearSurvey.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/declaration/DeclaredDocumentReference.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/economy/EconomicalSurvey.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/activity/ActivityCalendar.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/activity/DailyActivityCalendar.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/sale/SaleOrigin.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/sale/Sale.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/fishingTrip/FishingTrip.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/fishingTrip/FishingTripOrigin.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/scientificCruise/ScientificCruise.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/fishingEffort/FishingEffortCalendar.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/landing/LandingOrigin.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/survey/landing/Landing.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/sale/ExpectedSale.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/fishingArea/FishingArea2RegulationLocation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/fishingArea/FishingArea.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/operation/denormalized/DenormalizedOperation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/operation/Operation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/operation/OperationVesselAssociation.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/sample/Sample.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/transshipment/Transshipment.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/LandingMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/VesselPhysicalMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/QuantificationMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/VesselUseMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/file/MeasurementFile.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/VesselPositionMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/SaleMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/photo/Photo.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/TakeOverMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/GearUseMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/SortingMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/SampleMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/SurveyMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/measure/GearPhysicalMeasurement.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/link/LinkedItem.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/produce/Produce.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/history/UpdatedItemHistory.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/history/InsertedItemHistory.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/history/ProcessingHistory.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/history/DeletedItemHistory.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/position/VesselPosition.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/physical/GearPhysicalFeatures.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/physical/VesselPhysicalFeaturesOrigin.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/physical/VesselPhysicalFeatures.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/physical/GearPhysicalFeaturesOrigin.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/use/VesselUseFeaturesOrigin.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/use/GearUseFeaturesOrigin.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/use/VesselUseFeatures.hbm.xml</value> - <value>classpath:fr/ifremer/adagio/core/dao/data/vessel/feature/use/GearUseFeatures.hbm.xml</value> - </list> - </property--> - <!--property name="mappingLocations"> - <list> - <value>queries-override2.hbm.xml</value> - <value>file:///home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/Author.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/PersonSessionVessel.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/UserProfil.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/PersonSession.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/VesselManagePeriod.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/ManagedDataTransfer.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/ManagedDataType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/DepartmentPrivilegeTransfert.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/Person.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/ManagedData.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/ageReader/AgeReaderQualification.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/Department.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/Strategy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/PmfmAppliedStrategy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/ReferenceTaxonStrategy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/AppliedStrategy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/AppliedPeriod.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/Program2Person.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/Program.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/AcquisitionLevel.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/BatchModelAppliedStrategy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/Program2Department.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/ProgramPrivilege.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/PmfmStrategy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/technical/optimization/grouping/GroupingVesselHierarchy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/technical/optimization/grouping/GroupingItemHierarchy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/technical/optimization/location/LocationHierarchyException.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/technical/optimization/location/LocationHierarchy.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/DepthGradient.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/NearbySpecificArea.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/RegulationArea2RegulationLocation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/RegulationArea.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/Corpus.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/CorpusType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/RightToProduce.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/MinimumSizeAllowed.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/Fishery.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/seller/SellerType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/seller/Seller.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/PrecisionType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingItem.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingSystem.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingItemType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingSide.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/ProcessingStatus.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/DistanceToCoastGradient.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItem.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemLine.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemArea.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItem2Location.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemPoint.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/SurveyQualification.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/VesselType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/ObjectType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/Status.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/ProcessingType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/LinkedItemType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/gear/GearClassification.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/gear/GearClassificationAssociation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/gear/GearAssociation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/gear/Gear.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/location/Location.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/location/LocationClassification.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/location/LocationLevel.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/location/LocationAssociation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/samplingScheme/denormalized/DenormalizedSamplingStrata.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/buyer/Buyer.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/buyer/BuyerType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/grouping/GroupingClassification.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/grouping/GroupingItem.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/grouping/Grouping.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/grouping/GroupingLevel.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/PhotoType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/SaleType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroup.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupHistoricalRecord.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/ReferenceDocument.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/Citation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonInformation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupInformation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonNameHistory.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/Author.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/ReferenceTaxon.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonInformationHistory.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonName.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonomicLevel.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/VirtualComponent.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselOwner.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/EducationGrade.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselFeatures.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselRegistrationPeriod.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselOwnerPeriod.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselEngineType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselMasterPeriod.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/Vessel.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselMaster.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/metier/Metier.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/order/OrderItem.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/order/OrderType.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/conversion/UnitConversion.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/conversion/WeightLengthConversion.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/conversion/RoundWeightConversion.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/qualification/QualificationRule.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Matrix.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Unit.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/ParameterGroup.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Fraction.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Method.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Pmfm.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Parameter.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/AggregationLevel.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/QualitativeValue.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/NumericalPrecision.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/QualityFlag.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/AnalysisInstrument.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/BatchExhaustiveInventory.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/BatchModel.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/Batch.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/denormalized/DenormalizedBatch.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/denormalized/DenormalisedBatchSortingValue.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/qualification/AppliedQualificationRule.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/qualification/QualifiedItem.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/takeOver/TakeOver.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/physicalGear/PhysicalGearSurvey.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/declaration/DeclaredDocumentReference.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/economy/EconomicalSurvey.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/activity/ActivityCalendar.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/activity/DailyActivityCalendar.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/sale/SaleOrigin.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/sale/Sale.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/fishingTrip/FishingTrip.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/fishingTrip/FishingTripOrigin.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/scientificCruise/ScientificCruise.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/fishingEffort/FishingEffortCalendar.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/landing/LandingOrigin.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/landing/Landing.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/sale/ExpectedSale.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/fishingArea/FishingArea2RegulationLocation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/fishingArea/FishingArea.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/operation/denormalized/DenormalizedOperation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/operation/Operation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/operation/OperationVesselAssociation.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/sample/Sample.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/transshipment/Transshipment.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/LandingMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/VesselPhysicalMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/QuantificationMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/VesselUseMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/file/MeasurementFile.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/VesselPositionMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/SaleMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/photo/Photo.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/TakeOverMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/GearUseMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/SortingMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/SampleMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/SurveyMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/GearPhysicalMeasurement.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/link/LinkedItem.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/produce/Produce.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/history/UpdatedItemHistory.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/history/InsertedItemHistory.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/history/ProcessingHistory.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/history/DeletedItemHistory.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/position/VesselPosition.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/physical/GearPhysicalFeatures.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/physical/VesselPhysicalFeaturesOrigin.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/physical/VesselPhysicalFeatures.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/physical/GearPhysicalFeaturesOrigin.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/use/VesselUseFeaturesOrigin.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/use/GearUseFeaturesOrigin.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/use/VesselUseFeatures.hbm.xml</value> - <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/use/GearUseFeatures.hbm.xml</value> - </list> - </property--> + </property--> + <!--property name="mappingLocations"> + <list> + <value>queries-override2.hbm.xml</value> + <value>file:///home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/Author.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/PersonSessionVessel.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/UserProfil.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/PersonSession.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/VesselManagePeriod.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/ManagedDataTransfer.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/ManagedDataType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/DepartmentPrivilegeTransfert.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/Person.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/ManagedData.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/ageReader/AgeReaderQualification.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/user/Department.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/Strategy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/PmfmAppliedStrategy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/ReferenceTaxonStrategy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/AppliedStrategy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/AppliedPeriod.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/Program2Person.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/Program.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/AcquisitionLevel.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/BatchModelAppliedStrategy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/Program2Department.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/ProgramPrivilege.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/administration/programStrategy/PmfmStrategy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/technical/optimization/grouping/GroupingVesselHierarchy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/technical/optimization/grouping/GroupingItemHierarchy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/technical/optimization/location/LocationHierarchyException.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/technical/optimization/location/LocationHierarchy.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/DepthGradient.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/NearbySpecificArea.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/RegulationArea2RegulationLocation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/RegulationArea.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/Corpus.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/CorpusType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/RightToProduce.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/MinimumSizeAllowed.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/regulation/Fishery.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/seller/SellerType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/seller/Seller.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/PrecisionType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingItem.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingSystem.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingItemType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/transcribing/TranscribingSide.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/ProcessingStatus.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/DistanceToCoastGradient.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItem.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemLine.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemArea.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItem2Location.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/spatial/SpatialItemPoint.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/SurveyQualification.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/VesselType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/ObjectType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/Status.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/ProcessingType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/LinkedItemType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/gear/GearClassification.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/gear/GearClassificationAssociation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/gear/GearAssociation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/gear/Gear.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/location/Location.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/location/LocationClassification.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/location/LocationLevel.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/location/LocationAssociation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/samplingScheme/denormalized/DenormalizedSamplingStrata.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/buyer/Buyer.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/buyer/BuyerType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/grouping/GroupingClassification.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/grouping/GroupingItem.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/grouping/Grouping.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/grouping/GroupingLevel.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/PhotoType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/SaleType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroup.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupHistoricalRecord.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/ReferenceDocument.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/Citation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonInformation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonGroupInformation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonNameHistory.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/Author.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/ReferenceTaxon.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonInformationHistory.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonName.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/TaxonomicLevel.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/taxon/VirtualComponent.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselOwner.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/EducationGrade.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselFeatures.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselRegistrationPeriod.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselOwnerPeriod.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselEngineType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselMasterPeriod.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/Vessel.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/vessel/VesselMaster.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/metier/Metier.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/order/OrderItem.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/order/OrderType.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/conversion/UnitConversion.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/conversion/WeightLengthConversion.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/conversion/RoundWeightConversion.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/qualification/QualificationRule.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Matrix.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Unit.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/ParameterGroup.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Fraction.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Method.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Pmfm.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/Parameter.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/AggregationLevel.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/pmfm/QualitativeValue.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/NumericalPrecision.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/QualityFlag.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/referential/AnalysisInstrument.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/BatchExhaustiveInventory.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/BatchModel.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/Batch.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/denormalized/DenormalizedBatch.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/batch/denormalized/DenormalisedBatchSortingValue.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/qualification/AppliedQualificationRule.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/qualification/QualifiedItem.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/takeOver/TakeOver.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/physicalGear/PhysicalGearSurvey.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/declaration/DeclaredDocumentReference.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/economy/EconomicalSurvey.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/activity/ActivityCalendar.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/activity/DailyActivityCalendar.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/sale/SaleOrigin.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/sale/Sale.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/fishingTrip/FishingTrip.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/fishingTrip/FishingTripOrigin.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/scientificCruise/ScientificCruise.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/fishingEffort/FishingEffortCalendar.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/landing/LandingOrigin.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/survey/landing/Landing.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/sale/ExpectedSale.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/fishingArea/FishingArea2RegulationLocation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/fishingArea/FishingArea.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/operation/denormalized/DenormalizedOperation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/operation/Operation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/operation/OperationVesselAssociation.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/sample/Sample.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/transshipment/Transshipment.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/LandingMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/VesselPhysicalMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/QuantificationMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/VesselUseMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/file/MeasurementFile.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/VesselPositionMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/SaleMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/photo/Photo.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/TakeOverMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/GearUseMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/SortingMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/SampleMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/SurveyMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/measure/GearPhysicalMeasurement.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/link/LinkedItem.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/produce/Produce.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/history/UpdatedItemHistory.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/history/InsertedItemHistory.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/history/ProcessingHistory.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/history/DeletedItemHistory.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/position/VesselPosition.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/physical/GearPhysicalFeatures.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/physical/VesselPhysicalFeaturesOrigin.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/physical/VesselPhysicalFeatures.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/physical/GearPhysicalFeaturesOrigin.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/use/VesselUseFeaturesOrigin.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/use/GearUseFeaturesOrigin.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/use/VesselUseFeatures.hbm.xml</value> + <value>file:/home/tchemit/projets/ifremer/adagio/core/target/generated-sources/java/fr/ifremer/adagio/core/dao/data/vessel/feature/use/GearUseFeatures.hbm.xml</value> + </list> + </property--> <!--</bean>--> </beans> \ No newline at end of file Modified: trunk/tutti-persistence-adagio/src/main/resources/beanRefFactory.xml =================================================================== --- trunk/tutti-persistence-adagio/src/main/resources/beanRefFactory.xml 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/main/resources/beanRefFactory.xml 2013-01-12 17:59:34 UTC (rev 181) @@ -29,9 +29,9 @@ http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"> - <import resource="applicationContext-conf.xml"/> + <import resource="classpath:applicationContext-conf.xml"/> - <bean id="beanRefFactory" + <bean id="TuttiBeanRefFactory" class="org.springframework.context.support.ClassPathXmlApplicationContext"> <constructor-arg> <list> Modified: trunk/tutti-persistence-adagio/src/main/resources/queries-override.hbm.xml =================================================================== --- trunk/tutti-persistence-adagio/src/main/resources/queries-override.hbm.xml 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/main/resources/queries-override.hbm.xml 2013-01-12 17:59:34 UTC (rev 181) @@ -31,7 +31,11 @@ <!--TODO Create fetch profile to avoid eager loading --> <!--</fetch-profile>--> - <!-- Get all programs (to list with no detail) [DAT-01] --> + <!-- ===================================================================== --> + <!-- === Requete sur données thématiques [DAT-XXX] === --> + <!-- ===================================================================== --> + + <!-- [DAT-01] Get all programs (to list with no detail) --> <query cacheable="true" name="allPrograms"> <![CDATA[ SELECT @@ -42,7 +46,7 @@ ]]> </query> - <!-- Get all cruises for a given program (to list with no detail) [DAT-02] --> + <!-- [DAT-02] Get all cruises for a given program (to list with no detail) --> <query cacheable="true" name="allCruises"> <![CDATA[ SELECT @@ -56,7 +60,7 @@ <query-param name="programCode" type="java.lang.String"/> </query> - <!-- Get a detail program [DAT-03] --> + <!-- [DAT-03] Get a detail program --> <query cacheable="true" name="program"> <![CDATA[ SELECT @@ -69,7 +73,7 @@ <query-param name="programCode" type="java.lang.String"/> </query> - <!-- Get a program locations [DAT-03-1] --> + <!-- [DAT-03-1] Get a program locations --> <query cacheable="true" name="allProgramLocations"> <![CDATA[ SELECT @@ -83,7 +87,7 @@ <query-param name="programCode" type="java.lang.String"/> </query> - <!-- Get a detail cruise [DAT-04] --> + <!-- [DAT-04] Get a detail cruise --> <query cacheable="true" name="cruise"> <![CDATA[ SELECT @@ -112,125 +116,242 @@ <query-param name="countryLocationLevel" type="java.lang.Integer"/> </query> - <!-- Get all program zones [REF-01] --> + <!-- ===================================================================== --> + <!-- === Requete techniques sur référentiels [REF-TXXX] === --> + <!-- ===================================================================== --> + + <!-- [REF-T01] Get a pmfm caracteristics by this id --> + <query cacheable="true" name="pmfmById"> + <![CDATA[ + SELECT + p.id AS pmfmId, + p.parameter.name AS parameterName, + p.matrix.name AS matrixName, + p.fraction.name AS fractionName, + p.method.name AS methodName, + p.parameter.isAlphanumeric AS isAlphanumeric, + p.parameter.isQualitative AS isQualitative, + p.signifFiguresNumber, + p.maximumNumberDecimals, + p.precision, + case when (p.unit.id = :unitIdNone) then '' else p.unit.symbol end AS symbol, + p.status AS status + FROM PmfmImpl p + WHERE + p.status.code IN (:statusValidCode, :statusTemporaryCode) + AND p.id= :pmfmId + ]]> + <query-param name="pmfmId" type="java.lang.Integer"/> + <query-param name="unitIdNone" type="java.lang.Integer"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> + </query> + + <!-- [REF-T02] Get a pmfm qualitative values from his id --> + <query cacheable="true" name="pmfmQualitativeValues"> + <![CDATA[ + SELECT + qv.id AS id, + case when (qv.name = qv.description) then qv.name else concat(qv.name, ' - ', qv.description) end AS name, + qv.status AS status + FROM + PmfmImpl p JOIN p.qualitativeValues qv + WHERE + p.id= :pmfmId + AND qv.status.code IN (:statusValidCode, :statusTemporaryCode) + ]]> + <query-param name="pmfmId" type="java.lang.Integer"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> + </query> + + <!-- [REF-T03] Get all pmfms using a same matrix Id --> + <query cacheable="true" name="allPmfmsByMatrixId"> + <![CDATA[ + SELECT + p.id AS pmfmId, + p.parameter.name AS parameterName, + p.matrix.name AS matrixName, + p.fraction.name AS fractionName, + p.method.name AS methodName, + p.parameter.isAlphanumeric AS isAlphanumeric, + p.parameter.isQualitative AS isQualitative, + p.signifFiguresNumber, + p.maximumNumberDecimals, + p.precision, + case when (p.unit.id = :unitIdNone) then '' else p.unit.symbol end AS symbol, + p.status AS status + FROM PmfmImpl p + WHERE + p.status.code IN (:statusValidCode, :statusTemporaryCode) + AND p.matrix.id= :matrixId + ]]> + <query-param name="matrixId" type="java.lang.Integer"/> + <query-param name="unitIdNone" type="java.lang.Integer"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> + </query> + + <!-- [REF-T04] Get all pmfms using a same parameter group id --> + <query cacheable="true" name="allPmfmsByParameterGroudId"> + <![CDATA[ + SELECT + p.id AS pmfmId, + p.parameter.name AS parameterName, + p.matrix.name AS matrixName, + p.fraction.name AS fractionName, + p.method.name AS methodName, + p.parameter.isAlphanumeric AS isAlphanumeric, + p.parameter.isQualitative AS isQualitative, + p.signifFiguresNumber, + p.maximumNumberDecimals, + p.precision, + case when (p.unit.id = :unitIdNone) then '' else p.unit.symbol end AS symbol, + p.status AS status + FROM PmfmImpl p + WHERE + p.status.code IN (:statusValidCode, :statusTemporaryCode) + AND p.parameter.parameterGroup.id= :parameterGroupId + ]]> + <query-param name="parameterGroupId" type="java.lang.Integer"/> + <query-param name="unitIdNone" type="java.lang.Integer"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> + </query> + + <!-- ===================================================================== --> + <!-- === Requete sur référentiels [REF-XXX] === --> + <!-- ===================================================================== --> + + <!-- [REF-01] Get all program zones --> <query cacheable="true" name="allProgramZones"> <![CDATA[ - SELECT + SELECT l.id, l.label, l.name, l.status - FROM LocationImpl l - WHERE + FROM LocationImpl l + WHERE l.locationLevel.id = :locationLevelId - AND l.status.code IN (1, 2) + AND l.status.code IN (:statusValidCode, :statusTemporaryCode) ]]> <query-param name="locationLevelId" type="java.lang.Integer"/> </query> - <!-- Get all countries [REF-02] --> + <!-- [REF-02] Get all countries --> <query cacheable="true" name="allCountries"> <![CDATA[ - SELECT + SELECT l.id, l.label, l.name, l.status - FROM LocationImpl l - WHERE + FROM LocationImpl l + WHERE l.locationLevel.id = :locationLevelId - AND l.status.code IN (1, 2) + AND l.status.code IN (:statusValidCode, :statusTemporaryCode) ]]> <query-param name="locationLevelId" type="java.lang.Integer"/> </query> - <!-- Get all vessel for a given vesselType [REF-03] et [REF-04]--> + <!-- [REF-03] et [REF-04] Get all vessel for a given vesselType --> <query cacheable="true" name="allVessels"> <![CDATA[ SELECT - v.code AS vesselCode, - vrp.registrationCode AS nationalRegistrationCode, - vrp.internationalRegistrationCode as internationalRegistrationCode, - vf.name AS vesselName, - v.status AS status + v.code AS vesselCode, + vrp.registrationCode AS nationalRegistrationCode, + vrp.internationalRegistrationCode as internationalRegistrationCode, + vf.name AS vesselName, + v.status AS status FROM - VesselImpl v - INNER JOIN v.vesselRegistrationPeriods AS vrp - LEFT OUTER JOIN v.vesselFeatures AS vf - WHERE v.vesselType.id = :vesselTypeId - AND v.status.code IN (1, 2) - AND vrp.vesselRegistrationPeriodPk.startDateTime = - ( - SELECT MAX(vrp2.vesselRegistrationPeriodPk.startDateTime) - FROM VesselRegistrationPeriodImpl vrp2 WHERE - vrp2.vesselRegistrationPeriodPk.vessel.code = v.code - AND (vrp2.vesselRegistrationPeriodPk.startDateTime <= :refDate OR :refDate IS NULL) - GROUP BY vrp2.vesselRegistrationPeriodPk.vessel.code - ) - AND vf.startDateTime = - ( - SELECT MAX(vf2.startDateTime) - FROM VesselFeaturesImpl vf2 WHERE - vf2.vessel.code = v.code - AND (vf2.startDateTime <= :refDate OR :refDate IS NULL) - GROUP BY vf2.vessel.code - )]]> + VesselImpl v + INNER JOIN v.vesselRegistrationPeriods AS vrp + LEFT OUTER JOIN v.vesselFeatures AS vf + WHERE + v.vesselType.id = :vesselTypeId + AND v.status.code IN (:statusValidCode, :statusTemporaryCode) + AND vrp.vesselRegistrationPeriodPk.startDateTime = + ( + SELECT MAX(vrp2.vesselRegistrationPeriodPk.startDateTime) + FROM VesselRegistrationPeriodImpl vrp2 WHERE + vrp2.vesselRegistrationPeriodPk.vessel.code = v.code + AND (vrp2.vesselRegistrationPeriodPk.startDateTime <= :refDate OR :refDate IS NULL) + GROUP BY vrp2.vesselRegistrationPeriodPk.vessel.code + ) + AND vf.startDateTime = + ( + SELECT MAX(vf2.startDateTime) + FROM VesselFeaturesImpl vf2 WHERE + vf2.vessel.code = v.code + AND (vf2.startDateTime <= :refDate OR :refDate IS NULL) + GROUP BY vf2.vessel.code + ) + ]]> <query-param name="vesselTypeId" type="java.lang.Integer"/> <query-param name="refDate" type="java.util.Date"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> </query> - <!-- Get a vessel for a given vesselType [REF-03] et [REF-04]--> + <!-- Get a vessel for a given vesselType --> <query cacheable="true" name="vessel"> <![CDATA[ SELECT - v.code AS vesselCode, - vrp.registrationCode AS nationalRegistrationCode, - vrp.internationalRegistrationCode as internationalRegistrationCode, - vf.name AS vesselName, - v.status AS status + v.code AS vesselCode, + vrp.registrationCode AS nationalRegistrationCode, + vrp.internationalRegistrationCode as internationalRegistrationCode, + vf.name AS vesselName, + v.status AS status FROM - VesselImpl v - INNER JOIN v.vesselRegistrationPeriods AS vrp - LEFT OUTER JOIN v.vesselFeatures AS vf - WHERE v.code = :vesselCode - AND v.status.code IN (1, 2) - AND vrp.vesselRegistrationPeriodPk.startDateTime = - ( - SELECT MAX(vrp2.vesselRegistrationPeriodPk.startDateTime) - FROM VesselRegistrationPeriodImpl vrp2 WHERE - vrp2.vesselRegistrationPeriodPk.vessel.code = v.code - AND (vrp2.vesselRegistrationPeriodPk.startDateTime <= :refDate OR :refDate IS NULL) - GROUP BY vrp2.vesselRegistrationPeriodPk.vessel.code - ) - AND vf.startDateTime = - ( - SELECT MAX(vf2.startDateTime) - FROM VesselFeaturesImpl vf2 WHERE - vf2.vessel.code = v.code - AND (vf2.startDateTime <= :refDate OR :refDate IS NULL) - GROUP BY vf2.vessel.code - )]]> + VesselImpl v + INNER JOIN v.vesselRegistrationPeriods AS vrp + LEFT OUTER JOIN v.vesselFeatures AS vf + WHERE + v.code = :vesselCode + AND v.status.code IN (:statusValidCode, :statusTemporaryCode) + AND vrp.vesselRegistrationPeriodPk.startDateTime = + ( + SELECT MAX(vrp2.vesselRegistrationPeriodPk.startDateTime) + FROM VesselRegistrationPeriodImpl vrp2 WHERE + vrp2.vesselRegistrationPeriodPk.vessel.code = v.code + AND (vrp2.vesselRegistrationPeriodPk.startDateTime <= :refDate OR :refDate IS NULL) + GROUP BY vrp2.vesselRegistrationPeriodPk.vessel.code + ) + AND vf.startDateTime = + ( + SELECT MAX(vf2.startDateTime) + FROM VesselFeaturesImpl vf2 WHERE + vf2.vessel.code = v.code + AND (vf2.startDateTime <= :refDate OR :refDate IS NULL) + GROUP BY vf2.vessel.code + ) + ]]> <query-param name="vesselCode" type="java.lang.String"/> <query-param name="refDate" type="java.util.Date"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> </query> - <!-- Get all gears [REF-05] and [REF-06] --> + <!-- [REF-04] [REF-05] Get all gears --> <query cacheable="true" name="allGears"> <![CDATA[ - SELECT + SELECT g.id, g.label, g.name, g.status AS status - FROM GearImpl g - WHERE + FROM GearImpl g + WHERE g.gearClassification.id= :gearClassificiationId - AND g.status.code IN (1, 2) + AND g.status.code IN (:statusValidCode, :statusTemporaryCode) ]]> <query-param name="gearClassificiationId" type="java.lang.Integer"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> </query> - <!-- Get all persons [REF-07] --> + <!-- [REF-07] Get all persons --> <query cacheable="true" name="allPersons"> <![CDATA[ SELECT DISTINCT @@ -243,7 +364,7 @@ PersonImpl p LEFT OUTER JOIN p.profils pp WHERE - p.status.code in (1,2) + p.status.code IN (:statusValidCode, :statusTemporaryCode) AND pp.id IN ( :observerProfilId, :projectMemberProfilId, @@ -254,55 +375,26 @@ <query-param name="observerProfilId" type="java.lang.Integer"/> <query-param name="projectMemberProfilId" type="java.lang.Integer"/> <query-param name="userProfilId" type="java.lang.Integer"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> </query> - <!-- Get one persons [REF-07-1] --> + <!-- [REF-07-1] Get one person --> <query cacheable="true" name="person"> <![CDATA[ - SELECT DISTINCT + SELECT DISTINCT p.id, p.firstname, p.lastname, p.department.code, p.status - FROM - PersonImpl p - WHERE p.id = :personId + FROM PersonImpl p + WHERE p.id = :personId ]]> <query-param name="personId" type="java.lang.Integer"/> </query> - <!-- TODO Fix it! Get all species [REF-08] --> - <query cacheable="true" name="allSpecies"> - <![CDATA[ - SELECT - t.id, - t.label, - t.name, - t.status - FROM TaxonGroupImpl t - WHERE t.taxonGroupType.code = :taxonGroupCode - AND t.isChildGroupExclusive = false - AND t.status.code IN (1, 2) - ]]> - <query-param name="taxonGroupCode" type="java.lang.Integer"/> - </query> - - <!-- TODO Fix it! Get one species [REF-08-1] --> - <query cacheable="true" name="species"> - <![CDATA[ - SELECT - t.id, - t.label, - t.name, - t.status - FROM TaxonGroupImpl t - WHERE t.id = :speciesId - ]]> - <query-param name="speciesId" type="java.lang.Integer"/> - </query> - - <!-- Get all length step catacteristics [REF-09] --> + <!-- [REF-09] Get all length step catacteristics --> <query cacheable="true" name="allLengthStepCaracteristics"> <![CDATA[ SELECT @@ -319,7 +411,8 @@ p.unit.symbol AS symbol, p.status AS status FROM PmfmImpl p - WHERE p.status.code IN (1, 2) + WHERE + p.status.code IN (:statusValidCode, :statusTemporaryCode) AND p.matrix.id = :matrixId AND p.parameter.isQualitative=false AND p.parameter.isAlphanumeric=false @@ -331,100 +424,48 @@ <query-param name="ageParameterCode" type="java.lang.String"/> <query-param name="weightParameterCode" type="java.lang.String"/> <query-param name="methodDeclarationId" type="java.lang.Integer"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> </query> - <!-- Get all gear caracteristics [REF-10] (use allPmfmsByMatrixId) --> - <!--query cacheable="true" name="allGearFeaturesCaracteristics"> - <![CDATA[ - SELECT - p.id AS pmfmId, - p.parameter.name AS parameterName, - p.matrix.name AS matrixName, - p.fraction.name AS fractionName, - p.method.name AS methodName, - p.parameter.isAlphanumeric AS isAlphanumeric, - p.parameter.isQualitative AS isQualitative, - p.unit.symbol AS symbol, - p.status AS status - FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.matrix.id= :matrixId - ]]> - <query-param name="matrixId" type="java.lang.Integer"/> - </query--> - - <!-- Get all environment caracteristics [REF-11] (use allPmfmsByParameterGroudId) --> - <!--query cacheable="true" name="allEnvironmentCaracteristics"> - <![CDATA[ - SELECT - p.id AS pmfmId, - p.parameter.name AS parameterName, - p.matrix.name AS matrixName, - p.fraction.name AS fractionName, - p.method.name AS methodName, - p.parameter.isAlphanumeric AS isAlphanumeric, - p.parameter.isQualitative AS isQualitative, - p.unit.symbol AS symbol, - p.status AS status - FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.parameter.parameterGroup.id= :parameterGroupId - ]]> - <query-param name="parameterGroupId" type="java.lang.Integer"/> - </query--> - - <!-- TODO FIX IT! Get all hydrology caracteristics [REF-12] (use allPmfmsByParameterGroudId) --> - <!--query cacheable="true" name="allHydrologyCaracteristics"> - <![CDATA[ - SELECT - p.id AS pmfmId, - p.parameter.name AS parameterName, - p.matrix.name AS matrixName, - p.fraction.name AS fractionName, - p.method.name AS methodName, - p.parameter.isAlphanumeric AS isAlphanumeric, - p.parameter.isQualitative AS isQualitative, - p.unit.symbol AS symbol, - p.status AS status - FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.parameter.parameterGroup.id= :parameterGroupId - ]]> - <query-param name="parameterGroupId" type="java.lang.Integer"/> - </query--> - - <!-- Get all fishing operation strates [REF-13] --> + <!-- [REF-13] Get all fishing operation strates --> <query cacheable="true" name="allFishingOperationStratas"> <![CDATA[ - SELECT + SELECT l.id as locationId, l.label as locationLabel, l.name as locationName, l.locationLevel.id as locationLevelId, l.status as status - FROM LocationImpl l - WHERE l.status.code IN (1, 2) + FROM LocationImpl l + WHERE + l.status.code IN (:statusValidCode, :statusTemporaryCode) AND l.locationLevel.id = :locationLevelId ]]> <query-param name="locationLevel" type="java.lang.Integer"/> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> </query> - <!-- Get all fishing operation substrates [REF-14] --> + <!-- [REF-14] Get all fishing operation substrates --> <query cacheable="true" name="allFishingOperationSubStratas"> <![CDATA[ - SELECT + SELECT l.id as locationId, l.label as locationLabel, l.name as locationName, l.locationLevel.id as locationLevelId, l.status as status - FROM LocationImpl l - WHERE l.status.code IN (1, 2) + FROM LocationImpl l + WHERE + l.status.code IN (:statusValidCode, :statusTemporaryCode) AND l.locationLevel.id = :locationLevelId ]]> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> </query> - <!-- Get all fishing operation localites [REF-15] --> + <!-- [REF-15] Get all fishing operation localites --> <query cacheable="true" name="allFishingOperationLocalites"> <![CDATA[ SELECT @@ -434,143 +475,17 @@ l.locationLevel.id as locationLevelId, l.status as status FROM LocationImpl l - WHERE l.status.code IN (1, 2) - AND l.locationLevel.id = :locationLevelId + WHERE + l.status.code IN (:statusValidCode, :statusTemporaryCode) + AND l.locationLevel.id = :locationLevelId ]]> + <query-param name="statusValidCode" type="java.lang.String"/> + <query-param name="statusTemporaryCode" type="java.lang.String"/> </query> - <!-- TODO Fix it! Get all Length - Weight conversions [REF-16] --> + <!-- TODO [REF-16] Get all Length - Weight conversions --> <!--query cacheable="true" name="allLengthWeightConvertions"> <![CDATA[]]> </query--> - <!-- TODO Fix it! Get all benthos species [REF-17] --> - <query cacheable="true" name="allBenthosSpecies"> - <![CDATA[ - SELECT - t.id, - t.label, - t.name, - t.status - FROM TaxonGroupImpl t - WHERE t.taxonGroupType.code = :taxonGroupCode - AND t.isChildGroupExclusive = false - AND t.status.code IN (1, 2) - ]]> - <query-param name="taxonGroupCode" type="java.lang.Integer"/> - </query> - - <!-- TODO Fix it! Get all plankton species [REF-18] TODO --> - <query cacheable="true" name="allPlanktonSpecies"> - <![CDATA[ - SELECT - t.id, - t.label, - t.name, - t.status - FROM TaxonGroupImpl t - WHERE t.taxonGroupType.code = :taxonGroupCode - AND t.isChildGroupExclusive = false - AND t.status.code IN (1, 2) - ]]> - <query-param name="taxonGroupCode" type="java.lang.Integer"/> - </query> - - <!-- Get all macroWaste categories [REF-19] (use pmfmById + pmfmQualitativeValues) --> - <!--query cacheable="true" name="allMacroWasteCategories"> - <![CDATA[ - ]]> - </query--> - - <!-- Get all macroWaste size categories [REF-20] (use pmfmById + pmfmQualitativeValues) --> - <!--query cacheable="true" name="allMacroWasteSizeCategories"> - <![CDATA[ - ]]> - </query--> - - <!-- Get a pmfm caracteristics by this id [REF-24] --> - <query cacheable="true" name="pmfmById"> - <![CDATA[ - SELECT - p.id AS pmfmId, - p.parameter.name AS parameterName, - p.matrix.name AS matrixName, - p.fraction.name AS fractionName, - p.method.name AS methodName, - p.parameter.isAlphanumeric AS isAlphanumeric, - p.parameter.isQualitative AS isQualitative, - p.signifFiguresNumber, - p.maximumNumberDecimals, - p.precision, - p.unit.symbol AS symbol, - p.status AS status - FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.id= :pmfmId - ]]> - <query-param name="pmfmId" type="java.lang.Integer"/> - </query> - - <!-- Get a pmfm qualitative values from his id [REF-25] --> - <query cacheable="true" name="pmfmQualitativeValues"> - <![CDATA[ - SELECT - qv.id AS id, - case when (qv.name = qv.description) then qv.name else concat(qv.name, ' - ', qv.description) end AS name, - qv.status AS status - FROM - PmfmImpl p JOIN p.qualitativeValues qv - WHERE p.id= :pmfmId - AND qv.status.code IN (1, 2) - ]]> - <query-param name="pmfmId" type="java.lang.Integer"/> - </query> - - <!-- Get all pmfms using a same matrix Id --> - <query cacheable="true" name="allPmfmsByMatrixId"> - <![CDATA[ - SELECT - p.id AS pmfmId, - p.parameter.name AS parameterName, - p.matrix.name AS matrixName, - p.fraction.name AS fractionName, - p.method.name AS methodName, - p.parameter.isAlphanumeric AS isAlphanumeric, - p.parameter.isQualitative AS isQualitative, - p.signifFiguresNumber, - p.maximumNumberDecimals, - p.precision, - p.unit.symbol AS symbol, - p.status AS status - FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.matrix.id= :matrixId - ]]> - <query-param name="matrixId" type="java.lang.Integer"/> - </query> - - <!-- Get all pmfms using a same parameter group id --> - <query cacheable="true" name="allPmfmsByParameterGroudId"> - <![CDATA[ - SELECT - p.id AS pmfmId, - p.parameter.name AS parameterName, - p.matrix.name AS matrixName, - p.fraction.name AS fractionName, - p.method.name AS methodName, - p.parameter.isAlphanumeric AS isAlphanumeric, - p.parameter.isQualitative AS isQualitative, - p.signifFiguresNumber, - p.maximumNumberDecimals, - p.precision, - p.unit.symbol AS symbol, - p.status AS status - FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.parameter.parameterGroup.id= :parameterGroupId - ]]> - <query-param name="parameterGroupId" type="java.lang.Integer"/> - </query> - - </hibernate-mapping> Modified: trunk/tutti-persistence-adagio/src/main/resources/tutti-db-enumerations.properties =================================================================== --- trunk/tutti-persistence-adagio/src/main/resources/tutti-db-enumerations.properties 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/main/resources/tutti-db-enumerations.properties 2013-01-12 17:59:34 UTC (rev 181) @@ -297,6 +297,9 @@ ZoneCompetenceMapping.SEA=Corse|4022,Guadeloupe|4020,Guyanne|4020,La Réunion|4028,Martinique|4020,Mayotte|4028,Méditerranée|4022,Mer du nord manche atlantique|4018,Saint Pierre et Miquelon|4017 ZoneCompetenceMapping.DEFAULT_LOCATION_LEVEL=Corse|142,Guadeloupe|158;159,Guyanne|154;156,La Réunion|151;152,Martinique|158;159,Mayotte|,Méditerranée|142,Mer du nord manche atlantique|113;114,Saint Pierre et Miquelon|101 +# 10/01/2012 BLA Need to retrieve a Location from a given position (Lat/Long) +LocationLevelId.RECTANGLE_STATISTIQUE_MED=145 + # Ajoute pour Tutti LocationLevelId.LOCALITE=22 LocationLevelId.STRATA=23 Modified: trunk/tutti-persistence-adagio/src/main/site/rst/referential.rst =================================================================== --- trunk/tutti-persistence-adagio/src/main/site/rst/referential.rst 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/main/site/rst/referential.rst 2013-01-12 17:59:34 UTC (rev 181) @@ -29,14 +29,87 @@ Présentation ~~~~~~~~~~~~ -Ce document décrit comment sont récupérer les données du référentiel. +Ce document décrit comment sont récupérées les données du référentiel. Chaque requète a un nom du style **[REF-XXX]**. +Etat des lieux +~~~~~~~~~~~~~~ + ++-----------------------------------------------------+-------------------------------------------------------------+ +| Nom requète | Etat | Commentaire | ++=====================================================+======+=====================================================+ +| [REF-01] Liste des zones d'une série de campagne | KO | Définir le niveau LocationLevel | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-02] Liste des pays | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-03] Liste des navires (scientifique) | OK | Requète très longue il faut optimiser | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-04] Liste des navires (pro) | OK | Requète très longue il faut optimiser | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-05] Liste des engins (scientifique) | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-06] Liste des engins (pro) | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-07] Liste des utilisateurs | OK | Doit-on utliser limiter aux membres de l'Ifremer ? | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-08] Liste des espèces | OK | Utilisation de synonymes via import refTax ? | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-09] Liste des psfm mesure de classe de taille | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-10] Liste des psfm (mise en oeuvre de l'engin) | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-11] Liste des psfm (environnement) | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-12] Liste des psfm (hydrologique) | KO | Données à regrouper en base avec un ParameterGroup ?| ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-13] Liste des strates | KO | Pouvoir les lier aux zones / rectangle statistique | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-14] Liste des sous-strates | KO | Pouvoir les lier aux zones / rectangle statistique / strates | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-15] Liste des localités | KO | Pouvoir les lier aux zones / rectangle statistique / strates / sous-strates | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-16] Conversion Taille-poids | TODO | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-17] Liste des espèces (écran benthos) | KO | Valider comment on filtre (sur le protocole ?) | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-18] Liste des espèces (écran plancton) | KO | Valider comment on filtre (sur le protocole ?) | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-19] Catégorie de macro-déchets | KO | Créer les données en base | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-20] Catégorie de taille macro-déchets | KO | Créer les données en base | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-21] Liste des espèces (écran accidentelles) | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-22] Liste des psfm (écran accidentelles) | TODO | Définir ce qu'on peut mettre ici (protocole ?) | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-23] Catégorie H/VC | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-24] Catégorie Classe. Tri | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-25] Catégorie Sexe | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-26] Catégorie Maturité | KO | Valider le psfm à utiliser (MATURITY ou MATURITY_STAGE_5_VISUAL)| ++=====================================================+======+=====================================================+ +| [REF-T01] Détail d'un psfm par son id | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-T02] Valeurs qualitatives d'un psfm | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-T03] Liste de psfm à partir d'un support | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-T04] Liste de psfm à partir d'un parameterGroup| OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ +| [REF-T05] Lieu statistique à partir de lat/long | OK | | ++-----------------------------------------------------+------+-----------------------------------------------------+ + +Les requètes métier +~~~~~~~~~~~~~~~~~~~~ + [REF-01] Liste des zones d'une série de campagne ------------------------------------------------ :: + SELECT l.id, l.label, @@ -44,10 +117,9 @@ l.status FROM LocationImpl l WHERE - l.locationLevel.id = :locationLevelId - AND l.status.code IN (1, 2) + l.locationLevel.id = :locationLevelId + AND l.status.code IN (1, 2) - Paramètres : - :locationLevelId = *LocationLevelId.PROGRAM* @@ -66,8 +138,8 @@ l.status FROM LocationImpl l WHERE - l.locationLevel.id = :locationLevelId - AND l.status.code IN (1, 2) + l.locationLevel.id = :locationLevelId + AND l.status.code IN (1, 2) Paramètres : @@ -76,7 +148,7 @@ *État:* Valide. -[REF-03] liste des navires (scientifique) +[REF-03] Liste des navires (scientifique) ----------------------------------------- :: @@ -110,7 +182,6 @@ GROUP BY vf2.vessel.code ) - Paramètres : - :gearClassificiationId = *VesselTypeId.SCIENTIFIC_RESEARCH_VESSEL* @@ -118,7 +189,7 @@ *État:* Valide mais à optimiser. -[REF-04] liste des navires (pro) +[REF-04] Liste des navires (pro) -------------------------------- :: @@ -160,20 +231,20 @@ *État:* Valide mais à optimiser. -[REF-05] liste des engins (scientifique) +[REF-05] Liste des engins (scientifique) ---------------------------------------- :: SELECT - g.id, - g.label, - g.name, - g.status AS status + g.id, + g.label, + g.name, + g.status AS status FROM GearImpl g WHERE - g.gearClassification.id= :gearClassificiationId - AND g.status.code IN (1, 2) + g.gearClassification.id= :gearClassificiationId + AND g.status.code IN (1, 2) Paramètres : @@ -182,20 +253,20 @@ *État:* Valide. -[REF-06] liste des engins (scientifique) ----------------------------------------- +[REF-06] Liste des engins (pro) +------------------------------- :: SELECT - g.id, - g.label, - g.name, - g.status AS status + g.id, + g.label, + g.name, + g.status AS status FROM GearImpl g WHERE - g.gearClassification.id= :gearClassificiationId - AND g.status.code IN (1, 2) + g.gearClassification.id= :gearClassificiationId + AND g.status.code IN (1, 2) Paramètres : @@ -225,7 +296,7 @@ :projectMemberProfilId, :userProfilId ) - AND p.department.code LIKE 'PDG-%' + AND p.department.code LIKE 'PDG-%' Paramètres : @@ -245,8 +316,8 @@ *État:* Valide. -[REF-09] liste des mesures de classes de taille ------------------------------------------------ +[REF-09] Liste des psfm mesure de classe de taille +-------------------------------------------------- :: @@ -264,7 +335,8 @@ p.unit.symbol AS symbol, p.status AS status FROM PmfmImpl p - WHERE p.status.code IN (1, 2) + WHERE + p.status.code IN (1, 2) AND p.matrix.id = :matrixId AND p.parameter.isQualitative=false AND p.parameter.isAlphanumeric=false @@ -281,65 +353,166 @@ *État:* Valide. -[REF-10] Liste des pmfm (mise en oeuvre de l'engin) +[REF-10] Liste des psfm (mise en oeuvre de l'engin) --------------------------------------------------- +[REF-T03] avec :matrixId= *MatrixId.GEAR* + +*État:* Valide. + +[REF-11] Liste des psfm (environnement) +--------------------------------------- + +[REF-T03] avec :parameterGroupId= *ParameterGroupId.ENVIRONEMENT_MEASUREMENT* + +*État:* Valide. + +[REF-12] Liste des psfm (hydrologique) +-------------------------------------- + +[REF-T03] avec :parameterGroupId= *ParameterGroupId.HYDROLOGIC_MEASUREMENT* + +*État:* Données non présentes en base. + +[REF-13] Liste des strates +-------------------------- + :: SELECT - p.id AS pmfmId, - p.parameter.name AS parameterName, - p.matrix.name AS matrixName, - p.fraction.name AS fractionName, - p.method.name AS methodName, - p.parameter.isAlphanumeric AS isAlphanumeric, - p.parameter.isQualitative AS isQualitative, - p.signifFiguresNumber, - p.maximumNumberDecimals, - p.precision, - p.unit.symbol AS symbol, - p.status AS status - FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.matrix.id= :matrixId + l.id as locationId, + l.label as locationLabel, + l.name as locationName, + l.locationLevel.id as locationLevelId, + l.status as status + FROM LocationImpl l + WHERE + l.status.code IN (1, 2) + AND l.locationLevel.id = :locationLevelId Paramètres : -- :matrixId = *MatrixId.GEAR* +- :locationLevelId = *LocationLevelId.STRATA* -*État:* Valide. +*État:* A lier aux zones de série de camapgnes et au rectangle statistique. -[REF-11] liste des pmfm (environnement) ---------------------------------------- +[REF-14] Liste des sous-strates +------------------------------- :: SELECT - p.id AS pmfmId, - p.parameter.name AS parameterName, - p.matrix.name AS matrixName, - p.fraction.name AS fractionName, - p.method.name AS methodName, - p.parameter.isAlphanumeric AS isAlphanumeric, - p.parameter.isQualitative AS isQualitative, - p.signifFiguresNumber, - p.maximumNumberDecimals, - p.precision, - p.unit.symbol AS symbol, - p.status AS status - FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.parameter.parameterGroup.id= :parameterGroupId + l.id as locationId, + l.label as locationLabel, + l.name as locationName, + l.locationLevel.id as locationLevelId, + l.status as status + FROM LocationImpl l + WHERE + l.status.code IN (1, 2) + AND l.locationLevel.id = :locationLevelId Paramètres : -- :parameterGroupId = *ParameterGroupId.ENVIRONEMENT_MEASUREMENT* +- :locationLevelId = *LocationLevelId.SUBSTRATA* +*État:* Pouvoir les lier aux zones et rectangle statistique et strates. + +[REF-15] Liste des localités +---------------------------- + +:: + + SELECT + l.id as locationId, + l.label as locationLabel, + l.name as locationName, + l.locationLevel.id as locationLevelId, + l.status as status + FROM LocationImpl l + WHERE + l.status.code IN (1, 2) + AND l.locationLevel.id = :locationLevelId + +Paramètres : + +- :locationLevelId = *LocationLevelId.LOCALITE* + +*État:* Pouvoir les lier aux zones et rectangle statistique et strates . + +[REF-16] Conversion Taille-poids +-------------------------------- + +*État:* A faire. + +[REF-17] Liste des espèces (écran benthos) +------------------------------------------ + +*État:* Valider comment on filtre (sur le protocole ?). + +[REF-18] Liste des espèces (écran plancton) +------------------------------------------- + +*État:* Valider comment on filtre (sur le protocole ?). + +[REF-19] Catégorie de macro-déchets +----------------------------------- + +[REF-T01] + [REF-T02] avec :pmfmId = *PmfmId.MACRO_WASTE_CATEGORY* + +*État:* les données sont à créer en base. + +[REF-20] Catégorie de taille macro-déchets +------------------------------------------- + +[REF-T01] + [REF-T02] avec :pmfmId = *PmfmId.MACRO_WASTE_SIZE_CATEGORY* + +*État:* les données sont à créer en base. + +[REF-21] Liste des espèces (écran capture accidentelles) +-------------------------------------------------------- + +*État:* Valide (on prend toutes les espèces). + +[REF-22] Liste des psfm pour les captures accidentelles +------------------------------------------------------- + +*État:* A FAIRE. + +[REF-23] Catégorie H/VC +----------------------- + +[REF-T01] + [REF-T02] avec :pmfmId = *PmfmId.SORTED_UNSORTED* + *État:* Valide. -[REF-12] liste des pmfm (environnement) ---------------------------------------- +[REF-24] Catégorie Classe. Tri +------------------------------ +[REF-T01] + [REF-T02] avec :pmfmId = *PmfmId.SIZE_CATEGORY* + +*État:* Valide. + +[REF-25] Catégorie Sexe +----------------------- + +[REF-T01] + [REF-T02] avec :pmfmId = *PmfmId.SEX* + +*État:* Valide. + +[REF-26] Catégorie Maturité +--------------------------- + +[REF-T01] + [REF-T02] avec :pmfmId = *PmfmId.MATURITY* + +*État:* Valider l'id utilisé. + +Les requètes techniques +~~~~~~~~~~~~~~~~~~~~~~~ + +[REF-T01] Détail d'un psfm par son id +------------------------------------- + :: SELECT @@ -353,83 +526,104 @@ p.signifFiguresNumber, p.maximumNumberDecimals, p.precision, - p.unit.symbol AS symbol, + case when (p.unit.id = :unitIdNone) then '' else p.unit.symbol end AS symbol, p.status AS status FROM PmfmImpl p - WHERE p.status.code IN (1, 2) - AND p.parameter.parameterGroup.id= :parameterGroupId + WHERE + p.status.code IN (1, 2) + AND p.id= :pmfmId Paramètres : -- :parameterGroupId = *ParameterGroupId.HYDROLOGIC_MEASUREMENT* +- :pmfmId = id du psfm +- :unitIdNone = *UnitId.NONE* -*État:* Données non présentes en base. +*État:* Valide. -[REF-13] liste des strates --------------------------- +[REF-T02] Valeurs qualitatives d'un psfm +---------------------------------------- :: SELECT - l.id as locationId, - l.label as locationLabel, - l.name as locationName, - l.locationLevel.id as locationLevelId, - l.status as status - FROM LocationImpl l - WHERE l.status.code IN (1, 2) - AND l.locationLevel.id = :locationLevelId + qv.id AS id, + case when (qv.name = qv.description) then qv.name else concat(qv.name, ' - ', qv.description) end AS name, + qv.status AS status + FROM + PmfmImpl p JOIN p.qualitativeValues qv + WHERE + p.id= :pmfmId + AND qv.status.code IN (1, 2) Paramètres : -- :locationLevelId = *LocationLevelId.STRATA* +- :pmfmId = id du psfm *État:* Valide. -[REF-14] liste des sous-strates --------------------------------- +[REF-T03] Liste de psfm à partir d'un support +--------------------------------------------- :: SELECT - l.id as locationId, - l.label as locationLabel, - l.name as locationName, - l.locationLevel.id as locationLevelId, - l.status as status - FROM LocationImpl l - WHERE l.status.code IN (1, 2) - AND l.locationLevel.id = :locationLevelId + p.id AS pmfmId, + p.parameter.name AS parameterName, + p.matrix.name AS matrixName, + p.fraction.name AS fractionName, + p.method.name AS methodName, + p.parameter.isAlphanumeric AS isAlphanumeric, + p.parameter.isQualitative AS isQualitative, + p.signifFiguresNumber, + p.maximumNumberDecimals, + p.precision, + case when (p.unit.id = :unitIdNone) then '' else p.unit.symbol end AS symbol, + p.status AS status + FROM PmfmImpl p + WHERE + p.status.code IN (1, 2) + AND p.matrix.id= :matrixId Paramètres : -- :locationLevelId = *LocationLevelId.SUBSTRATA* +- :matrixId = id du support +- :unitIdNone = *UnitId.NONE* -*État:* A valider, il faut trouver comment récupérer les valeurs par rapport -à une strate. +*État:* Valide. -[REF-15] liste des localités ----------------------------- +[REF-T04] Liste de psfm à partir d'un groupe de paramètre +--------------------------------------------------------- :: SELECT - l.id as locationId, - l.label as locationLabel, - l.name as locationName, - l.locationLevel.id as locationLevelId, - l.status as status - FROM LocationImpl l - WHERE l.status.code IN (1, 2) - AND l.locationLevel.id = :locationLevelId + p.id AS pmfmId, + p.parameter.name AS parameterName, + p.matrix.name AS matrixName, + p.fraction.name AS fractionName, + p.method.name AS methodName, + p.parameter.isAlphanumeric AS isAlphanumeric, + p.parameter.isQualitative AS isQualitative, + p.signifFiguresNumber, + p.maximumNumberDecimals, + p.precision, + case when (p.unit.id = :unitIdNone) then '' else p.unit.symbol end AS symbol, + p.status AS status + FROM PmfmImpl p + WHERE + p.status.code IN (1, 2) + AND p.parameter.parameterGroup.id= :parameterGroupId Paramètres : -- :locationLevelId = *LocationLevelId.LOCALITE* +- :parameterGroupId = id du parameterGroup +- :unitIdNone = *UnitId.NONE* -*État:* A valider, il faut trouver comment récupérer les valeurs par rapport -à une strate, sous-strate. +*État:* Valide. +[REF-T04] Lieu statistique (rectangle statistique) à partir de lat/long +----------------------------------------------------------------------- +Utiliser *LocationService.getLocationIdByLatLong()* (adagio-core) - +*État:* Valide. Modified: trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/CruiseTest.java =================================================================== --- trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/CruiseTest.java 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/CruiseTest.java 2013-01-12 17:59:34 UTC (rev 181) @@ -26,7 +26,9 @@ import fr.ifremer.tutti.persistence.entities.data.Cruise; import fr.ifremer.tutti.persistence.entities.data.Program; +import fr.ifremer.tutti.persistence.service.TuttiPersistenceServiceLocator; import org.junit.Assert; +import org.junit.Before; import org.junit.ClassRule; import org.junit.Ignore; import org.junit.Test; @@ -45,10 +47,17 @@ @ClassRule public static final DatabaseResource dbResource = new DatabaseResource(); + protected TuttiPersistence service; + + @Before + public void setUp() throws Exception { + service = TuttiPersistenceServiceLocator.getPersistenceService(); + } + @Test public void getAllCruise(/*String programId*/) { String programCode = dbResource.getFixtures().programCode(); - List<Cruise> result = dbResource.getDriver().getAllCruise(programCode); + List<Cruise> result = service.getAllCruise(programCode); Assert.assertNotNull(result); Assert.assertEquals(1, result.size()); } @@ -57,7 +66,7 @@ public void getCruise(/*String id*/) { String cruiseId = dbResource.getFixtures().cruiseId(); - Cruise result = dbResource.getDriver().getCruise(cruiseId); + Cruise result = service.getCruise(cruiseId); Assert.assertNotNull(result); } Modified: trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/DatabaseResource.java =================================================================== --- trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/DatabaseResource.java 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/DatabaseResource.java 2013-01-12 17:59:34 UTC (rev 181) @@ -26,6 +26,7 @@ import fr.ifremer.tutti.persistence.config.TuttiPersistenceAdagioConfig; import fr.ifremer.tutti.persistence.config.TuttiPersistenceAdagioConfigOption; +import fr.ifremer.tutti.persistence.service.TuttiPersistenceServiceLocator; import org.apache.commons.io.FileUtils; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; @@ -34,9 +35,6 @@ import org.junit.runner.Description; import org.junit.runners.model.Statement; import org.nuiton.util.ApplicationConfig; -import org.nuiton.util.ArgumentsParserException; -import org.springframework.context.ApplicationContext; -import org.springframework.context.support.ClassPathXmlApplicationContext; import java.io.File; import java.io.IOException; @@ -58,17 +56,12 @@ protected TuttiPersistenceAdagioConfig config; - protected TuttiPersistence driver; - protected DatabaseFixtures fixtures; public TuttiPersistenceAdagioConfig getConfig() { return config; } - public TuttiPersistence getDriver() { - return driver; - } public DatabaseFixtures getFixtures() { return fixtures; @@ -108,46 +101,9 @@ } fixtures = new DatabaseFixtures(); - config = createConfig(testClass, ""); - if (log.isDebugEnabled()) { - log.debug("Use conf.properties at " + config.getDbConfigurationPath()); - } - ApplicationContext context = new ClassPathXmlApplicationContext( - "applicationContext-conf.xml", - "applicationContext-dataSource-local.xml", - "applicationContext-entities.xml", - "applicationContext-service-tutti.xml"); + File resourceDirectory = getTestSpecificDirectory(testClass, ""); - driver = (TuttiPersistence) context.getBean("adagioPersistenceService"); - - driver.setEnumerations(config.getDbEnumerations()); - - driver.open(); - } - - protected void after(Description description) throws IOException { - Class<?> testClass = description.getTestClass(); - if (log.isInfoEnabled()) { - log.info("After test " + testClass); - } - // push back old classLoader - if (oldClassLoader != null) { - Thread.currentThread().setContextClassLoader(oldClassLoader); - } - - // close hibernate session if was used - if (driver != null) { - driver.close(); - } - } - - - public static TuttiPersistenceAdagioConfig createConfig(Class<?> testClass, - String name) throws ArgumentsParserException, IOException { - - File resourceDirectory = getTestSpecificDirectory(testClass, name); - RessourceClassLoader loader = new RessourceClassLoader(testClass.getClassLoader()); @@ -162,13 +118,28 @@ resourceDirectory.getAbsolutePath()); applicationConfig.parse(); - TuttiPersistenceAdagioConfig result = - new TuttiPersistenceAdagioConfig(applicationConfig); + config = new TuttiPersistenceAdagioConfig(applicationConfig); - result.initConfig(loader); - return result; + config.initConfig(loader); + + if (log.isDebugEnabled()) { + log.debug("Use conf.properties at " + config.getDbConfigurationPath()); + } } + protected void after(Description description) throws IOException { + Class<?> testClass = description.getTestClass(); + if (log.isInfoEnabled()) { + log.info("After test " + testClass); + } + // push back old classLoader + if (oldClassLoader != null) { + Thread.currentThread().setContextClassLoader(oldClassLoader); + } + + TuttiPersistenceServiceLocator.close(); + } + public static File getTestSpecificDirectory(Class<?> testClass, String name) throws IOException { // Trying to look for the temporary folder to store data for the test @@ -193,5 +164,4 @@ return databaseFile; } - } Modified: trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ProgramTest.java =================================================================== --- trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ProgramTest.java 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ProgramTest.java 2013-01-12 17:59:34 UTC (rev 181) @@ -25,7 +25,9 @@ */ import fr.ifremer.tutti.persistence.entities.data.Program; +import fr.ifremer.tutti.persistence.service.TuttiPersistenceServiceLocator; import org.junit.Assert; +import org.junit.Before; import org.junit.ClassRule; import org.junit.Ignore; import org.junit.Test; @@ -43,9 +45,16 @@ @ClassRule public static final DatabaseResource dbResource = new DatabaseResource(); + protected TuttiPersistence service; + + @Before + public void setUp() throws Exception { + service = TuttiPersistenceServiceLocator.getPersistenceService(); + } + @Test public void getAllProgram() { - List<Program> result = dbResource.getDriver().getAllProgram(); + List<Program> result = service.getAllProgram(); Assert.assertNotNull(result); Assert.assertEquals(1, result.size()); } @@ -53,7 +62,7 @@ @Test public void getProgram(/*String id*/) { String programCode = dbResource.getFixtures().programCode(); - Program actual = dbResource.getDriver().getProgram(programCode); + Program actual = service.getProgram(programCode); Assert.assertNotNull(actual); Assert.assertNotNull(actual.getId()); Assert.assertNotNull(actual.getName()); Deleted: trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ReferentialTest.java =================================================================== --- trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ReferentialTest.java 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ReferentialTest.java 2013-01-12 17:59:34 UTC (rev 181) @@ -1,224 +0,0 @@ -package fr.ifremer.tutti.persistence; - -/* - * #%L - * Tutti :: Persistence Adagio (impl) - * $Id$ - * $HeadURL$ - * %% - * Copyright (C) 2012 - 2013 Ifremer - * %% - * This program 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. - * - * 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>. - * #L% - */ - -import fr.ifremer.tutti.persistence.entities.data.Program; -import fr.ifremer.tutti.persistence.entities.referential.Caracteristic; -import fr.ifremer.tutti.persistence.entities.referential.Country; -import fr.ifremer.tutti.persistence.entities.referential.Gear; -import fr.ifremer.tutti.persistence.entities.referential.Person; -import fr.ifremer.tutti.persistence.entities.referential.Species; -import fr.ifremer.tutti.persistence.entities.referential.Vessel; -import fr.ifremer.tutti.persistence.entities.referential.Zone; -import org.junit.Assert; -import org.junit.ClassRule; -import org.junit.Ignore; -import org.junit.Test; - -import java.util.List; - -/** - * Test the referential service. - * - * @author tchemit <chemit@codelutin.com> - * @since 0.3 - */ -public class ReferentialTest { - - @ClassRule - public static final DatabaseResource dbResource = new DatabaseResource(); - - @Test - public void getAllProgramZone() { - List<Zone> result = dbResource.getDriver().getAllProgramZone(); - Assert.assertNotNull(result); - Assert.assertEquals(0, result.size()); - } - - @Test - public void getAllCountry() { - List<Country> result = dbResource.getDriver().getAllCountry(); - Assert.assertNotNull(result); - Assert.assertEquals(240, result.size()); - } - - @Test - public void getAllScientificVessel() { - List<Vessel> result = dbResource.getDriver().getAllScientificVessel(); - Assert.assertNotNull(result); - Assert.assertEquals(1, result.size()); - } - - //FIXME : requete trop longue (index manquant, trop de jointures?) - @Test - @Ignore - public void getAllFishingVessel() { - List<Vessel> result = dbResource.getDriver().getAllFishingVessel(); - Assert.assertNotNull(result); - Assert.assertEquals(187, result.size()); - } - - @Test - public void getAllScientificGear() { - List<Gear> result = dbResource.getDriver().getAllScientificGear(); - Assert.assertNotNull(result); - Assert.assertEquals(2, result.size()); - } - - @Test - public void getAllFishingGear() { - List<Gear> result = dbResource.getDriver().getAllFishingGear(); - Assert.assertNotNull(result); - Assert.assertEquals(75, result.size()); - } - - @Test - public void getAllPerson() { - List<Person> result = dbResource.getDriver().getAllPerson(); - Assert.assertNotNull(result); - Assert.assertEquals(123, result.size()); - } - - - @Test - public void getAllSpecies() { - List<Species> result = dbResource.getDriver().getAllSpecies(); - Assert.assertNotNull(result); - Assert.assertEquals(156, result.size()); - } - - @Test - public void getAllBenthosSpecies() { - List<Species> result = dbResource.getDriver().getAllBenthosSpecies(); - Assert.assertNotNull(result); - Assert.assertEquals(156, result.size()); - } - - @Test - public void getAllPlanktonSpecies() { - List<Species> result = dbResource.getDriver().getAllPlanktonSpecies(); - Assert.assertNotNull(result); - Assert.assertEquals(156, result.size()); - } - - @Test - public void getSpecies(/*String speciesId*/) { - } - - @Test - public void getAllFishingOperationStrata(/*String zoneId*/) { - } - - @Test - public void getAllFishingOperationSubStrata(/*String locationId*/) { - } - - @Test - public void getAllFishingOperationLocation(/*String locationId*/) { - } - - @Test - public void getAllFishingOperationEnvironmentCaracteristic() { - List<Caracteristic> result = dbResource.getDriver().getAllFishingOperationEnvironmentCaracteristic(); - Assert.assertNotNull(result); - Assert.assertEquals(40, result.size()); - } - - @Test - public void getAllFishingOperationGearCaracteristic() { - List<Caracteristic> result = dbResource.getDriver().getAllFishingOperationGearCaracteristic(); - Assert.assertNotNull(result); - Assert.assertEquals(155, result.size()); - } - - @Test - public void getAllFishingOperationHydrologicCaracteristic() { - List<Caracteristic> result = dbResource.getDriver().getAllFishingOperationHydrologicCaracteristic(); - Assert.assertNotNull(result); - Assert.assertEquals(40, result.size()); - } - - @Test - public void getAllSpeciesLengthStepCaracteristic() { - List<Caracteristic> result = dbResource.getDriver().getAllSpeciesLengthStepCaracteristic(); - Assert.assertNotNull(result); - Assert.assertEquals(24, result.size()); - } - - @Test - public void getSizeCategoryCaracteristic() { - Caracteristic result = dbResource.getDriver().getSizeCategoryCaracteristic(); - Assert.assertNotNull(result); - Assert.assertTrue(result.isQualitativeType()); - Assert.assertNotNull(result.getQualitativeValue()); - Assert.assertEquals(6, result.sizeQualitativeValue()); - } - - @Test - public void getSexCaracteristic() { - Caracteristic result = dbResource.getDriver().getSexCaracteristic(); - Assert.assertNotNull(result); - Assert.assertTrue(result.isQualitativeType()); - Assert.assertNotNull(result.getQualitativeValue()); - Assert.assertEquals(4, result.sizeQualitativeValue()); - } - - @Test - public void getSortedUnsortedCaracteristic() { - Caracteristic result = dbResource.getDriver().getSortedUnsortedCaracteristic(); - Assert.assertNotNull(result); - Assert.assertTrue(result.isQualitativeType()); - Assert.assertNotNull(result.getQualitativeValue()); - Assert.assertEquals(2, result.sizeQualitativeValue()); - } - - @Test - public void getMaturityCaracteristic() { - Caracteristic result = dbResource.getDriver().getMaturityCaracteristic(); - Assert.assertNotNull(result); - Assert.assertTrue(result.isQualitativeType()); - Assert.assertNotNull(result.getQualitativeValue()); - Assert.assertEquals(10, result.sizeQualitativeValue()); - } - - @Test - public void getMacroWasteCategoryCaracteristic() { - Caracteristic result = dbResource.getDriver().getMacroWasteCategoryCaracteristic(); - Assert.assertNotNull(result); - Assert.assertTrue(result.isQualitativeType()); - Assert.assertNotNull(result.getQualitativeValue()); - Assert.assertEquals(10, result.sizeQualitativeValue()); - } - - @Test - public void getMacroWasteSizeCategoryCaracteristic() { - Caracteristic result = dbResource.getDriver().getMacroWasteSizeCategoryCaracteristic(); - Assert.assertNotNull(result); - Assert.assertTrue(result.isQualitativeType()); - Assert.assertNotNull(result.getQualitativeValue()); - Assert.assertEquals(10, result.sizeQualitativeValue()); - } - -} Copied: trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceTest.java (from rev 179, trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/ReferentialTest.java) =================================================================== --- trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceTest.java (rev 0) +++ trunk/tutti-persistence-adagio/src/test/java/fr/ifremer/tutti/persistence/service/ReferentialPersistenceServiceTest.java 2013-01-12 17:59:34 UTC (rev 181) @@ -0,0 +1,232 @@ +package fr.ifremer.tutti.persistence.service; + +/* + * #%L + * Tutti :: Persistence Adagio (impl) + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2012 - 2013 Ifremer + * %% + * This program 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. + * + * 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>. + * #L% + */ + +import fr.ifremer.tutti.persistence.DatabaseResource; +import fr.ifremer.tutti.persistence.entities.referential.Caracteristic; +import fr.ifremer.tutti.persistence.entities.referential.Country; +import fr.ifremer.tutti.persistence.entities.referential.Gear; +import fr.ifremer.tutti.persistence.entities.referential.Person; +import fr.ifremer.tutti.persistence.entities.referential.Species; +import fr.ifremer.tutti.persistence.entities.referential.Vessel; +import fr.ifremer.tutti.persistence.entities.referential.Zone; +import org.junit.Assert; +import org.junit.Before; +import org.junit.ClassRule; +import org.junit.Ignore; +import org.junit.Test; + +import java.util.List; + +/** + * Test the referential service. + * + * @author tchemit <chemit@codelutin.com> + * @since 0.3 + */ +public class ReferentialPersistenceServiceTest { + + @ClassRule + public static final DatabaseResource dbResource = new DatabaseResource(); + + protected ReferentialPersistenceService service; + + @Before + public void setUp() throws Exception { + service = TuttiPersistenceServiceLocator.getReferentialPersistenceService(); + } + + @Test + public void getAllProgramZone() { + List<Zone> result = service.getAllProgramZone(); + Assert.assertNotNull(result); + Assert.assertEquals(0, result.size()); + } + + @Test + public void getAllCountry() { + List<Country> result = service.getAllCountry(); + Assert.assertNotNull(result); + Assert.assertEquals(240, result.size()); + } + + @Test + public void getAllScientificVessel() { + List<Vessel> result = service.getAllScientificVessel(); + Assert.assertNotNull(result); + Assert.assertEquals(1, result.size()); + } + + //FIXME : requete trop longue (index manquant, trop de jointures?) + @Test + @Ignore + public void getAllFishingVessel() { + List<Vessel> result = service.getAllFishingVessel(); + Assert.assertNotNull(result); + Assert.assertEquals(187, result.size()); + } + + @Test + public void getAllScientificGear() { + List<Gear> result = service.getAllScientificGear(); + Assert.assertNotNull(result); + Assert.assertEquals(2, result.size()); + } + + @Test + public void getAllFishingGear() { + List<Gear> result = service.getAllFishingGear(); + Assert.assertNotNull(result); + Assert.assertEquals(75, result.size()); + } + + @Test + public void getAllPerson() { + List<Person> result = service.getAllPerson(); + Assert.assertNotNull(result); + Assert.assertEquals(123, result.size()); + } + + + @Test + public void getAllSpecies() { + List<Species> result = service.getAllSpecies(); + Assert.assertNotNull(result); + Assert.assertEquals(8435, result.size()); + } + + @Test + public void getAllBenthosSpecies() { + List<Species> result = service.getAllBenthosSpecies(); + Assert.assertNotNull(result); + Assert.assertEquals(8435, result.size()); + } + + @Test + public void getAllPlanktonSpecies() { + List<Species> result = service.getAllPlanktonSpecies(); + Assert.assertNotNull(result); + Assert.assertEquals(8435, result.size()); + } + + @Test + public void getSpecies(/*String speciesId*/) { + } + + @Test + public void getAllFishingOperationStrata(/*String zoneId*/) { + } + + @Test + public void getAllFishingOperationSubStrata(/*String locationId*/) { + } + + @Test + public void getAllFishingOperationLocation(/*String locationId*/) { + } + + @Test + public void getAllFishingOperationEnvironmentCaracteristic() { + List<Caracteristic> result = service.getAllFishingOperationEnvironmentCaracteristic(); + Assert.assertNotNull(result); + Assert.assertEquals(40, result.size()); + } + + @Test + public void getAllFishingOperationGearCaracteristic() { + List<Caracteristic> result = service.getAllFishingOperationGearCaracteristic(); + Assert.assertNotNull(result); + Assert.assertEquals(155, result.size()); + } + + @Test + public void getAllFishingOperationHydrologicCaracteristic() { + List<Caracteristic> result = service.getAllFishingOperationHydrologicCaracteristic(); + Assert.assertNotNull(result); + Assert.assertEquals(40, result.size()); + } + + @Test + public void getAllSpeciesLengthStepCaracteristic() { + List<Caracteristic> result = service.getAllSpeciesLengthStepCaracteristic(); + Assert.assertNotNull(result); + Assert.assertEquals(24, result.size()); + } + + @Test + public void getSizeCategoryCaracteristic() { + Caracteristic result = service.getSizeCategoryCaracteristic(); + Assert.assertNotNull(result); + Assert.assertTrue(result.isQualitativeType()); + Assert.assertNotNull(result.getQualitativeValue()); + Assert.assertEquals(6, result.sizeQualitativeValue()); + } + + @Test + public void getSexCaracteristic() { + Caracteristic result = service.getSexCaracteristic(); + Assert.assertNotNull(result); + Assert.assertTrue(result.isQualitativeType()); + Assert.assertNotNull(result.getQualitativeValue()); + Assert.assertEquals(4, result.sizeQualitativeValue()); + } + + @Test + public void getSortedUnsortedCaracteristic() { + Caracteristic result = service.getSortedUnsortedCaracteristic(); + Assert.assertNotNull(result); + Assert.assertTrue(result.isQualitativeType()); + Assert.assertNotNull(result.getQualitativeValue()); + Assert.assertEquals(2, result.sizeQualitativeValue()); + } + + @Test + public void getMaturityCaracteristic() { + Caracteristic result = service.getMaturityCaracteristic(); + Assert.assertNotNull(result); + Assert.assertTrue(result.isQualitativeType()); + Assert.assertNotNull(result.getQualitativeValue()); + Assert.assertEquals(10, result.sizeQualitativeValue()); + } + + @Test + public void getMacroWasteCategoryCaracteristic() { + Caracteristic result = service.getMacroWasteCategoryCaracteristic(); + Assert.assertNotNull(result); + Assert.assertTrue(result.isQualitativeType()); + Assert.assertNotNull(result.getQualitativeValue()); + Assert.assertEquals(10, result.sizeQualitativeValue()); + } + + @Test + public void getMacroWasteSizeCategoryCaracteristic() { + Caracteristic result = service.getMacroWasteSizeCategoryCaracteristic(); + Assert.assertNotNull(result); + Assert.assertTrue(result.isQualitativeType()); + Assert.assertNotNull(result.getQualitativeValue()); + Assert.assertEquals(10, result.sizeQualitativeValue()); + } + +} Modified: trunk/tutti-persistence-adagio/src/test/resources/tutti-test.properties =================================================================== --- trunk/tutti-persistence-adagio/src/test/resources/tutti-test.properties 2013-01-12 17:57:25 UTC (rev 180) +++ trunk/tutti-persistence-adagio/src/test/resources/tutti-test.properties 2013-01-12 17:59:34 UTC (rev 181) @@ -21,5 +21,5 @@ # <http://www.gnu.org/licenses/gpl-3.0.html>. # #L% ### -tutti.persistence.jdbc.url=jdbc:hsqldb:file:src/test/db/allegro -#tutti.persistence.jdbc.url=jdbc:hsqldb:hsql://localhost/allegro \ No newline at end of file +#tutti.persistence.jdbc.url=jdbc:hsqldb:file:src/test/db/allegro +tutti.persistence.jdbc.url=jdbc:hsqldb:hsql://localhost/allegro \ No newline at end of file