Changeset 42531 for branches/eam_branches/ipp-20230313/tools/eam/rawfix.20230221/src/update.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/update.rawfix.sh (modified) (2 diffs)

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

@@ -2 +2 @@
 
 if ($#argv < 1) then
-  echo "USAGE: update.rawfix.sh (night) (state) [quality]"
+  echo "USAGE: update.rawfix.sh (night) (state) [iter]"
   echo "   EG: update.rawfix.sh 20100501 new"
   exit 2
@@ -10 +10 @@
 set state   = $2
 
+set iter = ""
+if ($#argv == 3) then
+  set iter = ", iter = $3"
+endif
+
 # 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 --skip-column-names -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME"
+set DBOPTS = "--defaults-extra-file=~/.my.cnf.rawfix -B --skip-column-names -h $DBHOST $DBNAME"
 
-mysql $DBOPTS -e "update nights set state = '$state' where (dateobs = '$mynight')"
+mysql $DBOPTS -e "update nights set state = '$state' $iter where (dateobs = '$mynight')"
 exit 0