- Observe-commits - mailman.cloud.codelutin.com

[Git][ultreiaio/ird-observe] Pushed new branch release/9.0.8
by Tony CHEMIT (＠tchemit) 30 Sep '22

30 Sep '22

Tony CHEMIT pushed new branch release/9.0.8 at ultreiaio / ird-observe -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/tree/release/9.0.8 You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] 2 commits: Add warning (See #2430)
by Tony CHEMIT (＠tchemit) 30 Sep '22

30 Sep '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 11dad4f1 by Tony Chemit at 2022-09-30T18:09:55+02:00 Add warning (See #2430) - - - - - 5b4e926f by Tony Chemit at 2022-09-30T18:10:12+02:00 [jgitflow-maven-plugin]updating poms for 9.0.9-SNAPSHOT development[skip ci] - - - - - 30 changed files: - client/configuration/pom.xml - client/core/pom.xml - client/datasource/actions/pom.xml - client/datasource/editor/api-test/pom.xml - client/datasource/editor/api/pom.xml - client/datasource/editor/common/pom.xml - client/datasource/editor/ll/pom.xml - client/datasource/editor/pom.xml - client/datasource/editor/ps/pom.xml - client/datasource/editor/spi/pom.xml - client/datasource/pom.xml - client/pom.xml - client/runner/pom.xml - core/api/dto/pom.xml - core/api/pom.xml - core/api/services/pom.xml - core/api/tree/pom.xml - core/api/validation/pom.xml - core/persistence/java/pom.xml - core/persistence/pom.xml - core/persistence/resources/pom.xml - core/persistence/test/pom.xml - core/pom.xml - core/services/client/pom.xml - core/services/i18n/pom.xml - core/services/local/pom.xml - core/services/pom.xml - core/services/test/pom.xml - model/pom.xml - observe/pom.xml The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/99ba235bb1abe711841f3472… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/99ba235bb1abe711841f3472… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] Update changelog for v.9.0.8 [skip CI]
by Tony CHEMIT (＠tchemit) 30 Sep '22

30 Sep '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 99ba235b by Tony Chemit at 2022-09-30T18:02:14+02:00 Update changelog for v.9.0.8 [skip CI] - - - - - 1 changed file: - CHANGELOG.md Changes: ===================================== CHANGELOG.md ===================================== @@ -1,7 +1,23 @@ # ObServe changelog * Author [Tony Chemit](mailto:dev@tchemit.fr) - * Last generated at 2022-09-12 00:53. + * Last generated at 2022-09-30 18:00. + +## Version [9.0.8](https://gitlab.com/ultreiaio/ird-observe/-/milestones/234) + +**Closed at 2022-09-30.** + +### Download +* [Client (observe-9.0.8-client.zip)](https://repo1.maven.org/maven2/fr/ird/observe/ob…) +* [Serveur (observe-9.0.8.war)](https://repo1.maven.org/maven2/fr/ird/observe/observe/9…) +* [Serveur (observe-9.0.8-server.zip)](https://repo1.maven.org/maven2/fr/ird/observe/ob…) + + +### Issues + * [[Type::Anomalie 2431]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2431) **L'assistant sécurité 9.0.7 ne fonctionne plus** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil) + * [[Type::Anomalie 2433]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2433) **La synchronisation simple de la base locale ne fonctionne plus** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil) + * [[Type::Anomalie 2434]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2434) **L'importeur AVDTH plante en fin de processus** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil) + * [[Type::Anomalie 2436]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2436) **Souci d'affichage (probablement d'index) dans les échantillons PS après migration V9** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil) ## Version [9.0.7](https://gitlab.com/ultreiaio/ird-observe/-/milestones/232) View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/99ba235bb1abe711841f3472c… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/99ba235bb1abe711841f3472c… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] Souci d'affichage (probablement d'index) dans les échantillons PS après migration V9 - Closes #2436
by Tony CHEMIT (＠tchemit) 30 Sep '22

30 Sep '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 3131da07 by Tony Chemit at 2022-09-30T17:57:42+02:00 Souci d'affichage (probablement d'index) dans les échantillons PS après migration V9 - Closes #2436 - - - - - 2 changed files: - core/persistence/resources/src/main/java/fr/ird/observe/spi/migration/v9/DataSourceMigrationForVersion_9_0.java - core/persistence/resources/src/main/resources/db/migration/v9/9.0/03_fill-table-ps_observation_sample-common.sql Changes: ===================================== core/persistence/resources/src/main/java/fr/ird/observe/spi/migration/v9/DataSourceMigrationForVersion_9_0.java ===================================== @@ -23,6 +23,7 @@ package fr.ird.observe.spi.migration.v9; */ import com.google.auto.service.AutoService; +import fr.ird.observe.spi.context.DataDtoEntityContext; import fr.ird.observe.spi.migration.ByMajorMigrationVersionResource; import io.ultreia.java4all.util.Version; import io.ultreia.java4all.util.sql.SqlQuery; @@ -32,9 +33,13 @@ import org.apache.logging.log4j.Logger; import org.nuiton.topia.service.migration.resources.MigrationVersionResource; import org.nuiton.topia.service.migration.resources.MigrationVersionResourceExecutor; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.sql.Timestamp; import java.util.List; import java.util.Map; import java.util.Set; +import java.util.TreeMap; /** * Created on 19/01/2021. @@ -124,6 +129,11 @@ public class DataSourceMigrationForVersion_9_0 extends ByMajorMigrationVersionRe addNewTable(executor, withIds, "03", "table-ps_observation_catch", "table-ps_observation_sample"); + if (withIds) { + // See https://gitlab.com/ultreiaio/ird-observe/-/issues/2436 + migrateSample(executor); + } + executor.addScript("04_0", "adapt_table-ps_observation_activity"); executor.addScript("04_1", "adapt_table-ps_observation_set"); @@ -189,6 +199,307 @@ public class DataSourceMigrationForVersion_9_0 extends ByMajorMigrationVersionRe } } + static class Sample { + String topiaId; + long topiaVersion; + Timestamp topiaCreateDate; + Timestamp lastUpdateDate; + String homeId; + String comment; + String set; + + public Sample(ResultSet resultSet) throws SQLException { + this.topiaId = resultSet.getString(1); + this.topiaVersion = resultSet.getLong(2); + this.topiaCreateDate = resultSet.getTimestamp(3); + this.homeId = resultSet.getString(4); + this.comment = resultSet.getString(5); + this.set = resultSet.getString(6); + this.lastUpdateDate = resultSet.getTimestamp(7); + } + + public void addHomeId(String homeId) { + if (homeId == null) { + return; + } + if (this.homeId == null) { + this.homeId = homeId; + return; + } + this.homeId += " - " + homeId; + } + + public void addComment(String comment) { + if (comment == null) { + return; + } + if (this.comment == null) { + this.comment = comment; + return; + } + this.comment += " - " + comment; + } + + } + + + static class SampleMeasure { + String topiaId; + long topiaVersion; + Timestamp topiaCreateDate; + Timestamp lastUpdateDate; + String homeId; + Float length; + Boolean isLengthComputed; + String picturesReferences; + Float weight; + Boolean isWeightComputed; + int count; + int acquisitionMode; + String species; + String sample; + String sex; + String sizeMeasureType; + String weightMeasureType; + String tagNumber; + String speciesFate; + int sample_idx; + String lengthMeasureMethod; + String weightMeasureMethod; + + public SampleMeasure(ResultSet resultSet) throws SQLException { + this.topiaId = resultSet.getString(1); + this.topiaVersion = resultSet.getLong(2); + this.topiaCreateDate = resultSet.getTimestamp(3); + this.homeId = resultSet.getString(4); + this.length = resultSet.getFloat(5); + this.isLengthComputed = resultSet.getBoolean(6); + this.picturesReferences = resultSet.getString(7); + this.weight = resultSet.getFloat(8); + this.isWeightComputed = resultSet.getBoolean(9); + this.count = resultSet.getInt(10); + this.acquisitionMode = resultSet.getInt(11); + this.species = resultSet.getString(12); + this.sample = resultSet.getString(13); + this.sex = resultSet.getString(14); + this.lastUpdateDate = resultSet.getTimestamp(15); + this.sizeMeasureType = resultSet.getString(16); + this.weightMeasureType = resultSet.getString(17); + this.tagNumber = resultSet.getString(18); + this.speciesFate = resultSet.getString(19); + this.sample_idx = resultSet.getInt(20); + this.lengthMeasureMethod = resultSet.getString(21); + this.weightMeasureMethod = resultSet.getString(22); + } + + } + + private void migrateSample(MigrationVersionResourceExecutor executor) { + + Map<String, Sample> setToSampleMap = new TreeMap<>(); + Map<String, String> sampleMapping = new TreeMap<>(); + + addSample(executor, setToSampleMap, sampleMapping, "SELECT REPLACE(topiaId, '.NonTargetSample', '.Sample'), topiaVersion, topiaCreateDate, homeId, substr(trim(comment), 0, 1024), set, lastUpdateDate FROM ps_observation.nontargetsample order by set, topiaId"); + + addSample(executor, setToSampleMap, sampleMapping, "SELECT REPLACE(topiaId, '.TargetSample', '.Sample'), topiaVersion, topiaCreateDate, homeId, substr(trim(comment), 0, 1024), set, lastUpdateDate FROM ps_observation.targetsample order by set, topiaId"); + + for (Sample sample : setToSampleMap.values()) { + executor.writeSql(String.format("INSERT INTO ps_observation.Sample(topiaId, topiaVersion, topiaCreateDate, homeId, comment, set, lastUpdateDate) VALUES('%s', %s, '%s'::timestamp, %s, %s, '%s', '%s'::timestamp);", + sample.topiaId, + sample.topiaVersion, + sample.topiaCreateDate, + DataDtoEntityContext.escapeString(sample.homeId), + DataDtoEntityContext.escapeComment(sample.comment), + sample.set, + sample.lastUpdateDate + )); + } + + migrateSampleMeasure(executor, sampleMapping); + } + + private void migrateSampleMeasure(MigrationVersionResourceExecutor executor, Map<String, String> sampleMapping) { + // nonTargetSampleMeasure + addSampleMeasure(executor, sampleMapping, "SELECT " + + "REPLACE(topiaId, '.NonTargetLength', '.SampleMeasure'), " + + "topiaVersion + 1, " + + "topiaCreateDate, " + + "homeId, " + + "length, " + + "isLengthComputed, " + + "picturesReferences, " + + "weight, " + + "isWeightComputed, " + + "count, " + + "acquisitionMode, " + + "species, " + + "REPLACE(nonTargetSample, '.NonTargetSample', '.Sample'), " + + "sex, " + + "lastUpdateDate, " + + "sizeMeasureType, " + + "weightMeasureType, " + + "tagNumber, " + + "speciesFate, " + + "nonTargetSample_idx, " + + "lengthMeasureMethod, " + + "weightMeasureMethod " + + "FROM ps_observation.NonTargetLength"); + + // discardedTargetSampleMeasure + addSampleMeasure(executor, sampleMapping, "SELECT " + + "REPLACE(tl.topiaId, '.TargetLength', '.SampleMeasure'), " + + "tl.topiaVersion + 1, " + + "tl.topiaCreateDate, " + + "tl.homeId, " + + "tl.length, " + + "tl.isLengthComputed, " + + "NULL, " + + "tl.weight, " + + "tl.isWeightComputed, " + + "tl.count, " + + "tl.acquisitionMode, " + + "tl.species, " + + "REPLACE(tl.targetSample, '.TargetSample', '.Sample'), " + + "'fr.ird.referential.common.Sex#1239832686121#0.0', " + + "tl.lastUpdateDate, " + + "tl.sizeMeasureType, " + + "tl.weightMeasureType, " + + "tl.tagNumber, " + + "'fr.ird.referential.ps.common.SpeciesFate#1239832683619#0.6250731662108877', " + + "-tl.targetsample_idx, " + + "tl.lengthMeasureMethod, " + + "tl.weightMeasureMethod " + + "FROM ps_observation.TargetSample ts " + + "INNER JOIN ps_observation.TargetLength tl ON (tl.targetSample=ts.topiaId) " + + "WHERE ts.discarded"); + + // notDiscardedTargetSampleMeasure + addSampleMeasure(executor, sampleMapping, "SELECT " + + "REPLACE(tl.topiaId, '.TargetLength', '.SampleMeasure'), " + + "tl.topiaVersion + 1, " + + "tl.topiaCreateDate, " + + "tl.homeId, " + + "tl.length, " + + "tl.isLengthComputed, " + + "NULL, " + + "tl.weight, " + + "tl.isWeightComputed, " + + "tl.count, " + + "tl.acquisitionMode, " + + "tl.species, " + + "REPLACE(tl.targetSample, '.TargetSample', '.Sample'), " + + "'fr.ird.referential.common.Sex#1239832686121#0.0', " + + "tl.lastUpdateDate, " + + "tl.sizeMeasureType, " + + "tl.weightMeasureType, " + + "tl.tagNumber, " + + "'fr.ird.referential.ps.common.SpeciesFate#1239832683619#0.5722739932065866', " + + "-tl.targetsample_idx, " + + "tl.lengthMeasureMethod, " + + "tl.weightMeasureMethod " + + "FROM ps_observation.TargetSample ts " + + "INNER JOIN ps_observation.TargetLength tl ON (tl.targetSample=ts.topiaId) " + + "WHERE NOT ts.discarded"); + } + + private void addSample(MigrationVersionResourceExecutor executor, Map<String, Sample> setToSampleMap, Map<String, String> sampleMapping, String query) { + List<Sample> targetSample = executor.findMultipleResult(SqlQuery.wrap(query, Sample::new)); + for (Sample sample : targetSample) { + Sample existingSample = setToSampleMap.get(sample.set); + if (existingSample == null) { + // new sample + setToSampleMap.put(sample.set, sample); + } else { + // add to sample mapping + sampleMapping.put(sample.topiaId, existingSample.topiaId); + // update homeId + existingSample.addHomeId(sample.homeId); + // update comment + existingSample.addComment(sample.comment); + } + } + } + + private void addSampleMeasure(MigrationVersionResourceExecutor executor, Map<String, String> sampleMapping, String query) { + List<SampleMeasure> sampleMeasureList = executor.findMultipleResult(SqlQuery.wrap(query, SampleMeasure::new)); + for (SampleMeasure sampleMeasure : sampleMeasureList) { + String sampleId = sampleMapping.get(sampleMeasure.sample); + if (sampleId == null) { + sampleId = sampleMeasure.sample; + } + executor.writeSql(String.format("INSERT INTO ps_observation.SampleMeasure(" + + " topiaId," + + " topiaVersion," + + " topiaCreateDate," + + " homeId," + + " length," + + " isLengthComputed," + + " picturesReferences," + + " weight," + + " isWeightComputed," + + " count," + + " acquisitionMode," + + " species," + + " sample," + + " sex," + + " lastUpdateDate," + + " sizeMeasureType," + + " weightMeasureType," + + " tagNumber," + + " speciesFate," + + " sample_idx," + + " lengthMeasureMethod," + + " weightMeasureMethod)" + + " VALUES(" + + "'%s', " + + "%s, " + + "'%s'::timestamp, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "'%s', " + + "%s, " + + "'%s'::timestamp, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s " + + ");", + sampleMeasure.topiaId, + sampleMeasure.topiaVersion, + sampleMeasure.topiaCreateDate, + DataDtoEntityContext.escapeString(sampleMeasure.homeId == null ? null : sampleMeasure.homeId.replaceAll("'", "")), + sampleMeasure.length, + sampleMeasure.isLengthComputed, + DataDtoEntityContext.escapeString(sampleMeasure.picturesReferences == null ? null : sampleMeasure.picturesReferences.replaceAll("'", "")), + sampleMeasure.weight, + sampleMeasure.isWeightComputed, + sampleMeasure.count, + sampleMeasure.acquisitionMode, + DataDtoEntityContext.escapeString(sampleMeasure.species), + sampleId, + DataDtoEntityContext.escapeString(sampleMeasure.sex), + sampleMeasure.lastUpdateDate, + DataDtoEntityContext.escapeString(sampleMeasure.sizeMeasureType), + DataDtoEntityContext.escapeString(sampleMeasure.weightMeasureType), + DataDtoEntityContext.escapeString(sampleMeasure.tagNumber), + DataDtoEntityContext.escapeString(sampleMeasure.speciesFate), + sampleMeasure.sample_idx, + DataDtoEntityContext.escapeString(sampleMeasure.lengthMeasureMethod), + DataDtoEntityContext.escapeString(sampleMeasure.weightMeasureMethod) + )); + } + } + @Override public void generateFinalizeSqlScript(MigrationVersionResourceExecutor executor) { migrateIdx(executor, "ps_observation", "catch", "set"); ===================================== core/persistence/resources/src/main/resources/db/migration/v9/9.0/03_fill-table-ps_observation_sample-common.sql ===================================== @@ -20,14 +20,6 @@ -- #L% --- -INSERT INTO ps_observation.Sample(topiaId, topiaVersion, topiaCreateDate, homeId, comment, set, lastUpdateDate) SELECT REPLACE(topiaId, '.NonTargetSample', '.Sample'), topiaVersion, topiaCreateDate, homeId, substr(trim(comment), 0, 1024), set, lastUpdateDate FROM ps_observation.nontargetsample; -INSERT INTO ps_observation.Sample(topiaId, topiaVersion, topiaCreateDate, homeId, comment, set, lastUpdateDate) SELECT REPLACE(topiaId, '.TargetSample', '.Sample'), topiaVersion, topiaCreateDate, homeId, substr(trim(comment), 0, 1024), set, lastUpdateDate FROM ps_observation.TargetSample; - - -INSERT INTO ps_observation.SampleMeasure(topiaId, topiaVersion, topiaCreateDate, homeId, length, isLengthComputed, picturesReferences, weight, isWeightComputed, count, acquisitionMode, species, sample, sex, lastUpdateDate, sizeMeasureType,weightMeasureType, tagNumber, speciesFate, sample_idx, lengthMeasureMethod, weightMeasureMethod) SELECT REPLACE(topiaId, '.NonTargetLength', '.SampleMeasure'), topiaVersion + 1, topiaCreateDate, homeId, length, isLengthComputed, picturesReferences, weight, isWeightComputed, count, acquisitionMode, species, REPLACE(nonTargetSample, '.NonTargetSample', '.Sample'), sex, lastUpdateDate, sizeMeasureType, weightMeasureType, tagNumber, speciesFate, nonTargetSample_idx, lengthMeasureMethod, weightMeasureMethod FROM ps_observation.NonTargetLength; -INSERT INTO ps_observation.SampleMeasure(topiaId, topiaVersion, topiaCreateDate, homeId, length, isLengthComputed, weight, isWeightComputed, count, acquisitionMode, species, sample, sex, lastUpdateDate, sizeMeasureType, weightMeasureType,tagNumber, speciesFate, sample_idx, lengthMeasureMethod, weightMeasureMethod) SELECT REPLACE(tl.topiaId, '.TargetLength', '.SampleMeasure'), tl.topiaVersion + 1, tl.topiaCreateDate, tl.homeId, tl.length, tl.isLengthComputed, tl.weight, tl.isWeightComputed, tl.count, tl.acquisitionMode, tl.species, REPLACE(tl.targetSample, '.TargetSample', '.Sample'), 'fr.ird.referential.common.Sex#1239832686121#0.0', tl.lastUpdateDate, tl.sizeMeasureType, tl.weightMeasureType, tl.tagNumber, 'fr.ird.referential.ps.common.SpeciesFate#1239832683619#0.6250731662108877', -tl.targetsample_idx, tl.lengthMeasureMethod, tl.weightMeasureMethod FROM ps_observation.TargetSample ts INNER JOIN ps_observation.TargetLength tl ON (tl.targetSample=ts.topiaId) WHERE ts.discarded; -INSERT INTO ps_observation.SampleMeasure(topiaId, topiaVersion, topiaCreateDate, homeId, length, isLengthComputed, weight, isWeightComputed, count, acquisitionMode, species, sample, sex, lastUpdateDate, sizeMeasureType, weightMeasureType,tagNumber, speciesFate, sample_idx, lengthMeasureMethod, weightMeasureMethod) SELECT REPLACE(tl.topiaId, '.TargetLength', '.SampleMeasure'), tl.topiaVersion + 1, tl.topiaCreateDate, tl.homeId, tl.length, tl.isLengthComputed, tl.weight, tl.isWeightComputed, tl.count, tl.acquisitionMode, tl.species, REPLACE(tl.targetSample, '.TargetSample', '.Sample'), 'fr.ird.referential.common.Sex#1239832686121#0.0', tl.lastUpdateDate, tl.sizeMeasureType, tl.weightMeasureType, tl.tagNumber, 'fr.ird.referential.ps.common.SpeciesFate#1239832683619#0.5722739932065866', -tl.targetsample_idx, tl.lengthMeasureMethod, tl.weightMeasureMethod FROM ps_observation.TargetSample ts INNER JOIN ps_observation.TargetLength tl ON (tl.targetSample=ts.topiaId) WHERE NOT ts.discarded; - UPDATE common.LastUpdateDate SET TYPE = REPLACE(TYPE, '.NonTargetSample', '.Sample') WHERE type = 'fr.ird.observe.entities.data.ps.observation.NonTargetSample'; DELETE from common.LastUpdateDate WHERE TYPE LIKE ('%.TargetSample'); UPDATE common.LastUpdateDate SET TYPE = REPLACE(TYPE, '.NonTargetLength', '.SampleMeasure') WHERE type = 'fr.ird.observe.entities.data.ps.observation.NonTargetLength'; View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/3131da07db0e270eff5c3fea6… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/3131da07db0e270eff5c3fea6… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] Souci d'affichage (probablement d'index) dans les échantillons PS après migration V9 - Closes #2436
by Tony CHEMIT (＠tchemit) 30 Sep '22

30 Sep '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: a7e0a558 by Tony Chemit at 2022-09-30T17:56:36+02:00 Souci d'affichage (probablement d'index) dans les échantillons PS après migration V9 - Closes #2436 - - - - - 2 changed files: - core/persistence/resources/src/main/java/fr/ird/observe/spi/migration/v9/DataSourceMigrationForVersion_9_0.java - core/persistence/resources/src/main/resources/db/migration/v9/9.0/03_fill-table-ps_observation_sample-common.sql Changes: ===================================== core/persistence/resources/src/main/java/fr/ird/observe/spi/migration/v9/DataSourceMigrationForVersion_9_0.java ===================================== @@ -23,6 +23,7 @@ package fr.ird.observe.spi.migration.v9; */ import com.google.auto.service.AutoService; +import fr.ird.observe.spi.context.DataDtoEntityContext; import fr.ird.observe.spi.migration.ByMajorMigrationVersionResource; import io.ultreia.java4all.util.Version; import io.ultreia.java4all.util.sql.SqlQuery; @@ -32,9 +33,13 @@ import org.apache.logging.log4j.Logger; import org.nuiton.topia.service.migration.resources.MigrationVersionResource; import org.nuiton.topia.service.migration.resources.MigrationVersionResourceExecutor; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.sql.Timestamp; import java.util.List; import java.util.Map; import java.util.Set; +import java.util.TreeMap; /** * Created on 19/01/2021. @@ -124,6 +129,11 @@ public class DataSourceMigrationForVersion_9_0 extends ByMajorMigrationVersionRe addNewTable(executor, withIds, "03", "table-ps_observation_catch", "table-ps_observation_sample"); + if (withIds) { + // See https://gitlab.com/ultreiaio/ird-observe/-/issues/2436 + migrateSample(executor); + } + executor.addScript("04_0", "adapt_table-ps_observation_activity"); executor.addScript("04_1", "adapt_table-ps_observation_set"); @@ -189,6 +199,310 @@ public class DataSourceMigrationForVersion_9_0 extends ByMajorMigrationVersionRe } } + static class Sample { + String topiaId; + long topiaVersion; + Timestamp topiaCreateDate; + Timestamp lastUpdateDate; + String homeId; + String comment; + String set; + + public Sample(ResultSet resultSet) throws SQLException { + this.topiaId = resultSet.getString(1); + this.topiaVersion = resultSet.getLong(2); + this.topiaCreateDate = resultSet.getTimestamp(3); + this.homeId = resultSet.getString(4); + this.comment = resultSet.getString(5); + this.set = resultSet.getString(6); + this.lastUpdateDate = resultSet.getTimestamp(7); + } + + public void addHomeId(String homeId) { + if (homeId == null) { + return; + } + if (this.homeId == null) { + this.homeId = homeId; + return; + } + this.homeId += " - " + homeId; + } + + public void addComment(String comment) { + if (comment == null) { + return; + } + if (this.comment == null) { + this.comment = comment; + return; + } + this.comment += " - " + comment; + } + + } + + + static class SampleMeasure { + String topiaId; + long topiaVersion; + Timestamp topiaCreateDate; + Timestamp lastUpdateDate; + String homeId; + Float length; + Boolean isLengthComputed; + String picturesReferences; + Float weight; + Boolean isWeightComputed; + int count; + int acquisitionMode; + String species; + String sample; + String sex; + String sizeMeasureType; + String weightMeasureType; + String tagNumber; + String speciesFate; + int sample_idx; + String lengthMeasureMethod; + String weightMeasureMethod; + + public SampleMeasure(ResultSet resultSet) throws SQLException { + this.topiaId = resultSet.getString(1); + this.topiaVersion = resultSet.getLong(2); + this.topiaCreateDate = resultSet.getTimestamp(3); + this.homeId = resultSet.getString(4); + this.length = resultSet.getFloat(5); + this.isLengthComputed = resultSet.getBoolean(6); + this.picturesReferences = resultSet.getString(7); + this.weight = resultSet.getFloat(8); + this.isWeightComputed = resultSet.getBoolean(9); + this.count = resultSet.getInt(10); + this.acquisitionMode = resultSet.getInt(11); + this.species = resultSet.getString(12); + this.sample = resultSet.getString(13); + this.sex = resultSet.getString(14); + this.lastUpdateDate = resultSet.getTimestamp(15); + this.sizeMeasureType = resultSet.getString(16); + this.weightMeasureType = resultSet.getString(17); + this.tagNumber = resultSet.getString(18); + this.speciesFate = resultSet.getString(19); + this.sample_idx = resultSet.getInt(20); + this.lengthMeasureMethod = resultSet.getString(21); + this.weightMeasureMethod = resultSet.getString(22); + } + + } + + private void migrateSample(MigrationVersionResourceExecutor executor) { + + Map<String, Sample> setToSampleMap = new TreeMap<>(); + Map<String, String> sampleMapping = new TreeMap<>(); + + addSample(executor, setToSampleMap, sampleMapping, "SELECT REPLACE(topiaId, '.NonTargetSample', '.Sample'), topiaVersion, topiaCreateDate, homeId, substr(trim(comment), 0, 1024), set, lastUpdateDate FROM ps_observation.nontargetsample order by set, topiaId"); + + addSample(executor, setToSampleMap, sampleMapping, "SELECT REPLACE(topiaId, '.TargetSample', '.Sample'), topiaVersion, topiaCreateDate, homeId, substr(trim(comment), 0, 1024), set, lastUpdateDate FROM ps_observation.targetsample order by set, topiaId"); + + //fr.ird.data.ps.observation.Set#1307366814753#0.10928986819912401 + //fr.ird.data.ps.observation.Sample#1307366814761#0.8029664353471644 + for (Sample sample : setToSampleMap.values()) { + executor.writeSql(String.format("INSERT INTO ps_observation.Sample(topiaId, topiaVersion, topiaCreateDate, homeId, comment, set, lastUpdateDate) VALUES('%s', %s, '%s'::timestamp, %s, %s, '%s', '%s'::timestamp);", + sample.topiaId, + sample.topiaVersion, + sample.topiaCreateDate, + DataDtoEntityContext.escapeString(sample.homeId), + DataDtoEntityContext.escapeComment(sample.comment), + sample.set, + sample.lastUpdateDate + )); + } + + migrateSampleMeasure(executor, sampleMapping); + } + + private void migrateSampleMeasure(MigrationVersionResourceExecutor executor, Map<String, String> sampleMapping) { + // nonTargetSampleMeasure + addSampleMeasure(executor, sampleMapping, "SELECT " + + "REPLACE(topiaId, '.NonTargetLength', '.SampleMeasure'), " + + "topiaVersion + 1, " + + "topiaCreateDate, " + + "homeId, " + + "length, " + + "isLengthComputed, " + + "picturesReferences, " + + "weight, " + + "isWeightComputed, " + + "count, " + + "acquisitionMode, " + + "species, " + + "REPLACE(nonTargetSample, '.NonTargetSample', '.Sample'), " + + "sex, " + + "lastUpdateDate, " + + "sizeMeasureType, " + + "weightMeasureType, " + + "tagNumber, " + + "speciesFate, " + + "nonTargetSample_idx, " + + "lengthMeasureMethod, " + + "weightMeasureMethod " + + "FROM ps_observation.NonTargetLength"); + + // discardedTargetSampleMeasure + addSampleMeasure(executor, sampleMapping, "SELECT " + + "REPLACE(tl.topiaId, '.TargetLength', '.SampleMeasure'), " + + "tl.topiaVersion + 1, " + + "tl.topiaCreateDate, " + + "tl.homeId, " + + "tl.length, " + + "tl.isLengthComputed, " + + "NULL, " + + "tl.weight, " + + "tl.isWeightComputed, " + + "tl.count, " + + "tl.acquisitionMode, " + + "tl.species, " + + "REPLACE(tl.targetSample, '.TargetSample', '.Sample'), " + + "'fr.ird.referential.common.Sex#1239832686121#0.0', " + + "tl.lastUpdateDate, " + + "tl.sizeMeasureType, " + + "tl.weightMeasureType, " + + "tl.tagNumber, " + + "'fr.ird.referential.ps.common.SpeciesFate#1239832683619#0.6250731662108877', " + + "-tl.targetsample_idx, " + + "tl.lengthMeasureMethod, " + + "tl.weightMeasureMethod " + + "FROM ps_observation.TargetSample ts " + + "INNER JOIN ps_observation.TargetLength tl ON (tl.targetSample=ts.topiaId) " + + "WHERE ts.discarded"); + + // notDiscardedTargetSampleMeasure + addSampleMeasure(executor, sampleMapping, "SELECT " + + "REPLACE(tl.topiaId, '.TargetLength', '.SampleMeasure'), " + + "tl.topiaVersion + 1, " + + "tl.topiaCreateDate, " + + "tl.homeId, " + + "tl.length, " + + "tl.isLengthComputed, " + + "NULL, " + + "tl.weight, " + + "tl.isWeightComputed, " + + "tl.count, " + + "tl.acquisitionMode, " + + "tl.species, " + + "REPLACE(tl.targetSample, '.TargetSample', '.Sample'), " + + "'fr.ird.referential.common.Sex#1239832686121#0.0', " + + "tl.lastUpdateDate, " + + "tl.sizeMeasureType, " + + "tl.weightMeasureType, " + + "tl.tagNumber, " + + "'fr.ird.referential.ps.common.SpeciesFate#1239832683619#0.5722739932065866', " + + "-tl.targetsample_idx, " + + "tl.lengthMeasureMethod, " + + "tl.weightMeasureMethod " + + "FROM ps_observation.TargetSample ts " + + "INNER JOIN ps_observation.TargetLength tl ON (tl.targetSample=ts.topiaId) " + + "WHERE NOT ts.discarded"); + } + + private void addSample(MigrationVersionResourceExecutor executor, Map<String, Sample> setToSampleMap, Map<String, String> sampleMapping, String query) { + List<Sample> targetSample = executor.findMultipleResult(SqlQuery.wrap(query, Sample::new)); + for (Sample sample : targetSample) { + Sample existingSample = setToSampleMap.get(sample.set); + if (existingSample == null) { + // new sample + setToSampleMap.put(sample.set, sample); +// sampleMapping.put(sample.topiaId, sample.topiaId); + } else { + // add to sample mapping + sampleMapping.put(sample.topiaId, existingSample.topiaId); + // update homeId + existingSample.addHomeId(sample.homeId); + // update comment + existingSample.addComment(sample.comment); + } + } + } + + private void addSampleMeasure(MigrationVersionResourceExecutor executor, Map<String, String> sampleMapping, String query) { + List<SampleMeasure> sampleMeasureList = executor.findMultipleResult(SqlQuery.wrap(query, SampleMeasure::new)); + for (SampleMeasure sampleMeasure : sampleMeasureList) { + String sampleId = sampleMapping.get(sampleMeasure.sample); + if (sampleId == null) { + sampleId = sampleMeasure.sample; + } + executor.writeSql(String.format("INSERT INTO ps_observation.SampleMeasure(" + + " topiaId," + + " topiaVersion," + + " topiaCreateDate," + + " homeId," + + " length," + + " isLengthComputed," + + " picturesReferences," + + " weight," + + " isWeightComputed," + + " count," + + " acquisitionMode," + + " species," + + " sample," + + " sex," + + " lastUpdateDate," + + " sizeMeasureType," + + " weightMeasureType," + + " tagNumber," + + " speciesFate," + + " sample_idx," + + " lengthMeasureMethod," + + " weightMeasureMethod)" + + " VALUES(" + + "'%s', " + + "%s, " + + "'%s'::timestamp, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "'%s', " + + "%s, " + + "'%s'::timestamp, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s, " + + "%s " + + ");", + sampleMeasure.topiaId, + sampleMeasure.topiaVersion, + sampleMeasure.topiaCreateDate, + DataDtoEntityContext.escapeString(sampleMeasure.homeId == null ? null : sampleMeasure.homeId.replaceAll("'", "")), + sampleMeasure.length, + sampleMeasure.isLengthComputed, + DataDtoEntityContext.escapeString(sampleMeasure.picturesReferences == null ? null : sampleMeasure.picturesReferences.replaceAll("'", "")), + sampleMeasure.weight, + sampleMeasure.isWeightComputed, + sampleMeasure.count, + sampleMeasure.acquisitionMode, + DataDtoEntityContext.escapeString(sampleMeasure.species), + sampleId, + DataDtoEntityContext.escapeString(sampleMeasure.sex), + sampleMeasure.lastUpdateDate, + DataDtoEntityContext.escapeString(sampleMeasure.sizeMeasureType), + DataDtoEntityContext.escapeString(sampleMeasure.weightMeasureType), + DataDtoEntityContext.escapeString(sampleMeasure.tagNumber), + DataDtoEntityContext.escapeString(sampleMeasure.speciesFate), + sampleMeasure.sample_idx, + DataDtoEntityContext.escapeString(sampleMeasure.lengthMeasureMethod), + DataDtoEntityContext.escapeString(sampleMeasure.weightMeasureMethod) + )); + } + } + @Override public void generateFinalizeSqlScript(MigrationVersionResourceExecutor executor) { migrateIdx(executor, "ps_observation", "catch", "set"); ===================================== core/persistence/resources/src/main/resources/db/migration/v9/9.0/03_fill-table-ps_observation_sample-common.sql ===================================== @@ -20,14 +20,6 @@ -- #L% --- -INSERT INTO ps_observation.Sample(topiaId, topiaVersion, topiaCreateDate, homeId, comment, set, lastUpdateDate) SELECT REPLACE(topiaId, '.NonTargetSample', '.Sample'), topiaVersion, topiaCreateDate, homeId, substr(trim(comment), 0, 1024), set, lastUpdateDate FROM ps_observation.nontargetsample; -INSERT INTO ps_observation.Sample(topiaId, topiaVersion, topiaCreateDate, homeId, comment, set, lastUpdateDate) SELECT REPLACE(topiaId, '.TargetSample', '.Sample'), topiaVersion, topiaCreateDate, homeId, substr(trim(comment), 0, 1024), set, lastUpdateDate FROM ps_observation.TargetSample; - - -INSERT INTO ps_observation.SampleMeasure(topiaId, topiaVersion, topiaCreateDate, homeId, length, isLengthComputed, picturesReferences, weight, isWeightComputed, count, acquisitionMode, species, sample, sex, lastUpdateDate, sizeMeasureType,weightMeasureType, tagNumber, speciesFate, sample_idx, lengthMeasureMethod, weightMeasureMethod) SELECT REPLACE(topiaId, '.NonTargetLength', '.SampleMeasure'), topiaVersion + 1, topiaCreateDate, homeId, length, isLengthComputed, picturesReferences, weight, isWeightComputed, count, acquisitionMode, species, REPLACE(nonTargetSample, '.NonTargetSample', '.Sample'), sex, lastUpdateDate, sizeMeasureType, weightMeasureType, tagNumber, speciesFate, nonTargetSample_idx, lengthMeasureMethod, weightMeasureMethod FROM ps_observation.NonTargetLength; -INSERT INTO ps_observation.SampleMeasure(topiaId, topiaVersion, topiaCreateDate, homeId, length, isLengthComputed, weight, isWeightComputed, count, acquisitionMode, species, sample, sex, lastUpdateDate, sizeMeasureType, weightMeasureType,tagNumber, speciesFate, sample_idx, lengthMeasureMethod, weightMeasureMethod) SELECT REPLACE(tl.topiaId, '.TargetLength', '.SampleMeasure'), tl.topiaVersion + 1, tl.topiaCreateDate, tl.homeId, tl.length, tl.isLengthComputed, tl.weight, tl.isWeightComputed, tl.count, tl.acquisitionMode, tl.species, REPLACE(tl.targetSample, '.TargetSample', '.Sample'), 'fr.ird.referential.common.Sex#1239832686121#0.0', tl.lastUpdateDate, tl.sizeMeasureType, tl.weightMeasureType, tl.tagNumber, 'fr.ird.referential.ps.common.SpeciesFate#1239832683619#0.6250731662108877', -tl.targetsample_idx, tl.lengthMeasureMethod, tl.weightMeasureMethod FROM ps_observation.TargetSample ts INNER JOIN ps_observation.TargetLength tl ON (tl.targetSample=ts.topiaId) WHERE ts.discarded; -INSERT INTO ps_observation.SampleMeasure(topiaId, topiaVersion, topiaCreateDate, homeId, length, isLengthComputed, weight, isWeightComputed, count, acquisitionMode, species, sample, sex, lastUpdateDate, sizeMeasureType, weightMeasureType,tagNumber, speciesFate, sample_idx, lengthMeasureMethod, weightMeasureMethod) SELECT REPLACE(tl.topiaId, '.TargetLength', '.SampleMeasure'), tl.topiaVersion + 1, tl.topiaCreateDate, tl.homeId, tl.length, tl.isLengthComputed, tl.weight, tl.isWeightComputed, tl.count, tl.acquisitionMode, tl.species, REPLACE(tl.targetSample, '.TargetSample', '.Sample'), 'fr.ird.referential.common.Sex#1239832686121#0.0', tl.lastUpdateDate, tl.sizeMeasureType, tl.weightMeasureType, tl.tagNumber, 'fr.ird.referential.ps.common.SpeciesFate#1239832683619#0.5722739932065866', -tl.targetsample_idx, tl.lengthMeasureMethod, tl.weightMeasureMethod FROM ps_observation.TargetSample ts INNER JOIN ps_observation.TargetLength tl ON (tl.targetSample=ts.topiaId) WHERE NOT ts.discarded; - UPDATE common.LastUpdateDate SET TYPE = REPLACE(TYPE, '.NonTargetSample', '.Sample') WHERE type = 'fr.ird.observe.entities.data.ps.observation.NonTargetSample'; DELETE from common.LastUpdateDate WHERE TYPE LIKE ('%.TargetSample'); UPDATE common.LastUpdateDate SET TYPE = REPLACE(TYPE, '.NonTargetLength', '.SampleMeasure') WHERE type = 'fr.ird.observe.entities.data.ps.observation.NonTargetLength'; View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/a7e0a558d25b21fc6daae53cd… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/a7e0a558d25b21fc6daae53cd… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][develop] 5 commits: L'assistant sécurité 9.0.7 ne fonctionne plus - Closes #2431
by Tony CHEMIT (＠tchemit) 30 Sep '22

30 Sep '22

Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 3cc0792d by Tony Chemit at 2022-09-30T13:20:55+02:00 L'assistant sécurité 9.0.7 ne fonctionne plus - Closes #2431 - - - - - e5e18144 by Tony Chemit at 2022-09-30T13:20:55+02:00 update hibernate - - - - - b77e0641 by Tony Chemit at 2022-09-30T13:20:55+02:00 update slf4j and pom - - - - - f0b7e8a9 by Tony Chemit at 2022-09-30T13:20:55+02:00 update jts - - - - - c49a8b4f by Tony Chemit at 2022-09-30T13:25:52+02:00 L'assistant sécurité 9.0.7 ne fonctionne plus - See #2431 (add SecurityHelper in log info) - - - - - 23 changed files: - client/configuration/pom.xml - client/configuration/src/main/filtered-resources/observe-log4j2.xml - client/datasource/actions/pom.xml - client/datasource/editor/api/pom.xml - client/runner/pom.xml - core/api/dto/pom.xml - core/api/tree/pom.xml - core/api/validation/pom.xml - core/persistence/java/pom.xml - core/persistence/test/pom.xml - core/services/client/pom.xml - core/services/local/pom.xml - model/src/main/resources/log4j2.xml - pom.xml - server/configuration-tools/pom.xml - server/configuration/pom.xml - server/core/pom.xml - server/runner/src/main/resources/META-INF/configuration/log.xml - toolkit/api/pom.xml - toolkit/persistence/pom.xml - toolkit/persistence/src/main/java/org/nuiton/topia/persistence/security/SecurityScriptHelper.java - toolkit/plugin/pom.xml - toolkit/templates/pom.xml Changes: ===================================== client/configuration/pom.xml ===================================== @@ -140,7 +140,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> </dependencies> ===================================== client/configuration/src/main/filtered-resources/observe-log4j2.xml ===================================== @@ -127,6 +127,10 @@ <AppenderRef ref="console"/> <AppenderRef ref="File"/> </Logger> + <Logger name="org.nuiton.topia.persistence.security.SecurityScriptHelper" level="info" additivity="false"> + <AppenderRef ref="console"/> + <AppenderRef ref="File"/> + </Logger> <Logger name="org.nuiton.topia.persistence.TopiaApplicationContextFactory" level="info" additivity="false"> <AppenderRef ref="console"/> <AppenderRef ref="File"/> ===================================== client/datasource/actions/pom.xml ===================================== @@ -141,7 +141,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>runtime</scope> </dependency> <dependency> ===================================== client/datasource/editor/api/pom.xml ===================================== @@ -208,7 +208,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>runtime</scope> </dependency> <dependency> ===================================== client/runner/pom.xml ===================================== @@ -116,7 +116,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>runtime</scope> </dependency> <dependency> ===================================== core/api/dto/pom.xml ===================================== @@ -122,7 +122,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>runtime</scope> </dependency> <dependency> ===================================== core/api/tree/pom.xml ===================================== @@ -83,7 +83,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> <dependency> ===================================== core/api/validation/pom.xml ===================================== @@ -104,7 +104,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> <dependency> @@ -196,17 +196,17 @@ <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-core</artifactId> - <version>${lib.version.log4j2.eugene}</version> + <version>${lib.version.log4j2}</version> </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-jcl</artifactId> - <version>${lib.version.log4j2.eugene}</version> + <version>${lib.version.log4j2}</version> </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j-impl</artifactId> - <version>${lib.version.log4j2.eugene}</version> + <artifactId>log4j-slf4j2-impl</artifactId> + <version>${lib.version.log4j2}</version> </dependency> </dependencies> </plugin> ===================================== core/persistence/java/pom.xml ===================================== @@ -183,7 +183,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> </dependencies> ===================================== core/persistence/test/pom.xml ===================================== @@ -84,7 +84,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>runtime</scope> </dependency> <dependency> ===================================== core/services/client/pom.xml ===================================== @@ -238,7 +238,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> </dependencies> ===================================== core/services/local/pom.xml ===================================== @@ -146,7 +146,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> </dependencies> ===================================== model/src/main/resources/log4j2.xml ===================================== @@ -51,6 +51,9 @@ <Logger name="org.nuiton.topia.persistence.TopiaApplicationContextFactory" level="info" additivity="false"> <AppenderRef ref="console"/> </Logger> + <Logger name="org.nuiton.topia.persistence.security.SecurityScriptHelper" level="info" additivity="false"> + <AppenderRef ref="console"/> + </Logger> <Root level="warn"> <AppenderRef ref="console"/> </Root> ===================================== pom.xml ===================================== @@ -23,7 +23,7 @@ <parent> <groupId>io.ultreia.maven</groupId> <artifactId>pom</artifactId> - <version>2022.85</version> + <version>2022.87</version> </parent> <groupId>fr.ird.observe</groupId> <artifactId>ird-observe</artifactId> @@ -119,17 +119,16 @@ <lib.version.h2>1.4.196</lib.version.h2>   - <lib.version.hibernate>5.6.11.Final</lib.version.hibernate> + <lib.version.hibernate>5.6.12.Final</lib.version.hibernate>  <lib.version.jaxb-api>2.4.0-b180830.0359</lib.version.jaxb-api> <lib.version.jaxb-runtime>2.4.0-b180830.0438</lib.version.jaxb-runtime>   - <lib.version.jts>1.16.0</lib.version.jts> + <lib.version.jts>1.16.1</lib.version.jts>   <lib.version.java4all.eugene>3.0-alpha-42</lib.version.java4all.eugene> - <lib.version.log4j2.eugene>2.17.2</lib.version.log4j2.eugene>  <license.licenseName>gpl_v3</license.licenseName> <license.organizationName>IRD, Ultreia.io</license.organizationName> @@ -554,12 +553,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j-impl</artifactId> - <version>${lib.version.log4j2}</version> - </dependency> - <dependency> - <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <version>${lib.version.log4j2}</version> </dependency> <dependency> @@ -1105,22 +1099,22 @@ <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-api</artifactId> - <version>${lib.version.log4j2.eugene}</version> + <version>${lib.version.log4j2}</version> </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-core</artifactId> - <version>${lib.version.log4j2.eugene}</version> + <version>${lib.version.log4j2}</version> </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-jcl</artifactId> - <version>${lib.version.log4j2.eugene}</version> + <version>${lib.version.log4j2}</version> </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j-impl</artifactId> - <version>${lib.version.log4j2.eugene}</version> + <artifactId>log4j-slf4j2-impl</artifactId> + <version>${lib.version.log4j2}</version> </dependency> </dependencies> </plugin> ===================================== server/configuration-tools/pom.xml ===================================== @@ -76,7 +76,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>runtime</scope> </dependency> <dependency> ===================================== server/configuration/pom.xml ===================================== @@ -86,7 +86,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> </dependencies> ===================================== server/core/pom.xml ===================================== @@ -133,7 +133,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>runtime</scope> </dependency> <dependency> ===================================== server/runner/src/main/resources/META-INF/configuration/log.xml ===================================== @@ -98,6 +98,10 @@ <AppenderRef ref="console"/> <AppenderRef ref="File"/> </Logger> + <Logger name="org.nuiton.topia.persistence.security.SecurityScriptHelper" level="info" additivity="false"> + <AppenderRef ref="console"/> + <AppenderRef ref="File"/> + </Logger> <Root level="error"> <AppenderRef ref="console"/> <AppenderRef ref="File"/> ===================================== toolkit/api/pom.xml ===================================== @@ -176,7 +176,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> </dependencies> ===================================== toolkit/persistence/pom.xml ===================================== @@ -119,7 +119,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> <dependency> ===================================== toolkit/persistence/src/main/java/org/nuiton/topia/persistence/security/SecurityScriptHelper.java ===================================== @@ -180,7 +180,7 @@ public class SecurityScriptHelper { throw new TopiaException(String.format("Can't generate security script at %s", scriptPath), e); } try { - securityHelper.jdbcHelper().consume(SqlScriptConsumer.of(scriptPath)); + securityHelper.jdbcHelper().consume(SqlScriptConsumer.builder(scriptPath).commit().build()); } catch (SQLException e) { throw new TopiaException(String.format("Can't consume security script at %s", scriptPath), e); } ===================================== toolkit/plugin/pom.xml ===================================== @@ -166,7 +166,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>runtime</scope> </dependency> <dependency> ===================================== toolkit/templates/pom.xml ===================================== @@ -134,7 +134,7 @@ </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j18-impl</artifactId> + <artifactId>log4j-slf4j2-impl</artifactId> <scope>test</scope> </dependency> </dependencies> View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/4ce9e6ac52ad147d94a738dc… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/compare/4ce9e6ac52ad147d94a738dc… You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe] Pushed new branch feature/ps_logbook_well_plan
by Tony CHEMIT (＠tchemit) 28 Sep '22

28 Sep '22

Tony CHEMIT pushed new branch feature/ps_logbook_well_plan at ultreiaio / ird-observe -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/tree/feature/ps_logbook_well_plan You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe] Deleted branch release/9.0.7
by Tony CHEMIT (＠tchemit) 11 Sep '22

11 Sep '22

Tony CHEMIT deleted branch release/9.0.7 at ultreiaio / ird-observe -- You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe] Pushed new tag v9.0.7
by Tony CHEMIT (＠tchemit) 11 Sep '22

11 Sep '22

Tony CHEMIT pushed new tag v9.0.7 at ultreiaio / ird-observe -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/tree/v9.0.7 You're receiving this email because of your account on gitlab.com.

1 0

[Git][ultreiaio/ird-observe][release/9.0.7] [jgitflow-maven-plugin]updating poms for branch'release/9.0.7' with non-snapshot versions[skip ci]
by Tony CHEMIT (＠tchemit) 11 Sep '22

11 Sep '22

Tony CHEMIT pushed to branch release/9.0.7 at ultreiaio / ird-observe Commits: 23a31041 by Tony Chemit at 2022-09-12T00:56:41+02:00 [jgitflow-maven-plugin]updating poms for branch'release/9.0.7' with non-snapshot versions[skip ci] - - - - - 30 changed files: - client/configuration/pom.xml - client/core/pom.xml - client/datasource/actions/pom.xml - client/datasource/editor/api-test/pom.xml - client/datasource/editor/api/pom.xml - client/datasource/editor/common/pom.xml - client/datasource/editor/ll/pom.xml - client/datasource/editor/pom.xml - client/datasource/editor/ps/pom.xml - client/datasource/editor/spi/pom.xml - client/datasource/pom.xml - client/pom.xml - client/runner/pom.xml - core/api/dto/pom.xml - core/api/pom.xml - core/api/services/pom.xml - core/api/tree/pom.xml - core/api/validation/pom.xml - core/persistence/java/pom.xml - core/persistence/pom.xml - core/persistence/resources/pom.xml - core/persistence/test/pom.xml - core/pom.xml - core/services/client/pom.xml - core/services/i18n/pom.xml - core/services/local/pom.xml - core/services/pom.xml - core/services/test/pom.xml - model/pom.xml - observe/pom.xml The diff was not included because it is too large. View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/23a31041ad19c29cbeef11371… -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/23a31041ad19c29cbeef11371… You're receiving this email because of your account on gitlab.com.

1 0