Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 1b7dd1d4 by Tony Chemit at 2020-12-29T12:27:39+01:00 Peaufinage de la table common.country - Closes #1708 - - - - - 7 changed files: - models/persistence/src/main/resources/db/migration/8.0/30_common_fill-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/30_common_fill-common.sql ===================================== @@ -66,6 +66,9 @@ INSERT INTO common.WeightMeasureMethod(topiaId, topiaVersion, topiaCreateDate, l INSERT INTO common.WeightMeasureMethod(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, label1, label2, label3) values ('fr.ird.referential.common.WeightMeasureMethod#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Visual estimate', 'Estimation visuelle', 'Estimación visual'); INSERT INTO common.WeightMeasureMethod(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, label1, label2, label3) values ('fr.ird.referential.common.WeightMeasureMethod#666#04' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Estimate with sounder', 'Estimation au sondeur', 'Estimación con la ecosonda'); +INSERT INTO common.country(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, homeid, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8, iso2code, iso3code) VALUES ('fr.ird.referential.common.Country#1609197326325#0.9797981297337345', 1, '2020-12-28 23:13:40.571', '2020-12-28 23:15:26.372', '92', null, null, 'f', 1, 'Philippines', 'Philippines', 'Filipinas', null, null, null, null, null, 'PH', 'PHL'); +INSERT INTO common.country(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, homeid, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8, iso2code, iso3code) VALUES ('fr.ird.referential.common.Country#1609197447702#0.5128194152482344', 1, '2020-12-28 23:16:24.312', '2020-12-28 23:17:27.702', '93', null, null, 'f', 1, 'Oman', 'Oman', 'Omán', null, null, null, null, null, 'OM', 'OMN'); + UPDATE common.country SET iso2code = 'MR', iso3code = 'MRT', topiaVersion = topiaVersion + 1, lastUpdateDate = '2019-01-15 00:00:00.0' WHERE topiaId = 'fr.ird.referential.common.Country#1464000000000#0.00054'; UPDATE common.country SET iso2code = 'PR', iso3code = 'PRI', topiaVersion = topiaVersion + 1, lastUpdateDate = '2019-01-15 00:00:00.0' WHERE topiaId = 'fr.ird.referential.common.Country#1464000000000#0.00076'; ===================================== models/persistence/src/test/resources/fixtures/persistence/count-referential-common.properties ===================================== @@ -20,7 +20,7 @@ # #L% ### # suppress inspection "SpellCheckingInspection" for whole file -common.country=72 +common.country=74 common.dataquality=5 common.fpazone=42 common.gear=26 ===================================== models/persistence/src/test/resources/fixtures/persistence/entity-tables-count-referential.properties ===================================== @@ -19,7 +19,7 @@ # <http://www.gnu.org/licenses/gpl-3.0.html>. # #L% ### -fr.ird.observe.entities.referential.common.Country=72 +fr.ird.observe.entities.referential.common.Country=74 fr.ird.observe.entities.referential.common.DataQuality=5 fr.ird.observe.entities.referential.common.FpaZone=42 fr.ird.observe.entities.referential.common.Gear=26 ===================================== 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=3028 +REFERENTIAL_COUNT=3030 ENTITIES_LIMIT_SIZE=100 View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/1b7dd1d4bdd169d16763e405df... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/1b7dd1d4bdd169d16763e405df... You're receiving this email because of your account on gitlab.com.