-revert... functions are too limited

[eugene]

the chiptool -revertprocessedimfile (and equivalent functions) require a single chip_id or cam_id. this makes it fairly painful to do a bulk revert: it is necessary to either supply the correct chip_ids or loop over all possible and trigger many failures. it would be nice for the tool to be capable of selecting the chip_ids. I propose we add the following features:

• do not require -chip_id (or equivalent)
• add additional selection features (time, filter, etc; the fields allowed for -queue)
• add a -pretend option
• if no restrictions are supplied, do nothing
• add a -all (or some equivalent word) to force all even if no restrictions are supplied.

[jhoblitt]

libjpeg w/ gnuconf & libtool bits upgraded

[jhoblitt]

(From update of attachment 115)
oops. I hate it when bugzilla does that.

[rodney]

It seems that some of this functionality has been introduced. e.g.

chiptool -revertprocessedimfile -all

will do

DELETE FROM chipProcessedImfile
USING chipProcessedImfile, rawExp
WHERE

rawExp.exp_id = chipProcessedImfile.exp_id
AND chipProcessedImfile.fault != 0

However,

chiptool -revertprocessedimfile -code 2

does not do what the chiptool docstring claims:
DELETE FROM chipProcessedImfile
USING chipProcessedImfile, rawExp
WHERE

rawExp.exp_id = chipProcessedImfile.exp_id
AND chipProcessedImfile.fault == 2

[rodney]

SQL syntax errors in chiptool -processedimfile :

rodney@ipp003> chiptool -processedimfile -chip_id 68 -dbname sress

p_psDBRunQuery (psDB.c:837) : Failed to execute SQL query. Error: Unknown column 'chipProcessedImfile.chipRun.chip_id' in 'where clause'
processedimfileMode (chiptool.c:615) : database error

-> p_psDBRunQuery (psDB.c:837): Database error generated by the server

Failed to execute SQL query. Error: Unknown column 'chipProcessedImfile.chipRun.chip_id' in 'where clause'

-> processedimfileMode (chiptool.c:615): unknown psLib error

database error

The same problem comes up with the -exp_id option.

[eugene]

these errors have been addressed with the pxchip/cam/warpGet/SetSearchArgs functions.