Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'               UPDATE dependencies
'               _update_dependencies.asp
'               --- PROCESS FORM ---
'=====================================================
%>
<%
Option explicit
' Good idea to set when using redirect
Response.Expires = 0   ' always load the page, dont store
%>

<!--#include file="common/conf.asp"-->
<!--#include file="common/globals.asp"-->
<!--#include file="common/formating.asp"-->
<!--#include file="common/qstr.asp"-->
<!--#include file="common/common_subs.asp"-->
<!--#include file="common/common_dbedit.asp"-->
<%
' Set rfile parameter. This is a return page after Login
Call objPMod.StoreParameter ( "rfile", "dependencies.asp" )
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_login.asp"-->
<!--#include file="_access_control_general.asp"-->
<!--#include file="_access_control_project.asp"-->
<%
'------------ Variable Definition -------------
Dim depArray()
Dim array_is_empty
'------------ Constants Declaration -----------
Const enumlocal_DONOT_DELETE_OLD_DEPENDENCIES = 0
Const enumlocal_DELETE_OLD_DEPENDENCIES = 1
Const COL_pkg_name = 0
Const COL_pkg_version = 1
Const COL_build_type = 2
'------------ Variable Init -------------------
'----------------------------------------------
%>
<%
'
'   Populate from a form
'       Assumes that items are seqentially numbered starting at 1
Sub Populate_depArray_from_Import ( ARRdep, BBarray_is_empty )
   Dim recCnt, pkg_name, pkg_version, build_type

   recCnt=0
   BBarray_is_empty = true
   Do While TRUE
       pkg_name = Request("btName" & recCnt + 1)
       pkg_version = Request("pkgn" & recCnt + 1)
       build_type = Request("bt" & recCnt + 1)
     
          ' Proceed only if:
          '    pkg name is not empty,
          '    pkg version is not empty,
          If ( pkg_name <> "" )  AND  ( pkg_version <> "" ) Then
             ReDim Preserve ARRdep( 2, recCnt )
             ARRdep( COL_pkg_name, recCnt ) = pkg_name
             ARRdep( COL_pkg_version, recCnt ) = pkg_version
             ARRdep( COL_build_type, recCnt ) = build_type
             recCnt = recCnt + 1
             BBarray_is_empty = FALSE
         Else
            Exit Do
         End If
   Loop
End Sub

' This function is called when update_type is "add_custom". This is only the case when adding dependencies
' The list given via the actual parameter pkg_list is in fact a list of pv_id's supplied from the form_search_result_pkgs.asp
' and form_add_pkg_versions.asp files. In the past, it only ever used to be a list of package IDs, but this has now been
' changed so that users can only add package versions from the relevant release as dependencies to a packge also in that
' release, and to do this, the list has to hold pv_id's instead of pkg_id's, to cater for situations where a release
' contains 2 instances of a package, each one having different extensions (eg .mas, .sea).
Sub Populate_depArray_from_ADD_Custom ( NNpv_id_list, ARRdep, BBarray_is_empty )
   Dim depList, lastItem, i, recCnt, pkg_name, pkg_version, V_EXT
   Dim rsTemp, Query_String, PkgBaseView

   PkgBaseView = Get_Pkg_Base_View_ID ( Request("pv_id"), Request("rtag_id") )

   Query_String = _
   " SELECT pkgs.pkg_id, pkgs.pkg_name, pv.pv_id, pv.pkg_version"&_
   "  FROM packages pkgs, package_versions pv"&_
   " WHERE pv.pv_id IN ("& NNpv_id_list &")"&_
   "   AND pv.pkg_id = pkgs.pkg_id"
   Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))

   recCnt = 0
   While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
      ReDim Preserve ARRdep( 2, recCnt )
      ARRdep( COL_pkg_name, recCnt ) = rsTemp("pkg_name")
      ARRdep( COL_pkg_version, recCnt ) = rsTemp("pkg_version")

      '// Dependencies comming from custom dependency add are set to LinkPkgArchive by default, unless it is a product
      If PkgBaseView = enumBASE_VIEW_PRODUCTS Then
         ARRdep( COL_build_type, recCnt ) = enum_BUILD_PKG_ARCHIVE
      Else
         ARRdep( COL_build_type, recCnt ) = enum_LINK_PKG_ARCHIVE
      End If

      recCnt = recCnt + 1
      BBarray_is_empty = FALSE
      rsTemp.MoveNext
   WEnd

   rsTemp.Close
   Set rsTemp = nothing
End Sub

// The form passed to us may only have information for packages that need to change
// The enumlocal_DONOT_DELETE_OLD_DEPENDENCIES does not appear to work
//  Must provide a full set of dependencies with either a new version or the existing version
//
Sub Populate_depArray_from_EDIT_Custom ( NNpv_id, ARRdep, BBarray_is_empty, sDependBlock )
   Dim depList, lastItem, i, recCnt, pkg_name, pkg_version, V_EXT
   Dim rsTemp, rsCurrent, Query_String

   Query_String = _
   " SELECT dpkg.pkg_name, dpv.pkg_version, dpv.pv_id"&_
   "  FROM package_dependencies dep,"&_
   "       package_versions dpv,"&_
   "       packages dpkg"&_
   " WHERE dep.dpv_id = dpv.pv_id"&_
   "   AND dpv.pkg_id = dpkg.pkg_id"&_
   "   AND dep.pv_id = "& NNpv_id

   Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))

   recCnt = 0
   While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
      Dim pvid, pkgver, newver
      pvid = rsTemp("pv_id")
      pkgver = Request( "pkgn" & pvid )

      If pkgver <> "" Then
        newver = pkgver
      else
        newver = rsTemp("pkg_version")
      End if

      ReDim Preserve ARRdep( 2, recCnt )
      ARRdep( COL_pkg_name, recCnt )    = rsTemp("pkg_name")
      ARRdep( COL_pkg_version, recCnt ) = newver
      ARRdep( COL_build_type, recCnt )  = Request( "bt"& pvid )

      If not rsTemp("pkg_version") =  newver Then
         sDependBlock = rsTemp("pkg_name") & " " & newver
      End If

      recCnt = recCnt + 1
      BBarray_is_empty = FALSE

      rsTemp.MoveNext
   WEnd

   rsTemp.Close
   Set rsTemp = nothing

End Sub

Sub Update_Package_Dependencies ( ARRdep, NNpv_id, NNuser_id, NNdelete_old_dependency, sAction_type, sDependBlock )
   Dim i, OraParameter, sComments

   OraDatabase.Parameters.Add "PV_ID",            NNpv_id,                 ORAPARM_INPUT, ORATYPE_NUMBER
   OraDatabase.Parameters.Add "PKG_NAME",         "",                      ORAPARM_INPUT, ORATYPE_VARCHAR2
   OraDatabase.Parameters.Add "PKG_VERSION",      "",                      ORAPARM_INPUT, ORATYPE_VARCHAR2
   OraDatabase.Parameters.Add "BUILD_TYPE",       "",                      ORAPARM_INPUT, ORATYPE_VARCHAR2
   OraDatabase.Parameters.Add "USER_ID",          NNuser_id,               ORAPARM_INPUT, ORATYPE_NUMBER
   OraDatabase.Parameters.Add "DELETE_PV_ID",     NNdelete_old_dependency, ORAPARM_INPUT, ORATYPE_NUMBER
   OraDatabase.Parameters.Add "ACTION_TYPE_NAME", sAction_type,            ORAPARM_INPUT, ORATYPE_VARCHAR2

   Set OraParameter = OraDatabase.Parameters

   For i = 0 To UBound( ARRdep, 2 )
      If not i = 0 Then
         sComments = sComments & ", "
      End If
      sComments = sComments & depArray(COL_pkg_name, i) & " " & ARRdep( COL_pkg_version, i )

      OraParameter("PKG_NAME").Value    = ARRdep( COL_pkg_name, i )
      OraParameter("PKG_VERSION").Value = ARRdep( COL_pkg_version, i )
      OraParameter("BUILD_TYPE").Value  = ARRdep( COL_build_type, i )

      OraDatabase.ExecuteSQL "BEGIN  Update_Package_Dependency ( :PV_ID, :PKG_NAME, :PKG_VERSION, :BUILD_TYPE, :USER_ID, :DELETE_PV_ID );  END;"

   Next

   Set OraParameter = Nothing

   If sAction_type = "depend_add" Then
      OraDatabase.Parameters.Add "COMMENTS",    sComments, ORAPARM_INPUT, ORATYPE_VARCHAR2
   Else
      If Len(sDependBlock) <= 4000 Then
         OraDatabase.Parameters.Add "COMMENTS",    sDependBlock, ORAPARM_INPUT, ORATYPE_VARCHAR2
      Else
         OraDatabase.Parameters.Add "COMMENTS",    "Description too long to be inserted!", ORAPARM_INPUT, ORATYPE_VARCHAR2
      End If
   End If

   OraDatabase.ExecuteSQL _
   "BEGIN  Log_Action ( :PV_ID, :ACTION_TYPE_NAME, :USER_ID, :COMMENTS );  END;"



   OraDatabase.Parameters.Remove "PV_ID"
   OraDatabase.Parameters.Remove "PKG_NAME"
   OraDatabase.Parameters.Remove "PKG_VERSION"
   OraDatabase.Parameters.Remove "BUILD_TYPE"
   OraDatabase.Parameters.Remove "USER_ID"
   OraDatabase.Parameters.Remove "DELETE_PV_ID"
   OraDatabase.Parameters.Remove "ACTION_TYPE_NAME"
   OraDatabase.Parameters.Remove "COMMENTS"
End Sub


Sub Remove_Old_Dependencies ( SSpv_id )
   OraDatabase.Parameters.Add "PV_ID", SSpv_id,    ORAPARM_INPUT, ORATYPE_NUMBER

   OraDatabase.ExecuteSQL "DELETE FROM package_dependencies WHERE pv_id = :PV_ID"

   OraDatabase.Parameters.Remove "PV_ID"
End Sub


Sub Update_Mod_Details ( SSpv_id )
   OraDatabase.Parameters.Add "PV_ID",   SSpv_id,                 ORAPARM_INPUT, ORATYPE_NUMBER
   OraDatabase.Parameters.Add "RTAG_ID", Request("rtag_id"),      ORAPARM_INPUT, ORATYPE_NUMBER
   OraDatabase.Parameters.Add "USER_ID", objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER

   OraDatabase.ExecuteSQL _
      " UPDATE package_versions "&_
       " SET modified_stamp = "& ORA_SYSDATETIME &", modifier_id = :USER_ID"&_
       " WHERE pv_id = :PV_ID"

   If Request("rtag_id") <> "" Then
      ' Package in release view
      OraDatabase.ExecuteSQL _
        "BEGIN "&_
      " Touch_Release ( :RTAG_ID ); "&_
      "END; "

   Else
      ' Package view
      OraDatabase.ExecuteSQL _
        "BEGIN "&_
      " PK_RELEASE.RUN_POST_ACTIONS_BULK ( :PV_ID ); "&_
      "END; "

   End If

   OraDatabase.Parameters.Remove "PV_ID"
   OraDatabase.Parameters.Remove "RTAG_ID"
   OraDatabase.Parameters.Remove "USER_ID"
End Sub

%>
<%
'-----------------------  MAIN LINE  ---------------------------
'Response.Write "<pre>------------<br>"
'Dim Item
'For Each Item In Request.Form
'    Response.Write "User Data: " &Item & ": " & Request.Form(Item) & "<br>"
'Next
'Response.Write "------------<br>"

Dim sDependBlock

'--- Process submition ---
If (QStrPar("pv_id") <> "")  Then
   ' All mandatory parameters FOUND

   Err.Clear
   On Error Resume Next
   OraSession.BeginTrans
   ' The called subroutines beneath here do not use "on error resume next", but this calling code does, so if any error
   ' occurs in the called functions, control will resume within this code somewhere. On the assumption that an error might
   ' be the result of some problem in the database, further database commands are not performed, achieved by making them
   ' conditional upon Err.Number being zero. Ultimately, this should result in a rollback

   array_is_empty = TRUE
   If Request("update_type") = "add_custom" Then
      '---- ADD CUSTOM dependency ----
      ' NOTE - this happens when user clicks the Add action button on the dependencies/runtime tabs. Although the underlying search operation
      ' (see form_search_pkgs.asp and form_search_result_pkgs.asp) returns a list called "pkg_list", it actually contains a pv_id list in these
      ' special cases.
      Call Populate_depArray_from_ADD_Custom ( Request("pkg_list"), depArray, array_is_empty )

      If ((NOT array_is_empty) AND (Err.number = 0)) Then
         Call Update_Package_Dependencies ( depArray, Request("pv_id"), objAccessControl.UserId, enumlocal_DELETE_OLD_DEPENDENCIES, "depend_add", null )
      End If


   ElseIf Request("update_type") = "edit_custom" Then
      '---- EDIT CUSTOM dependency ----
      Call Populate_depArray_from_EDIT_Custom ( Request("pv_id"), depArray, array_is_empty, sDependBlock )
      Call Remove_Old_Dependencies ( Request("pv_id") )

      If ((NOT array_is_empty) AND (Err.number = 0)) Then
         Call Update_Package_Dependencies ( depArray, Request("pv_id"), objAccessControl.UserId, enumlocal_DONOT_DELETE_OLD_DEPENDENCIES, "depend_update", sDependBlock )
      End If


   ElseIf Request("update_type") = "edit_import" Then
      '-- JATS,ANT dependency import after being edited
      Call Populate_depArray_from_Import ( depArray, array_is_empty )
      Call Remove_Old_Dependencies ( Request("pv_id") )

      If ((NOT array_is_empty) AND (Err.number = 0)) Then
         Call Update_Package_Dependencies ( depArray, Request("pv_id"), objAccessControl.UserId, enumlocal_DONOT_DELETE_OLD_DEPENDENCIES, "depend_import", Request("FRdeps") )
      End If
   Else
      '---- Unknown input type
        Response.write "Internal error. Unknown update_type!" & "<br>" 'TODO
        Err.number = 1
   End If


   If Err.number = 0 Then
      Call Update_Mod_Details ( Request("pv_id") )
   End If


   If Err.number <> 0 Then
      OraSession.RollBack
      Call RaiseMsg ( enum_MSG_ERROR, Err.description &"<br>"& Err.Source )
   Else
      OraSession.CommitTrans
   End If

   Response.Redirect("dependencies.asp?pv_id="& Request("pv_id") &"&rtag_id="& Request("rtag_id"))
Else
   Response.write "Some mandatory parameters are missing!" & "<br>" 'TODO
   Response.write QSTR_FullQuery
End If
%>

<!-- DESTRUCTOR ------->
<!--#include file="common/destructor.asp"-->