Subversion Repositories DevTools

Rev

Rev 5370 | Rev 5962 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 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
11
Dim TNS_NAME, DB_AUTHENTICATION
12
Dim APP_ROOT
13
Dim rootPath
14
Dim scriptName
4808 dpurdie 15
Dim SMTP_HOST
5356 dpurdie 16
Dim ACCESS_MANAGER_URL
17
Dim strRelativePath             ' Rel Path from script to URL
18
Dim managerSuiteBase            ' Url to the base of the Manager Suite
19
Dim FavIcon                     ' Favorite Icon
20
Dim RmDebug                     ' Debug Display
21
 
64 jtweddle 22
' -----------------------------------------------------
23
%>
24
<%
25
' -- DATABASE CONNECTIONS -----------------------------
26
'Set OraSession = CreateObject("OracleInProcServer.XOraSession")
66 ghuddy 27
'OraSession.CreateDatabasePool 1,10,100, Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), 0
64 jtweddle 28
'Set OraDatabase = OraSession.GetDatabaseFromPool(10)
29
 
30
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
31
Set OraDatabase = OraSession.OpenDatabase( Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), Cint(0))
32
' -----------------------------------------------------
33
%>
34
<%
5356 dpurdie 35
' -- Basic Functions ----------------------------------
36
' --------------------------------------------------------------------------------------
37
' Determine if a variable or Const exists and is not empty
38
'   Use to check if a vbscript variable has been declared and contains a non-empty value
39
Function isDefined( var)
40
    If (not IsEmpty(Eval(var))) AND Eval(var & " <> """"") Then
41
        isDefined = TRUE
42
    Else
43
        isDefined = FALSE
44
   End If
45
End Function
46
 
4808 dpurdie 47
'--------------------------------------------------------------------------------------
48
'Returns the server of the package archive
49
Function Get_Mail_Server()
50
   Dim sqry: sqry = "SELECT * FROM RELEASE_MANAGER.BUILD_SERVICE_CONFIG WHERE SERVICE='MAIL SERVER'"
51
   Dim rsTemp
52
   Set rsTemp = OraDatabase.DbCreateDynaset( sqry , cint(0) )
53
   Get_Mail_Server = rsTemp("config")
54
   rsTemp.Close()
55
   Set rsTemp = Nothing
56
End Function
57
 
5356 dpurdie 58
'--------------------------------------------------------------------------------------
59
'Return a relative path to the server base. Used for relative pathing to 'images'
60
'Assumes server base is two directores below the web serve root (ManageSuite/Release_Manager)
61
Function GetPathToBase()
62
    Dim url,depth,rv,ii
63
    url = request.servervariables("URL")
64
    depth =  len(url) - len(replace(url, "/", ""))
65
    rv = ""
66
    For ii = 4 To depth
67
        rv = rv & "../"
68
    Next
69
    GetPathToBase = rv
70
End Function
71
 
72
' Return a URL to the base of the Manager suite
73
' Assumes this is one directory down from the web server root
74
Function GetManagerSuiteBase
75
    Dim data
76
    data = Split(request.servervariables("URL"),"/")
77
    GetManagerSuiteBase =  "/" & data(1)
78
End Function
79
 
64 jtweddle 80
' -- CONFIGURATIONS -----------------------------------
81
Const DOC_FOLDER = "doc"
82
Const TEMP_FOLDER = "temp"
83
Const APPLICATION_ID = 10  			' Stored in Deployment Manager, [APPLICATIONS] table
84
APP_ROOT = Server.MapPath(".")
66 ghuddy 85
TNS_NAME = Application("TNS_NAME") '"RELEASEM"
64 jtweddle 86
DB_AUTHENTICATION = Application("DEPLOYMENT_MANAGER_LOGIN") '"release_manager_devl/release_manager_devl"								' DEVL schema
87
QUERIES_PATH = APP_ROOT &"\queries"
88
scriptName = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
89
rootPath = Left( Server.MapPath( scriptName ), InStrRev(Server.MapPath( scriptName ), "\") )
4808 dpurdie 90
SMTP_HOST = Get_Mail_Server()
4014 dpurdie 91
Const ADMIN_EMAIL = "VixIT@vixtechnology.com"
64 jtweddle 92
Const enumDB_PERMISSION_TYPE_VISIBLE = 1		' Stored in Access Manager, [Permission_Types] table
93
Const enumDB_PERMISSION_TYPE_ACTIVE = 2			' Stored in Access Manager, [Permission_Types] table
94
Const enumRELEASES_DAYS_BACK_IN_TIME = 7		' Number of days back in time searching for released products
5356 dpurdie 95
 
96
strRelativePath = GetPathToBase()
97
managerSuiteBase = GetManagerSuiteBase()
98
ACCESS_MANAGER_URL      = ManagerSuiteBase & "/Access_Manager"
5370 dpurdie 99
FavIcon = strRelativePath & "favicons/PM" & Application("FavIconSuffix") & ".png"
5356 dpurdie 100
 
64 jtweddle 101
' -----------------------------------------------------
102
%>
103
<%
104
' -- VARIABLE INITIALISATION --------------------------
105
SCRIPT_NAME = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
106
Const enumDB_DIFF_NO_CHANGE = 0
107
Const enumDB_DIFF_UPDATED = 2
108
Const enumDB_DIFF_NEW = 1
109
Const enumDB_DIFF_REMOVED = -1
110
Const enumPRODUCTS_BASE_VIEW_ID = 5					' Release Manager products base view id
111
Const enumAUTOPRODUCTS_BASE_VIEW_ID = 2602					' Release Manager auto_products base view id
112
' -----------------------------------------------------
113
%>
114
<%
66 ghuddy 115
' -- CONSTANTS --------------------------------------
64 jtweddle 116
Const enumDB_DEFAULT_EMPTY = -1
117
Const enumISSUES_STATE_FIXED = 1
118
Const enumCLEARQUEST_TDSE_ID = 3
119
Const enumCLEARQUEST_DEVI_ID = 4
120
Const enumCLEARQUEST_VT5DM_ID = 5
121
Const enumCLEARQUEST_VTSUP_ID = 7
122
Const enumISSUES_STATE_IMPORTED = 0
123
Const enumDB_YES = "Y"
124
Const enumDB_NO = "N"
125
Const enumDEFAULT = "default"
126
Const enumCOOKIE_NAME = "DeploymentManager"
127
Const enumSEPARATOR_LABEL = "SEPARATOR_LABLE"
128
Const enumDB_ALL_DATA = 0
129
Const SPACER = "<img src='images/spacer.gif' width='1' height='1'>"
130
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>"
131
Const enumSESSION_COPY_TYPE = "COPY_TYPE"
132
Const enumSESSION_COPY_ITEMS = "COPY_ITEMS"
133
Const enumSESSION_COPY_FROM = "COPY_FROM"
134
Const enumLOADING = "Loading..."
135
'----- TESTS ------------------------------------------
136
Const enumTEST_TYPE_SANITY = 2
137
Const enumTEST_TYPE_NOT_DONE = 1
138
' -- ACTION TRAIL -------------------------------------
139
Const enumAT_EVENT_COMMENT 	= 0
140
Const enumAT_EVENT_ADDED 	= 1
141
Const enumAT_EVENT_MODIFIED = 2
142
Const enumAT_EVENT_REMOVED 	= 3
143
Const enum_MSG_PROCESS_EXISTS = "msg_process_exists.asp"
144
' -----------------------------------------------------
145
%>
146
<%
147
' -- OO4O ---------------------------------------------
148
const ORATYPE_VARCHAR2 = 1
149
const ORATYPE_NUMBER = 2
150
const ORATYPE_SINT = 3
151
const ORATYPE_FLOAT = 4
152
const ORATYPE_STRING = 5
153
const ORATYPE_VARCHAR = 9
154
const ORATYPE_DATE = 12
155
const ORATYPE_UINT = 68
156
const ORATYPE_RAW = 95
157
const ORATYPE_CHAR = 96
158
const ORATYPE_CHARZ = 97
159
const ORATYPE_MLSLABEL = 105
160
const ORATYPE_OBJECT = 108
161
const ORATYPE_REF = 110
162
const ORATYPE_CLOB = 112
163
const ORATYPE_BLOB = 113
164
const ORATYPE_BFILE = 114
165
const ORATYPE_VARRAY = 247
166
const ORATYPE_TABLE = 248
167
const ORATYPE_CURSOR = 102
168
 
169
 
66 ghuddy 170
const ORAPARM_INPUT=1
171
const ORAPARM_OUTPUT=2
64 jtweddle 172
const ORAPARM_BOTH=3
173
 
174
const ORADYN_DEFAULT=&H0&
175
' -----------------------------------------------------
176
%>
177
<%
178
' -- ERROR MESSAGES -----------------------------------
179
' -----------------------------------------------------
180
%>
181
<%
182
' -- ICONS --------------------------------------------
183
' -- ICONS SMALL --------------------------------------
184
' -----------------------------------------------------
185
' -- Other Configuration -----------------------------
186
Const enum_RELMGR_COOKIE_DOMAIN = "RELMGR_USER_COOKIES"
187
Const COOKIE_HIDE_FILES_FILTER = "COOKIE_HIDE_FILES_FILTER"
188
Const COOKIE_HIDE_DEPS_FILTER = "COOKIE_HIDE_DEPS_FILTER"
189
Const COOKIE_HIDE_DIFF_FILTER = "COOKIE_HIDE_DIFF_FILTER"
190
Const COOKIE_RELMGR_SHOW_VIEW = "COOKIE_RELMGR_SHOW_VIEW"
191
Const COOKIE_RELEASE_MANAGER_MEMORY = "RELEASE_MANAGER_MEMORY"
192
Const COOKIE_PATCH_OPTIONS_FILTER = "COOKIE_PATCH_OPTIONS_FILTER"
193
%>