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

[ruben]

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

Added Files:
        20041222-1-delete-task-artifact.php 20041222-2.sql 
Removed Files:
        20041222-delete-task-artifact.php 20041222.sql 
Log Message:
Renamed migration scripts from 2004/12/22

--- NEW FILE: 20041222-1-delete-task-artifact.php ---
#! /usr/bin/php4 -f
<?php
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 {
        $tasks = array();
        
        for ($i=0;$i<db_numrows($res);$i++) {
                $data = &db_fetch_array($res);
                $tasks[] = $data['project_task_id'];
        }
        
        foreach ($tasks as $task_id) {
                $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 {
                                //echo "Task with id: $task_id successfully 
deleted\n";
                        }
                }
        }
        db_commit();
        echo "SUCCESS\n";
}
?>
--- NEW FILE: 20041222-2.sql ---
DELETE FROM project_status WHERE status_id='3';
DELETE FROM artifact_status WHERE id='3';

--- 20041222-delete-task-artifact.php DELETED ---

--- 20041222.sql DELETED ---