|
Last change
on this file since 8204 was 8058, checked in by Daniela Dorner, 18 years ago |
|
*** empty log message ***
|
-
Property svn:executable
set to
*
|
|
File size:
557 bytes
|
| Line | |
|---|
| 1 | #!/bin/sh
|
|---|
| 2 | #
|
|---|
| 3 |
|
|---|
| 4 | query="select concat('/magic/data/rawfiles', Date_Format(adddate(fRunStart, interval 12 HOUR), '/%Y/%m/%d/'),'*', fRunNumber, '*.raw.gz') from RunData where fSequenceFirst='0' and fRunStart > '2004-08-20'"
|
|---|
| 5 |
|
|---|
| 6 | files=`mysql -u MAGIC --host=hercules --password=d99swMT! MyMagic -s -e " $query"`
|
|---|
| 7 |
|
|---|
| 8 | sum=0
|
|---|
| 9 |
|
|---|
| 10 | for file in $files
|
|---|
| 11 | do
|
|---|
| 12 | name=`basename $file`
|
|---|
| 13 | dir=`dirname $file`
|
|---|
| 14 | num=`find $dir -name $name -printf '%k '`
|
|---|
| 15 | if [ "$num" = "" ]
|
|---|
| 16 | then
|
|---|
| 17 | echo "num is empty for $file"
|
|---|
| 18 | continue
|
|---|
| 19 | fi
|
|---|
| 20 | sum=`expr $sum + $num`
|
|---|
| 21 | done
|
|---|
| 22 | echo $sum
|
|---|
| 23 |
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
