Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1
<?xml version="1.0" ?>
2
<package>
3
	<comment>
4
	PrimalCode wizard generated file.
5
	</comment>
6
	<job id="GenerateXMLNodeDefinitons" args="/bom_id:2864" prompt="no">
7
		<?job error="false" debug="false" ?>
8
		<runtime>
9
			<named helpstring="Bom ID" name="bom_id" required="false" type="string"/>
10
		</runtime>
11
		<object id="Oracle_Objects_For_OLE" progid="OracleInProcServer.XOraServer" events="true"/>
12
		<script language="VBScript" src="common_subs.vbs"/>
13
		<script language="VBScript" src="config.vbs"/>
14
		<script id="GenerateXMLNodeDefnitions" language="VBScript">
15
<![CDATA[
16
Option Explicit
17
'=====================================================
18
'        Name: 	GetComponents
19
' Description:	Connects to dpkg_archive and gets the
20
' 				content of folders and files of certain
21
' 				package. It then stores this info into 
22
'				Release Manager database. This info can
23
' 				later be included in release notes Or
24
' 				searched with search engine.
25
' 		INPUT:  pkg_name
26
'				pkg_version
27
'=====================================================
28
 
29
'== Variable Definition ==============================
30
Dim BomId
31
Dim objArgs
32
'== Constants Declaration ============================
33
'== Variable Init ====================================
34
'=====================================================
35
 
36
 
37
'-----------------------------------------------------------------------------------------------------------------
15 rsolanki 38
Sub GenerateXMLNodeDefinitionsWindows ( nBomId )
13 rsolanki 39
	Dim rsQry, aNetworkNodes, XMLNode, DateString
40
	Dim lastRow, row
41
 
42
	' Remove existing stuff
43
	Call DeleteFile( APP_ROOT &"downloads\*" )
44
 
45
 
46
	OraDatabase.Parameters.Add "BOM_ID", nBomId, ORAPARM_INPUT, ORATYPE_NUMBER 
47
 
48
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NetworkNodes.sql"), ORADYN_DEFAULT )
49
 
50
	OraDatabase.Parameters.Remove "BOM_ID"
51
 
52
	If rsQry.RecordCount > 0 Then
53
		aNetworkNodes = rsQry.GetRows()
54
 
55
	End If
56
 
57
	lastRow = UBound( aNetworkNodes, 2 )
58
	DateString = DateReversed( Date )
59
 
60
	For row = 0 To lastRow
61
 
62
		XMLNode = Null
63
 
64
		XMLNode = XMLNode &_
65
		"	<BomHeader>"& vbNewLine &_
66
		"		<release_ident></release_ident>"& vbNewLine &_
67
  		"		<bom_name>"& aNetworkNodes( 1, row ) &"</bom_name>"& vbNewLine &_
68
	  	"		<bom_type>system</bom_type>"& vbNewLine &_
69
	  	"		<bom_version>"& aNetworkNodes( 2, row ) &"."& aNetworkNodes( 3, row ) &"</bom_version>"& vbNewLine &_
70
	  	"		<bom_date>"& DateString &"</bom_date>"& vbNewLine &_
71
	  	"		<bom_status>REG</bom_status>"& vbNewLine &_
72
	  	"		<bom_status_date>"& DateString &"</bom_status_date>"& vbNewLine &_
73
		"	</BomHeader>"& vbNewLine 
74
 
15 rsolanki 75
 
76
		'-- Get Node Base Configurations Details --
77
		XMLNode = XMLNode & GetNodeBaseConfigDetailsWindows ( nBomId, aNetworkNodes( 0, row ) ) & vbNewLine 
78
 
13 rsolanki 79
 
15 rsolanki 80
		'-- Get Node Product Details --
81
		XMLNode = XMLNode & GetNodeDetailsWindows ( nBomId, aNetworkNodes( 0, row ) ) & vbNewLine 
13 rsolanki 82
 
83
 
84
		' Close xml node tag before saving
85
		XMLNode = _
86
		"<BomDistribution>"& vbNewLine &_
87
		XMLNode &"</BomDistribution>"& vbNewLine
88
 
89
		'WScript.Echo XMLNode
90
 
15 rsolanki 91
		If GetNodeBaseConfigDetailsWindows ( nBomId, aNetworkNodes( 0, row ) ) <> "" OR GetNodeDetailsWindows ( nBomId, aNetworkNodes( 0, row ) ) <> "" Then
92
			' Save to a file
93
			Call SaveFile( DateString, rsQry("version"), rsQry("branch_name"), APP_ROOT &"downloads",  FormatFileName( aNetworkNodes( 1, row ) ) &"_Windows.xml", XMLNode )
94
		End If	
13 rsolanki 95
 
15 rsolanki 96
	Next
97
 
98
 
99
 
100
 
101
 
102
End Sub
103
'-----------------------------------------------------------------------------------------------------------------
104
Sub GenerateXMLNodeDefinitionsSunOS ( nBomId )
105
	Dim rsQry, aNetworkNodes, XMLNode, DateString
106
	Dim lastRow, row
107
 
108
	' Remove existing stuff
109
	Call DeleteFile( APP_ROOT &"downloads\*" )
110
 
111
 
112
	OraDatabase.Parameters.Add "BOM_ID", nBomId, ORAPARM_INPUT, ORATYPE_NUMBER 
113
 
114
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NetworkNodes.sql"), ORADYN_DEFAULT )
115
 
116
	OraDatabase.Parameters.Remove "BOM_ID"
117
 
118
	If rsQry.RecordCount > 0 Then
119
		aNetworkNodes = rsQry.GetRows()
13 rsolanki 120
 
15 rsolanki 121
	End If
122
 
123
	lastRow = UBound( aNetworkNodes, 2 )
124
	DateString = DateReversed( Date )
125
 
126
	For row = 0 To lastRow
13 rsolanki 127
 
15 rsolanki 128
		XMLNode = Null
129
 
130
		XMLNode = XMLNode &_
131
		"	<BomHeader>"& vbNewLine &_
132
		"		<release_ident></release_ident>"& vbNewLine &_
133
  		"		<bom_name>"& aNetworkNodes( 1, row ) &"</bom_name>"& vbNewLine &_
134
	  	"		<bom_type>system</bom_type>"& vbNewLine &_
135
	  	"		<bom_version>"& aNetworkNodes( 2, row ) &"."& aNetworkNodes( 3, row ) &"</bom_version>"& vbNewLine &_
136
	  	"		<bom_date>"& DateString &"</bom_date>"& vbNewLine &_
137
	  	"		<bom_status>REG</bom_status>"& vbNewLine &_
138
	  	"		<bom_status_date>"& DateString &"</bom_status_date>"& vbNewLine &_
139
		"	</BomHeader>"& vbNewLine 
140
 
141
 
142
		'-- Get Node Base Configurations Details --
143
		XMLNode = XMLNode & GetNodeBaseConfigDetailsSunOS ( nBomId, aNetworkNodes( 0, row ) ) & vbNewLine 
144
 
145
 
146
		'-- Get Node Product Details --
147
		XMLNode = XMLNode & GetNodeDetailsSunOS ( nBomId, aNetworkNodes( 0, row ) ) & vbNewLine 
148
 
149
 
150
		' Close xml node tag before saving
151
		XMLNode = _
152
		"<BomDistribution>"& vbNewLine &_
153
		XMLNode &"</BomDistribution>"& vbNewLine
154
 
155
		'WScript.Echo XMLNode
156
 
157
		If GetNodeBaseConfigDetailsSunOS ( nBomId, aNetworkNodes( 0, row ) ) <> "" OR GetNodeDetailsSunOS ( nBomId, aNetworkNodes( 0, row ) ) <> "" Then		
158
			' Save to a file
159
			Call SaveFile( DateString, rsQry("version"), rsQry("branch_name"), APP_ROOT &"downloads",  FormatFileName( aNetworkNodes( 1, row ) ) &"_SunOS.xml", XMLNode )
160
		End If
161
 
13 rsolanki 162
	Next
163
 
164
 
165
 
166
 
167
 
168
End Sub
169
'-----------------------------------------------------------------------------------------------------------------
15 rsolanki 170
 
13 rsolanki 171
Function FormatFileName ( sFileName )
172
	Dim sReturn
173
 
174
	sReturn = Replace ( sFileName, "/", "" ) 	
175
	sReturn = Replace ( sReturn, "\", "" ) 	
176
	sReturn = Replace ( sReturn, "&", "And" ) 	
177
	sReturn = Replace ( sReturn, " ", "_" ) 	
178
 
179
	FormatFileName = sReturn
180
 
181
End Function
182
'-----------------------------------------------------------------------------------------------------------------
15 rsolanki 183
Function GetNodeBaseConfigDetailsWindows ( nBomId, nNodeId )
184
	Dim rsQry, XMLPackageString, pkgName, pkgReleaseType, osType
13 rsolanki 185
 
186
	OraDatabase.Parameters.Add "BOM_ID", nBomId, ORAPARM_INPUT, ORATYPE_NUMBER 
187
	OraDatabase.Parameters.Add "NODE_ID", nNodeId, ORAPARM_INPUT, ORATYPE_NUMBER 
188
 
15 rsolanki 189
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NodeBaseConfigsWindows.sql"), ORADYN_DEFAULT )
13 rsolanki 190
 
191
	OraDatabase.Parameters.Remove "BOM_ID"
192
	OraDatabase.Parameters.Remove "NODE_ID"
193
 
194
 
195
	While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
196
 
15 rsolanki 197
		If rsQry("win_electronic_name") <> "" Then
198
			pkgName = rsQry("win_electronic_name")
199
		Else
200
			pkgName = rsQry("pkg_name")
201
		End If
202
 
203
		If rsQry("is_patch") = "Y" Then
204
			pkgReleaseType = "PT"
205
		Else
206
			pkgReleaseType = "IR"
207
		End If
208
 
209
		If rsQry("os_name") <> "" Then
210
			osType = rsQry("os_name")
211
		Else
212
			osType = rsQry("bos_type")
213
		End If
214
 
215
 
13 rsolanki 216
		XMLPackageString = XMLPackageString &_
217
		"	<PackageRecord>"& vbNewLine &_
15 rsolanki 218
		"		<pkg_name>"& pkgName &"</pkg_name>"& vbNewLine &_
13 rsolanki 219
  		"		<pkg_version>"& rsQry("pkg_version") &"</pkg_version>"& vbNewLine &_
220
  		"		<pkg_date>2003-03-01</pkg_date>"& vbNewLine &_
221
  		"		<pkg_status>REG</pkg_status>"& vbNewLine &_
222
  		"		<pkg_status_date>"& DateReversed( CDate( rsQry("modified_stamp") ) ) &"</pkg_status_date>"& vbNewLine &_
223
  		"		<pkg_target></pkg_target>"& vbNewLine &_
224
    	"		<pkg_platform_list>"& vbNewLine &_
15 rsolanki 225
        "			<platform_record>"& osType &"</platform_record>"& vbNewLine &_
13 rsolanki 226
        "		</pkg_platform_list>"& vbNewLine &_ 
15 rsolanki 227
  		"		<pkg_release_type>"& pkgReleaseType &"</pkg_release_type>"& vbNewLine &_
13 rsolanki 228
		"	</PackageRecord>"& vbNewLine
229
 
230
 
231
		rsQry.MoveNext()
232
	Wend	
233
 
234
	rsQry.Close()
235
	Set rsQry = Nothing
236
 
237
	' Return string
15 rsolanki 238
	GetNodeBaseConfigDetailsWindows = XMLPackageString	
13 rsolanki 239
 
240
End Function
241
'-----------------------------------------------------------------------------------------------------------------
15 rsolanki 242
Function GetNodeBaseConfigDetailsSunOS ( nBomId, nNodeId )
243
	Dim rsQry, XMLPackageString, pkgName, pkgReleaseType, osType
244
 
245
	OraDatabase.Parameters.Add "BOM_ID", nBomId, ORAPARM_INPUT, ORATYPE_NUMBER 
246
	OraDatabase.Parameters.Add "NODE_ID", nNodeId, ORAPARM_INPUT, ORATYPE_NUMBER 
247
 
248
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NodeBaseConfigsSunOS.sql"), ORADYN_DEFAULT )
249
 
250
	OraDatabase.Parameters.Remove "BOM_ID"
251
	OraDatabase.Parameters.Remove "NODE_ID"
252
 
253
 
254
	While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
255
 
256
		If rsQry("sunos_electronic_name") <> "" Then
257
			pkgName = rsQry("sunos_electronic_name")
258
		Else
259
			pkgName = rsQry("pkg_name")
260
		End If
13 rsolanki 261
 
15 rsolanki 262
		If rsQry("is_patch") = "Y" Then
263
			pkgReleaseType = "PT"
264
		Else
265
			pkgReleaseType = "IR"
266
		End If
13 rsolanki 267
 
15 rsolanki 268
		If rsQry("os_name") <> "" Then
269
			osType = rsQry("os_name")
270
		Else
271
			osType = rsQry("bos_type")
272
		End If
13 rsolanki 273
 
15 rsolanki 274
 
275
		XMLPackageString = XMLPackageString &_
276
		"	<PackageRecord>"& vbNewLine &_
277
		"		<pkg_name>"& pkgName &"</pkg_name>"& vbNewLine &_
278
  		"		<pkg_version>"& rsQry("pkg_version") &"</pkg_version>"& vbNewLine &_
279
  		"		<pkg_date>2003-03-01</pkg_date>"& vbNewLine &_
280
  		"		<pkg_status>REG</pkg_status>"& vbNewLine &_
281
  		"		<pkg_status_date>"& DateReversed( CDate( rsQry("modified_stamp") ) ) &"</pkg_status_date>"& vbNewLine &_
282
  		"		<pkg_target></pkg_target>"& vbNewLine &_
283
    	"		<pkg_platform_list>"& vbNewLine &_
284
        "			<platform_record>"& osType &"</platform_record>"& vbNewLine &_
285
        "		</pkg_platform_list>"& vbNewLine &_ 
286
  		"		<pkg_release_type>"& pkgReleaseType &"</pkg_release_type>"& vbNewLine &_
287
		"	</PackageRecord>"& vbNewLine
288
 
289
 
290
		rsQry.MoveNext()
291
	Wend	
292
 
293
	rsQry.Close()
294
	Set rsQry = Nothing
295
 
296
	' Return string
297
	GetNodeBaseConfigDetailsSunOS = XMLPackageString	
298
 
299
End Function
300
'-----------------------------------------------------------------------------------------------------------------
301
Function GetNodeDetailsWindows ( nBomId, nNodeId )
302
	Dim rsQry, XMLPackageString, pkgName, pkgReleaseType, osType
303
 
304
	OraDatabase.Parameters.Add "BOM_ID", nBomId, ORAPARM_INPUT, ORATYPE_NUMBER 
305
	OraDatabase.Parameters.Add "NODE_ID", nNodeId, ORAPARM_INPUT, ORATYPE_NUMBER 
306
 
307
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NodeProductsWindows.sql"), ORADYN_DEFAULT )
308
 
309
	OraDatabase.Parameters.Remove "BOM_ID"
310
	OraDatabase.Parameters.Remove "NODE_ID"
311
 
312
 
313
	While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
314
 
315
		If rsQry("win_electronic_name") <> "" Then
316
			pkgName = rsQry("win_electronic_name")
317
		Else
318
			pkgName = rsQry("pkg_name")
319
		End If
320
 
321
		If rsQry("is_patch") = "Y" Then
322
			pkgReleaseType = "PT"
323
		Else
324
			pkgReleaseType = "IR"
325
		End If
326
 
327
		If rsQry("os_name") <> "" Then
328
			osType = rsQry("os_name")
329
		Else
330
			osType = rsQry("bos_type")
331
		End If
332
 
333
 
334
		XMLPackageString = XMLPackageString &_
335
		"	<PackageRecord>"& vbNewLine &_
336
		"		<pkg_name>"& pkgName &"</pkg_name>"& vbNewLine &_
337
  		"		<pkg_version>"& rsQry("pkg_version") &"</pkg_version>"& vbNewLine &_
338
  		"		<pkg_date>2003-03-01</pkg_date>"& vbNewLine &_
339
  		"		<pkg_status>REG</pkg_status>"& vbNewLine &_
340
  		"		<pkg_status_date>"& DateReversed( CDate( rsQry("modified_stamp") ) ) &"</pkg_status_date>"& vbNewLine &_
341
  		"		<pkg_target></pkg_target>"& vbNewLine &_
342
    	"		<pkg_platform_list>"& vbNewLine &_
343
        "			<platform_record>"& osType &"</platform_record>"& vbNewLine &_
344
        "		</pkg_platform_list>"& vbNewLine &_ 
345
  		"		<pkg_release_type>"& pkgReleaseType &"</pkg_release_type>"& vbNewLine &_
346
		"	</PackageRecord>"& vbNewLine
347
 
348
 
349
		rsQry.MoveNext()
350
	Wend	
351
 
352
	rsQry.Close()
353
	Set rsQry = Nothing
354
 
355
	' Return string
356
	GetNodeDetailsWindows = XMLPackageString	
357
 
358
End Function
359
'-----------------------------------------------------------------------------------------------------------------
360
Function GetNodeDetailsSunOS ( nBomId, nNodeId )
361
	Dim rsQry, XMLPackageString, pkgName, pkgReleaseType, osType
362
 
363
	OraDatabase.Parameters.Add "BOM_ID", nBomId, ORAPARM_INPUT, ORATYPE_NUMBER 
364
	OraDatabase.Parameters.Add "NODE_ID", nNodeId, ORAPARM_INPUT, ORATYPE_NUMBER 
365
 
366
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NodeProductsSunOS.sql"), ORADYN_DEFAULT )
367
 
368
	OraDatabase.Parameters.Remove "BOM_ID"
369
	OraDatabase.Parameters.Remove "NODE_ID"
370
 
371
 
372
	While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
373
 
374
		If rsQry("sunos_electronic_name") <> "" Then
375
			pkgName = rsQry("sunos_electronic_name")
376
		Else
377
			pkgName = rsQry("pkg_name")
378
		End If
379
 
380
		If rsQry("is_patch") = "Y" Then
381
			pkgReleaseType = "PT"
382
		Else
383
			pkgReleaseType = "IR"
384
		End If
385
 
386
		If rsQry("os_name") <> "" Then
387
			osType = rsQry("os_name")
388
		Else
389
			osType = rsQry("bos_type")
390
		End If
391
 
392
 
393
		XMLPackageString = XMLPackageString &_
394
		"	<PackageRecord>"& vbNewLine &_
395
		"		<pkg_name>"& pkgName &"</pkg_name>"& vbNewLine &_
396
  		"		<pkg_version>"& rsQry("pkg_version") &"</pkg_version>"& vbNewLine &_
397
  		"		<pkg_date>2003-03-01</pkg_date>"& vbNewLine &_
398
  		"		<pkg_status>REG</pkg_status>"& vbNewLine &_
399
  		"		<pkg_status_date>"& DateReversed( CDate( rsQry("modified_stamp") ) ) &"</pkg_status_date>"& vbNewLine &_
400
  		"		<pkg_target></pkg_target>"& vbNewLine &_
401
    	"		<pkg_platform_list>"& vbNewLine &_
402
        "			<platform_record>"& osType &"</platform_record>"& vbNewLine &_
403
        "		</pkg_platform_list>"& vbNewLine &_ 
404
  		"		<pkg_release_type>"& pkgReleaseType &"</pkg_release_type>"& vbNewLine &_
405
		"	</PackageRecord>"& vbNewLine
406
 
407
 
408
		rsQry.MoveNext()
409
	Wend	
410
 
411
	rsQry.Close()
412
	Set rsQry = Nothing
413
 
414
	' Return string
415
	GetNodeDetailsSunOS = XMLPackageString	
416
 
417
End Function
418
'-----------------------------------------------------------------------------------------------------------------
419
 
420
 
421
 
13 rsolanki 422
'=================================== MAIN LINE ======================================
423
WScript.Echo "==================== job:GenerateXMLNodeDefenitions ===================="
424
 
425
Set objArgs = WScript.Arguments
426
 
427
If (objArgs.Unnamed.Count > 0) Then
428
	Wscript.Echo "ERROR: Unnamed parameters!"
429
	objArgs.ShowUsage
430
   	WScript.Quit
431
 
432
Else
433
	BomId = objArgs.Named.Item("bom_id")
434
 
435
	If ( BomId <> "" ) Then
15 rsolanki 436
		Call GenerateXMLNodeDefinitionsWindows( BomId )
437
		Call GenerateXMLNodeDefinitionsSunOS( BomId )
13 rsolanki 438
 
439
   	Else
440
   		objArgs.ShowUsage
441
   		WScript.Quit
442
 
443
   	End If
444
 
445
End If
446
 
447
 
448
WScript.Echo "Job completed successfully!"
449
 
450
'====================================================================================
451
 
452
 
453
]]>
454
		</script>
455
	</job>
456
</package>