PDJJ14 WIKI : Directory 삭제/생성 및 SQL 실행

Created by 한재중, last modified on 4월 29, 2022

변수 생성 및 사용

  • 생성
    • SET <변수이름>=<값>
      • SET STORAGE_IP=192.168.30.86
  • 사용
    • %<변수>%
      • %STORAGE_IP%


디렉토리 삭제 및 생성

  • 삭제
    • rmdir /S /Q <디렉토리 경로>
      • rmdir /S /Q \\%STORAGE_IP%\kst22g\SIIS
      • /S 지정된 디렉터리 자체와, 그 안의 모든 디렉터리 및 파일을 지웁니다.
        디렉터리 트리를 지우는데 사용합니다.
      • /Q 조용한 모드로, /S로 디렉터리 트리를 지우는데 문제가 없으면 다시
        묻지 않습니다.
  • 생성
    • mkdir <디렉토리 경로>
      • mkdir \\%STORAGE_IP%\kst22g\SIIS


SQL 실행

  • sqlcmd -S "<DB 주소>" -U "<ID>" -P "<Password>" -d "<DB 이름>" -i "<실행할 SQL 파일 경로>"
    • sqlcmd -S "%DB_IP%" -U "sa" -P "1234%%^qwerTY" -d "KIPMS" -i "KIPMS_DB_Init.sql"


Robocopy 를 이용한 폴더 복사

  • robocopy /E <원본 폴더 경로> <복사할 폴더 경로> /XD <복사 제외할 폴더 이름 (공백으로 여러개 입력 가능)> /XF <복사 제외할 파일 이름 (공백으로 여러개 입력 가능)
    • robocopy /E \\%SERVER_IP%\d\KST22G\Converter\TestData\CADU_K3_MT_KST_20220302_01_01 \\%SERVER_IP%\d\KST22G\Converter\Input\CADU_K3_MT_KST_20220302_01_01 /XD Temp Release MT_* /XF *.doc sample.dat


샘플

SET STORAGE_IP=192.168.30.86
SET SERVER_IP=192.168.30.130
SET DB_IP=192.168.30.234
SET LP_IP=192.168.30.231

echo Start to init KSAT Folders
rmdir /S /Q \\%STORAGE_IP%\kst22g\KSAT\Product
mkdir \\%STORAGE_IP%\kst22g\KSAT\Product
echo End to init KSAT Folders

echo Start to init SIIS Folders
rmdir /S /Q \\%STORAGE_IP%\kst22g\SIIS
mkdir \\%STORAGE_IP%\kst22g\SIIS
mkdir \\%STORAGE_IP%\kst22g\SIIS\DEM
mkdir \\%STORAGE_IP%\kst22g\SIIS\JPLEphemerides
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3\Level0F
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3\MT
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3\PAD
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3\POD
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3A
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3A\Level0F
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3A\MT
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3A\PAD
mkdir \\%STORAGE_IP%\kst22g\SIIS\K3A\POD
mkdir \\%STORAGE_IP%\kst22g\SIIS\NUC
mkdir \\%STORAGE_IP%\kst22g\SIIS\Timetab
echo End to init SIIS Folders

echo Start to init PMS Data Folders
rmdir /S /Q \\%STORAGE_IP%\kst22g\PMS\Product
mkdir \\%STORAGE_IP%\kst22g\PMS\Product
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Browse
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Browse16Bit
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\DiskProduct
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\FPGR
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Level0F
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Level1G
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Level1O
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Level1R
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\ProductFinal
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Report
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Temp
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\TempProductFinal
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Thumbnail
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3\Workorder
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Browse
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Browse16Bit
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\DiskProduct
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\FPGR
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Level0F
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Level1G
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Level1O
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Level1R
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\ProductFinal
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Report
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Temp
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\TempProductFinal
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Thumbnail
mkdir \\%STORAGE_IP%\kst22g\PMS\Product\K3A\Workorder
echo End to init PMS Data Folders

echo Start to init Server Converter Result Folders
rmdir /S /Q \\%DB_IP%\d\KST22G\Converter\Error
mkdir \\%DB_IP%\d\KST22G\Converter\Error
rmdir /S /Q \\%DB_IP%\d\KST22G\Converter\Input
mkdir \\%DB_IP%\d\KST22G\Converter\Input
rmdir /S /Q \\%DB_IP%\d\KST22G\Converter\Log
mkdir \\%DB_IP%\d\KST22G\Converter\Log
rmdir /S /Q \\%DB_IP%\d\KST22G\Converter\MT
mkdir \\%DB_IP%\d\KST22G\Converter\MT
rmdir /S /Q \\%DB_IP%\d\KST22G\Converter\Output
mkdir \\%DB_IP%\d\KST22G\Converter\Output
echo End to init Server Converter Result Folders

echo Start to init Server PMS Result Folders
rmdir /S /Q \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene\K3
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene\K3\CalculateNmr_Result
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene\K3\Log
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene\K3\Temp
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene\K3A
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene\K3A\CalculateNmr_Result
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene\K3A\Log
mkdir \\%SERVER_IP%\d\KST22G\PMS\CalcNmrScene\K3A\Temp
rmdir /S /Q \\%SERVER_IP%\d\KST22G\PMS\ClientLog
mkdir \\%SERVER_IP%\d\KST22G\PMS\ClientLog
rmdir /S /Q \\%SERVER_IP%\d\KST22G\PMS\LevelProcessor
mkdir \\%SERVER_IP%\d\KST22G\PMS\LevelProcessor
mkdir \\%SERVER_IP%\d\KST22G\PMS\LevelProcessor\Log
mkdir \\%SERVER_IP%\d\KST22G\PMS\LevelProcessor\Log\K3
mkdir \\%SERVER_IP%\d\KST22G\PMS\LevelProcessor\Log\K3A
mkdir \\%SERVER_IP%\d\KST22G\PMS\LevelProcessor\Temp
mkdir \\%SERVER_IP%\d\KST22G\PMS\LevelProcessor\Temp\K3
mkdir \\%SERVER_IP%\d\KST22G\PMS\LevelProcessor\Temp\K3A
rmdir /S /Q \\%SERVER_IP%\d\KST22G\PMS\ServerLog
mkdir \\%SERVER_IP%\d\KST22G\PMS\ServerLog
rmdir /S /Q \\%SERVER_IP%\d\KST22G\PMS\SIPController
mkdir \\%SERVER_IP%\d\KST22G\PMS\SIPController
mkdir \\%SERVER_IP%\d\KST22G\PMS\SIPController\Input
mkdir \\%SERVER_IP%\d\KST22G\PMS\SIPController\Log
rmdir /S /Q \\%SERVER_IP%\d\KST22G\PMS\L0FfromCADUConverter
mkdir \\%SERVER_IP%\d\KST22G\PMS\L0FfromCADUConverter
echo End to init Server PMS Result Folders

echo Start to init DB PMS Result Folders
rmdir /S /Q \\%DB_IP%\d\KST22G\PMS\LevelProcessor
mkdir \\%DB_IP%\d\KST22G\PMS\LevelProcessor
mkdir \\%DB_IP%\d\KST22G\PMS\LevelProcessor\Log
mkdir \\%DB_IP%\d\KST22G\PMS\LevelProcessor\Log\K3
mkdir \\%DB_IP%\d\KST22G\PMS\LevelProcessor\Log\K3A
mkdir \\%DB_IP%\d\KST22G\PMS\LevelProcessor\Temp
mkdir \\%DB_IP%\d\KST22G\PMS\LevelProcessor\Temp\K3
mkdir \\%DB_IP%\d\KST22G\PMS\LevelProcessor\Temp\K3A
rmdir /S /Q \\%DB_IP%\d\KST22G\PMS\SIPController
mkdir \\%DB_IP%\d\KST22G\PMS\SIPController
mkdir \\%DB_IP%\d\KST22G\PMS\SIPController\Input
mkdir \\%DB_IP%\d\KST22G\PMS\SIPController\Log
echo End to init DB PMS Result Folders

echo Start to init LP PMS Result Folders
rmdir /S /Q \\%LP_IP%\d\KST22G\PMS\LevelProcessor
mkdir \\%LP_IP%\d\KST22G\PMS\LevelProcessor
mkdir \\%LP_IP%\d\KST22G\PMS\LevelProcessor\Log
mkdir \\%LP_IP%\d\KST22G\PMS\LevelProcessor\Log\K3
mkdir \\%LP_IP%\d\KST22G\PMS\LevelProcessor\Log\K3A
mkdir \\%LP_IP%\d\KST22G\PMS\LevelProcessor\Temp
mkdir \\%LP_IP%\d\KST22G\PMS\LevelProcessor\Temp\K3
mkdir \\%LP_IP%\d\KST22G\PMS\LevelProcessor\Temp\K3A
rmdir /S /Q \\%LP_IP%\d\KST22G\PMS\SIPController
mkdir \\%LP_IP%\d\KST22G\PMS\SIPController
mkdir \\%LP_IP%\d\KST22G\PMS\SIPController\Input
mkdir \\%LP_IP%\d\KST22G\PMS\SIPController\Log
echo End to init LP PMS Result Folders

echo Start to init KIPMS Database
sqlcmd -S "%DB_IP%" -U "sa" -P "1234%%^qwerTY" -d "KIPMS" -i "KIPMS_DB_Init.sql"
echo End to init KIPMS Database

echo Start to copy CADU files to input folder of converter
robocopy /E \\%SERVER_IP%\d\KST22G\Converter\TestData\CADU_K3_MT_KST_20220302_01_01 \\%SERVER_IP%\d\KST22G\Converter\Input\CADU_K3_MT_KST_20220302_01_01
robocopy /E \\%SERVER_IP%\d\KST22G\Converter\TestData\CADU_K3A_MT_KST_20220301_01_01 \\%SERVER_IP%\d\KST22G\Converter\Input\CADU_K3A_MT_KST_20220301_01_01
robocopy /E \\%SERVER_IP%\d\KST22G\Converter\TestData\MT \\%SERVER_IP%\d\KST22G\Converter\MT
echo End to copy CADU files to input folder of converter