Revision 8319
Added by Aaron Marcuse-Kubitza over 11 years ago
| bin/export_analytical_db | ||
|---|---|---|
| 6 | 6 |
cd "$selfDir/.." |
| 7 | 7 |
|
| 8 | 8 |
. "$selfDir/vegbien_dest" |
| 9 |
out="backups/analytical_aggregate.$public.csv"
|
|
| 9 |
out="backups/analytical_stem.$public.csv"
|
|
| 10 | 10 |
|
| 11 | 11 |
"$selfDir/psql_script_vegbien" >"$out" <<EOF |
| 12 |
COPY analytical_aggregate TO STDOUT CSV HEADER NULL 'NULL';
|
|
| 12 |
COPY analytical_stem TO STDOUT CSV HEADER NULL 'NULL';
|
|
| 13 | 13 |
EOF |
| 14 | 14 |
make "$out.md5" |
| README.TXT | ||
|---|---|---|
| 93 | 93 |
cd /home/bien/svn/ |
| 94 | 94 |
svn up |
| 95 | 95 |
export version=<version> |
| 96 |
make backups/analytical_aggregate.$version.csv/download
|
|
| 96 |
make backups/analytical_stem.$version.csv/download
|
|
| 97 | 97 |
In the bien_web DB: |
| 98 |
Create the analytical_aggregate_<version> table using its schema
|
|
| 98 |
Create the analytical_stem_<version> table using its schema
|
|
| 99 | 99 |
in schemas/vegbien.my.sql |
| 100 |
make -s backups/analytical_aggregate.$version.csv.md5/test
|
|
| 100 |
make -s backups/analytical_stem.$version.csv.md5/test
|
|
| 101 | 101 |
Check that "OK" is printed next to the filename |
| 102 |
env table=analytical_aggregate_$version bin/publish_analytical_db \
|
|
| 103 |
backups/analytical_aggregate.$version.csv
|
|
| 102 |
env table=analytical_stem_$version bin/publish_analytical_db \
|
|
| 103 |
backups/analytical_stem.$version.csv
|
|
| 104 | 104 |
If desired, record the import times in inputs/import.stats.xls: |
| 105 | 105 |
Open inputs/import.stats.xls |
| 106 | 106 |
If the rightmost import is within 5 columns of column IV: |
Also available in: Unified diff
bin/export_analytical_db: Replaced analytical_aggregate with analytical_stem