BOINC / boinc

require_once("../inc/common_defs.inc");

class BoincBatch {

    static function lookup_id($id) {

        $db = BoincDb::get();

        return $db->lookup_id($id, 'batch', 'BoincBatch');

    }

    static function lookup_name($name) {

        $db = BoincDb::get();

        $name = BoincDb::escape_string($name);

        return $db->lookup('batch', 'BoincBatch', "name='$name'");

    }

    static function enum($clause) {

        $db = BoincDb::get();

        return $db->enum('batch', 'BoincBatch', $clause);

    }

    static function insert($clause) {

        $db = BoincDb::get();

        $ret = $db->insert('batch', $clause);

        if (!$ret) return $ret;

        return $db->insert_id();

    }

    function update($clause) {

        $db = BoincDb::get();

        return $db->update($this, 'batch', $clause);

    }

    static function update_aux($clause) {

        $db = BoincDb::get();

        return $db->update_aux('batch', $clause);

    }

    function get_cpu_time() {

        $db = BoincDb::get();

        $x = $db->get_double(

            "select sum(result.cpu_time) as total_cpu_time from workunit join result on workunit.id = result.workunitid where workunit.batch=$this->id",

            "total_cpu_time"

        );

        return $x;

    }

}

class BoincUserSubmit {

    static function enum($clause) {

    }

}

class BoincResult {

    static function count($clause) {

        $db = BoincDb::get();

        return $db->count('result', $clause);

    }

    static function enum($where_clause) {

        $db = BoincDb::get();

        return $db->enum('result', 'BoincResult', $where_clause);

    }

	static function enum_fields($fields, $where_clause, $order_clause) {

        $db = BoincDb::get();

		return $db->enum_fields('result', 'BoincResult', $fields, $where_clause, $order_clause);

	}

    function update($clause) {

        $db = BoincDb::get();

        return $db->update($this, 'result', $clause);

    }

    static function update_aux($clause) {

        $db = BoincDb::get();

        return $db->update_aux('result', $clause);

    }

    static function lookup_id($id) {

        $db = BoincDb::get();

        return $db->lookup_id($id, 'result', 'BoincResult');

    }

    static function lookup_name($name) {

        $db = BoincDb::get();

        $name = BoincDb::escape_string($name);

        return $db->lookup('result', 'BoincResult', "name='$name'");

    }

    function delete() {

        $db = BoincDb::get();

        return $db->delete($this, 'result');

    }

}

class BoincWorkunit {

    static function lookup_id($id) {