Opened 11 years ago
Last modified 11 years ago
#484 closed defect
systemtest import functions not to rely on database IDs — at Initial Version
Reported by: | Piero Campalani | Owned by: | Piero Campalani |
---|---|---|---|
Priority: | minor | Milestone: | 9.0 |
Component: | systemtest | Version: | 8.5 |
Keywords: | Cc: | ||
Complexity: | Easy |
Description
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
Note:
See TracTickets
for help on using tickets.