-            this.editable = dto.isSelectable() && dto.getObjectMaterialType() != null;

-    <!-- selectable -->

-    <row>

-      <cell anchor='east' weightx="1" fill="both" columns="2">

-        <JCheckBox id='selectable' styleClass="i18n"

-                   onItemStateChanged='getBean().setSelectable(selectable.isSelected())'/>

-      </cell>

-    </row>

-

-#selectable {

-  selected:{bean.isSelectable()};

-}

-

-                      ObjectMaterialDto.PROPERTY_SELECTABLE,

-                      ObjectMaterialUI.BINDING_SELECTABLE_SELECTED,

-observe.common.ObjectMaterialDto.selectable=Selectable

-observe.common.ObjectMaterialDto.selectable=Sélectionnable \#TODO

-observe.common.ObjectMaterialDto.selectable=Sélectionnable

-selectable + {*:1} boolean

-        entity.setSelectable(dto.isSelectable());

-        dto.setSelectable(entity.isSelectable());

-selectable + {*:1} boolean | notNull

-package fr.ird.observe.persistence.migration;

-

-/*-

- * #%L

- * ObServe :: Persistence

- * %%

- * Copyright (C) 2008 - 2018 IRD, Code Lutin, Ultreia.io

- * %%

- * This program is free software: you can redistribute it and/or modify

- * it under the terms of the GNU General Public License as

- * published by the Free Software Foundation, either version 3 of the

- * License, or (at your option) any later version.

- * 

- * This program is distributed in the hope that it will be useful,

- * but WITHOUT ANY WARRANTY; without even the implied warranty of

- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

- * GNU General Public License for more details.

- * 

- * You should have received a copy of the GNU General Public

- * License along with this program.  If not, see

- * <http://www.gnu.org/licenses/gpl-3.0.html>.

- * #L%

- */

-

-import com.google.common.collect.ImmutableMap;

-import fr.ird.observe.dto.referential.ReferenceStatus;

-import fr.ird.observe.entities.referentiel.seine.ObjectMaterial;

-import fr.ird.observe.entities.referentiel.seine.ObjectMaterialImpl;

-import org.apache.commons.lang3.mutable.MutableInt;

-import org.apache.logging.log4j.Logger;

-import org.apache.logging.log4j.LogManager;

-import org.junit.Test;

-import org.nuiton.csv.Common;

-import org.nuiton.csv.Import;

-import org.nuiton.csv.ext.AbstractImportModel;

-

-import java.io.BufferedReader;

-import java.io.BufferedWriter;

-import java.io.File;

-import java.io.IOException;

-import java.nio.file.Files;

-import java.nio.file.Path;

-import java.util.Collection;

-

-/**

- * Created by tchemit on 31/07/17.

- *

- * @author Tony Chemit - dev@tchemit.fr

- */

-public class GenerateReferentialObjectMaterial {

-

-    // Lines to fxi and readd to file

-

-

-    /** Logger. */

-    private static final Logger log = LogManager.getLogger(GenerateReferentialObjectMaterial.class);

-

-    private static final String INSERT = "INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values (%-65s, 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  %s, %-15s, %-10s, %-15s, %-65s, %-50s, %-50s, %-50s, %-5s, %-5s, %-5s, %-66s, %-30s, %-5s, %-5s);";

-

-    @Test

-    public void generate() throws IOException {

-

-

-        Path dir = new File("").getAbsoluteFile().toPath()

-                .resolve("src")

-                .resolve("main")

-                .resolve("resources")

-                .resolve("db")

-                .resolve("migration")

-                .resolve("6.6.1");

-

-        Path sourcePath = dir.resolve("referential-ObjectMaterial.csv");

-        Path targetPath = dir.resolve("09_fill_object_material-common.sql");

-

-        Collection<ObjectMaterial> data = loadData(sourcePath);

-

-        try (BufferedWriter writer = Files.newBufferedWriter(targetPath)) {

-

-            for (ObjectMaterial datum : data) {

-

-                String row = String.format(INSERT

-                        , getValue(datum.getTopiaId())

-                        , datum.getStatus().ordinal()

-                        , getValue(datum.getLegacyCode())

-                        , getValue(datum.getStandardCode())

-                        , getValue(datum.getCode())

-                        , getValue(datum.getParent() == null ? "" : datum.getParent().getTopiaId())

-                        , getValue(datum.getLabel1())

-                        , getValue(datum.getLabel2())

-                        , getValue(datum.getLabel3())

-                        , datum.isSelectable()

-                        , datum.isChildrenMultiSelectable()

-                        , datum.isChildSelectionMandatory()

-                        , getValue(datum.getLabel5() == null ? "" : datum.getLabel5())

-                        , getValue(datum.getValidation())

-                        , datum.isBiodegradable()

-                        , datum.isNonEntangling()

-                );

-                writer.append(row);

-                writer.newLine();

-

-            }

-        }

-

-    }

-

-    private String getValue(String value) {

-        return value.isEmpty() ? "NULL" : ("'" + value + "'");

-    }

-

-    private Collection<ObjectMaterial> loadData(Path sourcePath) throws IOException {

-

-        ImmutableMap.Builder<String, ObjectMaterial> result = ImmutableMap.builder();

-        MutableInt idIndex = new MutableInt(0);

-        try (BufferedReader reader = Files.newBufferedReader(sourcePath)) {

-            Import.newImport(new ImportModel(), reader).forEach(objectMaterial -> {

-

-                objectMaterial.setTopiaId("fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0." + idIndex.incrementAndGet());

-

-                log.info(String.format("Loading %s (%s)", objectMaterial.getCode(), objectMaterial.getTopiaId()));

-                String dataType = objectMaterial.getLabel5();

-                objectMaterial.setLabel5(null);

-                if (dataType != null) {

-                    switch (dataType.trim().toLowerCase()) {

-                        case "boolean":

-                            objectMaterial.setLabel5("fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0");

-                            break;

-                        case "integer":

-                            objectMaterial.setLabel5("fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2");

-                            break;

-                        case "string":

-                            objectMaterial.setLabel5("fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#3");

-                            break;

-                        case "float1":

-                            objectMaterial.setLabel5("fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1");

-                            break;

-

-                    }

-                }

-                String status = objectMaterial.getLabel6();

-                objectMaterial.setLabel6(null);

-                Boolean statusB = status == null ? null : Boolean.valueOf(status);

-                objectMaterial.setStatus(statusB != null && statusB ? ReferenceStatus.enabled : ReferenceStatus.disabled);

-                result.put(objectMaterial.getCode(), objectMaterial);

-            });

-        }

-        ImmutableMap<String, ObjectMaterial> map = result.build();

-        for (ObjectMaterial objectMaterial : map.values()) {

-            String parentCode = objectMaterial.getLabel4();

-            objectMaterial.setLabel4(null);

-            if (parentCode != null) {

-                ObjectMaterial parent = map.get(parentCode);

-                objectMaterial.setParent(parent);

-            }

-        }

-        return map.values();

-    }

-

-    private static class ImportModel extends AbstractImportModel<ObjectMaterial> {

-

-        ImportModel() {

-            super(',');

-            newMandatoryColumn(ObjectMaterial.PROPERTY_CODE);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_LEGACY_CODE);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_STANDARD_CODE);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_BIODEGRADABLE, Common.PRIMITIVE_BOOLEAN);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_NON_ENTANGLING, Common.PRIMITIVE_BOOLEAN);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_SELECTABLE, Common.PRIMITIVE_BOOLEAN);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_CHILD_SELECTION_MANDATORY, Common.PRIMITIVE_BOOLEAN);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_CHILDREN_MULTI_SELECTABLE, Common.PRIMITIVE_BOOLEAN);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_LABEL1);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_LABEL2);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_LABEL3);

-            newMandatoryColumn(ObjectMaterial.PROPERTY_VALIDATION);

-            newMandatoryColumn("parent", ObjectMaterial.PROPERTY_LABEL4);

-            newMandatoryColumn("dataType", ObjectMaterial.PROPERTY_LABEL5);

-            newMandatoryColumn("status", ObjectMaterial.PROPERTY_LABEL6);

-        }

-

-        @Override

-        public ObjectMaterial newEmptyInstance() {

-            return new ObjectMaterialImpl();

-        }

-    }

-}

-create table OBSERVE_SEINE.objectMaterial (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp, lastUpdateDate timestamp not null, code varchar(255), uri varchar(255), needComment boolean not null, status integer, label1 varchar(255), label2 varchar(255), label3 varchar(255), label4 varchar(255), label5 varchar(255), label6 varchar(255), label7 varchar(255), label8 varchar(255), legacyCode varchar(2147483647), standardCode varchar(255), selectable boolean not null, biodegradable boolean not null, nonEntangling boolean not null, childrenMultiSelectable boolean not null, childSelectionMandatory boolean not null, parent varchar(255), objectMaterialType varchar(255), validation varchar(255), primary key (topiaId));

-create table OBSERVE_SEINE.objectMaterial (topiaId varchar(255) not null, topiaVersion int8 not null, topiaCreateDate timestamp, lastUpdateDate timestamp not null, code varchar(255), uri varchar(255), needComment boolean not null, status int4, label1 varchar(255), label2 varchar(255), label3 varchar(255), label4 varchar(255), label5 varchar(255), label6 varchar(255), label7 varchar(255), label8 varchar(255), legacyCode text, standardCode varchar(255), selectable boolean not null, biodegradable boolean not null, nonEntangling boolean not null, childrenMultiSelectable boolean not null, childSelectionMandatory boolean not null, parent varchar(255), objectMaterialType varchar(255), validation varchar(255), primary key (topiaId));