Tony CHEMIT pushed to branch develop at ultreiaio / ird-t3

Commits:

2 changed files:

Changes:

  • t3-domain/src/main/java/fr/ird/t3/services/migration/T3MigrationCallbackV2_1.java
    ... ... @@ -122,6 +122,7 @@ public class T3MigrationCallbackV2_1 extends T3MigrationCallbackSupport {
    122 122
             }
    
    123 123
     
    
    124 124
             addScript("08", "remove-Trip-fields", queries);
    
    125
    +        addScript("09", "fill-Harbour-ocean.sql", queries);
    
    125 126
         }
    
    126 127
     
    
    127 128
     
    

  • t3-domain/src/main/resources/db/migration/V2_1_09_fill-Harbour-ocean.sql
    1
    +---
    
    2
    +-- #%L
    
    3
    +-- T3 :: Domain
    
    4
    +-- %%
    
    5
    +-- Copyright (C) 2010 - 2018 IRD, Code Lutin, Ultreia.io
    
    6
    +-- %%
    
    7
    +-- This program is free software: you can redistribute it and/or modify
    
    8
    +-- it under the terms of the GNU Affero General Public License as published by
    
    9
    +-- the Free Software Foundation, either version 3 of the License, or
    
    10
    +-- (at your option) any later version.
    
    11
    +--
    
    12
    +-- This program is distributed in the hope that it will be useful,
    
    13
    +-- but WITHOUT ANY WARRANTY; without even the implied warranty of
    
    14
    +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    
    15
    +-- GNU General Public License for more details.
    
    16
    +--
    
    17
    +-- You should have received a copy of the GNU Affero General Public License
    
    18
    +-- along with this program.  If not, see <http://www.gnu.org/licenses/>.
    
    19
    +-- #L%
    
    20
    +---
    
    21
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528928#0.7684791138625932';
    
    22
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528928#0.7462510491346072';
    
    23
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528931#0.7340362909206456';
    
    24
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528929#0.700537735794819';
    
    25
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528929#0.07144864561003117';
    
    26
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528928#0.20978380101744742';
    
    27
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528933#0.3131099550330918';
    
    28
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528929#0.1831238826180489';
    
    29
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528930#0.27388207197386405';
    
    30
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1460000000000#0.17';
    
    31
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1460000000000#0.11';
    
    32
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1460000000000#0.10';
    
    33
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1460000000000#0.9';
    
    34
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1334600123513#0.12332082367823705';
    
    35
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1460000000000#0.18';
    
    36
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528931#0.5663867925551074';
    
    37
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1460000000000#0.16';
    
    38
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528929#0.23557122752694926';
    
    39
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528928#0.715358107654525';
    
    40
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528928#0.00830660499375091';
    
    41
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528929#0.030809936588289455';
    
    42
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1460000000000#0.1';
    
    43
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528929#0.04293415202169404';
    
    44
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528933#0.6009126144931943';
    
    45
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.4917298410119624' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528931#0.40837275149448937';
    
    46
    +
    
    47
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1460000000000#0.15';
    
    48
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528932#0.863042372573947';
    
    49
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528932#0.9991925653944878';
    
    50
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528932#0.7711735854917587';
    
    51
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528933#0.7511645427969551';
    
    52
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528933#0.17468417015421167';
    
    53
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528933#0.4894751387384305';
    
    54
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528934#0.17822915599428157';
    
    55
    +UPDATE Harbour SET ocean='fr.ird.t3.entities.reference.Ocean#1297580528924#0.02462443299831396' WHERE topiaId = 'fr.ird.t3.entities.reference.Harbour#1297580528932#0.21164070994041773';