Changeset 42531 for branches/eam_branches/ipp-20230313/tools/eam/rawfix.20230221/src/check.rawfix.sh

Timestamp:

Aug 17, 2023, 4:41:34 PM (3 years ago)

Author:

eugene

Message:

merging from trunk

Location:

branches/eam_branches/ipp-20230313/tools

Files:

• . (modified) (1 prop)
• eam/rawfix.20230221/src/check.rawfix.sh (modified) (5 diffs)

branches/eam_branches/ipp-20230313/tools/eam/rawfix.20230221/src/check.rawfix.sh

@@ -14 +14 @@
 
 # make the rawfix database to track rawfix operations
-set DBHOST = "ipp060"
+set DBHOST = "ippc190"
 set DBNAME = "rawfix"
-set DBUSER = "dvo"
-set DBPASS = "dvo"
+# set DBUSER = "dvo"
+# set DBPASS = "dvo"
 
 # set DBOPTS = "-B --skip-column-names -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME"
-set DBOPTS = "-B -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME"
+set DBOPTS = "--defaults-extra-file=~/.my.cnf.rawfix -B -h $DBHOST $DBNAME"
 
 if ($mode == "all") then
@@ -28 +28 @@
   endif
 
-  mysql $DBOPTS -e "select dateobs, state from nights"
+  mysql $DBOPTS -e "select dateobs, iter, state from nights"
   exit 0
 endif
@@ -49 +49 @@
 
   set mynight = $2
-  mysql $DBOPTS -e "select dateobs, state from nights where (dateobs = '$mynight')"
+  mysql $DBOPTS -E -e "select * from nights where (dateobs = '$mynight')"
   exit 0
 endif
@@ -61 +61 @@
   set mystate = $2
 
-  if ($mystate == "new") goto good_state
-  if ($mystate == "rsync") goto good_state
-  if ($mystate == "md5sum.new") goto good_state
-  if ($mystate == "md5sum.done") goto good_state
-  if ($mystate == "md5sum.fail") goto good_state
-  if ($mystate == "ckchip.new") goto good_state
-  if ($mystate == "ckchip.done") goto good_state
-  if ($mystate == "ckchip.fail") goto good_state
-  if ($mystate == "fixchip.new") goto good_state
-  if ($mystate == "fixchip.done") goto good_state
-  if ($mystate == "fixchip.fail") goto good_state
+  if ($mystate == "ckchip.new")      goto good_state
+  if ($mystate == "ckchip.done")     goto good_state
+  if ($mystate == "ckchip.fail")     goto good_state
+  if ($mystate == "fixchip.new")     goto good_state
+  if ($mystate == "fixchip.done")    goto good_state
+  if ($mystate == "fixchip.fail")    goto good_state
+  if ($mystate == "md5sum.new")      goto good_state
+  if ($mystate == "md5sum.done")     goto good_state
+  if ($mystate == "md5sum.fail")     goto good_state
+  if ($mystate == "md5chk.new")      goto good_state
+  if ($mystate == "md5chk.done")     goto good_state
+  if ($mystate == "md5chk.fail")     goto good_state
+  if ($mystate == "burntool.new")    goto good_state
+  if ($mystate == "burntool.done")   goto good_state
+  if ($mystate == "burntool.fail")   goto good_state
 
   echo "ERROR: unknown mode $mystate"
@@ -77 +81 @@
 
   good_state:
-  mysql $DBOPTS -e "select dateobs from nights where (state = '$mystate')"
+  set t = `date +%T..%N`
+  mysql $DBOPTS -e "select dateobs, iter from nights where (state = '$mystate')" | awk -v T=$t '(NR == 1){print $0, "timestamp"}(NR > 1){print $1, $2, T}'
   exit 0
 endif