habitflow-app/script.bat at main · HabitFlowTeam/habitflow-app · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
@echo off

:: Parámetros
set CONTAINER_NAME=%1
if "%CONTAINER_NAME%"=="" set CONTAINER_NAME=habitflow-db

set DB_USER=%2
if "%DB_USER%"=="" set DB_USER=directus

set DB_NAME=%3
if "%DB_NAME%"=="" set DB_NAME=directus

set DDL_FILE=%4
if "%DDL_FILE%"=="" set DDL_FILE=sql\DDL.sql

set USER_HABIT_CALENDAR_VIEW_FILE=%5
if "%USER_HABIT_CALENDAR_VIEW_FILE%"=="" set USER_HABIT_CALENDAR_VIEW_FILE=sql\USER_HABIT_CALENDAR_VIEW.sql

set USER_HABITS_VIEW_FILE=%6
if "%USER_HABITS_VIEW_FILE%"=="" set USER_HABITS_VIEW_FILE=sql\USER_HABITS_VIEW.sql

set HABITS_DAILY_TRIGGER_FILE=%7
if "%HABITS_DAILY_TRIGGER_FILE%"=="" set HABITS_DAILY_TRIGGER_FILE=sql\HABITS_DAILY_TRIGGER.sql

set RANKED_ARTICLES_VIEW_FILE=%8
if "%RANKED_ARTICLES_VIEW_FILE%"=="" set RANKED_ARTICLES_VIEW_FILE=sql\RANKED_ARTICLES_VIEW.sql

set DML_FILE=%9
if "%DML_FILE%"=="" set DML_FILE=sql\DML.sql

:: Archivos adicionales como estaban antes
set USER_ARTICLES_VIEW_FILE=sql\USER_ARTICLES_VIEW.sql
set USER_HABIT_TRACKING_VIEW_FILE=sql\USER_HABIT_TRACKING_VIEW.sql

:: Copiar archivos SQL al contenedor
docker cp "%DDL_FILE%" "%CONTAINER_NAME%:/tmp/DDL.sql"
docker cp "%USER_HABIT_CALENDAR_VIEW_FILE%" "%CONTAINER_NAME%:/tmp/USER_HABIT_CALENDAR_VIEW.sql"
docker cp "%USER_HABITS_VIEW_FILE%" "%CONTAINER_NAME%:/tmp/USER_HABITS_VIEW.sql"
docker cp "%HABITS_DAILY_TRIGGER_FILE%" "%CONTAINER_NAME%:/tmp/HABITS_DAILY_TRIGGER.sql"
docker cp "%RANKED_ARTICLES_VIEW_FILE%" "%CONTAINER_NAME%:/tmp/RANKED_ARTICLES_VIEW.sql"
docker cp "%DML_FILE%" "%CONTAINER_NAME%:/tmp/DML.sql"
docker cp "%USER_ARTICLES_VIEW_FILE%" "%CONTAINER_NAME%:/tmp/USER_ARTICLES_VIEW.sql"
docker cp "%USER_HABIT_TRACKING_VIEW_FILE%" "%CONTAINER_NAME%:/tmp/USER_HABIT_TRACKING_VIEW.sql"

:: Ejecutar los scripts SQL
docker exec -it "%CONTAINER_NAME%" psql -U "%DB_USER%" -d "%DB_NAME%" -f /tmp/DDL.sql
docker exec -it "%CONTAINER_NAME%" psql -U "%DB_USER%" -d "%DB_NAME%" -f /tmp/USER_HABIT_CALENDAR_VIEW.sql
docker exec -it "%CONTAINER_NAME%" psql -U "%DB_USER%" -d "%DB_NAME%" -f /tmp/USER_HABITS_VIEW.sql
docker exec -it "%CONTAINER_NAME%" psql -U "%DB_USER%" -d "%DB_NAME%" -f /tmp/HABITS_DAILY_TRIGGER.sql
docker exec -it "%CONTAINER_NAME%" psql -U "%DB_USER%" -d "%DB_NAME%" -f /tmp/RANKED_ARTICLES_VIEW.sql
docker exec -it "%CONTAINER_NAME%" psql -U "%DB_USER%" -d "%DB_NAME%" -f /tmp/DML.sql
docker exec -it "%CONTAINER_NAME%" psql -U "%DB_USER%" -d "%DB_NAME%" -f /tmp/USER_ARTICLES_VIEW.sql
docker exec -it "%CONTAINER_NAME%" psql -U "%DB_USER%" -d "%DB_NAME%" -f /tmp/USER_HABIT_TRACKING_VIEW.sql