| 6166 |
dpurdie |
1 |
<%
|
|
|
2 |
'=====================================================
|
|
|
3 |
' common_daemon.asp
|
|
|
4 |
' Subroutines and functions commonthe the build daemon displays
|
|
|
5 |
'=====================================================
|
|
|
6 |
'
|
|
|
7 |
%>
|
|
|
8 |
<%
|
|
|
9 |
'------------ Constants Declaration -----------
|
|
|
10 |
Const Max_Delta = 600 ' Seconds
|
|
|
11 |
|
|
|
12 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
13 |
Function PrettyDelta( delta, daemonState,pkgId )
|
|
|
14 |
Dim style
|
|
|
15 |
style = ""
|
| 6176 |
dpurdie |
16 |
If delta <> "" AND IsNumeric(delta) Then
|
|
|
17 |
delta = CLng(delta)
|
|
|
18 |
Else
|
|
|
19 |
PrettyDelta = "-"
|
|
|
20 |
Exit Function
|
|
|
21 |
End If
|
| 6166 |
dpurdie |
22 |
|
|
|
23 |
If (delta > Max_Delta) AND (IsNull(pkgId) OR pkgId = "") Then
|
|
|
24 |
style = "style=color:Red"
|
|
|
25 |
If (delta > 86400 ) Then
|
|
|
26 |
Dim bdate, dd,mm,yy
|
|
|
27 |
bdate = DateAdd("s", - delta,Now())
|
|
|
28 |
dd = Day(bdate)
|
|
|
29 |
mm = MonthName(Month(bdate),1)
|
|
|
30 |
yy = Year( bdate)
|
|
|
31 |
delta = dd & "-" & mm & "-" & yy
|
|
|
32 |
If ( daemonState >= 2 ) Then
|
|
|
33 |
style = ""
|
|
|
34 |
End If
|
|
|
35 |
ElseIf ( delta > 60*60 ) Then
|
|
|
36 |
'Dim bdate, hh, mins, ss
|
|
|
37 |
bdate = DateAdd("s", - delta,Now())
|
|
|
38 |
delta = TimeValue( bdate)
|
|
|
39 |
'delta = hh & ":" & mins & ":" & ss
|
|
|
40 |
End If
|
|
|
41 |
End If
|
|
|
42 |
|
|
|
43 |
If style <> "" Then
|
|
|
44 |
delta = "<span " & style & ">" & delta & "</span>"
|
|
|
45 |
End If
|
|
|
46 |
PrettyDelta = delta
|
|
|
47 |
End Function
|
|
|
48 |
|
|
|
49 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
50 |
' Convert daemon mode into a meaningful string
|
|
|
51 |
Function Get_Daemon_Mode( nMode )
|
|
|
52 |
If nMode = "M" Then
|
|
|
53 |
Get_Daemon_Mode = "Master"
|
|
|
54 |
ElseIf nMode = "S" Then
|
|
|
55 |
Get_Daemon_Mode = "Slave"
|
|
|
56 |
Else
|
|
|
57 |
Get_Daemon_Mode = "?"
|
|
|
58 |
End If
|
|
|
59 |
End Function
|
|
|
60 |
|
|
|
61 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
62 |
Function Get_Run_Level( nLevel, indefinitePause, astate)
|
|
|
63 |
|
|
|
64 |
If indefinitePause Then
|
|
|
65 |
Get_Run_Level = "<span class='err_alert'>Stopped</span>"
|
|
|
66 |
ElseIf astate = 1 Then ' if build daemon paused
|
|
|
67 |
Get_Run_Level = "Paused"
|
|
|
68 |
ElseIf astate = 2 Then ' if build daemon disabled
|
|
|
69 |
Get_Run_Level = "Disabled"
|
|
|
70 |
ElseIf astate = 0 Then ' if build daemon enabled
|
|
|
71 |
If nLevel = 1 Then
|
|
|
72 |
Get_Run_Level = "Cannot Continue"
|
|
|
73 |
ElseIf nLevel = 2 Then
|
|
|
74 |
Get_Run_Level = "Paused"
|
|
|
75 |
ElseIf nLevel = 3 Then
|
|
|
76 |
Get_Run_Level = "Building"
|
|
|
77 |
ElseIf nLevel = 4 Then
|
|
|
78 |
Get_Run_Level = "Idle"
|
|
|
79 |
ElseIf nLevel = 5 Then
|
|
|
80 |
Get_Run_Level = "Waiting"
|
|
|
81 |
ElseIf nLevel = 6 Then
|
|
|
82 |
Get_Run_Level = "Publishing"
|
|
|
83 |
Else
|
|
|
84 |
Get_Run_Level = "<span class='err_alert'>Unknown!</span>"
|
|
|
85 |
End If
|
|
|
86 |
End If
|
|
|
87 |
|
|
|
88 |
End Function
|
|
|
89 |
|
|
|
90 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
91 |
Function Get_Package_Name( sPackageName,nRtagId,nPkgPvid )
|
|
|
92 |
|
|
|
93 |
If IsNull(sPackageName) Then
|
|
|
94 |
Get_Package_Name = "None"
|
|
|
95 |
ElseIf IsNull(nPkgPvid) or nPkgPvid <= 0 Then
|
|
|
96 |
Get_Package_Name = sPackageName
|
|
|
97 |
Else
|
|
|
98 |
Get_Package_Name = "<a class=""txt_linked"" href=""dependencies.asp?pv_id=" + nPkgPvid + "&rtag_id=" + nRtagId + """>" + sPackageName + "</a>"
|
|
|
99 |
End If
|
|
|
100 |
|
|
|
101 |
End Function
|
|
|
102 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
103 |
Function GetLastBuildAge( rtagid)
|
|
|
104 |
Dim query_string, rsQry
|
|
|
105 |
query_string = "SELECT TRUNC (86400*(SYSDATE - rl.LAST_BUILD)) as delta," &_
|
|
|
106 |
" TO_CHAR(rl.LAST_BUILD, 'DD-Mon-YYYY') as last_build," &_
|
|
|
107 |
" TO_CHAR(rl.LAST_BUILD, 'HH:MI:SS PM') as last_build_hours," &_
|
|
|
108 |
" TRUNC (SYSDATE - rl.LAST_BUILD) as last_build_days" &_
|
|
|
109 |
" FROM RELEASE_CONFIG rc, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm " &_
|
|
|
110 |
" WHERE rc.RTAG_ID =" &rtagid &_
|
|
|
111 |
" AND rc.bmcon_id is not null" &_
|
|
|
112 |
" AND rl.RCON_ID = rc.RCON_ID" &_
|
|
|
113 |
" AND rc.bmcon_id = bm.bmcon_id(+)"
|
|
|
114 |
|
|
|
115 |
Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
|
|
|
116 |
If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then
|
|
|
117 |
Dim delta, last_build, last_build_time, last_build_days
|
|
|
118 |
If IsNull(rsQry("delta")) Then
|
|
|
119 |
delta = 0
|
|
|
120 |
Else
|
|
|
121 |
delta = CLng(rsQry("delta"))
|
|
|
122 |
End If
|
|
|
123 |
last_build = rsQry("last_build")
|
|
|
124 |
last_build_time = rsQry("last_build_hours")
|
|
|
125 |
last_build_days = rsQry("last_build_days")
|
|
|
126 |
If delta < (60*60*24) Then
|
|
|
127 |
GetLastBuildAge = last_build_time
|
|
|
128 |
Else
|
|
|
129 |
GetLastBuildAge = last_build
|
|
|
130 |
End If
|
|
|
131 |
End If
|
|
|
132 |
rsQry.Close()
|
|
|
133 |
Set rsQry = nothing
|
|
|
134 |
|
|
|
135 |
End Function
|
|
|
136 |
|
|
|
137 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
138 |
Function GetModifiedSeqNo( rtagid)
|
|
|
139 |
Dim query_string, rsQry
|
|
|
140 |
query_string = "SELECT SEQNUM FROM RELEASE_MODIFIED WHERE RTAG_ID = " & rtagid
|
|
|
141 |
|
|
|
142 |
Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
|
|
|
143 |
If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then
|
|
|
144 |
GetModifiedSeqNo = rsQry("SEQNUM")
|
|
|
145 |
Else
|
|
|
146 |
GetModifiedSeqNo = "-"
|
|
|
147 |
End If
|
|
|
148 |
rsQry.Close()
|
|
|
149 |
Set rsQry = nothing
|
|
|
150 |
|
|
|
151 |
End Function
|
|
|
152 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
153 |
Function CheckConfigErrors (rtagId)
|
|
|
154 |
|
|
|
155 |
Dim rsQry, query
|
|
|
156 |
CheckConfigErrors = false
|
|
|
157 |
|
|
|
158 |
OraDatabase.Parameters.Add "RTAG_ID", rtagId, ORAPARM_INPUT, ORATYPE_NUMBER
|
|
|
159 |
|
|
|
160 |
'
|
|
|
161 |
' Check that there is exacly one master in the build set
|
|
|
162 |
query = _
|
|
|
163 |
"SELECT COUNT (rc.daemon_mode) as masterCount" &_
|
|
|
164 |
" FROM release_manager.release_config rc, release_manager.run_level rl" &_
|
|
|
165 |
" WHERE rc.rtag_id = :RTAG_ID" &_
|
|
|
166 |
" AND rl.RCON_ID = rc.RCON_ID" &_
|
|
|
167 |
" AND rc.bmcon_id is not NULL" &_
|
|
|
168 |
" GROUP BY rc.daemon_mode" &_
|
|
|
169 |
" HAVING rc.daemon_mode = 'M'"
|
|
|
170 |
|
|
|
171 |
Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
|
|
|
172 |
|
|
|
173 |
If rsQry.RecordCount > 0 Then
|
|
|
174 |
If rsQry("masterCount") <> 1 Then
|
|
|
175 |
CheckConfigErrors = true
|
|
|
176 |
End If
|
|
|
177 |
End If
|
|
|
178 |
rsQry.Close
|
|
|
179 |
Set rsQry = Nothing
|
|
|
180 |
|
|
|
181 |
If NOT CheckConfigErrors Then
|
|
|
182 |
|
|
|
183 |
'
|
|
|
184 |
' Check that each GBE_MACHTYPE has exactly one insatnce where the BUILDFILTER contains
|
|
|
185 |
' a TOOLSET builder. The test is a bit sloppy
|
|
|
186 |
query = _
|
|
|
187 |
"SELECT * from ( " &_
|
|
|
188 |
"SELECT GBE_ID, COUNT(hasToolset) as ToolsetCount " &_
|
|
|
189 |
"FROM " &_
|
|
|
190 |
" (SELECT bc.GBE_ID, " &_
|
|
|
191 |
" CASE " &_
|
|
|
192 |
" WHEN INSTR(rc.GBE_BUILDFILTER, 'TOOLSET') > 0 " &_
|
|
|
193 |
" THEN 1 " &_
|
|
|
194 |
" ELSE NULL " &_
|
|
|
195 |
" END AS hasToolset " &_
|
|
|
196 |
" FROM release_manager.release_config rc, " &_
|
|
|
197 |
" BUILD_MACHINE_CONFIG bc " &_
|
| 6175 |
dpurdie |
198 |
" WHERE rc.rtag_id = :RTAG_ID " &_
|
| 6166 |
dpurdie |
199 |
" AND rc.bmcon_id IS NOT NULL " &_
|
|
|
200 |
" AND bc.bmcon_id = rc.bmcon_id " &_
|
|
|
201 |
" ) " &_
|
|
|
202 |
"GROUP BY GBE_ID ) " &_
|
|
|
203 |
"Where ToolsetCount != 1 "
|
|
|
204 |
|
|
|
205 |
Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
|
|
|
206 |
|
|
|
207 |
If rsQry.RecordCount > 0 Then
|
|
|
208 |
CheckConfigErrors = true
|
|
|
209 |
End If
|
|
|
210 |
|
|
|
211 |
rsQry.Close
|
|
|
212 |
Set rsQry = Nothing
|
|
|
213 |
|
|
|
214 |
End If
|
|
|
215 |
|
|
|
216 |
OraDatabase.Parameters.Remove "RTAG_ID"
|
|
|
217 |
|
|
|
218 |
End Function
|
|
|
219 |
|
|
|
220 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
221 |
Function Indefinitely_Paused()
|
|
|
222 |
Dim rsQry2
|
|
|
223 |
Dim query_string2
|
|
|
224 |
|
|
|
225 |
Indefinitely_Paused = False
|
|
|
226 |
|
|
|
227 |
query_string2 = " select * from run_level_schedule rls where rls.indefinite_pause = 'P'"
|
|
|
228 |
|
|
|
229 |
Set rsQry2 = OraDatabase.DbCreateDynaset( query_string2, ORADYN_DEFAULT )
|
|
|
230 |
If rsQry2.RecordCount > 0 Then
|
|
|
231 |
Indefinitely_Paused = True
|
|
|
232 |
End If
|
|
|
233 |
End Function
|
| 6175 |
dpurdie |
234 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
235 |
Sub BuildMenuPane
|
|
|
236 |
If parRtagId <> 0 Then %>
|
|
|
237 |
<fieldset class=body_rowg>
|
|
|
238 |
<legend class="body_scol">Build Menu</legend>
|
|
|
239 |
<div style="margin:3px"><a href="release_config.asp?rtag_id=<%=parRtagId%>" class="body_rowg">Configuration</a></div>
|
|
|
240 |
<div style="margin:3px"><a href="build_status.asp?rtag_id=<%=parRtagId%>" class="body_rowg">Build Status</a></div>
|
|
|
241 |
<div style="margin:3px"><a href="build_plan.asp?rtag_id=<%=parRtagId%>" class="body_rowg">Build Plan</a></div>
|
|
|
242 |
<div style="margin:3px"><a href="build_release_log.asp?rtag_id=<%=parRtagId%>" class="body_rowg">Build Log</a></div>
|
|
|
243 |
</fieldset>
|
|
|
244 |
<%
|
|
|
245 |
End If
|
|
|
246 |
End Sub
|
| 6166 |
dpurdie |
247 |
%>
|
|
|
248 |
|