@ECHO OFF

ECHO Instalacao de Base de Dados

CHCP 1252

REM Escolher o ambiente onde vai ser feito o deployment

echo Ambientes disponiveis:
echo  dev   (CoE_dev)
echo  local (local)
echo.


IF NOT DEFINED _AmbienteDeployment IF [%1]==[] (
	SET /P _AmbienteDeployment="Ambiente onde fazer deploy?(Default=local)"
) ELSE (
	SET _AmbienteDeployment=%1
)
IF [%_AmbienteDeployment%]==[] (
	SET "_AmbienteDeployment=local"
)

CALL "IAF_SQL\configuracoes\%_AmbienteDeployment%.bat"


SETLOCAL

:_PASSWORD
SET _PASSWORDInput=0

IF NOT DEFINED _PASSWORD (
    SET _PASSWORDInput=1
	SET /P _PASSWORD="Qual a password para a instancia SQL SERVER? "
)

IF [%_PASSWORD%]==[] (
	ECHO AVISO: Detectada password vazia, insira novamente
	GOTO :_PASSWORD
)

IF [%_PASSWORDInput%]==[1] (
    SET /P _PASSWORDConfirmacao="Confirme novamente a password: "
)

IF [%_PASSWORDInput%]==[1] IF NOT "%_PASSWORD%"=="%_PASSWORDConfirmacao%" (
    ECHO ERRO: As passwords nao condizem, repita novamente
    SET _PASSWORDInput=0
    SET "_PASSWORD="
    GOTO :_PASSWORD
)

REM apenas é definido se for evocado pelo mainGlobal e serve para evitar os drops constraints locais
IF NOT DEFINED DROP_CSTRT (
	SET DROP_CSTRT=Y
)

SET _CURRENT_DIR=%~dp0
SET _CURRENT_DIR=%_CURRENT_DIR:~0,-1%

ECHO INICIO MAIN %date% - %time% %_CURRENT_DIR%> "%_CURRENT_DIR%\output.log"
ECHO A INSTANCIA DE SQL SERVER E A DATABASE ONDE VAO CORRER OS SCRIPTS: %_SqlInst% - %_DB% >> "%_CURRENT_DIR%\output.log"

ECHO INICIO MAIN %date% - %time% %_CURRENT_DIR%
ECHO A INSTANCIA DE SQL SERVER E A DATABASE ONDE VAO CORRER OS SCRIPTS: %_SqlInst% - %_DB%

IF %AUTO% EQU 2 goto MANUAL
IF %AUTO% EQU 1 goto AUTOMATICO

:AUTOMATICO
ECHO MAIN SCRIPT AUTOMATICO >> "%_CURRENT_DIR%\output.log"
REM correr o main daa scripts ddl
IF EXIST "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\Main.bat" CALL "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\Main.bat"
REM IF EXIST "%_CURRENT_DIR%\IAF_NL_LOCAL\01script-sql\Main.bat" CALL "%_CURRENT_DIR%\IAF_NL_LOCAL\01script-sql\Main.bat" REM ADDED
IF EXIST "%_CURRENT_DIR%\IAF_SG_LOCAL\01script-sql\Main.bat" CALL "%_CURRENT_DIR%\IAF_SG_LOCAL\01script-sql\Main.bat"

REM correr todos os batch main que executam os inserts
CALL "%_CURRENT_DIR%\IAF_SQL\database\03scripts-dml\Main.bat"
TYPE "%_CURRENT_DIR%\IAF_SQL\database\03scripts-dml\output.log" >> "%_CURRENT_DIR%\output.log"
TYPE "%_CURRENT_DIR%\IAF_SQL\database\03scripts-dml\output.log" >> "%_CURRENT_DIR%\output.log"

REM correr todos os batch main que executam os inserts
CALL "%_CURRENT_DIR%\IAF_SQL\database\03scripts-dml\Main.bat"
TYPE "%_CURRENT_DIR%\IAF_SQL\database\03scripts-dml\output.log" >> "%_CURRENT_DIR%\output.log"

REM correr todos os batch main que inserem as assemblies
CALL "%_CURRENT_DIR%\IAF_SQL\database\04assemblies\Main.bat"
TYPE "%_CURRENT_DIR%\IAF_SQL\database\04assemblies\output.log" >> "%_CURRENT_DIR%\output.log"

REM correr todos os batch main que criam os jobs
CALL "%_CURRENT_DIR%\IAF_SQL\database\05jobs\Main.bat"
TYPE "%_CURRENT_DIR%\IAF_SQL\database\05jobs\output.log" >> "%_CURRENT_DIR%\output.log"

REM correr todos os batch main que criam as new features
CALL "%_CURRENT_DIR%\IAF_SQL\database\06new-features\Main.bat"
TYPE "%_CURRENT_DIR%\IAF_SQL\database\06new-features\output.log" >> "%_CURRENT_DIR%\output.log"



REM correr todos os batch main que criam os triggers
CALL "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\Triggers\MainTriggers.bat"
TYPE "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\Triggers\output.log" >> "%_CURRENT_DIR%\output.log"

sqlcmd -S %_SqlInst% -d %_DB% -U %_LOGINID% -P %_PASSWORD% -i "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\EnableFK.sql" >> "%_CURRENT_DIR%\output.log"
ECHO CORREU SCRIPT "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\EnableFK.sql" >> "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\output.log"

sqlcmd -S %_SqlInst% -d %_DB% -U %_LOGINID% -P %_PASSWORD% -i "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\EnableTriggers.sql" >> "%_CURRENT_DIR%\output.log"
ECHO CORREU SCRIPT "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\EnableTriggers.sql" >> "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\output.log"

REM CALL "%_CURRENT_DIR%\Paths.bat" >> "%_CURRENT_DIR%\output.log"
REM ECHO CORREU SCRIPT "%_CURRENT_DIR%\Paths.bat" >> "%_CURRENT_DIR%\output.log"

REM Criar a estrutura de directórios definida para os tipos de ficheiros
IF EXIST "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectorios.bat" DEL "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectorios.bat"
IF EXIST "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectoriosTemp.bat" DEL "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectoriosTemp.bat"
sqlcmd -S %_SqlInst% -d %_DB% -U %_LOGINID% -P %_PASSWORD% -i "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectorios.sql" -o "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectorios.bat"
ECHO CORREU SCRIPT "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectorios.sql" >> "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\output.log"
MORE +2 "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectorios.bat" > "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectoriosTemp.bat"
CALL "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectoriosTemp.bat" >> "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\output.log"
ECHO CORREU SCRIPT "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectoriosTemp.bat" >> "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\output.log"
REM IF EXIST "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectorios.bat" DEL "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectorios.bat"
REM IF EXIST "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectoriosTemp.bat" DEL "%_CURRENT_DIR%\IAF_SQL\database\01scripts-ddl\CriarDirectoriosTemp.bat"

IF EXIST "%_CURRENT_DIR%\IAF_SG_LOCAL\01script-sql\Main.bat" CALL "%_CURRENT_DIR%\IAF_SG_LOCAL\01script-sql\Main.bat"


goto LOG

:LOG
REM concatenar todos os outputs dos mains interiores
FOR /D %%G in ("%_CURRENT_DIR%\*") DO IF EXIST "%%G\output.log" TYPE "%%G\output.log" >> "%_CURRENT_DIR%\output.log"

ECHO FINAL MAIN %date% - %time% %_CURRENT_DIR% >> "%_CURRENT_DIR%\output.log"
ECHO FINAL MAIN %date% - %time% %_CURRENT_DIR%
ENDLOCAL