/DetectorDescription/OnlineDBLoader/scripts/CMS_DTCTR_GEOMETRY_OWNER/loading-scripts/load_all_tables.sh

https://github.com/aivanov-cern/cmssw · Shell · 77 lines · 30 code · 22 blank · 25 comment · 0 complexity · a0b9c151f656154e0ed4c4a5294bf311 MD5 · raw file 

    

  1. #!/bin/sh
    2. 

  2. # This script load all the tables in DGD using sqlldr.
    3. 

  3. # Yuyi Guo May 13, 2005 
    4. 

  4. #
    5. 

  5. 

  6. echo -n 'database TNS name: '
    7. 

  7. read DB_NAME
    8. 

  8. echo -n 'schema writer name: '
    9. 

  9. read USER_NAME
    10. 

  10. echo -n 'schema writer password: '
    11. 

  11. read PASSWD
    12. 

  12. CONN_ID=$USER_NAME@$DB_NAME/$PASSWD
    13. 

  13. #echo "$CONN_ID" 
    14. 

  14. 

  15. echo 'Loading Table SOLIDS' 
    16. 

  16. sqlldr $CONN_ID control=solids.ctl log=solids.log
    17. 

  17. 

  18. #echo 'Loading Table boxes'
    19. 

  19. sqlldr $CONN_ID control=boxes.ctl log=boxes.log
    20. 

  20. 

  21. #echo 'Loading Table trapezoids '
    22. 

  22. sqlldr $CONN_ID control=trapezoids.ctl log=trapezoids.log
    23. 

  23. 

  24. #echo 'Loading Table trapezoids '
    25. 

  25. sqlldr $CONN_ID control=pseudotraps.ctl log=pseduotraps.log
    26. 

  26. 

  27. #echo 'Loading Table cones '
    28. 

  28. sqlldr $CONN_ID control=cones.ctl log=cones.log
    29. 

  29. 

  30. #echo 'Loading Table  polyhedras'
    31. 

  31. sqlldr $CONN_ID control=polyhedras.ctl log=polyhedras.log
    32. 

  32. 

  33. #echo 'Loading Table polycones'
    34. 

  34. sqlldr $CONN_ID control=polycones.ctl log=polycones.log
    35. 

  35. 

  36. #echo 'Loading Table tubesections'
    37. 

  37. sqlldr $CONN_ID control=tubesections.ctl log=tubesections.log
    38. 

  38. 

  39. #echo 'Loading Table trd1s '
    40. 

  40. sqlldr $CONN_ID control=trd1s.ctl log=trd1s.log
    41. 

  41. 

  42. #echo 'Loading Table rotations '
    43. 

  43. sqlldr $CONN_ID control=rotations.ctl log=rotations.log
    44. 

  44. 

  45. #echo 'Loading Table booleansolids '
    46. 

  46. sqlldr $CONN_ID control=booleansolids.ctl log=booleansolids.log
    47. 

  47. 

  48. #echo 'Loading Table zsections'
    49. 

  49. sqlldr $CONN_ID control=zsections.ctl log=zsections.log
    50. 

  50. 

  51. #echo 'Loading Table materials'
    52. 

  52. sqlldr $CONN_ID control=materials.ctl log=materials.log
    53. 

  53. 

  54. #echo 'Loading Table  compositematerials '
    55. 

  55. sqlldr $CONN_ID control=compositematerials.ctl log=compositematerials.log
    56. 

  56. 

  57. #echo 'Loading Table elementarymaterials '
    58. 

  58. sqlldr $CONN_ID control=elementarymaterials.ctl log=elementarymaterials.log
    59. 

  59. 

  60. #echo 'Loading Table materialfractions'
    61. 

  61. sqlldr $CONN_ID control=materialfractions.ctl log=materialfractions.log
    62. 

  62. 

  63. #echo 'Loading Table categories '
    64. 

  64. sqlldr $CONN_ID control=categories.ctl log=categories.log
    65. 

  65. 

  66. #echo 'Loading Table logicalparttypes & detectorparts'
    67. 

  67. sqlldr $CONN_ID control=logicalparts.ctl log=logicalparts.log
    68. 

  68. sqlldr $CONN_ID control=detectorparts.ctl log=detectorparts.log
    69. 

  69. 

  70. #echo 'Loading Table  pospartsgraph & replacements '
    71. 

  71. sqlldr $CONN_ID control=pospartsgraph.ctl log= pospartsgraph.log
    72. 

  72. 

  73. #echo 'Loading Table  physicalpartstree '
    74. 

  74. sqlldr $CONN_ID control=physicalpartstree.ctl log=physicalpartstree.log
    75. 

  75. 

  76. #echo 'Loading Table nominalplacements '
    77. 

  77. sqlldr $CONN_ID control=nominalplacements.ctl log=nominalplacements.log
    78.