Changeset 61472 in vbox for trunk/src/VBox/ValidationKit/testmanager/core/testcase.pgsql

Timestamp:

Jun 5, 2016 5:46:15 PM (9 years ago)

Author:

vboxsync

Message:

testmanager: adding sComment columns to TestCases, TestGroups and SchedGroups.

File:

• trunk/src/VBox/ValidationKit/testmanager/core/testcase.pgsql (modified) (5 diffs)

trunk/src/VBox/ValidationKit/testmanager/core/testcase.pgsql

@@ -32 +32 @@
 DROP FUNCTION IF EXISTS del_testcase(INTEGER);
 DROP FUNCTION IF EXISTS TestCaseLogic_delEntry(INTEGER, INTEGER);
+DROP FUNCTION IF EXISTS TestCaseLogic_addEntry(a_uidAuthor INTEGER, a_sName TEXT, a_sDescription TEXT,
+                                               a_fEnabled BOOL, a_cSecTimeout INTEGER,  a_sTestBoxReqExpr TEXT,
+                                               a_sBuildReqExpr TEXT, a_sBaseCmd TEXT, a_sTestSuiteZips TEXT);
+DROP FUNCTION IF EXISTS TestCaseLogic_editEntry(a_uidAuthor INTEGER, a_idTestCase INTEGER, a_sName TEXT, a_sDescription TEXT,
+                                                a_fEnabled BOOL, a_cSecTimeout INTEGER,  a_sTestBoxReqExpr TEXT,
+                                                a_sBuildReqExpr TEXT, a_sBaseCmd TEXT, a_sTestSuiteZips TEXT);
 
 ---
@@ -96 +102 @@
 $$ LANGUAGE plpgsql;
 
+
 CREATE OR REPLACE function TestCaseLogic_addEntry(a_uidAuthor INTEGER, a_sName TEXT, a_sDescription TEXT, 
                                                   a_fEnabled BOOL, a_cSecTimeout INTEGER,  a_sTestBoxReqExpr TEXT, 
-                                                  a_sBuildReqExpr TEXT, a_sBaseCmd TEXT, a_sTestSuiteZips TEXT) 
+                                                  a_sBuildReqExpr TEXT, a_sBaseCmd TEXT, a_sTestSuiteZips TEXT,
+                                                  a_sComment TEXT)
     RETURNS INTEGER AS $$
     DECLARE 
@@ -106 +114 @@
 
         INSERT INTO TestCases (uidAuthor, sName, sDescription, fEnabled, cSecTimeout, 
-                               sTestBoxReqExpr, sBuildReqExpr, sBaseCmd, sTestSuiteZips)
+                               sTestBoxReqExpr, sBuildReqExpr, sBaseCmd, sTestSuiteZips, sComment)
             VALUES (a_uidAuthor, a_sName, a_sDescription, a_fEnabled, a_cSecTimeout, 
-                    a_sTestBoxReqExpr, a_sBuildReqExpr, a_sBaseCmd, a_sTestSuiteZips)
+                    a_sTestBoxReqExpr, a_sBuildReqExpr, a_sBaseCmd, a_sTestSuiteZips, a_Comment)
             RETURNING idTestcase INTO v_idTestCase;
         RETURN v_idTestCase;
@@ -114 +122 @@
 $$ LANGUAGE plpgsql;
 
+
 CREATE OR REPLACE function TestCaseLogic_editEntry(a_uidAuthor INTEGER, a_idTestCase INTEGER, a_sName TEXT, a_sDescription TEXT, 
                                                    a_fEnabled BOOL, a_cSecTimeout INTEGER,  a_sTestBoxReqExpr TEXT, 
-                                                   a_sBuildReqExpr TEXT, a_sBaseCmd TEXT, a_sTestSuiteZips TEXT) 
+                                                   a_sBuildReqExpr TEXT, a_sBaseCmd TEXT, a_sTestSuiteZips TEXT,
+                                                   a_sComment TEXT)
     RETURNS INTEGER AS $$
     DECLARE 
@@ -126 +136 @@
         PERFORM TestCaseLogic_historizeEntry(a_idTestCase, CURRENT_TIMESTAMP);
         INSERT INTO TestCases (idTestCase, uidAuthor, sName, sDescription, fEnabled, cSecTimeout, 
-                               sTestBoxReqExpr, sBuildReqExpr, sBaseCmd, sTestSuiteZips)
+                               sTestBoxReqExpr, sBuildReqExpr, sBaseCmd, sTestSuiteZips, sComment)
             VALUES (a_idTestCase, a_uidAuthor, a_sName, a_sDescription, a_fEnabled, a_cSecTimeout, 
-                    a_sTestBoxReqExpr, a_sBuildReqExpr, a_sBaseCmd, a_sTestSuiteZips)
+                    a_sTestBoxReqExpr, a_sBuildReqExpr, a_sBaseCmd, a_sTestSuiteZips, a_sComment)
             RETURNING idGenTestCase INTO v_idGenTestCase;
        RETURN v_idGenTestCase;