Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>

<%

'=====================================================

'   splunk_build_test_results.asp

'

'   This page is designed to be used by 'splunk'

'   It is a very simple REST style interface

'   It simple produces Build and Unit tests metrics

'

'   The output is pure JSON

'   There are two sections

'   info : {}       - Internal data about the process

'   data : {}       - Build and Test results

'

'   The data section is organised by:

'       Project and then Release

'       Within each release there is:

'           BuildsCompleted

'           BuildsInError

'       Within each of these there is:

'           Count           - Total packages

'           UnitTests       - Total Unit Tests

'           NewVersions     - Subset of Count

'           Ripples         - Subset of Count

'           Other           - Subset of Count

'   The data is for all time

'   [May need to rethink that if processing time blows out]

'

'   Get Requests

'       ?day=n            - Limit result set n days ago

'                             0 == Results since midnight

'                             1 == yesterday

'

'=====================================================

%>

<%

Option explicit

' Essential to get UTF through all the hoops. ie: VÄSTTRAFIK (VTK)

Response.ContentType = "text/html"

Response.AddHeader "Content-Type", "text/html;charset=UTF-8"

Response.CodePage = 65001

Response.CharSet = "UTF-8"

%>

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

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

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

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

<SCRIPT LANGUAGE="VBScript" RUNAT=SERVER SRC="class/classaspJSON.vbs"></SCRIPT> 

<%

'------------ Variable Definition -------------

Dim result : result = -1

Dim SqlQry

Dim rsQry

' Init the output JSON class

'   Default data will be added at the end

Dim oJSON   : Set oJSON = New aspJSON

Dim infoSet : Set infoSet = newDataSet("info", oJSON.data)

'

'   Perform the bulk of the work within a sub

'       Done so that errors propergate up

'       Using the On Error Resume Next, any error within the routine

'       will cause the routine to exit    

On Error Resume Next

Call DoWork

'

' SQL error detection and reporting

If objEH.LastOraFailed Then

    infoSet("error") = 1

    result = -2

    infoSet("emsgSummary") = objEH.MessageSummary

    infoSet("emsgDetails") = objEH.MessageDetails

    infoSet("SqlQry") = SqlQry

'

'   Detect program errors

ElseIf Err.number <> 0 Then

    result = -3

    infoSet("error") = 2

    infoSet("errnum") = Err.number

    infoSet("errtxt") = Err.description

    infoSet("errsrc") = Err.source

End If

infoSet("result") = result

'Return the object

Response.Write oJSON.JSONoutput()

OraSession.Dispose()

' --- End of Mainline

'------------------------------------------------------------------------------

'

'   Create a new collection and add it to an existing colelction

'       sname - Name of the new collection (Key Name)

'       pset  - Parent collection. The collection to add it to

'   Returns a Collection ( Scripting Dictionary)

Function newDataSet(sname, pset)

    Set newDataSet  = oJSON.Collection()

    Set pset(sname) = newDataSet

End Function

'------------------------------------------------------------------------------

'

'   Perform the body of the query

'   Done in a Sub so that errors can be better captured and reported

Sub DoWork

    '   Create a collection to contain the returned data

    '

    Dim dataSet : Set dataSet = newDataSet("data", oJSON.data)

    '

    '   Support time limited query

    '

    Dim repday : repday = NiceInt( Request("day"), -1 )

    Dim limit : limit = ""

    If repday >= 0 Then

        infoSet("day") = repday

        limit = " AND bi.TIMESTAMP > TRUNC(SYSDATE - "& repday &")"

        limit = limit & " AND bi.TIMESTAMP < TRUNC(SYSDATE - "& repday - 1 &")"

    End If

    '   The query

    '

    SqlQry = _

        "SELECT proj_name," &_

        "  rtag_name," &_

        "  state," &_

        "  reason,  " &_

        "  COUNT(reason)   AS rc," &_

        "  SUM(test_count) AS tc" &_

        " FROM" &_

        "  (SELECT pj.PROJ_NAME," &_

        "    RTAG_NAME," &_

        "    DECODE(bi.reason, 'N', 'NewVersion', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'Unknown') as REASON," &_

        "    DECODE(bi.state, 'B', 'Buiding', 'C', 'Complete', 'E', 'Error', 'S', 'SysErr', 'Unknown') as STATE," &_

        "    (SELECT COUNT(*) FROM TEST_RUN tr WHERE tr.build_id = bi.build_id ) AS test_count" &_

        "  FROM BUILD_INSTANCES bi," &_

        "    projects pj," &_

        "    RELEASE_TAGS rt" &_

        "  WHERE bi.RTAG_ID = rt.RTAG_ID" &_

        "  AND rt.proj_id   = pj.proj_id" & limit &_

        "  ) group by proj_name, rtag_name, state, reason" &_

        " ORDER BY PROJ_NAME, rtag_name,  state,  reason"

    On Error Resume Next

    objEH.ErrorRedirect = FALSE

    objEH.TryORA ( OraSession )

    Set rsQry = OraDatabase.DbCreateDynaset( SqlQry, ORADYN_DEFAULT )

    objEH.CatchORA ( OraSession )

    ' Process each row and return required fields to the user

    If objEH.Finally Then

    On Error goto 0

        Dim lastProjectName, proj : lastProjectName = ""

        Dim lastReleaseName, rel : lastReleaseName = ""

        Dim dataOk, dataError

        While (NOT rsQry.BOF) AND (NOT rsQry.EOF)

            ' Attempt to speed up access tot he data

            '    Extract all fields for the row

            '    Access fields by index

            Dim fields

            Set fields = rsQry.Fields

            Dim pname    : pname = fields(0)

            Dim rname    : rname = fields(1)

            Dim state    : state = fields(2)

            Dim reason   : reason = fields(3)

            Dim rc       : rc = CInt(fields(4))

            Dim tc       : tc = CInt(fields(5))

            Set fields = nothing

            ' Create new Items as required

            '

            If pname <> lastProjectName Then

                lastProjectName = pname

                Set proj = newDataSet(pname,dataSet )

            End If

            If rname <> lastReleaseName Then 

                Set rel = newDataSet(rname, proj)

                lastReleaseName = rname

                Set dataOk = newDataSet("BuildsCompleted", rel)

                dataOk("Count") = 0

                Set dataError = newDataSet("BuildsInError", rel)      

                dataError("Count") = 0

            End If

            '   Accumulate data

            '

            If state = "Complete" Then

                dataOk(reason)      = dataOk(reason) + rc 

                dataOk("Count")     = dataOk("Count") + rc 

                dataOk("UnitTests") = dataOk("UnitTests") + tc 

            Else

                dataError(reason)      = dataError(reason) + rc 

                dataError("Count")     = dataError("Count") + rc 

                dataError("UnitTests") = dataError("UnitTests") + tc 

            End If

            rsQry.MoveNext

        Wend

    End IF

    rsQry.Close

    Set rsQry = Nothing

    result = 0

End Sub

%>