Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 5ecc9305 by Tony CHEMIT at 2017-07-31T11:54:29+02:00 Ajout du fichier de construction du référentiel ObjectMaterial - - - - - 5c7c2d1b by Tony CHEMIT at 2017-07-31T11:54:32+02:00 Suppression images inutiles - - - - - a935132e by Tony CHEMIT at 2017-07-31T12:57:58+02:00 fix les noms des colonnes pour l'import - - - - - 8809d805 by Tony CHEMIT at 2017-07-31T13:39:01+02:00 Lissage du fichier d'import (suppression des lignes à problème à repositionner - - - - - eaf05e9f by Tony CHEMIT at 2017-07-31T13:39:13+02:00 Ajout du générateur de fichier d'import - - - - - 4fb6584a by Tony CHEMIT at 2017-07-31T15:58:15+02:00 adaptation du ObjectMaterial - - - - - 21 changed files: - − doc/images/error.png - − doc/images/info.png - − doc/images/ok.png - − doc/images/question.png - − doc/images/warning.png - persistence/pom.xml - persistence/src/main/java/fr/ird/observe/persistence/migration/DataSourceMigrationForVersion_7_0.java - persistence/src/main/models/Observe.model - persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql - + persistence/src/main/resources/db/migration/6.901/09_fill_object_material-common.sql - + persistence/src/main/resources/db/migration/6.901/referential-ObjectMaterial.csv - + persistence/src/test/java/fr/ird/observe/persistence/migration/GenerateReferentialObjectMaterial.java - services-topia/src/main/java/fr/ird/observe/services/binder/referential/seine/ObjectMaterialBinder.java - services-topia/src/test/java/fr/ird/observe/services/topia/service/actions/validate/ValidateServiceTopiaTest.java - services-topia/src/test/java/fr/ird/observe/services/topia/service/data/seine/FloatingObjectServiceTopiaTest.java - test/src/main/java/fr/ird/observe/test/ObserveFixtures.java - test/src/main/resources/db/6.901/dataForTestLongline.sql.gz - test/src/main/resources/db/6.901/dataForTestSeine.sql.gz - test/src/main/resources/db/6.901/empty_h2.sql.gz - test/src/main/resources/db/6.901/empty_pg.sql.gz - test/src/main/resources/db/6.901/referentiel.sql.gz Changes: ===================================== doc/images/error.png deleted ===================================== Binary files a/doc/images/error.png and /dev/null differ ===================================== doc/images/info.png deleted ===================================== Binary files a/doc/images/info.png and /dev/null differ ===================================== doc/images/ok.png deleted ===================================== Binary files a/doc/images/ok.png and /dev/null differ ===================================== doc/images/question.png deleted ===================================== Binary files a/doc/images/question.png and /dev/null differ ===================================== doc/images/warning.png deleted ===================================== Binary files a/doc/images/warning.png and /dev/null differ ===================================== persistence/pom.xml ===================================== --- a/persistence/pom.xml +++ b/persistence/pom.xml @@ -57,6 +57,11 @@ <groupId>org.nuiton</groupId> <artifactId>nuiton-version</artifactId> </dependency> + <dependency> + <groupId>org.nuiton</groupId> + <artifactId>nuiton-csv</artifactId> + <scope>test</scope> + </dependency> <!-- commons --> <dependency> ===================================== persistence/src/main/java/fr/ird/observe/persistence/migration/DataSourceMigrationForVersion_7_0.java ===================================== --- a/persistence/src/main/java/fr/ird/observe/persistence/migration/DataSourceMigrationForVersion_7_0.java +++ b/persistence/src/main/java/fr/ird/observe/persistence/migration/DataSourceMigrationForVersion_7_0.java @@ -65,6 +65,7 @@ public class DataSourceMigrationForVersion_7_0 extends AbstractObserveMigrationC addScript("06", "add_non_target_catch_release", queries); addScript("07", "drop_table_sizemeasuretype", queries); addScript("08", "add_floating_object_fields", queries); + addScript("09", "fill_object_material", queries); } public static class H2DataSourceMigrationForVersion extends DataSourceMigrationForVersion_7_0 { ===================================== persistence/src/main/models/Observe.model ===================================== --- a/persistence/src/main/models/Observe.model +++ b/persistence/src/main/models/Observe.model @@ -654,7 +654,7 @@ nonEntangling + {*:1} boolean | notNull childrenMultiSelectable + {*:1} boolean | notNull childSelectionMandatory + {*:1} boolean | notNull parent {*:0..1} referentiel.seine.ObjectMaterial -objectMaterialType {*:1} referentiel.seine.ObjectMaterialType | notNull lazy=false +objectMaterialType {*:1} referentiel.seine.ObjectMaterialType | lazy=false validation + {*:1} String referentiel.seine.ObjectMaterialType > referentiel.I18nReferentialEntity | entity ===================================== persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql ===================================== --- a/persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql +++ b/persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql @@ -35,48 +35,3 @@ ALTER TABLE observe_seine.objectMaterial ADD CONSTRAINT PK_OBJECT_MATERIAL PRIMA ALTER TABLE observe_seine.objectMaterial ADD CONSTRAINT FK_OBJECT_MATERIAL_PARENT FOREIGN KEY (parent) REFERENCES observe_seine.objectMaterial(topiaid); ALTER TABLE observe_seine.objectMaterial ADD CONSTRAINT FK_OBJECT_MATERIAL_OBJECT_MATERIAL_TYPE FOREIGN KEY (objectMaterialType) REFERENCES observe_seine.objectMaterialType(topiaid); INSERT INTO observe_common.LASTUPDATEDATE (topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#901', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial', CURRENT_TIMESTAMP); - -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1', NULL,'Raft', 'Radeau', true, true, true, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0', 'Frame', ' Chassis', FALSE, FALSE, TRUE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#2', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1', 'Vegetal (including bamboo)', 'Végétal (dont bambou)', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#3', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1', 'Metal', 'Métal', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#4', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-1-3', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1','PVC', 'PVC', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0', 'Coverage type', 'Type de couverture', false, true, true, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#6', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 'Net', 'Filet', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#7', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#6', 'Net with mesh <=3cm', 'Filet avec maille <=3cm', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#8', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-1-1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#7', 'Net with mesh <=3cm above', 'Filet avec maille <=3cm dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#9', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-1-1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#7', 'Net with mesh <=3cm behind', 'Filet avec maille <=3cm dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#10', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#6', 'Net with mesh >3cm', 'Filet avec maille >3cm', FALSE, FALSE, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#11', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-1-2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#10', 'Net with mesh >3cm above', 'Filet avec maille >3cm dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#12', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-1-2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#10', 'Net with mesh >3cm behind', 'Filet avec maille >3cm dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#13', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 'Coverage without mesh', 'Couverture sans maille', FALSE, FALSE, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#14', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#13', 'Coverage without mesh above', 'Couverture sans maille dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#15', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#13', 'Coverage without mesh behind', 'Couverture sans maille dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#16', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-3', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 'Not covered', 'Non couvert', FALSE, FALSE, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#17', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-3-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#16', 'Not covered above', 'Non couvert dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#18', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-3-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#16', 'Not covered behind', 'Non couvert dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#19', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-4', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 'Not visible', 'Non visible', false, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#20', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-4-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#19', 'Not visible above', 'Non visible dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#21', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '1-2-4-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#19', 'Not visible behind', 'Non visible dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2', NULL, 'Underwater part', 'Partie immergée', false, true, true, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#23', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Net in sausage', 'Filet saucisse', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#24', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#24', 'Net in sausage <=3cm', 'Filet saucisse <=3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#25', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#24', 'Net in sausage >3cm', 'Filet saucisse >3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#26', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Open net', 'Filet ouvert', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#27', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#26', 'Open net <= 3cm', 'Filet ouvert <=3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#28', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#26', 'Open net >3cm', 'Filet ouvert >3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#29', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-3', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Single net pieces', 'Pièces de filets accolées', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#30', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-3-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#29', 'Single net pieces <=3cm', 'Pièces de filets accolées <=3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#31', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-3-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#29', 'Single net pieces >3cm', 'Pièces de filets accolées >3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#32', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-4', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Rope/no mesh', 'Bout/sans maille', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#33', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-5', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Not visible', 'Pas visible', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#34', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '2-6', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'No sub structure', 'Pas de mouillage', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '3', NULL, 'Other elements', 'Autres éléments', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#36', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '3-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Platic containers', 'Bidons plastique', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#37', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '3-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Corks', 'Flotteurs', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#38', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '3-3', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Bags', 'Sacs', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#39', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '3-4', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Palms, canes', 'Palmes, tiges', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#40', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '3-5', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Color belts', 'Rubans colorés', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#41', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '3-6', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Weights', 'Poids', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2', false, false); -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#42', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '', '', '3-7', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Entangled animal', 'Animal maillé', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#3', false, false); -UPDATE observe_seine.objectMaterial set label3 = label2 || ' TODO'; ===================================== persistence/src/main/resources/db/migration/6.901/09_fill_object_material-common.sql ===================================== --- /dev/null +++ b/persistence/src/main/resources/db/migration/6.901/09_fill_object_material-common.sql @@ -0,0 +1,107 @@ +--- +-- #%L +-- ObServe :: Persistence +-- %% +-- Copyright (C) 2008 - 2017 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% +--- +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.1' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , 'FAD' , '1' , NULL , 'FAD' , 'FAD' , 'FAD' , false, false, false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '16' , 'DFAD' , '1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.1' , 'DFAD (drifting FAD)' , 'DFAD (FAD dérivant)' , 'DFAD (FAD a la deriva)' , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, '19' , NULL , '1-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Experimental FAD' , 'Objet expérimental' , 'Objeto experimental' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, '18' , NULL , '1-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Artificial FAD' , 'Objet artificiel' , 'Objeto artificial' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '27' , NULL , '1-1-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Several FAD entangled' , 'Plusieurs FAD' , 'Objectos enredados' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Frame' , 'Chassis' , 'Estructura' , false, false, true , NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.7' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '6, 15, 25' , NULL , '1-1-1-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 'Vegetal, canes,bamboo' , 'Végétal, tiges,bambou' , 'Bambú, cañas' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.8' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '20, 21*,26' , NULL , '1-1-1-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 'Metallic or PVC' , 'Métal ou PVC' , 'Metállica ó PVC' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Superior coverage' , 'Revêtement supérieur' , 'Recubrimiento superior' , false, true , true , NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.10', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-2-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 'Net' , 'Filet' , 'Red' , false, true , false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.11', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-2-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.10', 'Net with mesh ≤7cm' , 'Filet avec maillage ≤7cm' , 'Red con malla ≤7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.12', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-2-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.10', 'Net with mesh >7cm' , 'Filet avec maillage >7cm' , 'Red con malla >7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.13', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-2-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 'Coverage without mesh' , 'Revêtement sans maillage' , 'Recubrimiento sin malla' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.14', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-2-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 'Not covered' , 'Non couvert' , 'Sin recubrimiento' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.15', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-2-4' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 'Not visible' , 'Non visible' , 'No se ve' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Inferior coverage' , 'Revêtement inférieur' , 'Recubrimiento inferior' , false, true , true , NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.17', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-3-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 'Net' , 'Filet' , 'Red' , false, true , false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.18', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-3-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.17', 'Net with mesh ≤7cm' , 'Filet avec maillage ≤7cm' , 'Red con malla ≤7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.19', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-3-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.17', 'Net with mesh >7cm' , 'Filet avec maillage >7cm' , 'Red con malla >7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.20', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-3-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 'Coverage without mesh' , 'Revêtement sans maillage' , 'Recubrimiento sin malla' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.21', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-3-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 'Not covered' , 'Non couvert' , 'Sin recubrimiento' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.22', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-3-4' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 'Not visible' , 'Non visible' , 'No se ve' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.23', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-4' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Modified' , 'Modifié' , 'Se modifica' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.24', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-1-5' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Replaced' , 'Remplacé' , 'Se reemplaza' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.25', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Net in sausage' , 'Filet saucisse' , 'Red en chorizo' , false, true , false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.26', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, NULL , NULL , '1-1-2-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.25', 'Net in sausage with mesh ≤7cm' , 'Filet saucisse avec maillage ≤7cm' , 'Red en chorizo con malla ≤7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.27', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, NULL , NULL , '1-1-2-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.25', 'Net in sausage with mesh >7cm' , 'Filet saucisse avec maillage >7cm' , 'Red en chorizo con malla >7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.28', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Open net' , 'Filet ouvert' , 'Red abierta' , false, true , false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.29', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-2-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.28', 'Open net with mesh ≤7cm' , 'Filet ouvert avec maillage ≤7cm' , 'Red abierta con malla ≤7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.30', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-2-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.28', 'Open net with mesh >7cm' , 'Filet ouvert avec maillage >7cm' , 'Red abierta con malla >7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.31', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Single net pieces' , 'Pièces de filets accolées' , 'Paños de red sueltos' , false, true , false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.32', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-3-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.31', 'Single net pieces with mesh ≤7cm' , 'Pièces de filets accolées avec maillage ≤7cm' , 'Paños de red sueltos con malla ≤7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.33', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-3-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.31', 'Single net pieces with mesh >7cm' , 'Pièces de filets accolées avec maillage >7cm' , 'Paños de red sueltos con malla >7cm' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.34', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-4' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Rope/no mesh' , 'Bout/sans maillage' , 'Cabo/sin red' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.35', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-5' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Not visible' , 'Pas visible' , 'No se ve' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.36', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-6' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'No subsurface structure' , 'Pas de mouillage' , 'Sin rabo' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.37', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-7' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Modified' , 'Modifié' , 'Se modifica' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.38', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-2-8' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Replaced' , 'Remplacé' , 'Se reemplaza' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.39', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-3-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Containers' , 'Bidons plastique' , 'Garrafas plástico' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.40', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-3-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Corks' , 'Flotteurs' , 'Corchos' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.41', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-3-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Bags' , 'Sacs' , 'Sacos' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.42', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-3-4' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Palms, canes' , 'Palmes, tiges' , 'Palmeras, cañas' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.43', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-3-5' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Color belts' , 'Rubans colorés' , 'Cintas de colores' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.44', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-3-6' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Weights' , 'Poids' , 'Peso' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.45', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-1-3-7' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Entangled animal' , 'Animal maillé' , 'Animal enmallado' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.46', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '7' , 'AFAD' , '1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.1' , 'AFAD (anchored FAD)' , 'AFAD (FAD ancré)' , 'AFAD (FAD arraigado)' , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.47', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-2-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.46', 'Radar reflectors' , 'Réflecteurs radar' , 'Reflectores de radar' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.48', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-2-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.46', 'Lighting' , 'Eclairage' , 'iluminación' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.49', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '1-2-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.46', 'Visual range (in nautical miles)' , 'Rayon de visibilité (en miles nautiques)' , 'Rango de visibilidad' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1', 'x >= 0.1 && x <= 50' , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.50', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , 'LOG' , '2' , NULL , 'LOG' , 'LOG' , 'LOG' , true , true , false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.51', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , 'NLOG' , '2-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.50', 'NLOG (natural LOG)' , 'NLOG (LOG naturel)' , 'NLOG (LOG natural)' , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.52', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , 'VNLOG' , '2-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.51', 'VNLOG (vegetal NLOG)' , 'VNLOG (NLOG vegetal)' , 'VNLOG (NLOG vegetal)' , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.53', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '1' , NULL , '2-1-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.52', 'Straw heap' , 'Tas de paille' , 'Monton the hierba' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.54', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '2' , NULL , '2-1-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.52', 'Palm tree, palm' , 'Palmier, palme' , 'Palma, hoja de palmera' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.55', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '3' , NULL , '2-1-1-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.52', 'Tree, branche' , 'Arbre, branche' , 'Árbol, rama' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.56', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , 'ANLOG' , '2-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.51', 'ANLOG (animal NLOG)' , 'ANLOG (NLOG animal)' , 'ANLOG (NLOG animal)' , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.57', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '4, 5*, 24' , NULL , '2-1-2-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.56', 'Carrion' , 'Charogne' , 'Carroña' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.58', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '2-1-2-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.56', 'Whale shark' , 'Requin-baleine' , 'Tiburón ballena' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , 'ALOG' , '2-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.50', 'ALOG (artificial LOG)' , 'ALOG (LOG artificiel)' , 'ALOG (LOG artificial)' , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.60', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '10' , NULL , '2-2-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'Case, big board' , 'Caisse, grosse planche' , 'Caja, gran tablero' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.61', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '13' , NULL , '2-2-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'Plastic object' , 'Objet plastique' , 'Objeto de plastico' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.62', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '17' , NULL , '2-2-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'Metallic object' , 'Objet métallique' , 'Objeto de metal' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , 'FALOG' , '2-2-4' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'FALOG (fishing ALOG)' , 'FALOG (ALOG pêche)' , 'FALOG (ALOG pesca)' , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.64', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '11' , NULL , '2-2-4-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63', 'Rope, cable' , 'Cordage, câble' , 'Cuerda, cable' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.65', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '12' , NULL , '2-2-4-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63', 'Net, piece of net' , 'Filet, morceau de filet' , 'Red, pedazo de red' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.66', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '2-2-4-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63', 'Inert plastic buoy' , 'Bouée plastique inerte' , 'Boya de plástico inerte' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.67', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , 'HALOG' , '2-2-5' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'HALOG (not fishing ALOG)' , 'HALOG (ALOG non pêche)' , 'HALOG (HALOG no pesca)' , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '4' , NULL , 'Other properties' , 'Autres propriétés' , 'Otras propiedades' , false, true , false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.69', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '4-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Biodegradable' , 'Matériaux' , 'Materiales' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.70', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '22' , NULL , '4-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Non entangling' , 'Non maillant' , NULL , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.71', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, '23' , NULL , '4-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Entangling' , 'Maillant' , 'Enmallante' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.72', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '4-4' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Depth (in m)' , 'Profondeur (en m)' , 'Profundidad (en m)' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2', 'x >= 0 && x <= 100' , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.73', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '4-5' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Area (in m2)' , 'Surface (en m2)' , 'Superficie (en m2)' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1', 'x >= 0.5 && x <= 50' , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.74', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '4-6' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Size of largest mesh' , 'Taille de la maille la plus grande (en mm)' , 'Talla de la malla más grandes (en mm)' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2', 'x >= 5 && x <= 200' , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.75', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '4-7' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'FOB identifier' , 'Identifiant du FOB' , 'Identificador del FOB' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#3', 'len(x) >= 3 && len(x) <= 64' , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.76', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '4-8' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Number of FOB of this' , 'Nombre de FOB de ce type emmêlés' , NULL , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2', 'x >= 2 && x <= 100' , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, NULL , NULL , '6' , NULL , 'Legacy codes' , 'Anciens codes' , 'Códigos antiguos' , false, true , false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.78', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, '99' , NULL , '6-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'Other, unknown' , 'Autre, inconnu' , 'Otro, desconocido' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.79', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, '14' , 'ALOG' , '6-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'One of the previous (10, 11, 12, 13) tagged' , 'Un des antérieurs (10, 11, 12, 13) balisé' , 'Una de los anterior (10, 11, 12, 13) con Baliza' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.80', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, '8' , NULL , '6-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'Tuna seiner (or skiff)' , 'Thonier (ou skiff)' , 'Atunero (oó panga)' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.81', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, '9' , NULL , '6-4' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'Supply' , 'Bateau d’appui' , 'Macicero' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.82', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, '5*, 6*, 21*' , NULL , '6-5' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'Tagged' , 'Balisé' , 'Marcado' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.83', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '7-1-1' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Raft' , 'Radeau' , 'Parrilla' , true , true , true , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.84', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 0, NULL , NULL , '7-1-1-1-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 'Mixed vegetal and metallic or PVC' , NULL , 'Mixta (metálica o PVC y cañas)' , false, false, false, NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.85', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '7-1-2' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 'Subsurface structure' , 'Structure immergée' , 'Rabo' , false, true , true , NULL , NULL , false, false); +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 ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.86', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false, 1, NULL , NULL , '7-1-3' , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Other components' , 'Autres éléments' , 'Otros componentes' , false, true , false, NULL , NULL , false, false); ===================================== persistence/src/main/resources/db/migration/6.901/referential-ObjectMaterial.csv ===================================== --- /dev/null +++ b/persistence/src/main/resources/db/migration/6.901/referential-ObjectMaterial.csv @@ -0,0 +1,87 @@ +code,parent,legacyCode,standardCode,label1,label2,label3,dataType,validation,selectable,childrenMultiSelectable,childSelectionMandatory,status,biodegradable,nonEntangling +1,,,FAD,FAD,FAD,FAD,,,FALSE,FALSE,FALSE,TRUE,, +1-1,1,16,DFAD,DFAD (drifting FAD),DFAD (FAD dérivant),DFAD (FAD a la deriva),Boolean,,TRUE,TRUE,FALSE,TRUE,, +1-1-1,1-1,19,,Experimental FAD,Objet expérimental,Objeto experimental,Boolean,,TRUE,,,FALSE,, +1-1-2,1-1,18,,Artificial FAD,Objet artificiel,Objeto artificial,Boolean,,TRUE,,,FALSE,, +1-1-3,1-1,27,,Several FAD entangled,Plusieurs FAD,Objectos enredados,Boolean,,TRUE,,,TRUE,, +1-1-1-1,1-1-1,,,Frame,Chassis,Estructura,,,FALSE,FALSE,TRUE,TRUE,, +1-1-1-1-1,1-1-1-1,"6, 15, 25",,"Vegetal, canes,bamboo","Végétal, tiges,bambou","Bambú, cañas",Boolean,,TRUE,,,TRUE,, +1-1-1-1-2,1-1-1-1,"20, 21*,26",,Metallic or PVC,Métal ou PVC,Metállica ó PVC,Boolean,,TRUE,,,TRUE,, +1-1-1-2,1-1-1,,,Superior coverage,Revêtement supérieur,Recubrimiento superior,,,FALSE,TRUE,TRUE,TRUE,, +1-1-1-2-1,1-1-1-2,,,Net,Filet,Red,,,FALSE,TRUE,FALSE,TRUE,, +1-1-1-2-1-1,1-1-1-2-1,,,Net with mesh ≤7cm,Filet avec maillage ≤7cm,Red con malla ≤7cm,Boolean,,TRUE,,FALSE,TRUE,, +1-1-1-2-1-2,1-1-1-2-1,,,Net with mesh >7cm,Filet avec maillage >7cm,Red con malla >7cm,Boolean,,TRUE,,FALSE,TRUE,, +1-1-1-2-2,1-1-1-2,,,Coverage without mesh,Revêtement sans maillage,Recubrimiento sin malla,Boolean,,TRUE,,FALSE,TRUE,, +1-1-1-2-3,1-1-1-2,,,Not covered,Non couvert,Sin recubrimiento,Boolean,,TRUE,,FALSE,TRUE,, +1-1-1-2-4,1-1-1-2,,,Not visible,Non visible,No se ve,Boolean,,TRUE,,,TRUE,, +1-1-1-3,1-1-1,,,Inferior coverage,Revêtement inférieur,Recubrimiento inferior,,,FALSE,TRUE,TRUE,TRUE,, +1-1-1-3-1,1-1-1-3,,,Net,Filet,Red,,,FALSE,TRUE,FALSE,TRUE,, +1-1-1-3-1-1,1-1-1-3-1,,,Net with mesh ≤7cm,Filet avec maillage ≤7cm,Red con malla ≤7cm,Boolean,,TRUE,,FALSE,TRUE,, +1-1-1-3-1-2,1-1-1-3-1,,,Net with mesh >7cm,Filet avec maillage >7cm,Red con malla >7cm,Boolean,,TRUE,,FALSE,TRUE,, +1-1-1-3-2,1-1-1-3,,,Coverage without mesh,Revêtement sans maillage,Recubrimiento sin malla,Boolean,,TRUE,,FALSE,TRUE,, +1-1-1-3-3,1-1-1-3,,,Not covered,Non couvert,Sin recubrimiento,Boolean,,TRUE,,FALSE,TRUE,, +1-1-1-3-4,1-1-1-3,,,Not visible,Non visible,No se ve,Boolean,,TRUE,,,TRUE,, +1-1-1-4,1-1-1,,,Modified,Modifié,Se modifica,Boolean,,TRUE,,,TRUE,, +1-1-1-5,1-1-1,,,Replaced,Remplacé,Se reemplaza,Boolean,,TRUE,,,TRUE,, +1-1-2-1,1-1-2,,,Net in sausage,Filet saucisse,Red en chorizo,,,FALSE,TRUE,FALSE,TRUE,, +1-1-2-1-1,1-1-2-1,,,Net in sausage with mesh ≤7cm,Filet saucisse avec maillage ≤7cm,Red en chorizo con malla ≤7cm,Boolean,,TRUE,,,FALSE,, +1-1-2-1-2,1-1-2-1,,,Net in sausage with mesh >7cm,Filet saucisse avec maillage >7cm,Red en chorizo con malla >7cm,Boolean,,TRUE,,,FALSE,, +1-1-2-2,1-1-2,,,Open net,Filet ouvert,Red abierta,,,FALSE,TRUE,FALSE,TRUE,, +1-1-2-2-1,1-1-2-2,,,Open net with mesh ≤7cm,Filet ouvert avec maillage ≤7cm,Red abierta con malla ≤7cm,Boolean,,TRUE,,,TRUE,, +1-1-2-2-2,1-1-2-2,,,Open net with mesh >7cm,Filet ouvert avec maillage >7cm,Red abierta con malla >7cm,Boolean,,TRUE,,,TRUE,, +1-1-2-3,1-1-2,,,Single net pieces,Pièces de filets accolées,Paños de red sueltos,,,FALSE,TRUE,FALSE,TRUE,, +1-1-2-3-1,1-1-2-3,,,Single net pieces with mesh ≤7cm,Pièces de filets accolées avec maillage ≤7cm,Paños de red sueltos con malla ≤7cm,Boolean,,TRUE,,,TRUE,, +1-1-2-3-2,1-1-2-3,,,Single net pieces with mesh >7cm,Pièces de filets accolées avec maillage >7cm,Paños de red sueltos con malla >7cm,Boolean,,TRUE,,,TRUE,, +1-1-2-4,1-1-2,,,Rope/no mesh,Bout/sans maillage,Cabo/sin red,Boolean,,TRUE,,,TRUE,, +1-1-2-5,1-1-2,,,Not visible,Pas visible,No se ve,Boolean,,TRUE,,,TRUE,, +1-1-2-6,1-1-2,,,No subsurface structure,Pas de mouillage,Sin rabo,Boolean,,TRUE,,,TRUE,, +1-1-2-7,1-1-2,,,Modified,Modifié,Se modifica,Boolean,,TRUE,,,TRUE,, +1-1-2-8,1-1-2,,,Replaced,Remplacé,Se reemplaza,Boolean,,TRUE,,,TRUE,, +1-1-3-1,1-1-3,,,Containers,Bidons plastique,Garrafas plástico,Boolean,,TRUE,,,TRUE,, +1-1-3-2,1-1-3,,,Corks,Flotteurs,Corchos,Boolean,,TRUE,,,TRUE,, +1-1-3-3,1-1-3,,,Bags,Sacs,Sacos,Boolean,,TRUE,,,TRUE,, +1-1-3-4,1-1-3,,,"Palms, canes","Palmes, tiges","Palmeras, cañas",Boolean,,TRUE,,,TRUE,, +1-1-3-5,1-1-3,,,Color belts,Rubans colorés,Cintas de colores,Boolean,,TRUE,,,TRUE,, +1-1-3-6,1-1-3,,,Weights,Poids,Peso,Boolean,,TRUE,,,TRUE,, +1-1-3-7,1-1-3,,,Entangled animal,Animal maillé,Animal enmallado,Boolean,,TRUE,,,TRUE,, +1-2,1,7,AFAD,AFAD (anchored FAD),AFAD (FAD ancré),AFAD (FAD arraigado),Boolean,,TRUE,TRUE,FALSE,TRUE,, +1-2-1,1-2,,,Radar reflectors,Réflecteurs radar,Reflectores de radar,Boolean,,TRUE,,FALSE,TRUE,, +1-2-2,1-2,,,Lighting,Eclairage,iluminación,Boolean,,TRUE,,FALSE,TRUE,, +1-2-3,1-2,,,Visual range (in nautical miles),Rayon de visibilité (en miles nautiques),Rango de visibilidad,float1,x >= 0.1 && x <= 50,TRUE,,FALSE,TRUE,, +2,,,LOG,LOG,LOG,LOG,,,TRUE,TRUE,FALSE,TRUE,, +2-1,2,,NLOG,NLOG (natural LOG),NLOG (LOG naturel),NLOG (LOG natural),Boolean,,TRUE,TRUE,FALSE,TRUE,, +2-1-1,2-1,,VNLOG,VNLOG (vegetal NLOG),VNLOG (NLOG vegetal),VNLOG (NLOG vegetal),Boolean,,TRUE,TRUE,FALSE,TRUE,, +2-1-1-1,2-1-1,1,,Straw heap,Tas de paille,Monton the hierba,Boolean,,TRUE,,,TRUE,, +2-1-1-2,2-1-1,2,,"Palm tree, palm","Palmier, palme","Palma, hoja de palmera",Boolean,,TRUE,,,TRUE,, +2-1-1-3,2-1-1,3,,"Tree, branche","Arbre, branche","Árbol, rama",Boolean,,TRUE,,,TRUE,, +2-1-2,2-1,,ANLOG,ANLOG (animal NLOG),ANLOG (NLOG animal),ANLOG (NLOG animal),Boolean,,TRUE,TRUE,FALSE,TRUE,, +2-1-2-1,2-1-2,"4, 5*, 24",,Carrion,Charogne,Carroña,Boolean,,TRUE,,,TRUE,, +2-1-2-2,2-1-2,,,Whale shark,Requin-baleine,Tiburón ballena,Boolean,,TRUE,,,TRUE,, +2-2,2,,ALOG,ALOG (artificial LOG),ALOG (LOG artificiel),ALOG (LOG artificial),Boolean,,TRUE,TRUE,FALSE,TRUE,, +2-2-1,2-2,10,,"Case, big board","Caisse, grosse planche","Caja, gran tablero",Boolean,,TRUE,,,TRUE,, +2-2-2,2-2,13,,Plastic object,Objet plastique,Objeto de plastico,Boolean,,TRUE,,,TRUE,, +2-2-3,2-2,17,,Metallic object,Objet métallique,Objeto de metal,Boolean,,TRUE,,,TRUE,, +2-2-4,2-2,,FALOG,FALOG (fishing ALOG),FALOG (ALOG pêche),FALOG (ALOG pesca),Boolean,,TRUE,TRUE,,TRUE,, +2-2-4-1,2-2-4,11,,"Rope, cable","Cordage, câble","Cuerda, cable",Boolean,,TRUE,,,TRUE,, +2-2-4-2,2-2-4,12,,"Net, piece of net","Filet, morceau de filet","Red, pedazo de red",Boolean,,TRUE,,,TRUE,, +2-2-4-3,2-2-4,,,Inert plastic buoy,Bouée plastique inerte,Boya de plástico inerte,Boolean,,TRUE,,,TRUE,, +2-2-5,2-2,,HALOG,HALOG (not fishing ALOG),HALOG (ALOG non pêche),HALOG (HALOG no pesca),Boolean,,TRUE,TRUE,FALSE,TRUE,, +4,,,,Other properties,Autres propriétés,Otras propiedades,,,FALSE,TRUE,FALSE,TRUE,, +4-1,4,,,Biodegradable,Matériaux,Materiales,Boolean,,TRUE,,,TRUE,, +4-2,4,22,,Non entangling,Non maillant,,Boolean,,TRUE,,,TRUE,, +4-3,4,23,,Entangling,Maillant,Enmallante,Boolean,,TRUE,,,TRUE,, +4-4,4,,,Depth (in m),Profondeur (en m),Profundidad (en m),Integer,x >= 0 && x <= 100,TRUE,,,TRUE,, +4-5,4,,,Area (in m2),Surface (en m2),Superficie (en m2),float1,x >= 0.5 && x <= 50,TRUE,,,TRUE,, +4-6,4,,,Size of largest mesh,Taille de la maille la plus grande (en mm),Talla de la malla más grandes (en mm),Integer,x >= 5 && x <= 200,TRUE,,,TRUE,, +4-7,4,,,FOB identifier,Identifiant du FOB,Identificador del FOB,String,len(x) >= 3 && len(x) <= 64,TRUE,,,TRUE,, +4-8,4,,,Number of FOB of this,Nombre de FOB de ce type emmêlés,,Integer,x >= 2 && x <= 100,TRUE,,,TRUE,, +6,,,,Legacy codes,Anciens codes,Códigos antiguos,,,FALSE,TRUE,FALSE,FALSE,, +6-1,6,99,,"Other, unknown","Autre, inconnu","Otro, desconocido",Boolean,,TRUE,,,,, +6-2,6,14,ALOG,"One of the previous (10, 11, 12, 13) tagged","Un des antérieurs (10, 11, 12, 13) balisé","Una de los anterior (10, 11, 12, 13) con Baliza",Boolean,,TRUE,,,,, +6-3,6,8,,Tuna seiner (or skiff),Thonier (ou skiff),Atunero (oó panga),Boolean,,TRUE,,,,, +6-4,6,9,,Supply,Bateau d’appui,Macicero,Boolean,,TRUE,,,,, +6-5,6,"5*, 6*, 21*",,Tagged,Balisé,Marcado,Boolean,,TRUE,,,FALSE,, +7-1-1,1-1,,,Raft,Radeau,Parrilla,Boolean,,TRUE,TRUE,TRUE,TRUE,, +7-1-1-1-3,1-1-1-1,,,Mixed vegetal and metallic or PVC,,Mixta (metálica o PVC y cañas),,,,,,,, +7-1-2,1-1-1-1,,,Subsurface structure,Structure immergée,Rabo,,,FALSE,TRUE,TRUE,TRUE,, +7-1-3,1-1,,,Other components,Autres éléments,Otros componentes,,,FALSE,TRUE,FALSE,TRUE,, \ No newline at end of file ===================================== persistence/src/test/java/fr/ird/observe/persistence/migration/GenerateReferentialObjectMaterial.java ===================================== --- /dev/null +++ b/persistence/src/test/java/fr/ird/observe/persistence/migration/GenerateReferentialObjectMaterial.java @@ -0,0 +1,184 @@ +package fr.ird.observe.persistence.migration; + +/*- + * #%L + * ObServe :: Persistence + * %% + * Copyright (C) 2008 - 2017 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.common.constants.ReferenceStatus; +import fr.ird.observe.entities.referentiel.seine.ObjectMaterial; +import fr.ird.observe.entities.referentiel.seine.ObjectMaterialImpl; +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; +import org.apache.commons.lang3.mutable.MutableInt; +import org.apache.commons.logging.Log; +import org.apache.commons.logging.LogFactory; +import org.junit.Test; +import org.nuiton.csv.Common; +import org.nuiton.csv.Import; +import org.nuiton.csv.ext.AbstractImportModel; + +/** + * 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 Log log = LogFactory.getLog(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.901"); + + 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(); + } + } +} ===================================== services-topia/src/main/java/fr/ird/observe/services/binder/referential/seine/ObjectMaterialBinder.java ===================================== --- a/services-topia/src/main/java/fr/ird/observe/services/binder/referential/seine/ObjectMaterialBinder.java +++ b/services-topia/src/main/java/fr/ird/observe/services/binder/referential/seine/ObjectMaterialBinder.java @@ -22,6 +22,7 @@ package fr.ird.observe.services.binder.referential.seine; * #L% */ +import fr.ird.observe.entities.referentiel.I18nReferentialEntity; import fr.ird.observe.entities.referentiel.seine.ObjectMaterial; import fr.ird.observe.entities.referentiel.seine.ObjectMaterialType; import fr.ird.observe.services.binder.referential.ReferentialBinderSupport; @@ -80,7 +81,7 @@ public class ObjectMaterialBinder extends ReferentialBinderSupport<ObjectMateria return toReferentialReference(entity, entity.getCode(), getLabel(referentialLocale, entity), Optional.ofNullable(entity.getParent()).map(ObjectMaterial::getTopiaId).orElse(null), - entity.getObjectMaterialType().getTopiaId(), + Optional.ofNullable(entity.getObjectMaterialType()).map(I18nReferentialEntity::getTopiaId).orElse(null), entity.getValidation()); } ===================================== services-topia/src/test/java/fr/ird/observe/services/topia/service/actions/validate/ValidateServiceTopiaTest.java ===================================== --- a/services-topia/src/test/java/fr/ird/observe/services/topia/service/actions/validate/ValidateServiceTopiaTest.java +++ b/services-topia/src/test/java/fr/ird/observe/services/topia/service/actions/validate/ValidateServiceTopiaTest.java @@ -199,7 +199,7 @@ public class ValidateServiceTopiaTest extends AbstractServiceTopiaTest { assertValidateResultForReferentialDtoType(resultByType, ObjectOperationDto.class, 10); assertValidateResultForReferentialDtoType(resultByType, ObjectTypeDto.class, 23); assertValidateResultForReferentialDtoType(resultByType, ObjectMaterialTypeDto.class, 4); - assertValidateResultForReferentialDtoType(resultByType, ObjectMaterialDto.class, 43); + assertValidateResultForReferentialDtoType(resultByType, ObjectMaterialDto.class, 86); assertValidateResultForReferentialDtoType(resultByType, ObservedSystemDto.class, 21); assertValidateResultForReferentialDtoType(resultByType, ReasonForDiscardDto.class, 5); assertValidateResultForReferentialDtoType(resultByType, ReasonForNoFishingDto.class, 13); ===================================== services-topia/src/test/java/fr/ird/observe/services/topia/service/data/seine/FloatingObjectServiceTopiaTest.java ===================================== --- a/services-topia/src/test/java/fr/ird/observe/services/topia/service/data/seine/FloatingObjectServiceTopiaTest.java +++ b/services-topia/src/test/java/fr/ird/observe/services/topia/service/data/seine/FloatingObjectServiceTopiaTest.java @@ -52,7 +52,7 @@ public class FloatingObjectServiceTopiaTest extends AbstractServiceTopiaTest { List<ObjectMaterialHierarchyDto> form = service.getObjectMaterialHierarchy(); Assert.assertNotNull(form); - Assert.assertEquals(3, form.size()); + Assert.assertEquals(4, form.size()); } ===================================== test/src/main/java/fr/ird/observe/test/ObserveFixtures.java ===================================== --- a/test/src/main/java/fr/ird/observe/test/ObserveFixtures.java +++ b/test/src/main/java/fr/ird/observe/test/ObserveFixtures.java @@ -101,7 +101,7 @@ public class ObserveFixtures { .<String, Long>builder() .put("observe_seine.detectionmode", 11L) .put("observe_seine.objectoperation", 10L) - .put("observe_seine.objectmaterial", 43L) + .put("observe_seine.objectmaterial", 86L) .put("observe_seine.objectmaterialtype", 4L) .put("observe_seine.objecttype", 27L) .put("observe_seine.observedsystem", 21L) ===================================== test/src/main/resources/db/6.901/dataForTestLongline.sql.gz ===================================== Binary files a/test/src/main/resources/db/6.901/dataForTestLongline.sql.gz and b/test/src/main/resources/db/6.901/dataForTestLongline.sql.gz differ ===================================== test/src/main/resources/db/6.901/dataForTestSeine.sql.gz ===================================== Binary files a/test/src/main/resources/db/6.901/dataForTestSeine.sql.gz and b/test/src/main/resources/db/6.901/dataForTestSeine.sql.gz differ ===================================== test/src/main/resources/db/6.901/empty_h2.sql.gz ===================================== Binary files a/test/src/main/resources/db/6.901/empty_h2.sql.gz and b/test/src/main/resources/db/6.901/empty_h2.sql.gz differ ===================================== test/src/main/resources/db/6.901/empty_pg.sql.gz ===================================== Binary files a/test/src/main/resources/db/6.901/empty_pg.sql.gz and b/test/src/main/resources/db/6.901/empty_pg.sql.gz differ ===================================== test/src/main/resources/db/6.901/referentiel.sql.gz ===================================== Binary files a/test/src/main/resources/db/6.901/referentiel.sql.gz and b/test/src/main/resources/db/6.901/referentiel.sql.gz differ View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/compare/373c225e2fc2c2e52d1159558ac... --- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/compare/373c225e2fc2c2e52d1159558ac... You're receiving this email because of your account on gitlab.com.