Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 5eaaef3d by Tony Chemit at 2020-12-28T12:32:04+01:00 Ajouts au référentiel VesseType - Closes #1704 - - - - - 7 changed files: - models/persistence/src/main/resources/db/migration/8.0/01_update_referential-common.sql - models/persistence/src/test/resources/fixtures/persistence/count-referential-common.properties - models/persistence/src/test/resources/fixtures/persistence/entity-tables-count-referential.properties - tests/test/src/main/resources/db/8.0/dataForTestLongline.sql.gz - tests/test/src/main/resources/db/8.0/dataForTestSeine.sql.gz - tests/test/src/main/resources/db/8.0/referentiel.sql.gz - tests/test/src/main/resources/fixtures/global.properties Changes: ===================================== models/persistence/src/main/resources/db/migration/8.0/01_update_referential-common.sql ===================================== @@ -20,8 +20,10 @@ -- #L% --- -INSERT INTO observe_common.VesselType(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.VesselType#666#1' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, null,'Industrial longliner', 'Palangrier industriel','Palangrero industrial'); -INSERT INTO observe_common.VesselType(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.VesselType#666#2' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, null,'Semi industrial longliner', 'Palangrier semi industriel','Palangreros semindustriales'); +INSERT INTO observe_common.VesselType(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, code, label1, label2, label3) values ('fr.ird.referential.common.VesselType#1464000000000#0.14' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, '14','Industrial longliner', 'Palangrier industriel','Palangrero industrial'); +INSERT INTO observe_common.VesselType(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, code, label1, label2, label3) values ('fr.ird.referential.common.VesselType#1464000000000#0.15' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, '15','Semi industrial longliner', 'Palangrier semi industriel','Palangreros semindustriales'); +INSERT INTO observe_common.VesselType(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, code, label1, label2, label3) values ('fr.ird.referential.common.VesselType#1464000000000#0.16' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, '16','Schooner', 'Goélette','Goleta'); +INSERT INTO observe_common.VesselType(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, code, label1, label2, label3) values ('fr.ird.referential.common.VesselType#1464000000000#0.17' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, '17','Handliner', 'Palangrotte','Handlin'); INSERT INTO observe_longline.vesselactivity(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'CRUISE', 'Cruising', 'Route','Route #TODO'); INSERT INTO observe_longline.vesselactivity(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'DRIFT', 'Drifting', 'En dérive','En dérive #TODO'); ===================================== models/persistence/src/test/resources/fixtures/persistence/count-referential-common.properties ===================================== @@ -48,7 +48,7 @@ common.speciesgroup_speciesgroupreleasemode=19 common.specieslist=8 common.vessel=1172 common.vesselsizecategory=13 -common.vesseltype=16 +common.vesseltype=18 common.weightmeasuremethod=4 common.weightmeasuretype=3 common.wind=13 ===================================== models/persistence/src/test/resources/fixtures/persistence/entity-tables-count-referential.properties ===================================== @@ -42,7 +42,7 @@ fr.ird.observe.entities.referential.common.SpeciesGroupReleaseMode=9 fr.ird.observe.entities.referential.common.SpeciesList=8 fr.ird.observe.entities.referential.common.Vessel=1172 fr.ird.observe.entities.referential.common.VesselSizeCategory=13 -fr.ird.observe.entities.referential.common.VesselType=16 +fr.ird.observe.entities.referential.common.VesselType=18 fr.ird.observe.entities.referential.common.WeightMeasureMethod=4 fr.ird.observe.entities.referential.common.WeightMeasureType=3 fr.ird.observe.entities.referential.common.Wind=13 ===================================== tests/test/src/main/resources/db/8.0/dataForTestLongline.sql.gz ===================================== Binary files a/tests/test/src/main/resources/db/8.0/dataForTestLongline.sql.gz and b/tests/test/src/main/resources/db/8.0/dataForTestLongline.sql.gz differ ===================================== tests/test/src/main/resources/db/8.0/dataForTestSeine.sql.gz ===================================== Binary files a/tests/test/src/main/resources/db/8.0/dataForTestSeine.sql.gz and b/tests/test/src/main/resources/db/8.0/dataForTestSeine.sql.gz differ ===================================== tests/test/src/main/resources/db/8.0/referentiel.sql.gz ===================================== Binary files a/tests/test/src/main/resources/db/8.0/referentiel.sql.gz and b/tests/test/src/main/resources/db/8.0/referentiel.sql.gz differ ===================================== tests/test/src/main/resources/fixtures/global.properties ===================================== @@ -35,5 +35,5 @@ SPECIES_GROUP_ID=fr.ird.referential.common.SpeciesGroup#1239832683689#0.71201161 # for fr.ird.observe.spi.DbModelHelperTest REFERENCE_DATA_COUNT=52 # for fr.ird.observe.services.local.service.referential.differential.DifferentialModelTest -REFERENTIAL_COUNT=3017 +REFERENTIAL_COUNT=3019 ENTITIES_LIMIT_SIZE=100 View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/5eaaef3df681e6caaafcd432f8... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/5eaaef3df681e6caaafcd432f8... You're receiving this email because of your account on gitlab.com.