github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/migration/v2_to_v3/migr.sh (about)

     1  # Script de transition v2 -> v3
     2  # Script supplémentaires à appliquer ensuite :
     3  #   - convertion des lettres directeurs
     4  #   - décompression des documents
     5  #   - compression JPEG/PDF des docs existants
     6  #   - import du test nautique
     7  #   - vérifier que la tache planifié de cleanup des documents tmp est lancée
     8  #   - script de nettoyage de la base
     9  
    10  echo "Reseting DB v3_dev..." &&
    11      dropdb v3_dev --if-exists &&
    12      createdb v3_dev &&
    13      echo "Copying from go_acve$1..." &&
    14      PGOPTIONS='--client-min-messages=warning' psql -o /dev/null -d v3_dev -q -f $1 &&
    15      echo "Building migration script..." &&
    16      rm migration/v2_to_v3/main.sql &&
    17      cat migration/v2_to_v3/*.sql >migration/v2_to_v3/main.sql &&
    18      echo "Applying migration..." &&
    19      PGOPTIONS='--client-min-messages=warning' psql -o /dev/null -d v3_dev -q -f migration/v2_to_v3/main.sql &&
    20      echo "Done."
    21  echo "Removing old camps & personnes..." &&
    22      PGOPTIONS='--client-min-messages=warning' psql -o /dev/null -d v3_dev -q -f migration/v2_to_v3/menage/delete_old.sql &&
    23      echo "Done."
    24  echo "Creating passwords table..." &&
    25      PGOPTIONS='--client-min-messages=warning' psql -o /dev/null -d v3_dev -q -f server/passwords/1create.sql &&
    26      echo "Done."