rm data from file after it has been applied in csql

[chapm4]

Hi,

I have a script that reads numbers from a seperate file and runs a csql update applying a negative to cartons that are in that group number. I want to remove that number from the file after the negative is applied so that group is not updated again. Simple question that I think I have made confusing.

Example:

mgCheck.txt:
37812
37813
37814

mgCheck:
for input in $(cat mgCheck.txt)
do
csql -c -f "update carton set skuWeight = skuWeight -9999 _
where masterGroupId = ( '00000$input' ) and status = 65"
done

In the example above lets say that 37812 is updated to negative. I want to remove that from mgCheck.txt so that it is not updated again when the script runs automatically 30 minutes later. Thanks for any help.

 

[grega]

A couple of questions ...

- Is every group in the file updated, or do you only want to remove some groups for each pass?

- How can you tell if the group has satisfied the query conditions and been updated? Does csql give a specific exit status depending on what happened?

If so, you could do something like

rm mgCheck.tmp
for input in $(cat mgCheck.txt)
do
  ctsql ....
  if group not updated
     echo $input >> mgCheck.tmp
done
mv mgCheck.tmp mgCheck.txt

Greg.

 

[chapm4]

Thanks for the response. Yes it is only some of the groups that get updated on the pass and I only want to remove those groups from the mgCheck.txt file. Only some of those groups (signified by group number like 37819) will be in the database and only those records will be updated. And those again are the only ones I want to remove.