# ObServe changelog

  * Author [Tony Chemit](mailto:dev@tchemit.fr)

 ## Version [9.0.7](https://gitlab.com/ultreiaio/ird-observe/-/milestones/232)

 ### Issues

   * [[Type::Anomalie 2324]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2324) **Ouverture de base impossible selon configuration précédente de l'arbre** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Anomalie 2327]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2327) **Clé de libellé non traduite en anglais sur la page de synchrod e la synchro avancée** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Anomalie 2411]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2411) **HResponseErrorException / InvalidAuthenticationTokenException en 9.0.6 en quittant l'application** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Anomalie 2412]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2412) **Certains services sont encore en GET alors qu'ils devraient être en POST** (Thanks to Tony CHEMIT) (Reported by Tony CHEMIT)

   * [[Type::Anomalie 2416]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2416) **La boîte 'A propos' ne fontionne pas** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Anomalie 2419]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2419) **Erreur de migration de l'espèce AVDTH 8 de CAPT_ELEM vers ps_logbook.catch** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Anomalie 2420]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2420) **Statut de la doc de mapping des espèces AVDTH/ObServe** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Anomalie 2423]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2423) **Erreur calcul des données sur V9** (Thanks to Tony CHEMIT) (Reported by Philippe Sabarros)

   * [[Type::Anomalie 2427]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2427) **Erreur de type de mesure sur les échantillons AVDTH migrés** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Evolution 1751]](https://gitlab.com/ultreiaio/ird-observe/-/issues/1751) **Mettre un sablier lors de l'ouverture si le nœud a beaucoup de données à charger.** (Thanks to Tony CHEMIT) (Reported by Tony CHEMIT)

   * [[Type::Evolution 2104]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2104) **On pourrait avoir un service de génération de topiaid** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Evolution 2232]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2232) **Dans l'UI des profils de connexion, trimmer les espaces** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Evolution 2259]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2259) **Dans l'assistant rapport, ajouter un export CSV** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

   * [[Type::Evolution 2293]](https://gitlab.com/ultreiaio/ird-observe/-/issues/2293) **Il serait intéressant de permettre l'absence de base déclarée par défaut** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

         "from": "WHERE sampleActivity.sample %s",

         "parentColumnName": "sample",

         "columnNames": "topiaId,topiaCreateDate,topiaVersion,lastUpdateDate,homeId,weightedWeight,activity,sample",

         "requiredTypes": "ps_logbook.activity"

       },

       {

         "from": "WHERE sampleActivity.topiaId %s",

         "parentColumnName": "sample",

         "columnNames": "topiaId,topiaCreateDate,topiaVersion,lastUpdateDate,homeId,weightedWeight,activity,sample",

         "requiredTypes": "ps_logbook.activity",

         "entryPoint": true

       }

         "from": "WHERE wellPlan.topiaId %s",

         "parentColumnName": "trip",

         "columnNames": "topiaId,topiaCreateDate,topiaVersion,trip_idx,lastUpdateDate,homeId,well,weight,activity,species,weightCategory,wellSamplingConformity,wellSamplingStatus,trip",

         "requiredTypes": "ps_logbook.activity",

         "entryPoint": true

       }

   <parent>

     <groupId>io.ultreia.maven</groupId>

     <artifactId>pom</artifactId>

   </parent>

   <groupId>fr.ird.observe</groupId>

   <artifactId>ird-observe</artifactId>

     <lib.version.h2>1.4.196</lib.version.h2>

     <!-- FIXME can't use 1.4.197 (date has changed + blob also)-->

     <!-- FIXME   <lib.version.h2>2.1.210</lib.version.h2>-->

     <!-- FIXME    <lib.version.hibernate>6.1.0.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>

     TopiaEntitySqlBlobModel getBlobModel();

     Set<ReplicatePartialRequestCallback> getReplicatePartialRequestCallbacks();

     Set<ReplicateRequestCallback> getReplicateRequestCallbacks();

 public class DeletePartialEntityConsumer implements SqlRequestConsumer<DeletePartialEntityRequest> {

     public static final String DELETE_REVERSE_ASSOCIATION_STATEMENT = "UPDATE %1$s _main SET _main.%2$s = NULL WHERE _main.%2$s %3$s;";

     @Override

     public void consume(DeletePartialEntityRequest request, SqlRequestSetConsumerContext context) {

         TopiaEntitySqlDeletePlan deletePlan = request.getDeletePlan();

         SqlScriptWriter writer = context.getWriter();

         for (TopiaEntitySqlDeletePlanTask task : deletePlan) {

             if (task.accept(shell)) {

             }

         }

     }

         String deleteSql = task.getDeleteSql();

         String realDeleteSql = task.applyIds(deleteSql, ids);

         if (detachTasks != null) {

 import org.nuiton.topia.service.sql.internal.SqlRequestConsumer;

 import org.nuiton.topia.service.sql.internal.SqlRequestSetConsumerContext;

 import org.nuiton.topia.service.sql.internal.request.DuplicateEntityRequest;

 import org.nuiton.topia.service.sql.model.TopiaEntitySqlSelectArgument;

 import org.nuiton.topia.service.sql.plan.replicate.TopiaEntitySqlReplicatePlan;

 import org.nuiton.topia.service.sql.plan.replicate.TopiaEntitySqlReplicatePlanTask;

 import java.util.Set;

         this.columnNames = task.getColumnNames();

         String selectClause = SqlRequestConsumer.getSelectClause(task.getTableName(), columnNames);

         this.sql = TopiaEntitySqlReplicatePlanTask.applyIds(task.getSelectSql(), selectClause, ids);

         this.blobColumns = blobsBuilder.keySet();

         this.insertStatementSql = SqlRequestConsumer.newInsertStatementSql(task.getInsertSql(), columnNames, blobColumns);

         this.columnsToReplace = task.getColumnsToReplace();

         this.parentColumnName = parentColumnName;

         this.entryPoint = task.isEntryPoint();

         Set<String> shell = context.getShell();

         this.columnsToDetach = new LinkedHashSet<>();

         for (Map.Entry<String, String> entry : task.getColumnsToDetachSimple()) {

             }

         }

         this.recursiveProperty = task.getRecursiveColumnName().orElse(null);

         this.columnNames = task.getColumnNames();

         String selectClause = SqlRequestConsumer.getSelectClause(task.getTableName(), columnNames);

         this.sql = TopiaEntitySqlReplicatePlanTask.applyIds(partialTask.getCopyTask().getSelectSql(), selectClause, ids);

         this.blobColumns = blobsBuilder.keySet();

         this.insertStatementSql = SqlRequestConsumer.newInsertStatementSql(task.getInsertSql(), columnNames, blobColumns);

         List<String> parentColumnNames = task.getParentColumnName();

         String parentColumnName = null;

         if (parentColumnNames.size() == 1) {

         this.parentColumnName = parentColumnName;

         this.entryPoint = task.isEntryPoint();

         Set<String> shell = context.getShell();

         this.columnsToDetach = new LinkedHashSet<>();

         for (Map.Entry<String, String> entry : task.getColumnsToDetachSimple()) {

             }

         }

         this.recursiveProperty = task.getRecursiveColumnName().orElse(null);

     public void execute(Connection connection) throws SQLException {

         long t0 = TimeLog.getTime();

         try (PreparedStatement statement = connection.prepareStatement(sql)) {

             try (ResultSet resultSet = statement.executeQuery()) {

                 if (recursiveProperty == null) {

                     simpleCopy(statement, resultSet);

             parents.put(key == null ? sentinel : key, topiaId);

             requestsByTopiaId.put(topiaId, sql);

         }

         if (orderedTopiaIds.size() != requestsByTopiaId.size()) {

             throw new IllegalStateException("Mismatch ids size!!!");

         }

                 String stringValue = (String) columnValue;

                 if (entryPoint && stringValue.equals(oldParentId)) {

                     argumentsBuilder.append(", NULL");

                     continue;

                 }

                 argumentsBuilder.append(", '").append(stringValue.replaceAll("'", "''")).append("'");

         for (String columnName : blobColumns) {

             Object columnValue = resultSet.getObject(columnName);

             if (blobColumns.contains(columnName)) {

             }

         }

         String arguments = argumentsBuilder.substring(2);

  * #L%

  */

 import io.ultreia.java4all.util.sql.SqlScriptWriter;

 import org.nuiton.topia.persistence.TopiaIdFactoryForBulkSupport;

 import org.nuiton.topia.service.sql.internal.SqlRequestSetConsumerContext;

 import java.util.Map;

 import java.util.Objects;

 import java.util.Set;

     public void writeSql(String sql) {

         writer.writeSql(sql);

     }

 }

                 throw new IllegalArgumentException(String.format("Can't manage with this case: %s", parentColumnNames));

             }

         }

         Set<String> requiredTypes = new LinkedHashSet<>();

         String literalName = metadataEntity.getType();

         if (mandatoryReverseCompositions.containsKey(literalName)) {

             for (TopiaMetadataComposition composition : mandatoryReverseCompositions.get(literalName)) {

                 String type = composition.getTarget().getType();

                 if (missingTypes.contains(type)) {

                 }

             }

         }

         List<String> columNames = List.copyOf(table.getAuthorizedColumnNames());

         Set<String> columnsToDetach = new LinkedHashSet<>();

         for (Map.Entry<String, String> entry : metadataEntity.getManyToOneAssociations().entrySet()) {

         }

         for (Map.Entry<String, String> entry : metadataEntity.getReversedAssociations().entrySet()) {

         }

         // the parent column is always to replace

         parentColumnNames.forEach(columnsToReplace::remove);

                                                       columNames,

                                                       columnsToReplace,

                                                       columnsToDetach,

                                                       useBlob,

                                                       mainTable,

                                                       recursiveColumnName));

                                                                  null));

     }

         String literalName = entry.getValue();

         if (literals.contains(literalName)) {

             // this one need to be replace

             columnsToReplace.add(entry.getKey());

             // this one need to be detach

             int endIndex = literalName.lastIndexOf("_");

             String columnDefinition = entry.getKey() + "~" + literalName.substring(0, endIndex) + "." + Introspector.decapitalize(literalName.substring(endIndex + 1));