| 13 |
rsolanki |
1 |
<%
|
|
|
2 |
'=====================================================
|
|
|
3 |
' CONFIG FILE
|
|
|
4 |
'=====================================================
|
|
|
5 |
%>
|
|
|
6 |
<%
|
|
|
7 |
' -- VARIABLE DEFINITION ------------------------------
|
|
|
8 |
Dim OraSession, OraDatabase ' DB connection
|
|
|
9 |
Dim QUERIES_PATH
|
|
|
10 |
Dim SCRIPT_NAME
|
| 15 |
rsolanki |
11 |
Dim TNS_NAME, DB_AUTHENTICATION
|
| 13 |
rsolanki |
12 |
Dim APP_ROOT
|
| 17 |
rsolanki |
13 |
Dim rootPath
|
|
|
14 |
Dim scriptName
|
| 13 |
rsolanki |
15 |
' -----------------------------------------------------
|
|
|
16 |
%>
|
|
|
17 |
<%
|
|
|
18 |
' -- DATABASE CONNECTIONS -----------------------------
|
|
|
19 |
'Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
|
|
20 |
'OraSession.CreateDatabasePool 1,10,100, Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), 0
|
|
|
21 |
'Set OraDatabase = OraSession.GetDatabaseFromPool(10)
|
|
|
22 |
|
|
|
23 |
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
|
|
24 |
Set OraDatabase = OraSession.OpenDatabase( Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), Cint(0))
|
|
|
25 |
|
|
|
26 |
'-- ClearQuest Connection
|
|
|
27 |
Const CQ_CONN = "Provider=sqloledb;Data Source=auperatcm04;Initial Catalog=master;User Id=release_manager;Password=release_manager"
|
|
|
28 |
' -----------------------------------------------------
|
|
|
29 |
%>
|
|
|
30 |
<%
|
|
|
31 |
' -- CONFIGURATIONS -----------------------------------
|
|
|
32 |
Const APPLICATION_ID = 1 ' Stored in Deployment Manager, [APPLICATIONS] table
|
|
|
33 |
APP_ROOT = Server.MapPath(".")
|
| 15 |
rsolanki |
34 |
TNS_NAME = Application("TNS_NAME") '"RELEASEM"
|
|
|
35 |
DB_AUTHENTICATION = Application("DEPLOYMENT_MANAGER_LOGIN") '"release_manager_devl/release_manager_devl" ' DEVL schema
|
| 13 |
rsolanki |
36 |
QUERIES_PATH = APP_ROOT &"\queries"
|
| 17 |
rsolanki |
37 |
scriptName = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
|
|
|
38 |
rootPath = Left( Server.MapPath( scriptName ), InStrRev(Server.MapPath( scriptName ), "\") )
|
| 13 |
rsolanki |
39 |
Const ADMIN_EMAIL = "releasem@erggroup.com"
|
|
|
40 |
Const enumDB_PERMISSION_TYPE_VISIBLE = 1 ' Stored in Access Manager, [Permission_Types] table
|
|
|
41 |
Const enumDB_PERMISSION_TYPE_ACTIVE = 2 ' Stored in Access Manager, [Permission_Types] table
|
|
|
42 |
Const enumRELEASES_DAYS_BACK_IN_TIME = 7 ' Number of days back in time searching for released products
|
|
|
43 |
Const ACCESS_MANAGER_URL = "http://erg:8002/ManagerSuite/Access_Manager"
|
|
|
44 |
Const RELEASE_MANAGER_URL = "http://erg:8002/ManagerSuite/Release_Manager"
|
|
|
45 |
' -----------------------------------------------------
|
|
|
46 |
%>
|
|
|
47 |
<%
|
|
|
48 |
' -- VARIABLE INITIALISATION --------------------------
|
|
|
49 |
SCRIPT_NAME = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
|
|
|
50 |
Const enumDB_DIFF_NO_CHANGE = 0
|
|
|
51 |
Const enumDB_DIFF_UPDATED = 2
|
|
|
52 |
Const enumDB_DIFF_NEW = 1
|
|
|
53 |
Const enumDB_DIFF_REMOVED = -1
|
|
|
54 |
Const enumPRODUCTS_BASE_VIEW_ID = 5 ' Release Manager products base view id
|
| 23 |
rsolanki |
55 |
Const enumAUTOPRODUCTS_BASE_VIEW_ID = 2602 ' Release Manager auto_products base view id
|
| 13 |
rsolanki |
56 |
' -----------------------------------------------------
|
|
|
57 |
%>
|
|
|
58 |
<%
|
|
|
59 |
' -- CONSTANTS ----------------------------------------
|
|
|
60 |
Const enumDB_DEFAULT_EMPTY = -1
|
|
|
61 |
Const enumISSUES_STATE_FIXED = 1
|
|
|
62 |
Const enumCLEARQUEST_TDSE_ID = 3
|
|
|
63 |
Const enumCLEARQUEST_DEVI_ID = 4
|
|
|
64 |
Const enumCLEARQUEST_VT5DM_ID = 5
|
| 23 |
rsolanki |
65 |
Const enumJIRA_ID = 6
|
|
|
66 |
Const enumCLEARQUEST_VTSUP_ID = 7
|
| 13 |
rsolanki |
67 |
Const enumISSUES_STATE_IMPORTED = 0
|
|
|
68 |
Const enumDB_YES = "Y"
|
|
|
69 |
Const enumDB_NO = "N"
|
|
|
70 |
Const enumDEFAULT = "default"
|
|
|
71 |
Const enumCOOKIE_NAME = "DeploymentManager"
|
|
|
72 |
Const enumSEPARATOR_LABEL = "SEPARATOR_LABLE"
|
|
|
73 |
Const enumDB_ALL_DATA = 0
|
|
|
74 |
Const SPACER = "<img src='images/spacer.gif' width='1' height='1'>"
|
|
|
75 |
Const enumMSSQL_ERROR = "<img src='icons/i_no_db_connection.gif' width='16' height='17' hspace='2' border='0' align='absmiddle' title='3rd party database is off-line'><SPAN class='body_txtr'>Information not currently available.</SPAN>"
|
|
|
76 |
Const enumSESSION_COPY_TYPE = "COPY_TYPE"
|
|
|
77 |
Const enumSESSION_COPY_ITEMS = "COPY_ITEMS"
|
|
|
78 |
Const enumSESSION_COPY_FROM = "COPY_FROM"
|
|
|
79 |
Const enumLOADING = "Loading..."
|
|
|
80 |
' -- ACTION TRAIL -------------------------------------
|
|
|
81 |
Const enumAT_EVENT_COMMENT = 0
|
|
|
82 |
Const enumAT_EVENT_ADDED = 1
|
|
|
83 |
Const enumAT_EVENT_MODIFIED = 2
|
|
|
84 |
Const enumAT_EVENT_REMOVED = 3
|
|
|
85 |
Const SMTP_HOST = "aupera03.aupera.erggroup.com"
|
| 21 |
rsolanki |
86 |
Const enum_MSG_PROCESS_EXISTS = "msg_process_exists.asp"
|
| 13 |
rsolanki |
87 |
' -----------------------------------------------------
|
|
|
88 |
%>
|
|
|
89 |
<%
|
|
|
90 |
' -- OO4O ---------------------------------------------
|
|
|
91 |
const ORATYPE_VARCHAR2 = 1
|
|
|
92 |
const ORATYPE_NUMBER = 2
|
|
|
93 |
const ORATYPE_SINT = 3
|
|
|
94 |
const ORATYPE_FLOAT = 4
|
|
|
95 |
const ORATYPE_STRING = 5
|
|
|
96 |
const ORATYPE_VARCHAR = 9
|
|
|
97 |
const ORATYPE_DATE = 12
|
|
|
98 |
const ORATYPE_UINT = 68
|
|
|
99 |
const ORATYPE_RAW = 95
|
|
|
100 |
const ORATYPE_CHAR = 96
|
|
|
101 |
const ORATYPE_CHARZ = 97
|
|
|
102 |
const ORATYPE_MLSLABEL = 105
|
|
|
103 |
const ORATYPE_OBJECT = 108
|
|
|
104 |
const ORATYPE_REF = 110
|
|
|
105 |
const ORATYPE_CLOB = 112
|
|
|
106 |
const ORATYPE_BLOB = 113
|
|
|
107 |
const ORATYPE_BFILE = 114
|
|
|
108 |
const ORATYPE_VARRAY = 247
|
|
|
109 |
const ORATYPE_TABLE = 248
|
|
|
110 |
const ORATYPE_CURSOR = 102
|
|
|
111 |
|
|
|
112 |
|
|
|
113 |
const ORAPARM_INPUT=1
|
|
|
114 |
const ORAPARM_OUTPUT=2
|
|
|
115 |
const ORAPARM_BOTH=3
|
|
|
116 |
|
|
|
117 |
const ORADYN_DEFAULT=&H0&
|
|
|
118 |
' -----------------------------------------------------
|
|
|
119 |
%>
|
|
|
120 |
<%
|
|
|
121 |
' -- ERROR MESSAGES -----------------------------------
|
|
|
122 |
' -----------------------------------------------------
|
|
|
123 |
%>
|
|
|
124 |
<%
|
|
|
125 |
' -- ICONS --------------------------------------------
|
|
|
126 |
' -- ICONS SMALL --------------------------------------
|
|
|
127 |
' -----------------------------------------------------
|
|
|
128 |
' -- Other Configuration -----------------------------
|
|
|
129 |
Const enum_RELMGR_COOKIE_DOMAIN = "RELMGR_USER_COOKIES"
|
|
|
130 |
Const COOKIE_HIDE_FILES_FILTER = "COOKIE_HIDE_FILES_FILTER"
|
|
|
131 |
Const COOKIE_HIDE_DEPS_FILTER = "COOKIE_HIDE_DEPS_FILTER"
|
|
|
132 |
Const COOKIE_HIDE_DIFF_FILTER = "COOKIE_HIDE_DIFF_FILTER"
|
|
|
133 |
Const COOKIE_RELMGR_SHOW_VIEW = "COOKIE_RELMGR_SHOW_VIEW"
|
|
|
134 |
Const COOKIE_RELEASE_MANAGER_MEMORY = "RELEASE_MANAGER_MEMORY"
|
|
|
135 |
Const COOKIE_PATCH_OPTIONS_FILTER = "COOKIE_PATCH_OPTIONS_FILTER"
|
|
|
136 |
%>
|