March 2012 - Echobase-commits - mailman.cloud.codelutin.com

r443 - trunk
by tchemit＠users.forge.codelutin.com 29 Mar '12

29 Mar '12

Author: tchemit Date: 2012-03-29 14:01:23 +0200 (Thu, 29 Mar 2012) New Revision: 443 Url: http://forge.codelutin.com/repositories/revision/echobase/443 Log: Updates to mavenpom 3.2.1 Modified: trunk/pom.xml Modified: trunk/pom.xml =================================================================== --- trunk/pom.xml 2012-03-29 11:58:18 UTC (rev 442) +++ trunk/pom.xml 2012-03-29 12:01:23 UTC (rev 443) @@ -12,7 +12,7 @@ <parent> <groupId>org.nuiton</groupId> <artifactId>mavenpom4redmine</artifactId> - <version>3.2.1-SNAPSHOT</version> + <version>3.2.1</version> </parent> <groupId>fr.ifremer</groupId>

1 0

r442 - in trunk: echobase-entities/src/main/xmi src/doc/reunions
by tchemit＠users.forge.codelutin.com 29 Mar '12

29 Mar '12

Author: tchemit Date: 2012-03-29 13:58:18 +0200 (Thu, 29 Mar 2012) New Revision: 442 Url: http://forge.codelutin.com/repositories/revision/echobase/442 Log: add more docs + naturalId on Voyage Modified: trunk/echobase-entities/src/main/xmi/echobase.properties trunk/src/doc/reunions/reunion-2012-03-29.txt Modified: trunk/echobase-entities/src/main/xmi/echobase.properties =================================================================== --- trunk/echobase-entities/src/main/xmi/echobase.properties 2012-03-29 10:29:50 UTC (rev 441) +++ trunk/echobase-entities/src/main/xmi/echobase.properties 2012-03-29 11:58:18 UTC (rev 442) @@ -304,7 +304,7 @@ fr.ifremer.echobase.entities.data.Transit.attribute.relatedActivity.tagValue.notNull=true fr.ifremer.echobase.entities.data.Voyage.class.tagValue.naturalIdMutable=false -fr.ifremer.echobase.entities.data.Voyage.attribute.name.tagValue.naturalId=false +fr.ifremer.echobase.entities.data.Voyage.attribute.name.tagValue.naturalId=true fr.ifremer.echobase.entities.data.Voyage.attribute.name.tagValue.notNull=true fr.ifremer.echobase.entities.data.Voyage.attribute.startDate.tagValue.notNull=true fr.ifremer.echobase.entities.data.Voyage.attribute.endDate.tagValue.notNull=true Modified: trunk/src/doc/reunions/reunion-2012-03-29.txt =================================================================== --- trunk/src/doc/reunions/reunion-2012-03-29.txt 2012-03-29 10:29:50 UTC (rev 441) +++ trunk/src/doc/reunions/reunion-2012-03-29.txt 2012-03-29 11:58:18 UTC (rev 442) @@ -10,6 +10,7 @@ - valider tous les imports - lancer la phase de tests +- discuter des contraintes en base Référentiels ------------ @@ -32,6 +33,50 @@ J'ai renommé les colonne des datas dans Map (minuscule sur première lettre) et ageCategory ? oubli ou pas a utiliser (map import) +Création base embarquée +----------------------- + +Optimiser la gestion mémoire car y'a des soucis (import des associations) : + +Struts has detected an unhandled exception: +Messages: +Could not initialize class org.h2.message.DbException +File: org/h2/command/Command.java +Line number: 230 +Stacktraces +java.lang.reflect.InvocationTargetException + sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + java.lang.reflect.Method.invoke(Method.java:597) + com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) + com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) + org.apache.struts2.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:57) + java.lang.Thread.run(Thread.java:662) + +java.lang.NoClassDefFoundError: Could not initialize class org.h2.message.DbException + org.h2.command.Command.executeUpdate(Command.java:230) + org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:181) + org.nuiton.topia.framework.TopiaContextImpl$SQLWork.execute(TopiaContextImpl.java:1597) + org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) + org.nuiton.topia.framework.TopiaContextImpl.executeSQL(TopiaContextImpl.java:952) + fr.ifremer.echobase.services.ImportDbService.importAssociationfile(ImportDbService.java:316) + fr.ifremer.echobase.services.ImportDbService.importFile(ImportDbService.java:216) + fr.ifremer.echobase.services.ImportDbService.importDb(ImportDbService.java:125) + fr.ifremer.echobase.services.EmbeddedApplicationService.importDb(EmbeddedApplicationService.java:322) + fr.ifremer.echobase.services.EmbeddedApplicationService.createEmbeddedApplication(EmbeddedApplicationService.java:117) + fr.ifremer.echobase.ui.actions.embeddedApplication.Build.startAction(Build.java:66) + fr.ifremer.echobase.ui.actions.embeddedApplication.Build.startAction(Build.java:38) + fr.ifremer.echobase.ui.actions.AbstractWaitAndExecAction.execute(AbstractWaitAndExecAction.java:91) + sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + java.lang.reflect.Method.invoke(Method.java:597) + com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) + com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) + org.apache.struts2.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:57) + java.lang.Thread.run(Thread.java:662) + Suppression des résultats ------------------------- @@ -40,7 +85,8 @@ Modèle ------ -- Ajouter les clef naturels si possible +- Ajout des clef naturels +- Ajout des contrainte de non nullité Divers ------

1 0

r441 - in trunk/echobase-tools: . src/test/java/fr/ifremer/echobase/tools
by tchemit＠users.forge.codelutin.com 29 Mar '12

29 Mar '12

Author: tchemit Date: 2012-03-29 12:29:50 +0200 (Thu, 29 Mar 2012) New Revision: 441 Url: http://forge.codelutin.com/repositories/revision/echobase/441 Log: add at release time default datas to import in a new EchoBase application Modified: trunk/echobase-tools/pom.xml trunk/echobase-tools/src/test/java/fr/ifremer/echobase/tools/EchoBaseDbZipCreatorIT.java Modified: trunk/echobase-tools/pom.xml =================================================================== --- trunk/echobase-tools/pom.xml 2012-03-29 10:14:49 UTC (rev 440) +++ trunk/echobase-tools/pom.xml 2012-03-29 10:29:50 UTC (rev 441) @@ -1,6 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> -<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> +<project xmlns="http://maven.apache.org/POM/4.0.0" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> @@ -124,6 +126,12 @@ </dependencies> + <properties> + <redmine.releaseFiles> + ${basedir}/target/echobase-legacyDatas-${project.version}.zip + ${basedir}/target/echobase-referentiel-${project.version}.zip + </redmine.releaseFiles> + </properties> <build> <pluginManagement> <plugins> @@ -177,13 +185,22 @@ <profile> <id>db-to-zip</id> - + <activation> + <property> + <name>performRelease</name> + <value>true</value> + </property> + </activation> <build> <defaultGoal>test</defaultGoal> <plugins> <plugin> <artifactId>maven-surefire-plugin</artifactId> <configuration> + <environmentVariables> + <dbVersion>${project.version}</dbVersion> + <dbDestination>${basedir}/target</dbDestination> + </environmentVariables> <includes> <include>**/*EchoBaseDbZipCreatorIT.java</include> </includes> Modified: trunk/echobase-tools/src/test/java/fr/ifremer/echobase/tools/EchoBaseDbZipCreatorIT.java =================================================================== --- trunk/echobase-tools/src/test/java/fr/ifremer/echobase/tools/EchoBaseDbZipCreatorIT.java 2012-03-29 10:14:49 UTC (rev 440) +++ trunk/echobase-tools/src/test/java/fr/ifremer/echobase/tools/EchoBaseDbZipCreatorIT.java 2012-03-29 10:29:50 UTC (rev 441) @@ -23,11 +23,14 @@ */ package fr.ifremer.echobase.tools; +import org.apache.commons.io.FileUtils; import org.junit.Assert; +import org.junit.BeforeClass; import org.junit.Test; import org.nuiton.util.FileUtil; import java.io.File; +import java.io.IOException; import java.text.SimpleDateFormat; import java.util.Date; @@ -44,6 +47,20 @@ static final String date = new SimpleDateFormat("dd-MM-yyyy").format(new Date()); + static File dbDesFile; + + static String dbVersion; + + @BeforeClass + public static void beforeTest() throws IOException { + + String dbDestination = System.getenv("dbDestination"); + + dbVersion = System.getenv("dbVersion"); + dbDesFile = new File(dbDestination); + FileUtil.createDirectoryIfNecessary(dbDesFile); + } + @Test public void createEchoBaseLegacyDataDb() throws Exception { @@ -57,7 +74,7 @@ File dir = new File(exportdir, "echobase"); - File distributionFile = new File(exportdir, "echobase-legacyDatas-" + date + ".zip"); + File distributionFile = new File(exportdir, "echobase-legacyDatas-" + dbVersion + ".zip"); Assert.assertFalse(distributionFile.exists()); File sourceDir = TestHelper.getCsvResourceDirectory(); @@ -65,6 +82,8 @@ new EchoBaseDbCreator().createEchoBaseLegacyDataDb(sourceDir, dir, distributionFile); Assert.assertTrue(distributionFile.exists()); + + FileUtils.copyFileToDirectory(distributionFile, dbDesFile); } @Test @@ -80,7 +99,7 @@ File dir = new File(exportdir, "echobase"); - File distributionFile = new File(exportdir, "echobase-referentiel-" + date + ".zip"); + File distributionFile = new File(exportdir, "echobase-referentiel-" + dbVersion + ".zip"); Assert.assertFalse(distributionFile.exists()); File sourceDir = TestHelper.getCsvResourceDirectory(); @@ -88,6 +107,9 @@ new EchoBaseDbCreator().createEchoBaseReferentielDb(sourceDir, dir, distributionFile); Assert.assertTrue(distributionFile.exists()); + + FileUtils.copyFileToDirectory(distributionFile, dbDesFile); + }

1 0

r440 - in trunk: echobase-entities/src/main/java/fr/ifremer/echobase/entities echobase-entities/src/main/java/fr/ifremer/echobase/entities/meta echobase-entities/src/main/xmi echobase-services/src/main/java/fr/ifremer/echobase/services echobase-services/src/main/java/fr/ifremer/echobase/services/importdata echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv echobase-services/src/test/java/fr/ifremer/echobase/services/importdata echobase-services/src/test/resources
by tchemit＠users.forge.codelutin.com 29 Mar '12

29 Mar '12

Author: tchemit Date: 2012-03-29 12:14:49 +0200 (Thu, 29 Mar 2012) New Revision: 440 Url: http://forge.codelutin.com/repositories/revision/echobase/440 Log: fixes #1046 (Ajout de contrainte fortes sur la base) Added: trunk/echobase-entities/src/main/java/fr/ifremer/echobase/entities/EchoBaseUserDAOImpl.java Modified: trunk/echobase-entities/src/main/java/fr/ifremer/echobase/entities/meta/TableMeta.java trunk/echobase-entities/src/main/xmi/echobase.properties trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ImportDbService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/UserService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AbstractImportDataService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AcousticDataImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/CatchesDataImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/CommonDataImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsMapCellImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsVoyageImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/LengthWeightKeyImportModel.java trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/AbstractImportDataServiceIT.java trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportServiceIT.java trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportServiceIT.java trunk/echobase-services/src/test/resources/echobase-0.3-importDb-referentiel.zip trunk/echobase-services/src/test/resources/import-data/echobase-0.3-catches-and-voyage-result.h2.db.gz trunk/echobase-services/src/test/resources/import-data/echobase-0.3-catches.h2.db.gz trunk/echobase-services/src/test/resources/import-data/echobase-0.3-commonData.h2.db.gz trunk/echobase-services/src/test/resources/import-data/echobase-0.3-nodata.h2.db.gz trunk/echobase-services/src/test/resources/import-data/echobase-0.3-operation.h2.db.gz trunk/echobase-tools/src/main/java/fr/ifremer/echobase/tools/loaders/EntityLoader.java Added: trunk/echobase-entities/src/main/java/fr/ifremer/echobase/entities/EchoBaseUserDAOImpl.java =================================================================== --- trunk/echobase-entities/src/main/java/fr/ifremer/echobase/entities/EchoBaseUserDAOImpl.java (rev 0) +++ trunk/echobase-entities/src/main/java/fr/ifremer/echobase/entities/EchoBaseUserDAOImpl.java 2012-03-29 10:14:49 UTC (rev 440) @@ -0,0 +1,30 @@ +package fr.ifremer.echobase.entities; + +import org.nuiton.topia.TopiaException; +import org.nuiton.topia.framework.TopiaQuery; +import org.nuiton.util.PagerUtil; + +import java.util.List; + +public class EchoBaseUserDAOImpl<E extends EchoBaseUser> extends EchoBaseUserDAOAbstract<E> { + + public List<E> findAll(PagerUtil.PagerBean pager) throws TopiaException { + List<E> users; + + if (pager == null) { + + users = findAll(); + } else { + + // get user count + long count = count(); + pager.setRecords((int) count); + PagerUtil.computeRecordIndexesAndPagesNumber(pager); + + TopiaQuery query = createQuery("e"); + query.setLimit(pager.getRecordStartIndex(), pager.getRecordEndIndex() - 1); + users = findAllByQuery(query); + } + return users; + } +} //EchoBaseUserDAOImpl<E extends EchoBaseUser> Modified: trunk/echobase-entities/src/main/java/fr/ifremer/echobase/entities/meta/TableMeta.java =================================================================== --- trunk/echobase-entities/src/main/java/fr/ifremer/echobase/entities/meta/TableMeta.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-entities/src/main/java/fr/ifremer/echobase/entities/meta/TableMeta.java 2012-03-29 10:14:49 UTC (rev 440) @@ -44,6 +44,7 @@ import java.io.Writer; import java.util.Iterator; import java.util.List; +import java.util.Map; import java.util.Set; /** @@ -75,6 +76,11 @@ /** Binder used to copy entities (lazy loaded). */ protected Binder<TopiaEntity, TopiaEntity> binder; + /** Entity operator used in generic algorithms. */ + protected transient EntityOperator<TopiaEntity> operator; + + protected boolean useNaturalIdsOrNotNulls; + @Override public EchoBaseEntityEnum getSource() { return source; @@ -167,6 +173,15 @@ getBinder().copy(source, target); } + public Map<String, Object> prepareCreate(TopiaEntity bean, + String topiaId) { + Map<String, Object> result = getOperator().getNaturalIsdAndNotNulls(bean); + if (topiaId != null) { + result.put(TopiaEntity.TOPIA_ID, topiaId); + } + return result; + } + @Override public Iterator<ColumnMeta> iterator() { return getColumns().iterator(); @@ -241,6 +256,15 @@ } dependencies = deps.toArray(new EchoBaseEntityEnum[deps.size()]); + useNaturalIdsOrNotNulls = source.isUseNotNulls() || + source.isUseNaturalIds(); + } + public EntityOperator<TopiaEntity> getOperator() { + if (operator == null) { + operator = EchoBaseDAOHelper.getOperator( + (Class<TopiaEntity>) getEntityType()); + } + return operator; } } Modified: trunk/echobase-entities/src/main/xmi/echobase.properties =================================================================== --- trunk/echobase-entities/src/main/xmi/echobase.properties 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-entities/src/main/xmi/echobase.properties 2012-03-29 10:14:49 UTC (rev 440) @@ -32,7 +32,10 @@ model.tagValue.doNotGenerateBooleanGetMethods=true model.tagValue.indexForeignKeys=true -# ordered +############################################################################### +### Ordered attributes ######################################################## +############################################################################### + fr.ifremer.echobase.entities.data.Voyage.attribute.transit.stereotype=ordered fr.ifremer.echobase.entities.data.Voyage.attribute.transit.tagvalue.orderBy=startTime fr.ifremer.echobase.entities.data.Transit.attribute.transect.stereotype=ordered @@ -40,10 +43,273 @@ fr.ifremer.echobase.entities.data.Transect.attribute.operation.stereotype=ordered fr.ifremer.echobase.entities.data.Transect.attribute.operation.tagvalue.orderBy=gearShootingStartTime -#unique +############################################################################### +### Unique attributes ######################################################### +############################################################################### + fr.ifremer.echobase.entities.data.Voyage.attribute.echotype.stereotype=unique -# big text zone +############################################################################### +### Big Text attributes ####################################################### +############################################################################### + fr.ifremer.echobase.entities.EntityModificationLog.attribute.modificationText.tagvalue.type=text fr.ifremer.echobase.entities.ExportQuery.attribute.sqlQuery.tagvalue.type=text +############################################################################### +### Natural id for references ################################################ +############################################################################### + +fr.ifremer.echobase.entities.EchoBaseUser.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.EchoBaseUser.attribute.email.tagValue.naturalId=true +fr.ifremer.echobase.entities.EchoBaseUser.attribute.email.tagValue.notNull=true +fr.ifremer.echobase.entities.EchoBaseUser.attribute.password.tagValue.notNull=true + +fr.ifremer.echobase.entities.EntityModificationLog.attribute.entityType.tagValue.notNull=true +fr.ifremer.echobase.entities.EntityModificationLog.attribute.entityId.tagValue.notNull=true +fr.ifremer.echobase.entities.EntityModificationLog.attribute.modificationText.tagValue.notNull=true +fr.ifremer.echobase.entities.EntityModificationLog.attribute.modificationDate.tagValue.notNull=true +fr.ifremer.echobase.entities.EntityModificationLog.attribute.modificationUser.tagValue.notNull=true + +fr.ifremer.echobase.entities.ExportQuery.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.ExportQuery.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.ExportQuery.attribute.description.tagValue.notNull=true +fr.ifremer.echobase.entities.ExportQuery.attribute.sqlQuery.tagValue.notNull=true +fr.ifremer.echobase.entities.ExportQuery.attribute.lastModifiedDate.tagValue.notNull=true +fr.ifremer.echobase.entities.ExportQuery.attribute.lastModifiedUser.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.AcousticInstrument.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.AcousticInstrument.attribute.id.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.AcousticInstrument.attribute.id.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.AgeCategory.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.AgeCategory.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.AgeCategory.attribute.name.tagValue.notNull=true +fr.ifremer.echobase.entities.references.AgeCategory.attribute.meaning.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.AreaOfOperation.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.AreaOfOperation.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.AreaOfOperation.attribute.name.tagValue.notNull=true + +#fr.ifremer.echobase.entities.references.Calibration.class.tagValue.naturalIdMutable=false +#fr.ifremer.echobase.entities.references.Calibration.attribute.code.tagValue.naturalId=true + +fr.ifremer.echobase.entities.references.CategoryMeaning.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.CategoryMeaning.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.CategoryMeaning.attribute.name.tagValue.notNull=true + +#fr.ifremer.echobase.entities.references.CategoryRef.class.tagValue.naturalIdMutable=false +#fr.ifremer.echobase.entities.references.CategoryRef.attribute.code.tagValue.naturalId=true + +fr.ifremer.echobase.entities.references.CategoryType.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.CategoryType.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.CategoryType.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.CellMethod.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.CellMethod.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.CellMethod.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.CellType.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.CellType.attribute.id.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.CellType.attribute.id.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.DataMetadata.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.DataMetadata.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.DataMetadata.attribute.name.tagValue.notNull=true + +#fr.ifremer.echobase.entities.references.DataProtocol.class.tagValue.naturalIdMutable=false +#fr.ifremer.echobase.entities.references.DataProtocol.attribute.code.tagValue.naturalId=true + +#fr.ifremer.echobase.entities.references.DataQuality.class.tagValue.naturalIdMutable=false +#fr.ifremer.echobase.entities.references.DataQuality.attribute.code.tagValue.naturalId=true + +fr.ifremer.echobase.entities.references.DataType.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.DataType.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.DataType.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.DepthStratum.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.DepthStratum.attribute.id.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.DepthStratum.attribute.id.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.EchotypeCategory.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.EchotypeCategory.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.EchotypeCategory.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.Gear.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.Gear.attribute.casinoGearName.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.Gear.attribute.casinoGearName.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.GearCharacteristic.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.GearCharacteristic.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.GearCharacteristic.attribute.name.tagValue.notNull=true + +#fr.ifremer.echobase.entities.references.GearCharacteristicValue.class.tagValue.naturalIdMutable=false +#fr.ifremer.echobase.entities.references.GearCharacteristicValue.attribute.code.tagValue.naturalId=true + +fr.ifremer.echobase.entities.references.GearMetadata.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.GearMetadata.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.GearMetadata.attribute.name.tagValue.notNull=true + +#fr.ifremer.echobase.entities.references.Impacte.class.tagValue.naturalIdMutable=false +#fr.ifremer.echobase.entities.references.Impacte.attribute.code.tagValue.naturalId=true + +fr.ifremer.echobase.entities.references.MeasurementMetadata.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.MeasurementMetadata.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.MeasurementMetadata.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.MeasureType.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.MeasureType.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.MeasureType.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.Mission.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.Mission.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.Mission.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.OperationEvent.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.OperationEvent.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.OperationEvent.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.OperationMetadata.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.OperationMetadata.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.OperationMetadata.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.ReferenceDatum.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.ReferenceDatum.attribute.id.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.ReferenceDatum.attribute.id.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.ReferenceDatumType.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.ReferenceDatumType.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.ReferenceDatumType.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.ReferencingMethod.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.ReferencingMethod.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.ReferencingMethod.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.SampleDataType.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.SampleDataType.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.SampleDataType.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.SampleType.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.SampleType.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.SampleType.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.SexCategory.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.SexCategory.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.SexCategory.attribute.name.tagValue.notNull=true +fr.ifremer.echobase.entities.references.SexCategory.attribute.meaning.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.SizeCategory.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.SizeCategory.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.SizeCategory.attribute.name.tagValue.notNull=true +fr.ifremer.echobase.entities.references.SizeCategory.attribute.meaning.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.Species.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.Species.attribute.baracoudaCode.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.Species.attribute.baracoudaCode.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.SpeciesCategory.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.SpeciesCategory.attribute.species.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.SpeciesCategory.attribute.sizeCategory.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.SpeciesCategory.attribute.ageCategory.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.SpeciesCategory.attribute.sexCategory.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.SpeciesCategory.attribute.species.tagValue.notNull=true +fr.ifremer.echobase.entities.references.SpeciesCategory.attribute.sizeCategory.tagValue.notNull=false +fr.ifremer.echobase.entities.references.SpeciesCategory.attribute.ageCategory.tagValue.notNull=false +fr.ifremer.echobase.entities.references.SpeciesCategory.attribute.sexCategory.tagValue.notNull=false + +fr.ifremer.echobase.entities.references.Strata.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.Strata.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.Strata.attribute.name.tagValue.notNull=true + +#fr.ifremer.echobase.entities.references.TSParameters.class.tagValue.naturalIdMutable=false +#fr.ifremer.echobase.entities.references.TSParameters.attribute.code.tagValue.naturalId=true + +fr.ifremer.echobase.entities.references.Vessel.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.Vessel.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.Vessel.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.references.VesselType.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.references.VesselType.attribute.name.tagValue.naturalId=true +fr.ifremer.echobase.entities.references.VesselType.attribute.name.tagValue.notNull=true + +############################################################################### +### Natural id for data ###################################################### +############################################################################### + +fr.ifremer.echobase.entities.data.Category.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.data.Category.attribute.depthStratum.tagValue.naturalId=true +fr.ifremer.echobase.entities.data.Category.attribute.echotype.tagValue.naturalId=true +fr.ifremer.echobase.entities.data.Category.attribute.speciesCategory.tagValue.naturalId=true +fr.ifremer.echobase.entities.data.Category.attribute.depthStratum.tagValue.notNull=false +fr.ifremer.echobase.entities.data.Category.attribute.echotype.tagValue.notNull=false +fr.ifremer.echobase.entities.data.Category.attribute.speciesCategory.tagValue.notNull=false + +fr.ifremer.echobase.entities.data.Cell.attribute.cellType.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Cell.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.Data.attribute.dataValue.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Data.attribute.dataMetadata.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.DataAcquisition.attribute.acousticInstrument.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.DataProcessing.attribute.id.tagValue.notNull=true +fr.ifremer.echobase.entities.data.DataProcessing.attribute.processingTemplate.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.Echotype.attribute.name.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.GearMetadataValue.attribute.gearMetadata.tagValue.notNull=true +fr.ifremer.echobase.entities.data.GearMetadataValue.attribute.gear.tagValue.notNull=true +fr.ifremer.echobase.entities.data.GearMetadataValue.attribute.dataValue.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.LengthAgeKey.attribute.age.tagValue.notNull=true +fr.ifremer.echobase.entities.data.LengthAgeKey.attribute.length.tagValue.notNull=true +fr.ifremer.echobase.entities.data.LengthAgeKey.attribute.metadata.tagValue.notNull=true +fr.ifremer.echobase.entities.data.LengthAgeKey.attribute.species.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.LengthWeightKey.attribute.AParameter.tagValue.notNull=true +fr.ifremer.echobase.entities.data.LengthWeightKey.attribute.BParameter.tagValue.notNull=true +fr.ifremer.echobase.entities.data.LengthWeightKey.attribute.metadata.tagValue.notNull=false +fr.ifremer.echobase.entities.data.LengthWeightKey.attribute.speciesCategory.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.Operation.attribute.id.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Operation.attribute.gear.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.OperationMetadataValue.attribute.operationMetadata.tagValue.notNull=true +fr.ifremer.echobase.entities.data.OperationMetadataValue.attribute.dataValue.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.Result.attribute.category.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Result.attribute.dataMetadata.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Result.attribute.resultLabel.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Result.attribute.resultValue.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.Sample.attribute.sampleType.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Sample.attribute.speciesCategory.tagValue.notNull=false +fr.ifremer.echobase.entities.data.Sample.attribute.sampleWeight.tagValue.notNull=false +fr.ifremer.echobase.entities.data.Sample.attribute.numberSampled.tagValue.notNull=false + +fr.ifremer.echobase.entities.data.SampleData.attribute.sampleDataType.tagValue.notNull=true +fr.ifremer.echobase.entities.data.SampleData.attribute.dataLabel.tagValue.notNull=false +fr.ifremer.echobase.entities.data.SampleData.attribute.dataValue.tagValue.notNull=true +fr.ifremer.echobase.entities.data.SampleData.attribute.dataProtocol.tagValue.notNull=false + +fr.ifremer.echobase.entities.data.Transect.attribute.title.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Transect.attribute.vessel.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Transect.attribute.stratum.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.Transit.attribute.startTime.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Transit.attribute.endTime.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Transit.attribute.startLocality.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Transit.attribute.endLocality.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Transit.attribute.description.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Transit.attribute.relatedActivity.tagValue.notNull=true + +fr.ifremer.echobase.entities.data.Voyage.class.tagValue.naturalIdMutable=false +fr.ifremer.echobase.entities.data.Voyage.attribute.name.tagValue.naturalId=false +fr.ifremer.echobase.entities.data.Voyage.attribute.name.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Voyage.attribute.startDate.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Voyage.attribute.endDate.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Voyage.attribute.startPort.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Voyage.attribute.endPort.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Voyage.attribute.description.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Voyage.attribute.mission.tagValue.notNull=true +fr.ifremer.echobase.entities.data.Voyage.attribute.datum.tagValue.notNull=true Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -359,7 +359,12 @@ if (create) { - entityToSave = dao.create(); + // get naturalIds or not-null properties + Map<String, Object> properties = + tableMeta.prepareCreate(entity, null); + + entityToSave = dao.create(properties); + // push back topiaId (could be used by caller) entity.setTopiaId(entityToSave.getTopiaId()); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ImportDbService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ImportDbService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ImportDbService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -246,10 +246,12 @@ CsvImportResult csvResult) throws TopiaException { TopiaDAO<TopiaEntity> dao = getDAO(meta.getSource()); + for (TopiaEntity entity : importer) { - TopiaEntity entityToSave = dao.create(TopiaEntity.TOPIA_ID, - entity.getTopiaId()); + Map<String, Object> properties = meta.prepareCreate( + entity, entity.getTopiaId()); + TopiaEntity entityToSave = dao.create(properties); meta.copy(entity, entityToSave); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/UserService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/UserService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/UserService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -30,7 +30,6 @@ import fr.ifremer.echobase.entities.EchoBaseUserImpl; import org.apache.commons.lang3.StringUtils; import org.nuiton.topia.TopiaException; -import org.nuiton.topia.framework.TopiaQuery; import org.nuiton.util.PagerUtil; import org.nuiton.util.StringUtil; @@ -56,22 +55,8 @@ public List<EchoBaseUser> getUsers(PagerUtil.PagerBean pager) { try { - List<EchoBaseUser> users; - - EchoBaseUserDAO dao = getDAO(); - if (pager == null) { - - users = dao.findAll(); - } else { - - // get user count - long count = dao.count(); - pager.setRecords((int) count); - PagerUtil.computeRecordIndexesAndPagesNumber(pager); - TopiaQuery query = dao.createQuery("e"); - query.setLimit(pager.getRecordStartIndex(), pager.getRecordEndIndex() - 1); - users = dao.findAllByQuery(query); - } + EchoBaseUserDAO dao = getDAO(EchoBaseUser.class, EchoBaseUserDAO.class); + List<EchoBaseUser> users = dao.findAll(pager); return users; } catch (TopiaException eee) { throw new EchoBaseTechnicalException(eee); @@ -81,7 +66,8 @@ public EchoBaseUser getUserByEmail(String email) { Preconditions.checkNotNull(email); try { - EchoBaseUser user = getDAO().findByEmail(email); + EchoBaseUserDAO dao = getDAO(EchoBaseUser.class, EchoBaseUserDAO.class); + EchoBaseUser user = dao.findByEmail(email); return user; } catch (TopiaException eee) { throw new EchoBaseTechnicalException(eee); @@ -90,24 +76,29 @@ public void createOrUpdate(EchoBaseUser user) { try { - EchoBaseUserDAO dao = getDAO(); + EchoBaseUserDAO dao = getDAO(EchoBaseUser.class, EchoBaseUserDAO.class); EchoBaseUser userToCreateOrUpdate; // No id, creating new one entity String id = user.getTopiaId(); + String password = user.getPassword(); if (StringUtils.isEmpty(id)) { - userToCreateOrUpdate = dao.create(); + userToCreateOrUpdate = dao.create( + EchoBaseUser.PROPERTY_EMAIL, user.getEmail(), + EchoBaseUser.PROPERTY_PASSWORD, encodePassword(password) + + ); } else { - userToCreateOrUpdate = dao.findByTopiaId(id); + userToCreateOrUpdate = getEntityById(EchoBaseUser.class, id); + + userToCreateOrUpdate.setEmail(user.getEmail()); + if (StringUtils.isNotEmpty(password)) { + userToCreateOrUpdate.setPassword(encodePassword(password)); + } } userToCreateOrUpdate.setAdmin(user.isAdmin()); - userToCreateOrUpdate.setEmail(user.getEmail()); - String password = user.getPassword(); - if (StringUtils.isNotEmpty(password)) { - userToCreateOrUpdate.setPassword(encodePassword(password)); - } - dao.update(userToCreateOrUpdate); +// dao.update(userToCreateOrUpdate); commitTransaction("Could not create or update user"); } catch (TopiaException eee) { throw new EchoBaseTechnicalException(eee); @@ -116,9 +107,9 @@ public void delete(EchoBaseUser user) { try { - EchoBaseUserDAO dao = getDAO(); - EchoBaseUser userToDelete = dao.findByTopiaId(user.getTopiaId()); - dao.delete(userToDelete); + EchoBaseUser userToDelete = getEntityById(EchoBaseUser.class, + user.getTopiaId()); + getDAO(EchoBaseUser.class).delete(userToDelete); commitTransaction("Could not delete user"); } catch (TopiaException eee) { throw new EchoBaseTechnicalException(eee); @@ -152,10 +143,6 @@ return encodedPassword; } - protected EchoBaseUserDAO getDAO() throws TopiaException { - return (EchoBaseUserDAO) getDAO(EchoBaseUser.class); - } - public EchoBaseUser newUser() { return new EchoBaseUserImpl(); } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AbstractImportDataService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AbstractImportDataService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AbstractImportDataService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -257,10 +257,12 @@ // not found in db, create it - category = create(speciesCategoryDAO); - category.setSpecies(species); - category.setSizeCategory(sizeCategory); - category.setSexCategory(sexCategory); + category = create(speciesCategoryDAO, + SpeciesCategory.PROPERTY_SPECIES, species, + SpeciesCategory.PROPERTY_SIZE_CATEGORY, sizeCategory, + SpeciesCategory.PROPERTY_AGE_CATEGORY, ageCategory, + SpeciesCategory.PROPERTY_SEX_CATEGORY, sexCategory + ); importResult.incrementsNumberCreated(EchoBaseEntityEnum.SpeciesCategory); } @@ -289,7 +291,19 @@ null, importResult); - String key = speciesCategory.getTopiaId(); + Category category = getResultCategory(categoryDAO, + echotype, + speciesCategory, + importResult); + return category; + } + + protected Category getResultCategory(CategoryDAO categoryDAO, + Echotype echotype, + SpeciesCategory speciesCategory, + CsvFileImportResult importResult) { + + String key = speciesCategory == null ? "" : speciesCategory.getTopiaId(); key += "#" + (echotype == null ? "" : echotype.getName()); Category category = categories.get(key); @@ -307,9 +321,11 @@ if (category == null) { // not found in db, create it - category = create(categoryDAO); - category.setEchotype(echotype); - category.setSpeciesCategory(speciesCategory); + category = create( + categoryDAO, + Category.PROPERTY_ECHOTYPE, echotype, + Category.PROPERTY_SPECIES_CATEGORY, speciesCategory + ); importResult.incrementsNumberCreated(EchoBaseEntityEnum.Category); } @@ -357,9 +373,9 @@ String dataValue, CsvFileImportResult importResult) { - Data data = create(dao); - data.setDataMetadata(dataMetaData); - data.setDataValue(dataValue); + Data data = create(dao, + Data.PROPERTY_DATA_METADATA, dataMetaData, + Data.PROPERTY_DATA_VALUE, dataValue); cell.addData(data); importResult.incrementsNumberCreated(EchoBaseEntityEnum.Data); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AcousticDataImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AcousticDataImportService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AcousticDataImportService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -210,7 +210,8 @@ // compute once for all the common dataprocessing id used // for hole the movies file - dataProcessingId = row.getEiLayer() + configuration.getProcessingTemplate(); + dataProcessingId = row.getEiLayer() + + configuration.getProcessingTemplate(); } Date startDate = row.getCellDateStart(); @@ -582,10 +583,13 @@ String loggedDataDatatype = configuration.getLoggedDataDatatype(); String pingDutyCycle = configuration.getPingDutyCycle(); - DataAcquisition dataAcquisition = create(dataAcquisitionDAO); + DataAcquisition dataAcquisition = create( + dataAcquisitionDAO, + DataAcquisition.PROPERTY_ACOUSTIC_INSTRUMENT, instrument + ); // fill from manual configuration - dataAcquisition.setAcousticInstrument(instrument); +// dataAcquisition.setAcousticInstrument(instrument); dataAcquisition.setTransceiverAcquisitionAbsorptionDescription(transceiverAcquisitionAbsorptionDescription); dataAcquisition.setAcquisitionSoftwareVersion(softwareVersion); dataAcquisition.setLoggedDataFormat(loggedDataFormat); @@ -640,11 +644,15 @@ String acousticDensityUnit = configuration.getAcousticDensityUnit(); String notes = configuration.getNotes(); - DataProcessing dataProcessing = create(dataProcessingDAO); + DataProcessing dataProcessing = create( + dataProcessingDAO, + DataProcessing.PROPERTY_ID, id, + DataProcessing.PROPERTY_PROCESSING_TEMPLATE, processingTemplate + ); // fill from manual configuration - dataProcessing.setId(id); - dataProcessing.setProcessingTemplate(processingTemplate); +// dataProcessing.setId(id); +// dataProcessing.setProcessingTemplate(processingTemplate); dataProcessing.setProcessingDescription(processingDescription); dataProcessing.setSounderConstant(sounderConstant); dataProcessing.setDigitThreshold(digitThreshold); @@ -690,14 +698,24 @@ String metadataName, String dataValue, CsvFileImportResult importResult) { + createCellData( + dao, + cell, + dataMetadatasByName.get(metadataName), + dataValue, + importResult + ); - DataMetadata dataMetaData = dataMetadatasByName.get(metadataName); - Data data = create(dao); - data.setDataMetadata(dataMetaData); - data.setDataValue(dataValue); - cell.addData(data); +// DataMetadata dataMetaData = dataMetadatasByName.get(metadataName); +// Data data = create(dao, +// Data.PROPERTY_DATA_METADATA, dataMetaData, +// Data.PROPERTY_DATA_VALUE, dataValue +// ); +// data.setDataMetadata(dataMetaData); +// data.setDataValue(dataValue); +// cell.addData(data); - importResult.incrementsNumberCreated(EchoBaseEntityEnum.Data); +// importResult.incrementsNumberCreated(EchoBaseEntityEnum.Data); } private String getSoftwareVersion(AcousticDataImportConfiguration configuration, Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/CatchesDataImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/CatchesDataImportService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/CatchesDataImportService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -244,7 +244,6 @@ sample = row.getSample(); sample.setSpeciesCategory(category); - sample.setSampleType(sampleType); sample = addSample(sampleDAO, @@ -311,11 +310,12 @@ } } - private CsvFileImportResult importSubSampleFile(CatchesDataImportConfiguration configuration, - InputFile inputFile, - Map<String, Operation> operationMap, - Map<String, Species> speciesMap, - Map<String, SizeCategory> sizeCategoryMap + private CsvFileImportResult importSubSampleFile( + CatchesDataImportConfiguration configuration, + InputFile inputFile, + Map<String, Operation> operationMap, + Map<String, Species> speciesMap, + Map<String, SizeCategory> sizeCategoryMap ) throws ImportException { if (log.isInfoEnabled()) { @@ -331,11 +331,12 @@ CsvFileImportResult importResult = new CsvFileImportResult( inputFile.getFileName()); - SubSampleImportModel csvModel = new SubSampleImportModel(getCsvSeparator(), - operationMap, - speciesMap, - sizeCategoryMap, - sexCategoryMap); + SubSampleImportModel csvModel = new SubSampleImportModel( + getCsvSeparator(), + operationMap, + speciesMap, + sizeCategoryMap, + sexCategoryMap); SampleDAO sampleDAO = getDAO(Sample.class, SampleDAO.class); SampleDataDAO sampleDataDAO = getDAO(SampleData.class, SampleDataDAO.class); @@ -421,10 +422,11 @@ } } - private CsvFileImportResult importBiometrySampleFile(CatchesDataImportConfiguration configuration, - InputFile inputFile, - Map<String, Operation> operationMap, - Map<String, Species> speciesMap + private CsvFileImportResult importBiometrySampleFile( + CatchesDataImportConfiguration configuration, + InputFile inputFile, + Map<String, Operation> operationMap, + Map<String, Species> speciesMap ) throws ImportException { if (log.isInfoEnabled()) { @@ -533,10 +535,16 @@ float value, Sample sample, CsvFileImportResult importResult) { - SampleData sampleData = create(dao); - sampleData.setSampleDataType(sampleDataType); - sampleData.setDataValue(value); - sampleData.setDataLabel(label); + SampleData sampleData = create( + dao, + SampleData.PROPERTY_SAMPLE_DATA_TYPE, sampleDataType, + SampleData.PROPERTY_DATA_VALUE, value, + SampleData.PROPERTY_DATA_LABEL, label + + ); +// sampleData.setSampleDataType(sampleDataType); +// sampleData.setDataValue(value); +// sampleData.setDataLabel(label); sample.addSampleData(sampleData); importResult.incrementsNumberCreated(EchoBaseEntityEnum.SampleData); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/CommonDataImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/CommonDataImportService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/CommonDataImportService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -165,8 +165,7 @@ VoyageDAO dao = getDAO(Voyage.class, VoyageDAO.class); - ImportModel<Voyage> csvModel = - new VoyageImportModel(getCsvSeparator()); + ImportModel<Voyage> csvModel = new VoyageImportModel(getCsvSeparator()); Voyage newVoyage = null; Locale locale = getLocale(); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -250,11 +250,8 @@ Cell cell = row.getCell(); Category category = getResultCategory(categoryDAO, - speciesCategoryDAO, row.getEchotype(), null, - null, - null, importResult); if (rowNumber % 100 == 0) { @@ -466,9 +463,11 @@ if (sizeCategory == null) { // create a new sizeCategory - sizeCategory = create(sizeCategoryDAO); - sizeCategory.setName(sizeCategoryName); - sizeCategory.setMeaning(row.getSizeCategoryMeaning()); + sizeCategory = create( + sizeCategoryDAO, + SizeCategory.PROPERTY_NAME, sizeCategoryName, + SizeCategory.PROPERTY_MEANING, row.getSizeCategoryMeaning() + ); importResult.incrementsNumberCreated( EchoBaseEntityEnum.SizeCategory); if (log.isInfoEnabled()) { @@ -503,9 +502,7 @@ result.setResultLabel(resultLabel); Result resultCreated = create(dao, result); - cell.addResult(resultCreated); - importResult.incrementsNumberCreated(EchoBaseEntityEnum.Result); } } @@ -546,14 +543,12 @@ header); CellDAO cellDAO = (CellDAO) getDAO(Cell.class); - SpeciesCategoryDAO speciesCategoryDAO = getDAO(SpeciesCategory.class, SpeciesCategoryDAO.class); - AgeCategoryDAO ageCategoryDAO = getDAO(AgeCategory.class, AgeCategoryDAO.class); + CategoryDAO categoryDAO = (CategoryDAO) getDAO(Category.class); - EsduResultBySpeciesAndAgeCategoryImportModel csvModel = new EsduResultBySpeciesAndAgeCategoryImportModel( serviceContext.getConfiguration().getCsvSeparator(), speciesMap, @@ -561,7 +556,6 @@ cellDAO, metas); - CategoryDAO categoryDAO = (CategoryDAO) getDAO(Category.class); DecoratorService decoratorService = getService(DecoratorService.class); Decorator<Category> categoryDecorator = decoratorService.getDecorator(getLocale(), Category.class, null); @@ -591,9 +585,11 @@ if (ageCategory == null) { // create a new sizeCategory - ageCategory = create(ageCategoryDAO); - ageCategory.setName(row.getAgeCategory()); - ageCategory.setMeaning(row.getAgeCategoryMeaning()); + ageCategory = create( + ageCategoryDAO, + AgeCategory.PROPERTY_NAME, ageCategoryName, + AgeCategory.PROPERTY_MEANING, row.getAgeCategoryMeaning() + ); importResult.incrementsNumberCreated( EchoBaseEntityEnum.AgeCategory); if (log.isInfoEnabled()) { @@ -628,9 +624,7 @@ result.setResultLabel(resultLabel); Result resultCreated = create(dao, result); - cell.addResult(resultCreated); - importResult.incrementsNumberCreated(EchoBaseEntityEnum.Result); } } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsMapCellImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsMapCellImportService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsMapCellImportService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -87,8 +87,9 @@ configuration.getVoyageId()); InputFile inputFile = configuration.getMapsFile(); - CsvFileImportResult importResult = importMapFile( - configuration, inputFile, voyage); + CsvFileImportResult importResult = importMapFile(configuration, + inputFile, + voyage); List<CsvFileImportResult> result = Lists.newLinkedList(); addResultAndLog(result, inputFile, importResult, user); @@ -147,7 +148,6 @@ String[] header = EchoBaseImport.getHeader(inputFile.getFile(), getCsvSeparator()); - List<DataMetadata> metas = getMetas( MapCellImportModel.COLUMN_NAMES_TO_EXCLUDE, dataMetadataMap, @@ -170,12 +170,10 @@ inputFile.getFileName()); CellDAO dao = getDAO(Cell.class, CellDAO.class); - DataDAO dataDao = getDAO(Data.class, DataDAO.class); ResultDAO resultDao = getDAO(Result.class, ResultDAO.class); SpeciesCategoryDAO speciesCategoryDAO = getDAO(SpeciesCategory.class, SpeciesCategoryDAO.class); - CategoryDAO categoryDAO = getDAO(Category.class, CategoryDAO.class); Reader reader = getInputFileReader(inputFile); @@ -190,11 +188,9 @@ configuration.incrementsProgression(); Cell cell = create(dao, row.getCell()); - voyage.addPostCell(cell); importResult.incrementsNumberCreated(EchoBaseEntityEnum.Cell); - // add gridCellLongitude data createCellData(dataDao, cell, @@ -259,9 +255,7 @@ result.setResultLabel(resultLabel); Result resultCreated = create(resultDao, result); - cell.addResult(resultCreated); - importResult.incrementsNumberCreated(EchoBaseEntityEnum.Result); } } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -177,10 +177,12 @@ if (cell == null || !row.getName().equals(cell.getName())) { - cell = create(dao); - - cell.setName(row.getName()); - cell.setCellType(row.getCellType()); + cell = create(dao, + Cell.PROPERTY_CELL_TYPE, row.getCellType(), + Cell.PROPERTY_NAME, row.getName() + ); +// cell.setName(row.getName()); +// cell.setCellType(row.getCellType()); voyage.addPostCell(cell); importResult.incrementsNumberCreated(EchoBaseEntityEnum.Cell); @@ -210,9 +212,10 @@ } } - protected CsvFileImportResult importRegionAssociationFile(ResultsImportConfiguration configuration, - InputFile inputFile, - Voyage voyage) throws ImportException { + protected CsvFileImportResult importRegionAssociationFile( + ResultsImportConfiguration configuration, + InputFile inputFile, + Voyage voyage) throws ImportException { if (log.isInfoEnabled()) { log.info("Starts import of Region cells association from file " + @@ -272,9 +275,10 @@ } } - protected CsvFileImportResult importRegionResultFile(ResultsImportConfiguration configuration, - InputFile inputFile, - Voyage voyage) throws ImportException { + protected CsvFileImportResult importRegionResultFile( + ResultsImportConfiguration configuration, + InputFile inputFile, + Voyage voyage) throws ImportException { if (log.isInfoEnabled()) { log.info("Starts import of Map cell results from file " + @@ -329,9 +333,7 @@ SpeciesCategoryDAO speciesCategoryDAO = getDAO(SpeciesCategory.class, SpeciesCategoryDAO.class); - CategoryDAO categoryDAO = getDAO(Category.class, CategoryDAO.class); - ResultDAO dao = getDAO(Result.class, ResultDAO.class); Reader reader = getInputFileReader(inputFile); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsVoyageImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsVoyageImportService.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsVoyageImportService.java 2012-03-29 10:14:49 UTC (rev 440) @@ -183,29 +183,24 @@ configuration.incrementsProgression(); Voyage voyage = row.getVoyage(); - LengthWeightKey lengthWeightKeyToCreate = - row.getLengthWeightKey(); - LengthWeightKey lengthWeightKey = create( - dao, lengthWeightKeyToCreate); - - //TODO should we import it ? - //lengthWeightKey.setMetadata(row.getMetadata()); - - Species species = row.getSpecies(); - SizeCategory sizeCategory = row.getSizeCategory(); - // find speciesCategory SpeciesCategory speciesCategory = getSpeciesCategory( speciesCategoryDAO, - species, - sizeCategory, + row.getSpecies(), + row.getSizeCategory(), null, null, importResult ); - lengthWeightKey.setSpeciesCategory(speciesCategory); + LengthWeightKey toCreate = row.getLengthWeightKey(); + toCreate.setSpeciesCategory(speciesCategory); + LengthWeightKey lengthWeightKey = create(dao, toCreate); + + //TODO should we import it ? + //lengthWeightKey.setMetadata(row.getMetadata()); + // attach it to voyage voyage.addLengthWeightKey(lengthWeightKey); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/LengthWeightKeyImportModel.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/LengthWeightKeyImportModel.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/LengthWeightKeyImportModel.java 2012-03-29 10:14:49 UTC (rev 440) @@ -50,7 +50,7 @@ newForeignKeyColumn(LengthWeightKeyImportRow.PROPERTY_VOYAGE, Voyage.class, Voyage.PROPERTY_NAME, voyageMap); newForeignKeyColumn(LengthWeightKeyImportRow.PROPERTY_SIZE_CATEGORY, SizeCategory.class, SizeCategory.PROPERTY_NAME, sizeCategoryMap); - newForeignKeyColumn("baracoudacode", LengthWeightKeyImportRow.PROPERTY_SPECIES, Species.class, Species.PROPERTY_BARACOUDA_CODE, speciesMap); + newForeignKeyColumn("baracoudaCode", LengthWeightKeyImportRow.PROPERTY_SPECIES, Species.class, Species.PROPERTY_BARACOUDA_CODE, speciesMap); } @Override Modified: trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/AbstractImportDataServiceIT.java =================================================================== --- trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/AbstractImportDataServiceIT.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/AbstractImportDataServiceIT.java 2012-03-29 10:14:49 UTC (rev 440) @@ -23,6 +23,7 @@ */ package fr.ifremer.echobase.services.importdata; +import com.google.common.base.Preconditions; import com.google.common.collect.Collections2; import com.google.common.collect.Sets; import fr.ifremer.echobase.EchoBaseFunctions; @@ -31,6 +32,7 @@ import fr.ifremer.echobase.csv.AbstractImportModel; import fr.ifremer.echobase.csv.CsvFileImportResult; import fr.ifremer.echobase.csv.EchoBaseImport; +import fr.ifremer.echobase.entities.EchoBaseEntityEnum; import fr.ifremer.echobase.entities.EchoBaseUser; import fr.ifremer.echobase.entities.data.Cell; import fr.ifremer.echobase.entities.data.CellDAO; @@ -48,6 +50,7 @@ import fr.ifremer.echobase.entities.data.Transect; import fr.ifremer.echobase.entities.data.Transit; import fr.ifremer.echobase.entities.data.Voyage; +import fr.ifremer.echobase.entities.references.CellType; import fr.ifremer.echobase.services.EchoBaseTestServiceSupport; import fr.ifremer.echobase.services.ImportException; import org.apache.commons.logging.Log; @@ -243,7 +246,10 @@ if (transect.isDataAcquisitionEmpty()) { // create a fake dataAcquisition - dataAcquisition = create(getDAO(DataAcquisition.class)); + dataAcquisition = create( + getDAO(DataAcquisition.class), + DataAcquisition.PROPERTY_ACOUSTIC_INSTRUMENT, + getEntities(EchoBaseEntityEnum.AcousticInstrument).get(0)); transect.addDataAcquisition(dataAcquisition); } else { dataAcquisition = transect.getDataAcquisition().iterator().next(); @@ -252,7 +258,11 @@ if (dataAcquisition.isDataProcessingEmpty()) { // creates a fake dataProcessing - dataProcessing = create(getDAO(DataProcessing.class)); + dataProcessing = create( + getDAO(DataProcessing.class), + DataProcessing.PROPERTY_ID, "id", + DataProcessing.PROPERTY_PROCESSING_TEMPLATE, "pt" + ); dataAcquisition.addDataProcessing(dataProcessing); } else { dataProcessing = dataAcquisition.getDataProcessing().iterator().next(); @@ -274,6 +284,10 @@ esduColumnName, inputFile.getFile()); + CellType esduCellType = getEntityByProperty( + CellType.class, CellType.PROPERTY_ID, "Esdu"); + Preconditions.checkNotNull(esduCellType); + Reader reader = service.getInputFileReader(inputFile); try { EchoBaseImport<ResultEdsuImportMockImportModelRow> importer = @@ -290,7 +304,9 @@ esduCellId); } - Cell cell = dao.create(Cell.PROPERTY_NAME, esduCellId); + Cell cell = create(dao, + Cell.PROPERTY_NAME, esduCellId, + Cell.PROPERTY_CELL_TYPE, esduCellType); dataProcessing.addCell(cell); cellsNames.add(esduCellId); } Modified: trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportServiceIT.java =================================================================== --- trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportServiceIT.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportServiceIT.java 2012-03-29 10:14:49 UTC (rev 440) @@ -79,7 +79,6 @@ assertCsvImportResult(result, 0, Result.class, 43533); assertCsvImportResult(result, 0, Category.class, 7); - assertCsvImportResult(result, 0, SpeciesCategory.class, 1); } @Test @@ -139,7 +138,7 @@ assertCsvImportResult(result, 0, Result.class, 68108); assertCsvImportResult(result, 0, Category.class, 129); - assertCsvImportResult(result, 0, SpeciesCategory.class, 129); + assertCsvImportResult(result, 0, SpeciesCategory.class, 129, 0, 585); assertCsvImportResult(result, 0, SizeCategory.class, 62); } @@ -170,9 +169,9 @@ result = doImport(conf, ResultsEsduCellImportService.class, 1); assertCsvImportResult(result, 0, Result.class, 10021); - assertCsvImportResult(result, 0, AgeCategory.class, 10); + assertCsvImportResult(result, 0, AgeCategory.class, 6); assertCsvImportResult(result, 0, Category.class, 14); - assertCsvImportResult(result, 0, SpeciesCategory.class, 14, 0, 471); + assertCsvImportResult(result, 0, SpeciesCategory.class, 14, 0, 470); } Modified: trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportServiceIT.java =================================================================== --- trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportServiceIT.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-services/src/test/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportServiceIT.java 2012-03-29 10:14:49 UTC (rev 440) @@ -85,9 +85,9 @@ assertCsvImportResult(result, 0, Cell.class, 10, 0, 2083); assertCsvImportResult(result, 0, Data.class, 238); assertCsvImportResult(result, 1, Cell.class, 0, 4146, 2083); - assertCsvImportResult(result, 2, Result.class, 1873); + assertCsvImportResult(result, 2, Result.class, 2128); assertCsvImportResult(result, 2, Category.class, 27); - assertCsvImportResult(result, 2, SpeciesCategory.class, 1, 0, 458); + assertCsvImportResult(result, 2, SpeciesCategory.class, 1, 0, 457); } } \ No newline at end of file Modified: trunk/echobase-services/src/test/resources/echobase-0.3-importDb-referentiel.zip =================================================================== (Binary files differ) Modified: trunk/echobase-services/src/test/resources/import-data/echobase-0.3-catches-and-voyage-result.h2.db.gz =================================================================== (Binary files differ) Modified: trunk/echobase-services/src/test/resources/import-data/echobase-0.3-catches.h2.db.gz =================================================================== (Binary files differ) Modified: trunk/echobase-services/src/test/resources/import-data/echobase-0.3-commonData.h2.db.gz =================================================================== (Binary files differ) Modified: trunk/echobase-services/src/test/resources/import-data/echobase-0.3-nodata.h2.db.gz =================================================================== (Binary files differ) Modified: trunk/echobase-services/src/test/resources/import-data/echobase-0.3-operation.h2.db.gz =================================================================== (Binary files differ) Modified: trunk/echobase-tools/src/main/java/fr/ifremer/echobase/tools/loaders/EntityLoader.java =================================================================== --- trunk/echobase-tools/src/main/java/fr/ifremer/echobase/tools/loaders/EntityLoader.java 2012-03-29 10:00:37 UTC (rev 439) +++ trunk/echobase-tools/src/main/java/fr/ifremer/echobase/tools/loaders/EntityLoader.java 2012-03-29 10:14:49 UTC (rev 440) @@ -485,8 +485,9 @@ TopiaDAO<TopiaEntity> dao = getDAO(tableMeta.getSource()); for (TopiaEntity entity : importer) { - TopiaEntity entityToSave = dao.create(TopiaEntity.TOPIA_ID, - entity.getTopiaId()); + Map<String, Object> properties = meta.prepareCreate( + entity, entity.getTopiaId()); + TopiaEntity entityToSave = dao.create(properties); tableMeta.copy(entity, entityToSave);

1 0

r439 - trunk
by tchemit＠users.forge.codelutin.com 29 Mar '12

29 Mar '12

Author: tchemit Date: 2012-03-29 12:00:37 +0200 (Thu, 29 Mar 2012) New Revision: 439 Url: http://forge.codelutin.com/repositories/revision/echobase/439 Log: use topia 2.6.9 Modified: trunk/pom.xml Modified: trunk/pom.xml =================================================================== --- trunk/pom.xml 2012-03-28 18:26:53 UTC (rev 438) +++ trunk/pom.xml 2012-03-29 10:00:37 UTC (rev 439) @@ -126,7 +126,7 @@  <eugenePluginVersion>2.4.2</eugenePluginVersion> - <topiaVersion>2.6.8</topiaVersion> + <topiaVersion>2.6.9</topiaVersion> <nuitonUtilsVersion>2.4.6</nuitonUtilsVersion> <nuitonI18nVersion>2.4.1</nuitonI18nVersion> <nuitonWebVersion>1.10</nuitonWebVersion>

1 0

r438 - in trunk/echobase-tools: . src/test/java/fr/ifremer/echobase/tools
by tchemit＠users.forge.codelutin.com 28 Mar '12

28 Mar '12

Author: tchemit Date: 2012-03-28 20:26:53 +0200 (Wed, 28 Mar 2012) New Revision: 438 Url: http://forge.codelutin.com/repositories/revision/echobase/438 Log: use last version of legacy datas Modified: trunk/echobase-tools/pom.xml trunk/echobase-tools/src/test/java/fr/ifremer/echobase/tools/TestHelper.java Modified: trunk/echobase-tools/pom.xml =================================================================== --- trunk/echobase-tools/pom.xml 2012-03-28 18:09:06 UTC (rev 437) +++ trunk/echobase-tools/pom.xml 2012-03-28 18:26:53 UTC (rev 438) @@ -196,14 +196,14 @@ <profile> <activation> <file> - <exists>src/test/private/echobase-2012-03-20</exists> + <exists>src/test/private/echobase-2012-03-28</exists> </file> </activation> <id>echobase-csv-inputs</id> <build> <testResources> <testResource> - <directory>src/test/private/echobase-2012-03-20</directory> + <directory>src/test/private/echobase-2012-03-28</directory> <includes> <include>**/*.csv</include> </includes> Modified: trunk/echobase-tools/src/test/java/fr/ifremer/echobase/tools/TestHelper.java =================================================================== --- trunk/echobase-tools/src/test/java/fr/ifremer/echobase/tools/TestHelper.java 2012-03-28 18:09:06 UTC (rev 437) +++ trunk/echobase-tools/src/test/java/fr/ifremer/echobase/tools/TestHelper.java 2012-03-28 18:26:53 UTC (rev 438) @@ -57,7 +57,7 @@ protected static final long timestamp = System.currentTimeMillis(); /** La version du jeux de données utilisé. */ - public static final String ECHOBASE_CSV_VERSION = "2012-03-20"; + public static final String ECHOBASE_CSV_VERSION = "2012-03-28"; public static File getBasedir() { if (basedir == null) {

1 0

r437 - in trunk: echobase-entities/src/main/resources/i18n echobase-services/src/main/resources/i18n
by tchemit＠users.forge.codelutin.com 28 Mar '12

28 Mar '12

Author: tchemit Date: 2012-03-28 20:09:06 +0200 (Wed, 28 Mar 2012) New Revision: 437 Url: http://forge.codelutin.com/repositories/revision/echobase/437 Log: update i18n Modified: trunk/echobase-entities/src/main/resources/i18n/echobase-entities_en_GB.properties trunk/echobase-entities/src/main/resources/i18n/echobase-entities_fr_FR.properties trunk/echobase-services/src/main/resources/i18n/echobase-services_en_GB.properties trunk/echobase-services/src/main/resources/i18n/echobase-services_fr_FR.properties Modified: trunk/echobase-entities/src/main/resources/i18n/echobase-entities_en_GB.properties =================================================================== --- trunk/echobase-entities/src/main/resources/i18n/echobase-entities_en_GB.properties 2012-03-28 18:00:58 UTC (rev 436) +++ trunk/echobase-entities/src/main/resources/i18n/echobase-entities_en_GB.properties 2012-03-28 18:09:06 UTC (rev 437) @@ -74,7 +74,6 @@ echobase.common.echosounderSoundSpeed= echobase.common.echotype= echobase.common.echotypeCategory= -echobase.common.eiThreshold= echobase.common.email= echobase.common.endDate= echobase.common.endLocality= @@ -178,8 +177,6 @@ echobase.common.precision= echobase.common.principalInvestigator= echobase.common.principalInvestigatorEmail= -echobase.common.processedAge= -echobase.common.processedLength= echobase.common.processingDescription= echobase.common.processingMethod= echobase.common.processingSoftwareVersion= Modified: trunk/echobase-entities/src/main/resources/i18n/echobase-entities_fr_FR.properties =================================================================== --- trunk/echobase-entities/src/main/resources/i18n/echobase-entities_fr_FR.properties 2012-03-28 18:00:58 UTC (rev 436) +++ trunk/echobase-entities/src/main/resources/i18n/echobase-entities_fr_FR.properties 2012-03-28 18:09:06 UTC (rev 437) @@ -74,7 +74,6 @@ echobase.common.echosounderSoundSpeed= echobase.common.echotype= echobase.common.echotypeCategory= -echobase.common.eiThreshold= echobase.common.email=Courriel echobase.common.endDate= echobase.common.endLocality= @@ -178,8 +177,6 @@ echobase.common.precision= echobase.common.principalInvestigator=Chercheur echobase.common.principalInvestigatorEmail=Courriel du chercheur -echobase.common.processedAge= -echobase.common.processedLength= echobase.common.processingDescription= echobase.common.processingMethod= echobase.common.processingSoftwareVersion= Modified: trunk/echobase-services/src/main/resources/i18n/echobase-services_en_GB.properties =================================================================== --- trunk/echobase-services/src/main/resources/i18n/echobase-services_en_GB.properties 2012-03-28 18:00:58 UTC (rev 436) +++ trunk/echobase-services/src/main/resources/i18n/echobase-services_en_GB.properties 2012-03-28 18:09:06 UTC (rev 437) @@ -1,5 +1,4 @@ echobase.common.biometrySampleFile= -echobase.common.cellMapResultFile= echobase.common.cellMapsFile= echobase.common.cellPositionReference.end= echobase.common.cellPositionReference.mid= Modified: trunk/echobase-services/src/main/resources/i18n/echobase-services_fr_FR.properties =================================================================== --- trunk/echobase-services/src/main/resources/i18n/echobase-services_fr_FR.properties 2012-03-28 18:00:58 UTC (rev 436) +++ trunk/echobase-services/src/main/resources/i18n/echobase-services_fr_FR.properties 2012-03-28 18:09:06 UTC (rev 437) @@ -1,5 +1,4 @@ echobase.common.biometrySampleFile=Fichier BiometrySample -echobase.common.cellMapResultFile=Fichier de résultats de cellules Carte echobase.common.cellMapsFile=Fichier des cellules Cartes echobase.common.cellPositionReference.end=Fin echobase.common.cellPositionReference.mid=Milieu

1 0

r436 - trunk/echobase-ui/src/main/resources/i18n
by tchemit＠users.forge.codelutin.com 28 Mar '12

28 Mar '12

Author: tchemit Date: 2012-03-28 20:00:58 +0200 (Wed, 28 Mar 2012) New Revision: 436 Url: http://forge.codelutin.com/repositories/revision/echobase/436 Log: i18n revert Modified: trunk/echobase-ui/src/main/resources/i18n/echobase-ui_en_GB.properties trunk/echobase-ui/src/main/resources/i18n/echobase-ui_fr_FR.properties Modified: trunk/echobase-ui/src/main/resources/i18n/echobase-ui_en_GB.properties =================================================================== --- trunk/echobase-ui/src/main/resources/i18n/echobase-ui_en_GB.properties 2012-03-28 17:56:01 UTC (rev 435) +++ trunk/echobase-ui/src/main/resources/i18n/echobase-ui_en_GB.properties 2012-03-28 18:00:58 UTC (rev 436) @@ -36,7 +36,7 @@ echobase.error.warlocation.notFound=War not found at location %s echobase.info.import.failed=L'import a échoué. echobase.info.import.succeded= -echobase.info.new.sqlQuery.inprogress=\=New query creation in progress +echobase.info.new.sqlQuery.inprogress=New query creation in progress echobase.info.no.sqlQuery.saved= echobase.info.no.sqlQuery.selected= echobase.info.no.table.selected= @@ -47,7 +47,7 @@ echobase.info.user.update= echobase.information.mission.created= echobase.label.exportAsSeen=Export as seen on screen -echobase.legend.dbeditor.show=Visualisation de '%s' +echobase.legend.dbeditor.show=Detail of '%s' echobase.legend.importData.result.resume=Résultat echobase.legend.libreOfficeQuery=Requète "libre office" echobase.menu.editData=Modify datas Modified: trunk/echobase-ui/src/main/resources/i18n/echobase-ui_fr_FR.properties =================================================================== --- trunk/echobase-ui/src/main/resources/i18n/echobase-ui_fr_FR.properties 2012-03-28 17:56:01 UTC (rev 435) +++ trunk/echobase-ui/src/main/resources/i18n/echobase-ui_fr_FR.properties 2012-03-28 18:00:58 UTC (rev 436) @@ -1,25 +1,258 @@ -echobase.error.bad.password= -echobase.error.email.already.used= -echobase.error.invalid.sql= -echobase.error.login.unknown= -echobase.error.mission.name.already.exist= -echobase.error.no.embeddedApplication.configurationFound= -echobase.error.no.embeddedApplication.exportFileFound= -echobase.error.no.exportDb.configurationFound= -echobase.error.no.exportDb.exportFileFound= -echobase.error.query.name.already.exists= -echobase.error.required.email= -echobase.error.required.password= -echobase.error.warlocation.notFound= -echobase.info.import.failed= -echobase.info.import.succeded= -echobase.info.new.sqlQuery.inprogress= -echobase.info.no.sqlQuery.saved= -echobase.info.no.sqlQuery.selected= -echobase.info.no.table.selected= -echobase.info.no.voyagee.found= -echobase.info.sqlQuery.not.modifiable= -echobase.info.user.create= -echobase.info.user.delete= -echobase.info.user.update= -echobase.information.mission.created= +echobase.action.applySqlQuery=Appliquer la requête +echobase.action.backToUserList=Retour à la liste des utilisateurs +echobase.action.cancel=Annuler +echobase.action.cloneSqlQuery=Cloner +echobase.action.configureImport=Configurer l'import +echobase.action.create=Créer +echobase.action.createEmbeddedApplication=Créer l'application +echobase.action.createMission=Créer la mission +echobase.action.createNewMission=Créer une nouvelle mission +echobase.action.createSqlQuery=Enregistrer +echobase.action.delete=Suppression +echobase.action.deleteSqlQuery=Supprimer +echobase.action.downloadEmbeddedApplicationFile=Télécharger l'application embarquée +echobase.action.downloadExportDbFile=Télécharger le fichier d'export de la base complête +echobase.action.export=Exporter +echobase.action.exportSqlData=Exporter les données +echobase.action.exportTable=Exporter +echobase.action.generateSqlQuery=Générer la requète +echobase.action.import=Importer +echobase.action.importTable=Importer +echobase.action.locale.english=Anglais +echobase.action.locale.french=Français +echobase.action.login=Connection +echobase.action.logout=Déconnexion +echobase.action.newLibreOfficeQuery=Nouvelle requète Libre office +echobase.action.newQuery=Nouvelle requète +echobase.action.reloadSqlQuery=Recharger +echobase.action.reset=Annuler +echobase.action.return=Retour +echobase.action.save=Sauvegarder +echobase.action.saveSqlQuery=Mettre à jour +echobase.action.toEnglish=Utiliser la version anglaise +echobase.action.toFrench=Utiliser la version française +echobase.action.usingEnglish=Version anglaise utilisé +echobase.action.usingFrench=Version française utilisé +echobase.common.acousticDensityUnit=acousticDensityUnit +echobase.common.acquisitionSoftwareVersionER60=acquisitionSoftwareVersion (ER60 instrument) +echobase.common.acquisitionSoftwareVersionME70=acquisitionSoftwareVersion (ME70 instrument) +echobase.common.addDataAcquisition=Toujours créer des DataAcqusitions +echobase.common.admin=Administrateur +echobase.common.cellPositionReference=cellPositionReference +echobase.common.digitThreshold=digitThreshold +echobase.common.echosounderSoundSpeed=echosounderSoundSpeed +echobase.common.email=Email +echobase.common.entityType=Type d'entité +echobase.common.importDataMode=Type d'import +echobase.common.importError=Message d'erreur +echobase.common.importFileName=Nom du fichier importé +echobase.common.importMode=Type d'import +echobase.common.importResult=Résultat de l'import +echobase.common.inProgress=en cours... +echobase.common.jdbcLogin=Login de connexion +echobase.common.jdbcPassword=Mot de passe +echobase.common.jdbcUrl=Url de connexion +echobase.common.loggedDataDatatype=loggedDataDatatype +echobase.common.loggedDataFormat=loggedDataFormat +echobase.common.nbCreatedObjects=Nombre d'objets crées +echobase.common.notes=notes +echobase.common.password=Mot de passe +echobase.common.pingDutyCycle=pingDutyCycle +echobase.common.processingDescription=processingDescription +echobase.common.processingTemplate=processingTemplate +echobase.common.resultLabel=Result label +echobase.common.soundSpeedCalculationsER60=soundSpeedCalculations (ER60 instrument) +echobase.common.soundSpeedCalculationsME70=soundSpeedCalculations (ME70 instrument) +echobase.common.sounderConstant=sounderConstant +echobase.common.transceiverAcquisitionAbsorptionDescription=transceiverAcquisitionAbsorptionDescription +echobase.common.transectBinUnitsPingAxis=BinUnitsPingAxis (transect) +echobase.common.transectGeospatialVerticalPositive=GeospatialVerticalPositive (transect) +echobase.common.transectLicence=Licence (transect) +echobase.common.transitRelatedActivity=RelatedActivity (transit) +echobase.common.user=Utilisateur +echobase.common.voyageDescription=Description +echobase.confirm.delete.query=Confirmer la suppression de la requète suivante +echobase.error.bad.password=Mot de passe incorrrect +echobase.error.email.already.used=Nom d'utilisateur déjà pris +echobase.error.export.description.requiredstring=La description de l'export est obligatoire +echobase.error.export.name.requiredstring=Le nom de l'export est obligatoire +echobase.error.export.sqlQuery.forbidden.alter.word=La requète contient le mot 'ALTER', ce qui est interdit +echobase.error.export.sqlQuery.forbidden.delete.word=La requète contient le mot 'DELETE', ce qui est interdit +echobase.error.export.sqlQuery.forbidden.drop.word=La requète contient le mot 'DROP', ce qui est interdit +echobase.error.export.sqlQuery.forbidden.insert.word=La requète contient le mot 'INSERT', ce qui est interdit +echobase.error.export.sqlQuery.forbidden.update.word=La requète contient le mot 'UPDATE', ce qui est interdit +echobase.error.export.sqlQuery.requiredstring=La requête de l'export est obligatoire +echobase.error.export.sqlQuery.wrongformat=La requêtes n'est pas valide +echobase.error.import.acousticDensityUnit.required=acousticDensityUnit non renseigné +echobase.error.import.acquisitionSoftwareVersionER60.required=acquisitionSoftwareVersionER60 non renseigné +echobase.error.import.acquisitionSoftwareVersionME70.required=acquisitionSoftwareVersionME70 non renseigné +echobase.error.import.areaOfOperation.required=La sélection d'une zone d'opération est obligatoire +echobase.error.import.biometrySampleFile.required=La sélection d'un fichier BiometrySample est obligatoire +echobase.error.import.cellPositionReference.required=La sélection d'un cellPositionReference est obligatoire +echobase.error.import.datum.required=Datum de la campagne non rengeigné +echobase.error.import.digitThreshold.required=digitThreshold non renseigné +echobase.error.import.echosounderSoundSpeed.required=echosounderSoundSpeed non renseigné +echobase.error.import.echotypeFile.required=La sélection d'un fichier Echotype est obligatoire +echobase.error.import.esduByEchotypeAndSpeciesCategoryFile.required=La sélection d'un fichier d'import est obligatoire +echobase.error.import.esduByEchotypeFile.required=La sélection d'un fichier d'import est obligatoire +echobase.error.import.esduBySpeciesAndAgeCategoryFile.required=La sélection d'un fichier d'import est obligatoire +echobase.error.import.esduBySpeciesAndSizeCategoryFile.required=La sélection d'un fichier d'import est obligatoire +echobase.error.import.gearMetadataFile.required=La sélection d'un fichier GearMetadata est obligatoire +echobase.error.import.importMode.required=Le mode d'import est obligatoire +echobase.error.import.lengthWeightKeyFile.required=La sélection d'un fichier lengthWeightKey est obligatoire +echobase.error.import.loggedDataDatatype.required=loggedDataDatatype non renseigné +echobase.error.import.loggedDataFormat.required=loggedDataFormat non renseigné +echobase.error.import.mapResultFile.required=La sélection d'un fichier de résultats de Carte est obligatoire +echobase.error.import.mapsFile.required=La sélection d'un fichier Carte est obligatoire +echobase.error.import.mission.required=La sélection d'une mission est obligatoire +echobase.error.import.missionAbstract.required=Le résumé de la mission est obligatoire +echobase.error.import.missionName.required=Le nom de la mission est obligatoire +echobase.error.import.moviesFile.required=La sélection d'un fichier Movies est obligatoire +echobase.error.import.notes.required=Note des DataProcessing non renseigné +echobase.error.import.operationFile.required=La sélection d'un fichier Operation est obligatoire +echobase.error.import.operationMetadataFile.required=La sélection d'un fichier OperationMetadata est obligatoire +echobase.error.import.pingDutyCycle.required=pingDutyCycle non renseigné +echobase.error.import.processingDescription.required=processingDescription non renseigné +echobase.error.import.processingTemplate.required=processingTemplate non renseigné +echobase.error.import.regionAssociationFile.required=La sélection d'un fichier d'association de Région est obligatoire +echobase.error.import.regionResultFile.required=La sélection d'un fichier de résultats de Région est obligatoire +echobase.error.import.regionsFile.required=La sélection d'un fichier Region est obligatoire +echobase.error.import.resultImportFile.required=Veuillez sélectionner au moins un fichier à importer +echobase.error.import.resultLabel.required=Le champs ResultLabel est obligatoire +echobase.error.import.soundSpeedCalculationsER60.required=soundSpeedCalculationsER60 non renseigné +echobase.error.import.soundSpeedCalculationsME70.required=soundSpeedCalculationsME70 non renseigné +echobase.error.import.sounderConstant.required=sounderConstant non renseigné +echobase.error.import.subSampleFile.required=La sélection d'un fichier SubSample est obligatoire +echobase.error.import.totalSampleFile.required=La sélection d'un fichier Sample est obligatoire +echobase.error.import.transceiverAcquisitionAbsorptionDescription.required=transceiverAcquisitionAbsorptionDescription non renseigné +echobase.error.import.transectBinUnitsPingAxis.required=BinUnitsPingAxis des transtects non rengeigné +echobase.error.import.transectFile.required=La sélection d'un fichier Transect est obligatoire +echobase.error.import.transectGeospatialVerticalPositive.required=GeospatialVerticalPositive des transtects non rengeigné +echobase.error.import.transectLicence.required=Licence des transtects non rengeigné +echobase.error.import.transit.required=La sélection d'un transit est obligatoire +echobase.error.import.transitFile.required=La sélection d'un fichier Transit est obligatoire +echobase.error.import.transitRelatedActivity.required=RelatedActivity des transits non rengeigné +echobase.error.import.vessel.required=La sélection d'un navire est obligatoire +echobase.error.import.voyage.required=La sélection d'une campagne est obligatoire +echobase.error.import.voyageDescription.required=Description de la campagne non rengeigné +echobase.error.import.voyageFile.required=La sélection d'un fichier Voyage est obligatoire +echobase.error.importFile.required=Fichier d'import obligatoire +echobase.error.importHistorical.input.required=Le fichier d'import est obligatoire +echobase.error.invalid.sql=Requète non valide \: %s +echobase.error.login.unknown=Utilisateur inconnu +echobase.error.login.wrongLogin=Le login est déjà utilisé +echobase.error.mission.name.already.exist=Nom de mission déjà utilisé +echobase.error.no.embeddedApplication.configurationFound=La configuration de création d'application embarquée non trouvée +echobase.error.no.embeddedApplication.exportFileFound=L'application embarquée générée non trouvée +echobase.error.no.exportDb.configurationFound=La configuration de l'export de la base non trouvée +echobase.error.no.exportDb.exportFileFound=L'archive d'export de la base non trouvée +echobase.error.query.name.already.exists=Nom de requète déjà utilisé +echobase.error.required.email=L'email est obligatoire +echobase.error.required.password=Le mot de passe est obligatoire +echobase.error.warlocation.notFound=L'application n'a pas été trouvé à l'emplacement suivant %s +echobase.header.request.result=Résultat de la requête sql +echobase.header.user.gridTitle=Liste des utilisateurs +echobase.info.dbeditor.propertyDiffsResult=Résultat d'import de données +echobase.info.import.failed=L'import a échoué. +echobase.info.import.succeded=L'import a réussi. +echobase.info.new.sqlQuery.inprogress=Nouvelle requète en cours de création +echobase.info.no.sqlQuery.saved=Aucune requête d'export sql enregistrée +echobase.info.no.sqlQuery.selected=Aucune requête d'export sql sélectionnée +echobase.info.no.table.selected=Aucune table sélectionnée +echobase.info.no.voyagee.found=Aucune campagne à exporter +echobase.info.sqlQuery.not.modifiable=Vous ne pouvez pas modifier la requète sélectionnée +echobase.info.user.create=L'utilisateur '%s' a été créée +echobase.info.user.delete=L'utilisateur '%s' a été supprimé +echobase.info.user.update=L'utilisateur '%s' a été mis à jour +echobase.information.create.mission=Si la mission n'existe, suivez le lien pour en créer une nouvelle. +echobase.information.mission.created=La mission %s a été créée +echobase.label.admin.user.create=Création d'un utilisateur +echobase.label.admin.user.delete=Suppression d'un utilisateur +echobase.label.admin.user.edit=Mise à jour d'un utilisateur +echobase.label.createIfNotFound=Créer les entités non trouvées en base +echobase.label.embeddedApplicationFileName=Nom de l'archive à télécharger +echobase.label.embeddedWarFileName=Nom du war à utiliser +echobase.label.exportAsSeen=Exporter "comme à l'écran" +echobase.label.exportDbFileName=Nom du fichier d'export +echobase.label.exportFileName=Nom du fichier d'export +echobase.label.import.accoustique=Fichier accoustique +echobase.label.import.events=Fichier evenements +echobase.label.import.lectureAgeGen=Fichier lecture age +echobase.label.import.pecherie=Fichier pecherie +echobase.label.import.typeEchoSpecies=Fichier espèces +echobase.label.importFile=Fichier à importer +echobase.label.info.changePassword=Changement du mot de passe +echobase.label.language=Language +echobase.label.locale.english=Anglais +echobase.label.locale.french=Français +echobase.label.login=Connexion +echobase.label.numberOfCreatedEntities=Nombre d'entitiés créées +echobase.label.numberOfUpdatedEntities=Nombre d'entitiés mises à jour +echobase.label.query.description=Description +echobase.label.query.name=Nom +echobase.label.query.sql=SQL +echobase.label.sqlQueries=Requêtes enregistrées +echobase.label.user.login=Utilisateur \: %s +echobase.label.voyageToSelect=Voyage à exporter +echobase.legend.connectionToDb.detail=Détail de la connection à la base de données +echobase.legend.dbeditor.edit=Edition de '%s' +echobase.legend.dbeditor.show=Visualisation de '%s' +echobase.legend.embeddedApplication.configuration=Configuration de l'application embarquée +echobase.legend.exportDb.configuration.files=Configuration de l'export +echobase.legend.importData.configuration.files=Choix des fichiers d'import +echobase.legend.importData.configuration.mission=Configurer la mission +echobase.legend.importData.configuration.mission.resume=Résumé de la mission à utiliser +echobase.legend.importData.configuration.resume=Résumé de la configuration d'import +echobase.legend.importData.configuration.selectImportType=Sélection du type d'import +echobase.legend.importData.configure=Configurer l'import +echobase.legend.importData.configure.CommonData.selectMission=Sélection de la mission +echobase.legend.importData.createMission=Caractéristiques de la nouvelle mission +echobase.legend.importData.result.resume=Résultat +echobase.legend.importDb.configuration.files=Choix du fichier d'import de la base complête (fichier zip) +echobase.legend.importFileResult=Résultat de l'import %s +echobase.legend.libreOfficeQuery=Requète "libre office" +echobase.legend.sqlQuery.configuration=Configuration de la requête +echobase.legend.sqlQuery.result=Résultats de la requête +echobase.menu.connectToDbInformations=Informations de connection à la base de données +echobase.menu.createEmbeddedApplication=Créer une application embarquée +echobase.menu.editData=Modifier les données +echobase.menu.export=Exporter des données +echobase.menu.exportDb=Exporter une base complête +echobase.menu.importData=Importer des données +echobase.menu.importDb=Importer une base complête +echobase.menu.logs=Journal des modifications +echobase.menu.users=Gérer les utilisateurs +echobase.menu.viewData=Visualiser les données +echobase.message.askAdministratorPassword=Demander à un administrateur le mot de passe pour l'utilisateur donné +echobase.message.no.row.selected=Aucune donnée sélectionnée +echobase.message.noEntrySelection=Aucune entrée sélectionnée +echobase.message.warnEmbeddedApplicationInProgress=Merci de ne pas fermer la fenêtre pour pouvoir accéder aux résultats de la création de l'application embarquée. +echobase.message.warnExportInProgress=Merci de ne pas fermer la fenêtre pour pouvoir accéder aux résultats de l'export. +echobase.message.warnImportInProgress=Merci de ne pas fermer la fenêtre pour pouvoir accéder aux résultats de l'import. +echobase.title.confirm.deleteQuery=Supprimer une requète +echobase.title.connectToDbInformations=Informations de connection à la base de données +echobase.title.createEmbeddedApplication=Création de l'application embarquée +echobase.title.createMission=Créer une mission +echobase.title.dbEditor=Modification de la base +echobase.title.embeddedApplicationProgress=Création de l'application embarquée en cours +echobase.title.embeddedApplicationResult=Résultat de la création de l'application embarquée +echobase.title.entityModificationLogs=Journal des modifications +echobase.title.export=Export Sql +echobase.title.exportDb=Export complet de la base +echobase.title.exportDbProgress=Export complêt de la base de données en cours +echobase.title.exportDbResult=Résultat de l'export complêt de la base de données +echobase.title.exportTable=Exporter une table +echobase.title.importData=Import de données +echobase.title.importData.configuration=Configuration d'un import de données +echobase.title.importData.selectImportType=Sélection du type d'import +echobase.title.importDataProgress=Import de données en cours +echobase.title.importDataResult=Résultats de l'import de données +echobase.title.importDb=Import de données historiques +echobase.title.importDbProgress=Import de données en cours +echobase.title.importDbResult=Résultats de l'import de données +echobase.title.importTable=Importer une table +echobase.title.login=Connexion +echobase.title.modification.detail=Détail de la modification +echobase.title.newLibreOfficeQuery=Importer une requète Libre-office +echobase.title.users=Adminitration des utilisateurs +echobase.title.welcome=Bienvenue dans EchoBase

1 0

r435 - in trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata: . csv
by tchemit＠users.forge.codelutin.com 28 Mar '12

28 Mar '12

Author: tchemit Date: 2012-03-28 19:56:01 +0200 (Wed, 28 Mar 2012) New Revision: 435 Url: http://forge.codelutin.com/repositories/revision/echobase/435 Log: last modif on import api Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AbstractImportDataService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsImportConfiguration.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultByEchotypeAndSpeciesCategoryImportModel.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultByEchotypeImportModel.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultBySpeciesAndAgeCategoryImportModel.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultBySpeciesAndSizeCategoryImportModel.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/RegionCellResultImportModel.java Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AbstractImportDataService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AbstractImportDataService.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/AbstractImportDataService.java 2012-03-28 17:56:01 UTC (rev 435) @@ -35,6 +35,9 @@ import fr.ifremer.echobase.entities.EntityModificationLog; import fr.ifremer.echobase.entities.data.Category; import fr.ifremer.echobase.entities.data.CategoryDAO; +import fr.ifremer.echobase.entities.data.Cell; +import fr.ifremer.echobase.entities.data.Data; +import fr.ifremer.echobase.entities.data.DataDAO; import fr.ifremer.echobase.entities.data.Echotype; import fr.ifremer.echobase.entities.references.AgeCategory; import fr.ifremer.echobase.entities.references.DataMetadata; @@ -347,4 +350,18 @@ } return result; } + + protected void createCellData(DataDAO dao, + Cell cell, + DataMetadata dataMetaData, + String dataValue, + CsvFileImportResult importResult) { + + Data data = create(dao); + data.setDataMetadata(dataMetaData); + data.setDataValue(dataValue); + cell.addData(data); + + importResult.incrementsNumberCreated(EchoBaseEntityEnum.Data); + } } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportService.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsEsduCellImportService.java 2012-03-28 17:56:01 UTC (rev 435) @@ -336,7 +336,6 @@ metas); - DecoratorService decoratorService = getService(DecoratorService.class); Decorator<Category> categoryDecorator = decoratorService.getDecorator(getLocale(), Category.class, null); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsImportConfiguration.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsImportConfiguration.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsImportConfiguration.java 2012-03-28 17:56:01 UTC (rev 435) @@ -75,9 +75,6 @@ /** Map cells file to import. */ protected final InputFile mapsFile; - /** Map cell results file to import. */ - protected final InputFile mapResultFile; - /** Echotype file to import. */ protected final InputFile echotypeFile; @@ -96,8 +93,6 @@ l_(locale, "echobase.common.cellRegionResultFile")); mapsFile = InputFile.newFile( l_(locale, "echobase.common.cellMapsFile")); - mapResultFile = InputFile.newFile( - l_(locale, "echobase.common.cellMapResultFile")); echotypeFile = InputFile.newFile( l_(locale, "echobase.common.echotypeFile")); lengthAgeKeyFile = InputFile.newFile( @@ -162,10 +157,6 @@ return mapsFile; } - public InputFile getMapResultFile() { - return mapResultFile; - } - public InputFile getEchotypeFile() { return echotypeFile; } @@ -198,7 +189,7 @@ public InputFile[] getInputFiles() { return new InputFile[]{regionsFile, regionAssociationFile, regionResultFile, - mapsFile, mapResultFile, echotypeFile, + mapsFile, echotypeFile, lengthAgeKeyFile, lengthWeightKeyFile, esduByEchotypeFile, esduByEchotypeAndSpeciesCategoryFile, Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportService.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/ResultsRegionCellImportService.java 2012-03-28 17:56:01 UTC (rev 435) @@ -376,20 +376,4 @@ closeReader(reader, inputFile); } } - - private void createCellData(DataDAO dao, - Cell cell, - DataMetadata dataMetaData, - String dataValue, - CsvFileImportResult importResult) { - - Data data = create(dao); - data.setDataMetadata(dataMetaData); - data.setDataValue(dataValue); - cell.addData(data); - - importResult.incrementsNumberCreated(EchoBaseEntityEnum.Data); - } - - } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultByEchotypeAndSpeciesCategoryImportModel.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultByEchotypeAndSpeciesCategoryImportModel.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultByEchotypeAndSpeciesCategoryImportModel.java 2012-03-28 17:56:01 UTC (rev 435) @@ -70,7 +70,7 @@ String name = metadata.getName(); newMandatoryColumn( name, - EchobaseCsvUtil.newResultValueParser(metadata), + EchobaseCsvUtil.newResultValueParser(metadata, false), EchobaseCsvUtil.<EsduResultByEchotypeAndSpeciesCategoryImportRow>newResultValueSetter()); } } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultByEchotypeImportModel.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultByEchotypeImportModel.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultByEchotypeImportModel.java 2012-03-28 17:56:01 UTC (rev 435) @@ -62,7 +62,7 @@ String name = metadata.getName(); newMandatoryColumn( name, - EchobaseCsvUtil.newResultValueParser(metadata), + EchobaseCsvUtil.newResultValueParser(metadata, false), EchobaseCsvUtil.<EsduResultByEchotypeImportRow>newResultValueSetter()); } } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultBySpeciesAndAgeCategoryImportModel.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultBySpeciesAndAgeCategoryImportModel.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultBySpeciesAndAgeCategoryImportModel.java 2012-03-28 17:56:01 UTC (rev 435) @@ -66,7 +66,7 @@ String name = metadata.getName(); newMandatoryColumn( name, - EchobaseCsvUtil.newResultValueParser(metadata), + EchobaseCsvUtil.newResultValueParser(metadata, false), EchobaseCsvUtil.<EsduResultBySpeciesAndAgeCategoryImportRow>newResultValueSetter()); } } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultBySpeciesAndSizeCategoryImportModel.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultBySpeciesAndSizeCategoryImportModel.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/EsduResultBySpeciesAndSizeCategoryImportModel.java 2012-03-28 17:56:01 UTC (rev 435) @@ -66,7 +66,7 @@ String name = metadata.getName(); newMandatoryColumn( name, - EchobaseCsvUtil.newResultValueParser(metadata), + EchobaseCsvUtil.newResultValueParser(metadata, false), EchobaseCsvUtil.<EsduResultBySpeciesAndSizeCategoryImportRow>newResultValueSetter()); } } Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/RegionCellResultImportModel.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/RegionCellResultImportModel.java 2012-03-28 17:55:12 UTC (rev 434) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/importdata/csv/RegionCellResultImportModel.java 2012-03-28 17:56:01 UTC (rev 435) @@ -68,10 +68,9 @@ newForeignKeyColumn(RegionCellResultImportRow.PROPERTY_SIZE_CATEGORY, SizeCategory.class, SizeCategory.PROPERTY_NAME, sizeCategoryMap); for (DataMetadata metadata : dataMetadatas) { - String name = metadata.getName(); newMandatoryColumn( - name, - EchobaseCsvUtil.newResultValueParser(metadata), + metadata.getName(), + EchobaseCsvUtil.newResultValueParser(metadata, true), EchobaseCsvUtil.<RegionCellResultImportRow>newResultValueSetter()); } }

1 0

r434 - trunk/src/doc/reunions
by tchemit＠users.forge.codelutin.com 28 Mar '12

28 Mar '12

Author: tchemit Date: 2012-03-28 19:55:12 +0200 (Wed, 28 Mar 2012) New Revision: 434 Url: http://forge.codelutin.com/repositories/revision/echobase/434 Log: update doc Modified: trunk/src/doc/reunions/reunion-2012-03-29.txt Modified: trunk/src/doc/reunions/reunion-2012-03-29.txt =================================================================== --- trunk/src/doc/reunions/reunion-2012-03-29.txt 2012-03-28 17:54:51 UTC (rev 433) +++ trunk/src/doc/reunions/reunion-2012-03-29.txt 2012-03-28 17:55:12 UTC (rev 434) @@ -30,6 +30,7 @@ On a pas utiliser les dataProcessing.id ? J'ai renommé les colonne des datas dans Map (minuscule sur première lettre) +et ageCategory ? oubli ou pas a utiliser (map import) Suppression des résultats -------------------------

1 0