Changeset 20104 for trunk/Mars/hawc/processing/DiskToDB/extract-aux-data2.sh

Timestamp:

09/05/21 07:13:17 (3 years ago)

Author:

maslowski

Message:

Added Telescope as command line parameter. And fixed some bugs.

File:

• trunk/Mars/hawc/processing/DiskToDB/extract-aux-data2.sh (modified) (4 diffs)

trunk/Mars/hawc/processing/DiskToDB/extract-aux-data2.sh

@@ -30 +30 @@
 # File to which the queries are written
 OUTPUT="insert-aux.sql"
-TMPOUT="./tmpAuxOut.sql"
 # The Mars build directory
-readonly MARS="/home/frankm/Dateien/Mars-6.24.00/build4/"
+readonly MARS="/home/hawc/Desktop/Mars/"
 # The path to your Mars/build directory where the processing macros are stored
-# MACROS="/home/frankm/Dateien/Mars/hawc/processing"
-readonly MACROS="/home/frankm/Dateien/Mars-6.24.00/build/Masterarbeit/Datenbank/HE01/Mexico/Cfiles/"
+readonly MACROS="/home/hawc/Desktop/Mars-src/hawc/processing/"
 readonly PROGRAM=$0
 INSERT="INSERT INTO"
@@ -96 +94 @@
 NIGHT="${4}"
 
+TMPOUT="./tmpAuxOut-${TEL}.sql"
 ERRCODE=
 
@@ -318 +317 @@
 
 # Delete last comma and replace it with closing parintheses
-sed -i '$s/,/)/' "${OUTPUT}"
-
-# Finish the query file with defining the column names
-echo "\
+if [ -f "${TMPOUT}" ]
+then
+        sed -i '$s/,/)/' "${OUTPUT}"
+
+        # Finish the query file with defining the column names
+        echo "\
 AS
 v(
@@ -337 +338 @@
 "\ >> ${OUTPUT}
 
-cat ${TMPOUT} >> ${OUTPUT}
+else
+        head -n -4 "${OUTPUT}" > out.sql.new && mv out.sql.new "${OUTPUT}"
+fi
+
+if [ -f "${TMPOUT}" ]
+then
+        cat ${TMPOUT} >> ${OUTPUT}
+fi
 
 rm -f ${TMPOUT}