Red Hat

'This script will:
' - ZIP some source file or dir to %BAK_DEPOT%\BAK_YYYYMMDD.zip

' Loader parameters

Const CCBS_LOG_DIR = "/cloudoracle/app/loadlog/logs/"

Const LOADER_USER=" smart_new_admin/smo20100726@neo60"

Const LOADED_LOGSM_FOLDER = "/cloudoracle/app/loadlog/logs/loaded/"
Const SKIPED_LOGSM_FOLDER = "/cloudoracle/app/loadlog/logs/skiped/"

Const LOADER_CMD_FILE = "./_load_data.sh"
Const ANALYZE_CMD_FILE = "./_analyze_data.sh"
Const ANALYZE_SQL_FILE = "./_analyze_data.sql"

Const PER_CONTROL_FILE = "./_load_perdata.ctl"
Const SEL_CONTROL_FILE = "./_load_seldata.ctl"
Const UPD_CONTROL_FILE = "./_load_upddata.ctl"
Const ERR_CONTROL_FILE = "./_load_errdata.ctl"
Const INV_CONTROL_FILE = "./_load_invdata.ctl"


''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 
' MAIN-ENTRY
'
'prepareTask
mainTask
'postTask

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 
'
'
'--------------------------------------------
' FUNCTIONS
'--------------------------------------------

Function mainTask()
	
Dim oFSO, oLogFolder, oFile
On Error Resume Next

Set oFSO = WScript.CreateObject("Scripting.FileSystemObject")
Set oLogFolder = oFSO.GetFolder(CCBS_LOG_DIR)

Dim fYYYYMMDD_
Dim perf_filelist_, sel_filelist_, upd_filelist_
perf_filelist_=""
sel_filelist_=""
upd_filelist_=""

'MsgBox "hello"

Dim maxLoadDate_
maxLoadDate_ = getYYYYMMDD(-1)

For Each oFile in oLogFolder.Files
  
  fYYYYMMDD_ = Left(oFile.Name, 8)

  if (fYYYYMMDD_ <= maxLoadDate_) then
	if (instr(oFile.Name, "per") > 0) then	
		loadData PER_CONTROL_FILE, CCBS_LOG_DIR & oFile.Name
		oFile.Move LOADED_LOGSM_FOLDER		
	elseif (instr(oFile.Name, "sel") > 0) then
		loadData SEL_CONTROL_FILE, CCBS_LOG_DIR & oFile.Name
		oFile.Move LOADED_LOGSM_FOLDER		
	elseif (instr(oFile.Name, "upd") > 0) then
		loadData UPD_CONTROL_FILE, CCBS_LOG_DIR & oFile.Name
		oFile.Move LOADED_LOGSM_FOLDER		
	elseif (instr(oFile.Name, "err") > 0) then
		loadData ERR_CONTROL_FILE, CCBS_LOG_DIR & oFile.Name
		oFile.Move LOADED_LOGSM_FOLDER		
	elseif (instr(oFile.Name, "inv") > 0) then
		loadData INV_CONTROL_FILE, CCBS_LOG_DIR & oFile.Name
		oFile.Move LOADED_LOGSM_FOLDER		
	else
		oFile.Move SKIPED_LOGSM_FOLDER		
	end if
  end if
  
Next

  analyzeData()

End Function

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Function loadData(control_file, data_file_list)

dim objShell
dim strCommand

set objShell = WScript.CreateObject("Wscript.Shell")

strCommand = LOADER_CMD_FILE & LOADER_USER & " " & control_file & " " & data_file_list
'MsgBox "strCommand: " & strCommand
objShell.run strCommand ,1 ,true

set objShell = nothing

End Function

Function analyzeData()

dim objShell
dim strCommand

set objShell = WScript.CreateObject("Wscript.Shell")

strCommand = ANALYZE_CMD_FILE & LOADER_USER & " @" &ANALYZE_SQL_FILE
'MsgBox "strCommand: " & strCommand
objShell.run strCommand ,1 ,true

set objShell = nothing

End Function


Function getYYYYMMDD(offset)
Dim currDate
currDate = Date() + offset

dim mm_
mm_ = DatePart("m", currDate)
if  mm_ <= 9 then
	mm_ = "0" & mm_
end if

dim dd_
dd_ = DatePart("d", currDate)
if  dd_ <= 9 then
	dd_ = "0" & dd_
end if

Dim sDate
sDate = DatePart("yyyy", currDate) &  mm_ & dd_

getYYYYMMDD = sDate
'getYYYYMMDD = "20101011"

End Function