prepare-test-db.sh

   1 #! /bin/bash
   2
   3 export PHOROS_HOST=localhost
   4 export PHOROS_DATABASE=phoros_test
   5 export PHOROS_AUX_HOST=localhost
   6 export PHOROS_AUX_DATABASE=phoros_test
   7 export PHOROS_COMMON_ROOT=`pwd`/testsuite/
   8 export PHOROS_LOG_DIR=preparation-test.log/
   9
  10 ./phoros --version --verbose=libraries:1
  11
  12 ./phoros --nuke-all-tables
  13
  14 ./phoros --create-sys-tables
  15
  16 ./testsuite/calib-storage.sh
  17
  18 ./phoros --create-acquisition-project=cottbus-acq-1
  19 ./phoros --create-acquisition-project=cottbus-acq-2
  20
  21 ./phoros --create-presentation-project=cottbus-presentation
  22
  23 ./phoros --create-user=pub --user-password=pp6 --user-full-name="John Q. Public" --user-role=write --presentation-project=cottbus-presentation
  24 ./phoros --create-user=uu6 --user-password=pp6 --user-full-name="Ulf6 Uuu6" --user-role=admin --presentation-project=cottbus-presentation
  25
  26 # ./phoros --store-user-points=cottbus-presentation --json-file=user-points-cottbus-presentation.json
  27
  28 # ./phoros --create-aux-view=cottbus-presentation \
  29 #     --aux-table= \
  30 #     --coordinates-column=the_geom \
  31 #     --numeric-column=nk_station \
  32 #     --numeric-column= \
  33 #     --numeric-column= \
  34 #     --text-column= \
  35 #     --text-column=vnk \
  36 #     --text-column=nnk \
  37 #     --text-column=strasse \
  38 #     $pg_aux_credentials
  39
  40 ./phoros --create-image-attribute=cottbus-presentation --tag="east" --sql-clause="heading BETWEEN 0 AND 180"
  41 ./phoros --create-image-attribute=cottbus-presentation --tag="south" --sql-clause="heading BETWEEN 90 AND 270"
  42 ./phoros --create-image-attribute=cottbus-presentation --tag="west" --sql-clause="heading BETWEEN 180 AND 360"
  43 ./phoros --create-image-attribute=cottbus-presentation --tag="north" --sql-clause="heading BETWEEN 270 AND 360 OR heading BETWEEN 0 AND 90"
  44
  45 ./phoros --store-images-and-points=cottbus-acq-1 --directory=`pwd`/testsuite/cottbus_0696/
  46 ./phoros --add-to-presentation-project=cottbus-presentation --acquisition-project=cottbus-acq-1
  47
  48 ./phoros --store-images-and-points=cottbus-acq-2 --directory=`pwd`/testsuite/cottbus_0756/
  49 ./phoros --add-to-presentation-project=cottbus-presentation --acquisition-project=cottbus-acq-2
  50
  51
  52 ./phoros --server --verbose=no-daemon:1 --verbose=render-footprints:1 --images=7 --http-port=8080 --login-intro="Please use Firefox or one of its relatives." --login-intro="It is recommendable to set your browser cache size to about 2000 MB." --login-intro="Also make sure that you have a decent Internet connection."