[Gforge-commits] gforge/db 20041222-delete-task-artifact.php, 1.1, 1.2

[ruben]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/tmp/cvs-serv20179

Modified Files:
        20041222-delete-task-artifact.php 
Log Message:
Added db_begin/db_commit

Index: 20041222-delete-task-artifact.php
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20041222-delete-task-artifact.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 20041222-delete-task-artifact.php   22 Dec 2004 20:04:05 -0000      1.1
+++ 20041222-delete-task-artifact.php   22 Dec 2004 20:15:47 -0000      1.2
@@ -3,13 +3,14 @@
 require_once('www/include/squal_pre.php');
 require_once('common/pm/ProjectTask.class');
 
+db_begin();
+
 $res = db_query("SELECT project_task_id FROM project_task WHERE 
status_id='3'");
 
 if (!$res) {
        echo "FAIL\n";
        exit();
-} else
-{
+} else {
        $tasks = array();
        
        for ($i=0;$i<db_numrows($res);$i++) {
@@ -21,11 +22,13 @@
                $task = projecttask_get_object($task_id);
                if (!$task || !is_object($task)) {
                        // echo "Error instantiating Task object with id: 
$task_id\n";
+                       db_rollback();
                        echo "FAIL\n";
                        exit();
                } else {
                        if (!$task->delete()) {
                                // echo "Error deleting Task with id: 
$task_id\n";
+                               db_rollback();
                                echo "FAIL\n";
                                exit();
                        } else {
@@ -33,6 +36,7 @@
                        }
                }
        }
+       db_commit();
        echo "SUCCESS\n";
 }
 ?>
\ No newline at end of file