From f215e02bf85f68d3a6106c2a1f4f7f063f819064 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Thu, 11 Apr 2024 10:17:27 +0200
Subject: Adding upstream version 7.0.14-dfsg.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 .../testmanager/batch/close_orphaned_testsets.py   | 105 +++++++++++++++++++++
 1 file changed, 105 insertions(+)
 create mode 100755 src/VBox/ValidationKit/testmanager/batch/close_orphaned_testsets.py

(limited to 'src/VBox/ValidationKit/testmanager/batch/close_orphaned_testsets.py')

diff --git a/src/VBox/ValidationKit/testmanager/batch/close_orphaned_testsets.py b/src/VBox/ValidationKit/testmanager/batch/close_orphaned_testsets.py
new file mode 100755
index 00000000..932122b5
--- /dev/null
+++ b/src/VBox/ValidationKit/testmanager/batch/close_orphaned_testsets.py
@@ -0,0 +1,105 @@
+#!/usr/bin/env python
+# -*- coding: utf-8 -*-
+# $Id: close_orphaned_testsets.py $
+# pylint: disable=line-too-long
+
+"""
+Maintenance tool for closing orphaned testsets.
+"""
+
+from __future__ import print_function;
+
+__copyright__ = \
+"""
+Copyright (C) 2012-2023 Oracle and/or its affiliates.
+
+This file is part of VirtualBox base platform packages, as
+available from https://www.virtualbox.org.
+
+This program is free software; you can redistribute it and/or
+modify it under the terms of the GNU General Public License
+as published by the Free Software Foundation, in version 3 of the
+License.
+
+This program is distributed in the hope that it will be useful, but
+WITHOUT ANY WARRANTY; without even the implied warranty of
+MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+General Public License for more details.
+
+You should have received a copy of the GNU General Public License
+along with this program; if not, see <https://www.gnu.org/licenses>.
+
+The contents of this file may alternatively be used under the terms
+of the Common Development and Distribution License Version 1.0
+(CDDL), a copy of it is provided in the "COPYING.CDDL" file included
+in the VirtualBox distribution, in which case the provisions of the
+CDDL are applicable instead of those of the GPL.
+
+You may elect to license modified versions of this file under the
+terms and conditions of either the GPL or the CDDL or both.
+
+SPDX-License-Identifier: GPL-3.0-only OR CDDL-1.0
+"""
+__version__ = "$Revision: 155244 $"
+
+# Standard python imports
+import sys
+import os
+from optparse import OptionParser;  # pylint: disable=deprecated-module
+
+# Add Test Manager's modules path
+g_ksTestManagerDir = os.path.dirname(os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
+sys.path.append(g_ksTestManagerDir)
+
+# Test Manager imports
+from testmanager.core.db        import TMDatabaseConnection
+from testmanager.core.testset   import TestSetLogic;
+
+
+class CloseOrphanedTestSets(object):
+    """
+    Finds and closes orphaned testsets.
+    """
+
+    def __init__(self):
+        """
+        Parse command line
+        """
+        oParser = OptionParser();
+        oParser.add_option('-d', '--just-do-it', dest='fJustDoIt', action='store_true',
+                           help='Do the database changes.');
+
+
+        (self.oConfig, _) = oParser.parse_args();
+
+
+    def main(self):
+        """ Main method. """
+        oDb = TMDatabaseConnection();
+
+        # Get a list of orphans.
+        oLogic = TestSetLogic(oDb);
+        aoOrphans = oLogic.fetchOrphaned();
+        if aoOrphans:
+            # Complete them.
+            if self.oConfig.fJustDoIt:
+                print('Completing %u test sets as abandoned:' % (len(aoOrphans),));
+                for oTestSet in aoOrphans:
+                    print('#%-7u: idTestBox=%-3u tsCreated=%s tsDone=%s'
+                          % (oTestSet.idTestSet, oTestSet.idTestBox, oTestSet.tsCreated, oTestSet.tsDone));
+                    oLogic.completeAsAbandoned(oTestSet.idTestSet);
+                print('Committing...');
+                oDb.commit();
+            else:
+                for oTestSet in aoOrphans:
+                    print('#%-7u: idTestBox=%-3u tsCreated=%s tsDone=%s'
+                          % (oTestSet.idTestSet, oTestSet.idTestBox, oTestSet.tsCreated, oTestSet.tsDone));
+                print('Not completing any testsets without seeing the --just-do-it option.');
+        else:
+            print('No orphaned test sets.\n');
+        return 0;
+
+
+if __name__ == '__main__':
+    sys.exit(CloseOrphanedTestSets().main())
+
-- 
cgit v1.2.3