Project

General

Profile

1
#!/bin/sh
2
# Creates analytical DB
3

    
4
selfDir="$(dirname -- "$0")"
5

    
6
exec &>"$selfDir/../inputs/analytical_db/logs/make_analytical_db.log"
7

    
8
set -x
9
date
10

    
11
"$selfDir/psql_verbose_vegbien" <<EOF
12
SELECT make_family_higher_plant_group();
13

    
14
TRUNCATE analytical_stem;
15
INSERT INTO analytical_stem SELECT * FROM analytical_stem_view;
16
TRUNCATE analytical_aggregate;
17
INSERT INTO analytical_aggregate SELECT * FROM analytical_aggregate_view;
18
TRUNCATE geoscrub_input;
19
INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view;
20
EOF
(32-32/63)