| Line 48... |
Line 48... |
| 48 |
ECHO.
|
48 |
ECHO.
|
| 49 |
|
49 |
|
| 50 |
REM query previous month
|
50 |
REM query previous month
|
| 51 |
REM date_code is accessed in the sql script
|
51 |
REM date_code is accessed in the sql script
|
| 52 |
SET date_code=1
|
52 |
SET date_code=1
|
| 53 |
CALL :query_to_csv %SERVER_TD% "%DIR_INPUT%\SOM_Dashboard_query_TD.sql" "%DIR_OUTPUT%\SOM_Dashboard_%year%%month%_TD.csv" "Test Director" "-E"
|
53 |
CALL :query_to_csv %SERVER_TD% "%DIR_INPUT%\SOM_Dashboard_query_TD.sql" "%DIR_OUTPUT%\SOM_Dashboard_%year%%month%_TD.csv" "Test Director" "-E"
|
| 54 |
CALL :query_to_csv %SERVER_CQ% "%DIR_INPUT%\SOM_Dashboard_query_CQ.sql" "%DIR_OUTPUT%\SOM_Dashboard_%year%%month%_CQ.csv" "Clear Quest" "-E"
|
54 |
CALL :query_to_csv %SERVER_CQ% "%DIR_INPUT%\SOM_Dashboard_query_CQ_JR.sql" "%DIR_OUTPUT%\SOM_Dashboard_%year%%month%_CQ_JR.csv" "Clear Quest/Jira" "-E"
|
| 55 |
CALL :query_to_csv %SERVER_JR% "%DIR_INPUT%\SOM_Dashboard_query_JR.sql" "%DIR_OUTPUT%\SOM_Dashboard_%year%%month%_JR.csv" "Jira" "-E"
|
- |
|
| 56 |
|
55 |
|
| 57 |
IF %DEBUG% == Y (
|
56 |
IF %DEBUG% == Y (
|
| 58 |
REM This block of code is used for debugging purposes.
|
57 |
REM This block of code is used for debugging purposes.
|
| 59 |
REM It is not required in a live system, ie SET DEBUG=N
|
58 |
REM It is not required in a live system, ie SET DEBUG=N
|
| 60 |
|
59 |
|
| 61 |
REM Query data since 2009
|
60 |
REM Query data since 2009
|
| 62 |
SET date_code=2
|
61 |
SET date_code=2
|
| 63 |
CALL :query_to_csv %SERVER_TD% "%DIR_INPUT%\SOM_Dashboard_query_TD.sql" "%DIR_OUTPUT%\SOM_Dashboard_Test_TD_TEST_v%VER_TD%.csv" "Test Director" "-E"
|
62 |
CALL :query_to_csv %SERVER_TD% "%DIR_INPUT%\SOM_Dashboard_query_TD.sql" "%DIR_OUTPUT%\SOM_Dashboard_Test_TD_TEST_v%VER_TD%.csv" "Test Director" "-E"
|
| 64 |
CALL :query_to_csv %SERVER_CQ% "%DIR_INPUT%\SOM_Dashboard_query_CQ.sql" "%DIR_OUTPUT%\SOM_Dashboard_Test_CQ_DEVI_v%VER_CQ%.csv" "Clear Quest" "-E"
|
63 |
CALL :query_to_csv %SERVER_CQ% "%DIR_INPUT%\SOM_Dashboard_query_CQ_JR.sql" "%DIR_OUTPUT%\SOM_Dashboard_Test_CQ_DEVI_v%VER_CQ_JR%.csv" "Clear Quest/Jira" "-E"
|
| 65 |
CALL :query_to_csv %SERVER_JR% "%DIR_INPUT%\SOM_Dashboard_query_JR.sql" "%DIR_OUTPUT%\SOM_Dashboard_Test_JR_DEVI_v%VER_JR%.csv" "Jira" "-E"
|
- |
|
| 66 |
|
64 |
|
| 67 |
REM generate row data for issue investigation purposes
|
65 |
REM generate row data for issue investigation purposes
|
| 68 |
REM query data for a specific debug date range, See Dashboard_query_init.sql
|
66 |
REM query data for a specific debug date range, See Dashboard_query_init.sql
|
| 69 |
SET date_code=3
|
67 |
SET date_code=3
|
| 70 |
CALL :query_to_csv %SERVER_TD% "%DIR_INPUT%\SOM_Dashboard_query_TD_TEST_rows_aug_to_oct.sql" "%DIR_OUTPUT%\SOM_Dashboard_Test_TD_TEST_rows_aug_to_oct_v%VER_TD%.csv" "Test Director" "-E"
|
68 |
CALL :query_to_csv %SERVER_TD% "%DIR_INPUT%\SOM_Dashboard_query_TD_TEST_rows_aug_to_oct.sql" "%DIR_OUTPUT%\SOM_Dashboard_Test_TD_TEST_rows_aug_to_oct_v%VER_TD%.csv" "Test Director" "-E"
|