Changeset 9088 for trunk/MagicSoft

Timestamp:

08/05/08 09:44:03 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• datacenter/scripts/makecallistolinks (modified) (1 diff)
• datacenter/scripts/sourcefile (modified) (2 diffs)
• datacenter/tools/resetpriorities (added)

trunk/MagicSoft/Mars/Changelog

@@ -18 +18 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2008/08/05 Daniela Dorner
+
+   * datacenter/tools/resetpriorities:
+     - added (script to reset priorities in the tables RunProcessStatus,
+       SequenceProcessStatus and DataSetProcessStatus)
+
+   * datacenter/scripts/makecallistolinks:
+     - removed not needed output
+
+   * datacenter/scripts/sourcefile:
+     - fixed bug in query of setstatus 
+     - improved if-clause to avoid unneccessary output
+
+
 
  2008/08/04 Daniela Dorner

trunk/MagicSoft/Mars/datacenter/scripts/makecallistolinks

@@ -54 +54 @@
 query="SELECT fSequenceFirst, fTelescopeNumber from SequenceProcessStatus where fReturnCode=13 and fProgramId=14"
 primaries=( `sendquery` )
-echo ${primaries[@]}
 if [ ${#primaries[@]} -eq 0 ]
 then 

trunk/MagicSoft/Mars/datacenter/scripts/sourcefile

@@ -281 +281 @@
    query=$query" and isnull(fStartTime) and isnull(fFailedTime) and isnull(fProgramId) and isnull(fReturnCode) "
    query=$query" order by fPriority desc "
-   if [ "$@" != "" ]
+   if [ "$@ " != " " ]
    then 
       query=$query" limit 0, $@ "
@@ -367 +367 @@
       if [ $i -lt `expr ${#prims[@]} - 1` ]
       then 
-         query=$query" ${prims[$i]}=${primaries[$s+$s+$i]} and "
+         query=$query" ${prims[$i]}='${primaries[$s+$s+$i]}' and "
       else
-         query=$query" ${prims[$i]}=${primaries[$s+$s+$i]} "
+         query=$query" ${prims[$i]}='${primaries[$s+$s+$i]}' "
       fi
    done