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

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

@@ -1 +1 @@
 #!/bin/csh
 
-if ($#argv != 1) then
-  echo "USAGE: queue.rawfix.sh (mjddate)"
+if ($#argv != 2) then
+  echo "USAGE: queue.rawfix.sh (list) (filename)"
+  echo "USAGE: queue.rawfix.sh (night) (YYYYMMDD)"
   exit 2
 endif
 
+set mode = $1
+
 # 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"
 
-## XXX validate the format (YYYYMMDD)?
-set mynight = $1
+set DBOPTS = "--defaults-extra-file=~/.my.cnf.rawfix -h $DBHOST $DBNAME"
 
-mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME -e "insert into nights (dateobs, state) values ('$mynight', 'new')"
+if ($mode == "list") then
+  set filename = $2
+
+  # validate the list: could be DATE STATE or just DATE (prcol 1)?
+
+  # just a big list of dates?
+  foreach night (`cat $filename`)
+    queue.rawfix.sh night $night
+  end
+  exit 0
+endif
+
+if ($mode == "night") then
+  ## XXX validate the format (YYYYMMDD)?
+  set mynight = $2
+  
+  set year = `echo $mynight | awk '{print substr($0, 1, 4)}'`
+  if (($year < 2005) || ($year > 2030)) then
+    echo "invalid date $mynight"
+    exit 2
+  endif
+
+  set month = `echo $mynight | awk '{print 1*substr($0, 5, 2)}'`
+  if (($month < 1) || ($month > 12)) then
+    echo "invalid date $mynight"
+    exit 2
+  endif
+
+  set day = `echo $mynight | awk '{print 1*substr($0, 7, 2)}'`
+  if (($day < 1) || ($day > 31)) then
+    echo "invalid date $mynight"
+    exit 2
+  endif
+
+  mysql $DBOPTS -e "insert into nights (dateobs, state) values ('$mynight', 'new')"
+  exit 0
+endif
+
+echo "ERROR: unknown mode $mode"
+exit 2