class.ilSearchCommandQueue.php

Go to the documentation of this file.

<?php

declare(strict_types=1);
class ilSearchCommandQueue
{
    private static ?self $instance = null;

    protected ilDBInterface $db;

    protected function __construct()
    {
        global $DIC;

        $this->db = $DIC->database();
    }

    public static function factory(): ilSearchCommandQueue
    {
        if (self::$instance instanceof ilSearchCommandQueue) {
            return self::$instance;
        }
        return self::$instance = new ilSearchCommandQueue();
    }

    public function store(ilSearchCommandQueueElement $element): void
    {
        $query = "SELECT obj_id, obj_type FROM search_command_queue " .
            "WHERE obj_id = " . $this->db->quote($element->getObjId(), 'integer') . " " .
            "AND obj_type = " . $this->db->quote($element->getObjType(), 'text');
        $res = $this->db->query($query);
        if ($res->numRows()) {
            $this->update($element);
        } else {
            $this->insert($element);
        }
    }

    protected function insert(ilSearchCommandQueueElement $element): void
    {
        $query = "INSERT INTO search_command_queue (obj_id,obj_type,sub_id,sub_type,command,last_update,finished) " .
            "VALUES( " .
            $this->db->quote($element->getObjId(), 'integer') . ", " .
            $this->db->quote($element->getObjType(), 'text') . ", " .
            "0, " .
            "''," .
            $this->db->quote($element->getCommand(), 'text') . ", " .
            $this->db->now() . ", " .
            "0 " .
            ")";
        $res = $this->db->manipulate($query);
    }

    protected function update(ilSearchCommandQueueElement $element): void
    {
        $query = "UPDATE search_command_queue " .
            "SET command = " . $this->db->quote($element->getCommand(), 'text') . ", " .
            "last_update = " . $this->db->now() . ", " .
            "finished = " . $this->db->quote(0, 'integer') . " " .
            "WHERE obj_id = " . $this->db->quote($element->getObjId(), 'integer') . " " .
            "AND obj_type = " . $this->db->quote($element->getObjType(), 'text');
        $res = $this->db->manipulate($query);
    }
}