Update content due to data update

ThomasG77 · ThomasG77 · commit c43b64f61060 · 2024-04-17T11:35:30.000+02:00
diff --git a/db/build_db.sh b/db/build_db.sh
@@ -3,8 +3,10 @@
 DIR=$(echo $(dirname $0))
 cd $DIR
 
-month="06"
+month="12"
 year_end="2023"
+min_year=2019
+max_year=2023
 
 sudo -u postgres psql -c "DROP DATABASE IF EXISTS dvf_${year_end}${month};"
 sudo -u postgres psql -c "CREATE DATABASE dvf_${year_end}${month};"
@@ -15,7 +17,7 @@ sudo -u postgres psql -d dvf_${year_end}${month} -f "create_table.sql"
 DATADIR="data"
 mkdir -p $DATADIR
 
-for YEAR in {2018..2023}
+for ((YEAR = $min_year ; YEAR <= $max_year ; YEAR++));
 do
   [ ! -f $DATADIR/full_$YEAR.csv.gz ] && wget -r -np -nH -N --cut-dirs 5  https://files.data.gouv.fr/geo-dvf/latest/csv/$YEAR/full.csv.gz -O $DATADIR/full_$YEAR.csv.gz
 done
@@ -24,7 +26,7 @@ find $DATADIR -name '*.gz' -exec gunzip -f '{}' \;
 
 #Chargement des donn&eacute;es dans postgres
 DATAPATH=$( cd $DATADIR ; pwd -P )
-for YEAR in {2018..2023}
+for ((YEAR = $min_year ; YEAR <= $max_year ; YEAR++));
 do
   sudo -u postgres psql -d dvf_$year_end$month -c "COPY dvf FROM '$DATAPATH/full_$YEAR.csv' delimiter ',' csv header encoding 'UTF8';"
 done
diff --git a/static/js/index.js b/static/js/index.js
@@ -24,8 +24,8 @@ vue.$watch('fold_left', function () {
 
 // D&eacute;finition des variables globales
 
-var MIN_DATE = '2018-07-01'
-var MAX_DATE = '2023-06-30'
+var MIN_DATE = '2019-01-01'
+var MAX_DATE = '2023-12-31'
 
 var map = null;
 var mapLoaded = false;
