#!/bin/csh -f

if($1 == "-h" || $1 == ""  || $2 == "" || $#argv != 2) then
 echo " "
 echo "Usage:   "
 echo  "  >> edit_volume_in_table tablename volumename"
 echo  "     add/replace <volumename> into table <tablename>"
 echo " "
 exit 0
endif

set table = $1
set vname = $2


rm -rf tmp6.txt
echo  "use user_geometry;" > tmp6.txt
echo  "select name, mother, description, pos, rot, col, type, dimensions, material, magfield, ncopy, pmany, exist, visible, style, sensitivity, hitType, identity from $table" 'where name = "'$vname'";' >> tmp6.txt 

# for some reason I can't do it all at once
set vname  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $1}'`)
set mvname = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $2}'`)
set descri = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $3}'`)
set vposi  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $4}'`)
set vrota  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $5}'`)
set vcolor = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $6}'`)
set solid  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $7}'`)
set dimens = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $8}'`)
set materi = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $9}'`)
set mfield = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $10}'`)
set ncopy  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $11}'`)
set pmany  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $12}'`)
set exist  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $13}'`)
set visibl = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $14}'`)
set style  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $15}'`)
set sensi  = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $16}'`)
set hitype = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $17}'`)
set identi = (`mysql -h $GEMC_HOST -u $GEMC_USER < tmp6.txt | grep $vname | awk -F"	" '{print $18}'`)

if("$vname" == "" ) then
 echo  "  >> edit_geo_volume tablename volumename"
 echo  "     add/replace <volumename> into table <tablename>"
 echo 
 exit 0
endif


rm -f tmp.txt
echo " "                                               > tmp.txt
echo " Adding new volume to table:" $1                >> tmp.txt
echo " "                                              >> tmp.txt
echo " ---------------------------------------------" >> tmp.txt
echo " "                                              >> tmp.txt
echo " Volume Name                    ==  $vname"     >> tmp.txt
echo " Mother Volume                  ==  $mvname"    >> tmp.txt
echo " Volume Description             ==  $descri"    >> tmp.txt
echo " Position                       ==  $vposi"     >> tmp.txt
echo " Rotation                       ==  $vrota"     >> tmp.txt
echo " Color rrggbb                   ==  $vcolor"    >> tmp.txt
echo " Solid Type                     ==  $solid"     >> tmp.txt
echo " Solid Dimensions               ==  $dimens"    >> tmp.txt
echo " Material                       ==  $materi"    >> tmp.txt
echo " Magnetic Field                 ==  $mfield"    >> tmp.txt
echo " copy number                    ==  $ncopy"     >> tmp.txt
echo " pMany                          ==  $pmany"     >> tmp.txt
echo " exist                          ==  $exist"     >> tmp.txt
echo " visible                        ==  $visibl"    >> tmp.txt
echo " style                          ==  $style"     >> tmp.txt
echo " Sensitivity                    ==  $sensi"     >> tmp.txt
echo " Hit Type                       ==  $hitype"    >> tmp.txt
echo " Identifiers                    ==  $identi"    >> tmp.txt
echo " "                                              >> tmp.txt
echo " "                                              >> tmp.txt
echo " ---------------------------------------------" >> tmp.txt

$EDITOR tmp.txt

set vname  = (`cat tmp.txt | grep "Volume Name"      | awk -F"==" '{print $2}'`)
set mvname = (`cat tmp.txt | grep "Mother Volume"    | awk -F"==" '{print $2}'`)
set descri = (`cat tmp.txt | grep "Description"      | awk -F"==" '{print $2}'`)
set vposi  = (`cat tmp.txt | grep "Position"         | awk -F"==" '{print $2}'`)
set vrota  = (`cat tmp.txt | grep "Rotation"         | awk -F"==" '{print $2}'`)
set vcolor = (`cat tmp.txt | grep "Color"            | awk -F"==" '{print $2}'`)
set solid  = (`cat tmp.txt | grep "Solid Type"       | awk -F"==" '{print $2}'`)
set dimens = (`cat tmp.txt | grep "Solid Dimensions" | awk -F"==" '{print $2}'`)
set materi = (`cat tmp.txt | grep "Material"         | awk -F"==" '{print $2}'`)
set mfield = (`cat tmp.txt | grep "Magnetic"         | awk -F"==" '{print $2}'`)
set ncopy  = (`cat tmp.txt | grep "copy number"      | awk -F"==" '{print $2}'`)
set pmany  = (`cat tmp.txt | grep "pMany"            | awk -F"==" '{print $2}'`)
set exist  = (`cat tmp.txt | grep "exist"            | awk -F"==" '{print $2}'`)
set visibl = (`cat tmp.txt | grep "visible"          | awk -F"==" '{print $2}'`)
set style  = (`cat tmp.txt | grep "style"            | awk -F"==" '{print $2}'`)
set sensi  = (`cat tmp.txt | grep "Sensitivity"      | awk -F"==" '{print $2}'`)
set hitype = (`cat tmp.txt | grep "Hit Type"         | awk -F"==" '{print $2}'`)
set identi = (`cat tmp.txt | grep "Identifiers"      | awk -F"==" '{print $2}'`)

echo
echo Volume Name: $vname
echo Mother Volume: $mvname
echo Description: "$descri"
echo Position in the mother volume: "$vposi"
echo Rotation in the mother volume: "$vrota"
echo Color: $vcolor
echo Solid Type: $solid
echo Dimensions: "$dimens"
echo Material: $materi
echo Magnetic Field: $mfield
echo ncopy: $ncopy
echo pmany: $pmany
echo Existance: $exist 
echo Visibility: $visibl
echo Style: $style
echo Sensitivity: $sensi
echo Hit Type: $hitype
echo Identifiers: "$identi"
echo
echo "Proceed? y/n"
echo 
set confirm = $<

if($confirm == "y") then
  rm -rf tmp5.txt
  echo  "use user_geometry;"                                > tmp5.txt
  echo  'replace into ' $table ' values("'$vname'", "'$mvname'" , "'"$descri"'", "'\
                                     "$vposi"'", "'"$vrota"'", "'$vcolor'", "'$solid'", "'\
                                     "$dimens"'", "'$materi'", "'$mfield'", '\
                                      $ncopy', '\
                                      $pmany', '\
                                      $exist', '\
                                      $visibl', '\
                                      $style', "'$sensi'", "'$hitype'", "'"$identi"'");' >> tmp5.txt;
  set out = `mysql -h $GEMC_HOST -u $GEMC_USER < tmp5.txt` 
  echo Volume $vname replaced.
endif

rm -rf tmp5.txt tmp.txt tmp6.txt




