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

Commits:

7 changed files:

Changes:

  • persistence/src/main/java/fr/ird/observe/persistence/migration/DataSourceMigrationForVersion_7_0_RC_9.java
    ... ... @@ -46,6 +46,7 @@ public abstract class DataSourceMigrationForVersion_7_0_RC_9 extends AbstractObs
    46 46
    47 47 
             addScript("01", "rename_longline_obs", queries);
    48 48 
             addScript("02", "move_wind_referential", queries);
    49 
    +        addScript("03", "wind_i18n", queries);
    49 50
    50 51 
         }
    51 52

  • persistence/src/main/resources/db/migration/6.904/02_move_wind_referential-H2.sql
    1 
    +---
    2 
    +-- #%L
    3 
    +-- ObServe :: Persistence
    4 
    +-- %%
    5 
    +-- Copyright (C) 2008 - 2017 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 General Public License as
    9 
    +-- published by the Free Software Foundation, either version 3 of the
    10 
    +-- License, or (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 General Public
    18 
    +-- License along with this program.  If not, see
    19 
    +-- <http://www.gnu.org/licenses/gpl-3.0.html>.
    20 
    +-- #L%
    21 
    +---
    1 22 
     UPDATE OBSERVE_SEINE.Wind SET TOPIAID = replace(TOPIAID, '.seine', '');
    2 23 
     UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET TYPE = replace(TYPE, '.seine.Wind', '.Wind');
    3 24

  • persistence/src/main/resources/db/migration/6.904/02_move_wind_referential-PG.sql
    1 
    +---
    2 
    +-- #%L
    3 
    +-- ObServe :: Persistence
    4 
    +-- %%
    5 
    +-- Copyright (C) 2008 - 2017 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 General Public License as
    9 
    +-- published by the Free Software Foundation, either version 3 of the
    10 
    +-- License, or (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 General Public
    18 
    +-- License along with this program.  If not, see
    19 
    +-- <http://www.gnu.org/licenses/gpl-3.0.html>.
    20 
    +-- #L%
    21 
    +---
    1 22 
     UPDATE OBSERVE_SEINE.Wind SET TOPIAID = replace(TOPIAID, '.seine', '');
    2 23 
     ALTER TABLE OBSERVE_SEINE.Wind SET SCHEMA OBSERVE_COMMON;
    3 24 
     UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET TYPE = replace(TYPE, '.seine.Wind', '.Wind');

  • persistence/src/main/resources/db/migration/6.904/03_wind_i18n-common.sql
    1 
    +---
    2 
    +-- #%L
    3 
    +-- ObServe :: Persistence
    4 
    +-- %%
    5 
    +-- Copyright (C) 2008 - 2017 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 General Public License as
    9 
    +-- published by the Free Software Foundation, either version 3 of the
    10 
    +-- License, or (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 General Public
    18 
    +-- License along with this program.  If not, see
    19 
    +-- <http://www.gnu.org/licenses/gpl-3.0.html>.
    20 
    +-- #L%
    21 
    +---
    22 
    +
    23 
    +UPDATE Observe_common.Wind SET LABEL2='Calme (Calme)', LABEL1='Calm', LABEL3='Calma (Despejado)' WHERE CODE='0';
    24 
    +UPDATE Observe_common.Wind SET LABEL2='Très légère brise (Calme, ridée)', LABEL1='Light air',LABEL3='Ventolina (Pequeñas olas, pero sin espuma)' WHERE CODE='1';
    25 
    +UPDATE Observe_common.Wind SET LABEL2='Légère brise (Belle, vaguelettes)', LABEL1='Light breeze', LABEL3='Flojito (Crestas de apariencia vítrea, sin romper)' WHERE CODE='2';
    26 
    +UPDATE Observe_common.Wind SET LABEL2='Petite brise (Peu agitée, vaguelettes surmontées de moutons)', LABEL1='Gentle breeze', LABEL3='Flojo (Pequeñas olas, crestas rompientes.)' WHERE CODE='3';
    27 
    +UPDATE Observe_common.Wind SET LABEL2='Jolie brise (Agitée, patites vagues, nombreux moutons)', LABEL1='Moderate breeze', LABEL3='Bonancible (Borreguillos numerosos, olas cada vez más largas)' WHERE CODE='4';
    28 
    +UPDATE Observe_common.Wind SET LABEL2='Bonne brise (Forte, vagues moyennes écumeuses)', LABEL1='Fresh breeze', LABEL3='Fresquito (Olas medianas y alargadas, borreguillos muy abundantes)' WHERE CODE='5';
    29 
    +UPDATE Observe_common.Wind SET LABEL2='Vent frais (Très forte, grosses vagues très écumeuses)', LABEL1='Strong breeze', LABEL3='Fresco (Comienzan a formarse olas grandes, crestas rompientes, espuma)' WHERE CODE='6';
    30 
    +UPDATE Observe_common.Wind SET LABEL2='Fort coup de vent (Enorme, visibilité se réduisant avec l''augmentation de l''écume)', LABEL1='Strong/severe gale', LABEL3='Temporal fuerte (Olas muy grandes, rompientes. Visibilidad mermada)' WHERE CODE='9';
    31 
    +UPDATE Observe_common.Wind SET LABEL2='Coup de vent (Très grosse, trainées décumes bien nettes)', LABEL1='Gale, fresh gale', LABEL3='Temporal (Grandes olas rompientes, franjas de espuma)' WHERE CODE='8';
    32 
    +UPDATE Observe_common.Wind SET LABEL2='Grand frais (Grosse, formation de trainées décumes)', LABEL1='High wind, moderate gale, near gale', LABEL3='Frescachón (Mar gruesa, con espuma arrastrada en dirección del viento)' WHERE CODE='7';
    33 
    +UPDATE Observe_common.Wind SET LABEL2='Tempête (Très grosses lames, visibilité réduite)', LABEL1='Storm, whole gale', LABEL3='Temporal duro (Olas muy gruesas con crestas empenachadas. Superficie del mar blanca)' WHERE CODE='10';
    34 
    +UPDATE Observe_common.Wind SET LABEL2='Violente tempête (Lames exceptionnellement hautes, visibilité très réduite)', LABEL1='Violent storm', LABEL3='Temporal muy duro (Olas excepcionalmente grandes, mar completamente blanca, visibilidad muy reducida)' WHERE CODE='11';
    35 
    +UPDATE Observe_common.Wind SET LABEL2='Ouragan (Mer blanche, air plein d''écume, visibilité nulle)', LABEL1='Hurricane force', LABEL3='Temporal huracanado (Olas excepcionalmente grandes, mar blanca, visibilidad nula)' WHERE CODE='12';
    36 
    +UPDATE OBSERVE_COMMON.Wind SET TOPIAVERSION = TOPIAVERSION +1;
    37 
    +UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE TYPE ='fr.ird.observe.entities.referentiel.Wind';

  • test/src/main/resources/db/6.904/dataForTestLongline.sql.gz
    No preview for this file type
  • test/src/main/resources/db/6.904/dataForTestSeine.sql.gz
    No preview for this file type
  • test/src/main/resources/db/6.904/referentiel.sql.gz
    No preview for this file type

    • —
    View it on GitLab.
    You're receiving this email because of your account on gitlab.com. If you'd like to receive fewer emails, you can adjust your notification settings.