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

r904 - in trunk: . echobase-domain echobase-services echobase-ui
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 15:36:31 +0100 (Thu, 12 Dec 2013) New Revision: 904 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/904 Log: [maven-release-plugin] prepare release echobase-2.5 Modified: trunk/echobase-domain/pom.xml trunk/echobase-services/pom.xml trunk/echobase-ui/pom.xml trunk/pom.xml Modified: trunk/echobase-domain/pom.xml =================================================================== --- trunk/echobase-domain/pom.xml 2013-12-12 14:27:43 UTC (rev 903) +++ trunk/echobase-domain/pom.xml 2013-12-12 14:36:31 UTC (rev 904) @@ -9,7 +9,7 @@ <parent> <groupId>fr.ifremer</groupId> <artifactId>echobase</artifactId> - <version>2.5-SNAPSHOT</version> + <version>2.5</version> </parent> <groupId>fr.ifremer.echobase</groupId> Modified: trunk/echobase-services/pom.xml =================================================================== --- trunk/echobase-services/pom.xml 2013-12-12 14:27:43 UTC (rev 903) +++ trunk/echobase-services/pom.xml 2013-12-12 14:36:31 UTC (rev 904) @@ -6,7 +6,7 @@ <parent> <groupId>fr.ifremer</groupId> <artifactId>echobase</artifactId> - <version>2.5-SNAPSHOT</version> + <version>2.5</version> </parent> <groupId>fr.ifremer.echobase</groupId> Modified: trunk/echobase-ui/pom.xml =================================================================== --- trunk/echobase-ui/pom.xml 2013-12-12 14:27:43 UTC (rev 903) +++ trunk/echobase-ui/pom.xml 2013-12-12 14:36:31 UTC (rev 904) @@ -7,7 +7,7 @@ <parent> <groupId>fr.ifremer</groupId> <artifactId>echobase</artifactId> - <version>2.5-SNAPSHOT</version> + <version>2.5</version> </parent> <groupId>fr.ifremer.echobase</groupId> Modified: trunk/pom.xml =================================================================== --- trunk/pom.xml 2013-12-12 14:27:43 UTC (rev 903) +++ trunk/pom.xml 2013-12-12 14:36:31 UTC (rev 904) @@ -11,7 +11,7 @@ <groupId>fr.ifremer</groupId> <artifactId>echobase</artifactId> - <version>2.5-SNAPSHOT</version> + <version>2.5</version> <modules> <module>echobase-domain</module> @@ -84,12 +84,12 @@ </developers> <scm> - <url>https://forge.codelutin.com/repositories/browse/echobase/trunk</url> + <url>https://forge.codelutin.com/repositories/browse/echobase/tags/echobase-2.5</url> <connection> - scm:svn:https://forge.codelutin.com/svn/echobase/trunk + scm:svn:https://forge.codelutin.com/svn/echobase/tags/echobase-2.5 </connection> <developerConnection> - scm:svn:https://forge.codelutin.com/svn/echobase/trunk + scm:svn:https://forge.codelutin.com/svn/echobase/tags/echobase-2.5 </developerConnection> </scm>

1 0

r903 - trunk/echobase-ui/src/main/resources/i18n
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 15:27:43 +0100 (Thu, 12 Dec 2013) New Revision: 903 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/903 Log: fix i18n Modified: trunk/echobase-ui/src/main/resources/i18n/echobase-ui_en_GB.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 2013-12-12 14:23:53 UTC (rev 902) +++ trunk/echobase-ui/src/main/resources/i18n/echobase-ui_en_GB.properties 2013-12-12 14:27:43 UTC (rev 903) @@ -266,10 +266,10 @@ echobase.info.no.workingDb.selected=No working database selected echobase.info.no.workingDbConfiguration.saved=No working database configuration saved echobase.info.no.workingDbConfiguration.selected=Select a working database configuration and then connect -echobase.info.query.cloned= -echobase.info.query.created= -echobase.info.query.removed= -echobase.info.query.saved= +echobase.info.query.cloned=Query cloned +echobase.info.query.created=Query created +echobase.info.query.removed=Query removed +echobase.info.query.saved=Query saved echobase.info.removeData.failed=Import removal failed echobase.info.removeData.succeded=Successful data import removal echobase.info.reportBug=Bug report

1 0

r902 - trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 15:23:53 +0100 (Thu, 12 Dec 2013) New Revision: 902 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/902 Log: fixes #3852: Ajout de vues spatiales Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java =================================================================== --- trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 13:50:57 UTC (rev 901) +++ trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 14:23:53 UTC (rev 902) @@ -359,7 +359,8 @@ " (Select SUM(totalsamplemicrpou.sampleweight) From totalsamplemicrpou Where totalsamplemicrpou.operation_id = echobase_operation_spatial.operationname) as TotalCatchMICRPOU,\n" + " (Select SUM(totalsamplescomsco.sampleweight) From totalsamplescomsco Where totalsamplescomsco.operation_id = echobase_operation_spatial.operationname) as TotalCatchSCOMSCO,\n" + " (Select SUM(totalsampletractru.sampleweight) From totalsampletractru Where totalsampletractru.operation_id = echobase_operation_spatial.operationname) as TotalCatchTRACTRU,\n" + - " echobase_operation_spatial.operationid;"); + " echobase_operation_spatial.operationid\n" + + "From echobase_operation_spatial;"); queries.add("DROP VIEW IF EXISTS cellmapview;"); queries.add("CREATE OR REPLACE VIEW cellmapview AS \n" +

1 0

r901 - trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 14:50:57 +0100 (Thu, 12 Dec 2013) New Revision: 901 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/901 Log: fixes #3852: Ajout de vues spatiales Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java =================================================================== --- trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 11:14:47 UTC (rev 900) +++ trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 13:50:57 UTC (rev 901) @@ -168,6 +168,7 @@ // add operation data view queries.add("DROP VIEW IF EXISTS TotalSampleEngrEnc;"); queries.add("CREATE OR REPLACE VIEW TotalSampleEngrEnc AS\n" + + "\n" + "SELECT \n" + " echobase_operation_spatial.voyageid, \n" + " operation.id AS operation_id, \n" + @@ -178,13 +179,13 @@ " species.baracoudacode, \n" + " sample.topiaid\n" + "FROM\n" + - " echobase_operation_spatial, \n" + - " operation, \n" + - " sample, \n" + - " speciescategory, \n" + - " sizecategory, \n" + - " species, \n" + - " sampletype\n" + + " public.echobase_operation_spatial, \n" + + " public.operation, \n" + + " public.sample, \n" + + " public.speciescategory, \n" + + " public.sizecategory, \n" + + " public.species, \n" + + " public.sampletype\n" + "WHERE \n" + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + " operation.topiaid = sample.operation AND\n" + @@ -193,10 +194,11 @@ " speciescategory.sizecategory = sizecategory.topiaid AND\n" + " speciescategory.species = species.topiaid AND\n" + " sampletype.name = 'Total' AND\n" + - " species.baracoudacode='ENGR-ENC';"); + " species.baracoudacode='ENGR-ENC';\n"); queries.add("DROP VIEW IF EXISTS TotalSampleSardPil;"); queries.add("CREATE OR REPLACE VIEW TotalSampleSardPil AS\n" + + "\n" + "SELECT \n" + " echobase_operation_spatial.voyageid, \n" + " operation.id AS operation_id, \n" + @@ -207,13 +209,13 @@ " species.baracoudacode, \n" + " sample.topiaid\n" + "FROM \n" + - " echobase_operation_spatial, \n" + - " operation, \n" + - " sample, \n" + - " speciescategory, \n" + - " sizecategory, \n" + - " species, \n" + - " sampletype\n" + + " public.echobase_operation_spatial, \n" + + " public.operation, \n" + + " public.sample, \n" + + " public.speciescategory, \n" + + " public.sizecategory, \n" + + " public.species, \n" + + " public.sampletype\n" + "WHERE \n" + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + " operation.topiaid = sample.operation AND\n" + @@ -226,6 +228,7 @@ queries.add("DROP VIEW IF EXISTS TotalSampleTracTru;"); queries.add("CREATE OR REPLACE VIEW TotalSampleTracTru AS\n" + + "\n" + "SELECT \n" + " echobase_operation_spatial.voyageid, \n" + " operation.id AS operation_id, \n" + @@ -236,13 +239,13 @@ " species.baracoudacode, \n" + " sample.topiaid\n" + "FROM \n" + - " echobase_operation_spatial, \n" + - " operation, \n" + - " sample, \n" + - " speciescategory, \n" + - " sizecategory, \n" + - " species, \n" + - " sampletype\n" + + " public.echobase_operation_spatial, \n" + + " public.operation, \n" + + " public.sample, \n" + + " public.speciescategory, \n" + + " public.sizecategory, \n" + + " public.species, \n" + + " public.sampletype\n" + "WHERE \n" + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + " operation.topiaid = sample.operation AND\n" + @@ -255,6 +258,7 @@ queries.add("DROP VIEW IF EXISTS TotalSampleSpraSpr;"); queries.add("CREATE OR REPLACE VIEW TotalSampleSpraSpr AS\n" + + "\n" + "SELECT \n" + " echobase_operation_spatial.voyageid, \n" + " operation.id AS operation_id, \n" + @@ -265,13 +269,13 @@ " species.baracoudacode, \n" + " sample.topiaid\n" + "FROM \n" + - " echobase_operation_spatial, \n" + - " operation, \n" + - " sample, \n" + - " speciescategory, \n" + - " sizecategory, \n" + - " species, \n" + - " sampletype\n" + + " public.echobase_operation_spatial, \n" + + " public.operation, \n" + + " public.sample, \n" + + " public.speciescategory, \n" + + " public.sizecategory, \n" + + " public.species, \n" + + " public.sampletype\n" + "WHERE \n" + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + " operation.topiaid = sample.operation AND\n" + @@ -284,6 +288,7 @@ queries.add("DROP VIEW IF EXISTS TotalSampleScomSco;"); queries.add("CREATE OR REPLACE VIEW TotalSampleScomSco AS\n" + + "\n" + "SELECT \n" + " echobase_operation_spatial.voyageid, \n" + " operation.id AS operation_id, \n" + @@ -294,13 +299,13 @@ " species.baracoudacode, \n" + " sample.topiaid\n" + "FROM \n" + - " echobase_operation_spatial, \n" + - " operation, \n" + - " sample, \n" + - " speciescategory, \n" + - " sizecategory, \n" + - " species, \n" + - " sampletype\n" + + " public.echobase_operation_spatial, \n" + + " public.operation, \n" + + " public.sample, \n" + + " public.speciescategory, \n" + + " public.sizecategory, \n" + + " public.species, \n" + + " public.sampletype\n" + "WHERE \n" + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + " operation.topiaid = sample.operation AND\n" + @@ -313,6 +318,7 @@ queries.add("DROP VIEW IF EXISTS TotalSampleMicrPou;"); queries.add("CREATE OR REPLACE VIEW TotalSampleMicrPou AS\n" + + "\n" + "SELECT \n" + " echobase_operation_spatial.voyageid, \n" + " operation.id AS operation_id, \n" + @@ -323,13 +329,13 @@ " species.baracoudacode, \n" + " sample.topiaid\n" + "FROM \n" + - " echobase_operation_spatial, \n" + - " operation, \n" + - " sample, \n" + - " speciescategory, \n" + - " sizecategory, \n" + - " species, \n" + - " sampletype\n" + + " public.echobase_operation_spatial, \n" + + " public.operation, \n" + + " public.sample, \n" + + " public.speciescategory, \n" + + " public.sizecategory, \n" + + " public.species, \n" + + " public.sampletype\n" + "WHERE \n" + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + " operation.topiaid = sample.operation AND\n" + @@ -342,6 +348,7 @@ queries.add("DROP VIEW IF EXISTS TotalCatchSpOpWide;"); queries.add("CREATE OR REPLACE VIEW TotalCatchSpOpWide AS\n" + + "\n" + "SELECT\n" + " echobase_operation_spatial.voyagename,\n" + " echobase_operation_spatial.operationname,\n" + @@ -351,8 +358,8 @@ " (Select SUM(totalsamplespraspr.sampleweight) From totalsamplespraspr Where totalsamplespraspr.operation_id = echobase_operation_spatial.operationname) as TotalCatchSPRASPR,\n" + " (Select SUM(totalsamplemicrpou.sampleweight) From totalsamplemicrpou Where totalsamplemicrpou.operation_id = echobase_operation_spatial.operationname) as TotalCatchMICRPOU,\n" + " (Select SUM(totalsamplescomsco.sampleweight) From totalsamplescomsco Where totalsamplescomsco.operation_id = echobase_operation_spatial.operationname) as TotalCatchSCOMSCO,\n" + - " (Select SUM(totalsampletractru.sampleweight) From totalsampletractru Where totalsampletractru.operation_id = echobase_operation_spatial.operationname) as TotalCatchTRACTRU\n" + - "From echobase_operation_spatial;"); + " (Select SUM(totalsampletractru.sampleweight) From totalsampletractru Where totalsampletractru.operation_id = echobase_operation_spatial.operationname) as TotalCatchTRACTRU,\n" + + " echobase_operation_spatial.operationid;"); queries.add("DROP VIEW IF EXISTS cellmapview;"); queries.add("CREATE OR REPLACE VIEW cellmapview AS \n" +

1 0

r900 - trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 12:14:47 +0100 (Thu, 12 Dec 2013) New Revision: 900 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/900 Log: fixes #3852: Ajout de vues spatiales Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java =================================================================== --- trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 11:11:35 UTC (rev 899) +++ trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 11:14:47 UTC (rev 900) @@ -353,5 +353,11 @@ " (Select SUM(totalsamplescomsco.sampleweight) From totalsamplescomsco Where totalsamplescomsco.operation_id = echobase_operation_spatial.operationname) as TotalCatchSCOMSCO,\n" + " (Select SUM(totalsampletractru.sampleweight) From totalsampletractru Where totalsampletractru.operation_id = echobase_operation_spatial.operationname) as TotalCatchTRACTRU\n" + "From echobase_operation_spatial;"); + + queries.add("DROP VIEW IF EXISTS cellmapview;"); + queries.add("CREATE OR REPLACE VIEW cellmapview AS \n" + + " SELECT echobase_cell_spatial.voyagename, echobase_cell_spatial.coordinate, echobase_cell_spatial.shape, datametadata.name, result.resultvalue, species.baracoudacode, echobase_cell_spatial.cellname, result.topiaid AS resultid\n" + + " FROM echobase_cell_spatial, result, datametadata, category, speciescategory, species\n" + + " WHERE echobase_cell_spatial.cellid::text = result.cell::text AND result.datametadata::text = datametadata.topiaid::text AND result.category::text = category.topiaid::text AND category.speciescategory::text = speciescategory.topiaid::text AND speciescategory.species::text = species.topiaid::text AND echobase_cell_spatial.celltypename::text = 'Map cell'::text;"); } }

1 0

r899 - trunk/src/site/rst
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 12:11:35 +0100 (Thu, 12 Dec 2013) New Revision: 899 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/899 Log: update doc Modified: trunk/src/site/rst/install.rst.vm Modified: trunk/src/site/rst/install.rst.vm =================================================================== --- trunk/src/site/rst/install.rst.vm 2013-12-12 10:28:48 UTC (rev 898) +++ trunk/src/site/rst/install.rst.vm 2013-12-12 11:11:35 UTC (rev 899) @@ -92,8 +92,8 @@ Pré-requis: -- Avoir installer tomcat 7 -- Etre loggué sur une console avec l'utilisateur root. +- Avoir installé tomcat 7 +- Être loggué sur une console avec l'utilisateur root. On suppose que tomcat a été installé via le système de paquets, et donc que le répertoire **/var/lib/tomcat7** existe. @@ -107,14 +107,14 @@ mkdir /var/local/echobase mkdir /var/local/echobase/war -- Placer le war à utiliser dans **/var/local/echobase/war** -- Ajouter une lien symoblique vers le war à utiliser +- Placer le war *echobase-full-${project.version}.war* à utiliser dans **/var/local/echobase/war** +- Ajouter un lien symoblique vers le war à utiliser :: - ln -s /var/local/echobase/war/echobase-full-${project.version}.var /var/local/echobase/echobase.war + ln -s /var/local/echobase/war/echobase-full-${project.version}.war /var/local/echobase/echobase.war -- Mettre l'application dans tomcat +- Ajouter l'application dans tomcat :: @@ -142,7 +142,7 @@ | `-- echobase.log |-- echobase.war `-- war - `-- echobase-full-2.3-SNAPSHOT.war + `-- echobase-full-${project.version}-SNAPSHOT.war Mettre à jour le war de l'application @@ -150,8 +150,8 @@ Pré-requis : -- Avoir installer tomcat 7 -- Etre loggué sur une console avec l'utilisateur root. +- Avoir installé tomcat 7 +- Être loggué sur une console avec l'utilisateur root. On suppose que tomcat a été installé via le système de paquets, et donc que le répertoire **/var/lib/tomcat7** existe. @@ -167,13 +167,13 @@ - Attendre que le répertoire **/var/lib/tomcat7/webapps/echobase** a bien été supprimé. -- Copier le nouveau war dans **/var/local/echobase/war** +- Placer le war *echobase-full-${project.version}.war* à utiliser dans **/var/local/echobase/war** - Changer le lien symbolique **/var/local/echobase/echobase.war** :: - unlink echobase.war - ln -s /var/local/echobasewar/echobase-full-${project.version}.war /var/local/echobase/echobase.war + unlink /var/local/echobase/echobase.war + ln -s /var/local/echobase/war/echobase-full-${project.version}.war /var/local/echobase/echobase.war - Mettre l'application dans tomcat

1 0

r898 - trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 11:28:48 +0100 (Thu, 12 Dec 2013) New Revision: 898 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/898 Log: fixes #3856: Probl?\195?\168me de g?\195?\169n?\195?\169ration des donn?\195?\169es spatiales suite ?\195?\160 un import de base. fixes #3973: La colonne operationname n'est pas renseign?\195?\169e dans la table echobase_operation_spatial refs #3852: Ajout de vues spatiales (view sur les operations) Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java Modified: trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java =================================================================== --- trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 09:27:01 UTC (rev 897) +++ trunk/echobase-domain/src/main/java/fr/ifremer/echobase/persistence/migration/workingDb/MigrationCallBackForVersion2_5.java 2013-12-12 10:28:48 UTC (rev 898) @@ -49,59 +49,309 @@ boolean showSql, boolean showProgression) throws TopiaException { - // add spatial view (http://forge.codelutin.com/issues/3672) - updatePostgis(tx, queries); - } + boolean spatialAware; - protected void updatePostgis(TopiaContext tx, List<String> queries) { TopiaEchoBasePersistenceContext persistenceContext = new TopiaEchoBasePersistenceContext(tx); - boolean spatialAware = - persistenceContext.isSpatialAware(); - try { - if (spatialAware) { - // add cell data view - queries.add("DROP VIEW IF EXISTS echobase_cell_spatial_data;"); - queries.add("CREATE OR REPLACE VIEW echobase_cell_spatial_data AS\n" + - "SELECT\n" + - " s.*,\n" + - " m.topiaId as metaDataId,\n" + - " m.name as metaDataName,\n" + - " d.datavalue as dataValue,\n" + - " d.topiaid as dataId\n" + - "FROM\n" + - " echobase_cell_spatial s,\n" + - " data d,\n" + - " datametadata m\n" + - "WHERE\n" + - " s.cellid = d.cell AND\n" + - " d.datametadata = m.topiaid;"); - - // add cell result view - queries.add("DROP VIEW IF EXISTS echobase_cell_spatial_result;"); - queries.add("CREATE OR REPLACE VIEW echobase_cell_spatial_result AS\n" + - "SELECT\n" + - " s.*,\n" + - " m.topiaId as metaDataId,\n" + - " m.name as metaDataName,\n" + - " r.resultvalue as resultValue,\n" + - " r.topiaid as resultId\n" + - "FROM\n" + - " echobase_cell_spatial s,\n" + - " result r,\n" + - " datametadata m\n" + - "WHERE\n" + - " s.cellid = r.cell AND\n" + - " r.datametadata = m.topiaid;"); - - // add operation data view - queries.add("DROP VIEW IF EXISTS echobase_operation_spatial_data;"); - //TODO Add spatial table - } + spatialAware = persistenceContext.isSpatialAware(); } finally { persistenceContext.rollbackTransaction(); } + + if (spatialAware) { + + // add spatial view (http://forge.codelutin.com/issues/3672) + addPostgisView(queries); + + // fix http://forge.codelutin.com/issues/3856 + fixechobase_fill_cell_spatial_tableFunction(queries); + + // fix http://forge.codelutin.com/issues/3973 + fixOperationNameNotFilled(queries); + } } + + private void fixOperationNameNotFilled(List<String> queries) { + + // fix http://forge.codelutin.com/issues/3973 + queries.add("update echobase_operation_spatial set operationname = (select op.id from operation op where op.topiaid = operationid);"); + } + + private void fixechobase_fill_cell_spatial_tableFunction(List<String> queries) { + + queries.add("CREATE OR REPLACE FUNCTION echobase_fill_cell_spatial_row(cell_id VARCHAR)\n" + + " RETURNS VOID AS $$\n" + + " DECLARE cell_type VARCHAR;\n" + + "BEGIN\n" + + "\n" + + " cell_type = echobase_get_cell_type(cell_id);\n" + + "\n" + + " RAISE DEBUG 'Treat spatial cell % [type %] ...', cell_id, cell_type;\n" + + " CASE cell_type\n" + + " WHEN 'ESDU'\n" + + " THEN\n" + + " EXECUTE echobase_fill_esdu_cell_spatial_table(cell_id);\n" + + " WHEN 'ELEMENTARY'\n" + + " THEN\n" + + " EXECUTE echobase_fill_elementary_cell_spatial_table(cell_id);\n" + + " WHEN 'REGION'\n" + + " THEN\n" + + " EXECUTE echobase_fill_region_cell_spatial_table(cell_id);\n" + + " WHEN 'MAP'\n" + + " THEN\n" + + " EXECUTE echobase_fill_map_cell_spatial_table(cell_id);\n" + + " ELSE\n" + + " RAISE LOG 'Can not deal with celltype % (cell %)', cell_type, cell_id;\n" + + " END CASE;\n" + + "END\n" + + "$$\n" + + "LANGUAGE plpgsql;"); + + queries.add("CREATE OR REPLACE FUNCTION echobase_fill_cell_spatial_table()\n" + + " RETURNS VOID AS $$\n" + + "DECLARE\n" + + " cellRow RECORD;\n" + + "BEGIN\n" + + " FOR cellRow IN SELECT\n" + + " *\n" + + " FROM echobase_cell_spatial_temp LOOP\n" + + "\n" + + " PERFORM echobase_fill_cell_spatial_row(cellRow.cellid);\n" + + "\n" + + " END LOOP;\n" + + "\n" + + " DELETE FROM echobase_cell_spatial_temp;\n" + + "\n" + + "END\n" + + "$$\n" + + "LANGUAGE plpgsql;"); + } + + private void addPostgisView(List<String> queries) { + + // add cell data view + queries.add("DROP VIEW IF EXISTS echobase_cell_spatial_data;"); + queries.add("CREATE OR REPLACE VIEW echobase_cell_spatial_data AS\n" + + "SELECT\n" + + " s.*,\n" + + " m.topiaId as metaDataId,\n" + + " m.name as metaDataName,\n" + + " d.datavalue as dataValue,\n" + + " d.topiaid as dataId\n" + + "FROM\n" + + " echobase_cell_spatial s,\n" + + " data d,\n" + + " datametadata m\n" + + "WHERE\n" + + " s.cellid = d.cell AND\n" + + " d.datametadata = m.topiaid;"); + + // add cell result view + queries.add("DROP VIEW IF EXISTS echobase_cell_spatial_result;"); + queries.add("CREATE OR REPLACE VIEW echobase_cell_spatial_result AS\n" + + "SELECT\n" + + " s.*,\n" + + " m.topiaId as metaDataId,\n" + + " m.name as metaDataName,\n" + + " r.resultvalue as resultValue,\n" + + " r.topiaid as resultId\n" + + "FROM\n" + + " echobase_cell_spatial s,\n" + + " result r,\n" + + " datametadata m\n" + + "WHERE\n" + + " s.cellid = r.cell AND\n" + + " r.datametadata = m.topiaid;"); + + // add operation data view + queries.add("DROP VIEW IF EXISTS TotalSampleEngrEnc;"); + queries.add("CREATE OR REPLACE VIEW TotalSampleEngrEnc AS\n" + + "SELECT \n" + + " echobase_operation_spatial.voyageid, \n" + + " operation.id AS operation_id, \n" + + " echobase_operation_spatial.coordinate, \n" + + " sampletype.name AS sampletype_name, \n" + + " sample.sampleweight, \n" + + " sizecategory.name AS sizecategory_name, \n" + + " species.baracoudacode, \n" + + " sample.topiaid\n" + + "FROM\n" + + " echobase_operation_spatial, \n" + + " operation, \n" + + " sample, \n" + + " speciescategory, \n" + + " sizecategory, \n" + + " species, \n" + + " sampletype\n" + + "WHERE \n" + + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + + " operation.topiaid = sample.operation AND\n" + + " sample.speciescategory = speciescategory.topiaid AND\n" + + " sample.sampletype = sampletype.topiaid AND\n" + + " speciescategory.sizecategory = sizecategory.topiaid AND\n" + + " speciescategory.species = species.topiaid AND\n" + + " sampletype.name = 'Total' AND\n" + + " species.baracoudacode='ENGR-ENC';"); + + queries.add("DROP VIEW IF EXISTS TotalSampleSardPil;"); + queries.add("CREATE OR REPLACE VIEW TotalSampleSardPil AS\n" + + "SELECT \n" + + " echobase_operation_spatial.voyageid, \n" + + " operation.id AS operation_id, \n" + + " echobase_operation_spatial.coordinate, \n" + + " sampletype.name AS sampletype_name, \n" + + " sample.sampleweight, \n" + + " sizecategory.name AS sizecategory_name, \n" + + " species.baracoudacode, \n" + + " sample.topiaid\n" + + "FROM \n" + + " echobase_operation_spatial, \n" + + " operation, \n" + + " sample, \n" + + " speciescategory, \n" + + " sizecategory, \n" + + " species, \n" + + " sampletype\n" + + "WHERE \n" + + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + + " operation.topiaid = sample.operation AND\n" + + " sample.speciescategory = speciescategory.topiaid AND\n" + + " sample.sampletype = sampletype.topiaid AND\n" + + " speciescategory.sizecategory = sizecategory.topiaid AND\n" + + " speciescategory.species = species.topiaid AND\n" + + " sampletype.name = 'Total' AND\n" + + " species.baracoudacode='SARD-PIL';"); + + queries.add("DROP VIEW IF EXISTS TotalSampleTracTru;"); + queries.add("CREATE OR REPLACE VIEW TotalSampleTracTru AS\n" + + "SELECT \n" + + " echobase_operation_spatial.voyageid, \n" + + " operation.id AS operation_id, \n" + + " echobase_operation_spatial.coordinate, \n" + + " sampletype.name AS sampletype_name, \n" + + " sample.sampleweight, \n" + + " sizecategory.name AS sizecategory_name, \n" + + " species.baracoudacode, \n" + + " sample.topiaid\n" + + "FROM \n" + + " echobase_operation_spatial, \n" + + " operation, \n" + + " sample, \n" + + " speciescategory, \n" + + " sizecategory, \n" + + " species, \n" + + " sampletype\n" + + "WHERE \n" + + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + + " operation.topiaid = sample.operation AND\n" + + " sample.speciescategory = speciescategory.topiaid AND\n" + + " sample.sampletype = sampletype.topiaid AND\n" + + " speciescategory.sizecategory = sizecategory.topiaid AND\n" + + " speciescategory.species = species.topiaid AND\n" + + " sampletype.name = 'Total' AND\n" + + " species.baracoudacode='TRAC-TRU';"); + + queries.add("DROP VIEW IF EXISTS TotalSampleSpraSpr;"); + queries.add("CREATE OR REPLACE VIEW TotalSampleSpraSpr AS\n" + + "SELECT \n" + + " echobase_operation_spatial.voyageid, \n" + + " operation.id AS operation_id, \n" + + " echobase_operation_spatial.coordinate, \n" + + " sampletype.name AS sampletype_name, \n" + + " sample.sampleweight, \n" + + " sizecategory.name AS sizecategory_name, \n" + + " species.baracoudacode, \n" + + " sample.topiaid\n" + + "FROM \n" + + " echobase_operation_spatial, \n" + + " operation, \n" + + " sample, \n" + + " speciescategory, \n" + + " sizecategory, \n" + + " species, \n" + + " sampletype\n" + + "WHERE \n" + + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + + " operation.topiaid = sample.operation AND\n" + + " sample.speciescategory = speciescategory.topiaid AND\n" + + " sample.sampletype = sampletype.topiaid AND\n" + + " speciescategory.sizecategory = sizecategory.topiaid AND\n" + + " speciescategory.species = species.topiaid AND\n" + + " sampletype.name = 'Total' AND\n" + + " species.baracoudacode='SPRA-SPR';"); + + queries.add("DROP VIEW IF EXISTS TotalSampleScomSco;"); + queries.add("CREATE OR REPLACE VIEW TotalSampleScomSco AS\n" + + "SELECT \n" + + " echobase_operation_spatial.voyageid, \n" + + " operation.id AS operation_id, \n" + + " echobase_operation_spatial.coordinate, \n" + + " sampletype.name AS sampletype_name, \n" + + " sample.sampleweight, \n" + + " sizecategory.name AS sizecategory_name, \n" + + " species.baracoudacode, \n" + + " sample.topiaid\n" + + "FROM \n" + + " echobase_operation_spatial, \n" + + " operation, \n" + + " sample, \n" + + " speciescategory, \n" + + " sizecategory, \n" + + " species, \n" + + " sampletype\n" + + "WHERE \n" + + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + + " operation.topiaid = sample.operation AND\n" + + " sample.speciescategory = speciescategory.topiaid AND\n" + + " sample.sampletype = sampletype.topiaid AND\n" + + " speciescategory.sizecategory = sizecategory.topiaid AND\n" + + " speciescategory.species = species.topiaid AND\n" + + " sampletype.name = 'Total' AND\n" + + " species.baracoudacode='SCOM-SCO';"); + + queries.add("DROP VIEW IF EXISTS TotalSampleMicrPou;"); + queries.add("CREATE OR REPLACE VIEW TotalSampleMicrPou AS\n" + + "SELECT \n" + + " echobase_operation_spatial.voyageid, \n" + + " operation.id AS operation_id, \n" + + " echobase_operation_spatial.coordinate, \n" + + " sampletype.name AS sampletype_name, \n" + + " sample.sampleweight, \n" + + " sizecategory.name AS sizecategory_name, \n" + + " species.baracoudacode, \n" + + " sample.topiaid\n" + + "FROM \n" + + " echobase_operation_spatial, \n" + + " operation, \n" + + " sample, \n" + + " speciescategory, \n" + + " sizecategory, \n" + + " species, \n" + + " sampletype\n" + + "WHERE \n" + + " echobase_operation_spatial.operationid = operation.topiaid AND\n" + + " operation.topiaid = sample.operation AND\n" + + " sample.speciescategory = speciescategory.topiaid AND\n" + + " sample.sampletype = sampletype.topiaid AND\n" + + " speciescategory.sizecategory = sizecategory.topiaid AND\n" + + " speciescategory.species = species.topiaid AND\n" + + " sampletype.name = 'Total' AND\n" + + " species.baracoudacode='MICR-POU';"); + + queries.add("DROP VIEW IF EXISTS TotalCatchSpOpWide;"); + queries.add("CREATE OR REPLACE VIEW TotalCatchSpOpWide AS\n" + + "SELECT\n" + + " echobase_operation_spatial.voyagename,\n" + + " echobase_operation_spatial.operationname,\n" + + " echobase_operation_spatial.coordinate,\n" + + " (Select SUM(totalsampleengrenc.sampleweight) From totalsampleengrenc Where totalsampleengrenc.operation_id = echobase_operation_spatial.operationname) as TotalCatchENGRENC,\n" + + " (Select SUM(totalsamplesardpil.sampleweight) From totalsamplesardpil Where totalsamplesardpil.operation_id = echobase_operation_spatial.operationname) as TotalCatchSARDPIL,\n" + + " (Select SUM(totalsamplespraspr.sampleweight) From totalsamplespraspr Where totalsamplespraspr.operation_id = echobase_operation_spatial.operationname) as TotalCatchSPRASPR,\n" + + " (Select SUM(totalsamplemicrpou.sampleweight) From totalsamplemicrpou Where totalsamplemicrpou.operation_id = echobase_operation_spatial.operationname) as TotalCatchMICRPOU,\n" + + " (Select SUM(totalsamplescomsco.sampleweight) From totalsamplescomsco Where totalsamplescomsco.operation_id = echobase_operation_spatial.operationname) as TotalCatchSCOMSCO,\n" + + " (Select SUM(totalsampletractru.sampleweight) From totalsampletractru Where totalsampletractru.operation_id = echobase_operation_spatial.operationname) as TotalCatchTRACTRU\n" + + "From echobase_operation_spatial;"); + } }

1 0

r897 - trunk
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 10:27:01 +0100 (Thu, 12 Dec 2013) New Revision: 897 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/897 Log: fixes #3850: Updates mavenpom to 4.4 Modified: trunk/pom.xml Modified: trunk/pom.xml =================================================================== --- trunk/pom.xml 2013-12-12 08:00:48 UTC (rev 896) +++ trunk/pom.xml 2013-12-12 09:27:01 UTC (rev 897) @@ -6,7 +6,7 @@ <parent> <groupId>org.nuiton</groupId> <artifactId>mavenpom4redmine</artifactId> - <version>4.3</version> + <version>4.4</version> </parent> <groupId>fr.ifremer</groupId>

1 0

r896 - trunk
by tchemit＠users.forge.codelutin.com 12 Dec '13

12 Dec '13

Author: tchemit Date: 2013-12-12 09:00:48 +0100 (Thu, 12 Dec 2013) New Revision: 896 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/896 Log: fixes #3974: Suppression du module echobase-tools Removed: trunk/echobase-tools/ Modified: trunk/pom.xml Modified: trunk/pom.xml =================================================================== --- trunk/pom.xml 2013-12-11 07:43:25 UTC (rev 895) +++ trunk/pom.xml 2013-12-12 08:00:48 UTC (rev 896) @@ -16,7 +16,6 @@ <modules> <module>echobase-domain</module> <module>echobase-services</module> - <module>echobase-tools</module> <module>echobase-ui</module> </modules>

1 0

r895 - in trunk/echobase-ui/src/main/webapp: WEB-INF/includes css images
by tchemit＠users.forge.codelutin.com 11 Dec '13

11 Dec '13

Author: tchemit Date: 2013-12-11 08:43:25 +0100 (Wed, 11 Dec 2013) New Revision: 895 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/895 Log: fixes #3954: Int?\195?\169grer les nouveaux icones Added: trunk/echobase-ui/src/main/webapp/images/menu3.jpg Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/includes/header.jsp trunk/echobase-ui/src/main/webapp/css/screen.css Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/includes/header.jsp =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/includes/header.jsp 2013-11-22 09:11:50 UTC (rev 894) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/includes/header.jsp 2013-12-11 07:43:25 UTC (rev 895) @@ -118,7 +118,7 @@ </s:a> </li> <li> - <s:a action="configure" namespace="/spatial" cssClass="info"> + <s:a action="configure" namespace="/spatial" cssClass="spatial"> <span> <s:text name="echobase.menu.showSpatialData"/> </span> Modified: trunk/echobase-ui/src/main/webapp/css/screen.css =================================================================== --- trunk/echobase-ui/src/main/webapp/css/screen.css 2013-11-22 09:11:50 UTC (rev 894) +++ trunk/echobase-ui/src/main/webapp/css/screen.css 2013-12-11 07:43:25 UTC (rev 895) @@ -592,7 +592,7 @@ transition: 0.25s; } .menu a{ - background:url(../images/menu2.jpg) no-repeat; + background:url(../images/menu3.jpg) no-repeat; height:48px; width:48px; @@ -672,11 +672,18 @@ } .menu .dashboard{ - background-position:-336px 0; + background-position:-528px 0; } .menu .dashboard:hover{ - background-position:-336px -48px; + background-position:-528px -48px; } + +.menu .spatial{ + background-position:-480px 0; +} +.menu .spatial:hover{ + background-position:-480px -48px; +} /*connexion*/ #headerRight{ font-size:140%; Added: trunk/echobase-ui/src/main/webapp/images/menu3.jpg =================================================================== (Binary files differ) Property changes on: trunk/echobase-ui/src/main/webapp/images/menu3.jpg ___________________________________________________________________ Added: svn:mime-type + image/jpeg

1 0