|
Last change
on this file was 8079, checked in by Daniela Dorner, 18 years ago |
|
*** empty log message ***
|
-
Property svn:executable
set to
*
|
|
File size:
751 bytes
|
| Line | |
|---|
| 1 | #!/bin/sh
|
|---|
| 2 |
|
|---|
| 3 | file=SPS.2006.10.17.cp.sql
|
|---|
| 4 | while read LINE
|
|---|
| 5 | do
|
|---|
| 6 | if [ "$LINE" = "" ]
|
|---|
| 7 | then
|
|---|
| 8 | continue
|
|---|
| 9 | fi
|
|---|
| 10 | cal=`echo $LINE | cut -d, -f4`
|
|---|
| 11 | if [ "$cal" = "NULL" ]
|
|---|
| 12 | then
|
|---|
| 13 | continue
|
|---|
| 14 | fi
|
|---|
| 15 | query="UPDATE SequenceProcessStatus set fCallisto=$cal"
|
|---|
| 16 | star=`echo $LINE | cut -d, -f5`
|
|---|
| 17 | if ! [ "$star" = "NULL" ]
|
|---|
| 18 | then
|
|---|
| 19 | query=$query", fStar=$star"
|
|---|
| 20 | fi
|
|---|
| 21 | # echo $LINE
|
|---|
| 22 | seq=`echo $LINE | cut -d\( -f2 | cut -d, -f1`
|
|---|
| 23 | # query=$query", fFillCallisto=NULL, fFillStar=NULL"
|
|---|
| 24 | # query=$query", fStartTime=NULL, fFailedCode=NULL, fReturnCode=NULL"
|
|---|
| 25 | # query=$query", fFailedTime=NULL, fFailedCodeAdd=NULL"
|
|---|
| 26 | query=$query", fAllFilesAvail=Now() where fSequenceFirst=$seq;"
|
|---|
| 27 | # echo "LINE: "$LINE
|
|---|
| 28 | echo $query
|
|---|
| 29 | # sleep 1
|
|---|
| 30 | done < $file
|
|---|
| 31 |
|
|---|
| 32 |
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
