systemtest import functions not to rely on database IDs

[Piero Campalani]

Some INSERT statements in the systemtest import functions rely on database IDs.

This is related to functions in ./systemtest/util/petascope.sh:

$ egrep 'PS_crsset|PS_Range' ./systemtest/util/petascope.sh -r
  $PSQL -c "delete from PS_Range where coverage = $c_id" > /dev/null
  $PSQL -c "delete from PS_crsset where axis = $x_id" > /dev/null
  $PSQL -c "delete from PS_crsset where axis = $y_id" > /dev/null
  $PSQL -c "insert into PS_Range (coverage, i, name, type) values ($c_id, 0, 'value', 4)" > /dev/null || exit $RC_ERROR
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $x_id, 9)" > /dev/null || exit $RC_ERROR
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $y_id, 9)" > /dev/null || exit $RC_ERROR
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $t_id, 8)" > /dev/null || exit $RC_ERROR
  $PSQL -c "insert into PS_Range (coverage, i, name, type) values ($c_id, 0, 'red', 7)" > /dev/null
  $PSQL -c "insert into PS_Range (coverage, i, name, type) values ($c_id, 1, 'green', 7)" > /dev/null
  $PSQL -c "insert into PS_Range (coverage, i, name, type) values ($c_id, 2, 'blue', 7)" > /dev/null
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $x_id, 8)" > /dev/null
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $y_id, 8)" > /dev/null
  $PSQL -c "insert into PS_Range (coverage, i, name, type) values ($c_id, 0, 'value', 2)" > /dev/null
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $x_id, 8)" > /dev/null
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $y_id, 8)" > /dev/null
  $PSQL -c "insert into PS_Range (coverage, i, name, type) values ($c_id, 0, 'value', 2)" > /dev/null
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $x_id, 9)" > /dev/null
  $PSQL -c "insert into PS_crsset ( axis, crs) values ( $y_id, 9)" > /dev/null

[Piero Campalani]

Fixed already four months ago in changeset:3db4936.

git show 3db4936 ~/rasdaman/systemtest/util/petascope.sh